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

5、javac.bat檔案，用於編譯java檔案，其內容如下，雙擊執行得到testSqlServer2000.class

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

執行結果：

I:/workspace/java/testSQLServer2000>set path="C:/Program Files/Java/jdk1.6.0_11/<br />bin; C:/Windows;C:/Windows/Command"</p><p>I:/workspace/java/testSQLServer2000>set classpath=". ;C:/Program Files/Java/jdk1<br />.6.0_11/lib/tools.jar"</p><p>I:/workspace/java/testSQLServer2000>"C:/Program Files/Java/jdk1.6.0_11/bin/javac<br />" testSqlServer2000.java</p><p>I:/workspace/java/testSQLServer2000>pause<br />請按任意鍵繼續. . .

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"<br />@set classpath=". ;C:/Program Files/Java/jdk1.6.0_11/lib/tools.jar;mssqlserver.jar;msbase.jar;msutil.jar"<br />"C:/Program Files/Java/jdk1.6.0_11/bin/java" testSqlServer2000<br />pause<br />

雙擊執行結果

I:/workspace/java/testSQLServer2000>"C:/Program Files/Java/jdk1.6.0_11/bin/java"<br /> testSqlServer2000<br />connect successful<br />2000-08-06 01:30:31.687<br />close successful</p><p>I:/workspace/java/testSQLServer2000>pause<br />請按任意鍵繼續. . .