edittea.java~21~

java语言写的

package scoremis;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

      public class  editTea extends JFrame{
        JLabel jLabel1=new JLabel("教师信息修改");
        JLabel jLabel2=new JLabel("姓名：");
        JTextField tname=new JTextField();
        JLabel jLabel3=new JLabel("性别");
        ButtonGroup bg=new ButtonGroup();
        JRadioButton sex1=new JRadioButton("男");
        JRadioButton sex2=new JRadioButton("女");
        JLabel jLabel4=new JLabel("职称：");
        JComboBox post=new JComboBox();
        JButton sure=new JButton("保存");
        JButton cancel=new JButton("取消");
        JLabel jLabel5=new JLabel("教师编号");
        JTextField tID=new JTextField();
        String bh,xm,xb,zc;
        public editTea(String bh,String xm,String xb,String zc){
           try{
                this.bh=bh;
                this.xm=xm;
                this.xb=xb;
                this.zc=zc;
                jbInit();
                }catch(Exception exception){exception.printStackTrace();}
               }
        private void jbInit() throws Exception {
          this.getContentPane().setLayout(null);
          jLabel1.setFont(new java.awt.Font("Dialog", 1, 22));
          jLabel1.setBounds(new Rectangle(117, 14, 149, 33));
          jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
          jLabel5.setBounds(new Rectangle(98, 61, 66, 40));
          tID.setBounds(new Rectangle(181, 71, 99, 21));
          tID.setFont(new java.awt.Font("Dialog", 0, 12));
          tID.setText(bh);
          jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
          jLabel2.setBounds(new Rectangle(97, 103, 47, 29));
          tname.setBounds(new Rectangle(181, 104, 99, 25));
          tname.setFont(new java.awt.Font("Dialog", 0, 12));
          tname.setText(xm);
          jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
          jLabel3.setBounds(new Rectangle(99, 135, 40, 27));
          sex1.setFont(new java.awt.Font("Dialog", 0, 12));
          sex2.setFont(new java.awt.Font("Dialog", 0, 12));
          post.setFont(new java.awt.Font("Dialog", 0, 12));
          jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
          sure.setFont(new java.awt.Font("Dialog", 0, 12));
          cancel.setFont(new java.awt.Font("Dialog", 0, 12));
          bg.add(sex1); bg.add(sex2);
          sex1.setBounds(new Rectangle(180, 136, 39, 23));
          sex2.setBounds(new Rectangle(229, 136, 39, 23));
          if(xb.equals("男"))
            sex1.setSelected(true);
          else
            sex2.setSelected(true);
            jLabel4.setBounds(new Rectangle(98, 169, 41, 26));
            post.setBounds(new Rectangle(183, 171, 96, 26));
            post.addItem("讲师");
            post.addItem("助教");
            post.addItem("副教授");
            post.addItem("教授");
            post.setSelectedItem(zc);
            sure.setBounds(new Rectangle(99, 239, 78, 26));
            cancel.setBounds(new Rectangle(232, 238, 80, 26));
            sure.addActionListener(new Handel());//给按钮添加监视器
            cancel.addActionListener(new Handel()) ;
            this.getContentPane().add(tID);
            this.getContentPane().add(jLabel1);
            this.getContentPane().add(tname);
            this.getContentPane().add(sex1);
            this.getContentPane().add(sex2);
            this.getContentPane().add(post);
            this.getContentPane().add(sure);
            this.getContentPane().add(cancel);
            this.getContentPane().add(jLabel3);
            this.getContentPane().add(jLabel4);
            this.getContentPane().add(jLabel5);
            this.getContentPane().add(jLabel2);
           }
        class Handel implements ActionListener{
          public void actionPerformed(ActionEvent e){
             dbconn db=new dbconn();
             if(e.getSource()==sure){
             String id=tID.getText();
             String xx=tname.getText();
             String xb1="";
             String sql="";
             if (sex1.isSelected())
               xb1="男";
             else
               xb1="女";
              String title=(String)post.getSelectedItem();
              sql="update teacher set ID='"+id+"', name='"+xx+"',sex='"+xb1+"',title='"+title+"' where ID='"+bh+"'  and name='"+xm+"'  and sex='"+xb+"'  and title='"+zc+"'";
              try{
              int n=db.Update(sql);
              if(n>0){
                JOptionPane.showMessageDialog(null, "修改成功!!");
                bh=id;xm=xx;xb=xb1;zc=title;
              }
              else
                JOptionPane.showMessageDialog(null,"修改失败!!");
              }catch(Exception er){}
           }else{
             setVisible(false);
             QueryTea.scan.doClick() ;
           }
       }
   }
}