insertstudent.java

一个教务管理系统

package teacherframe.student;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.BorderFactory;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import jdbc.DbManager;
import java.sql.*;
import java.awt.event.FocusEvent;
import java.awt.event.FocusAdapter;
import java.util.*;
import java.text.SimpleDateFormat;

public class InsertStudent extends JFrame {

    SearchStudent st;   //创建一个引用对象
    public InsertStudent(SearchStudent main)
    {
        st=main;
        try {
            jbInit();
            TianJia();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    DbManager db=new DbManager();
    public void TianJia()
    {
     ResultSet rs=db.query("select * from classInfo");   //拿到classInfo表中的所有结果集
    try {
        while (rs.next())               //有多少条记录，就循环多少次
        {
          cbo1.addItem(rs.getString(1));    //每循环一次，将每一条记录中的第一列添加到组合框中
        }
    } catch (SQLException ex) {
      System.out.println(ex.getMessage());
    }
    }
    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        lab.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 20));
        lab.setText("增 加 学 生 基 本 信 息 ");
        lab.setBounds(new Rectangle(164, 22, 282, 61));
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(17, 76, 584, 356));
        jPanel1.setLayout(null);
        lab1.setText("编号:");
        lab1.setBounds(new Rectangle(45, 29, 57, 36));
        txt1.setBounds(new Rectangle(108, 31, 163, 26));
        lab2.setText("姓名：");
        lab2.setBounds(new Rectangle(323, 26, 65, 30));
        lab3.setToolTipText("");
        lab3.setText("性别：");
        lab3.setBounds(new Rectangle(46, 78, 53, 26));
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(108, 76, 163, 31));
        jPanel2.setLayout(null);
        rad1.setSelected(true);
        rad1.setText("男");
        rad1.setBounds(new Rectangle(17, 3, 39, 25));
        rad2.setText("女");
        rad2.setBounds(new Rectangle(81, 3, 39, 25));
        lab4.setText("生日：");
        lab4.setBounds(new Rectangle(323, 81, 50, 29));
        txt2.setBounds(new Rectangle(377, 31, 149, 25));
        txt3.setBounds(new Rectangle(377, 82, 149, 25));
        lab5.setText("班级:");
        lab5.setBounds(new Rectangle(46, 132, 51, 23));
        cbo1.setBounds(new Rectangle(108, 128, 163, 27));
        lab6.setText("电话：");
        lab6.setBounds(new Rectangle(324, 131, 58, 28));
        txt4.setBounds(new Rectangle(377, 129, 149, 25));
        lab7.setText("入校时间：");
        lab7.setBounds(new Rectangle(30, 182, 68, 24));
        txt5.setBounds(new Rectangle(108, 184, 163, 25));
        lab8.setText("地址:");
        lab8.setBounds(new Rectangle(324, 180, 60, 29));
        txt6.setBounds(new Rectangle(378, 182, 148, 25));
        lab9.setText("备注：");
        lab9.setBounds(new Rectangle(45, 234, 59, 29));
        jScrollPane1.setBounds(new Rectangle(106, 240, 420, 105));
        but1.setBounds(new Rectangle(144, 455, 92, 33));
        but1.setText("确定");
        but1.addActionListener(new InsertStudent_but1_actionAdapter(this));
        but2.setBounds(new Rectangle(269, 455, 98, 33));
        but2.setText("取消");
        but2.addActionListener(new InsertStudent_but2_actionAdapter(this));
        but3.setBounds(new Rectangle(394, 455, 95, 33));
        but3.setText("重置");
        but3.addActionListener(new InsertStudent_but3_actionAdapter(this));
        this.setTitle("学生信息管理");
        this.getContentPane().add(lab);
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(but1);
        this.getContentPane().add(but2);
        this.getContentPane().add(but3);
        jPanel2.add(rad2);
        jPanel2.add(rad1);
        jPanel1.add(lab8);
        jPanel1.add(txt4);
        jPanel1.add(cbo1);
        jPanel1.add(txt5);
        jPanel1.add(txt6);
        jPanel1.add(lab4);
        jPanel1.add(lab6);
        jPanel1.add(lab3);
        jPanel1.add(lab5);
        jPanel1.add(lab7);
        jPanel1.add(lab2);
        jPanel1.add(txt2);
        jPanel1.add(txt1);
        jPanel1.add(jScrollPane1);
        jPanel1.add(lab1);
        jPanel1.add(lab9);
        jPanel1.add(txt3);
        jPanel1.add(jPanel2);
        jScrollPane1.getViewport().add(txt7);
        buttonGroup1.add(rad1);
        buttonGroup1.add(rad2);
    }

    JLabel lab = new JLabel();
    JPanel jPanel1 = new JPanel();
    JLabel lab1 = new JLabel();
    JTextField txt1 = new JTextField();
    JLabel lab2 = new JLabel();
    JLabel lab3 = new JLabel();
    JPanel jPanel2 = new JPanel();
    ButtonGroup buttonGroup1 = new ButtonGroup();
    JRadioButton rad1 = new JRadioButton();
    JRadioButton rad2 = new JRadioButton();
    JLabel lab4 = new JLabel();
    JTextField txt2 = new JTextField();
    JTextField txt3 = new JTextField();
    JLabel lab5 = new JLabel();
    JComboBox cbo1 = new JComboBox();
    JLabel lab6 = new JLabel();
    JTextField txt4 = new JTextField();
    JLabel lab7 = new JLabel();
    JTextField txt5 = new JTextField();
    JLabel lab8 = new JLabel();
    JTextField txt6 = new JTextField();
    JLabel lab9 = new JLabel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTextArea txt7 = new JTextArea();
    JButton but1 = new JButton();
    JButton but2 = new JButton();
    JButton but3 = new JButton();
