欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

SQL Server 2000 Driver for JDBC Service Pack 3 安装测试方法

程序员文章站 2024-03-01 19:45:58
1.安装:sql server 2000 driver for jdbc service pack 3 下载安装jdbc sp3 里面的安装包 按照提示...

1.安装:sql server 2000 driver for jdbc service pack 3
下载安装jdbc sp3



里面的安装包

按照提示安装可以了.成功后有三个文件要使用:
c:/program files/microsoft sql server 2000 driver for jdbc/lib/msbase.jar
c:/program files/microsoft sql server 2000 driver for jdbc/lib/msutil.jar
c:/program files/microsoft sql server 2000 driver for jdbc/lib/mssqlserver.jar

2.测试代码

新建类文件connect.java.

package test;
import java.*;
import java.sql.driver;
public class connect{
   private java.sql.connection con = null;
   private final string url = "jdbc:microsoft:sqlserver://";
   private final string servername= "localhost";
   private final string portnumber = "1433";
   private final string databasename= "dbtest";
   private final string username = "sa";
   private final string password = "123456";
   // informs the driver to use server a side-cursor,
   // which permits more than one active statement
   // on a connection.
   private final string selectmethod = "cursor";

   // constructor
   public connect(){}

   private string getconnectionurl(){
     return url+servername+":"+portnumber+";databasename="+databasename+";selectmethod="+selectmethod+";";

   }

   private java.sql.connection getconnection(){
     try{
        class.forname("com.microsoft.jdbc.sqlserver.sqlserverdriver");
        con = java.sql.drivermanager.getconnection(getconnectionurl(),username,password);
        if(con!=null) system.out.println("connection successful!");
     }catch(exception e){
        e.printstacktrace();
        system.out.println("error trace in getconnection() : " + e.getmessage());
     }
     return con;
   }

   /*
     display the driver properties, database details
   */

   public void displaydbproperties(){
     java.sql.databasemetadata dm = null;
     java.sql.resultset rs = null;
     try{
        con= this.getconnection();
        if(con!=null){
          dm = con.getmetadata();
          system.out.println("driver information");
          system.out.println("/tdriver name: "+ dm.getdrivername());
          system.out.println("/tdriver version: "+ dm.getdriverversion ());
          system.out.println("/ndatabase information ");
          system.out.println("/tdatabase name: "+ dm.getdatabaseproductname());
          system.out.println("/tdatabase version: "+ dm.getdatabaseproductversion());
          system.out.println("avalilable catalogs ");
          rs = dm.getcatalogs();
          while(rs.next()){
             system.out.println("/tcatalog: "+ rs.getstring(1));
          }
          rs.close();
          rs = null;
          closeconnection();
        }else system.out.println("error: no active connection");
     }catch(exception e){
        e.printstacktrace();
     }
     dm=null;
   }

   private void closeconnection(){
     try{
        if(con!=null)
          con.close();
        con=null;
     }catch(exception e){
        e.printstacktrace();
     }
   }
   public static void main(string[] args) throws exception
    {
     connect mydbtest = new connect();
     mydbtest.displaydbproperties();
    }
}

代码来源:
http://support.microsoft.com/default.aspx?scid=kb;zh-cn;313100
------------------------------------------
成功后控制台输出:
connection successful!
driver information
 driver name: sqlserver
 driver version: 2.2.0040

database information
 database name: microsoft sql server
 database version: microsoft sql server  2000 - 8.00.760 (intel x86)
 dec 17 2002 14:22:05
 copyright (c) 1988-2003 microsoft corporation
 enterprise edition on windows nt 5.2 (build 3790: )

avalilable catalogs
 catalog: dbtest
 ...........


3.问题:
在测试中控制台老输出下面的错误!
找资料找了很久.都说把jdbc安装后的三个jar文件的路径放进环境变量里可以了但我试了不行的!
java.lang.classnotfoundexception: com.microsoft.jdbc.sqlserver.sqlserverdriver
.........
error trace in getconnection() : com.microsoft.jdbc.sqlserver.sqlserverdriver
error: no active connection

请教了别人才找到办法:

包资源管理器-->包名右键"构建路径"-->配置构建路径-->java构建路径-->库-->添加外部jar
把那三个jar选择进去就可以了.

SQL Server 2000 Driver for JDBC Service Pack 3 安装测试方法

SQL Server 2000 Driver for JDBC Service Pack 3 安装测试方法

添加后三个jdbc文件就有了.

SQL Server 2000 Driver for JDBC Service Pack 3 安装测试方法