{"id":36,"date":"2021-01-05T23:57:05","date_gmt":"2021-01-05T15:57:05","guid":{"rendered":"https:\/\/www.52dixiaowo.com\/java\/?p=36"},"modified":"2021-05-11T19:21:13","modified_gmt":"2021-05-11T11:21:13","slug":"jdbc-%e8%bf%9e%e6%8e%a5%e6%b1%a0","status":"publish","type":"post","link":"https:\/\/www.52dixiaowo.com\/java\/post-36.html","title":{"rendered":"JDBC \u8fde\u63a5\u6c60"},"content":{"rendered":"\n<h2>\u8fde\u63a5\u6c60\u57fa\u672c\u6982\u5ff5<\/h2>\n\n\n\n<p>\u5bb9\u5668\u521b\u5efa\u540e\uff0c\u521b\u5efa\u4e00\u4e2a\u8fde\u63a5\u6c60\uff0c\u521d\u59cb\u5316\u4e00\u4e9b\u8fde\u63a5\u5bf9\u8c61\uff0c\u4f7f\u7528\u65f6\u8c03\u7528\u5176\u4e2d\u7684\u8fde\u63a5\u5bf9\u8c61\uff0c\u7528\u5b8c\u5f52\u8fd8\u7ed9\u8fde\u63a5\u6c60\u3002\u8fd9\u6837\u80fd\u52a0\u5feb\u6570\u636e\u5e93\u8fde\u63a5\u901f\u5ea6\u3002<\/p>\n\n\n\n<h4>1.DataSource \u8868\u793a\u8fde\u63a5\u6c60\u5bf9\u8c61<\/h4>\n\n\n\n<p>\u5b83\u662f javax.sql \u5305\u4e0b\u7684\u4e00\u4e2a\u7c7b<\/p>\n\n\n\n<p>\u8fd9\u4e2a\u7c7b\u662f\u4e00\u4e2a\u63a5\u53e3\u7c7b<\/p>\n\n\n\n<p>\u4e00\u822c\u4e0d\u7531\u6211\u4eec\u81ea\u5df1\u5b9e\u73b0\uff0c\u800c\u662f\u6570\u636e\u5e93\u5382\u5546\u5b9e\u73b0\u8fde\u63a5\u6c60<\/p>\n\n\n\n<h4>2.\u8fde\u63a5\u6c60\u7684\u57fa\u672c\u4f7f\u7528\u65b9\u6cd5<\/h4>\n\n\n\n<p>\u83b7\u53d6\u8fde\u63a5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>getConnection();<\/code><\/pre>\n\n\n\n<p>\u5f52\u8fd8\u8fde\u63a5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Connection.clonse();<\/code><\/pre>\n\n\n\n<h2>C3P0\u8fde\u63a5\u6c60\u6280\u672f<\/h2>\n\n\n\n<p>1.\u5bfc\u5165 jar \u5305\uff0c\uff08\u70b9\u51fb<a href=\"https:\/\/pan.5252.online\/%E5%BC%80%E5%8F%91%E5%B7%A5%E5%85%B7\/JavaJar\/jdbc\/\" data-type=\"URL\" data-id=\"https:\/\/pan.5252.online\/%E5%BC%80%E5%8F%91%E5%B7%A5%E5%85%B7\/JavaJar\/jdbc\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u8fd9\u91cc<\/a>\u4e0b\u8f7d\uff09\uff08\u9700\u8981\u5bfc\u51652\u4e2a jar \u5305\uff09<\/p>\n\n\n\n<p>\uff08c3p0-0.9.5.2-sources.jar \uff0cmchange-commons-java-0.2.12.jar \uff09<\/p>\n\n\n\n<p>(\u6ce8\u610f\uff1a\u6570\u636e\u5e93\u8fde\u63a5\u6c60\uff0c\u4ecd\u9700\u8981\u5bfc\u5165\u9a71\u52a8 jar \u5305\uff09<\/p>\n\n\n\n<p>2.\u5b9a\u4e49\u914d\u7f6e\u6587\u4ef6\uff0c\u8fd9\u91cc\u6709\u4e00\u4e9b\u5f3a\u5236\u7684\u89c4\u5b9a<\/p>\n\n\n\n<ul><li>\u540d\u79f0\uff1ac3p0.properties \u6216\u8005 c3p0-config.xml<\/li><li>\u8def\u5f84\uff1a\u653e\u5728 src \u4e0b\u5373\u53ef\uff0c\u4f1a\u81ea\u52a8\u8bfb\u53d6<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;c3p0-config>\n  &lt;!-- \u4f7f\u7528\u9ed8\u8ba4\u7684\u914d\u7f6e\u8bfb\u53d6\u8fde\u63a5\u6c60\u5bf9\u8c61 -->\n  &lt;default-config>\n  \t&lt;!--  \u8fde\u63a5\u53c2\u6570 -->\n    &lt;property name=\"driverClass\">com.mysql.jdbc.Driver&lt;\/property>\n    &lt;property name=\"jdbcUrl\">jdbc:mysql:\/\/localhost:3306\/day25&lt;\/property>\n    &lt;property name=\"user\">root&lt;\/property>\n    &lt;property name=\"password\">root&lt;\/property>\n    \n    &lt;!-- \u8fde\u63a5\u6c60\u53c2\u6570\uff0c\u521d\u59cb\u5316\u6570\u91cf\uff0c\u6700\u5927\u6570\u91cf\uff0c\u8fde\u63a5\u5931\u8d25\u8d85\u65f6\u65f6\u95f4 -->\n    &lt;property name=\"initialPoolSize\">5&lt;\/property>\n    &lt;property name=\"maxPoolSize\">10&lt;\/property>\n    &lt;property name=\"checkoutTimeout\">3000&lt;\/property>\n  &lt;\/default-config>\n\n  &lt;named-config name=\"otherc3p0\"> \n    &lt;!--  \u8fde\u63a5\u53c2\u6570 -->\n    &lt;property name=\"driverClass\">com.mysql.jdbc.Driver&lt;\/property>\n    &lt;property name=\"jdbcUrl\">jdbc:mysql:\/\/localhost:3306\/day25&lt;\/property>\n    &lt;property name=\"user\">root&lt;\/property>\n    &lt;property name=\"password\">root&lt;\/property>\n    \n    &lt;!-- \u8fde\u63a5\u6c60\u53c2\u6570 -->\n    &lt;property name=\"initialPoolSize\">5&lt;\/property>\n    &lt;property name=\"maxPoolSize\">8&lt;\/property>\n    &lt;property name=\"checkoutTimeout\">1000&lt;\/property>\n  &lt;\/named-config>\n&lt;\/c3p0-config><\/code><\/pre>\n\n\n\n<p>3.\u521b\u5efa\u6838\u5fc3\u5bf9\u8c61\uff0c\u6570\u636e\u5e93\u8fde\u63a5\u6c60\u5bf9\u8c61 ComboPooledDataSource<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DataSource ds = new ComboPooledDataSource();<\/code><\/pre>\n\n\n\n<p>(\u5982\u679c\u9700\u8981\u6307\u5b9a\u540d\u79f0\u7684\u6570\u636e\u5e93\u8fde\u63a5\u6c60\u5bf9\u8c61\uff0c\u90a3\u4e48\u6307\u5b9a\u8fde\u63a5\u6c60\u914d\u7f6e\u7684 name \u5c5e\u6027\uff09<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DataSource ds = new ComboPooledDataSource(\"otherc3p0\");<\/code><\/pre>\n\n\n\n<p>4.\u83b7\u53d6\u8fde\u63a5\uff1agetConnection(); <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Connection conn = ds.getConnection();<\/code><\/pre>\n\n\n\n<h2>Druid \u8fde\u63a5\u6c60<\/h2>\n\n\n\n<p>1.\u5bfc\u5165 jar \u5305\uff0c\u70b9\u51fb\u8fd9\u91cc<a rel=\"noreferrer noopener\" href=\"https:\/\/pan.5252.online\/%E5%BC%80%E5%8F%91%E5%B7%A5%E5%85%B7\/JavaJar\/jdbc\/\" data-type=\"URL\" data-id=\"https:\/\/pan.5252.online\/%E5%BC%80%E5%8F%91%E5%B7%A5%E5%85%B7\/JavaJar\/jdbc\/\" target=\"_blank\">\u4e0b\u8f7d<\/a>\uff08\u540c\u65f6\u4e0d\u8981\u5fd8\u8bb0\u5bfc\u5165 \u9a71\u52a8 jar \u5305\uff09<\/p>\n\n\n\n<p>maven\u5bfc\u5165\u5982\u4e0b\u5750\u6807<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;dependency>\n      &lt;groupId>com.alibaba&lt;\/groupId>\n      &lt;artifactId>druid&lt;\/artifactId>\n      &lt;version>1.1.6&lt;\/version>\n    &lt;\/dependency><\/code><\/pre>\n\n\n\n<p>2.\u5b9a\u4e49\u914d\u7f6e\u6587\u4ef6<\/p>\n\n\n\n<ul><li>\u5fc5\u987b\u662f properties \u7c7b\u578b\u7684\u6587\u4ef6<\/li><li>\u540d\u79f0\u4efb\u610f\uff0c\u53ef\u4ee5\u653e\u7f6e\u5728\u4efb\u610f\u5730\u65b9\uff08\u5047\u8bbe\u4e3a druid.properties)<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>driverClassName=com.mysql.jdbc.Driver\nurl=jdbc:mysql:\/\/127.0.0.1:3306\/db3\nusername=root\npassword=root\ninitialSize=5\nmaxActive=10\nmaxWait=3000<\/code><\/pre>\n\n\n\n<p>3.\u52a0\u8f7d\u914d\u7f6e\u6587\u4ef6\uff08\u5047\u8bbe\u5f53\u524d\u7c7b\u540d\u4e3a DruidDemo\uff09<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Properties pro = new Properties();\nInputStream is = DruidDemo.class.getClassLoader().getResourceAsStream(\"druid.properties\");\npro.load(is);<\/code><\/pre>\n\n\n\n<p>4.\u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5\u6c60\u5bf9\u8c61\uff0c\u901a\u8fc7\u5de5\u5382\u7c7b DruidDataSourceFactory \u83b7\u53d6<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DataSource ds = DruidDataSourceFactory.createDataSource(pro);<\/code><\/pre>\n\n\n\n<p>5.\u83b7\u53d6\u8fde\u63a5\u6c60\u5bf9\u8c61\uff0cgetConnection();<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Connection conn = ds.getConnection();<\/code><\/pre>\n\n\n\n<h2>Druid\u8fde\u63a5\u6c60\u5de5\u5177\u7c7b<\/h2>\n\n\n\n<p>1.\u5b9a\u4e49\u914d\u7f6e\u6587\u4ef6\uff0c\u548c\u4e0a\u9762\u4e00\u6837\u7684\u64cd\u4f5c\uff08\u8fd9\u91cc\u5047\u8bbe\u4e3a druid.properties\uff09<\/p>\n\n\n\n<p>2.\u5b9a\u4e49\u4e00\u4e2a\u7c7b JDBCUtils<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import com.alibaba.druid.pool.DruidDataSourceFactory;\n\nimport javax.sql.DataSource;\nimport java.io.IOException;\nimport java.sql.Connection;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\nimport java.sql.Statement;\nimport java.util.Properties;\n\n\/**\n * Druid\u8fde\u63a5\u6c60\u7684\u5de5\u5177\u7c7b\n *\/\npublic class JDBCUtils {\n\n    \/\/\u5b9a\u4e49\u6210\u5458\u53d8\u91cf DataSource\n    private static DataSource ds ;\n\n    static{\n        try {\n            \/\/1.\u52a0\u8f7d\u914d\u7f6e\u6587\u4ef6\n            Properties pro = new Properties();\n            pro.load(JDBCUtils.class.getClassLoader().getResourceAsStream(\"druid.properties\"));\n            \/\/2.\u83b7\u53d6DataSource\n            ds = DruidDataSourceFactory.createDataSource(pro);\n        } catch (IOException e) {\n            e.printStackTrace();\n        } catch (Exception e) {\n            e.printStackTrace();\n        }\n    }\n\n    \/**\n     * \u83b7\u53d6\u8fde\u63a5\u6c60\u65b9\u6cd5\n     *\/\n\n    public static DataSource getDataSource(){\n        return  ds;\n    }\n    \n    \/**\n     * \u83b7\u53d6\u8fde\u63a5\u65b9\u6cd5\n     *\/\n    public static Connection getConnection() throws SQLException {\n        return ds.getConnection();\n    }\n\n    \/\/\u5f52\u8fd8\u8fde\u63a5\uff082\u53c2\u6570\uff09\n    public static void close(Statement stmt,Connection conn){\n    \t\n       close(null,stmt,conn);\n    }\n\n\n    \/\/\u5f52\u8fd8\u8fde\u63a5\uff083\u53c2\u6570\uff09\n    public static void close(ResultSet rs , Statement stmt, Connection conn){\n\n        if(rs != null){\n            try {\n                rs.close();\n            } catch (SQLException e) {\n                e.printStackTrace();\n            }\n        }\n\n        if(stmt != null){\n            try {\n                stmt.close();\n            } catch (SQLException e) {\n                e.printStackTrace();\n            }\n        }\n\n        if(conn != null){\n            try {\n                conn.close();\n            } catch (SQLException e) {\n                e.printStackTrace();\n            }\n        }\n    }\n}\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u8fde\u63a5\u6c60\u57fa\u672c\u6982\u5ff5 \u5bb9\u5668\u521b\u5efa\u540e\uff0c\u521b\u5efa\u4e00\u4e2a\u8fde\u63a5\u6c60\uff0c\u521d\u59cb\u5316\u4e00\u4e9b\u8fde\u63a5\u5bf9\u8c61\uff0c\u4f7f\u7528\u65f6\u8c03\u7528\u5176\u4e2d\u7684\u8fde\u63a5\u5bf9\u8c61\uff0c\u7528\u5b8c\u5f52\u8fd8\u7ed9\u8fde\u63a5\u6c60\u3002\u8fd9&hellip; <a href=\"https:\/\/www.52dixiaowo.com\/java\/post-36.html\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">JDBC \u8fde\u63a5\u6c60<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/posts\/36"}],"collection":[{"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/comments?post=36"}],"version-history":[{"count":5,"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/posts\/36\/revisions"}],"predecessor-version":[{"id":1347,"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/posts\/36\/revisions\/1347"}],"wp:attachment":[{"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/media?parent=36"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/categories?post=36"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/java\/wp-json\/wp\/v2\/tags?post=36"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}