chaxun.java
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
class chaxun extends JDialog implements ActionListener
{
JLabel bq1;
JTextField wbk1;
JButton an1;
JPanel mb1,mb2;
JTable bg1;
JScrollPane gd1;
Vector ziduan,jilu;//集合类:hengshu
PreparedStatement ps=null;//作为 Statement 的子类,PreparedStatement 继承了 Statement 的所有功能
Connection ct=null;
ResultSet rs=null;
public chaxun(Frame fck,String ckm,Boolean msck)
{
super(fck,ckm,msck);
bq1=new JLabel(" 学号: ");
wbk1=new JTextField(5);
an1=new JButton("查询");
an1.addActionListener(this);
an1.setActionCommand("cx");
mb1=new JPanel();
mb2=new JPanel();
mb1.setLayout(new GridLayout(1,2));
mb1.add(bq1); mb1.add(wbk1); mb2.add(an1);
Vector ziduan,jilu;//集合类:hengshu
ziduan=new Vector();
ziduan.add("学号");
ziduan.add("姓名");
ziduan.add("性别");
ziduan.add("年龄");
jilu=new Vector();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ct=DriverManager.getConnection("jdbc:odbc:sql server");
ps=ct.prepareStatement("select * from Table_3");
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.getString(4));
jilu.add(hang);
}
}catch(Exception e){}
finally{
try{
if(rs!=null)
{
rs.close();
}
if(ps!=null)
{
ps.close();
}
if(ct!=null)
{
ct.close();
}
}catch(Exception e){}
}
bg1=new JTable(jilu,ziduan);
gd1=new JScrollPane(bg1);
this.add(gd1);
this.add(mb1,BorderLayout.NORTH);
this.add(mb2,BorderLayout.SOUTH);
this.setSize(370,270);
this.setLocation(401,281);
this.setResizable(false);
//this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
if(e.getActionCommand().equals("cx"))
{
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
Statement sm=null;
try {
String xueh=this.wbk1.getText().trim();
String sql="select * from Table_3 where xuehao='"+xueh+"'";
xsxx xsxx2=new xsxx(sql);
bg1.setModel(xsxx2);
} catch (Exception e2){}
finally
{
try {
if(rs!=null)
{
rs.close();
}
if(ps!=null)
{
ps.close();
}
if(ct!=null)
{
ct.close();
}
} catch (Exception e3){}
}
}
else if(e.getActionCommand().equals("quxiao"))
{
this.dispose();
}
}
}