eclipse3.21如何联接SQL Server 2000+SP4？？？？

[wjzfly]

eclipse3.21+myeclipse5.01GA如何联接WINxp(sp2)+SQL Server 2000(SP4)？？？？请各位大哥指点一下小弟。看网上说eclipse要与SQL相匹配才能正常访问的。

[houston123]

String url="jdbc.microsoft:sqlserver://localhost:1433;databaseName=?"
Class.forname("com.microsoft.jdbc.sqlserver.SqlServerDriver")
Connection con=DriverManager.getConnection(url,"sa","sa")

[sjjga]

tring driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url= "jdbc:microsoft.sqlserver://locall:1433;DatabaseName=?";
String user ="";
String password ="";
Class.forName(driver);
Connection conn=DriverManager.getConnection( url,user,password);

[gaohaha]

用JDBC......记得要导入包

[jianghu77]

String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url= "jdbc:microsoft.sqlserver://locall:1433;DatabaseName=?";
String user ="";
String password ="";
Class.forName(driver);
Connection conn=DriverManager.getConnection( url,user,password);

楼上的少了个S帮改过来了

[jianghu77]

public class DBC{
Connection conn=null;
Statement st=null;
ResultSet rs=null;
String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=DB";
String user="sa";
String password="";
public DBConn(){
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DirverManager.getConnection();
}catch(Exception ex)
{
ex.printStackTrace
}
}
}

[jianghu77]

忘了点东西

conn=DriverManager.getConnection(url,user,password);

[tony_zhou820602]

将jar包导入你的工程
然后用jdbc方式联啊

[wtucel]

1、下载SQL Server 2000 driver for JDBC

http://www.microsoft.com/downloads/results.aspx?displaylang=en&freeText=sql+server+2000+driver+for+jdbc

2、在eclipse工程库中导入SQL Server 2000 Driver For JDBC Lib目录下的三个.jar文件

3、测试代码：

import java.sql.*;

public class TestDB {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
String userName = "sa";
String userPwd = "";
Connection dbConn

try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
}
Catch (Exception e) {
e.printStackTrace();
}
}
}