菜鸟遇上数据库连接问题
连接SQLServer2000出现以下问题,不知道怎么解决
Code:
public class DBConn {
protected static String dbClassName=
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
protected static String dbUrl=
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_library;";
protected static String dbUser="sa";
protected static String dbPwd="";
private static Connection conn=null;
private DBConn(){
try{
if(conn==null){
Class.forName(dbClassName);
conn=DriverManager.getConnection(dbUrl,dbUser,dbPwd);
}
}catch(Exception ee){
ee.printStackTrace();
}
}
...
}
Error:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
...