dialogupdateteachers.java

学员信息管理系统

                        jLabel10.setForeground(new java.awt.Color(255, 0, 0));
                        jLabel10.setBounds(532, 91, 140, 21);
                        jLabel10.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        jLabel9 = new JLabel();
                        panelNorth.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();
                        panelNorth.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));
                    }
                    {
                        scrollPaneLike = new JScrollPane();
                        panelNorth.add(scrollPaneLike);
                        scrollPaneLike.setBounds(98, 231, 196, 154);
                        {
                            textAreaLike = new JTextArea();
                            scrollPaneLike.setViewportView(textAreaLike);
                            textAreaLike.setLineWrap(true);
                            textAreaLike.setFont(new java.awt.Font("宋体", 0, 12));
                        }
                    }
                    {
                        scrollPaneRemarks = new JScrollPane();
                        panelNorth.add(scrollPaneRemarks);
                        scrollPaneRemarks.setBounds(427, 231, 196, 154);
                        {
                            textAreaRemarks = new JTextArea();
                            scrollPaneRemarks.setViewportView(textAreaRemarks);
                            textAreaRemarks.setLineWrap(true);
                            textAreaRemarks.setFont(new java.awt.Font("宋体", 0, 12));
                        }
                    }
                }
            }
            this.setSize(677, 524);
            this.setTitle("修改教师信息");
            /*
             * 设置窗口显示居中
             */
            int windowsWidth = Toolkit.getDefaultToolkit().getScreenSize().width;// 获取桌面宽度
            int windowsHeight = Toolkit.getDefaultToolkit().getScreenSize().height;// 获取桌面高度

            int frameWidth = getSize().width;// 获取窗体宽度
            int frameHeight = getSize().height;// 获取窗体高度

            int startX = (windowsWidth - frameWidth) / 2;// 计算窗体显示的初始横坐标
            int startY = (windowsHeight - frameHeight) / 2;// 计算窗体显示的初始纵坐标
            this.setLocation(startX, startY);// 设置窗体显示位置
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

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

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

    /**
     * 《取消修改信息》按钮事件处理方法
     * 
     * @param evt
     */
    private void buttonExitActionPerformed(ActionEvent evt) {
        this.dispose();
    }

    /**
     * 界面初始化方法
     */
    private void initial() {
        sqlStr = "Select * from Teachers where ID = " + id;
        rs = SQLOperate.getResultSet(sqlStr);
        try {
            if (rs.next()) {
                this.textFieldID.setText(rs.getString("Teacher_ID"));
                this.teacherID = rs.getString("Teacher_ID");
                this.textFieldName.setText(rs.getString("Teacher_Name"));
                this.comboBoxSex.setSelectedItem(rs.getString("Teacher_Sex"));
                this.comboBoxAge.setSelectedItem(rs.getString("Teacher_Age"));
                this.textFieldPhone.setText(rs.getString("Teacher_Phone"));
                this.textFieldHandset.setText(rs.getString("Teacher_Handset"));
                this.textFieldAddress.setText(rs.getString("Teacher_Address"));
                this.comboBoxNative.setSelectedItem(rs.getString("Teacher_Native"));
                this.comboBoxEdu.setSelectedItem(rs.getString("Teacher_Edu"));
                this.comboBoxMarry.setSelectedItem(rs.getString("Teacher_Marry"));
                this.comboBoxWork.setSelectedItem(rs.getString("Teacher_Work"));
                this.textFieldLanguage.setText(rs.getString("Teacher_Language"));
                this.comboBoxPost.setSelectedItem(rs.getString("Teacher_Post"));
                this.date = rs.getString("Teacher_StartTeachTime");
                this.comboBoxY.setSelectedItem(date.split("-")[0]);
                this.comboBoxM.setSelectedItem(date.split("-")[1]);
                this.comboBoxD.setSelectedItem(date.split("-")[2]);
                this.textAreaLike.setText(rs.getString("Teacher_Like"));
                this.textAreaRemarks.setText(rs.getString("Teacher_Remarks"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    /**
     * 获取表单并进行验证，更新数据库
     */
    private void update() {
        /*
         * 《教师编号》
         */
        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 (!teacher_ID.equals(teacherID))
            if (!FormChecked.mustNotRepeat("教师编号", teacher_ID, "Teachers", "Teacher_ID")) {
                this.textFieldID.requestFocus();
                return;
            }
        if (!FormChecked.charCheck("教师编号", 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();
        /*
         * 《教师年龄》
         */
        String teacher_Age = this.comboBoxAge.getSelectedItem().toString();
        /*
         * 《电话号码》
         */
        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();
        /*
         * 《教师学历》
         */
        String teacher_Edu = this.comboBoxEdu.getSelectedItem().toString();
        /*
         * 《婚姻状况》
         */
        String teacher_Marry = this.comboBoxMarry.getSelectedItem().toString();
        /*
         * 《工作经验》
         */
        String teacher_Work = this.comboBoxWork.getSelectedItem().toString();
        /*
         * 《教授语言》
         */
        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();
        /*
         * 《入教时间》
         */
        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 = "Update Teachers set " + "Teacher_ID = " + teacher_ID + " , " + "Teacher_Name = '" + teacher_Name + "' , " + "Teacher_Sex = '" + teacher_Sex + "' , " + "Teacher_Age = '" + teacher_Age + "' , " + "Teacher_Phone = '" + teacher_Phone + "' , " + "Teacher_Handset = '" + teacher_Handset + "' , " + "Teacher_Address = '" + teacher_Address + "' , " + "Teacher_Native = '" + teacher_Native + "' , " + "Teacher_Edu = '" + teacher_Edu + "' , " + "Teacher_Marry = '" + teacher_Marry + "' , " + "Teacher_Work = '" + teacher_Work + "' , " + "Teacher_Language = '" + teacher_Language + "' , " + "Teacher_Post = '" + teacher_Post + "' , " + "Teacher_StartTeachTime = '" + teacher_StartTeachTime + "' , " + "Teacher_Like = '" + teacher_Like + "' , " + "Teacher_Remarks = '" + teacher_Remarks + "' , " + "Teacher_UpdateTime = '" + teacher_UpdateTime + "' , " + "Teacher_UpdateName = '" + teacher_UpdateName + "' " + "where ID = " + id;
        System.out.println(sqlStr);
        st = SQLOperate.getStatement();
        try {
            st.executeUpdate(sqlStr);
        } catch (SQLException e) {
            // e.printStackTrace();
            SQLOperate.closeST();
            FormChecked.lose("修改教师", "修改失败！数据库访问错误！");
            return;
        }
        FormChecked.success("修改教师", "成功修改教师信息！");
        this.dispose();
    }
}