addteacherframe.java~41~

用java 写的学生信息管理系统

package prjTeacher;

import java.awt.BorderLayout;
import prjsystementer.*;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JTextArea;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.*;
import java.awt.Font;
import java.awt.SystemColor;
import java.awt.Color;


public class AddTeacherFrame extends JDialog {
    public AddTeacherFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    Teacher tea;
    public AddTeacherFrame(Teacher t) {
        this();
        this.tea = t;
        this.txtID.setText(t.getTeacherID());
        this.txtName.setText(t.getTeacherName());
        this.txtPhone.setText(t.getTeacherPhone());
        this.txtMemo.setText(t.getTeacherMemo());
        this.txtID.setEnabled(false);
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        lblID.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblID.setText("编号");
        lblID.setBounds(new Rectangle(38, 32, 42, 15));
        btnCancel.addActionListener(new AddTeacherFrame_btnCancel_actionAdapter(this));
        btnOk.addActionListener(new AddTeacherFrame_btnOk_actionAdapter(this));
        lblName.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblPhone.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblMemo.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnOk.setBackground(Color.white);
        btnOk.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnCancel.setBackground(Color.white);
        btnCancel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        txtID.addActionListener(new AddTeacherFrame_txtID_actionAdapter(this));
        this.setTitle("添加教师信息");
        jScrollPane1.setBounds(new Rectangle(133, 209, 186, 84));
        this.getContentPane().add(lblID);
        btnCancel.setBounds(new Rectangle(223, 322, 83, 25));
        btnCancel.setText("取消");
        btnOk.setBounds(new Rectangle(88, 322, 83, 25));
        btnOk.setText("确定");
        txtPhone.setBounds(new Rectangle(133, 144, 175, 26));
        txtName.setBounds(new Rectangle(133, 86, 175, 29));
        txtID.setBounds(new Rectangle(133, 32, 176, 27));
        lblMemo.setText("备注");
        lblMemo.setBounds(new Rectangle(38, 197, 42, 15));
        lblPhone.setText("电话");
        lblPhone.setBounds(new Rectangle(38, 144, 42, 15));
        this.getContentPane().add(lblName);
        this.getContentPane().add(lblPhone);
        this.getContentPane().add(lblMemo);
        this.getContentPane().add(txtID);
        this.getContentPane().add(txtName);
        this.getContentPane().add(txtPhone);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btnCancel);
        this.getContentPane().add(btnOk);
        jScrollPane1.getViewport().add(txtMemo);
        lblName.setText("姓名");
        lblName.setBounds(new Rectangle(38, 86, 42, 15));
    }

//    public static void main(String[] args) {
//        AddTeacherFrame addteacherframe = new AddTeacherFrame();
//        addteacherframe.setSize(500, 600);
//        addteacherframe.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
//        addteacherframe.setVisible(true);
//    }

    JLabel lblID = new JLabel();
    JLabel lblName = new JLabel();
    JLabel lblPhone = new JLabel();
    JLabel lblMemo = new JLabel();
    JTextField txtID = new JTextField();
    JTextField txtName = new JTextField();
    JTextField txtPhone = new JTextField();
    JTextArea txtMemo = new JTextArea();
    JButton btnOk = new JButton();
    JButton btnCancel = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();


    public void btnCancel_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void btnOk_actionPerformed(ActionEvent e) {
        String ID = this.txtID.getText();
        String Name = this.txtName.getText();
        String Phone = this.txtPhone.getText();
        String memo = this.txtMemo.getText();

        DBManager db = new DBManager();
        String sql;
        if (ID.equals("")) {
            JOptionPane.showMessageDialog(this, "编号不能为空。");
            return;
        }

        if (ID.substring(0, 1).equals("T") == false) {
            JOptionPane.showMessageDialog(this, "编号的格式应该为：T001");
            return;
        }
        if (ID.length() > 4 || ID.length() < 4) {
            JOptionPane.showMessageDialog(this, "教师编号应该为4位");
            return;
        }

        //没有判断2，3，4位是否是数字？
        if (this.tea == null) {
            String Querysql = "select * from T_TEACHER where  teacherId='" + ID +
                              "'";
            ResultSet rs = db.ExecuteQuery(Querysql);
            try {
                while (rs.next()) {
                    JOptionPane.showMessageDialog(this, "编号不可用");
                    return;
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }

            sql =
                    "insert T_TEACHER( teacherId, teacherName, teacherTel, Memo )values ('" +
                    ID + "','" + Name + "','" + Phone + "','" + memo + "')";
        } else {
            sql = "update T_TEACHER set teacherId='" + ID +
                  "',teacherName='" + Name + "',teacherTel='" + Phone +
                  "',Memo='" + memo + "' where teacherId='" + ID + "'";
        }
        if (Name.equals("")) {
            JOptionPane.showMessageDialog(this, "教师姓名不能为空。");
            return;
        }
        //！！！！！！！！！！！这里的5指的是5个汉字！！！！！！！！！！！
        if (Name.length() > 5) {
            JOptionPane.showMessageDialog(this, "教师姓名过长");
            return;
        }

        db.ExecuteUpdate(sql);
        this.dispose();
    }

    public void txtID_actionPerformed(ActionEvent e) {

    }
}


class AddTeacherFrame_txtID_actionAdapter implements ActionListener {
    private AddTeacherFrame adaptee;
    AddTeacherFrame_txtID_actionAdapter(AddTeacherFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class AddTeacherFrame_btnOk_actionAdapter implements ActionListener {
    private AddTeacherFrame adaptee;
    AddTeacherFrame_btnOk_actionAdapter(AddTeacherFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class AddTeacherFrame_btnCancel_actionAdapter implements ActionListener {
    private AddTeacherFrame adaptee;
    AddTeacherFrame_btnCancel_actionAdapter(AddTeacherFrame adaptee) {
        this.adaptee = adaptee;
    }

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