dialogupdateclasses.java

学员信息管理系统

                        panelNorth.add(comboBoxM);
                        comboBoxM.setModel(comboBoxMModel);
                        comboBoxM.setBounds(490, 63, 42, 21);
                        comboBoxM.setFont(new java.awt.Font("宋体", 0, 12));
                        for (int i = 1; i < 13; i++) {
                            this.comboBoxM.addItem("" + i);
                        }
                    }
                    {
                        labelM = new JLabel();
                        panelNorth.add(labelM);
                        labelM.setText("月");
                        labelM.setBounds(532, 63, 14, 21);
                        labelM.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        ComboBoxModel comboBoxDModel = new DefaultComboBoxModel();
                        comboBoxD = new JComboBox();
                        panelNorth.add(comboBoxD);
                        comboBoxD.setModel(comboBoxDModel);
                        comboBoxD.setBounds(546, 63, 42, 21);
                        comboBoxD.setFont(new java.awt.Font("宋体", 0, 12));
                        for (int i = 1; i < 32; i++) {
                            this.comboBoxD.addItem("" + i);
                        }
                    }
                    {
                        labelD = new JLabel();
                        panelNorth.add(labelD);
                        labelD.setText("日");
                        labelD.setBounds(588, 63, 14, 21);
                        labelD.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        jLabel1 = new JLabel();
                        panelNorth.add(jLabel1);
                        jLabel1.setText(" * 格式：10001");
                        jLabel1.setForeground(new java.awt.Color(255, 0, 0));
                        jLabel1.setBounds(203, 63, 126, 21);
                        jLabel1.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        jLabel2 = new JLabel();
                        panelNorth.add(jLabel2);
                        jLabel2.setText(" * 格式：H1T107010601");
                        jLabel2.setForeground(new java.awt.Color(255, 0, 0));
                        jLabel2.setBounds(203, 119, 126, 21);
                        jLabel2.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        jLabel3 = new JLabel();
                        panelNorth.add(jLabel3);
                        jLabel3.setText(" * ");
                        jLabel3.setForeground(new java.awt.Color(255, 0, 0));
                        jLabel3.setBounds(203, 175, 126, 21);
                        jLabel3.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        jLabel4 = new JLabel();
                        panelNorth.add(jLabel4);
                        jLabel4.setText(" * ");
                        jLabel4.setForeground(new java.awt.Color(255, 0, 0));
                        jLabel4.setBounds(602, 63, 21, 21);
                        jLabel4.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        jLabel5 = new JLabel();
                        panelNorth.add(jLabel5);
                        jLabel5.setText(" * ");
                        jLabel5.setForeground(new java.awt.Color(255, 0, 0));
                        jLabel5.setBounds(532, 119, 126, 21);
                        jLabel5.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        jLabel6 = new JLabel();
                        panelNorth.add(jLabel6);
                        jLabel6.setText(" * ");
                        jLabel6.setForeground(new java.awt.Color(255, 0, 0));
                        jLabel6.setBounds(532, 175, 126, 21);
                        jLabel6.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        scrollPaneDescribe = new JScrollPane();
                        panelNorth.add(scrollPaneDescribe);
                        scrollPaneDescribe.setBounds(98, 231, 196, 154);
                        {
                            textAreaDescribe = new JTextArea();
                            scrollPaneDescribe.setViewportView(textAreaDescribe);
                            textAreaDescribe.setLineWrap(true);
                            textAreaDescribe.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 Classes where ID = " + id;
        rs = SQLOperate.getResultSet(sqlStr);
        try {
            if (rs.next()) {
                this.textFieldID.setText(rs.getString("Class_ID"));
                this.classID = rs.getString("Class_ID");
                this.textFieldName.setText(rs.getString("Class_Name"));
                this.comboBoxFamily.setSelectedItem(rs.getString("Class_Family"));
                this.date = rs.getString("Class_StartTime");
                this.comboBoxY.setSelectedItem(date.split("-")[0]);
                this.comboBoxM.setSelectedItem(date.split("-")[1]);
                this.comboBoxD.setSelectedItem(date.split("-")[2]);
                this.comboBoxTime.setSelectedItem(rs.getString("Class_Time"));
                this.comboBoxTeacher.setSelectedItem("Class_Teacher");
                this.textAreaDescribe.setText(rs.getString("Class_Describe"));
                this.textAreaRemarks.setText(rs.getString("Class_Remarks"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    /**
     * 获取表单并进行验证，更新数据库
     */
    private void update() {
        /*
         * 《班级编号》
         */
        String class_ID = this.textFieldID.getText().trim();
        if (!FormChecked.mustNotNull("班级编号", class_ID)) {
            this.textFieldID.requestFocus();
            return;
        }
        if (!FormChecked.mustNumber("班级编号", class_ID)) {
            this.textFieldID.requestFocus();
            return;
        }
        if (!FormChecked.charEqualNumber("班级编号", class_ID, 5)) {
            this.textFieldID.requestFocus();
            return;
        }
        if (!class_ID.equals(classID))
            if (!FormChecked.mustNotRepeat("班级编号", class_ID, "Classes", "class_ID")) {
                this.textFieldID.requestFocus();
                return;
            }
        if (!FormChecked.charCheck("班级编号", class_ID)) {
            this.textFieldID.requestFocus();
            return;
        }
        /*
         * 《班级名称》
         */
        String class_Name = this.textFieldName.getText().trim();
        if (!FormChecked.mustNotNull("班级名称", class_Name)) {
            this.textFieldName.requestFocus();
            return;
        }
        if (!FormChecked.charEqualNumber("班级名称", class_Name, 12)) {
            this.textFieldName.requestFocus();
            return;
        }
        for (int i = 0; i < class_Name.length(); i++) {
            if (i == 0) {
                if (class_Name.charAt(0) != 'H') {
                    JOptionPane.showMessageDialog(null, "错误信息：[班级名称]\n错误提示：第1个字符必需为H！\n参照示例：H1T107010601");
                    this.textFieldName.requestFocus();
                    return;
                }
            } else if (i == 2) {
                if (class_Name.charAt(2) != 'T') {
                    JOptionPane.showMessageDialog(null, "错误信息：[班级名称]\n错误提示：第3个字符必需为T！\n参照示例：H1T107010601");
                    this.textFieldName.requestFocus();
                    return;
                }
            } else {
                if (class_Name.charAt(i) < '0' || class_Name.charAt(i) > '9') {
                    JOptionPane.showMessageDialog(null, "错误信息：[班级名称]\n错误提示：第" + (i + 1) + "个字符必需为数字！\n参照示例：H1T107010601");
                    this.textFieldName.requestFocus();
                    return;
                }
            }
        }
        if (!FormChecked.charCheck("班级名称", class_Name)) {
            this.textFieldName.requestFocus();
            return;
        }

        /*
         * 《所属类别》
         */
        String class_Family = this.comboBoxFamily.getSelectedItem().toString();
        /*
         * 《开设时间》
         */
        String date_Y = this.comboBoxY.getSelectedItem().toString();
        String date_M = this.comboBoxM.getSelectedItem().toString();
        String date_D = this.comboBoxD.getSelectedItem().toString();
        String class_StartTime = date_Y + "-" + date_M + "-" + date_D;
        /*
         * 《上课时间》
         */
        String class_Time = this.comboBoxTime.getSelectedItem().toString();
        /*
         * 《负责教师》
         */
        String class_Teacher = this.comboBoxTeacher.getSelectedItem().toString();
        /*
         * 《班级描述》
         */
        String class_Describe = this.textAreaDescribe.getText();
        if (!FormChecked.charCheck("班级描述", class_Describe)) {
            this.textAreaDescribe.requestFocus();
            return;
        }
        /*
         * 《班级点评》
         */
        String class_Remarks = this.textAreaRemarks.getText();
        if (!FormChecked.charCheck("班级点评", class_Remarks)) {
            this.textAreaRemarks.requestFocus();
            return;
        }
        String class_UpdateTime = SQLOperate.getPreciseDate();
        String class_UpdateName = "边疆";
        /**
         * 生成 SQL 语句
         */
        sqlStr = "Update Classes set " + "Class_ID = " + class_ID + " , " + "Class_Name = '" + class_Name + "' , " + "Class_Family = '" + class_Family + "' , " + "Class_StartTime = '" + class_StartTime + "' , " + "Class_Time = '" + class_Time + "' , " + "Class_Teacher = '" + class_Teacher + "' , " + "Class_Describe = '" + class_Describe + "' , " + "Class_Remarks = '" + class_Remarks + "' , " + "Class_UpdateTime = '" + class_UpdateTime + "' , " + "Class_UpdateName = '" + class_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();
    }
}