急急急,JDK连数据库出现java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver错误,如何解决?
我想用DIRVER-API的方法连接数库,但当我用JAVA连数据库时出现这种错误:java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
应如何解决?问题应该是说没找到这个驱动吧,可是classpath都配置好了,在JSP也可以访问,但放到JAVA中就不行了,是什么问。难道,还要将msbase.jar、mssqlserver.jar、msutil.jar放到JDK中
以下是我的配置:classpath=D:\j2sdk1.4.2\bin;.;D:\j2sdk1.4.2\lib;D:\j2sdk1.4.2\lib\dt.jar;D:\j2sdk1.4.2\lib\tools.jar;D:\Program Files\Apache Software Foundation\Tomcat 5.0\lib\servlet-api.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar
以下是源代码:
import java.sql.*;
import java.io.*;
public class conDatabase
{
private String DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";
//private String URL="jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=1;DatabaseName=pubs";
private Connection con=null;
private Statement stmt=null;
private ResultSet rs=null;
public void connection()throws ClassNotFoundException,SQLException
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
try
{
String URL="jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=1;DatabaseName=pubs";
con=DriverManager.getConnection(URL);
}
catch(Exception e)
{
System.out.println("Connection to Database");
}
}
public ResultSet statement(sql)
{
try
{
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
//System.out.println(sql);
}
catch(Exception e)
{
System.out.println("Unconnection to Database");
}
return rs;
}
public void close1()throws ClassNotFoundException,SQLException
{
try
{
rs.close();
rs=null;
stmt.close();
stmt=null;
}
finally
{
if(con!=null)
{
con.close();
con=null;
}
}
}
}
class conTest
{
public static void main(String[] args)
{
try
{
ResultSet rstest=null;
String sql="select * from jobs";
conDatabase con1=new conDatabase();
con1.connection();
rstest=con1.statement();
while(rstest.next())
{
System.out.println(rstest.getString(1));
System.out.println(rstest.getString(2));
}
rstest.close();
rstest=null;
con1.close1();
}
catch(Exception e)
{
System.out.println(e);
}
}
}