package com.test1;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
public class Test22 extends JFrame implements ActionListener{
Vector rowData,columnNames;
JTable jt;
JScrollPane jsp;
String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String str="jdbc:sqlserver://10.12.242.171:1433;databasename=spdb1";
String name="sa";
String pass="123456";
public static void main(String[] args) {
new Test22();
}
public Test22(){
columnNames=new Vector();
rowData=new Vector();
ResultSet rs=null;
PreparedStatement ps=null;
Connection conn=null;
columnNames.add("学号");
columnNames.add("姓名");
columnNames.add("性别");
columnNames.add("年龄");
columnNames.add("地址");
columnNames.add("专业");
try {
Class.forName(driver);
conn=DriverManager.getConnection(str,name,pass);
String sql="select * from stu";
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
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.add(hang);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
if(rs!=null)rs.close();
if(ps!=null)ps.close();
if(conn!=null)conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
jt=new JTable(rowData,columnNames);
jsp=new JScrollPane(jt);
this.add(jsp);
this.setSize(500,300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
public void actionPerformed(ActionEvent e) {
}
}
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
public class Test22 extends JFrame implements ActionListener{
Vector rowData,columnNames;
JTable jt;
JScrollPane jsp;
String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String str="jdbc:sqlserver://10.12.242.171:1433;databasename=spdb1";
String name="sa";
String pass="123456";
public static void main(String[] args) {
new Test22();
}
public Test22(){
columnNames=new Vector();
rowData=new Vector();
ResultSet rs=null;
PreparedStatement ps=null;
Connection conn=null;
columnNames.add("学号");
columnNames.add("姓名");
columnNames.add("性别");
columnNames.add("年龄");
columnNames.add("地址");
columnNames.add("专业");
try {
Class.forName(driver);
conn=DriverManager.getConnection(str,name,pass);
String sql="select * from stu";
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
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.add(hang);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
if(rs!=null)rs.close();
if(ps!=null)ps.close();
if(conn!=null)conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
jt=new JTable(rowData,columnNames);
jsp=new JScrollPane(jt);
this.add(jsp);
this.setSize(500,300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
public void actionPerformed(ActionEvent e) {
}
}