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

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

 

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

1、sqljdbc.jar

2、testSqlServer2000.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.sqlserver.jdbc.SQLServerDriver"; //connection string String JDBCConnection="jdbc: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)