jdbc 连接大全

最新推荐文章于 2022-09-22 13:09:47 发布

lovting

最新推荐文章于 2022-09-22 13:09:47 发布

阅读量103

点赞数

分类专栏： java学习文章标签： JDBC Sybase Oracle MySQL PostgreSQL

本文链接：https://blog.csdn.net/lovting/article/details/83297896

版权

java学习专栏收录该内容

17 篇文章 0 订阅

订阅专栏

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