UC知道用jdbc连接sql2000的问题
来源：百度知道 编辑：UC知道 时间：2024/05/30 09:55:40
package courseappl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.ResultSet;
import com.microsoft.*;
public class CourseAppl {
private Connection con;
private String url;
private String portNumber;
private String databaseName;
private String serverName;
private String userName;
private String password;
private String sql;
public CourseAppl() {
url="jdbc:microsoft:sqlserver://";
serverName="localhost";
portNumber="1433";
databaseName="test";
userName="sa";
password="";
}
private String getConnectionUrl(){
return url+serverName+":"+portNumber+";databaseName="+databaseName+";&q
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.ResultSet;
import com.microsoft.*;
public class CourseAppl {
private Connection con;
private String url;
private String portNumber;
private String databaseName;
private String serverName;
private String userName;
private String password;
private String sql;
public CourseAppl() {
url="jdbc:microsoft:sqlserver://";
serverName="localhost";
portNumber="1433";
databaseName="test";
userName="sa";
password="";
}
private String getConnectionUrl(){
return url+serverName+":"+portNumber+";databaseName="+databaseName+";&q
很可能是1433端口没有监听,我用你的程序改一下数据库,运行都成功了.你必须先打sp3补丁，再打sp4补丁.完了cmd进入命令行，打netstat -a -n看下1433端口的状态，如果是Listening就可以了.
sql server 2000 for jdbc diver
sql server 2000 for jdbc diver这个驱动你装没有
你装一个sqlserver2000的sp4补丁就行了！
看1433端口开了没，如果没开打个SP3补丁
3个jar包导进去了么？