数据库连接不上

显示全部楼层 · 2011-3-18 11:36:43

import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.util.Vector;
import java.sql.*;
public class Test1 extends JFrame{
Vector rowData,columnNames;
JTable jt=null;
JScrollPane jsp=null;
//定义操作数据库需要的东东
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;

public static void main(String[] args) {
// TODO Auto-generated method stub

Test1 test1=new Test1();
}
public Test1()
{
columnNames=new Vector();
//设置列名
columnNames.add("学号");
columnNames.add("性别");
columnNames.add("年龄");
columnNames.add("籍贯");
columnNames.add("系别");

rowData=new Vector();

try{
//加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=model","sa","azqw");
ps=ct.prepareStatement("select * from stu");
rs=ps.executeQuery();

while(rs.next())
{

//rowData可以存放多行

Vector hang=new Vector();

hang.add(rs.getString(1));

hang.add(rs.getString(2));

hang.add(rs.getString(3));

hang.add(rs.getInt(4));

hang.add(rs.getString(5));

hang.add(rs.getString(6));

//加入到rowData

rowData.add(hang);
}
}catch(Exception e){
e.printStackTrace();
}finally{
//关闭
try{

if(rs!=null)rs.close();

if(ps!=null)ps.close();

if(ct!=null)ct.close();
}catch(Exception e){

e.printStackTrace();
}
}
//初始化JTable
jt=new JTable(rowData,columnNames);

//初始化jsp JScrollPane
jsp=new JScrollPane(jt);

//把jsp放入到jframe
this.add(jsp);
this.setSize(400,300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);

}
}
数据库没有连接上
出错：
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.(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 Test1.(Test1.java:38)
at Test1.main(Test1.java:21)
不懂，请高手指教

千问 · 2011-3-18 11:36:43

把你定义的关于数据库的东东全部放到try{ //加载驱动 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=model","sa","azqw"); ps=ct.prepareStatement("select * from stu"); rs=ps.executeQuery();里面试试？？？