java连接常用数据库

1. //MicrosoftAccess(ODBC)
2. packagecom.jdm.Access;
3. importjava.sql.Connection;
4. importjava.sql.DriverManager;
5. importjava.sql.ResultSet;
6. importjava.sql.SQLException;
7. importjava.sql.Statement;
8. importcom.jdm.dmdatabase.DMsource;
9. publicclassAccess{
10. privateConnectioncon;
11. privateStringdriverclass;
12. privateStatementstatement;
13. privateStringurl;
14. privateResultSetresult;
15. privateStringusername;
16. privateStringpassword;
17. publicAccess(){
18. init();
19. try{
20. Class.forName(driverclass);
21. con=DriverManager.getConnection(url,username,password);
22. if(con!=null){
23. statement=con.createStatement();
24. inta=statement.executeUpdate("insertintouser(username,password)values('mike','tome')");
25. result=statement.executeQuery("select*fromuser");
26. while(result.next())
27. System.out.println("user:"+result.getString(1)
28. +"password:"+result.getString(2));
29. System.out.print("/n");
30. }
31. result.close();
32. statement.close();
33. con.close();
34. }catch(ClassNotFoundExceptione){
36. e.printStackTrace();
37. }catch(SQLExceptione){
38. e.printStackTrace();
39. }
40. }
41. publicvoidinit(){
42. driverclass="sun.jdbc.odbc.JdbcOdbcDriver";
43. url="jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=E://java//test.mdb";
44. username="";
45. password="";
46. }
47. publicstaticvoidmain(Stringargs[]){
48. newAccess();
49. }
50. }
51. ///
52. /MicrosoftSqlServer2000(需要装sp3补丁，并开放端口)
53. //
54. packagecom.jdm.sqlserver;
55. importjava.sql.CallableStatement;
56. importjava.sql.Connection;
57. importjava.sql.DriverManager;
58. importjava.sql.ResultSet;
59. importjava.sql.SQLException;
60. importjava.sql.Statement;
61. publicclassSqlLink{
63. privateConnectioncon;
64. privateStatementstm;
65. privateResultSetresultset;
66. privateStringdriverclass=null;
67. privateStringurl=null;
68. privateStringusername=null;
69. privateStringpassword=null;
70. publicSqlLink(){
71. driverclass="com.microsoft.jdbc.sqlserver.SQLServerDriver";
72. url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=cjgl";
73. username="sa";
74. password="123456";
75. init();
76. if(con!=null){
77. try{
78. con.close();
79. if(con.isClosed())
80. System.out.println("连接成功"+"数据源已释放");
81. else
82. System.out.println("连接成功"+"数据源未释放");
83. }catch(SQLExceptione1){
84. e1.printStackTrace();
85. }
86. }else{
87. System.out.println("连接失败");
88. }
89. }
90. publicvoidinit(){
91. try{
92. Class.forName(driverclass);
93. con=DriverManager.getConnection(url,username,password);
94. stm=con.createStatement();
95. /*CallableStatementcall=con.prepareCall("{callADDXS(?,?,?,?,?,?,?)}");
96. call.setString(1,"001118");
97. call.setString(2,"王珊珊");
98. call.setString(3,"女");
99. call.setString(4,"通信工程");
100. call.setString(5,"1988-03-21");
101. call.setInt(6,40);
102. call.setString(7,"良");
103. call.execute();*/
105. resultset=stm.executeQuery("select*fromXSwherexb='女'");
106. while(resultset.next()){
107. System.out
108. .println(resultset.getString(1)+""
109. +resultset.getString(2)+""
110. +resultset.getString(3)+""
111. +resultset.getString(4)+""
112. +resultset.getString(5)+""
113. +resultset.getString(6));
114. }
115. }catch(ClassNotFoundExceptione){
117. e.printStackTrace();
118. System.out.println("驱动类没有找到");
119. }catch(SQLExceptione){
120. e.printStackTrace();
121. }
122. }
123. publicstaticvoidmain(String[]args){
125. newSqlLink();
126. }
127. }
128. ///
129. //sunMySql
130. packagecom.jdm.mysql;
131. importjava.sql.Connection;
132. importjava.sql.DriverManager;
133. importjava.sql.ResultSet;
134. importjava.sql.SQLException;
135. importjava.sql.Statement;
136. publicclassMySql{
138. privateStringdriverclass;
139. privateStringurl;
140. privateStringusername;
141. privateStringpassword;
142. privateConnectioncon;
143. privateStatementstm;
144. privateResultSetresult;
145. publicMySql(){
146. init();
147. try{
148. Class.forName(driverclass);
149. con=DriverManager.getConnection(url,username,password);
150. stm=con.createStatement();
151. result=stm.executeQuery("SELECT*FROMuserinfo");
152. while(result.next()){
153. System.out.println("用户名:"+result.getString(1)+"密码:"
154. +result.getString(2)+"角色:"+result.getString(3)+"日期:"
155. +result.getString(4)+"性别:"+result.getString(4));
156. }
157. con.close();
158. }catch(ClassNotFoundExceptione){
160. e.printStackTrace();
161. }catch(SQLExceptione){
162. e.printStackTrace();
163. }
164. }
165. publicvoidinit(){
166. driverclass="com.mysql.jdbc.Driver";
167. url="jdbc:mysql://localhost:3306/test";
168. username="root";
169. password="123456";
170. }
171. publicstaticvoidmain(String[]args){
172. newMySql();
173. }
174. }
176. ///
177. //华工达梦数据库DM
178. packagecom.jdm.dmdatabase;
179. importjava.sql.Connection;
180. importjava.sql.DriverManager;
181. importjava.sql.ResultSet;
182. importjava.sql.SQLException;
183. importjava.sql.Statement;
184. publicclassDMsource{
185. privateConnectioncon;
186. privateStringdriverclass;
187. privateStatementstatement;
188. privateStringurl;
189. privateResultSetresult;
190. privateStringusername;
191. privateStringpassword;
192. publicDMsource(){
193. init();
194. try{
195. Class.forName(driverclass);
196. con=DriverManager.getConnection(url,username,password);
197. if(con!=null){
198. System.out.println("连接成功"+con.toString());
199. con.close();
200. }
201. }catch(ClassNotFoundExceptione){
202. e.printStackTrace();
203. }catch(SQLExceptione){
204. e.printStackTrace();
205. }
206. }
207. publicvoidinit(){
208. driverclass="dm.jdbc.driver.DmDriver";
209. url="jdbc:dm://localhost:12345/mdj";
210. username="mdj";
211. password="123456";
212. }
213. publicstaticvoidmain(Stringargs[]){
214. newDMsource();
215. }
216. }
218. ///
219. //ORACLEDATABASE
220. //
221. packagecom.jdm.Oracle;
222. importjava.sql.Connection;
223. importjava.sql.DriverManager;
224. importjava.sql.ResultSet;
225. importjava.sql.SQLException;
226. importjava.sql.Statement;
227. importcom.jdm.mysql.MySql;
228. publicclassOracle{
230. privateStringdriverclass;
231. privateStringurl;
232. privateStringusername;
233. privateStringpassword;
234. privateConnectioncon;
235. privateStatementstm;
236. privateResultSetresult;
237. publicOracle(){
238. init();
239. try{
240. Class.forName(driverclass);
241. con=DriverManager.getConnection(url,username,password);
242. stm=con.createStatement();
243. result=stm.executeQuery("SELECT*FROMHELP");
244. while(result.next()){
245. System.out.println(result.getString(1)+""+result.getString(2)+""+result.getString(3));
247. }
248. if(con!=null)System.out.println("连接成功");
249. con.close();
250. }catch(ClassNotFoundExceptione){
252. e.printStackTrace();
253. }catch(SQLExceptione){
254. e.printStackTrace();
255. }
256. }
257. publicvoidinit(){
258. driverclass="oracle.jdbc.driver.OracleDriver";
259. url="jdbc:oracle:thin:@localhost:1521:XE";
260. //url="jdbc:oracle:thin:@computername:host(1521):databasename"
261. username="SYSTEM";
262. password="123456";
263. }
264. publicstaticvoidmain(String[]args){
265. newOracle();
266. }
267. }
268. //推荐国产数据库系统 华工达梦 人大金仓 神舟oscr