各种数据库的jdbc连接大全

最新推荐文章于 2024-12-10 13:39:30 发布

转载最新推荐文章于 2024-12-10 13:39:30 发布 · 580 阅读

文章标签：

#jdbc #数据库 #postgresql #download #sybase #url

Java技术专栏收录该内容

13 篇文章

订阅专栏

本文汇总了多种数据库的JDBC连接方法及示例代码，包括Microsoft SQL Server、MySQL、Oracle、Sybase、PostgreSQL等，提供了JDBC驱动下载链接及连接语法。

各种数据库的 JDBC 连接大全

1. 各种数据库的JDBC连接大全 2. Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10 3. 4. JDBC Name: jTDS 5. URL: http://jtds.sourceforge.net/ 6. Version: 0.5.1 7. Download URL: http://sourceforge.net/project/showfiles.php?group_id=33291 8. 9. 语法: 10. Class.forName("net.sourceforge.jtds.jdbc.Driver "); 11. Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://host:port/database","user","password"); 12. or 13. Connection con = DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password"); 14. 15. 16. MySQL 17. 18. JDBC Name: Connector/J 3.0 19. URL: http://www.mysql.com/ 20. Version: 3.0.8-stable 21. Download URL: http://www.mysql.com/downloads/api-jdbc-stable.html 22. 23. 语法: 24. Download URL: http://www.mysql.com/downloads/api-jdbc-stable.html 25. 26. 语法: 27. Class.forName("com.mysql.jdbc.Driver"); 28. Connection con = DriverManager.getConnection("jdbc:mysql://host:port/database","user","password"); 29. 30. 31. Oracle 32. 33. JDBC Name: Connector/J 3.0 34. URL: http://otn.oracle.com/ 35. Version: 3.0.8-stable 36. Download URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html 37. 38. 语法: 39. Download URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html 40. 41. 语法: 42. Class.forName("oracle.jdbc.driver.OracleDriver"); 43. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password"); 44. 45. 46. Sybase 47. 48. Driver: jConnect 4.5/5.5 (JDBC 2.0 请使用5.5) 49. 50. 语法: 51. 52. Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance(); 53. DriverManager.getConnection("jdbc:sybase:Tds:IP地址:2638?ServiceName="+数据库名称,"账号","密码"); 54. 55. 56. Postgresql 57. 58. JDBC Name: PostgreSQL JDBC 59. URL: http://jdbc.postgresql.org/ 60. Version: 7.3.3 build 110 61. Download URL: http://jdbc.postgresql.org/download.html 62. 63. 语法: 64. Download URL: http://jdbc.postgresql.org/download.html 65. 66. 语法: 67. Class.forName("org.postgresql.Driver"); 68. Connection con=DriverManager.getConnection("jdbc:postgresql://host:port/database","user","password"); 69. 70. 71. IBM AS400主机在用的JDBC语法 72. 73. 有装V4R4以上版本的Client Access Express 74. 可以在C:Program FilesIBMClient Accessjt400lib 75. 找到 driver 档案 jt400.zip，并更改扩展名成为 jt400.jar 76. 77. 语法语法: 78. Class.forName("net.sourceforge.jtds.jdbc.Driver "); 79. Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://host:port/database","user","password"); 80. or 81. Connection con = DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password"); 82. 83. 84. MySQL 85. 86. JDBC Name: Connector/J 3.0 87. URL: http://www.mysql.com/ 88. Version: 3.0.8-stable 89. Download URL: http://www.mysql.com/downloads/api-jdbc-stable.html 90. 91. 语法: 92. Download URL: http://www.mysql.com/downloads/api-jdbc-stable.html 93. 94. 语法: 95. Class.forName("com.mysql.jdbc.Driver"); 96. Connection con = DriverManager.getConnection("jdbc:mysql://host:port/database","user","password"); 97. 98. 99. Oracle 100. 101. JDBC Name: Connector/J 3.0 102. URL: http://otn.oracle.com/ 103. Version: 3.0.8-stable 104. Download URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html 105. 106. 语法: 107. Download URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html 108. 109. 语法: 110. Class.forName("oracle.jdbc.driver.OracleDriver"); 111. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password"); 112. 113. 114. Sybase 115. 116. Driver: jConnect 4.5/5.5 (JDBC 2.0 请使用5.5) 117. 118. 语法: 119. 120. Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance(); 121. DriverManager.getConnection("jdbc:sybase:Tds:IP地址:2638?ServiceName="+数据库名称,"账号","密码"); 122. 123. 124. Postgresql 125. 126. JDBC Name: PostgreSQL JDBC 127. URL: http://jdbc.postgresql.org/ 128. Version: 7.3.3 build 110 129. Download URL: http://jdbc.postgresql.org/download.html 130. 131. 语法: 132. Download URL: http://jdbc.postgresql.org/download.html 133. 134. 语法: 135. Class.forName("org.postgresql.Driver"); 136. Connection con=DriverManager.getConnection("jdbc:postgresql://host:port/database","user","password"); 137. 138. 139. IBM AS400主机在用的JDBC语法 140. 141. 有装V4R4以上版本的Client Access Express 142. 可以在C:Program FilesIBMClient Accessjt400lib 143. 找到 driver 档案 jt400.zip，并更改扩展名成为 jt400.jar 144. 145. 语法 146. java.sql.DriverManager.registerDriver (new com.ibm.as400.access.AS400JDBCDriver ()); 147. Class.forName("com.ibm.as400.access.AS400JDBCConnection"); 148. con = DriverManager.getConnection("jdbc:as400://IP","user","passwor"); 149. 150. 1．Oracle8/8i/9i数据库（thin模式） 151. Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 152. String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID 153. String user="test"; 154. String password="test"; 155. Connection conn= DriverManager.getConnection(url,user,password); 156. 2．DB2数据库 157. Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance(); 158. String url="jdbc:db2://localhost:5000/sample"; //sample为你的数据库名 159. String user="admin"; 160. String password=""; 161. Connection conn= DriverManager.getConnection(url,user,password); 162. 3．Sql Server7.0/2000数据库 163. Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 164. String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb"; 165. //mydb为数据库 166. String user="sa"; 167. String password=""; 168. Connection conn= DriverManager.getConnection(url,user,password); 169. 4．Sybase数据库 170. Class.forName("com.sybase.jdbc.SybDriver").newInstance(); 171. String url =" jdbc:sybase:Tds:localhost:5007/myDB";//myDB为你的数据库名 172. Properties sysProps = System.getProperties(); 173. SysProps.put("user","userid"); 174. SysProps.put("password","user_password"); 175. Connection conn= DriverManager.getConnection(url, SysProps); 176. 5．Informix数据库 177. Class.forName("com.informix.jdbc.IfxDriver").newInstance(); 178. String url = "jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver; 179. user=testuser;password=testpassword"; //myDB为数据库名 180. Connection conn= DriverManager.getConnection(url); 181. 6．MySQL数据库 182. Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 183. String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1" 184. //myDB为数据库名 185. Connection conn= DriverManager.getConnection(url); 186. 7．PostgreSQL数据库 187. Class.forName("org.postgresql.Driver").newInstance(); 188. String url ="jdbc:postgresql://localhost/myDB" //myDB为数据库名 189. String user="myuser"; 190. String password="mypassword"; 191. Connection conn= DriverManager.getConnection(url,user,password); 192. 8．access数据库直连用ODBC的 193. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; 194. String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+application.getRealPath("/Data/ReportDemo.mdb"); 195. Connection conn = DriverManager.getConnection(url,"",""); 196. Statement stmtNew=conn.createStatement() ;