querytea.java~3~

java语言写的

package scoremis;
import java.awt.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
import java.util.Vector;
import java.sql.ResultSet;
import java.awt.event.*;

//import java.awt.event.ActionEvent;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class QueryTea  extends JPanel{
  BorderLayout borderLayout1=new BorderLayout();
  JLabel ll=new JLabel("值:");
   JLabel jLabel1=new JLabel("查询条件:");
   JComboBox tiaojian=new JComboBox();
   JTextField tname=new JTextField(10);
   JButton query=new JButton("查询");
   JButton scan=new JButton("浏览");
   JButton del=new JButton("删除");
   JButton edit=new JButton("修改");
   JTextField show=new JTextField(10);
   Vector tempvector=new Vector(1,1);
   DefaultTableModel model=new DefaultTableModel();
   JTable dbtable=new JTable(model);
   JScrollPane sp=new JScrollPane(dbtable);
   ResultSet rs=null;
   String bh="",zc="",xb="",xm="";
  public QueryTea() {
    try{jbInit();}
    catch(Exception exception) {exception.printStackTrace() ;}
  }
   private void jbInit() throws Exception{
   jLabel1.setFont(new java.awt.Font("Dialog", 0, 12));
    tiaojian.setFont(new java.awt.Font("Dialog", 0, 12));
    tname.setFont(new java.awt.Font("Dialog", 0, 12));
    query.setFont(new java.awt.Font("Dialog", 0, 12));
    scan.setFont(new java.awt.Font("Dialog", 0, 12));
    edit.setFont(new java.awt.Font("Dialog", 0, 12));
    del.setFont(new java.awt.Font("Dialog", 0, 12));
    ll.setFont(new java.awt.Font("Dialog", 0, 12));
    dbtable.setFont(new java.awt.Font("Dialog", 0, 12));
    sp.setFont(new java.awt.Font("Dialog", 0, 12));
    sp.setPreferredSize(new Dimension(454, 240));
    sp.setRequestFocusEnabled(true);
    show.setEnabled(false);
    add(jLabel1);add(tiaojian);
    tiaojian.addItem("");
    tiaojian.addItem("编号");
    tiaojian.addItem("姓名");
    tiaojian.addItem("性别");
    tiaojian.addItem("职称");
    add(ll);add(tname);
    add(query); add(scan);add(edit); add(del);
    add(sp,"Center");
    add(show,"North");
    query.addActionListener(new EventHadel());
    scan.addActionListener(new EventHadel());
    edit.addActionListener(new EventHadel());
    del.addActionListener(new EventHadel());
    edit.setEnabled(false);
    del.setEnabled(false);
    model.addColumn("编号");
    model.addColumn("姓名");
    model.addColumn("性别");
    model.addColumn("职称");
    dbtable.addMouseListener(new MouseAdapter(){
    public void mouseClicked(MouseEvent e)
  { int j=dbtable.getSelectedRow();
    bh=(String)model.getValueAt(j,0);
    xm=(String)model.getValueAt(j,1);
    xb=(String)model.getValueAt(j,2);;
    zc=(String)model.getValueAt(j,3);
    edit.setEnabled(true);
    del.setEnabled(true);
  }
    });
}
   class EventHadel implements ActionListener{
    public void actionPerformed(ActionEvent e){
    dbconn db=new dbconn();
    String sql="";
    if(e.getSource()==scan||e.getSource()==query ){
      int j=model.getRowCount();
      if(j>0){
       for(int i=0;i<j;i++)
         model.removeRow(0);
      }
      if(e.getSource()==query){
      String tj=(String)tiaojian.getSelectedItem();
      String mingcheng="";
      if(tiaojian.getSelectedItem().equals("") || tname.getText().equals(""))
        JOptionPane.showMessageDialog(null,"请选择查询条件并输入查询内容!!");
      else{
       if(tj.equals("编号"))
          mingcheng="ID";
          else if(tj.equals("姓名"))
        mingcheng="name";
            else if(tj.equals("性别"))
          mingcheng="sex";
          else
           mingcheng="title";
        sql="select * from teacher where "+mingcheng+"='"+tname.getText()+"'";
       }
      }else if(e.getSource()==scan )
          sql="select * from teacher";
          try {
            rs=db.Query(sql);
            int i=0;
            while(rs.next()) {
            i++;
            String tbh=rs.getString(1);
          if(!tbh.startsWith("admin")){
          tempvector=new Vector(1,1);
          tempvector.add(tbh);
          tempvector.add(rs.getString(2));
          tempvector.add(rs.getString(4));
          tempvector.add(rs.getString(5));
          model.addRow(tempvector);
          scan.setText("刷新");
          }
          }
          if(i==0)
            JOptionPane.showMessageDialog(null,"没有该教师或数据库中未录入该教师!!");
            dbtable.setRowSelectionAllowed(true);
            int sr=dbtable.getSelectedRow();
          }catch(Exception e2){System.out.println(e2.toString());
          }
      }else if(e.getSource()==edit){
        Toolkit tk=Toolkit.getDefaultToolkit() ;
        Dimension sSize=tk.getScreenSize() ;
        int sh=sSize.height;
        int sw=sSize.width ;
        editTea er=new editTea(bh,xm,xb,zc);
        er.setSize(sh/2,sh/2);
        er.setLocation(sh/4,sh/4);
        er.setVisible(true);
         }else if(e.getSource()==del){
         try{
          int el=JOptionPane.showConfirmDialog(null,"确定要删除吗?","确认",JOptionPane.OK_CANCEL_OPTION);
         if(el==0){
         String sql2="",sql3="";
         if(!tname.getText().equals("")){
         sql="select ID from teacher where name='"+tname.getText()+"'";
         ResultSet rs=db.Query(sql);
         if(rs.next())
           bh=rs.getString(1);
           }
         sql="delete * from teacher where ID='"+bh+"'";
         sql2="select * from T_C where tID='"+bh+"'";
         sql3="delete * from T_C where tID='"+bh+"'";
         int i=db.Update(sql);
         if(i>0){
         ResultSet rs=db.Query(sql2);
         boolean have=false;
         if(rs.next())
           have=true;
           if(have==true){
           int j=db.Update(sql3);
           if(j>0){
             JOptionPane.showMessageDialog(null, "删除成功!!");
             scan.doClick() ;
           }
             }else{
             JOptionPane.showMessageDialog(null,"删除成功!!");
             scan.doClick() ;
             }
           }
         }
        }catch(Exception er) {}
      }
    }
  }
}