inputtea.java~16~

java语言写的

package scoremis;

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

public class InputTea extends JPanel{
    public InputTea(){
       try{
         jbInit();
       }catch(Exception exception){exception.printStackTrace();}
          }
  private void jbInit() throws Exception{//设置布局为空，需要设置各组件的位置
     setLayout(null);
     jLabel1.setFont(new java.awt.Font("宋体",Font.PLAIN,19));
     jLabel1.setBounds(new Rectangle(139,39,231,33));
     jLabel2.setBounds(new Rectangle(144,125,71,29));
     tname.setBounds(new Rectangle(233,128,114,25));
     jLabel3.setBounds(new Rectangle(140,157,65,27));
     bg.add(sex1);
          bg.add(sex2);
          sex1.setBounds(new Rectangle(230,161,39,23));
          sex2.setBounds(new Rectangle(315,162,42,23));
          jLabel4.setBounds(new Rectangle(140,184,55,34));
          post.setBounds(new Rectangle(234,191,113,26));
          sure.setBounds(new Rectangle(140,239,82,25));
          con.setBounds(new Rectangle(266,239,81,25));
          jLabel5.setBounds(new Rectangle(140,83,66,30));
          tID.setBounds(new Rectangle(233,90,114,26));
          add(jLabel1);//添加各个组件
          add(jLabel5);
          add(tID);
          add(jLabel2);
          this.add(tname);
          add(jLabel3);
          add(sex1);
          this.add(sex2);
          this.add(jLabel4);
          add(post);
          add(sure);
          add(con);
    post.addItem("讲师");//给组合框职称添加项目
    post.addItem("助教");
    post.addItem("副教授");
    post.addItem("教授");
    sure.addActionListener(new Handel());
    con.addActionListener(new Handel());
          }
  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 con=new JButton("继续");
  JLabel jLabel5=new JLabel("教师编号：");
  JTextField tID=new JTextField();

  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="女",sql;
                          if(sex1.isSelected())
                            xb="男";
                          String title=(String)post.getSelectedItem();
                          sql="select * from teacher where ID='"+id+"'";
                          try{//首先从数据库中查询该教师信息，找到则不再添加，否则进行添加
                                  ResultSet rs=db.Query(sql);
                                  if(rs.next())
                                   JOptionPane.showMessageDialog(null,"该教师编号已存在！！");
                                  else{//普通教师的密码为“123456”
                                          sql="insert into teacher(ID,name,psd,sex,title) values('"+id+"','"+xx+"','123456','"+xb+"','"+title+"')";
                                          int n=db.Update(sql);
                                          if(n>0)
                                            JOptionPane.showMessageDialog(null,"添加成功！！");
                                          else
                                            JOptionPane.showMessageDialog(null,"添加失败！！");

                                          }

                          }catch(Exception er){}

                          }
                          else{//处理继续事件
                                  tID.setText("");
                                  tname.setText("");

                                  }
                  }

          }
        }