inputtea.java

一个毕业设计的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.printStackTrackTrace();
       }
    }
   private void jbInit() throws Exception
    { 
      setLayout(null);//设置布局方式为空布局
      jLabel1.setFont(new java.awt.Font("宋体",Font.PLAIN,19));//设置各个组件的位置字体样式
      jLabel1.setBounds(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);      //向按钮组中添加单选钮"sex1","sex2"
      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.setBound(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);   //向单选钮组中添加单选钮sex1,sex2
      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 JTextFielld();
   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();//分别利用字符串变量记录"教师编号"(tID),"姓名"(tname)，"性别"(sex1,sex2)
          String xx=tname.getText();
          String sb="女",sql;
           if(sex1.isSelected())
            xb="男";
         String title=(String) post.getSelectedItem();//利用title记录职称组合框中的选择项
         sql="select * from teacher where ID='"+id+"'";
            try      //先从数据库中查询该教师信息，如果该教师已经存在，则弹出相应的信息对话框进行提示，如果不存在则添加该条信息
             {
              ResultSet rs=db.Query(sql);  
              if(rs.next())
               JOptionPane.showMessageDialog(null,"该教师编号已经存在");
              else     
               {
                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("");
           }
      }
    }

}