eclipse连接sql server 2005问题

Question

import java.sql.*;
public class DataBase {
public static void main(String[] args){
Connection ct=null;
Statement sm=null;

    try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        ct=DriverManager.getConnection("jdbc:odbc:sql server","sa","rengui987426.");
        sm=ct.createStatement();
        ResultSet rs=sm.executeQuery("select * from bumen");
        while(rs.next()){
            int ners=rs.getInt(1);
            String ner=rs.getString(2);
            String didian=rs.getString(3);
            System.out.println(ners+"   "+ner+"   "+didian);
        }
    }catch(Exception e){
          System.out.println("错误");
    }finally{
        try{
            if(ct!=null){
                ct.close();
            }
            if(sm!=null){
                sm.close();
            }
        }catch(Exception e){}
    }
}

}
连接sql server时运行catch语句,运行结果为:错误
看看我的代码哪儿出问题了?

Answer 1

 public static void main(String[] args) {
        // TODO 自动生成的方法存根
        String  driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
        String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=test";
        String userName = "sa";
        String userPwd = "dsghsdgh";
        try{
            Class.forName(driverName);
            System.out.println("加载驱动成功！");
        }catch(Exception e){
            e.printStackTrace();
            System.out.println("加载驱动失败！");
        }
        try{
            @SuppressWarnings("unused")
            Connection dbConn = DriverManager.getConnection(dbURL,userName,userPwd);
            System.out.println("连接数据库成功！");
        }catch(Exception e){
            e.printStackTrace();
            System.out.println("SQL Server连接失败！");
        }
    }

先测试是否能够加载驱动，测试是否能连接数据库，再测试读取数据，你的try不利于查看问题的所在