为什么找不到 com.microsoft.jdbc.sqlserver.SQLServerDriver
我在Servletl里调用一个DBConnect类的getConnect()方法以取得连接代码如下:
package afu.db;
import java.sql.*;
import java.util.Properties;
import java.io.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public class DBConnect
{
private static Connection conn = null;
private static Properties prop = new Properties();
public static Connection getConnection()
{
try
{
String driverClass = null;
/*-------------------------------------------------------
*connectString.properties该文件内为一组键值对,
*包含了 jdbcDriver,userName,password,jdbc url 等信息。
*将该文件内容型成流,加载到prop中。
*--------------------------------------------------------*/
System.out.println("DBConnect ");
prop.load(DBConnect.class.getResourceAsStream("connectString.properties"));
System.out.println("porp.load connectstring.properties");
// prop.load(DBConnect.class.getResourceAsStream("connectstring.properties"));
/*------------------------
*如果driverClass键存在于
*prop中返回真
*------------------------*/
if(prop.containsKey("driverClass"))
{
System.out.println("if prop.containsKey(driverClass)");
/*------------------------------
*搜索prop中指定键param对应的值
*------------------------------*/
driverClass=prop.getProperty("driverClass");
System.out.println(driverClass);
}
System.out.println("driverClass");
System.out.println("Class.forName");
********* Class.forName(driverClass).newInstance();
String url = prop.getProperty("url");
System.out.println(url);
String userName = prop.getProperty("userName");
System.out.println(userName);
String passWord = prop.getProperty("passWord");
System.out.println(passWord);
conn = DriverManager.getConnection(url,userName,passWord);
System.out.println("getconnection(url,userName,passWord)ed");
}
catch(ClassNotFoundException ex)
{
ex.printStackTrace();
}
catch(SQLException ex)
{
ex.printStackTrace();
}
catch(IOException e)
{
e.printStackTrace();
}
catch(InstantiationException e)
{
e.printStackTrace();
}
catch(IllegalAccessException e)
{
e.printStackTrace();
}
return conn;
}
}
当执行到用*******标记的那一行时抛出意外:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
我明明在编辑工具里把com.microsoft.jdbc.sqlserver.SQLServerDriver所在的包的路径加入进来了.
JAVA文件里也 import com.microsoft.jdbc.sqlserver.SQLServerDriver;
大虾们帮我找找原因