安装了sql2005 jdbc的驱动,也设置了classpath,设为“C:\JdbcSqldriver\sqljdbc_1.2\chs\sqljdbc.jar;”,但在netbeans中调试时报java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver异常,谁知道怎么设置啊??
代码:
package jsc.java;
import java.sql.*;
/**
*
* @author Administrator
*/
public class SqlDataConnection {
private String Driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String constr="jdbc:sqlserver://PC-200902061125\\SQLEXPRESS;databasename=db_Examination;user=sa;password=111";
Connection con=null;
Statement stm=null;
ResultSet rs=null;
public SqlDataConnection() throws ClassNotFoundException,SQLException
{
Class.forName(Driver);
con=DriverManager.getConnection(constr);
stm=con.createStatement();
System.out.println(con.isClosed());
}
public ResultSet executeQuery(String sql) throws SQLException
{
rs=null;
rs=stm.executeQuery(sql);
return rs;
}
public void execute(String sql) throws SQLException
{
stm.execute(sql);
}}
代码:
package jsc.java;
import java.sql.*;
/**
*
* @author Administrator
*/
public class SqlDataConnection {
private String Driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String constr="jdbc:sqlserver://PC-200902061125\\SQLEXPRESS;databasename=db_Examination;user=sa;password=111";
Connection con=null;
Statement stm=null;
ResultSet rs=null;
public SqlDataConnection() throws ClassNotFoundException,SQLException
{
Class.forName(Driver);
con=DriverManager.getConnection(constr);
stm=con.createStatement();
System.out.println(con.isClosed());
}
public ResultSet executeQuery(String sql) throws SQLException
{
rs=null;
rs=stm.executeQuery(sql);
return rs;
}
public void execute(String sql) throws SQLException
{
stm.execute(sql);
}}
netBeans中,点击要添加jar文件的项目出现:源包,测试包,库,测试库。
右键单击库,选择添加JAR/文件夹...,将sqljdbc.jar导入即可。