//这是我连接数据库的代码import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class first{
public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://20101119-1553:1433; DatabaseName=exercise";
String userName = "sa";
String userPwd = "123";
Connection dbConn ; try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection SUCcessful!");
}
catch(Exception e) {
e.printStackTrace();
} }
}
//这是出现的错误java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at first.main(first.java:14)
//这是14行的代码:Class.forName(driverName); //我基本的准备都做好了,环境变量“C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib”也设置好了
还出现这个问题是怎么了?求帮助啊、、、、、
import java.sql.DriverManager;
import java.sql.SQLException;public class first{
public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://20101119-1553:1433; DatabaseName=exercise";
String userName = "sa";
String userPwd = "123";
Connection dbConn ; try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection SUCcessful!");
}
catch(Exception e) {
e.printStackTrace();
} }
}
//这是出现的错误java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at first.main(first.java:14)
//这是14行的代码:Class.forName(driverName); //我基本的准备都做好了,环境变量“C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib”也设置好了
还出现这个问题是怎么了?求帮助啊、、、、、
第二,下载到jar包之后,工程名右键-build path-configure-libraries-add extern jars 然后找到对应的jar加进去,有几个加几个,然后重新运行
把驱动jar放到WEB-INF/lib下。
没有这个类,sql2000三个架包,重新导入一下,2005只要导入一个
微软连接SQLServer 2000的jar包有3个文件,如msbase.jar、mssqlserver.jar、msutil.jar
也可以使用JTDS,如jtds-1.2.2.jar