Question

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]???????说????效 sql server数据库连接失败

package Test;import java.sql.*;public class test{ public static void main(String[] args) { Connection ct=null; Statement sm=null; try { //加载驱动 sun.jdbc.odbc.jdbcodbcDriver Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //Class.forName("sun.jdbc.odbc.jdbcodbcDriver"); //得到连接 ct=DriverManager.getConnection("jdbc:odbc:Test"); sm=ct.createStatement(); //执行添加操作 int i= sm.executeUpdate("insert into Stu values('王菲','2212','男')"); ct.commit(); if(i==1){ System.out.println("添加成功"); }else{ System.out.println("添加失败"); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); }finally{ try { if(sm!=null){ sm.close(); } if(ct!=null){ ct.close(); } } catch (SQLException e2) { // TODO: handle exception e2.printStackTrace(); } } }

}

Answer 1

连接SQL Server2000数据库
Class.forName("com.microsoft.JDBC.sqlserver.SQLServerDriver"衫局尘腊核);
String url="JDBC:microsoft:sqlserver://localhost:1433;DatabaseName=testDb";
String user="或禅test"; String password="test";
Connection con=DriverManager.getConnection(url,user,password);

Answer 2

连接SQL Server2000数据库
Class.forName("com.microsoft.JDBC.sqlserver.SQLServerDriver"衫局尘腊核);
String url="JDBC:microsoft:sqlserver://localhost:1433;DatabaseName=testDb";
String user="或禅test"; String password="test";
Connection con=DriverManager.getConnection(url,user,password);