Question

JAVA连接SQL2000 JDBC问题 com.microsoft.jdbc.sqlserver.SQLServerDriver No suitable driver found for

提示！
com.microsoft.jdbc.sqlserver.SQLServerDriver
No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseN
ame=libmanager
Press any key to continue...

怎么改能连接上

代码如下
import java.sql.*;

public class ConDB {
Connection conn = null;

CallableStatement statement = null;

Statement stmt = null;

ResultSet rs = null;

// 导入驱动
public ConDB() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (java.lang.ClassNotFoundException e) {
System.err.println(e.getMessage());
}
}

// 数据库查询
public ResultSet executeQuery(String sql) {
try {
conn = DriverManager
.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=libmanager",
"sa", "");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}

// 数据库更新
public int executeUpdate(String sql) {
int result = 0;
try {
conn = DriverManager
.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=libmanager",
"sa", "");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
result = stmt.executeUpdate(sql);
} catch (SQLException ex) {
System.err.println(ex.getMessage());
result = 0;
}
return result;
}

// 调用存储过程
public ResultSet executeProcedure(String sql) {
try {
conn = DriverManager
.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=libmanager",
"sa", "");
statement = conn.prepareCall(sql);
statement.execute();
rs = statement.getResultSet();
} catch (SQLException ex) {
System.err.println(ex);
}
return rs;
}
public static void main(String[] args){
ConDB ff=new ConDB();
ResultSet rs = ff.executeQuery("SELECT top 5 * FROM Books order by Totaljie desc");
try{
while(rs.next()){
System.out.println(rs.getString("Bookname".trim()));

}
}
catch(Exception e){}
}

}
把JAR包放进classpath里面???
一楼能不能说?细点？
什么是JAR包??classpath??

Answer 1

如果你用的是eclipse 右键单击项目,选buildpath 在打开的窗口中(图)

点边上那个add external jars  然后找到并选择

msbase.jar

mssqlserver.jar

msutil.jar

共3个

这3个需要自己去下载

还有SQL2000需要打上SP4补丁才可以用JDBC连

Answer 2

三个jar包，你有吗，没有我传你百度hi随时在线
msbase.jar
mssqlserver.jar
msutil.jar

Answer 3

他们说得都对.提示就是缺少驱动包.你需要下载sql 2000的SP3 和SP4补丁.然后下栽JDBC,把JDBC的包拷到项目的lib目录下.

Answer 4

需要有sqlserver2000的jar包，然后把JAR包放进classpath里面，有可能是jar包不合适

Answer 5

把JAR包放进classpath里面