{"id":185,"date":"2013-02-01T23:08:32","date_gmt":"2013-02-01T23:08:32","guid":{"rendered":"http:\/\/lg.yusemo.com\/?p=185"},"modified":"2016-08-26T02:15:13","modified_gmt":"2016-08-26T02:15:13","slug":"database-connection-java","status":"publish","type":"post","link":"https:\/\/lg.yusemo.com\/?p=185","title":{"rendered":"java\u5e38\u7528\u6570\u636e\u5e93\u8fde\u63a5\u7684\u9a71\u52a8\u4ee3\u7801"},"content":{"rendered":"
\n
\u7f16\u7801\u8fc7\u7a0b\u4e2d\u65f6\u957f\u4f1a\u60f3\u4e0d\u8d77\u4e66\u5e93\u7684\u9a71\u52a8\u4ee3\u7801\uff0c\u518d\u6b64\u505a\u4e00\u4e2a\u7b14\u8bb0\u3002<\/div>\n
“`<\/div>\n
MySQL\uff1a<\/div>\n
\u00a0 \u00a0 String Driver=”com.mysql.jdbc.Driver”; \u00a0 \u00a0\/\/\u9a71\u52a8\u7a0b\u5e8f<\/div>\n
\u00a0 \u00a0 String URL=”jdbc:mysql:\/\/localhost:3306\/db_name”; \u00a0 \u00a0\/\/\u8fde\u63a5\u7684URL,db_name\u4e3a\u6570\u636e\u5e93\u540d<\/div>\n
\u00a0 \u00a0 String Username=”username”; \u00a0 \u00a0\/\/\u7528\u6237\u540d<\/div>\n
\u00a0 \u00a0 String Password=”password”; \u00a0 \u00a0\/\/\u5bc6\u7801<\/div>\n
\u00a0 \u00a0 Class.forName(Driver).new Instance();<\/div>\n
\u00a0 \u00a0 Connection con=DriverManager.getConnection(URL,Username,Password);<\/div>\n
Microsoft SQL Server 2.0\u9a71\u52a8(3\u4e2ajar\u7684\u90a3\u4e2a):<\/div>\n
\u00a0 \u00a0 String Driver=”com.microsoft.jdbc.sqlserver.SQLServerDriver”; \u00a0 \u00a0\/\/\u8fde\u63a5SQL\u6570\u636e\u5e93\u7684\u65b9\u6cd5<\/div>\n
\u00a0 \u00a0 String URL=”jdbc:microsoft:sqlserver:\/\/localhost:1433;DatabaseName=db_name”; \u00a0 \u00a0\/\/db_name\u4e3a\u6570\u636e\u5e93\u540d<\/div>\n
\u00a0 \u00a0 String Username=”username”; \u00a0 \u00a0\/\/\u7528\u6237\u540d<\/div>\n
\u00a0 \u00a0 String Password=”password”; \u00a0 \u00a0\/\/\u5bc6\u7801<\/div>\n
\u00a0 \u00a0 Class.forName(Driver).new Instance(); \u00a0 \u00a0\/\/\u52a0\u8f7d\u6570\u636e\u53ef\u9a71\u52a8<\/div>\n
\u00a0 \u00a0 Connection con=DriverManager.getConnection(URL,UserName,Password); \u00a0 \u00a0\/\/<\/div>\n
Microsoft SQL Server 3.0\u9a71\u52a8(1\u4e2ajar\u7684\u90a3\u4e2a):<\/div>\n
\u00a0 \u00a0 String Driver=”com.microsoft.sqlserver.jdbc.SQLServerDriver”; \u00a0 \u00a0\/\/\u8fde\u63a5SQL\u6570\u636e\u5e93\u7684\u65b9\u6cd5<\/div>\n
\u00a0 \u00a0 String URL=”jdbc:microsoft:sqlserver:\/\/localhost:1433;DatabaseName=db_name”; \u00a0 \u00a0\/\/db_name\u4e3a\u6570\u636e\u5e93\u540d<\/div>\n
\u00a0 \u00a0 String Username=”username”; \u00a0 \u00a0\/\/\u7528\u6237\u540d<\/div>\n
\u00a0 \u00a0 String Password=”password”; \u00a0 \u00a0\/\/\u5bc6\u7801<\/div>\n
\u00a0 \u00a0 Class.forName(Driver).new Instance(); \u00a0 \u00a0\/\/\u52a0\u8f7d\u6570\u636e\u53ef\u9a71\u52a8<\/div>\n
\u00a0 \u00a0 Connection con=DriverManager.getConnection(URL,UserName,Password); \u00a0 \u00a0\/\/<\/div>\n
Sysbase:<\/div>\n
\u00a0 \u00a0 String Driver=”com.sybase.jdbc.SybDriver”; \u00a0 \u00a0\/\/\u9a71\u52a8\u7a0b\u5e8f<\/div>\n
\u00a0 \u00a0 String URL=”jdbc:Sysbase:\/\/localhost:5007\/db_name”; \u00a0 \u00a0\/\/db_name\u4e3a\u6570\u636e\u53ef\u540d<\/div>\n
\u00a0 \u00a0 String Username=”username”; \u00a0 \u00a0\/\/\u7528\u6237\u540d<\/div>\n
\u00a0 \u00a0 String Password=”password”; \u00a0 \u00a0\/\/\u5bc6\u7801<\/div>\n
\u00a0 \u00a0 Class.forName(Driver).newInstance();<\/div>\n
\u00a0 \u00a0 Connection con=DriverManager.getConnection(URL,Username,Password);<\/div>\n
Oracle(\u7528thin\u6a21\u5f0f):<\/div>\n
\u00a0 \u00a0 String Driver=”oracle.jdbc.driver.OracleDriver”; \u00a0 \u00a0\/\/\u8fde\u63a5\u6570\u636e\u5e93\u7684\u65b9\u6cd5<\/div>\n
\u00a0 \u00a0 String URL=”jdbc:oracle:thin:@loaclhost:1521:orcl”; \u00a0 \u00a0\/\/orcl\u4e3a\u6570\u636e\u5e93\u7684SID<\/div>\n
\u00a0 \u00a0 String Username=”username”; \u00a0 \u00a0\/\/\u7528\u6237\u540d<\/div>\n
\u00a0 \u00a0 String Password=”password”; \u00a0 \u00a0\/\/\u5bc6\u7801<\/div>\n
\u00a0 \u00a0 Class.forName(Driver).newInstance(); \u00a0 \u00a0\/\/\u52a0\u8f7d\u6570\u636e\u5e93\u9a71\u52a8<\/div>\n
\u00a0 \u00a0 Connection con=DriverManager.getConnection(URL,Username,Password);<\/div>\n
PostgreSQL:<\/div>\n
\u00a0 \u00a0 String Driver=”org.postgresql.Driver”; \u00a0 \u00a0\/\/\u8fde\u63a5\u6570\u636e\u5e93\u7684\u65b9\u6cd5<\/div>\n
\u00a0 \u00a0 String URL=”jdbc:postgresql:\/\/localhost\/db_name”; \u00a0 \u00a0\/\/db_name\u4e3a\u6570\u636e\u53ef\u540d<\/div>\n
\u00a0 \u00a0 String Username=”username”; \u00a0 \u00a0\/\/\u7528\u6237\u540d<\/div>\n
\u00a0 \u00a0 String Password=”password”; \u00a0 \u00a0\/\/\u5bc6\u7801<\/div>\n
\u00a0 \u00a0 Class.forName(Driver).newInstance();<\/div>\n
\u00a0 \u00a0 Connection con=DriverManager.getConnection(URL,Username,Password);<\/div>\n
DB2\uff1a<\/div>\n
\u00a0 \u00a0 String Driver=”com.ibm.db2.jdbc.app.DB2.Driver”; \u00a0 \u00a0\/\/\u8fde\u63a5\u5177\u6709DB2\u5ba2\u6237\u7aef\u7684Provider\u5b9e\u4f8b<\/div>\n
\u00a0 \u00a0 \/\/String Driver=”com.ibm.db2.jdbc.net.DB2.Driver”; \u00a0 \u00a0\/\/\u8fde\u63a5\u4e0d\u5177\u6709DB2\u5ba2\u6237\u7aef\u7684Provider\u5b9e\u4f8b<\/div>\n
\u00a0 \u00a0 String URL=”jdbc:db2:\/\/localhost:5000\/db_name”; \u00a0 \u00a0\/\/db_name\u4e3a\u6570\u636e\u53ef\u540d<\/div>\n
\u00a0 \u00a0 String Username=”username”; \u00a0 \u00a0\/\/\u7528\u6237\u540d<\/div>\n
\u00a0 \u00a0 String Password=”password”; \u00a0 \u00a0\/\/\u5bc6\u7801<\/div>\n
\u00a0 \u00a0 Class.forName(Driver).newInstance();<\/div>\n
\u00a0 \u00a0 Connection con=DriverManager.getConnection(URL,Username,Password);<\/div>\n
Informix:<\/div>\n
\u00a0 \u00a0 String Driver=”com.informix.jdbc.IfxDriver”;<\/div>\n
\u00a0 \u00a0 String URL=”jdbc:Informix-sqli:\/\/localhost:1533\/db_name:INFORMIXSER=myserver”; \u00a0 \u00a0\/\/db_name\u4e3a\u6570\u636e\u53ef\u540d<\/div>\n
\u00a0 \u00a0 String Username=”username”; \u00a0 \u00a0\/\/\u7528\u6237\u540d<\/div>\n
\u00a0 \u00a0 String Password=”password”; \u00a0 \u00a0\/\/\u5bc6\u7801<\/div>\n
\u00a0 \u00a0 Class.forName(Driver).newInstance();<\/div>\n
\u00a0 \u00a0 Connection con=DriverManager.getConnection(URL,Username,Password);<\/div>\n
JDBC-ODBC:<\/div>\n
\u00a0 \u00a0 String Driver=”sun.jdbc.odbc.JdbcOdbcDriver”;<\/div>\n
\u00a0 \u00a0 String URL=”jdbc:odbc:dbsource”; \u00a0 \u00a0\/\/dbsource\u4e3a\u6570\u636e\u6e90\u540d<\/div>\n
\u00a0 \u00a0 String Username=”username”; \u00a0 \u00a0\/\/\u7528\u6237\u540d<\/div>\n
\u00a0 \u00a0 String Password=”password”; \u00a0 \u00a0\/\/\u5bc6\u7801<\/div>\n
\u00a0 \u00a0 Class.forName(Driver).newInstance();<\/div>\n
\u00a0 \u00a0 Connection con=DriverManager.getConnection(URL,Username,Password);<\/div>\n
“`<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u7f16\u7801\u8fc7\u7a0b\u4e2d\u65f6\u957f\u4f1a\u60f3\u4e0d\u8d77\u4e66\u5e93\u7684\u9a71\u52a8\u4ee3\u7801\uff0c\u518d\u6b64\u505a\u4e00\u4e2a\u7b14\u8bb0\u3002 “` MySQL\uff1a \u00a0 \u00a0 String Driver=”com.mysql.jdbc.Driver”; \u00a0 \u00a0\/\/\u9a71\u52a8\u7a0b\u5e8f \u00a0 \u00a0 String URL=”jdbc:mysql:\/\/localh…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[22],"tags":[3],"_links":{"self":[{"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=\/wp\/v2\/posts\/185"}],"collection":[{"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=185"}],"version-history":[{"count":5,"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=\/wp\/v2\/posts\/185\/revisions"}],"predecessor-version":[{"id":449,"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=\/wp\/v2\/posts\/185\/revisions\/449"}],"wp:attachment":[{"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lg.yusemo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}