主题:[原创]为什么会发生这种事情
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 com.admin.db.opensql.getsqlconn(opensql.java:14)
at com.admin.db.opensql.main(opensql.java:26)
Exception in thread "main" java.lang.NullPointerException
at com.admin.db.opensql.main(opensql.java:28)
以下是我编写的:运行后就是上面的错误信息
package com.admin.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class opensql {
public Connection con;
public Connection getsqlconn(String dburl, String dbuser, String dbpwsd){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con=DriverManager.getConnection(dburl,dbuser,dbpwsd);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
public static void main(String[] args){
opensql op = new opensql();
String dburl = "jdbc:microsoft:sqlserver://192.168.1.222:1433;DatabaseName=master";
String dbuser = "sa";
String dbpwsd = "sa";
String sql="select * from tuser";
Connection con1 = op.getsqlconn(dburl,dbuser,dbpwsd);
try{
Statement st = con1.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
System.out.println("tid = "+rs.getInt(1)+"**"+"name = "+rs.getString(4));
//System.out.println("tid = "+rs.getInt("tid")+"**"+"name = "+rs.getString("name"));
}
}catch(SQLException e){
e.printStackTrace();
}
}
}
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 com.admin.db.opensql.getsqlconn(opensql.java:14)
at com.admin.db.opensql.main(opensql.java:26)
Exception in thread "main" java.lang.NullPointerException
at com.admin.db.opensql.main(opensql.java:28)
以下是我编写的:运行后就是上面的错误信息
package com.admin.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class opensql {
public Connection con;
public Connection getsqlconn(String dburl, String dbuser, String dbpwsd){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con=DriverManager.getConnection(dburl,dbuser,dbpwsd);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
public static void main(String[] args){
opensql op = new opensql();
String dburl = "jdbc:microsoft:sqlserver://192.168.1.222:1433;DatabaseName=master";
String dbuser = "sa";
String dbpwsd = "sa";
String sql="select * from tuser";
Connection con1 = op.getsqlconn(dburl,dbuser,dbpwsd);
try{
Statement st = con1.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
System.out.println("tid = "+rs.getInt(1)+"**"+"name = "+rs.getString(4));
//System.out.println("tid = "+rs.getInt("tid")+"**"+"name = "+rs.getString("name"));
}
}catch(SQLException e){
e.printStackTrace();
}
}
}