{"id":240,"date":"2020-03-27T13:08:11","date_gmt":"2020-03-27T05:08:11","guid":{"rendered":"https:\/\/blog.frost-s.tk\/?p=240"},"modified":"2020-03-27T13:17:01","modified_gmt":"2020-03-27T05:17:01","slug":"jdbctemplate%e5%9f%ba%e6%9c%ac%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"https:\/\/blog.frost-s.com\/index.php\/2020\/03\/27\/jdbctemplate%e5%9f%ba%e6%9c%ac%e4%bd%bf%e7%94%a8\/","title":{"rendered":"JdbcTemplate\u57fa\u672c\u4f7f\u7528"},"content":{"rendered":"\n<h3 class=\"has-custom-transform wp-block-heading\" style=\"text-transform:initial\">JdbcTemplate\u57fa\u672c\u4f7f\u7528<\/h3>\n\n\n\n<p><br> \u200b JDBC\u5df2\u7ecf\u80fd\u591f\u6ee1\u8db3\u5927\u90e8\u5206\u7528\u6237\u6700\u57fa\u672c\u7684\u9700\u6c42\uff0c\u4f46\u662f\u5728\u4f7f\u7528JDBC\u65f6\uff0c\u5fc5\u987b\u81ea\u5df1\u6765\u7ba1\u7406\u6570\u636e\u5e93\u8d44\u6e90\u5982\uff1a\u83b7\u53d6PreparedStatement\uff0c\u8bbe\u7f6eSQL\u8bed\u53e5\u53c2\u6570\uff0c\u5173\u95ed\u8fde\u63a5\u7b49\u6b65\u9aa4\u3002<\/p>\n\n\n\n<p>\u200b JdbcTemplate\u662fSpring\u5bf9JDBC\u7684\u5c01\u88c5\uff0c\u76ee\u7684\u662f\u4f7fJDBC\u66f4\u52a0\u6613\u4e8e\u4f7f\u7528\u3002JdbcTemplate\u662fSpring\u7684\u4e00\u90e8\u5206\u3002JdbcTemplate\u5904\u7406\u4e86\u8d44\u6e90\u7684\u5efa\u7acb\u548c\u91ca\u653e\u3002\u4ed6\u5e2e\u52a9\u6211\u4eec\u907f\u514d\u4e00\u4e9b\u5e38\u89c1\u7684\u9519\u8bef\uff0c\u6bd4\u5982\u5fd8\u4e86\u603b\u8981\u5173\u95ed\u8fde\u63a5\u3002\u4ed6\u8fd0\u884c\u6838\u5fc3\u7684JDBC\u5de5\u4f5c\u6d41\uff0c\u5982Statement\u7684\u5efa\u7acb\u548c\u6267\u884c\uff0c\u800c\u6211\u4eec\u53ea\u9700\u8981\u63d0\u4f9bSQL\u8bed\u53e5\u548c\u63d0\u53d6\u7ed3\u679c\u3002<\/p>\n\n\n\n<div class=\"wp-block-button aligncenter\" style=\"font-size:17px\"><a class=\"wp-block-button__link\" href=\"https:\/\/github.com\/spring-projects\/spring-framework\"> Spring\u6e90\u7801\u5730\u5740 <\/a><\/div>\n\n\n\n<p><br> \u5728JdbcTemplate\u4e2d\u6267\u884cSQL\u8bed\u53e5\u7684\u65b9\u6cd5\u5927\u81f4\u5206\u4e3a3\u7c7b\uff1a<\/p>\n\n\n\n<ol><li><code><strong>execute<\/strong><\/code>\uff1a\u53ef\u4ee5\u6267\u884c\u6240\u6709SQL\u8bed\u53e5\uff0c\u4e00\u822c\u7528\u4e8e\u6267\u884cDDL\u8bed\u53e5\u3002<\/li><li><code><strong>update<\/strong><\/code>\uff1a\u7528\u4e8e\u6267\u884c<code><strong>INSERT<\/strong><\/code>\u3001<code><strong>UPDATE<\/strong><\/code>\u3001<code><strong>DELETE<\/strong><\/code>\u7b49DML\u8bed\u53e5\u3002<\/li><li><code><strong>queryXxx<\/strong><\/code>\uff1a\u7528\u4e8eDQL\u6570\u636e\u67e5\u8be2\u8bed\u53e5\u3002<\/li><\/ol>\n\n\n\n<h4 class=\"has-custom-transform wp-block-heading\" style=\"text-transform:initial\">JdbcTemplate\u914d\u7f6e\u8fde\u63a5\u6c60<\/h4>\n\n\n\n<p style=\"font-family:Karla\" class=\"has-custom-font\"><code><strong>org.springframework.jdbc.core.JdbcTemplate<\/strong><\/code>\u7c7b\u65b9\u4fbf\u6267\u884cSQL\u8bed\u53e5<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">public JdbcTemplate(DataSource dataSource)&lt;br>\n\u521b\u5efaJdbcTemplate\u5bf9\u8c61\uff0c\u65b9\u4fbf\u6267\u884cSQL\u8bed\u53e5<\/pre>\n\n\n\n<h4 class=\"has-custom-transform wp-block-heading\" style=\"text-transform:initial\">JdbcTemplate\u4f7f\u7528\u6b65\u9aa4<\/h4>\n\n\n\n<ol><li> \u51c6\u5907DruidDataSource\u8fde\u63a5\u6c60<\/li><li> \u5bfc\u5165\u4f9d\u8d56\u7684jar\u5305<\/li><li> \u521b\u5efaJdbcTemplate\u5bf9\u8c61\uff0c\u4f20\u5165Druid\u8fde\u63a5\u6c60<\/li><li>\u8c03\u7528execute\u3001update\u3001queryXxx\u7b49\u65b9\u6cd5 <\/li><\/ol>\n\n\n\n<ul><li> spring-beans-4.1.2.RELEASE.jar<\/li><li> spring-core-4.1.2.RELEASE.jar<\/li><li> spring-jdbc-4.1.2.RELEASE.jar<\/li><li> spring-tx-4.1.2.RELEASE.jar<\/li><li> com.springsource.org.apache.commons.logging-1.1.1.jar<\/li><\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">public class Demo04 {\n\tpublic static void main(String[] args) {\n\t\t\/\/ \u521b\u5efa\u8868\u7684SQL\u8bed\u53e5\n\t\tString sql = \"CREATE TABLE product(\"\n\t\t\t\t+ \"pid INT PRIMARY KEY AUTO_INCREMENT,\"\n\t\t\t\t+ \"pname VARCHAR(20),\"\n\t\t\t\t+ \"price DOUBLE\"\n\t\t\t\t+ \");\";\n\t\t\t\t\n\t\tJdbcTemplate jdbcTemplate = new JdbcTemplate(DataSourceUtils.getDataSource());\n\t\tjdbcTemplate.execute(sql);\n\t}\n}\n<\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>JdbcTemplate\u57fa\u672c\u4f7f\u7528 \u200b JDBC\u5df2\u7ecf\u80fd\u591f\u6ee1\u8db3\u5927\u90e8\u5206\u7528\u6237\u6700\u57fa\u672c\u7684\u9700\u6c42\uff0c\u4f46\u662f\u5728\u4f7f\u7528JDBC\u65f6\uff0c\u5fc5\u987b\u81ea [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":246,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/posts\/240"}],"collection":[{"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/comments?post=240"}],"version-history":[{"count":5,"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/posts\/240\/revisions"}],"predecessor-version":[{"id":245,"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/posts\/240\/revisions\/245"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/media\/246"}],"wp:attachment":[{"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/media?parent=240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/categories?post=240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.frost-s.com\/index.php\/wp-json\/wp\/v2\/tags?post=240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}