用以下代码连接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;
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;
eclipse出错信息:java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDrive
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=人事; at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at CourseAppl.getConnection(CourseAppl.java:45)
at CourseAppl.main(CourseAppl.java:68)
getConnection() 内部错误跟踪:com.microsoft.sqlserver.jdbc.SQLServerDrive