import java.sql.*;
public class coffees{
public static void main(String args[]){
try
{ System.out.println("aaaaaaaaaaaaaaaa");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
System.out.println("aaaaaaaaaaaaaaaa");
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
String user="sa";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
System.out.println("aaaaaaaaaaaaaaaa");
Statement stm=conn.createStatement();
System.out.println("aaaaaaaaaaaaaaaa");
String sql="select * from sales";
ResultSet rs =stm.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString(1));
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
执行结果:
aaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaa
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis
hing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at coffees.main(coffees.java:13)
Press any key to continue...
求哪位大侠帮个忙.很急的,谢谢!
轻薄的假像 这位大侠,我的SQLSERVER SP2补丁已经安装完拉,你看还可能是哪有问题那???谢谢拉!
谢谢三位为我排忧解难,你们的方法不同程度的帮助了我,我都不知道该把分加给谁拉,这里先谢谢你们拉!