{"id":796,"date":"2023-02-13T12:11:53","date_gmt":"2023-05-07T10:18:20","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/index.php\/2023\/11\/30\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/"},"modified":"2025-08-03T08:29:35","modified_gmt":"2025-08-03T00:29:35","slug":"java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/","title":{"rendered":"Java\u6570\u636e\u6e90\u914d\u7f6e\u5b8c\u5168\u6307\u5357\uff1aJDBC\u6570\u636e\u6e90\u5b9e\u4f8b\u4e0e\u6700\u4f73\u5b9e\u8df5"},"content":{"rendered":"<p>Java\u7684DataSource\u548cJDBC DataSource\u7f16\u7a0b\u662f\u6211\u4eec\u5728Java\u7a0b\u5e8f\u4e2d\u4e0e\u6570\u636e\u5e93\u4ea4\u4e92\u7684\u65b9\u5f0f\u3002\u6211\u4eec\u5df2\u7ecf\u77e5\u9053\u53ef\u4ee5\u4f7f\u7528JDBC DriverManager\u83b7\u53d6\u5173\u7cfb\u6570\u636e\u5e93\u8fde\u63a5\u3002\u4f46\u662f\u5f53\u6211\u4eec\u8fdb\u884c\u5b9e\u9645\u7f16\u7a0b\u65f6\uff0c\u6211\u4eec\u60f3\u8981\u7684\u4e0d\u4ec5\u662f\u8fde\u63a5\u3002<\/p>\n<h2>Java\u6570\u636e\u6e90<\/h2>\n<p>\u5927\u591a\u6570\u65f6\u5019\uff0c\u6211\u4eec\u5bfb\u6c42\u677e\u8026\u5408\u6765\u5b9e\u73b0\u8fde\u63a5\u6027\uff0c\u4ee5\u4fbf\u53ef\u4ee5\u8f7b\u677e\u5207\u6362\u6570\u636e\u5e93\u3001\u4e8b\u52a1\u7ba1\u7406\u548c\u5206\u5e03\u5f0f\u7cfb\u7edf\u652f\u6301\u7684\u8fde\u63a5\u6c60\u3002\u5982\u679c\u60a8\u5728\u5e94\u7528\u7a0b\u5e8f\u4e2d\u9700\u8981\u8fd9\u4e9b\u529f\u80fd\u4e4b\u4e00\uff0cJDBC DataSource \u662f\u9996\u9009\u65b9\u6cd5\u3002Java \u7684 DataSource \u63a5\u53e3\u4f4d\u4e8e javax.sql \u5305\u4e2d\uff0c\u5b83\u4ec5\u58f0\u660e\u4e86\u4e24\u4e2a\u91cd\u8f7d\u65b9\u6cd5\uff1agetConnection() \u548c getConnection(String str1, String str2)\u3002<\/p>\n<h2>JDBC\u6570\u636e\u6e90<\/h2>\n<p>\u4e0d\u540c\u7684\u6570\u636e\u5e93\u4f9b\u5e94\u5546\u6709\u8d23\u4efb\u63d0\u4f9b\u4e0d\u540c\u79cd\u7c7b\u7684DataSource\u63a5\u53e3\u7684\u5b9e\u73b0\u3002\u4f8b\u5982\uff0cMySQL JDBC\u9a71\u52a8\u7a0b\u5e8f\u4f7f\u7528com.mysql.jdbc.jdbc2.optional.MysqlDataSource\u7c7b\u63d0\u4f9bDataSource\u63a5\u53e3\u7684\u57fa\u672c\u5b9e\u73b0\uff0c\u800cOracle\u6570\u636e\u5e93\u9a71\u52a8\u7a0b\u5e8f\u4f7f\u7528oracle.jdbc.pool.OracleDataSource\u7c7b\u6765\u5b9e\u73b0\u3002\u8fd9\u4e9b\u5b9e\u73b0\u7c7b\u901a\u8fc7\u65b9\u6cd5\u6765\u63d0\u4f9b\u6570\u636e\u5e93\u670d\u52a1\u5668\u8be6\u7ec6\u4fe1\u606f\u548c\u7528\u6237\u51ed\u636e\u3002\u8fd9\u4e9bJDBC DataSource\u5b9e\u73b0\u7c7b\u63d0\u4f9b\u7684\u5176\u4ed6\u5e38\u89c1\u529f\u80fd\u5305\u62ec\uff1a<\/p>\n<ul class=\"post-ul\">\n<li>PreparedStatement\u7f13\u5b58\u4ee5\u5b9e\u73b0\u66f4\u5feb\u7684\u5904\u7406<\/li>\n<li>\u8fde\u63a5\u8d85\u65f6\u8bbe\u7f6e<\/li>\n<li>\u65e5\u5fd7\u529f\u80fd<\/li>\n<li>ResultSet\u6700\u5927\u5927\u5c0f\u9608\u503c<\/li>\n<\/ul>\n<h3>JDBC\u6570\u636e\u6e90\u793a\u4f8b<\/h3>\n<p>\u8ba9\u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u7b80\u5355\u7684JDBC\u6570\u636e\u6e90\u793a\u4f8b\u9879\u76ee\uff0c\u5b66\u4e60\u5982\u4f55\u4f7f\u7528MySQL\u548cOracle\u6570\u636e\u6e90\u57fa\u672c\u5b9e\u73b0\u7c7b\u6765\u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5\u3002\u6211\u4eec\u7684\u6700\u7ec8\u9879\u76ee\u5c06\u5982\u4e0b\u56fe\u6240\u793a\u3002<\/p>\n<h3>Java JDBC\u6570\u636e\u6e90 &#8211; \u6570\u636e\u5e93\u8bbe\u7f6e<\/h3>\n<p>\u5728\u6211\u4eec\u5f00\u59cb\u793a\u4f8b\u7a0b\u5e8f\u4e4b\u524d\uff0c\u6211\u4eec\u9700\u8981\u8fdb\u884c\u4e00\u4e9b\u6570\u636e\u5e93\u7684\u8bbe\u7f6e\uff0c\u5305\u62ec\u8868\u548c\u793a\u4f8b\u6570\u636e\u3002MySQL\u6216Oracle\u6570\u636e\u5e93\u7684\u5b89\u88c5\u4e0d\u5728\u672c\u6559\u7a0b\u7684\u8303\u56f4\u5185\uff0c\u6240\u4ee5\u6211\u4f1a\u76f4\u63a5\u8bbe\u7f6e\u8868\u683c\u5e76\u586b\u5145\u793a\u4f8b\u6570\u636e\u3002<\/p>\n<pre class=\"post-pre\"><code>-- \u521b\u5efa\u5458\u5de5\u8868\r\nCREATE TABLE `Employee` (\r\n  `empId` int(10) unsigned NOT NULL,\r\n  `name` varchar(10) DEFAULT NULL,\r\n  PRIMARY KEY (`empId`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n-- \u63d2\u5165\u4e00\u4e9b\u793a\u4f8b\u6570\u636e\r\nINSERT INTO `Employee` (`empId`, `name`)\r\nVALUES\r\n\t(1, 'Pankaj'),\r\n\t(2, 'David');\r\n\r\ncommit;\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>CREATE TABLE \"EMPLOYEE\"\r\n  (\r\n    \"EMPID\"   NUMBER NOT NULL ENABLE,\r\n    \"NAME\"    VARCHAR2(10 BYTE) DEFAULT NULL,\r\n    PRIMARY KEY (\"EMPID\")\r\n  );\r\n\r\n-- \u63d2\u5165\u6570\u636e\r\nInsert into EMPLOYEE (EMPID,NAME) values (10,'Pankaj');\r\nInsert into EMPLOYEE (EMPID,NAME) values (5,'Kumar');\r\nInsert into EMPLOYEE (EMPID,NAME) values (1,'Pankaj');\r\ncommit;\r\n<\/code><\/pre>\n<p>\u73b0\u5728\uff0c\u6211\u4eec\u7ee7\u7eed\u8fdb\u884c\u6211\u4eec\u7684Java\u7a0b\u5e8f\u3002\u4e3a\u4e86\u4f7f\u6570\u636e\u5e93\u914d\u7f6e\u677e\u6563\u8026\u5408\uff0c\u6211\u5c06\u4ece\u5c5e\u6027\u6587\u4ef6\u4e2d\u8bfb\u53d6\u5b83\u4eec\u3002db.properties\u6587\u4ef6\uff1a<\/p>\n<pre class=\"post-pre\"><code># MySQL\u6570\u636e\u5e93\u5c5e\u6027\r\nMYSQL_DB_DRIVER_CLASS=com.mysql.jdbc.Driver\r\nMYSQL_DB_URL=jdbc:mysql:\/\/localhost:3306\/UserDB\r\nMYSQL_DB_USERNAME=scdev\r\nMYSQL_DB_PASSWORD=scdev123\r\n\r\n# Oracle\u6570\u636e\u5e93\u5c5e\u6027\r\nORACLE_DB_DRIVER_CLASS=oracle.jdbc.driver.OracleDriver\r\nORACLE_DB_URL=jdbc:oracle:thin:@localhost:1521:orcl\r\nORACLE_DB_USERNAME=hr\r\nORACLE_DB_PASSWORD=oracle\r\n<\/code><\/pre>\n<p>\u8bf7\u786e\u4fdd\u4e0a\u8ff0\u914d\u7f6e\u4e0e\u60a8\u7684\u672c\u5730\u8bbe\u7f6e\u76f8\u5339\u914d\u3002\u8fd8\u8bf7\u786e\u4fdd\u60a8\u7684\u9879\u76ee\u6784\u5efa\u8def\u5f84\u4e2d\u5305\u542b\u4e86MySQL\u548cOracle DB JDBC jars\u6587\u4ef6\u3002<\/p>\n<h3>Java JDBC \u6570\u636e\u6e90 &#8211; MySQL\u3001Oracle \u793a\u4f8b<\/h3>\n<p>\u8fd9\u662f\u6587\u7ae0\u300aJava\u6570\u636e\u6e90\uff0cJDBC\u6570\u636e\u6e90\u793a\u4f8b\u300b\u7684\u7b2c2\u90e8\u5206\uff08\u51713\u90e8\u5206\uff09\u3002<\/p>\n<p>\u8ba9\u6211\u4eec\u7f16\u5199\u4e00\u4e2a\u5de5\u5382\u7c7b\uff0c\u7528\u6765\u83b7\u53d6MySQL\u6216Oracle\u7684\u6570\u636e\u6e90\u3002<\/p>\n<pre class=\"post-pre\"><code>package com.Olivia.jdbc.datasource;\r\n\r\nimport java.io.FileInputStream;\r\nimport java.io.IOException;\r\nimport java.sql.SQLException;\r\nimport java.util.Properties;\r\n\r\nimport javax.sql.DataSource;\r\n\r\nimport oracle.jdbc.pool.OracleDataSource;\r\n\r\nimport com.mysql.jdbc.jdbc2.optional.MysqlDataSource;\r\n\r\npublic class MyDataSourceFactory {\r\n\r\n\tpublic static DataSource getMySQLDataSource() {\r\n\t\tProperties props = new Properties();\r\n\t\tFileInputStream fis = null;\r\n\t\tMysqlDataSource mysqlDS = null;\r\n\t\ttry {\r\n\t\t\tfis = new FileInputStream(\"db.properties\");\r\n\t\t\tprops.load(fis);\r\n\t\t\tmysqlDS = new MysqlDataSource();\r\n\t\t\tmysqlDS.setURL(props.getProperty(\"MYSQL_DB_URL\"));\r\n\t\t\tmysqlDS.setUser(props.getProperty(\"MYSQL_DB_USERNAME\"));\r\n\t\t\tmysqlDS.setPassword(props.getProperty(\"MYSQL_DB_PASSWORD\"));\r\n\t\t} catch (IOException e) {\r\n\t\t\te.printStackTrace();\r\n\t\t}\r\n\t\treturn mysqlDS;\r\n\t}\r\n\t\r\n\tpublic static DataSource getOracleDataSource(){\r\n\t\tProperties props = new Properties();\r\n\t\tFileInputStream fis = null;\r\n\t\tOracleDataSource oracleDS = null;\r\n\t\ttry {\r\n\t\t\tfis = new FileInputStream(\"db.properties\");\r\n\t\t\tprops.load(fis);\r\n\t\t\toracleDS = new OracleDataSource();\r\n\t\t\toracleDS.setURL(props.getProperty(\"ORACLE_DB_URL\"));\r\n\t\t\toracleDS.setUser(props.getProperty(\"ORACLE_DB_USERNAME\"));\r\n\t\t\toracleDS.setPassword(props.getProperty(\"ORACLE_DB_PASSWORD\"));\r\n\t\t} catch (IOException e) {\r\n\t\t\te.printStackTrace();\r\n\t\t} catch (SQLException e) {\r\n\t\t\te.printStackTrace();\r\n\t\t}\r\n\t\treturn oracleDS;\r\n\t}\r\n\t\t\r\n}\r\n<\/code><\/pre>\n<p>\u8bf7\u6ce8\u610f\uff0cOracle\u548cMySQL\u7684\u6570\u636e\u6e90\u5b9e\u73b0\u7c7b\u975e\u5e38\u76f8\u4f3c\u3002\u8ba9\u6211\u4eec\u7f16\u5199\u4e00\u4e2a\u7b80\u5355\u7684\u6d4b\u8bd5\u7a0b\u5e8f\u6765\u4f7f\u7528\u8fd9\u4e9b\u65b9\u6cd5\u5e76\u8fd0\u884c\u4e00\u4e9b\u6d4b\u8bd5\u3002<\/p>\n<pre class=\"post-pre\"><code>package com.Olivia.jdbc.datasource;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\nimport java.sql.Statement;\r\n\r\nimport javax.sql.DataSource;\r\n\r\npublic class DataSourceTest {\r\n\r\n\tpublic static void main(String[] args) {\r\n\t\t\r\n\t\ttestDataSource(\"mysql\");\r\n\t\tSystem.out.println(\"**********\");\r\n\t\ttestDataSource(\"oracle\");\r\n\r\n\t}\r\n\r\n\tprivate static void testDataSource(String dbType) {\r\n\t\tDataSource ds = null;\r\n\t\tif(\"mysql\".equals(dbType)){\r\n\t\t\tds = MyDataSourceFactory.getMySQLDataSource();\r\n\t\t}else if(\"oracle\".equals(dbType)){\r\n\t\t\tds = MyDataSourceFactory.getOracleDataSource();\r\n\t\t}else{\r\n\t\t\tSystem.out.println(\"invalid db type\");\r\n\t\t\treturn;\r\n\t\t}\r\n\t\t\r\n\t\tConnection con = null;\r\n\t\tStatement stmt = null;\r\n\t\tResultSet rs = null;\r\n\t\ttry {\r\n\t\t\tcon = ds.getConnection();\r\n\t\t\tstmt = con.createStatement();\r\n\t\t\trs = stmt.executeQuery(\"select empid, name from Employee\");\r\n\t\t\twhile(rs.next()){\r\n\t\t\t\tSystem.out.println(\"Employee ID=\"+rs.getInt(\"empid\")+\", Name=\"+rs.getString(\"name\"));\r\n\t\t\t}\r\n\t\t} catch (SQLException e) {\r\n\t\t\te.printStackTrace();\r\n\t\t}finally{\r\n\t\t\t\ttry {\r\n\t\t\t\t\tif(rs != null) rs.close();\r\n\t\t\t\t\tif(stmt != null) stmt.close();\r\n\t\t\t\t\tif(con != null) con.close();\r\n\t\t\t\t} catch (SQLException e) {\r\n\t\t\t\t\te.printStackTrace();\r\n\t\t\t\t}\r\n\t\t}\r\n\t}\r\n\r\n}\r\n<\/code><\/pre>\n<p>\u8bf7\u6ce8\u610f\uff0c\u5ba2\u6237\u7aef\u7c7b\u5b8c\u5168\u72ec\u7acb\u4e8e\u4efb\u4f55\u7279\u5b9a\u6570\u636e\u5e93\u7c7b\u3002\u8fd9\u6709\u52a9\u4e8e\u6211\u4eec\u9690\u85cf\u5ba2\u6237\u7a0b\u5e8f\u7684\u5e95\u5c42\u5b9e\u73b0\u7ec6\u8282\uff0c\u5b9e\u73b0\u677e\u8026\u5408\u548c\u62bd\u8c61\u4f18\u52bf\u3002\u5f53\u6211\u4eec\u8fd0\u884c\u4e0a\u8ff0\u6d4b\u8bd5\u7a0b\u5e8f\u65f6\uff0c\u5c06\u83b7\u5f97\u4ee5\u4e0b\u8f93\u51fa\u3002<\/p>\n<pre class=\"post-pre\"><code>Employee ID=1, Name=Pankaj\r\nEmployee ID=2, Name=David\r\n**********\r\nEmployee ID=10, Name=Pankaj\r\nEmployee ID=5, Name=Kumar\r\nEmployee ID=1, Name=Pankaj\r\n<\/code><\/pre>\n<h3>Apache Commons DBCP\uff08\u6570\u636e\u5e93\u8fde\u63a5\u6c60\uff09\u793a\u4f8b<\/h3>\n<p>\u5982\u679c\u67e5\u770b\u4e0a\u9762\u7684Java\u6570\u636e\u6e90\u5de5\u5382\u7c7b\uff0c\u4f1a\u53d1\u73b0\u5176\u4e2d\u5b58\u5728\u4e24\u4e2a\u4e3b\u8981\u95ee\u9898\u3002<\/p>\n<ol>\n<li>\u521b\u5efaMySQL\u548cOracle\u6570\u636e\u6e90\u7684\u5de5\u5382\u7c7b\u65b9\u6cd5\u4e0e\u5b83\u4eec\u5404\u81ea\u7684\u9a71\u52a8\u7a0b\u5e8fAPI\u7d27\u5bc6\u8026\u5408\u3002\u5982\u679c\u672a\u6765\u9700\u8981\u79fb\u9664\u5bf9Oracle\u6570\u636e\u5e93\u7684\u652f\u6301\u6216\u8005\u60f3\u8981\u589e\u52a0\u5176\u4ed6\u6570\u636e\u5e93\u7684\u652f\u6301\uff0c\u5c31\u5fc5\u987b\u4fee\u6539\u4ee3\u7801\u3002<\/li>\n<li>\u83b7\u53d6MySQL\u548cOracle\u6570\u636e\u6e90\u7684\u5927\u90e8\u5206\u4ee3\u7801\u662f\u76f8\u4f3c\u7684\uff0c\u53ea\u6709\u4f7f\u7528\u7684\u5b9e\u73b0\u7c7b\u4e0d\u540c\u3002<\/li>\n<\/ol>\n<p>Apache Commons DBCP API\u901a\u8fc7\u63d0\u4f9bJava\u6570\u636e\u6e90\u5b9e\u73b0\u4f5c\u4e3a\u6211\u4eec\u7a0b\u5e8f\u4e0e\u4e0d\u540cJDBC\u9a71\u52a8\u7a0b\u5e8f\u4e4b\u95f4\u7684\u62bd\u8c61\u5c42\uff0c\u5e2e\u52a9\u6211\u4eec\u89e3\u51b3\u8fd9\u4e9b\u95ee\u9898\u3002Apache DBCP\u5e93\u4f9d\u8d56\u4e8eCommons Pool\u5e93\uff0c\u56e0\u6b64\u8bf7\u786e\u4fdd\u5b83\u4eec\u90fd\u5728\u6784\u5efa\u8def\u5f84\u4e2d\uff0c\u5982\u56fe\u6240\u793a\u3002\u4ee5\u4e0b\u662f\u4f7f\u7528BasicDataSource\u7684\u6570\u636e\u6e90\u5de5\u5382\u7c7b\uff0c\u5b83\u662f\u6570\u636e\u6e90\u7684\u7b80\u5355\u5b9e\u73b0\u3002<\/p>\n<pre class=\"post-pre\"><code>package com.Olivia.jdbc.datasource;\r\n\r\nimport java.io.FileInputStream;\r\nimport java.io.IOException;\r\nimport java.util.Properties;\r\n\r\nimport javax.sql.DataSource;\r\n\r\nimport org.apache.commons.dbcp.BasicDataSource;\r\n\r\npublic class DBCPDataSourceFactory {\r\n\r\n\tpublic static DataSource getDataSource(String dbType){\r\n\t\tProperties props = new Properties();\r\n\t\tFileInputStream fis = null;\r\n\t\tBasicDataSource ds = new BasicDataSource();\r\n\t\t\r\n\t\ttry {\r\n\t\t\tfis = new FileInputStream(\"db.properties\");\r\n\t\t\tprops.load(fis);\r\n\t\t}catch(IOException e){\r\n\t\t\te.printStackTrace();\r\n\t\t\treturn null;\r\n\t\t}\r\n\t\tif(\"mysql\".equals(dbType)){\r\n\t\t\tds.setDriverClassName(props.getProperty(\"MYSQL_DB_DRIVER_CLASS\"));\r\n            ds.setUrl(props.getProperty(\"MYSQL_DB_URL\"));\r\n            ds.setUsername(props.getProperty(\"MYSQL_DB_USERNAME\"));\r\n            ds.setPassword(props.getProperty(\"MYSQL_DB_PASSWORD\"));\r\n\t\t}else if(\"oracle\".equals(dbType)){\r\n\t\t\tds.setDriverClassName(props.getProperty(\"ORACLE_DB_DRIVER_CLASS\"));\r\n            ds.setUrl(props.getProperty(\"ORACLE_DB_URL\"));\r\n            ds.setUsername(props.getProperty(\"ORACLE_DB_USERNAME\"));\r\n            ds.setPassword(props.getProperty(\"ORACLE_DB_PASSWORD\"));\r\n\t\t}else{\r\n\t\t\treturn null;\r\n\t\t}\r\n\t\t\r\n\t\treturn ds;\r\n\t}\r\n}\r\n<\/code><\/pre>\n<p>\u6839\u636e\u7528\u6237\u7684\u8f93\u5165\uff0c\u7a0b\u5e8f\u4f1a\u521b\u5efaMySQL\u6216Oracle\u7684\u6570\u636e\u6e90\u3002\u5982\u679c\u5e94\u7528\u7a0b\u5e8f\u53ea\u652f\u6301\u4e00\u4e2a\u6570\u636e\u5e93\uff0c\u90a3\u4e48\u751a\u81f3\u4e0d\u9700\u8981\u8fd9\u4e9b\u903b\u8f91\u3002\u53ea\u9700\u66f4\u6539\u5c5e\u6027\uff0c\u5c31\u53ef\u4ee5\u5728\u4e0d\u540c\u7684\u6570\u636e\u5e93\u670d\u52a1\u5668\u4e4b\u95f4\u8fdb\u884c\u5207\u6362\u3002Apache DBCP\u63d0\u4f9b\u62bd\u8c61\u7684\u5173\u952e\u70b9\u662fsetDriverClassName()\u65b9\u6cd5\u3002\u4ee5\u4e0b\u662f\u4f7f\u7528\u4e0a\u8ff0\u5de5\u5382\u65b9\u6cd5\u83b7\u53d6\u4e0d\u540c\u7c7b\u578b\u8fde\u63a5\u7684\u5ba2\u6237\u7aef\u7a0b\u5e8f\u3002<\/p>\n<pre class=\"post-pre\"><code>package com.Olivia.jdbc.datasource;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\nimport java.sql.Statement;\r\n\r\nimport javax.sql.DataSource;\r\n\r\npublic class ApacheCommonsDBCPTest {\r\n\r\n\tpublic static void main(String[] args) {\r\n\t\ttestDBCPDataSource(\"mysql\");\r\n\t\tSystem.out.println(\"**********\");\r\n\t\ttestDBCPDataSource(\"oracle\");\r\n\t}\r\n\r\n\tprivate static void testDBCPDataSource(String dbType) {\r\n\t\tDataSource ds = DBCPDataSourceFactory.getDataSource(dbType);\r\n\t\t\r\n\t\tConnection con = null;\r\n\t\tStatement stmt = null;\r\n\t\tResultSet rs = null;\r\n\t\ttry {\r\n\t\t\tcon = ds.getConnection();\r\n\t\t\tstmt = con.createStatement();\r\n\t\t\trs = stmt.executeQuery(\"select empid, name from Employee\");\r\n\t\t\twhile(rs.next()){\r\n\t\t\t\tSystem.out.println(\"Employee ID=\"+rs.getInt(\"empid\")+\", Name=\"+rs.getString(\"name\"));\r\n\t\t\t}\r\n\t\t} catch (SQLException e) {\r\n\t\t\te.printStackTrace();\r\n\t\t}finally{\r\n\t\t\t\ttry {\r\n\t\t\t\t\tif(rs != null) rs.close();\r\n\t\t\t\t\tif(stmt != null) stmt.close();\r\n\t\t\t\t\tif(con != null) con.close();\r\n\t\t\t\t} catch (SQLException e) {\r\n\t\t\t\t\te.printStackTrace();\r\n\t\t\t\t}\r\n\t\t}\r\n\t}\r\n\r\n}\r\n<\/code><\/pre>\n<p>\u5f53\u8fd0\u884c\u4e0a\u8ff0\u7a0b\u5e8f\u65f6\uff0c\u8f93\u51fa\u5c06\u4e0e\u4e4b\u524d\u7684\u7a0b\u5e8f\u76f8\u540c\u3002\u5982\u679c\u67e5\u770bJava JDBC\u6570\u636e\u6e90\u548c\u4e0a\u8ff0\u7528\u6cd5\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528\u6b63\u5e38\u7684DriverManager\u6765\u5b8c\u6210\u3002Java\u6570\u636e\u6e90\u7684\u4e3b\u8981\u4f18\u70b9\u662f\u5728\u4e0a\u4e0b\u6587\u548cJNDI\u4e2d\u4f7f\u7528\u65f6\u3002\u901a\u8fc7\u7b80\u5355\u7684\u914d\u7f6e\uff0c\u6211\u4eec\u53ef\u4ee5\u521b\u5efa\u4e00\u4e2a\u7531\u5bb9\u5668\u672c\u8eab\u7ef4\u62a4\u7684\u6570\u636e\u5e93\u8fde\u63a5\u6c60\u3002\u5927\u591a\u6570Servlet\u5bb9\u5668\uff08\u5982Tomcat\u548cJBoss\uff09\u90fd\u63d0\u4f9b\u4e86\u81ea\u5df1\u7684Java\u6570\u636e\u6e90\u5b9e\u73b0\uff0c\u6211\u4eec\u53ea\u9700\u8981\u901a\u8fc7\u7b80\u5355\u7684\u57fa\u4e8eXML\u7684\u914d\u7f6e\u8fdb\u884c\u914d\u7f6e\uff0c\u7136\u540e\u4f7f\u7528JNDI\u4e0a\u4e0b\u6587\u67e5\u627e\u6765\u83b7\u53d6Java\u6570\u636e\u6e90\u5e76\u4e0e\u4e4b\u4ea4\u4e92\u3002\u8fd9\u6837\u53ef\u4ee5\u5c06\u8fde\u63a5\u6c60\u548c\u7ba1\u7406\u4ece\u6211\u4eec\u7684\u5e94\u7528\u7a0b\u5e8f\u7aef\u79fb\u5230\u670d\u52a1\u5668\u7aef\uff0c\u4ece\u800c\u4e3a\u6211\u4eec\u63d0\u4f9b\u66f4\u591a\u7684\u65f6\u95f4\u6765\u7f16\u5199\u5e94\u7528\u7a0b\u5e8f\u7684\u4e1a\u52a1\u903b\u8f91\u3002\u5728\u4e0b\u4e00\u4e2a\u6559\u7a0b\u4e2d\uff0c\u6211\u4eec\u5c06\u5b66\u4e60\u5982\u4f55\u5728Tomcat\u5bb9\u5668\u4e2d\u914d\u7f6e\u6570\u636e\u6e90\u5e76\u5728Web\u5e94\u7528\u7a0b\u5e8f\u4e2d\u4f7f\u7528\u5b83\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Java\u7684DataSource\u548cJDBC DataSource\u7f16\u7a0b\u662f\u6211\u4eec\u5728Java\u7a0b\u5e8f\u4e2d\u4e0e\u6570\u636e\u5e93\u4ea4\u4e92\u7684\u65b9\u5f0f\u3002\u6211 [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[189,232,936,545,2118],"class_list":{"0":"post-796","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-uncategorized","7":"tag-java","9":"tag-jdbc","10":"tag-545","11":"tag-2118"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Java\u6570\u636e\u6e90\u914d\u7f6e\u5b8c\u5168\u6307\u5357\uff1aJDBC\u6570\u636e\u6e90\u5b9e\u4f8b\u4e0e\u6700\u4f73\u5b9e\u8df5 - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5168\u9762\u89e3\u6790Java\u6570\u636e\u6e90\u6982\u5ff5\u4e0eJDBC\u6570\u636e\u6e90\u914d\u7f6e\u65b9\u6cd5\u3002\u901a\u8fc7\u5b9e\u4f8b\u6f14\u793a\u5982\u4f55\u5728Java\u5e94\u7528\u4e2d\u914d\u7f6e\u548c\u4f7f\u7528JDBC\u6570\u636e\u6e90\uff0c\u5305\u62ec\u57fa\u672c\u8fde\u63a5\u6c60\u8bbe\u7f6e\u3001\u53c2\u6570\u4f18\u5316\u53ca\u5e38\u89c1\u95ee\u9898\u89e3\u51b3\u65b9\u6848\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u5b66\u4e60\u6570\u636e\u5e93\u8fde\u63a5\u6280\u672f\uff0c\u63d0\u5347\u5e94\u7528\u6027\u80fd\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/java\u6570\u636e\u6e90\uff0cjdbc\u6570\u636e\u6e90\u793a\u4f8b\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Java\u6570\u636e\u6e90\u914d\u7f6e\u5b8c\u5168\u6307\u5357\uff1aJDBC\u6570\u636e\u6e90\u5b9e\u4f8b\u4e0e\u6700\u4f73\u5b9e\u8df5\" \/>\n<meta property=\"og:description\" content=\"\u5168\u9762\u89e3\u6790Java\u6570\u636e\u6e90\u6982\u5ff5\u4e0eJDBC\u6570\u636e\u6e90\u914d\u7f6e\u65b9\u6cd5\u3002\u901a\u8fc7\u5b9e\u4f8b\u6f14\u793a\u5982\u4f55\u5728Java\u5e94\u7528\u4e2d\u914d\u7f6e\u548c\u4f7f\u7528JDBC\u6570\u636e\u6e90\uff0c\u5305\u62ec\u57fa\u672c\u8fde\u63a5\u6c60\u8bbe\u7f6e\u3001\u53c2\u6570\u4f18\u5316\u53ca\u5e38\u89c1\u95ee\u9898\u89e3\u51b3\u65b9\u6848\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u5b66\u4e60\u6570\u636e\u5e93\u8fde\u63a5\u6280\u672f\uff0c\u63d0\u5347\u5e94\u7528\u6027\u80fd\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/java\u6570\u636e\u6e90\uff0cjdbc\u6570\u636e\u6e90\u793a\u4f8b\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-07T10:18:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-03T00:29:35+00:00\" \/>\n<meta name=\"author\" content=\"\u65b0, \u97f5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u65b0, \u97f5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/\",\"name\":\"Java\u6570\u636e\u6e90\u914d\u7f6e\u5b8c\u5168\u6307\u5357\uff1aJDBC\u6570\u636e\u6e90\u5b9e\u4f8b\u4e0e\u6700\u4f73\u5b9e\u8df5 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-05-07T10:18:20+00:00\",\"dateModified\":\"2025-08-03T00:29:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\"},\"description\":\"\u5168\u9762\u89e3\u6790Java\u6570\u636e\u6e90\u6982\u5ff5\u4e0eJDBC\u6570\u636e\u6e90\u914d\u7f6e\u65b9\u6cd5\u3002\u901a\u8fc7\u5b9e\u4f8b\u6f14\u793a\u5982\u4f55\u5728Java\u5e94\u7528\u4e2d\u914d\u7f6e\u548c\u4f7f\u7528JDBC\u6570\u636e\u6e90\uff0c\u5305\u62ec\u57fa\u672c\u8fde\u63a5\u6c60\u8bbe\u7f6e\u3001\u53c2\u6570\u4f18\u5316\u53ca\u5e38\u89c1\u95ee\u9898\u89e3\u51b3\u65b9\u6848\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u5b66\u4e60\u6570\u636e\u5e93\u8fde\u63a5\u6280\u672f\uff0c\u63d0\u5347\u5e94\u7528\u6027\u80fd\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java\u6570\u636e\u6e90\u914d\u7f6e\u5b8c\u5168\u6307\u5357\uff1aJDBC\u6570\u636e\u6e90\u5b9e\u4f8b\u4e0e\u6700\u4f73\u5b9e\u8df5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\",\"name\":\"\u65b0, \u97f5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"caption\":\"\u65b0, \u97f5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Java\u6570\u636e\u6e90\u914d\u7f6e\u5b8c\u5168\u6307\u5357\uff1aJDBC\u6570\u636e\u6e90\u5b9e\u4f8b\u4e0e\u6700\u4f73\u5b9e\u8df5 - Blog - Silicon Cloud","description":"\u5168\u9762\u89e3\u6790Java\u6570\u636e\u6e90\u6982\u5ff5\u4e0eJDBC\u6570\u636e\u6e90\u914d\u7f6e\u65b9\u6cd5\u3002\u901a\u8fc7\u5b9e\u4f8b\u6f14\u793a\u5982\u4f55\u5728Java\u5e94\u7528\u4e2d\u914d\u7f6e\u548c\u4f7f\u7528JDBC\u6570\u636e\u6e90\uff0c\u5305\u62ec\u57fa\u672c\u8fde\u63a5\u6c60\u8bbe\u7f6e\u3001\u53c2\u6570\u4f18\u5316\u53ca\u5e38\u89c1\u95ee\u9898\u89e3\u51b3\u65b9\u6848\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u5b66\u4e60\u6570\u636e\u5e93\u8fde\u63a5\u6280\u672f\uff0c\u63d0\u5347\u5e94\u7528\u6027\u80fd\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/java\u6570\u636e\u6e90\uff0cjdbc\u6570\u636e\u6e90\u793a\u4f8b\/","og_locale":"zh_CN","og_type":"article","og_title":"Java\u6570\u636e\u6e90\u914d\u7f6e\u5b8c\u5168\u6307\u5357\uff1aJDBC\u6570\u636e\u6e90\u5b9e\u4f8b\u4e0e\u6700\u4f73\u5b9e\u8df5","og_description":"\u5168\u9762\u89e3\u6790Java\u6570\u636e\u6e90\u6982\u5ff5\u4e0eJDBC\u6570\u636e\u6e90\u914d\u7f6e\u65b9\u6cd5\u3002\u901a\u8fc7\u5b9e\u4f8b\u6f14\u793a\u5982\u4f55\u5728Java\u5e94\u7528\u4e2d\u914d\u7f6e\u548c\u4f7f\u7528JDBC\u6570\u636e\u6e90\uff0c\u5305\u62ec\u57fa\u672c\u8fde\u63a5\u6c60\u8bbe\u7f6e\u3001\u53c2\u6570\u4f18\u5316\u53ca\u5e38\u89c1\u95ee\u9898\u89e3\u51b3\u65b9\u6848\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u5b66\u4e60\u6570\u636e\u5e93\u8fde\u63a5\u6280\u672f\uff0c\u63d0\u5347\u5e94\u7528\u6027\u80fd\u3002","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/java\u6570\u636e\u6e90\uff0cjdbc\u6570\u636e\u6e90\u793a\u4f8b\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-05-07T10:18:20+00:00","article_modified_time":"2025-08-03T00:29:35+00:00","author":"\u65b0, \u97f5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u65b0, \u97f5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/","name":"Java\u6570\u636e\u6e90\u914d\u7f6e\u5b8c\u5168\u6307\u5357\uff1aJDBC\u6570\u636e\u6e90\u5b9e\u4f8b\u4e0e\u6700\u4f73\u5b9e\u8df5 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-05-07T10:18:20+00:00","dateModified":"2025-08-03T00:29:35+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9"},"description":"\u5168\u9762\u89e3\u6790Java\u6570\u636e\u6e90\u6982\u5ff5\u4e0eJDBC\u6570\u636e\u6e90\u914d\u7f6e\u65b9\u6cd5\u3002\u901a\u8fc7\u5b9e\u4f8b\u6f14\u793a\u5982\u4f55\u5728Java\u5e94\u7528\u4e2d\u914d\u7f6e\u548c\u4f7f\u7528JDBC\u6570\u636e\u6e90\uff0c\u5305\u62ec\u57fa\u672c\u8fde\u63a5\u6c60\u8bbe\u7f6e\u3001\u53c2\u6570\u4f18\u5316\u53ca\u5e38\u89c1\u95ee\u9898\u89e3\u51b3\u65b9\u6848\u3002\u9002\u5408Java\u5f00\u53d1\u8005\u5b66\u4e60\u6570\u636e\u5e93\u8fde\u63a5\u6280\u672f\uff0c\u63d0\u5347\u5e94\u7528\u6027\u80fd\u3002","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"Java\u6570\u636e\u6e90\u914d\u7f6e\u5b8c\u5168\u6307\u5357\uff1aJDBC\u6570\u636e\u6e90\u5b9e\u4f8b\u4e0e\u6700\u4f73\u5b9e\u8df5"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9","name":"\u65b0, \u97f5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","caption":"\u65b0, \u97f5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/java%e6%95%b0%e6%8d%ae%e6%ba%90%ef%bc%8cjdbc%e6%95%b0%e6%8d%ae%e6%ba%90%e7%a4%ba%e4%be%8b\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/796","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=796"}],"version-history":[{"count":4,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/796\/revisions"}],"predecessor-version":[{"id":110697,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/796\/revisions\/110697"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}