当前位置: 代码迷 >> Eclipse >> 数据库连接疏失:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
  详细解决方案

数据库连接疏失:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket

热度:115   发布时间:2016-04-23 18:50:32.0
数据库连接出错:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
运行时,出现在样的出错提示:
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(DriverManager.java:512)
at   java.sql.DriverManager.getConnection(DriverManager.java:171)
at   query.QueryFrame. <init> (QueryFrame.java:48)
at   query.QueryFrame.main(QueryFrame.java:103)

////////////////////////////////////////////////////////
运行环境
IDE   :   Eclipse3.1

DB   :   SQLServer2000  

Driver   :   MS   的官方驱动:   msbase.jar   、   mssqlserver.jar   、   msutil.jar    

/////////////////////////////////////////////////////////
原代码:
package   query;

import   java.awt.Container;
import   java.awt.GridLayout;
import   java.awt.event.ActionEvent;
import   java.awt.event.ActionListener;
import   java.sql.Connection;
import   java.sql.DriverManager;
import   java.sql.ResultSet;
import   java.sql.Statement;

import   javax.swing.JButton;
import   javax.swing.JComboBox;
import   javax.swing.JFrame;
import   javax.swing.JLabel;
import   javax.swing.JPanel;
import   javax.swing.JTextField;


public   class   QueryFrame   extends   JFrame     implements   ActionListener{
JTextField   jf   =   new   JTextField(20);
String[]   value   =   { "姓名 ", "部门 ", "薪水 "};
JComboBox   box   =   new   JComboBox(value);
JButton   find   =   new   JButton( "查询 ");
JPanel   panel_find   =   new   JPanel();
JPanel   panel_content   =   new   JPanel();
Statement   stmt   =   null;

public   QueryFrame() {
this.setTitle( "查询系统 ");
Container   c   =   this.getContentPane();

//完成了查找界面的设置
jf.addActionListener(this);
find.addActionListener(this);
panel_find.add(jf);  
panel_find.add(box);
panel_find.add(find);

c.add(panel_find, "North ");
c.add(panel_content, "Center ");

this.setSize(400,400);
this.setLocation(200,100);
//连接SQL   Server数据库
try{
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
Connection   conn   =   DriverManager.getConnection( "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=xdf ", "xdf ", "xdf ");
stmt   =   conn.createStatement();
}catch(Exception   e){
e.printStackTrace();
}
this.setVisible(true);
}
  相关解决方案