JDBC的错误(抱SQL异常`)

wuying8624 2009-12-08 10:24:23

相同的代码`我在学校的电脑上可以正常执行``可是回家电脑报以下错误呀`相同的数据库和相同的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();

	}



}