edittea.java

一个毕业设计的Java学生成绩管理系统

package scoremis;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import jfava.sql.*;
public class editTea extends JPanel
{
    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("保存");
    JLabel jLabel5=new JLabel("教师编号");
    JTextField tID=new JTextField();
    String bh,xm,xb,zc;
    public editTea(String bh,String xm,String xb,String zc)//执行类QueryTea中的构造函数editTea er=new editTea(bh,xm,xb,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.setLayout(null);     //设置布局管理器的布局方式为null方式
        jLabel1.setFont(new java.awt.Font("宋体",Font.PLAIN,20));//设置各种组件的字体，位置等属性
        jLabel1.setBounds(new Rectangle(133,14,149,33));
        jLabel5.setBounds(new Rectangle(80,60,66,40));
        tID.setBounds(new Rectangle(154,70,79,21));
        tID.setText(bh);   //设置教师编号文本框(tID)的初始值为bh的值
        jLabel2.setBounds(new Rectangle(100,98,47,29));
        tname.setBounds(new Rectangle(154,103,78,25));
        tname.setText(xm);//设置姓名文本框(tname)的初始值为xm
        jLabel3.setBounds(new Rectangle(100,133,40,27));
        bg.add(sex1);//向性别按钮组bg中添加两个单选钮'sex1','sex2'
        bg.add(sex2);
        sex1.setBounds(new Rectangle(151,136,39,23));
        sex2.setBounds(new Rectangle(200,136,39,23));
        if(xb.equals("男"))     //如果在性别单选钮中选中的值为"男"，则sex1设为选中状态，否则sex2为选中的状态
          sex1.setSelected(true);
        else 
          sex2.setSelected(true);
        jLabel4.setBounds(new Rectangle(100,162,41,34));
        post.setBounds(new Rectangle(155,166,96,26));
        post.addItem("讲师");    //向"职称"组合框post中添加各值
        post.addItem("助教");
        post.addItem("副教授");
        post.addItem("教授");
        post.setSelectedItem(zc);  //设置"职称"组合框的初始值为zc的值
         sure.setBounds(new Rectangle(145,215,73,25));
         sure.addActionListener(new Handel());   //为保存按钮(sure)添加监视器
       this.add(jLabel1);
       this.add(jLabel5);
       this.add(tID);
       this.add(jLabel2);
       this.add(tname);
       this.add(jLable3);
       this.add(sex1);
       this.add(sex2);
       this.add(jLabel4);
       this.add(post);
       this.add(sure);

      }
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 xb="";
                String sql="";
                if(sex1.setSelected())
                   xb="男";
                 else 
                   xb="女";
                String title=(String) post.getSelectedItem();
                sql="update teacher set name='"+xx+"',sex='"++xb"',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,"修改成功");
                      else
                     JOptionPane.showMessageDialog(null,"修改失败");
                   }
                 catch(Exception er)
                   {}
             }
         }
      }
}