JAVA学到JDBC遇到的问题 求高手解答

Question

在eclipse上运行如下代码   Java codeimport java.sql.*;
public class testJDBC01
{
    public static void main(String[] args) 
    {
        Connection conn = null;
        Statement stmt = null;
        try
        {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
            conn = DriverManager.getConnection(url,"sa","sa");
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            //新增表,以及插入数据
//            String sql1 = "create table d_student (sno int primary key,sname varchar(50),age int)";
//            stmt.executeUpdate(sql1);
//
//            String insertSql1 = "insert into d_student values(1,'zhangsan',20)";
//            int count1 = stmt.executeUpdate(insertSql1);
//            insertSql1 = "insert into d_student values(2,'wangwu',20)";
//            count1 = stmt.executeUpdate(insertSql1);
//            insertSql1 = "insert into d_student values(3,'lisi',20)";
//            count1 = stmt.executeUpdate(insertSql1);
            
            //新增表
            String sql2 = "create table d_course (cno int primary key,cname varchar(50),credit int )";
            stmt.executeUpdate(sql2);
            
            //加列属性
            String insertSql2 = "insert into d_course values(1,'语文',5)";
            int count2 = stmt.executeUpdate(insertSql2);
            insertSql2 = "insert into d_course values(2,'数学',6)";
            count2 = stmt.executeUpdate(insertSql2);
            insertSql2 = "insert into d_course values(3,'英语',7)";
            count2 = stmt.executeUpdate(insertSql2);
            
            //新增表
            String sql3 = "create table d_sc (sno int ,cno int primary key (sno,cno) , score int )";
            stmt.executeUpdate(sql3);
            
            //加列属性
            String insertSql3 = "insert into d_course values(1,1,80)";
            int count3 = stmt.executeUpdate(insertSql3);
            insertSql3 = "insert into d_course values(2,2,90)";
            count3 = stmt.executeUpdate(insertSql3);
            insertSql3 = "insert into d_course values(3,3,100)";
            count3 = stmt.executeUpdate(insertSql3);
            
            //查询数据
//            String sql = "select * from d_student";
//            ResultSet rs = stmt.executeQuery(sql);
//            //int counter=0;
//            rs.last();
//            System.out.println("记录数="+rs.getRow());
//            rs.beforeFirst();
//            while(rs.next())
//            {
//                System.out.println(rs.getString("sname"));
//                //counter++;
//            }
//            //System.out.println("记录数="+counter);
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
            try
            {
                stmt.close();
                conn.close();    
            }
            catch (Exception e)
            {
                e.printStackTrace();
            }            
        }
    }
} 
出现以下错误 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset 
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) 
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) 
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) 
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) 
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) 
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source) 
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) 
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) 
at java.sql.DriverManager.getConnection(DriverManager.java:525) 
at java.sql.DriverManager.getConnection(DriverManager.java:171) 
at cn.sotraining.testJDBC.testJDBC01.main(testJDBC01.java:14) 
java.lang.NullPointerException 
at cn.sotraining.testJDBC.testJDBC01.main(testJDBC01.java:73) 
SQL的三个JAR包msbase,mssqlserver,msutil我已经导入到eclipse的Java Build Path-Libraries中.. SQL上我改了混合模式,并将sa帐户添加到student库中,新增了student库其他参数没有改. 
并且在windows数据源中添加了  sa用户访问student库的驱动 不知道哪里还出现问题了...求高手解答..

Answer 1

用 String url = "jdbc:odbc:driver={SQL Server};server=.;Database= student" 试试看。

Answer 2

用这个Connection con=null;
String url="jdbc:odbc:student";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();

Answer 3

额...就说么,SP4补丁我解压缩后,我以为就装好了,结果在C盘发现他的安装文件升级到SP4后,问题解决 o(∩_∩)o...感谢这位大大,以及所有帮助在下的网友...^_^