JAVA连接SQL server 2000 的问题 （急！！！）
用以下代码连接SQL server 2000出错
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.ResultSet;
//import java.*;
public class CourseAppl {
private Connection conn;
private String url;
private String serverName;
private String portNumber;
private String databaseName;
private String userName;
private String password;
private String sql;
CourseAppl() {
url = "jdbc:microsoft:sqlserver:// ";
serverName = "127.0.0.1 ";
portNumber = "1433 ";
databaseName = "master ";
userName = " ";
password = " ";
}
private String getConnectionUrl() {
//System.out.println (url + serverName + ": "
// + portNumber + ";databaseName= "
//+ databaseName + "; ");
return url + serverName + ": "
+ portNumber + ";databaseName= "
+ databaseName + "; ";
}
private Connection getConnection() {
try {
System.out.println (getConnectionUrl());
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
//Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDrive ");
conn =
DriverManager.getConnection(getConnectionUrl(),userName,password);
if(conn != null) {
System.out.println ( "数据库连接成功! ");
}
}catch(Exception ce) {
ce.printStackTrace();
System.out.println ( "getConnection() 内部错误跟踪: " +
ce.getMessage());
}
return conn;
}
public static void main(String[] args) {
CourseAppl retObj = new CourseAppl();
retObj.getConnection();
}
}
出错信息为：
jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=master;
getConnection() 内部错误跟踪:No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at CourseAppl.getConnection(CourseAppl.java:48)
at CourseAppl.main(CourseAppl.java:69)
已下在驱动，环境变量设置如下：
E:\Program Files\Java\jdk1.5.0_08\lib\tools.jar;
E:\Program Files\Java\jre1.5.0_08\lib\ext\mssqlserver.jar;
E:\Program Files\Java\jdk1.5.0_08\lib\dt.jar;
E:\Program Files\Java\jre1.5.0_08\lib\ext\msutil.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;
[解决办法]
驱动错了
------解决方案--------------------
唉,驱动错了.
[解决办法]
用桥的话就要设置odbc数据源，用url的话就要用jdbc驱动，两个搞混了
[解决办法]
的确是驱动错了,为什么要把那注释掉呢,用那个驱动就对啦!
