import java.sql.*;
import java.net.URL;public class MyDataBase{ public static void main(String[] args) { String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String query="select * from titles";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
ResultSet r=stmt.executeQuery(query);
while(r.next()){
System.out.println(r.getString(1));}
stmt.close();
con.close();}
catch(Exception e) { System.out.println(e.toString());
}
}}
运行提示的问题是 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis
hing socket.
请问怎么调试
import java.net.URL;public class MyDataBase{ public static void main(String[] args) { String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String query="select * from titles";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
ResultSet r=stmt.executeQuery(query);
while(r.next()){
System.out.println(r.getString(1));}
stmt.close();
con.close();}
catch(Exception e) { System.out.println(e.toString());
}
}}
运行提示的问题是 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis
hing socket.
请问怎么调试
这句少设置了user,password;user--数据库登录用户名,password--用户密码
如没有就下一个SP3补丁打上就可以了