import java.sql.*;public class TestDB {
public static void main(String[] args) throws SQLException{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=admin";
String userName = "admin";
String userPwd = "admin";
Connection dbConn ;
Statement sta;
ResultSet rs;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL,userName, userPwd);
String sql ="select * from card";
sta = dbConn.createStatement();
rs= sta.executeQuery(sql);
if(rs.next())
System.out.println(rs.getString(1));
else
System.out.print("错误1");
dbConn.close();
rs.close();
sta.close();
} catch (Exception e)
{
System.out.print("错误");
e.printStackTrace();
}
}
}
错误java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing 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 Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at TestDB.main(TestDB.java:18)
public static void main(String[] args) throws SQLException{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=admin";
String userName = "admin";
String userPwd = "admin";
Connection dbConn ;
Statement sta;
ResultSet rs;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL,userName, userPwd);
String sql ="select * from card";
sta = dbConn.createStatement();
rs= sta.executeQuery(sql);
if(rs.next())
System.out.println(rs.getString(1));
else
System.out.print("错误1");
dbConn.close();
rs.close();
sta.close();
} catch (Exception e)
{
System.out.print("错误");
e.printStackTrace();
}
}
}
错误java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing 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 Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at TestDB.main(TestDB.java:18)
System.out.println(rs.getString(1));
dbConn.close();
rs.close();
sta.close();
} catch (Exception e)
{
System.out.print("错误");
e.printStackTrace();
}
}
}
至少SP3