inputtea.java~20~

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("Dialog", 1, 22));
     jLabel1.setBounds(new Rectangle(119, 31, 144, 33));
     jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setToolTipText("");
    jLabel2.setText("姓        名");
    jLabel2.setBounds(new Rectangle(82, 123, 71, 29));
     tname.setFont(new java.awt.Font("Dialog", 0, 12));
    tname.setBounds(new Rectangle(175, 128, 114, 25));
     jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setText("性        别");
    jLabel3.setBounds(new Rectangle(82, 156, 65, 27));
     jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
    tID.setFont(new java.awt.Font("Dialog", 0, 12));
    sex1.setFont(new java.awt.Font("Dialog", 0, 12));
    sex2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel4.setToolTipText("");
    jLabel4.setText("职        称");
    post.setFont(new java.awt.Font("Dialog", 0, 12));
    sure.setFont(new java.awt.Font("Dialog", 0, 12));
    con.setFont(new java.awt.Font("Dialog", 0, 12));
    bg.add(sex1);bg.add(sex2);
     sex1.setBounds(new Rectangle(172, 161, 39, 23));
     sex2.setBounds(new Rectangle(257, 162, 42, 23));
     jLabel4.setBounds(new Rectangle(82, 184, 55, 34));
     post.setBounds(new Rectangle(176, 191, 113, 26));
     sure.setBounds(new Rectangle(82, 239, 82, 25));
     con.setBounds(new Rectangle(208, 239, 81, 25));
     jLabel5.setBounds(new Rectangle(82, 83, 66, 30));
     tID.setBounds(new Rectangle(175, 90, 114, 26));//添加各个组件
    this.add(jLabel1);
    this.add(jLabel5);
    this.add(tID);
    this.add(tname);
    this.add(sex1);
    this.add(sex2);
    this.add(post);
    this.add(sure);
    this.add(con);
    this.add(jLabel2);
    this.add(jLabel3);
    this.add(jLabel4);
     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("");
                }
           }
     }
}