最近也不知道是怎么了,sqlserver死活连不上,JAR包也放好了,程序也没问题,以前从来没出现过这种情况,程序如下:
import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class connDB
{
public static void main(String args[])
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection cn=DriverManager.getConnection"jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs","sa","sa");
Statement st=cn.createStatement();
ResultSet rs = st.executeQuery("select * from authors");
while(rs.next())
{
System.out.print(rs.getString(2)+" ");
System.out.print(rs.getString(3)+" ");
System.out.println("--------------------------");
}
rs.close();
st.close();
cn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
一运行就出下面的异常,说建立socket出现错误,请问是什么原因(数据库的安装没有问题),我都TM怀疑是不是RPWT了,靠!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class connDB
{
public static void main(String args[])
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection cn=DriverManager.getConnection"jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs","sa","sa");
Statement st=cn.createStatement();
ResultSet rs = st.executeQuery("select * from authors");
while(rs.next())
{
System.out.print(rs.getString(2)+" ");
System.out.print(rs.getString(3)+" ");
System.out.println("--------------------------");
}
rs.close();
st.close();
cn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
一运行就出下面的异常,说建立socket出现错误,请问是什么原因(数据库的安装没有问题),我都TM怀疑是不是RPWT了,靠!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货