//    public static void main(String[] args) {
//        InsertStudent i=new InsertStudent();
//        i.setSize(620,550);
//        i.setLocation(150,120);
//        i.setVisible(true);
//        i.setResizable(false);
//    }

    public void but1_actionPerformed(ActionEvent e) {
     ResultSet rs=db.query("select * from student where stuID='"+txt1.getText().trim()+"'");
    try {
        if (rs.next()) {
         JOptionPane.showMessageDialog(this,"该编号已经存在，请从新输入！");
         txt1.setText("");
        }else
        {
          if(rad1.isSelected())
          {
           String s1=String.valueOf(cbo1.getSelectedItem());   //用字符串去接收组合框里的内容
           int n=db.exec("insert into student values('"+txt1.getText().trim()+"','"+txt2.getText().trim()+"','男','"+txt3.getText().trim()+"','"+s1+"','"+txt4.getText().trim()+"','"+txt5.getText().trim()+"','"+txt6.getText().trim()+"','"+txt7.getText().trim()+"')");
            //用一个整数去接收exec()方法的返回值
           if(n==1)   //如果n==1 就是说db.exec()方法执行成功
           {
             st.refresh("select * from student");
              JOptionPane.showMessageDialog(this,"添加成功");
              this.setVisible(false);
           }else    //否则，db.exec()方法没执行成功
           {
            JOptionPane.showMessageDialog(this,"输入的信息有误，请从新输入");
            txt1.setText("");
            txt2.setText("");
            txt3.setText("");
            txt4.setText("");
            txt5.setText("");
            txt6.setText("");
            txt7.setText("");
           }

          }else
          {
           String s2=String.valueOf(cbo1.getSelectedItem());
           db.exec("insert into student values('"+txt1.getText().trim()+"','"+txt2.getText().trim()+"','女','"+txt3.getText().trim()+"','"+s2+"','"+txt4.getText().trim()+"','"+txt5.getText().trim()+"','"+txt6.getText().trim()+"','"+txt7.getText().trim()+"')");
           st.refresh("select * from student");
           JOptionPane.showMessageDialog(this,"添加成功");
           this.setVisible(false);
          }
        }
        } catch (SQLException ex)
       {
         System.out.println(ex.getMessage());
       }
    }

    public void but2_actionPerformed(ActionEvent e) {
     this.setVisible(false);
    }

    public void but3_actionPerformed(ActionEvent e) {
       txt1.setText("");
       txt2.setText("");
       txt3.setText("");
       txt4.setText("");
       txt5.setText("");
       txt6.setText("");
       txt7.setText("");
    }

}


class InsertStudent_but3_actionAdapter implements ActionListener {
    private InsertStudent adaptee;
    InsertStudent_but3_actionAdapter(InsertStudent adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.but3_actionPerformed(e);
    }
}


class InsertStudent_but2_actionAdapter implements ActionListener {
    private InsertStudent adaptee;
    InsertStudent_but2_actionAdapter(InsertStudent adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.but2_actionPerformed(e);
    }
}


class InsertStudent_but1_actionAdapter implements ActionListener {
    private InsertStudent adaptee;
    InsertStudent_but1_actionAdapter(InsertStudent adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.but1_actionPerformed(e);
    }
}