实例讲解3jar包连接sqlserver2000 - msbase.jar;mssqlserver.jar;msutil.jar

实例讲解3jar包连接sqlserver2000 - msbase.jar;mssqlserver.jar;msutil.jar

一、首先确保环境Ok，1、安装jdk，2、下载jdbc驱动。

其中msbase.jar;mssqlserver.jar;msutil.jar的下载：http://download.youkuaiyun.com/source/2474798

(很抱歉，上传时忘了改0资源分了，直接重新上传还不行)

二、建立如图工作环境：

简要说明一下各个文件的作用，按创建先后：

1、sqlserver_driver_lib.rar：下载的jdbc驱动；

2、msbase.jar;mssqlserver.jar;msutil.jar：解压缩得到的jar包文件；

3、新建 文本文档.txt：为了编写java代码与bat文件使用；

4、testSqlServer2000.java：java源码，内容如下

import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.*; public class testSqlServer2000 { //driver string static String JDBCDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver"; //connection string String JDBCConnection="jdbc:microsoft:sqlserver://data:1433;DatabaseName=master"; String userName = "sa"; String userPwd = "sa"; Connection conn=null; ResultSet rs=null; public testSqlServer2000() { try{ Class.forName(JDBCDriver);//load Driver } catch(java.lang.ClassNotFoundException e) { System.err.println("Dbconnection ():"+e.getMessage());//catch exception } } public Connection connect() { try{//get connection conn=DriverManager.getConnection(JDBCConnection, userName, userPwd); System.out.println("connect successful"); } catch(SQLException ex) { System.err.println("connection():"+ex.getMessage()); } return conn; } public void close() { try { if(!this.conn.isClosed()) { this.conn.close(); System.out.println("close successful"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub testSqlServer2000 cdb=new testSqlServer2000(); cdb.connect(); Statement stmt; ResultSet rs; try { stmt = cdb.conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery("select * from spt_monitor"); while(rs.next()) { String s=rs.getString(1); System.out.println(s); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } cdb.close(); } }

5、javac.bat文件，用于编译java文件，其内容如下，双击执行得到testSqlServer2000.class

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

执行结果：

I:/workspace/java/testSQLServer2000>set path="C:/Program Files/Java/jdk1.6.0_11/ bin; C:/Windows;C:/Windows/Command" I:/workspace/java/testSQLServer2000>set classpath=". ;C:/Program Files/Java/jdk1 .6.0_11/lib/tools.jar" I:/workspace/java/testSQLServer2000>"C:/Program Files/Java/jdk1.6.0_11/bin/javac " testSqlServer2000.java I:/workspace/java/testSQLServer2000>pause 请按任意键继续. . .

6、testSqlServer2000.class 是java编译得到的字节码文件，虚拟机实际解析的文件

7、java.bat是调用java执行testSqlServer2000，其代码为：

@set path="C:/Program Files/Java/jdk1.6.0_11/bin; C:/Windows;C:/Windows/Command" @set classpath=". ;C:/Program Files/Java/jdk1.6.0_11/lib/tools.jar;mssqlserver.jar;msbase.jar;msutil.jar" "C:/Program Files/Java/jdk1.6.0_11/bin/java" testSqlServer2000 pause

双击执行结果

I:/workspace/java/testSQLServer2000>"C:/Program Files/Java/jdk1.6.0_11/bin/java" testSqlServer2000 connect successful 2000-08-06 01:30:31.687 close successful I:/workspace/java/testSQLServer2000>pause 请按任意键继续. . .