{"id":67843,"date":"2026-01-29T08:57:05","date_gmt":"2026-01-29T00:57:05","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/67843.html"},"modified":"2026-01-29T08:57:05","modified_gmt":"2026-01-29T00:57:05","slug":"jdbc-%e5%85%a8%e8%a7%a3%e6%9e%90%ef%bc%9a-%e4%bb%8e%e5%85%a5%e9%97%a8%e5%88%b0%e7%b2%be%e9%80%9a","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/67843.html","title":{"rendered":"JDBC \u5168\u89e3\u6790\uff1a \u4ece\u5165\u95e8\u5230\u7cbe\u901a"},"content":{"rendered":"

\u5f15\u8a00：\u5b66\u4e60\u76ee\u6807<\/h3>\n\n\u77e5\u8bc6\u70b9\u8981\u6c42<\/tr>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
JDBC \u6982\u8ff0<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
\u4f7f\u7528 JDBC \u5b8c\u6210\u6dfb\u52a0\u64cd\u4f5c<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
\u4f7f\u7528 JDBC \u5b8c\u6210\u66f4\u65b0\u548c\u5220\u9664<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
DBUtils \u7684\u7b80\u5355\u5c01\u88c5<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
\u4f7f\u7528 JDBC \u5b8c\u6210\u67e5\u8be2<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
\u4f7f\u7528 JDBC \u5b8c\u6210\u5206\u9875\u67e5\u8be2<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
\u5e38\u7528\u63a5\u53e3\u8be6\u89e3<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
JDBC \u6279\u5904\u7406<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
SQL \u6ce8\u5165\u95ee\u9898<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
\u4e8b\u52a1\u5904\u7406\u89e3\u51b3\u8f6c\u8d26\u95ee\u9898<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
\u8fde\u63a5\u6c60<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
\u4f7f\u7528\u53cd\u5c04\u5bf9 DBUtils \u518d\u6b21\u7684\u5c01\u88c5<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n
BaseDAO \u7684\u5c01\u88c5<\/td>\n\u638c\u63e1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e00\u3001JDBC \u6982\u8ff0<\/h3>\n

1.1 \u4e3a\u4ec0\u4e48\u8981\u5b66\u4e60 JDBC？<\/h4>\n

\u5982\u7528\u6237\u63d0\u4ea4\u8868\u5355\u65f6，JDBC \u80fd\u81ea\u52a8\u5c06\u6570\u636e\u5b58\u5165\u6570\u636e\u5e93，\u800c Navicat \u53ea\u80fd\u6bcf\u6b21\u624b\u52a8\u64cd\u4f5c，\u65e0\u6cd5\u5bf9\u63a5\u7a0b\u5e8f\u5b9e\u73b0\u81ea\u52a8\u5316\u64cd\u4f5c\u3002<\/p>\n

JDBC \u7684\u6838\u5fc3\u4ef7\u503c\u5728\u4e8e\u5b9e\u73b0 Java \u7a0b\u5e8f\u4e0e\u6570\u636e\u5e93\u7684\u65e0\u7f1d\u5bf9\u63a5，\u652f\u6301\u81ea\u52a8\u5316\u6570\u636e\u5904\u7406\u3002<\/p>\n

1.2 \u4ec0\u4e48\u662f JDBC？<\/h4>\n

JDBC（Java DataBase Connectivity）\u5373 Java \u6570\u636e\u5e93\u8fde\u63a5，\u662f\u7528 Java \u8bed\u8a00\u64cd\u4f5c\u6570\u636e\u5e93\u7684\u89c4\u8303\u3002\u4f20\u7edf\u64cd\u4f5c\u6570\u636e\u5e93\u9700\u5728 Navicat \u7b49\u5de5\u5177\u4e2d\u6267\u884c SQL \u8bed\u53e5，\u800c JDBC \u5141\u8bb8\u901a\u8fc7 Java \u4ee3\u7801\u5411\u6570\u636e\u5e93\u53d1\u9001 SQL \u6307\u4ee4，\u5b9e\u73b0\u7a0b\u5e8f\u9a71\u52a8\u7684\u6570\u636e\u4ea4\u4e92\u3002<\/p>\n

\"\"<\/p>\n

1.3 JDBC \u7684\u539f\u7406<\/h4>\n
    \n
  • SUN \u516c\u53f8\u63d0\u4f9b JDBC \u6838\u5fc3\u63a5\u53e3（\u89c4\u8303），\u5b9a\u4e49\u6570\u636e\u5e93\u8bbf\u95ee\u6807\u51c6\u3002<\/li>\n
  • \u5404\u6570\u636e\u5e93\u5382\u5546（\u5982 MySQL\u3001Oracle）\u9075\u5faa\u8be5\u89c4\u8303，\u63d0\u4f9b\u5b9e\u73b0\u63a5\u53e3\u7684\u9a71\u52a8\u7a0b\u5e8f（Driver）\u3002<\/li>\n
  • Java \u7a0b\u5e8f\u901a\u8fc7 JDBC \u63a5\u53e3\u8c03\u7528\u5382\u5546\u9a71\u52a8，\u95f4\u63a5\u64cd\u4f5c\u6570\u636e\u5e93，\u5b9e\u73b0\u8de8\u6570\u636e\u5e93\u517c\u5bb9\u3002<\/li>\n
  • \u7b2c\u4e09\u65b9\u4e5f\u53ef\u80fd\u63d0\u4f9b\u975e\u5f00\u6e90\u514d\u8d39\u7684\u6570\u636e\u5e93\u9a71\u52a8\u3002<\/li>\n<\/ul>\n

    \"\"<\/p>\n

    1.4 JDBC \u7684 API<\/h4>\n

    JDBC \u6838\u5fc3\u529f\u80fd\u53ef\u6982\u62ec\u4e3a\u4e09\u70b9：\u4e0e\u6570\u636e\u5e93\u5efa\u7acb\u8fde\u63a5\u3001\u53d1\u9001 SQL \u8bed\u53e5\u3001\u5904\u7406\u67e5\u8be2\u7ed3\u679c\u3002\u6838\u5fc3 API \u7ec4\u4ef6\u5982\u4e0b：<\/p>\n

    \"\"<\/p>\n

      \n
    • DriverManager：\u7ba1\u7406 JDBC \u9a71\u52a8，\u8d1f\u8d23\u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5\u3002<\/li>\n
    • Connection：\u4ee3\u8868\u6570\u636e\u5e93\u7269\u7406\u8fde\u63a5，\u8d1f\u8d23\u6570\u636e\u4f20\u8f93\u3002<\/li>\n
    • Statement：\u7531 Connection \u521b\u5efa，\u7528\u4e8e\u53d1\u9001\u6267\u884c SQL \u8bed\u53e5\u3002<\/li>\n
    • ResultSet：\u4fdd\u5b58 Statement \u6267\u884c\u67e5\u8be2\u540e\u7684\u7ed3\u679c\u96c6\u3002<\/li>\n<\/ul>\n

      \u4e8c\u3001\u5e38\u7528\u63a5\u53e3\u8be6\u89e3<\/h3>\n

      2.1 DriverManager<\/h4>\n

      \u7528\u4e8e\u7ba1\u7406 JDBC \u9a71\u52a8\u7684\u670d\u52a1\u7c7b，\u6838\u5fc3\u65b9\u6cd5：<\/p>\n

      java<\/p>\n

      public static Connection getConnection(String url, String user, String password) throws SQLException<\/p>\n

      \u529f\u80fd：\u83b7\u53d6\u6307\u5b9a URL \u5bf9\u5e94\u6570\u636e\u5e93\u7684\u8fde\u63a5，\u53c2\u6570\u5206\u522b\u4e3a\u6570\u636e\u5e93\u5730\u5740\u3001\u7528\u6237\u540d\u3001\u5bc6\u7801\u3002<\/p>\n

      2.2 Connection<\/h4>\n

      \u6570\u636e\u5e93\u8fde\u63a5\u5bf9\u8c61，\u6bcf\u4e2a Connection \u5bf9\u5e94\u4e00\u4e2a\u7269\u7406\u8fde\u63a5\u4f1a\u8bdd\u3002\u5e38\u7528\u65b9\u6cd5：<\/p>\n

        \n
      • \u521b\u5efa SQL \u6267\u884c\u5bf9\u8c61：\n
          \n
        • Statement createStatement()：\u521b\u5efa\u666e\u901a Statement \u5bf9\u8c61\u3002<\/li>\n
        • PreparedStatement prepareStatement(String sql)：\u521b\u5efa\u9884\u7f16\u8bd1 Statement \u5bf9\u8c61（\u9632 SQL \u6ce8\u5165）\u3002<\/li>\n
        • CallableStatement prepareCall(String sql)：\u521b\u5efa\u8c03\u7528\u5b58\u50a8\u8fc7\u7a0b\u7684 Statement \u5bf9\u8c61\u3002<\/li>\n<\/ul>\n<\/li>\n
        • \u4e8b\u52a1\u63a7\u5236\u65b9\u6cd5：\n
            \n
          • setAutoCommit(boolean autoCommit)：\u5173\u95ed\u81ea\u52a8\u63d0\u4ea4（\u5f00\u542f\u4e8b\u52a1）\u3002<\/li>\n
          • commit()：\u63d0\u4ea4\u4e8b\u52a1\u3002<\/li>\n
          • rollback()：\u56de\u6eda\u4e8b\u52a1\u3002<\/li>\n
          • setSavepoint()：\u521b\u5efa\u4e8b\u52a1\u4fdd\u5b58\u70b9\u3002<\/li>\n
          • setTransactionIsolation(int level)：\u8bbe\u7f6e\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

            2.3 Statement<\/h4>\n

            \u6267\u884c SQL \u8bed\u53e5\u7684\u5de5\u5177\u63a5\u53e3，\u652f\u6301 DDL\u3001DML\u3001\u67e5\u8be2\u8bed\u53e5，\u5e38\u7528\u65b9\u6cd5：<\/p>\n

              \n
            • ResultSet executeQuery(String sql)：\u6267\u884c\u67e5\u8be2\u8bed\u53e5，\u8fd4\u56de\u7ed3\u679c\u96c6（\u4ec5\u652f\u6301 SELECT）\u3002<\/li>\n
            • int executeUpdate(String sql)：\u6267\u884c DML（INSERT\/UPDATE\/DELETE）\u8fd4\u56de\u53d7\u5f71\u54cd\u884c\u6570；\u6267\u884c DDL \u8fd4\u56de 0\u3002<\/li>\n
            • boolean execute(String sql)：\u6267\u884c\u4efb\u610f SQL，\u8fd4\u56de true \u8868\u793a\u7ed3\u679c\u4e3a ResultSet，false \u8868\u793a\u53d7\u5f71\u54cd\u884c\u6570\u6216\u65e0\u7ed3\u679c\u3002<\/li>\n<\/ul>\n

              2.4 PreparedStatement<\/h4>\n

              Statement \u7684\u5b50\u63a5\u53e3，\u652f\u6301\u9884\u7f16\u8bd1 SQL（\u542b\u53c2\u6570\u5360\u4f4d\u7b26?），\u4f18\u52bf：<\/p>\n

                \n
              • \u9884\u7f16\u8bd1\u540e\u91cd\u590d\u6267\u884c\u65e0\u9700\u91cd\u65b0\u7f16\u8bd1，\u63d0\u5347\u6548\u7387\u3002<\/li>\n
              • \u901a\u8fc7\u53c2\u6570\u7ed1\u5b9a\u907f\u514d SQL \u6ce8\u5165，\u66f4\u5b89\u5168\u3002\u6838\u5fc3\u65b9\u6cd5：<\/li>\n<\/ul>\n

                java<\/p>\n

                void setXxx(int parameterIndex, Xxx value)<\/p>\n

                \u6839\u636e\u53c2\u6570\u7c7b\u578b（\u5982 String\u3001int）\u9009\u62e9\u5bf9\u5e94\u65b9\u6cd5，\u6309\u7d22\u5f15\u4e3a SQL \u5360\u4f4d\u7b26\u8d4b\u503c\u3002<\/p>\n

                2.5 ResultSet<\/h4>\n

                \u67e5\u8be2\u7ed3\u679c\u96c6\u5bf9\u8c61，\u901a\u8fc7\u6e38\u6807（\u6307\u9488）\u8bbf\u95ee\u6570\u636e，\u5e38\u7528\u65b9\u6cd5：<\/p>\n

                  \n
                • \u6e38\u6807\u79fb\u52a8：\n
                    \n
                  • boolean next()：\u6e38\u6807\u5411\u4e0b\u79fb\u52a8\u4e00\u884c，\u8fd4\u56de\u662f\u5426\u6307\u5411\u6709\u6548\u6570\u636e\u3002<\/li>\n
                  • boolean absolute(int row)：\u79fb\u52a8\u5230\u6307\u5b9a\u884c（\u8d1f\u6570\u8868\u793a\u5012\u6570）\u3002<\/li>\n
                  • boolean last()：\u79fb\u52a8\u5230\u6700\u540e\u4e00\u884c\u3002<\/li>\n<\/ul>\n<\/li>\n
                  • \u6570\u636e\u83b7\u53d6：\n
                      \n
                    • getInt(int colIndex)\/getInt(String colLabel)：\u901a\u8fc7\u5217\u7d22\u5f15\u6216\u5217\u540d\u83b7\u53d6 int \u7c7b\u578b\u503c\u3002<\/li>\n
                    • getString(int colIndex)\/getString(String colLabel)：\u83b7\u53d6\u5b57\u7b26\u4e32\u7c7b\u578b\u503c\u3002<\/li>\n
                    • getObject(String colLabel)：\u83b7\u53d6\u4efb\u610f\u7c7b\u578b\u503c\u3002<\/li>\n<\/ul>\n<\/li>\n
                    • \u8d44\u6e90\u91ca\u653e：close()：\u5173\u95ed\u7ed3\u679c\u96c6，\u91ca\u653e\u8d44\u6e90\u3002<\/li>\n<\/ul>\n

                      \u4e09\u3001JDBC \u64cd\u4f5c\u6570\u636e\u5e93\u7684\u6b65\u9aa4<\/h3>\n

                      3.1 \u52a0\u8f7d\u9a71\u52a8<\/h4>\n

                      \u901a\u8fc7Class.forName()\u52a0\u8f7d\u9a71\u52a8\u7c7b，\u5e38\u7528\u6570\u636e\u5e93\u9a71\u52a8\u52a0\u8f7d\u8bed\u53e5：<\/p>\n

                      java<\/p>\n

                      \/\/ Oracle
                      \nClass.forName("oracle.JDBC.driver.OracleDriver");
                      \n\/\/ SQL Server
                      \nClass.forName("com.microsoft.JDBC.sqlserver.SQLServerDriver");
                      \n\/\/ DB2
                      \nClass.forName("com.ibm.db2.JDBC.app.DB2Driver");
                      \n\/\/ MySQL 5
                      \nClass.forName("com.mysql.jdbc.Driver");
                      \n\/\/ MySQL 8
                      \nClass.forName("com.mysql.cj.jdbc.Driver");<\/p>\n

                      3.2 \u521b\u5efa\u6570\u636e\u5e93\u8fde\u63a5<\/h4>\n

                      \u8c03\u7528DriverManager.getConnection()\u83b7\u53d6\u8fde\u63a5：<\/p>\n

                      java<\/p>\n

                      Connection conn = null;
                      \nString url = "jdbc:mysql:\/\/localhost:3306\/jdbc_db?useUnicode=true&useSSL=false&characterEncoding=UTF8";
                      \nString user = "root";
                      \nString password = "123456";
                      \nconn = DriverManager.getConnection(url, user, password);<\/p>\n

                      3.3 \u521b\u5efa Statement \u5e76\u53d1\u9001\u547d\u4ee4<\/h4>\n

                      \u6839\u636e\u9700\u6c42\u521b\u5efa Statement\/PreparedStatement \u5bf9\u8c61，\u6267\u884c SQL：<\/p>\n

                      java<\/p>\n

                      \/\/ \u666e\u901aStatement
                      \nStatement stmt = conn.createStatement();
                      \nint affectedRows = stmt.executeUpdate("INSERT INTO student VALUES(1,'\u5c0f\u521a',32,'\u7537','\u6b66\u6c49')");<\/p>\n

                      \/\/ \u9884\u7f16\u8bd1PreparedStatement
                      \nPreparedStatement pstmt = conn.prepareStatement("INSERT INTO student VALUES(?, ?, ?, ?, ?)");
                      \npstmt.setInt(1, 2);
                      \npstmt.setString(2, "\u5c0f\u660e");
                      \npstmt.setInt(3, 23);
                      \npstmt.setString(4, "\u5973");
                      \npstmt.setString(5, "\u6b66\u6c49");
                      \npstmt.executeUpdate();<\/p>\n

                      3.4 \u5904\u7406 ResultSet \u7ed3\u679c<\/h4>\n

                      \u901a\u8fc7\u5faa\u73af\u904d\u5386\u7ed3\u679c\u96c6，\u63d0\u53d6\u6570\u636e：<\/p>\n

                      java<\/p>\n

                      ResultSet rs = stmt.executeQuery("SELECT * FROM student");
                      \nwhile (rs.next()) {
                      \n int id = rs.getInt(1); \/\/ \u5217\u7d22\u5f15（\u4ece1\u5f00\u59cb）
                      \n String name = rs.getString("name"); \/\/ \u5217\u540d
                      \n int age = rs.getInt("age");
                      \n System.out.println(id + " " + name + " " + age);
                      \n}<\/p>\n

                      3.5 \u5173\u95ed\u6570\u636e\u5e93\u8d44\u6e90<\/h4>\n

                      \u5fc5\u987b\u6309\u300cResultSet \u2192 Statement \u2192 Connection\u300d\u7684\u987a\u5e8f\u5173\u95ed（\u4e0e\u521b\u5efa\u987a\u5e8f\u76f8\u53cd），\u907f\u514d\u8d44\u6e90\u6cc4\u6f0f：<\/p>\n

                      java<\/p>\n

                      rs.close();
                      \nstmt.close();
                      \nconn.close();<\/p>\n

                      \u56db\u3001\u51c6\u5907\u5de5\u4f5c<\/h3>\n

                      4.1 \u521b\u5efa\u6570\u636e\u5e93\u5e76\u521b\u5efa student \u8868<\/h4>\n
                    • \u521b\u5efa\u6570\u636e\u5e93jdbc_db，\u5b57\u7b26\u96c6utf8，\u6392\u5e8f\u89c4\u5219utf8_general_ci\u3002<\/li>\n
                    • \u521b\u5efastudent\u8868：\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\n

                      \"\"<\/p>\n<\/li>\n

                      4.2 \u521b\u5efa\u9879\u76ee<\/h4>\n

                      \u4f7f\u7528 IDEA \u521b\u5efa Java \u9879\u76ee（JDK \u5efa\u8bae 1.8+），\u65e0\u9700\u989d\u5916\u6846\u67b6，\u4fdd\u6301\u57fa\u7840 Java \u5de5\u7a0b\u7ed3\u6784\u3002<\/p>\n

                      4.3 \u521b\u5efa lib \u76ee\u5f55\u5e76\u5f15\u5165 MySQL \u9a71\u52a8\u5305<\/h4>\n
                    • \u5728\u9879\u76ee\u6839\u76ee\u5f55\u521b\u5efalib\u6587\u4ef6\u5939\u3002<\/li>\n
                    • \u653e\u5165 MySQL \u9a71\u52a8\u5305（\u5982mysql-connector-java-5.1.38.jar）\u3002<\/li>\n

                      \"\"<\/p>\n

                      4.4 \u628a lib \u5305\u5f15\u5165\u9879\u76ee\u73af\u5883<\/h4>\n
                    • \u53f3\u952elib\u76ee\u5f55 \u2192 \u9009\u62e9\u300cAdd as Library…\u300d\u3002<\/li>\n
                    • \u9009\u62e9\u300cProject Library\u300d\u7ea7\u522b，\u6dfb\u52a0\u5230\u5f53\u524d\u9879\u76ee，\u70b9\u51fb\u300cOK\u300d\u3002<\/li>\n

                      \"\"<\/p>\n

                      \u4e94\u3001\u4f7f\u7528 JDBC \u5b8c\u6210\u6dfb\u52a0\u64cd\u4f5c<\/h3>\n

                      5.1 \u6848\u4f8b\u5b9e\u73b0<\/h4>\n

                      java<\/p>\n

                      package com.hg.jdbc;<\/p>\n

                      import java.sql.Connection;
                      \nimport java.sql.DriverManager;
                      \nimport java.sql.SQLException;
                      \nimport java.sql.Statement;<\/p>\n

                      public class AddTest {
                      \n \/\/ \u9a71\u52a8\u5668\u8def\u5f84
                      \n private static final String DRIVER = "com.mysql.jdbc.Driver";
                      \n \/\/ \u8fde\u63a5\u6570\u636e\u5e93\u5730\u5740
                      \n private static final String URL = "jdbc:mysql:\/\/localhost:3306\/jdbc_db?useSSL=false&characterEncoding=UTF8";
                      \n \/\/ \u6570\u636e\u5e93\u7528\u6237\u540d
                      \n private static final String USER_NAME = "root";
                      \n \/\/ \u6570\u636e\u5e93\u5bc6\u7801
                      \n private static final String USER_PASSWORD = "1111";<\/p>\n

                      public static void main(String[] args) throws ClassNotFoundException, SQLException {
                      \n \/\/ \u52a0\u8f7dJDBC\u8bbf\u95eemysql\u7684\u9a71\u52a8
                      \n Class.forName(DRIVER);
                      \n \/\/ \u5efa\u7acb\u548c\u6570\u636e\u5e93\u7684\u8fde\u63a5
                      \n Connection conn = DriverManager.getConnection(URL, USER_NAME, USER_PASSWORD);
                      \n \/\/ \u521b\u5efaSQL\u547d\u4ee4\u53d1\u9001\u5668
                      \n Statement stmt = conn.createStatement();
                      \n \/\/ \u4f7f\u7528SQL\u547d\u4ee4\u53d1\u9001\u5668\u53d1\u9001SQL\u547d\u4ee4\u5e76\u5f97\u5230\u7ed3\u679c
                      \n String sql = "insert into student values(1,'\u5c0f\u521a',32,'\u7537','\u6e56\u5317\u7701\u6b66\u6c49\u5e02')";
                      \n int n = stmt.executeUpdate(sql);
                      \n \/\/ \u5904\u7406\u7ed3\u679c
                      \n if (n > 0) {
                      \n System.out.println("\u6dfb\u52a0\u6210\u529f");
                      \n } else {
                      \n System.out.println("\u6dfb\u52a0\u5931\u8d25");
                      \n }
                      \n \/\/ \u5173\u95ed\u6570\u636e\u5e93\u8d44\u6e90
                      \n stmt.close();
                      \n conn.close();
                      \n }
                      \n}<\/p>\n

                      5.2 URL \u8be6\u89e3<\/h4>\n

                      URL \u683c\u5f0f：\u534f\u8bae:\/\/\u670d\u52a1\u5668\u4e3b\u673a:\u7aef\u53e3\/\u670d\u52a1\u5668\u8def\u5f84?\u67e5\u8be2\u53c2\u6570<\/p>\n

                        \n
                      • \u534f\u8bae：jdbc:mysql:（\u56fa\u5b9a\u683c\u5f0f）\u3002<\/li>\n
                      • \u670d\u52a1\u5668\u4e3b\u673a：\u6570\u636e\u5e93\u6240\u5728\u5730\u5740（\u672c\u5730\u4e3alocalhost）\u3002<\/li>\n
                      • \u7aef\u53e3：MySQL \u9ed8\u8ba4 3306\u3002<\/li>\n
                      • \u670d\u52a1\u5668\u8def\u5f84：\u6570\u636e\u5e93\u540d（\u5982jdbc_db）\u3002<\/li>\n
                      • \u67e5\u8be2\u53c2\u6570：\u7f16\u7801\u683c\u5f0f\u3001SSL \u8bbe\u7f6e\u7b49（\u5982useSSL=false&characterEncoding=UTF8）\u3002<\/li>\n<\/ul>\n

                        \u516d\u3001\u4f7f\u7528 JDBC \u5b8c\u6210\u66f4\u65b0\u548c\u5220\u9664<\/h3>\n

                        6.1 \u6848\u4f8b\u539f\u7406<\/h4>\n

                        \u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c\u6d41\u7a0b\u4e0e\u6dfb\u52a0\u4e00\u81f4，\u6838\u5fc3\u533a\u522b\u5728\u4e8e SQL \u8bed\u53e5，\u5747\u4f7f\u7528executeUpdate()\u65b9\u6cd5\u6267\u884c\u3002<\/p>\n

                        6.2 \u4fee\u6539\u64cd\u4f5c\u4ee3\u7801<\/h4>\n

                        java<\/p>\n

                        package com.hg.jdbc;<\/p>\n

                        import java.sql.Connection;
                        \nimport java.sql.DriverManager;
                        \nimport java.sql.SQLException;
                        \nimport java.sql.Statement;<\/p>\n

                        public class UpdateTest {
                        \n private static final String DRIVER = "com.mysql.jdbc.Driver";
                        \n private static final String URL = "jdbc:mysql:\/\/localhost:3306\/jdbc_db?useSSL=false&characterEncoding=UTF8";
                        \n private static final String USER_NAME = "root";
                        \n private static final String USER_PASSWORD = "1111";<\/p>\n

                        public static void main(String[] args) throws ClassNotFoundException, SQLException {
                        \n Class.forName(DRIVER);
                        \n Connection conn = DriverManager.getConnection(URL, USER_NAME, USER_PASSWORD);
                        \n Statement stat = conn.createStatement();
                        \n \/\/ \u7f16\u5199\u66f4\u65b0SQL
                        \n String sql = "update student set name='\u5c0f\u660e',age=23,sex='\u5973',address='\u6b66\u6c49' where id=1";
                        \n int res = stat.executeUpdate(sql);
                        \n if (res > 0) {
                        \n System.out.println("\u4fee\u6539\u6210\u529f");
                        \n } else {
                        \n System.out.println("\u5904\u7406\u5931\u8d25");
                        \n }
                        \n stat.close();
                        \n conn.close();
                        \n }
                        \n}<\/p>\n

                        6.3 \u5220\u9664\u64cd\u4f5c\u4ee3\u7801<\/h4>\n

                        java<\/p>\n

                        package com.hg.jdbc;<\/p>\n

                        import java.sql.Connection;
                        \nimport java.sql.DriverManager;
                        \nimport java.sql.SQLException;
                        \nimport java.sql.Statement;<\/p>\n

                        public class DeleteTest {
                        \n private static final String DRIVER = "com.mysql.jdbc.Driver";
                        \n private static final String URL = "jdbc:mysql:\/\/localhost:3306\/jdbc_db?useSSL=false&characterEncoding=UTF8";
                        \n private static final String USER_NAME = "root";
                        \n private static final String USER_PASSWORD = "1111";<\/p>\n

                        public static void main(String[] args) throws ClassNotFoundException, SQLException {
                        \n Class.forName(DRIVER);
                        \n Connection conn = DriverManager.getConnection(URL, USER_NAME, USER_PASSWORD);
                        \n Statement stat = conn.createStatement();
                        \n \/\/ \u7f16\u5199\u5220\u9664SQL
                        \n String sql = "delete from student where id=1";
                        \n int res = stat.executeUpdate(sql);
                        \n if (res > 0) {
                        \n System.out.println("\u5220\u9664\u6210\u529f");
                        \n } else {
                        \n System.out.println("\u5220\u9664\u5931\u8d25");
                        \n }
                        \n stat.close();
                        \n conn.close();
                        \n }
                        \n}<\/p>\n

                        \u4e03\u3001DBUtils \u7684\u7b80\u5355\u5c01\u88c5<\/h3>\n

                        7.1 \u4e3a\u4ec0\u4e48\u8981\u5c01\u88c5<\/h4>\n

                        \u6dfb\u52a0\u3001\u66f4\u65b0\u3001\u5220\u9664\u64cd\u4f5c\u4e2d，\u52a0\u8f7d\u9a71\u52a8\u3001\u521b\u5efa\u8fde\u63a5\u3001\u5173\u95ed\u8d44\u6e90\u7b49\u4ee3\u7801\u91cd\u590d\u5ea6\u6781\u9ad8，\u5c01\u88c5\u4e3a\u5de5\u5177\u7c7b\u53ef\u51cf\u5c11\u5197\u4f59，\u63d0\u9ad8\u5f00\u53d1\u6548\u7387\u3002<\/p>\n

                        7.2 \u521b\u5efa db.properties \u914d\u7f6e\u6587\u4ef6<\/h4>\n

                        \u5728src\u76ee\u5f55\u4e0b\u521b\u5efa\u914d\u7f6e\u6587\u4ef6，\u5b58\u50a8\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f：<\/p>\n

                        properties<\/p>\n

                        driverClass=com.mysql.jdbc.Driver
                        \nurl=jdbc:mysql:\/\/localhost:3306\/jdbc_db
                        \nusername=root
                        \npassword=1111<\/p>\n

                        7.3 \u5b9e\u73b0 DBUtils \u5de5\u5177\u7c7b<\/h4>\n

                        java<\/p>\n

                        import java.io.InputStream;
                        \nimport java.sql.Connection;
                        \nimport java.sql.DriverManager;
                        \nimport java.sql.SQLException;
                        \nimport java.util.Properties;<\/p>\n

                        public class DBUtils {
                        \n \/\/ \u914d\u7f6e\u53d8\u91cf
                        \n private static String DRIVER;
                        \n private static String URL;
                        \n private static String USER_NAME;
                        \n private static String USER_PASSWORD;<\/p>\n

                        \/\/ \u9759\u6001\u4ee3\u7801\u5757：\u52a0\u8f7d\u914d\u7f6e+\u6ce8\u518c\u9a71\u52a8
                        \n static {
                        \n try {
                        \n InputStream is = DBUtils.class.getClassLoader().getResourceAsStream("db.properties");
                        \n Properties prop = new Properties();
                        \n prop.load(is);<\/p>\n

                        DRIVER = prop.getProperty("driverClass");
                        \n URL = prop.getProperty("url");
                        \n USER_NAME = prop.getProperty("username");
                        \n USER_PASSWORD = prop.getProperty("password");<\/p>\n

                        \/\/ \u6ce8\u518c\u9a71\u52a8
                        \n Class.forName(DRIVER);
                        \n } catch (Exception e) {
                        \n e.printStackTrace();
                        \n }
                        \n }<\/p>\n

                        \/\/ \u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5
                        \n public static Connection getConn() {
                        \n try {
                        \n return DriverManager.getConnection(URL, USER_NAME, USER_PASSWORD);
                        \n } catch (SQLException e) {
                        \n e.printStackTrace();
                        \n System.out.println("\u521b\u5efa\u8fde\u63a5\u5bf9\u8c61\u5f02\u5e38");
                        \n }
                        \n return null;
                        \n }<\/p>\n

                        \/\/ \u91ca\u653e\u8d44\u6e90（\u652f\u6301Connection\u3001Statement\u3001ResultSet）
                        \n public static void close(AutoCloseable closeable) {
                        \n try {
                        \n if (closeable != null) {
                        \n closeable.close();
                        \n }
                        \n } catch (Exception e) {
                        \n e.printStackTrace();
                        \n }
                        \n }
                        \n}<\/p>\n

                        7.4 \u6539\u9020\u539f\u6709\u4ee3\u7801<\/h4>\n

                        \u4ee5\u6dfb\u52a0\u64cd\u4f5c\u4e3a\u4f8b，\u6539\u9020\u540e\u4ee3\u7801：<\/p>\n

                        java<\/p>\n

                        package com.hg.jdbc;<\/p>\n

                        import com.hg.utils.DBUtils;
                        \nimport java.sql.Connection;
                        \nimport java.sql.SQLException;
                        \nimport java.sql.Statement;<\/p>\n

                        public class Test01Add {
                        \n public static void main(String[] args) throws ClassNotFoundException, SQLException {
                        \n Connection conn = DBUtils.getConn();
                        \n Statement stmt = conn.createStatement();
                        \n String sql = "insert into student values(1,'\u5c0f\u521a',32,'\u7537','\u6e56\u5317\u7701\u6b66\u6c49\u5e02')";
                        \n int n = stmt.executeUpdate(sql);
                        \n if (n > 0) {
                        \n System.out.println("\u6dfb\u52a0\u6210\u529f");
                        \n } else {
                        \n System.out.println("\u6dfb\u52a0\u5931\u8d25");
                        \n }
                        \n \/\/ \u8c03\u7528\u5de5\u5177\u7c7b\u5173\u95ed\u8d44\u6e90
                        \n DBUtils.close(stmt);
                        \n DBUtils.close(conn);
                        \n }
                        \n}<\/p>\n

                        \u516b\u3001\u4f7f\u7528 JDBC \u5b8c\u6210\u67e5\u8be2<\/h3>\n

                        8.1 \u73af\u5883\u51c6\u5907（\u6279\u91cf\u6dfb\u52a0\u6d4b\u8bd5\u6570\u636e）<\/h4>\n

                        \u5148\u6279\u91cf\u63d2\u5165 20 \u6761\u6d4b\u8bd5\u6570\u636e，\u65b9\u4fbf\u67e5\u8be2\u9a8c\u8bc1：<\/p>\n

                        java<\/p>\n

                        package com.hg.jdbc;<\/p>\n

                        import com.hg.utils.DBUtils;
                        \nimport java.sql.Connection;
                        \nimport java.sql.SQLException;
                        \nimport java.sql.Statement;
                        \nimport java.util.Random;<\/p>\n

                        public class Test01Add20 {
                        \n public static void main(String[] args) throws ClassNotFoundException, SQLException {
                        \n Connection conn = DBUtils.getConn();
                        \n Statement stmt = conn.createStatement();
                        \n Random random = new Random();
                        \n for (int i = 1; i <= 20; i++) {
                        \n Integer id = i;
                        \n String name = "\u5c0f\u660e" + i;
                        \n int age = random.nextInt(100);
                        \n String sex = random.nextBoolean() ? "\u7537" : "\u5973";
                        \n String address = "\u6b66\u6c49" + i;<\/p>\n

                        String sql = "insert into student values(" + i + ",'" + name + "'," + age + ",'" + sex + "','" + address + "')";
                        \n int n = stmt.executeUpdate(sql);
                        \n if (n > 0) {
                        \n System.out.println("\u6dfb\u52a0\u6210\u529f");
                        \n } else {
                        \n System.out.println("\u6dfb\u52a0\u5931\u8d25");
                        \n }
                        \n }
                        \n DBUtils.close(stmt);
                        \n DBUtils.close(conn);
                        \n }
                        \n}<\/p>\n

                        8.2 \u67e5\u8be2\u6848\u4f8b\u5b9e\u73b0<\/h4>\n

                        java<\/p>\n

                        package com.hg.jdbc;<\/p>\n

                        import com.hg.utils.DBUtils;
                        \nimport java.sql.Connection;
                        \nimport java.sql.ResultSet;
                        \nimport java.sql.SQLException;
                        \nimport java.sql.Statement;<\/p>\n

                        public class Test04Query {
                        \n public static void main(String[] args) throws ClassNotFoundException, SQLException {
                        \n Connection conn = DBUtils.getConn();
                        \n Statement stmt = conn.createStatement();
                        \n String sql = "select * from student";
                        \n ResultSet rs = stmt.executeQuery(sql);
                        \n \/\/ \u904d\u5386\u7ed3\u679c\u96c6
                        \n while (rs.next()) {
                        \n int id = rs.getInt(1);
                        \n String name = rs.getString(2);
                        \n int age = rs.getInt(3);
                        \n String sex = rs.getString(4);
                        \n String address = rs.getString(5);
                        \n System.out.println(id + " " + name + " " + age + " " + sex + " " + address);
                        \n }
                        \n \/\/ \u5173\u95ed\u8d44\u6e90（ResultSet\u9700\u5148\u5173\u95ed）
                        \n DBUtils.close(rs);
                        \n DBUtils.close(stmt);
                        \n DBUtils.close(conn);
                        \n }
                        \n}<\/p>\n

                        \u4e5d\u3001\u4f7f\u7528 JDBC \u5b8c\u6210\u5206\u9875\u67e5\u8be2<\/h3>\n

                        MySQL \u5206\u9875\u4f9d\u8d56LIMIT\u5173\u952e\u5b57，\u8bed\u6cd5：LIMIT \u8d77\u59cb\u7d22\u5f15, \u6bcf\u9875\u6761\u6570（\u8d77\u59cb\u7d22\u5f15\u4ece 0 \u5f00\u59cb）\u3002<\/p>\n

                        9.1 \u5206\u9875\u67e5\u8be2\u6848\u4f8b<\/h4>\n

                        java<\/p>\n

                        package com.hg.jdbc;<\/p>\n

                        import com.hg.utils.DBUtils;
                        \nimport java.sql.Connection;
                        \nimport java.sql.ResultSet;
                        \nimport java.sql.SQLException;
                        \nimport java.sql.Statement;<\/p>\n

                        public class Test05QueryForPage {
                        \n public static void main(String[] args) throws ClassNotFoundException, SQLException {
                        \n Connection conn = DBUtils.getConn();
                        \n Statement stmt = conn.createStatement();
                        \n int pageNum = 2; \/\/ \u9875\u7801（\u67e5\u8be2\u7b2c2\u9875）
                        \n int pageSize = 5; \/\/ \u6bcf\u9875\u663e\u793a5\u6761
                        \n \/\/ \u8ba1\u7b97\u8d77\u59cb\u7d22\u5f15：(\u9875\u7801-1)*\u6bcf\u9875\u6761\u6570
                        \n String sql = "select * from student limit " + (pageNum – 1) * pageSize + "," + pageSize;
                        \n ResultSet rs = stmt.executeQuery(sql);
                        \n while (rs.next()) {
                        \n int id = rs.getInt(1);
                        \n String name = rs.getString(2);
                        \n int age = rs.getInt(3);
                        \n String sex = rs.getString(4);
                        \n String address = rs.getString(5);
                        \n System.out.println(id + " " + name + " " + age + " " + sex + " " + address);
                        \n }
                        \n DBUtils.close(rs);
                        \n DBUtils.close(stmt);
                        \n DBUtils.close(conn);
                        \n }
                        \n}<\/p>\n

                        \u5341\u3001SQL \u6ce8\u5165\u95ee\u9898<\/h3>\n

                        10.1 \u95ee\u9898\u5f15\u5165<\/h4>\n

                        10.1.1 \u51c6\u5907\u6d4b\u8bd5\u73af\u5883<\/h5>\n

                        \u521b\u5efasys_user\u8868\u5e76\u521d\u59cb\u5316\u6570\u636e：<\/p>\n

                        \"\"<\/p>\n\nidusernamepassword<\/tr>\n\n\n\n
                        1<\/td>\nadmin<\/td>\n123456<\/td>\n<\/tr>\n
                        2<\/td>\nzhangsan<\/td>\n123<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                        10.1.2 \u5b58\u5728\u6ce8\u5165\u98ce\u9669\u7684\u767b\u5f55\u4ee3\u7801<\/h5>\n

                        java<\/p>\n

                        package com.hg.jdbc;<\/p>\n

                        import com.hg.utils.DBUtils;
                        \nimport java.sql.Connection;
                        \nimport java.sql.ResultSet;
                        \nimport java.sql.SQLException;
                        \nimport java.sql.Statement;
                        \nimport java.util.Scanner;<\/p>\n

                        public class Test06Login {
                        \n public static void main(String[] args) throws ClassNotFoundException, SQLException {
                        \n Connection conn = DBUtils.getConn();
                        \n Statement stmt = conn.createStatement();
                        \n Scanner scanner = new Scanner(System.in);
                        \n System.out.println("\u8bf7\u8f93\u5165\u7528\u6237\u540d:");
                        \n String username = scanner.nextLine();
                        \n System.out.println("\u8bf7\u8f93\u5165\u5bc6\u7801:");
                        \n String password = scanner.nextLine();
                        \n \/\/ \u62fc\u63a5SQL（\u5b58\u5728\u6ce8\u5165\u98ce\u9669）
                        \n String sql = "select * from sys_user where username='" + username + "' and password='" + password + "'";
                        \n ResultSet rs = stmt.executeQuery(sql);
                        \n System.out.println(sql);
                        \n if (rs.next()) {
                        \n System.out.println("\u767b\u9646\u6210\u529f");
                        \n int id = rs.getInt(1);
                        \n String name = rs.getString(2);
                        \n String pwd = rs.getString(3);
                        \n System.out.println(id + " " + name + " " + pwd);
                        \n }
                        \n DBUtils.close(rs);
                        \n DBUtils.close(stmt);
                        \n DBUtils.close(conn);
                        \n }
                        \n}<\/p>\n

                        10.1.3 \u6d4b\u8bd5\u6ce8\u5165\u653b\u51fb<\/h5>\n

                        \u8f93\u5165\u4ee5\u4e0b\u5185\u5bb9，\u65e0\u9700\u6b63\u786e\u8d26\u53f7\u5bc6\u7801\u5373\u53ef\u767b\u5f55：<\/p>\n

                          \n
                        • \u7528\u6237\u540d：aaa<\/li>\n
                        • \u5bc6\u7801：aaa'or'1'='1<\/li>\n
                        • \u62fc\u63a5\u540e\u7684 SQL：select * from sys_user where username='aaa' and password='aaa'or'1'='1'<\/li>\n
                        • \u539f\u7406：'1'='1\u6052\u6210\u7acb，SQL \u6761\u4ef6\u6c38\u8fdc\u4e3a\u771f，\u7ed5\u8fc7\u767b\u5f55\u9a8c\u8bc1\u3002<\/li>\n<\/ul>\n

                          10.2 \u89e3\u51b3\u529e\u6cd5：\u4f7f\u7528 PreparedStatement<\/h4>\n

                          10.2.1 \u6280\u672f\u539f\u7406<\/h5>\n
                            \n
                          • PreparedStatement \u9884\u7f16\u8bd1 SQL，\u5360\u4f4d\u7b26?\u66ff\u4ee3\u76f4\u63a5\u62fc\u63a5\u53c2\u6570\u3002<\/li>\n
                          • \u53c2\u6570\u901a\u8fc7setXxx()\u65b9\u6cd5\u7ed1\u5b9a，\u6570\u636e\u5e93\u4f1a\u81ea\u52a8\u8fc7\u6ee4\u7279\u6b8a\u5b57\u7b26，\u907f\u514d\u6ce8\u5165\u3002<\/li>\n
                          • \u9884\u7f16\u8bd1\u540e\u91cd\u590d\u6267\u884c\u6548\u7387\u66f4\u9ad8\u3002<\/li>\n<\/ul>\n
                            10.2.2 \u6539\u9020\u540e\u7684\u767b\u5f55\u4ee3\u7801<\/h5>\n

                            java<\/p>\n

                            package com.hg.jdbc;<\/p>\n

                            import com.hg.utils.DBUtils;
                            \nimport java.sql.Connection;
                            \nimport java.sql.PreparedStatement;
                            \nimport java.sql.ResultSet;
                            \nimport java.sql.SQLException;
                            \nimport java.util.Scanner;<\/p>\n

                            public class Test07Login {
                            \n public static void main(String[] args) throws ClassNotFoundException, SQLException {
                            \n Scanner scanner = new Scanner(System.in);
                            \n System.out.println("\u8bf7\u8f93\u5165\u7528\u6237\u540d:");
                            \n String username = scanner.nextLine();
                            \n System.out.println("\u8bf7\u8f93\u5165\u5bc6\u7801:");
                            \n String password = scanner.nextLine();<\/p>\n

                            Connection conn = DBUtils.getConn();
                            \n \/\/ \u4f7f\u7528\u5360\u4f4d\u7b26\u7f16\u5199SQL
                            \n String sql = "select * from sys_user where username=? and password=? ";
                            \n \/\/ \u521b\u5efaPreparedStatement\u5bf9\u8c61（\u9884\u7f16\u8bd1SQL）
                            \n PreparedStatement pstmt = conn.prepareStatement(sql);
                            \n \/\/ \u7ed1\u5b9a\u53c2\u6570（\u7d22\u5f15\u4ece1\u5f00\u59cb）
                            \n pstmt.setString(1, username);
                            \n pstmt.setString(2, password);
                            \n ResultSet rs = pstmt.executeQuery();<\/p>\n

                            if (rs.next()) {
                            \n System.out.println("\u767b\u9646\u6210\u529f");
                            \n int id = rs.getInt(1);
                            \n String name = rs.getString(2);
                            \n String pwd = rs.getString(3);
                            \n System.out.println(id + " " + name + " " + pwd);
                            \n } else {
                            \n System.out.println("\u767b\u5f55\u5931\u8d25");
                            \n }<\/p>\n

                            DBUtils.close(rs);
                            \n DBUtils.close(pstmt);
                            \n DBUtils.close(conn);
                            \n }
                            \n}<\/p>\n

                            10.2.3 \u6d4b\u8bd5\u9a8c\u8bc1<\/h5>\n

                            \u518d\u6b21\u8f93\u5165\u6ce8\u5165\u5f0f\u5bc6\u7801aaa'or'1'='1，\u4f1a\u88ab\u5f53\u4f5c\u666e\u901a\u5b57\u7b26\u4e32\u5904\u7406，\u65e0\u6cd5\u7ed5\u8fc7\u9a8c\u8bc1，SQL \u6ce8\u5165\u88ab\u9632\u5fa1\u3002<\/p>\n

                            \u5341\u4e00\u3001\u4e8b\u52a1\u5904\u7406\u89e3\u51b3\u8f6c\u8d26\u95ee\u9898<\/h3>\n

                            11.1 \u4ec0\u4e48\u662f\u4e8b\u52a1<\/h4>\n

                            \u4e8b\u52a1\u662f\u6570\u636e\u5e93\u64cd\u4f5c\u7684\u6700\u5c0f\u5de5\u4f5c\u5355\u5143，\u662f\u4e00\u7cfb\u5217\u4e0d\u53ef\u5206\u5272\u7684\u64cd\u4f5c\u96c6\u5408，\u8981\u4e48\u5168\u90e8\u6267\u884c，\u8981\u4e48\u5168\u90e8\u4e0d\u6267\u884c（\u907f\u514d\u6570\u636e\u4e0d\u4e00\u81f4）\u3002<\/p>\n

                            11.2 \u4e8b\u52a1\u7684\u56db\u5927\u7279\u6027（ACID）<\/h4>\n
                              \n
                            • \u539f\u5b50\u6027（Atomicity）：\u4e8b\u52a1\u4e2d\u64cd\u4f5c\u8981\u4e48\u5168\u6210\u529f，\u8981\u4e48\u5168\u56de\u6eda\u3002<\/li>\n
                            • \u4e00\u81f4\u6027（Consistency）：\u4e8b\u52a1\u6267\u884c\u540e，\u6570\u636e\u5e93\u4ece\u4e00\u4e2a\u4e00\u81f4\u72b6\u6001\u5207\u6362\u5230\u53e6\u4e00\u4e2a\u4e00\u81f4\u72b6\u6001\u3002<\/li>\n
                            • \u9694\u79bb\u6027（Isolation）：\u5e76\u53d1\u4e8b\u52a1\u4e4b\u95f4\u4e92\u4e0d\u5e72\u6270\u3002<\/li>\n
                            • \u6301\u4e45\u6027（Durability）：\u4e8b\u52a1\u63d0\u4ea4\u540e，\u6570\u636e\u4fee\u6539\u6c38\u4e45\u6709\u6548\u3002<\/li>\n<\/ul>\n

                              11.3 \u9700\u6c42\u63cf\u8ff0<\/h4>\n

                              \u5b9e\u73b0\u8f6c\u8d26\u529f\u80fd：\u5f20\u4e09\u5411\u674e\u56db\u8f6c\u8d26 1000 \u5143，\u8981\u6c42\u6263\u51cf\u5f20\u4e09\u4f59\u989d\u548c\u589e\u52a0\u674e\u56db\u4f59\u989d\u4e24\u4e2a\u64cd\u4f5c\u8981\u4e48\u5168\u6210\u529f，\u8981\u4e48\u5168\u5931\u8d25\u3002<\/p>\n

                              11.4 \u51c6\u5907\u5de5\u4f5c（\u521b\u5efa account \u8868）<\/h4>\n

                              sql<\/p>\n

                              CREATE TABLE account (
                              \n aid INT PRIMARY KEY AUTO_INCREMENT,
                              \n aname VARCHAR(30) NOT NULL,
                              \n amount DECIMAL(10,2) NOT NULL
                              \n);<\/p>\n

                              \u521d\u59cb\u5316\u6570\u636e：<\/p>\n\naidanameamount<\/tr>\n\n\n\n
                              1<\/td>\n\u5f20\u4e09<\/td>\n10000.00<\/td>\n<\/tr>\n
                              2<\/td>\n\u674e\u56db<\/td>\n10000.00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                              11.5 \u4ee3\u7801\u5b9e\u73b0<\/h4>\n

                              java<\/p>\n

                              package com.hg.jdbc;<\/p>\n

                              import com.hg.utils.DBUtils;
                              \nimport java.sql.Connection;
                              \nimport java.sql.SQLException;
                              \nimport java.sql.Statement;<\/p>\n

                              public class Test08Transaction {
                              \n public static void main(String[] args) {
                              \n Connection conn = null;
                              \n Statement stmt = null;
                              \n try {
                              \n conn = DBUtils.getConn();
                              \n \/\/ \u5173\u95ed\u81ea\u52a8\u63d0\u4ea4，\u5f00\u542f\u4e8b\u52a1
                              \n conn.setAutoCommit(false);<\/p>\n

                              \/\/ \u8f6c\u8d26SQL：\u5f20\u4e09\u62631000，\u674e\u56db\u52a01000
                              \n String sql1 = "update account set amount = amount-1000 where aid=1";
                              \n String sql2 = "update account set amount = amount+1000 where aid=2";<\/p>\n

                              stmt = conn.createStatement();
                              \n stmt.executeUpdate(sql1);
                              \n \/\/ \u6a21\u62df\u5f02\u5e38（\u6d4b\u8bd5\u4e8b\u52a1\u56de\u6eda）：int i = 1\/0;
                              \n stmt.executeUpdate(sql2);<\/p>\n

                              \/\/ \u65e0\u5f02\u5e38\u5219\u63d0\u4ea4\u4e8b\u52a1
                              \n conn.commit();
                              \n System.out.println("\u8f6c\u8d26\u6210\u529f");
                              \n } catch (Exception e) {
                              \n e.printStackTrace();
                              \n \/\/ \u51fa\u73b0\u5f02\u5e38\u5219\u56de\u6eda\u4e8b\u52a1
                              \n try {
                              \n if (conn != null) {
                              \n conn.rollback();
                              \n System.out.println("\u8f6c\u8d26\u5931\u8d25，\u4e8b\u52a1\u56de\u6eda");
                              \n }
                              \n } catch (SQLException e1) {
                              \n e1.printStackTrace();
                              \n }
                              \n } finally {
                              \n \/\/ \u5173\u95ed\u8d44\u6e90
                              \n DBUtils.close(stmt);
                              \n DBUtils.close(conn);
                              \n }
                              \n }
                              \n}<\/p>\n

                              11.6 \u6d4b\u8bd5\u9a8c\u8bc1<\/h4>\n
                                \n
                              • \u6b63\u5e38\u60c5\u51b5：\u65e0\u5f02\u5e38\u65f6，\u4e8b\u52a1\u63d0\u4ea4，\u5f20\u4e09\u4f59\u989d 9000，\u674e\u56db 11000\u3002<\/li>\n
                              • \u5f02\u5e38\u60c5\u51b5：\u5728sql1\u548csql2\u4e4b\u95f4\u6dfb\u52a0int i = 1\/0;\u6a21\u62df\u5f02\u5e38，\u4e8b\u52a1\u56de\u6eda，\u4e24\u4eba\u4f59\u989d\u4fdd\u6301\u521d\u59cb\u503c 10000\u3002<\/li>\n<\/ul>\n

                                \u5341\u4e8c\u3001BaseDAO \u7684\u5c01\u88c5（\u96be\u70b9）<\/h3>\n

                                12.1 \u6982\u8ff0<\/h4>\n

                                ORM（\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04）\u6846\u67b6（\u5982 MyBatis\u3001Hibernate）\u53ef\u7b80\u5316 JDBC \u5f00\u53d1，BaseDAO \u901a\u8fc7\u53cd\u5c04\u673a\u5236\u6a21\u62df ORM \u6838\u5fc3\u529f\u80fd，\u5b9e\u73b0\u901a\u7528\u7684 CRUD \u64cd\u4f5c，\u51cf\u5c11\u91cd\u590d\u4ee3\u7801\u3002<\/p>\n

                                12.2 BaseDAO \u5b9e\u73b0\u4ee3\u7801<\/h4>\n

                                java<\/p>\n

                                import com.hg.utils.DBUtils;
                                \nimport java.lang.reflect.Field;
                                \nimport java.sql.Connection;
                                \nimport java.sql.PreparedStatement;
                                \nimport java.sql.ResultSet;
                                \nimport java.sql.ResultSetMetaData;
                                \nimport java.util.ArrayList;
                                \nimport java.util.List;<\/p>\n

                                public class BaseDao {
                                \n \/**
                                \n * \u901a\u7528\u67e5\u8be2（\u8fd4\u56de\u591a\u6761\u6570\u636e）
                                \n * @param sql SQL\u6307\u4ee4
                                \n * @param clss \u6620\u5c04\u7684\u5b9e\u4f53\u7c7b
                                \n * @param params SQL\u5360\u4f4d\u7b26\u53c2\u6570
                                \n * @param <T> \u5b9e\u4f53\u7c7b\u6cdb\u578b
                                \n * @return \u5b9e\u4f53\u7c7b\u5217\u8868
                                \n *\/
                                \n public <T> List<T> selectList(String sql, Class<T> clss, Object… params) {
                                \n List<T> data = new ArrayList<>();
                                \n Connection conn = DBUtils.getConn();
                                \n PreparedStatement prep = null;
                                \n ResultSet rs = null;
                                \n try {
                                \n prep = conn.prepareStatement(sql);
                                \n \/\/ \u7ed1\u5b9a\u53c2\u6570
                                \n for (int i = 0; i < params.length; i++) {
                                \n prep.setObject(i + 1, params[i]);
                                \n }
                                \n \/\/ \u6267\u884c\u67e5\u8be2
                                \n rs = prep.executeQuery();
                                \n ResultSetMetaData metaData = rs.getMetaData();
                                \n int columnCount = metaData.getColumnCount();<\/p>\n

                                \/\/ \u904d\u5386\u7ed3\u679c\u96c6，\u901a\u8fc7\u53cd\u5c04\u5c01\u88c5\u5b9e\u4f53\u7c7b
                                \n while (rs.next()) {
                                \n T t = clss.newInstance();
                                \n for (int i = 0; i < columnCount; i++) {
                                \n \/\/ \u83b7\u53d6\u5217\u522b\u540d（\u9700\u4e0e\u5b9e\u4f53\u7c7b\u5c5e\u6027\u540d\u4e00\u81f4）
                                \n String columnLabel = metaData.getColumnLabel(i + 1);
                                \n \/\/ \u83b7\u53d6\u5217\u503c
                                \n Object columnValue = rs.getObject(columnLabel);
                                \n \/\/ \u53cd\u5c04\u8bbe\u7f6e\u5b9e\u4f53\u7c7b\u5c5e\u6027\u503c
                                \n Field field = clss.getDeclaredField(columnLabel);
                                \n field.setAccessible(true); \/\/ \u5141\u8bb8\u8bbf\u95ee\u79c1\u6709\u5c5e\u6027
                                \n field.set(t, columnValue);
                                \n }
                                \n data.add(t);
                                \n }
                                \n } catch (Exception e) {
                                \n e.printStackTrace();
                                \n } finally {
                                \n DBUtils.close(rs);
                                \n DBUtils.close(prep);
                                \n DBUtils.close(conn);
                                \n }
                                \n return data;
                                \n }<\/p>\n

                                \/**
                                \n * \u901a\u7528\u67e5\u8be2（\u8fd4\u56de\u5355\u6761\u6570\u636e）
                                \n * @param sql SQL\u6307\u4ee4
                                \n * @param clss \u6620\u5c04\u7684\u5b9e\u4f53\u7c7b
                                \n * @param params SQL\u5360\u4f4d\u7b26\u53c2\u6570
                                \n * @param <T> \u5b9e\u4f53\u7c7b\u6cdb\u578b
                                \n * @return \u5355\u4e2a\u5b9e\u4f53\u5bf9\u8c61
                                \n *\/
                                \n public <T> T selectOne(String sql, Class<T> clss, Object… params) {
                                \n List<T> list = selectList(sql, clss, params);
                                \n return list.isEmpty() ? null : list.get(0);
                                \n }<\/p>\n

                                \/**
                                \n * \u901a\u7528\u66f4\u65b0\u64cd\u4f5c（INSERT\/UPDATE\/DELETE）
                                \n * @param sql SQL\u6307\u4ee4
                                \n * @param params SQL\u5360\u4f4d\u7b26\u53c2\u6570
                                \n * @return \u662f\u5426\u6267\u884c\u6210\u529f
                                \n *\/
                                \n public boolean update(String sql, Object… params) {
                                \n Connection conn = DBUtils.getConn();
                                \n PreparedStatement prep = null;
                                \n try {
                                \n prep = conn.prepareStatement(sql);
                                \n \/\/ \u7ed1\u5b9a\u53c2\u6570
                                \n for (int i = 0; i < params.length; i++) {
                                \n prep.setObject(i + 1, params[i]);
                                \n }
                                \n \/\/ \u6267\u884c\u66f4\u65b0，\u8fd4\u56de\u53d7\u5f71\u54cd\u884c\u6570
                                \n int affectedRows = prep.executeUpdate();
                                \n return affectedRows >= 1;
                                \n } catch (SQLException throwables) {
                                \n throwables.printStackTrace();
                                \n } finally {
                                \n DBUtils.close(prep);
                                \n DBUtils.close(conn);
                                \n }
                                \n return false;
                                \n }
                                \n}<\/p>\n

                                12.3 BaseDAO \u7684\u4f7f\u7528<\/h4>\n

                                \u5047\u8bbe\u5b58\u5728User\u5b9e\u4f53\u7c7b（\u5c5e\u6027\u4e0e\u6570\u636e\u5e93\u8868\u5b57\u6bb5\u5bf9\u5e94），\u521b\u5efa DAO \u5b9e\u73b0\u7c7b：<\/p>\n

                                java<\/p>\n

                                package com.hg.dao.impl;<\/p>\n

                                import com.hg.dao.BaseDao;
                                \nimport com.hg.pojo.User;<\/p>\n

                                public class UserDao extends BaseDao {
                                \n \/**
                                \n * \u6839\u636e\u7528\u6237\u540d\u548c\u5bc6\u7801\u67e5\u8be2\u7528\u6237
                                \n *\/
                                \n public User selectUser(String username, String password) {
                                \n String sql = "select id, username, password, realname, role from user where username = ? and password=?";
                                \n return super.selectOne(sql, User.class, username, password);
                                \n }<\/p>\n

                                \/**
                                \n * \u66f4\u65b0\u7528\u6237\u5220\u9664\u72b6\u6001
                                \n *\/
                                \n public void updateState(String id, Integer deleted) {
                                \n String sql = "update user set deleted = ?, deleted_time = now() where id = ?";
                                \n super.update(sql, deleted, id);
                                \n }
                                \n}<\/p>\n

                                12.4 \u5206\u9875\u5c01\u88c5<\/h4>\n

                                12.4.1 \u521b\u5efa\u5206\u9875\u7ed3\u679c\u5c01\u88c5\u7c7b PageInfo<T><\/h5>\n

                                java<\/p>\n

                                package com.hg.common;<\/p>\n

                                import java.util.List;<\/p>\n

                                public class PageInfo<T> {
                                \n private List<T> data; \/\/ \u5206\u9875\u6570\u636e
                                \n private Long count; \/\/ \u603b\u6570\u636e\u6761\u6570<\/p>\n

                                \/\/ getter\/setter
                                \n public List<T> getData() { return data; }
                                \n public void setData(List<T> data) { this.data = data; }
                                \n public Long getCount() { return count; }
                                \n public void setCount(Long count) { this.count = count; }
                                \n}<\/p>\n

                                12.4.2 \u6269\u5c55 BaseDAO \u6dfb\u52a0\u5206\u9875\u65b9\u6cd5<\/h5>\n

                                java<\/p>\n

                                \/**
                                \n * \u901a\u7528\u5206\u9875\u67e5\u8be2
                                \n * @param sql \u57fa\u7840SQL（\u4e0d\u542bLIMIT）
                                \n * @param cls \u5b9e\u4f53\u7c7b
                                \n * @param page \u9875\u7801
                                \n * @param limit \u6bcf\u9875\u6761\u6570
                                \n * @param <T> \u6cdb\u578b
                                \n * @return \u5206\u9875\u7ed3\u679c
                                \n *\/
                                \nprotected <T> PageInfo<T> selectPage(String sql, Class<T> cls, String page, String limit) {
                                \n \/\/ \u8ba1\u7b97\u8d77\u59cb\u7d22\u5f15
                                \n Integer pageNo = 0;
                                \n if (Integer.parseInt(page) > 0) {
                                \n pageNo = (Integer.parseInt(page) – 1) * Integer.parseInt(limit);
                                \n }
                                \n \/\/ \u5206\u9875SQL
                                \n String listSql = sql + " limit " + pageNo + "," + limit;
                                \n \/\/ \u67e5\u8be2\u5206\u9875\u6570\u636e
                                \n List<T> data = selectList(listSql, cls);
                                \n \/\/ \u67e5\u8be2\u603b\u6761\u6570
                                \n Long count = getCount(sql);
                                \n \/\/ \u5c01\u88c5\u5206\u9875\u7ed3\u679c
                                \n PageInfo<T> pageInfo = new PageInfo<>();
                                \n pageInfo.setData(data);
                                \n pageInfo.setCount(count);
                                \n return pageInfo;
                                \n}<\/p>\n

                                \/**
                                \n * \u67e5\u8be2\u603b\u6570\u636e\u6761\u6570
                                \n * @param sql \u57fa\u7840SQL
                                \n * @return \u603b\u6761\u6570
                                \n *\/
                                \nprivate Long getCount(String sql) {
                                \n String countSql = "select count(1) from (" + sql + ") rs";
                                \n Connection conn = DBUtils.getConn();
                                \n PreparedStatement prep = null;
                                \n ResultSet rs = null;
                                \n try {
                                \n prep = conn.prepareStatement(countSql);
                                \n rs = prep.executeQuery();
                                \n rs.next();
                                \n return rs.getLong(1);
                                \n } catch (SQLException throwables) {
                                \n throwables.printStackTrace();
                                \n } finally {
                                \n DBUtils.close(rs);
                                \n DBUtils.close(prep);
                                \n DBUtils.close(conn);
                                \n }
                                \n return 0L;
                                \n}<\/p>\n

                                \u5341\u4e09\u3001\u6570\u636e\u5e93\u8fde\u63a5\u6c60<\/h3>\n

                                13.1 \u4ec0\u4e48\u662f\u8fde\u63a5\u6c60<\/h4>\n

                                \u8fde\u63a5\u6c60\u662f\u7ba1\u7406\u6570\u636e\u5e93\u8fde\u63a5\u7684\u7f13\u51b2\u6c60\u6280\u672f，\u521d\u59cb\u5316\u65f6\u521b\u5efa\u4e00\u5b9a\u6570\u91cf\u7684\u8fde\u63a5\u5e76\u5b58\u50a8\u5728\u5185\u5b58\u4e2d，\u7a0b\u5e8f\u9700\u8981\u65f6\u4ece\u6c60\u4e2d\u83b7\u53d6，\u4f7f\u7528\u5b8c\u6bd5\u540e\u5f52\u8fd8（\u800c\u975e\u5173\u95ed），\u5b9e\u73b0\u8fde\u63a5\u590d\u7528\u3002<\/p>\n

                                13.2 \u4e3a\u4ec0\u4e48\u4f7f\u7528\u8fde\u63a5\u6c60<\/h4>\n
                                  \n
                                • \u8fde\u63a5\u7684\u521b\u5efa\u548c\u9500\u6bc1\u6d88\u8017\u8d44\u6e90，\u590d\u7528\u8fde\u63a5\u53ef\u63d0\u5347\u7cfb\u7edf\u6027\u80fd\u3002<\/li>\n
                                • \u63a7\u5236\u6700\u5927\u8fde\u63a5\u6570，\u907f\u514d\u6570\u636e\u5e93\u8fde\u63a5\u8017\u5c3d\u3002<\/li>\n
                                • \u7edf\u4e00\u7ba1\u7406\u8fde\u63a5，\u7b80\u5316\u8d44\u6e90\u91ca\u653e\u903b\u8f91\u3002<\/li>\n<\/ul>\n

                                  13.3 \u8fde\u63a5\u6c60\u7684\u5de5\u4f5c\u539f\u7406<\/h4>\n
                                • \u670d\u52a1\u5668\u542f\u52a8\u65f6，\u8fde\u63a5\u6c60\u521d\u59cb\u5316\u6307\u5b9a\u6570\u91cf\u7684\u8fde\u63a5\u3002<\/li>\n
                                • \u7a0b\u5e8f\u8bf7\u6c42\u8fde\u63a5\u65f6，\u4ece\u6c60\u4e2d\u53d6\u51fa\u7a7a\u95f2\u8fde\u63a5\u3002<\/li>\n
                                • \u7a0b\u5e8f\u4f7f\u7528\u5b8c\u6bd5\u540e，\u5c06\u8fde\u63a5\u5f52\u8fd8\u6c60（\u800c\u975e\u5173\u95ed）\u3002<\/li>\n
                                • \u8fde\u63a5\u6c60\u52a8\u6001\u7ef4\u62a4\u8fde\u63a5\u6570\u91cf（\u5982\u8fbe\u5230\u6700\u5927\u8fde\u63a5\u6570\u5219\u7b49\u5f85，\u7a7a\u95f2\u8fde\u63a5\u8fc7\u5c11\u5219\u65b0\u589e）\u3002<\/li>\n

                                  \"\"<\/p>\n

                                  13.4 \u81ea\u5b9a\u4e49\u8fde\u63a5\u6c60<\/h4>\n

                                  java<\/p>\n

                                  import java.sql.Connection;
                                  \nimport java.sql.DriverManager;
                                  \nimport java.sql.SQLException;
                                  \nimport java.util.LinkedList;
                                  \nimport java.util.Queue;<\/p>\n

                                  public class MyDataSource {
                                  \n \/\/ \u5b58\u50a8\u8fde\u63a5\u7684\u961f\u5217
                                  \n private static final Queue<Connection> connectionQueue = new LinkedList<>();
                                  \n \/\/ \u6570\u636e\u5e93\u914d\u7f6e
                                  \n private static final String URL = "jdbc:mysql:\/\/localhost:3306\/jdbc_db";
                                  \n private static final String USER = "root";
                                  \n private static final String PASSWORD = "1111";
                                  \n \/\/ \u521d\u59cb\u8fde\u63a5\u6570
                                  \n private int initSize;<\/p>\n

                                  \/**
                                  \n * \u6784\u9020\u65b9\u6cd5：\u521d\u59cb\u5316\u8fde\u63a5\u6c60
                                  \n * @param initSize \u521d\u59cb\u8fde\u63a5\u6570
                                  \n *\/
                                  \n public MyDataSource(int initSize) {
                                  \n this.initSize = initSize;
                                  \n try {
                                  \n Class.forName("com.mysql.jdbc.Driver");
                                  \n \/\/ \u521b\u5efa\u521d\u59cb\u8fde\u63a5\u5e76\u653e\u5165\u961f\u5217
                                  \n for (int i = 0; i < initSize; i++) {
                                  \n Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
                                  \n connectionQueue.offer(conn);
                                  \n }
                                  \n System.out.println("\u8fde\u63a5\u6c60\u521d\u59cb\u5316\u5b8c\u6210，\u521d\u59cb\u8fde\u63a5\u6570：" + this.initSize);
                                  \n } catch (ClassNotFoundException | SQLException e) {
                                  \n throw new RuntimeException("\u8fde\u63a5\u6c60\u521d\u59cb\u5316\u5931\u8d25", e);
                                  \n }
                                  \n }<\/p>\n

                                  \/**
                                  \n * \u83b7\u53d6\u8fde\u63a5
                                  \n *\/
                                  \n public Connection getConnection() {
                                  \n Connection conn = connectionQueue.poll();
                                  \n if (conn == null) {
                                  \n System.out.println("\u5f53\u524d\u65e0\u53ef\u7528\u8fde\u63a5！");
                                  \n return null;
                                  \n }
                                  \n System.out.println("\u83b7\u53d6\u8fde\u63a5\u6210\u529f，\u5269\u4f59\u53ef\u7528\u8fde\u63a5\u6570：" + connectionQueue.size());
                                  \n return conn;
                                  \n }<\/p>\n

                                  \/**
                                  \n * \u5f52\u8fd8\u8fde\u63a5
                                  \n *\/
                                  \n public void releaseConnection(Connection conn) {
                                  \n if (conn == null) {
                                  \n return;
                                  \n }
                                  \n connectionQueue.offer(conn);
                                  \n System.out.println("\u8fde\u63a5\u5f52\u8fd8\u6210\u529f，\u5269\u4f59\u53ef\u7528\u8fde\u63a5\u6570：" + connectionQueue.size());
                                  \n }
                                  \n}<\/p>\n

                                  \u6d4b\u8bd5\u81ea\u5b9a\u4e49\u8fde\u63a5\u6c60<\/h5>\n

                                  java<\/p>\n

                                  import java.sql.Connection;
                                  \nimport java.sql.PreparedStatement;
                                  \nimport java.sql.ResultSet;<\/p>\n

                                  public class MyDataSourceTest {
                                  \n public static void main(String[] args) throws Exception {
                                  \n \/\/ 1. \u521b\u5efa\u8fde\u63a5\u6c60（\u521d\u59cb5\u4e2a\u8fde\u63a5）
                                  \n MyDataSource pool = new MyDataSource(5);<\/p>\n

                                  \/\/ 2. \u83b7\u53d6\u8fde\u63a5
                                  \n Connection conn1 = pool.getConnection();<\/p>\n

                                  \/\/ 3. \u6267\u884c\u67e5\u8be2
                                  \n String sql = "SELECT * FROM student";
                                  \n PreparedStatement pst = conn1.prepareStatement(sql);
                                  \n ResultSet rs = pst.executeQuery();
                                  \n while (rs.next()) {
                                  \n System.out.println(rs.getInt("id") + "\\\\t" + rs.getString("name") + "\\\\t" + rs.getInt("age"));
                                  \n }<\/p>\n

                                  \/\/ 4. \u5f52\u8fd8\u8fde\u63a5
                                  \n pool.releaseConnection(conn1);<\/p>\n

                                  \/\/ 5. \u518d\u6b21\u83b7\u53d6\u8fde\u63a5
                                  \n Connection conn2 = pool.getConnection();
                                  \n pool.releaseConnection(conn2);
                                  \n }
                                  \n}<\/p>\n

                                  13.5 \u4e3b\u6d41\u8fde\u63a5\u6c60\u4ecb\u7ecd<\/h4>\n\n\u8fde\u63a5\u6c60\u7279\u70b9<\/tr>\n\n\n\n\n\n
                                  C3P0<\/td>\n\u8001\u724c\u8fde\u63a5\u6c60，\u529f\u80fd\u5b8c\u5584\u4f46\u6027\u80fd\u4e00\u822c，\u9010\u6e10\u6dd8\u6c70<\/td>\n<\/tr>\n
                                  DBCP<\/td>\nApache \u5f00\u6e90，\u7a33\u5b9a\u4f46\u914d\u7f6e\u590d\u6742<\/td>\n<\/tr>\n
                                  Druid<\/td>\n\u963f\u91cc\u5f00\u6e90，\u6027\u80fd\u4f18\u5f02，\u652f\u6301\u76d1\u63a7\u3001\u9632 SQL \u6ce8\u5165，\u63a8\u8350\u4f7f\u7528<\/td>\n<\/tr>\n
                                  Hikari<\/td>\n\u8f7b\u91cf\u7ea7，\u6027\u80fd\u6781\u81f4，SpringBoot \u9ed8\u8ba4\u96c6\u6210<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                  13.6 Druid \u8fde\u63a5\u6c60\u5b9e\u6218<\/h4>\n

                                  \u5f15\u5165 Druid \u4f9d\u8d56（Maven）<\/h5>\n

                                  xml<\/p>\n

                                  <dependency>
                                  \n <groupId>com.alibaba<\/groupId>
                                  \n <artifactId>druid<\/artifactId>
                                  \n <version>1.2.15<\/version>
                                  \n<\/dependency><\/p>\n

                                  Druid \u4f7f\u7528\u6848\u4f8b<\/h5>\n

                                  java<\/p>\n

                                  import com.alibaba.druid.pool.DruidDataSource;
                                  \nimport java.sql.Connection;
                                  \nimport java.sql.PreparedStatement;
                                  \nimport java.sql.ResultSet;
                                  \nimport java.sql.SQLException;<\/p>\n

                                  public class DruidDataSourceTest {
                                  \n \/\/ \u521d\u59cb\u5316Druid\u8fde\u63a5\u6c60
                                  \n private static DruidDataSource initDruidDataSource() {
                                  \n DruidDataSource ds = new DruidDataSource();
                                  \n \/\/ \u57fa\u7840\u914d\u7f6e
                                  \n ds.setUrl("jdbc:mysql:\/\/localhost:3306\/jdbc_db");
                                  \n ds.setUsername("root");
                                  \n ds.setPassword("1111");
                                  \n \/\/ \u8fde\u63a5\u6c60\u914d\u7f6e
                                  \n ds.setInitialSize(2); \/\/ \u521d\u59cb\u8fde\u63a5\u6570
                                  \n ds.setMaxActive(5); \/\/ \u6700\u5927\u6d3b\u8dc3\u8fde\u63a5\u6570
                                  \n ds.setMinIdle(1); \/\/ \u6700\u5c0f\u7a7a\u95f2\u8fde\u63a5\u6570
                                  \n return ds;
                                  \n }<\/p>\n

                                  public static void main(String[] args) throws SQLException {
                                  \n DruidDataSource ds = initDruidDataSource();
                                  \n \/\/ \u83b7\u53d6\u8fde\u63a5（Druid\u81ea\u52a8\u7ba1\u7406\u8fde\u63a5\u751f\u547d\u5468\u671f）
                                  \n Connection conn1 = ds.getConnection();
                                  \n System.out.println("\u83b7\u53d6\u8fde\u63a51\u6210\u529f，\u5269\u4f59\u53ef\u7528\u8fde\u63a5\u6570：" + ds.getPoolingCount());<\/p>\n

                                  \/\/ \u6267\u884c\u67e5\u8be2
                                  \n String sql = "SELECT * FROM student";
                                  \n PreparedStatement pst = conn1.prepareStatement(sql);
                                  \n ResultSet rs = pst.executeQuery();
                                  \n while (rs.next()) {
                                  \n System.out.println(rs.getInt("id") + "\\\\t" + rs.getString("name") + "\\\\t" + rs.getInt("age"));
                                  \n }<\/p>\n

                                  \/\/ \u5f52\u8fd8\u8fde\u63a5（Druid\u91cd\u5199close()\u65b9\u6cd5，\u5b9e\u9645\u662f\u5f52\u8fd8\u8fde\u63a5）
                                  \n conn1.close();
                                  \n System.out.println("\u5f52\u8fd8\u8fde\u63a51，\u5269\u4f59\u53ef\u7528\u8fde\u63a5\u6570：" + ds.getPoolingCount());<\/p>\n

                                  \/\/ \u518d\u6b21\u83b7\u53d6\u8fde\u63a5
                                  \n Connection conn2 = ds.getConnection();
                                  \n System.out.println("\u83b7\u53d6\u8fde\u63a52\u6210\u529f，\u5269\u4f59\u53ef\u7528\u8fde\u63a5\u6570：" + ds.getPoolingCount());
                                  \n conn2.close();
                                  \n }
                                  \n}<\/p>\n

                                  13.7 \u6539\u9020 DBUtils \u6574\u5408 Druid<\/h4>\n

                                  java<\/p>\n

                                  import com.alibaba.druid.pool.DruidDataSource;
                                  \nimport java.io.InputStream;
                                  \nimport java.sql.Connection;
                                  \nimport java.sql.SQLException;
                                  \nimport java.util.Properties;<\/p>\n

                                  public class DBUtils {
                                  \n private static String DRIVER;
                                  \n private static String URL;
                                  \n private static String USER_NAME;
                                  \n private static String USER_PASSWORD;
                                  \n private static DruidDataSource ds; \/\/ Druid\u8fde\u63a5\u6c60<\/p>\n

                                  static {
                                  \n try {
                                  \n \/\/ \u52a0\u8f7d\u914d\u7f6e\u6587\u4ef6
                                  \n InputStream is = DBUtils.class.getClassLoader().getResourceAsStream("db.properties");
                                  \n Properties prop = new Properties();
                                  \n prop.load(is);
                                  \n DRIVER = prop.getProperty("driverClass");
                                  \n URL = prop.getProperty("url");
                                  \n USER_NAME = prop.getProperty("username");
                                  \n USER_PASSWORD = prop.getProperty("password");<\/p>\n

                                  \/\/ \u521d\u59cb\u5316Druid\u8fde\u63a5\u6c60
                                  \n Class.forName(DRIVER);
                                  \n ds = new DruidDataSource();
                                  \n ds.setUrl(URL);
                                  \n ds.setUsername(USER_NAME);
                                  \n ds.setPassword(USER_PASSWORD);
                                  \n \/\/ \u53ef\u9009：\u914d\u7f6e\u8fde\u63a5\u6c60\u53c2\u6570
                                  \n ds.setInitialSize(2);
                                  \n ds.setMaxActive(5);
                                  \n } catch (Exception e) {
                                  \n e.printStackTrace();
                                  \n }
                                  \n }<\/p>\n

                                  \/\/ \u83b7\u53d6\u8fde\u63a5（\u4eceDruid\u6c60\u83b7\u53d6）
                                  \n public static Connection getConn() {
                                  \n try {
                                  \n return ds.getConnection();
                                  \n } catch (SQLException e) {
                                  \n e.printStackTrace();
                                  \n System.out.println("\u521b\u5efa\u8fde\u63a5\u5bf9\u8c61\u5f02\u5e38");
                                  \n }
                                  \n return null;
                                  \n }<\/p>\n

                                  \/\/ \u91ca\u653e\u8d44\u6e90（Druid\u81ea\u52a8\u5f52\u8fd8\u8fde\u63a5）
                                  \n public static void close(AutoCloseable closeable) {
                                  \n try {
                                  \n if (closeable != null) {
                                  \n closeable.close();
                                  \n }
                                  \n } catch (Exception e) {
                                  \n e.printStackTrace();
                                  \n }
                                  \n }
                                  \n}<\/p>\n","protected":false},"excerpt":{"rendered":"

                                  \u5f15\u8a00：\u5b66\u4e60\u76ee\u6807
                                  \n\u77e5\u8bc6\u70b9\u8981\u6c42JDBC \u6982\u8ff0\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u6dfb\u52a0\u64cd\u4f5c\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u66f4\u65b0\u548c\u5220\u9664\u638c\u63e1DBUtils \u7684\u7b80\u5355\u5c01\u88c5\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u67e5\u8be2\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u5206\u9875\u67e5\u8be2\u638c\u63e1\u5e38\u7528\u63a5\u53e3\u8be6\u89e3\u638c\u63e1JDBC \u6279\u5904\u7406\u638c\u63e1SQL \u6ce8\u5165\u95ee\u9898\u638c\u63e1\u4e8b\u52a1\u5904\u7406\u89e3\u51b3\u8f6c\u8d26\u95ee\u9898\u638c\u63e1\u8fde\u63a5\u6c60\u638c\u63e1\u4f7f\u7528\u53cd\u5c04\u5bf9 DBUtils \u518d\u6b21\u7684\u5c01\u88c5\u638c\u63e1BaseDAO \u7684\u5c01\u88c5\u638c\u63e1
                                  \n\u4e00\u3001JDBC \u6982\u8ff0
                                  \n1.1 \u4e3a\u4ec0\u4e48\u8981\u5b66\u4e60 JDBC？
                                  \n\u5982\u7528\u6237\u63d0\u4ea4\u8868\u5355\u65f6&#xff0c<\/p>\n","protected":false},"author":2,"featured_media":67835,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[386,99,87,100],"topic":[],"class_list":["post-67843","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-intellij-idea","tag-java","tag-87","tag-100"],"yoast_head":"\nJDBC \u5168\u89e3\u6790\uff1a \u4ece\u5165\u95e8\u5230\u7cbe\u901a - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\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.wsisp.com\/helps\/67843.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JDBC \u5168\u89e3\u6790\uff1a \u4ece\u5165\u95e8\u5230\u7cbe\u901a - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u5f15\u8a00：\u5b66\u4e60\u76ee\u6807 \u77e5\u8bc6\u70b9\u8981\u6c42JDBC \u6982\u8ff0\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u6dfb\u52a0\u64cd\u4f5c\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u66f4\u65b0\u548c\u5220\u9664\u638c\u63e1DBUtils \u7684\u7b80\u5355\u5c01\u88c5\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u67e5\u8be2\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u5206\u9875\u67e5\u8be2\u638c\u63e1\u5e38\u7528\u63a5\u53e3\u8be6\u89e3\u638c\u63e1JDBC \u6279\u5904\u7406\u638c\u63e1SQL \u6ce8\u5165\u95ee\u9898\u638c\u63e1\u4e8b\u52a1\u5904\u7406\u89e3\u51b3\u8f6c\u8d26\u95ee\u9898\u638c\u63e1\u8fde\u63a5\u6c60\u638c\u63e1\u4f7f\u7528\u53cd\u5c04\u5bf9 DBUtils \u518d\u6b21\u7684\u5c01\u88c5\u638c\u63e1BaseDAO \u7684\u5c01\u88c5\u638c\u63e1 \u4e00\u3001JDBC \u6982\u8ff0 1.1 \u4e3a\u4ec0\u4e48\u8981\u5b66\u4e60 JDBC？ \u5982\u7528\u6237\u63d0\u4ea4\u8868\u5355\u65f6&#xff0c\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/67843.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-29T00:57:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129005702-697ab05ee40f8.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/67843.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/67843.html\",\"name\":\"JDBC \u5168\u89e3\u6790\uff1a \u4ece\u5165\u95e8\u5230\u7cbe\u901a - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-01-29T00:57:05+00:00\",\"dateModified\":\"2026-01-29T00:57:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/67843.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/67843.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/67843.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JDBC \u5168\u89e3\u6790\uff1a \u4ece\u5165\u95e8\u5230\u7cbe\u901a\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"JDBC \u5168\u89e3\u6790\uff1a \u4ece\u5165\u95e8\u5230\u7cbe\u901a - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","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.wsisp.com\/helps\/67843.html","og_locale":"zh_CN","og_type":"article","og_title":"JDBC \u5168\u89e3\u6790\uff1a \u4ece\u5165\u95e8\u5230\u7cbe\u901a - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u5f15\u8a00：\u5b66\u4e60\u76ee\u6807 \u77e5\u8bc6\u70b9\u8981\u6c42JDBC \u6982\u8ff0\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u6dfb\u52a0\u64cd\u4f5c\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u66f4\u65b0\u548c\u5220\u9664\u638c\u63e1DBUtils \u7684\u7b80\u5355\u5c01\u88c5\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u67e5\u8be2\u638c\u63e1\u4f7f\u7528 JDBC \u5b8c\u6210\u5206\u9875\u67e5\u8be2\u638c\u63e1\u5e38\u7528\u63a5\u53e3\u8be6\u89e3\u638c\u63e1JDBC \u6279\u5904\u7406\u638c\u63e1SQL \u6ce8\u5165\u95ee\u9898\u638c\u63e1\u4e8b\u52a1\u5904\u7406\u89e3\u51b3\u8f6c\u8d26\u95ee\u9898\u638c\u63e1\u8fde\u63a5\u6c60\u638c\u63e1\u4f7f\u7528\u53cd\u5c04\u5bf9 DBUtils \u518d\u6b21\u7684\u5c01\u88c5\u638c\u63e1BaseDAO \u7684\u5c01\u88c5\u638c\u63e1 \u4e00\u3001JDBC \u6982\u8ff0 1.1 \u4e3a\u4ec0\u4e48\u8981\u5b66\u4e60 JDBC？ \u5982\u7528\u6237\u63d0\u4ea4\u8868\u5355\u65f6&#xff0c","og_url":"https:\/\/www.wsisp.com\/helps\/67843.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-01-29T00:57:05+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129005702-697ab05ee40f8.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"16 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/67843.html","url":"https:\/\/www.wsisp.com\/helps\/67843.html","name":"JDBC \u5168\u89e3\u6790\uff1a \u4ece\u5165\u95e8\u5230\u7cbe\u901a - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-01-29T00:57:05+00:00","dateModified":"2026-01-29T00:57:05+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/67843.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/67843.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/67843.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"JDBC \u5168\u89e3\u6790\uff1a \u4ece\u5165\u95e8\u5230\u7cbe\u901a"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/67843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=67843"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/67843\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/67835"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=67843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=67843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=67843"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=67843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}