JDBC.ODBC连接数据库代码

数据库产品：Microsoft SQL 2000

1.导入数据库：jia服装公司销售系统

2.建立数据源：jia

3.代码如下：

Code:

1. importjava.sql.*;//longlongagobynothing!
2. publicclassconnDatabase{
3. ResultSetrs;
4. Statementstmt;
5. Connectioncon;
6. Stringsqlstr="";
7. publicstaticvoidmain(String[]args)throwsException{
8. newconnDatabase();
9. }
10. connDatabase(inta)throwsException{
11. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
12. con=DriverManager.getConnection("jdbc:odbc:jia","sa","123");
13. }
14. //构造连接数据库
15. connDatabase()throwsException{
16. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
17. Stringurl="jdbc:odbc:jia";
18. Stringuser="sa";
19. Stringpass="123";
20. con=DriverManager.getConnection(url,user,pass);
21. System.out.println("连接数据库成功.........");
22. }
23. //tTransaction
24. publicvoidforTransaction(Stringsql)throwsException{
25. con=DriverManager.getConnection("jdbc:odbc:jia","sa","123");
26. con.setAutoCommit(false);
27. stmt=con.createStatement();
28. stmt.addBatch(sql);
29. stmt.addBatch(sql);
30. stmt.addBatch(sql);
31. stmt.executeBatch();
32. con.commit();
33. con.setAutoCommit(true);
34. }
35. //查询
36. publicResultSetqueryDB(Stringsql)throwsException{
37. stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
38. //查询表中的所有记录
39. rs=stmt.executeQuery(sql);
40. returnrs;
41. }
42. //更新
43. publicbooleanupdateDB(Stringsql)throwsException{
44. stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
45. if(stmt.executeUpdate(sql)<=0)
46. {
47. returnfalse;
48. }
49. else
50. returntrue;
51. }
52. //关闭连接
53. publicvoidconClose()throwsException{
54. con.close();
55. }
56. }