相同的代码`我在学校的电脑上可以正常执行``可是回家电脑报以下错误呀`相同的数据库和相同的JDBC包``
而且已经把数据库用户名都改为相同了```````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 less08.NewJFrame.inittree(NewJFrame.java:319)
at less08.NewJFrame.<init>(NewJFrame.java:105)
at less08.NewJFrame$1.run(NewJFrame.java:93)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
原代码在这里
public class Test
{
public static void main(String[] args) throws Exception
{
//加驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//建连接
Connection conn=DriverManager.getConnection("jdbc:Microsoft:sqlserver://localhost:1433;databasename=pubs","sa","sa");
//发送命令
Statement sm=conn.createStatement();
ResultSet rs=sm.executeQuery("select * from jobs");
while(rs.next())
{
int job_id=rs.getInt(1);
String job_desc=rs.getString(2);
int job_min=rs.getInt(3);
int job_max=rs.getInt(4);
System.out.println("job_id:"+job_id+"job_desc:"+job_desc+"job_min:"+job_min+"job_max:"+job_max);
}
//关闭 0
rs.close();
sm.close();
conn.close();
}}
而且已经把数据库用户名都改为相同了```````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 less08.NewJFrame.inittree(NewJFrame.java:319)
at less08.NewJFrame.<init>(NewJFrame.java:105)
at less08.NewJFrame$1.run(NewJFrame.java:93)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
原代码在这里
public class Test
{
public static void main(String[] args) throws Exception
{
//加驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//建连接
Connection conn=DriverManager.getConnection("jdbc:Microsoft:sqlserver://localhost:1433;databasename=pubs","sa","sa");
//发送命令
Statement sm=conn.createStatement();
ResultSet rs=sm.executeQuery("select * from jobs");
while(rs.next())
{
int job_id=rs.getInt(1);
String job_desc=rs.getString(2);
int job_min=rs.getInt(3);
int job_max=rs.getInt(4);
System.out.println("job_id:"+job_id+"job_desc:"+job_desc+"job_min:"+job_min+"job_max:"+job_max);
}
//关闭 0
rs.close();
sm.close();
conn.close();
}}
解决方案 »
- jTree 问题
- java数据库里日期2006-06-19 16:20:12,为什么取出2006-06-19 16:20:12.0
- 大侠帮忙,url经javascript的encodeURI编码后,在jsp中如何取得url中的中文参数值?
- 做一个调查:各位用的LINUX是哪个公司出的?
- java 的几个问题
- 对AtomicInteger的一点疑惑,请大师帮忙解答一下
- 关于args[]??
- appendcaar这样用对吗?
- 各位兄弟!有没有用西门子6688i/6686i/6688手机的啊?支持java的,讨论一下!
- 请问如何限制jTextFiled的输入字符的长度?
- 急,ArrayList类型报错
- 路径问题?
参考http://blog.chinaunix.net/u/21684/showart_270377.html