{"id":1579,"date":"2016-05-11T09:37:20","date_gmt":"2016-05-11T01:37:20","guid":{"rendered":"https:\/\/ai.zhousir.top\/?p=1579"},"modified":"2026-08-18T12:09:36","modified_gmt":"2026-08-18T04:09:36","slug":"java%e7%a8%8b%e5%ba%8f%e4%b8%8e%e6%95%b0%e6%8d%ae%e5%ba%93%e8%bf%9e%e6%8e%a5","status":"publish","type":"post","link":"https:\/\/ai.zhousir.top\/?p=1579","title":{"rendered":"Java\u7a0b\u5e8f\u4e0e\u6570\u636e\u5e93\u8fde\u63a5"},"content":{"rendered":"
\n

\u4e00\u4e2a\u7f51\u7edc\u5173\u7cfb\u6570\u636e\u5e93\u5e94\u7528\u7cfb\u7edf\u662f\u4e09\u5c42\u6b21\u7ed3\u6784\uff1a\u5ba2\u6237\u673a\u4e0e\u670d\u52a1\u5668\u7528\u7f51\u7edc\u8fde\u63a5\uff0c\u5ba2\u6237\u7aef\u6309\u901a\u4fe1\u534f\u8bae\u4e0e\u670d\u52a1\u5668\u7aef\u6570\u636e\u5e93\u7a0b\u5e8f\u901a\u4fe1\uff1b\u6570\u636e\u5e93\u670d\u52a1\u7a0b\u5e8f\u901a\u8fc7 SQL \u547d\u4ee4\u4e0e\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u901a\u4fe1\u3002<\/p>\n

<\/p>\n

Java \u7a0b\u5e8f\u8fde\u5e93\u6709\u4e24\u79cd\uff1aJDBC-ODBC \u6865<\/strong>\uff0c\u4ee5\u53ca\u7eaf Java \u7684 JDBC \u9a71\u52a8<\/strong>\u3002JDBC\uff08Java DataBase Connectivity\uff09\u7531\u4e00\u7ec4 Java \u7c7b\u548c\u63a5\u53e3\u7ec4\u6210\uff0c\u80fd\u505a\u4e09\u4ef6\u4e8b\uff1a\u5efa\u7acb\u8fde\u63a5\u3001\u53d1\u9001 SQL\u3001\u5904\u7406\u8fd4\u56de\u7ed3\u679c\u3002<\/p>\n

\u4e00\u3001JDBC-ODBC \u6865<\/h2>\n

\u901a\u4fe1\u8fc7\u7a0b\uff1a\u5e94\u7528\u7a0b\u5e8f\u5411 ODBC \u9a71\u52a8\u7ba1\u7406\u5668\u53d1 API \u8c03\u7528 \u2192 \u8f6c\u6210\u5bf9 DBMS \u7684 ODBC \u9a71\u52a8\u8c03\u7528 \u2192 DBMS \u518d\u8f6c\u6210\u64cd\u4f5c\u7cfb\u7edf\u7684\u6570\u636e I\/O \u2192 \u6570\u636e\u9010\u7ea7\u8fd4\u56de\u3002<\/p>\n

\u7f16\u7a0b\u524d\u8981\u8bbe\u6570\u636e\u6e90\u3002\u5728 ODBC \u4e2d\uff1a\u6253\u5f00\u63a7\u5236\u9762\u677f\u7ba1\u7406\u5de5\u5177\u3002Windows XP\uff1a\u6027\u80fd\u7ef4\u62a4 \u2192 \u7ba1\u7406\u5de5\u5177 \u2192 \u6570\u636e\u6e90(ODBC)\uff1bWindows 2000\uff1a\u7ba1\u7406\u5de5\u5177 \u2192 \u6570\u636e\u6e90\u3002\u6253\u5f00\u540e\u663e\u793a\u73b0\u6709\u6570\u636e\u6e90\u540d\u3002\u9009\u201c\u7528\u6237 DSN\u201d\uff0c\u70b9\u201c\u6dfb\u52a0\u201d\uff0c\u9009 Access(*.mdb) \u70b9\u5b8c\u6210\uff0c\u952e\u5165\u6570\u636e\u6e90\u540d\u5e76\u9009\u4e00\u4e2a\u6570\u636e\u5e93\u8868\u3002\u70b9\u6570\u636e\u5e93\u533a\u57df\u7684\u201c\u9009\u62e9\u201d\u3002\u9700\u8981\u6388\u6743\u65f6\u70b9\u201c\u9ad8\u7ea7\u201d\uff0c\u8bbe\u767b\u5f55\u540d\u548c\u5bc6\u7801\u540e\u786e\u5b9a\u3002\u82e5\u8fd8\u6ca1\u6709\u8868\uff0c\u5148\u5efa\u8868\u3002<\/p>\n

\u6570\u636e\u6e90\u5c31\u662f\u6570\u636e\u5e93\u3002\u8bbe\u597d\u540e\u8fd8\u8981\u5efa\u7acb JDBC-ODBC \u6865\uff0c\u7a0b\u5e8f\u624d\u80fd\u53d1 SQL\u3001\u5904\u7406\u7ed3\u679c\u3002\u8c03\u7528 Class.forName(String s)<\/code> \u52a0\u8f7d\u9a71\u52a8\uff1a<\/p>\n

try {\n    Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\");\n} catch (Exception e) {}<\/code><\/pre>\n
\u3010\u4f8b 13-7\u3011\u65b9\u6cd5 connectByJdbcOdbc()<\/code> \u6309\u7ed9\u5b9a\u6570\u636e\u5e93 URL\u3001\u7528\u6237\u540d\u548c\u5bc6\u7801\u8fde\u63a5\uff0c\u6210\u529f\u8fd4\u56de\u8fde\u63a5\u5bf9\u8c61\uff0c\u5931\u8d25\u8fd4\u56de\u7a7a\u3002<\/p>\n
\u6ce8\u610f\uff1aJDK 8 \u5df2\u79fb\u9664 JDBC-ODBC \u6865\uff08sun.jdbc.odbc.JdbcOdbcDriver<\/code>\uff09\uff0c\u65b0\u9879\u76ee\u8bf7\u7528\u7eaf JDBC \u9a71\u52a8\u3002<\/p>\n
\u4e8c\u3001\u7eaf Java JDBC \u9a71\u52a8<\/h2>\n
\u5e94\u7528\u66f4\u5e7f\uff0c\u4f46\u8981\u4e0b\u8f7d\u5bf9\u5e94\u9a71\u52a8\u5305\uff0c\u4e0d\u540c\u5e93\u52a0\u8f7d\u7684\u7c7b\u540d\u4e5f\u4e0d\u540c\u3002\u8fde\u63a5 SQL Server \u53ef\u4ece www.msdn.com \u4e0b\u8f7d msbase.jar\u3001mssqlserver.jar\u3001msutil.jar\uff0c\u653e\u5230 jdk\\jre\\lib\\ext\\ \u6216\u5199\u5165 CLASSPATH\u3002\u8fde\u63a5 MySQL \u7528\u4e00\u4e2a\u5305\uff1amysql-connector-java-3.1.11-bin.jar<\/code>\u3002<\/p>\n
\u52a0\u8f7d\u9a71\u52a8\u6709\u4e24\u79cd\uff1a\u628a\u9a71\u52a8\u7c7b\u540d\u52a0\u5230 java.lang.System<\/code> \u5c5e\u6027 jdbc.drivers<\/code>\uff08\u5192\u53f7\u5206\u9694\u7684\u5217\u8868\uff09\uff1b\u6216\u4e0b\u8f7d\u540e\u5728\u7a0b\u5e8f\u91cc Class.forName()<\/code>\uff1a<\/p>\n
Class.forName(\"com.microsoft.jdbc.sqlserver.SQLServerDriver\");\nClass.forName(\"com.mysql.jdbc.Driver\"); \/\/ \u52a0\u8f7d\u7279\u5b9a\u7684\u9a71\u52a8\u7a0b\u5e8f<\/code><\/pre>\n
\u6570\u636e\u5e93 URL \u7c7b\u4f3c\u7f51\u7edc\u5b9a\u4f4d\u7b26\uff0c\u683c\u5f0f subprotocol:subName:\/\/hostName:port\/DatabaseName<\/code>\u3002subprotocol \u662f\u9a71\u52a8\u652f\u6301\u7684\u8fde\u63a5\u673a\u5236\uff0csubName \u662f\u8be5\u673a\u5236\u4e0b\u7684\u5177\u4f53\u540d\u79f0\u3002\u4f8b\u5982\uff08\u539f\u6587 Microsoft \u5927\u5c0f\u5199\u4e0d\u7edf\u4e00\uff0c\u8fd9\u91cc\u6309\u5e38\u89c1\u5199\u6cd5\uff09\uff1a<\/p>\n
jdbc:microsoft:sqlserver:\/\/localhost:1433;DatabaseName=ksinfo\njdbc:mysql:\/\/localhost:3306\/\u6570\u636e\u5e93\u540d<\/code><\/pre>\n
\u8be5 URL \u8868\u793a\u7528 Microsoft \u673a\u5236\u3001SQL Server \u9a71\u52a8\u30011433 \u7aef\u53e3\u8bbf\u95ee\u672c\u673a ksinfo \u5e93\u3002\u5efa\u7acb\u8fde\u63a5\u7528 DriverManager.getConnection()<\/code>\u3002<\/p>\n
\u8fde\u63a5\u6b65\u9aa4<\/h3>\n
    \n
  • \n
    \u4e0b\u8f7d\u9a71\u52a8\u5305\uff0c\u5982 mysql-connector-java-3.1.11-bin.jar<\/section>\n<\/li>\n
  • \n
    Class.forName(\"com.mysql.jdbc.Driver\")<\/code><\/section>\n<\/li>\n
  • \n
    Connection con = DriverManager.getConnection(\"jdbc:mysql:\/\/localhost:3306\/\u6570\u636e\u5e93\u540d\", username, password)<\/code><\/section>\n<\/li>\n<\/ul>\n
    \u3010\u4f8b 13-8\u3011\u9759\u6001\u65b9\u6cd5\u6309 URL\u3001\u7528\u6237\u540d\u3001\u5bc6\u7801\u8fde\u63a5\uff0c\u6210\u529f\u8fd4\u56de Connection\uff08\u539f\u6587\u65b9\u6cd5\u540d conectByJdbc\u3001DriverManage \u4e3a\u7b14\u8bef\uff0c\u4e0b\u9762\u6309\u6b63\u786e API \u5199\u51fa\uff09\uff1a<\/p>\n
    public static Connection connectByJdbc(String url, String username, String password) {\n    String url = \"jdbc:mysql:\/\/localhost:3306\/scxh\";\n    Connection con = null;\n    try {\n        Class.forName(\"com.mysql.jdbc.Driver\"); \/\/ \u52a0\u8f7d\u7279\u5b9a\u7684\u9a71\u52a8\u7a0b\u5e8f\n    } catch (Exception e) {\n        e.printStackTrace();\n        return null; \/\/ \u8fde\u63a5\u5931\u8d25\n    }\n    try {\n        con = DriverManager.getConnection(url, username, password);\n    } catch (SQLException e) {\n        e.printStackTrace();\n        return null; \/\/ \u8fde\u63a5\u5931\u8d25\n    }\n    return con; \/\/ \u8fde\u63a5\u6210\u529f\n}<\/code><\/pre>\n
    \u4e09\u3001DriverManager \u4e0e Connection<\/h2>\n
    DriverManager<\/code> \u8d1f\u8d23\u52a0\u8f7d\u9a71\u52a8\u3001\u5efa\u7acb\u65b0\u8fde\u63a5\u3002\u5e94\u7528\u7a0b\u5e8f\u901a\u5e38\u53ea\u7528\u9759\u6001\u65b9\u6cd5 getConnection(String url, String username, String password)<\/code>\u3002\u6865\u63a5\u4e0b url \u5f62\u5982 jdbc:<\u8fde\u63a5\u673a\u5236>:<ODBC \u6570\u636e\u6e90\u540d><\/code>\u3002<\/p>\n
    Connection<\/code> \u8868\u793a\u4e0e\u7279\u5b9a\u6570\u636e\u5e93\u7684\u8fde\u63a5\uff0c\u5bf9\u5e93\u7684\u64cd\u4f5c\u90fd\u5728\u8fd9\u4e2a\u5bf9\u8c61\u4e0a\u8fdb\u884c\u3002\u4e3b\u8981\u65b9\u6cd5\uff1a<\/p>\n
    Statement createStatement()\nStatement createStatement(int resultSetType, int resultSetConcurrency)\nvoid commit()       \/\/ \u63d0\u4ea4\u6539\u52a8\u5e76\u91ca\u653e\u5f53\u524d\u6301\u6709\u7684\u9501\nvoid rollback()     \/\/ \u56de\u6eda\u5f53\u524d\u4e8b\u52a1\u4e2d\u7684\u6240\u6709\u6539\u52a8\nString getCatalog() \/\/ \u83b7\u5f97\u8fde\u63a5\u5bf9\u8c61\u7684\u5f53\u524d\u76ee\u5f55\nboolean isClosed()  \/\/ \u5224\u65ad\u8fde\u63a5\u662f\u5426\u5df2\u5173\u95ed\nboolean isReadOnly()\nvoid setReadOnly()\nvoid close()        \/\/ \u91ca\u653e\u8fde\u63a5\u5bf9\u8c61\u7684\u6570\u636e\u5e93\u548c JDBC \u8d44\u6e90<\/code><\/pre>\n
    \u56db\u3001Statement \u4e0e ResultSet<\/h2>\n
    \u6570\u636e\u5e93\u7f16\u7a0b\u8981\u70b9\u662f\u5d4c\u5165 SQL\u3002\u5148\u62ff\u5230 Connection<\/code>\uff0c\u518d\u7528 createStatement()<\/code> \u521b\u5efa\u8bed\u53e5\u5bf9\u8c61\uff1a<\/p>\n
    Statement sql = null;\ntry {\n    sql = con.createStatement();\n} catch (SQLException e) {}<\/code><\/pre>\n
    \u8c03\u7528 executeQuery()<\/code> \u6267\u884c\u67e5\u8be2\uff0c\u7ed3\u679c\u653e\u8fdb ResultSet<\/code>\uff0c\u4f8b\u5982 ResultSet rs = sql.executeQuery(\"SELECT * FROM ksInfo\")<\/code>\u3002ResultSet \u5b9e\u9645\u662f\u67e5\u8be2\u7ed3\u679c\u8868\uff0c\u4e00\u884c\u4e00\u6761\u8bb0\u5f55\u3002\u9690\u542b\u6e38\u6807\uff0c\u4e00\u6b21\u53ea\u80fd\u770b\u5230\u5f53\u524d\u884c\uff0cnext()<\/code> \u53d6\u4e0b\u4e00\u884c\u3002\u7528\u5217\u540d\u6216\u4ece 1 \u5f00\u59cb\u7684\u4f4d\u7f6e\u7d22\u5f15\u8c03\u7528 getXXX()<\/code>\uff1a<\/p>\n
    byte getByte(int columnIndex)\nDate getDate(int columnIndex)\nfloat getFloat(int columnIndex)\nint getInt(int columnIndex)\nString getString(int columnIndex)\ndouble getDouble(String columnName)\nlong getLong(String columnName)\nboolean next()  \/\/ \u662f\u5426\u8fd8\u6709\u4e0b\u4e00\u884c<\/code><\/pre>\n
    \u4e94\u3001\u53ef\u6eda\u52a8\u7ed3\u679c\u96c6<\/h2>\n
    \u8981\u524d\u540e\u79fb\u52a8\u6216\u5b9a\u4f4d\u5230\u6307\u5b9a\u8bb0\u5f55\uff0c\u521b\u5efa Statement \u65f6\u589e\u52a0\u4e24\u4e2a\u53c2\u6570\uff1a<\/p>\n
    Statement stmt = con.createStatement(type, concurrency);\nResultSet rs = stmt.executeQuery(SQL\u8bed\u53e5);\n\/\/ type \u51b3\u5b9a\u6eda\u52a8\u65b9\u5f0f\uff1a\n\/\/ ResultSet.TYPE_FORWARD_ONLY  \u6e38\u6807\u53ea\u80fd\u5411\u4e0b\n\/\/ ResultSet.TYPE_SCROLL_INSENSITIVE  \u53ef\u4e0a\u4e0b\u79fb\u52a8\uff0c\u5e93\u53d8\u4e86\u5f53\u524d\u7ed3\u679c\u96c6\u4e0d\u53d8\n\/\/ ResultSet.TYPE_SCROLL_SENSITIVE    \u53ef\u4e0a\u4e0b\u79fb\u52a8\uff0c\u5e93\u53d8\u4e86\u7ed3\u679c\u96c6\u540c\u6b65\u53d8\n\/\/ concurrency \u51b3\u5b9a\u80fd\u5426\u7528\u7ed3\u679c\u96c6\u66f4\u65b0\u8868\uff1a\n\/\/ ResultSet.CONCUR_READ_ONLY\n\/\/ ResultSet.CONCUR_UPDATABLE<\/code><\/pre>\n
    \u4f8b\u5982\u53ea\u8bfb\u3001\u53ef\u6eda\u52a8\uff1a<\/p>\n
    stmt = connect.createStatement(\n    ResultSet.TYPE_SCROLL_SENSITIVE,\n    ResultSet.CONCUR_READ_ONLY);<\/code><\/pre>\n
    \u53ef\u6eda\u52a8\u96c6\u4e0a\u5e38\u7528\u5bfc\u822a\uff1a<\/p>\n
    boolean previous()          \/\/ \u6e38\u6807\u5411\u4e0a\uff0c\u5230\u7b2c\u4e00\u884c\u4e4b\u524d\u8fd4\u56de false\nvoid beforeFirst()          \/\/ \u79fb\u5230\u7b2c\u4e00\u884c\u4e4b\u524d\nvoid afterLast()            \/\/ \u79fb\u5230\u6700\u540e\u4e00\u884c\u4e4b\u540e\nvoid first()\nvoid last()\nboolean isAfterLast()\nboolean isBeforeFirst()\nboolean isLast()\nboolean isFirst()\nint getRow()                \/\/ \u5f53\u524d\u884c\u53f7\u81ea 1 \u8d77\uff0c\u7a7a\u7ed3\u679c\u96c6\u8fd4\u56de 0\nboolean absolute(int row)   \/\/ \u79fb\u5230\u7b2c row \u884c<\/code><\/pre>\n\n\n\n\n\n\n\n\n
    \u7c7b \/ \u63a5\u53e3<\/th>\n\u804c\u8d23<\/th>\n<\/tr>\n<\/thead>\n
    DriverManager<\/td>\n\u52a0\u8f7d\u9a71\u52a8\uff0cgetConnection \u5f97\u5230\u8fde\u63a5<\/td>\n<\/tr>\n
    Connection<\/td>\n\u4ee3\u8868\u4e00\u6b21\u4f1a\u8bdd\uff1a\u5efa Statement\u3001\u63d0\u4ea4\/\u56de\u6eda\u3001\u5173\u95ed<\/td>\n<\/tr>\n
    Statement<\/td>\n\u5728\u6307\u5b9a\u8fde\u63a5\u4e0a\u6267\u884c SQL<\/td>\n<\/tr>\n
    ResultSet<\/td>\n\u67e5\u8be2\u7ed3\u679c\u8868 + \u6e38\u6807\uff0cgetXXX \/ next \/ \u6eda\u52a8\u5b9a\u4f4d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \n
    \u4e00\u53e5\u8bdd\u603b\u7ed3\uff1a\u8fde\u5e93\u5148\u52a0\u8f7d\u9a71\u52a8\u518d getConnection\uff1b\u53d1 SQL \u7528 Statement\uff0c\u8bfb\u7ed3\u679c\u7528 ResultSet \u6e38\u6807\u3002\u6865\u63a5\u5df2\u8fc7\u65f6\uff0c\u751f\u4ea7\u73af\u5883\u7528\u5404\u5e93\u81ea\u5df1\u7684 JDBC \u9a71\u52a8\u3002<\/strong><\/p>\n<\/blockquote>\n<\/section>\n","protected":false},"excerpt":{"rendered":"
    \u4e00\u4e2a\u7f51\u7edc\u5173\u7cfb\u6570\u636e\u5e93\u5e94\u7528\u7cfb\u7edf\u662f\u4e09\u5c42\u6b21\u7ed3\u6784\uff1a\u5ba2\u6237\u673a\u4e0e\u670d\u52a1\u5668\u7528\u7f51\u7edc\u8fde\u63a5\uff0c\u5ba2\u6237\u7aef\u6309\u901a\u4fe1\u534f\u8bae\u4e0e\u670d\u52a1\u5668\u7aef\u6570\u636e\u5e93\u7a0b\u5e8f\u901a\u4fe1\uff1b\u6570 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[61],"tags":[193,192,62],"_links":{"self":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/1579"}],"collection":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1579"}],"version-history":[{"count":3,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/1579\/revisions"}],"predecessor-version":[{"id":1583,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/1579\/revisions\/1583"}],"wp:attachment":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}