实例讲解连接sqlserver2000与2005 - sqljdbc.jar 驱动

一、文件准备与创建，其中sqljdbc.jar 的下载：http://download.csdn.net/source/2474822

?

二、测试sql server 200 所有代码及执行，按创建顺序

1、sqljdbc.jar

2、testSqlServer2000.java

?

1. import?java.sql.ResultSet;??
2. import?java.sql.SQLException;??
3. import?java.sql.Statement;??
4. import?java.sql.*;??
5. public?class?testSqlServer2000??
6. {??
7. ????//driver?string??
8. ????static?String?JDBCDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";??????
9. //connection?string??
10. ????String?JDBCConnection="jdbc:sqlserver://data:1433;DatabaseName=master";??
11. ????String?userName?=?"sa";??
12. ????String?userPwd?=?"sa";??
13. ????Connection?conn=null;??
14. ????ResultSet?rs=null;??
15. ??????
16. public?testSqlServer2000()??
17. ????{??
18. ????????try{?????????????
19. ????????????Class.forName(JDBCDriver);//load?Driver??????????????
20. ????????}??
21. ????????catch(java.lang.ClassNotFoundException?e)??
22. ????????{??
23. ????????????System.err.println("Dbconnection?():"+e.getMessage());//catch?exception??
24. ????}??
25. ??????
26. ????public?Connection?connect()??
27. ????{??
28. try{//get?connection??????????????
29. ????????????conn=DriverManager.getConnection(JDBCConnection,?userName,?userPwd);??????????????
30. ????????????System.out.println("connect?successful");??????????????
31. catch(SQLException?ex)??
32. ????????????System.err.println("connection():"+ex.getMessage());??????????????
33. return?conn;??
34. ????}??
35. void?close()??
36. try?{??
37. ????????????if(!this.conn.isClosed())??
38. ????????????{??
39. ????????????????this.conn.close();??
40. ????????????????System.out.println("close?successful");??
41. ????????????}??
42. ??????????????????
43. ????????}?catch?(SQLException?e)?{??
44. ????????????//?TODO?Auto-generated?catch?block??
45. ????????????e.printStackTrace();??
46. ??
47. /**?
48. ????*?@param?args?
49. ????*/??
50. static?void?main(String[]?args)?{??
51. ????????//?TODO?Auto-generated?method?stub??
52. ????????testSqlServer2000?cdb=new?testSqlServer2000();??
53. ????????cdb.connect();??
54. ????????Statement?stmt;??
55. ????????ResultSet?rs;??
56. ????????????stmt?=?cdb.conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);??
57. ????????????rs?=?stmt.executeQuery("select?*?from?spt_monitor");??
58. while(rs.next())??
59. ????????????????String?s=rs.getString(1);??
60. out.println(s);??
61. ????????}?catch?(SQLException?e)?{??
62. ????????????//?TODO?Auto-generated?catch?block??
63. ????????????e.printStackTrace();??
64. ????????}??
65. ????????cdb.close();?????
66. ????}?????
67. }??

3、javac2000.bat

set?path="C:/Program?Files/Java/jdk1.6.0_11/bin;?C:/Windows;C:/Windows/Command"??
1. set?classpath=".?;C:/Program?Files/Java/jdk1.6.0_11/lib/tools.jar"??
2. "C:/Program?Files/Java/jdk1.6.0_11/bin/javac"?testSqlServer2000.java??
3. pause??

执行结果

I:/workspace/java/testSqlServer/sqljdbc>set?path="C:/Program?Files/Java/jdk1.6.0??
1. _11/bin;?C:/Windows;C:/Windows/Command"??
2. ??
3. I:/workspace/java/testSqlServer/sqljdbc>set?classpath=".?;C:/Program?Files/Java/??
4. jdk1.6.0_11/lib/tools.jar"??
5. I:/workspace/java/testSqlServer/sqljdbc>"C:/Program?Files/Java/jdk1.6.0_11/bin/j??
6. avac"?testSqlServer2000.java??
7. I:/workspace/java/testSqlServer/sqljdbc>pause??
8. 请按任意键继续.?.?.??

4、java2000.bat

copy

@set?path="C:/Program?Files/Java/jdk1.6.0_11/bin;?C:/Windows;C:/Windows/Command"??
1. @set?classpath=".?;C:/Program?Files/Java/jdk1.6.0_11/lib/tools.jar;sqljdbc.jar;"??
2. "C:/Program?Files/Java/jdk1.6.0_11/bin/java"?testSqlServer2000??
3. copy
   I:/workspace/java/testSqlServer/sqljdbc>"C:/Program?Files/Java/jdk1.6.0_11/bin/j??
   1. ava"?testSqlServer2000??
   2. connect?successful??
   3. 2000-08-06?01:30:31.687??
   4. close?successful??
   5. I:/workspace/java/testSqlServer/sqljdbc>pause??
   6. 请按任意键继续.?.?.??

   三、测试sql server 2005

   1、testSqlServer2005.java

   [java]? copy
   import?java.sql.ResultSet;??
   1. import?java.sql.SQLException;??
   2. import?java.sql.Statement;??
   3. import?java.sql.*;??
   4. class?testSqlServer2005??
   5. ????String?JDBCConnection="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=master";??
   6. ????String?userPwd?=?"000000";??
   7. public?testSqlServer2005()??
   8. ????????????System.out.println("connect?successful");??????????????
   9. ????????????????System.out.println("close?successful");??
   10. ????????testSqlServer2005?cdb=new?testSqlServer2005();??
   11. ????????????????String?s=rs.getString(1);??
   12. ????????????????System.out.println(s);??
   13. 2、javac2005

       copy

       set?path="C:/Program?Files/Java/jdk1.6.0_11/bin;?C:/Windows;C:/Windows/Command"??
       1. set?classpath=".?;C:/Program?Files/Java/jdk1.6.0_11/lib/tools.jar"??
       2. "C:/Program?Files/Java/jdk1.6.0_11/bin/javac"?testSqlServer2005.java??
       3. 3、java2005

          copy

          @ @set?classpath=".?;C:/Program?Files/Java/jdk1.6.0_11/lib/tools.jar;sqljdbc.jar"??
          1. pause??

          （编辑：李大同）

          【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!