paneladdteachers.java

学员信息管理系统

                {
                    jLabel9 = new JLabel();
                    panelCenter.add(jLabel9);
                    jLabel9.setText(" * ");
                    jLabel9.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel9.setBounds(532, 63, 140, 21);
                    jLabel9.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel8 = new JLabel();
                    panelCenter.add(jLabel8);
                    jLabel8.setText(" * ");
                    jLabel8.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel8.setBounds(532, 35, 140, 21);
                    jLabel8.setFont(new java.awt.Font("宋体", 0, 12));
                }
            }
            {
                panelDown = new JPanel();
                this.add(panelDown, BorderLayout.SOUTH);
                panelDown.setBackground(new java.awt.Color(236, 233, 216));
                {
                    buttonSubmit = new JButton();
                    panelDown.add(buttonSubmit);
                    buttonSubmit.setText("确认添加信息");
                    buttonSubmit.setFont(new java.awt.Font("宋体", 0, 12));
                    buttonSubmit.addActionListener(new ActionListener() {
                        public void actionPerformed(ActionEvent evt) {
                            buttonSubmitActionPerformed(evt);
                        }
                    });
                }
                {
                    buttonReset = new JButton();
                    panelDown.add(buttonReset);
                    buttonReset.setText("重新填写信息");
                    buttonReset.setFont(new java.awt.Font("宋体", 0, 12));
                    buttonReset.addActionListener(new ActionListener() {
                        public void actionPerformed(ActionEvent evt) {
                            buttonResetActionPerformed(evt);
                        }
                    });
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 《确认添加信息》按钮事件处理方法
     * 
     * @param evt
     */
    private void buttonSubmitActionPerformed(ActionEvent evt) {
        insert();
    }

    /**
     * 《重新填写信息》按钮事件处理方法
     * 
     * @param evt
     */
    private void buttonResetActionPerformed(ActionEvent evt) {
        initial();
    }

    /**
     * 页面初始化方法
     */
    private void initial() {
        this.textFieldID.setText("");
        this.textFieldName.setText("");
        this.comboBoxSex.setSelectedIndex(0);
        this.comboBoxAge.setSelectedIndex(0);
        this.textFieldPhone.setText("");
        this.textFieldHandset.setText("");
        this.textFieldAddress.setText("");
        this.comboBoxNative.setSelectedIndex(0);
        this.comboBoxEdu.setSelectedIndex(0);
        this.comboBoxMarry.setSelectedIndex(0);
        this.comboBoxWork.setSelectedIndex(0);
        this.textFieldLanguage.setText("");
        this.comboBoxPost.setSelectedIndex(0);
        this.comboBoxY.setSelectedItem(date[0]);
        this.comboBoxM.setSelectedItem(date[1]);
        this.comboBoxD.setSelectedItem(date[2]);
        this.textAreaLike.setText("");
        this.textAreaRemarks.setText("");
    }

    /**
     * 获取表单，并验证，向数据库插入数据
     */
    private void insert() {
        /*
         * 《教师编号》
         */
        String teacher_ID = this.textFieldID.getText().trim();
        if (!FormChecked.mustNotNull("教师编号", teacher_ID)) {
            this.textFieldID.requestFocus();
            return;
        }
        if (!FormChecked.mustNumber("教师编号", teacher_ID)) {
            this.textFieldID.requestFocus();
            return;
        }
        if (!FormChecked.charEqualNumber("教师编号", teacher_ID, 5)) {
            this.textFieldID.requestFocus();
            return;
        }
        if (!FormChecked.mustNotRepeat("教师编号", teacher_ID, "Teachers", "Teacher_ID")) {
            this.textFieldID.requestFocus();
            return;
        }
        /*
         * 《教师姓名》
         */
        String teacher_Name = this.textFieldName.getText().trim();
        if (!FormChecked.mustNotNull("教师姓名", teacher_Name)) {
            this.textFieldName.requestFocus();
            return;
        }
        if (!FormChecked.charBigNumber("教师姓名", teacher_Name, 2)) {
            this.textFieldName.requestFocus();
            return;
        }
        if (!FormChecked.charCheck("教师姓名", teacher_Name)) {
            this.textFieldName.requestFocus();
            return;
        }
        /*
         * 《教师性别》
         */
        String teacher_Sex = this.comboBoxSex.getSelectedItem().toString();
        if (!FormChecked.mustSelect("教师性别", teacher_Sex)) {
            this.comboBoxSex.requestFocus();
            return;
        }
        /*
         * 《教师年龄》
         */
        String teacher_Age = this.comboBoxAge.getSelectedItem().toString();
        if (!FormChecked.mustSelect("教师年龄", teacher_Age)) {
            this.comboBoxAge.requestFocus();
            return;
        }
        /*
         * 《电话号码》
         */
        String teacher_Phone = this.textFieldPhone.getText().trim();
        if (!FormChecked.mustNumber("电话号码", teacher_Phone)) {
            this.textFieldPhone.requestFocus();
            return;
        }
        /*
         * 《手机号码》
         */
        String teacher_Handset = this.textFieldHandset.getText().trim();
        if (!FormChecked.mustNumber("手机号码", teacher_Handset)) {
            this.textFieldHandset.requestFocus();
            return;
        }
        /*
         * 《家庭住址》
         */
        String teacher_Address = this.textFieldAddress.getText().trim();
        if (!FormChecked.mustNotNull("家庭住址", teacher_Address)) {
            this.textFieldAddress.requestFocus();
            return;
        }
        if (!FormChecked.charCheck("家庭住址", teacher_Address)) {
            this.textFieldAddress.requestFocus();
            return;
        }
        /*
         * 《教师籍贯》
         */
        String teacher_Native = this.comboBoxNative.getSelectedItem().toString();
        if (!FormChecked.mustSelect("教师籍贯", teacher_Native)) {
            this.comboBoxNative.requestFocus();
            return;
        }
        /*
         * 《教师学历》
         */
        String teacher_Edu = this.comboBoxEdu.getSelectedItem().toString();
        if (!FormChecked.mustSelect("教师学历", teacher_Edu)) {
            this.comboBoxEdu.requestFocus();
            return;
        }
        /*
         * 《婚姻状况》
         */
        String teacher_Marry = this.comboBoxMarry.getSelectedItem().toString();
        if (!FormChecked.mustSelect("婚姻状况", teacher_Marry)) {
            this.comboBoxMarry.requestFocus();
            return;
        }
        /*
         * 《工作经验》
         */
        String teacher_Work = this.comboBoxWork.getSelectedItem().toString();
        if (!FormChecked.mustSelect("工作经验", teacher_Work)) {
            this.comboBoxWork.requestFocus();
            return;
        }
        /*
         * 《教授语言》
         */
        String teacher_Language = this.textFieldLanguage.getText().trim();
        if (!FormChecked.mustNotNull("教授语言", teacher_Language)) {
            this.textFieldLanguage.requestFocus();
            return;
        }
        if (!FormChecked.charCheck("教授语言", teacher_Language)) {
            this.textFieldLanguage.requestFocus();
            return;
        }
        /*
         * 《教师职务》
         */
        String teacher_Post = this.comboBoxPost.getSelectedItem().toString();
        if (!FormChecked.mustSelect("教师职务", teacher_Post)) {
            this.comboBoxPost.requestFocus();
            return;
        }
        /*
         * 《入教时间》
         */
        String date_Y = this.comboBoxY.getSelectedItem().toString();
        String date_M = this.comboBoxM.getSelectedItem().toString();
        String date_D = this.comboBoxD.getSelectedItem().toString();
        String teacher_StartTeachTime = date_Y + "-" + date_M + "-" + date_D;
        /*
         * 《兴趣爱好》
         */
        String teacher_Like = this.textAreaLike.getText();
        if (!FormChecked.charCheck("兴趣爱好", teacher_Like)) {
            this.textAreaLike.requestFocus();
            return;
        }
        /*
         * 《教师点评》
         */
        String teacher_Remarks = this.textAreaRemarks.getText();
        if (!FormChecked.charCheck("教师点评", teacher_Remarks)) {
            this.textAreaRemarks.requestFocus();
            return;
        }
        /*
         * 系统自动添加的插入时间、更新时间、更新人
         */
        String teacher_InsertTime = SQLOperate.getPreciseDate();
        String teacher_UpdateTime = SQLOperate.getPreciseDate();
        String teacher_UpdateName = "边疆";

        /**
         * 生成 SQL 语句
         */
        sqlStr = "Insert into Teachers" + "(" + "Teacher_ID," + "Teacher_Name," + "Teacher_Sex," + "Teacher_Age," + "Teacher_Phone," + "Teacher_Handset," + "Teacher_Address," + "Teacher_Native," + "Teacher_Edu," + "Teacher_Marry," + "Teacher_Work," + "Teacher_Language," + "Teacher_Post," + "Teacher_StartTeachTime," + "Teacher_Like," + "Teacher_Remarks," + "Teacher_InsertTime," + "Teacher_UpdateTime," + "Teacher_UpdateName" + ")" + "values" + "(" + "'" + teacher_ID + "'," + "'" + teacher_Name + "'," + "'" + teacher_Sex + "'," + "'" + teacher_Age + "'," + "'" + teacher_Phone + "'," + "'" + teacher_Handset + "'," + "'" + teacher_Address + "'," + "'" + teacher_Native + "'," + "'" + teacher_Edu + "'," + "'" + teacher_Marry + "'," + "'" + teacher_Work + "'," + "'" + teacher_Language + "'," + "'" + teacher_Post + "'," + "'" + teacher_StartTeachTime + "'," + "'" + teacher_Like + "'," + "'" + teacher_Remarks + "'," + "'" + teacher_InsertTime + "'," + "'" + teacher_UpdateTime + "'," + "'" + teacher_UpdateName + "'" + ")";
        // System.out.println(sqlStr);
        st = SQLOperate.getStatement();
        try {
            st.executeUpdate(sqlStr);
        } catch (SQLException e) {
            // e.printStackTrace();
            SQLOperate.closeST();
            FormChecked.lose("添加教师", "添加失败！数据库访问错误！");
            return;
        }
        FormChecked.success("添加教师", "成功添加教师信息！");
        SQLOperate.selectAllFromData("Teachers", tableTeachers);
        SQLOperate.addItem(comboBoxTeacher, "Teacher_Name", "Teachers", "Teacher_Post", "班主任");
        ObjectClasses.tableTeachersRowCountFile = ObjectClasses.tableTeachersRowFile.setTableRowFile(ObjectClasses.tableTeachersRowCount);
        initial();
    }
}