请各位指教:代码如下:
import java.sql.*;
public class Jdbc {
public static void main(String[] args) {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433";
Connection con=DriverManager.getConnection(url,"sa","");
con.setCatalog("bookTest");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo");
while(rs.next())
{
System.out.print(rs.getString(1)+" "+rs.getString(2)+" "
+rs.getFloat(3)+" "+rs.getString(4));
}
rs.close();
stmt.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
我已将SQlserver2000的驱动三个文件msbase.jar,mssqlserver.jar,msutil.jar 解压缩到当前目录下,可还是有运行错误,出错信息为第七行:
java.sql.SQLException:[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing
socket.
import java.sql.*;
public class Jdbc {
public static void main(String[] args) {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433";
Connection con=DriverManager.getConnection(url,"sa","");
con.setCatalog("bookTest");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo");
while(rs.next())
{
System.out.print(rs.getString(1)+" "+rs.getString(2)+" "
+rs.getFloat(3)+" "+rs.getString(4));
}
rs.close();
stmt.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
我已将SQlserver2000的驱动三个文件msbase.jar,mssqlserver.jar,msutil.jar 解压缩到当前目录下,可还是有运行错误,出错信息为第七行:
java.sql.SQLException:[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing
socket.
2。xp的话,需要sqlsp4
44.4 MB
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
78.5 MB
SQL2000-KB884525-SP4-ia64-ENU.EXE
49.1 MB
SQL2000-KB884525-SP4-x86-ENU.EXE
66.9 MB
有什么不一样?