11.12 java资料4.doc

import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; import java.util.*; class Pinjian extends JFrame { Container c; JLabel lname,lsex; JTextField tname,tsex; JButton badd,bdelete,bupdate,bselect; JTable table ; JScrollPane scroll; Pinjian() { c=this.getContentPane(); c.setLayout(null); lname=new JLabel (姓名); lname.setBounds(20,20,80,30); c.add(lname); tname=new JTextField (); tname.setBounds(110,20,80,30); c.add(tname); lsex=new JLabel (性别); lsex.setBounds(20,60,80,30); c.add(lsex); tsex=new JTextField (); tsex.setBounds(110,60,80,30); c.add(tsex); badd=new JButton (增加); badd.setBounds(20,90,80,30); c.add(badd); bdelete=new JButton (删除); bdelete.setBounds(100,90,80,30); c.add(bdelete); bupdate=new JButton (修改); bupdate.setBounds(180,90,80,30); c.add(bupdate); bselect=new JButton (查询); bselect.setBounds(260,90,80,30); c.add(bselect); //////////// bselect.addActionListener(new SelectListener()); badd.addActionListener(new InsertListener()); ////////////// this.setBounds(210,210,360,310); this.setVisible(true); } class SelectListener implements ActionListener { public void actionPerformed(ActionEvent e) { try { String name=tname.getText(); String sex=tsex.getText(); String sql=select * from student1 where 1=1; if(!name.equals()) { sql+= and name=+name+; } if(!sex.equals()) { sql+= and sex=+sex+; } SQLBean bean=new SQLBean(); Vector col=new Vector();// Vector row=new Vector();// ResultSet res=bean.select(sql); ResultSetMetaData rm=res.getMetaData(); for(int i=1;i=rm.getColumnCount();i++) { col.add(rm.getColumnName(i)); } while(res.next()) { Vector v=new Vector(); for(int i=1;i=rm.getColumnCount();i++) { v.add(res.getString(i)); } row.add(v); if(scroll!=null) { c.remove(scroll); } table=new