我刚学java没多长时间,在与数据库连接上遇到了点问题:
我下载了SQL Server 2000 For JDBC 的驱动程序,并安装成功,也设好了环境变量CLASSPATH(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.Connection;
import java.sql.DriverManager;public class Test {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=StudentScore";
String userName = "sa";
String userPwd = "sa";
Connection dbConn; try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
} catch (Exception e) {
System.out.println("发生错误!"+e);
}
}}
编译成功后运行结果是:
发生错误!java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver请高手指点错误的原因。谢谢!
我下载了SQL Server 2000 For JDBC 的驱动程序,并安装成功,也设好了环境变量CLASSPATH(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.Connection;
import java.sql.DriverManager;public class Test {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=StudentScore";
String userName = "sa";
String userPwd = "sa";
Connection dbConn; try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
} catch (Exception e) {
System.out.println("发生错误!"+e);
}
}}
编译成功后运行结果是:
发生错误!java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver请高手指点错误的原因。谢谢!
看看有没有这三个包:msbase.jar mssqlserver.jar msutil.jar