paneladdclasses.java

学员信息管理系统

                    labelD.setText("日");
                    labelD.setBounds(588, 63, 14, 21);
                    labelD.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    scrollPaneDescribe = new JScrollPane();
                    panelCenter.add(scrollPaneDescribe);
                    scrollPaneDescribe.setBounds(98, 231, 196, 154);
                    {
                        textAreaDescribe = new JTextArea();
                        textAreaDescribe.setLineWrap(true);
                        scrollPaneDescribe.setViewportView(textAreaDescribe);
                        textAreaDescribe.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                }
                {
                    scrollPaneRemarks = new JScrollPane();
                    panelCenter.add(scrollPaneRemarks);
                    scrollPaneRemarks.setBounds(427, 231, 196, 154);
                    {
                        textAreaRemarks = new JTextArea();
                        textAreaRemarks.setLineWrap(true);
                        scrollPaneRemarks.setViewportView(textAreaRemarks);
                        textAreaRemarks.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                }
                {
                    jLabel1 = new JLabel();
                    panelCenter.add(jLabel1);
                    jLabel1.setBounds(203, 63, 126, 21);
                    jLabel1.setText(" * 格式：10001");
                    jLabel1.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel1.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel2 = new JLabel();
                    panelCenter.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();
                    panelCenter.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();
                    panelCenter.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();
                    panelCenter.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();
                    panelCenter.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));
                }
            }
            {
                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();
    }

    /**
     * 《负责教师》选项 事件处理方法
     * 
     * @param evt
     */
    private void comboBoxTeacherItemStateChanged(ItemEvent evt) {
        if (this.comboBoxTeacher.getItemCount() != 0) {
            if (this.comboBoxTeacher.getSelectedItem().toString().equals("<添加新教师>")) {
                if (!ObjectClasses.checkBoxMenuItemAddTeachers.isSelected()) {
                    ObjectClasses.checkBoxMenuItemAddTeachers.setSelected(true);
                }
                LogChecked.tabbedSelected();
                tabbedPane.setSelectedComponent(ObjectClasses.panelAddTeachers);
                comboBoxTeacher.setSelectedIndex(0);
            }
        }
    }

    /**
     * 页面初始化方法
     */
    private void initial() {
        this.textFieldID.setText("");
        this.textFieldName.setText("");
        this.comboBoxFamily.setSelectedIndex(0);
        this.comboBoxY.setSelectedItem(date[0]);
        this.comboBoxM.setSelectedItem(date[1]);
        this.comboBoxD.setSelectedItem(date[2]);
        this.comboBoxTime.setSelectedIndex(0);
        this.comboBoxTeacher.setSelectedIndex(0);
        this.textAreaDescribe.setText("");
        this.textAreaRemarks.setText("");
    }

    /**
     * 获取表单并进行验证，向数据库插入数据的方法
     */
    private void insert() {
        /*
         * 《班级编号》
         */
        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 (!FormChecked.mustNotRepeat("班级编号", class_ID, "Classes", "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();
        if (!FormChecked.mustSelect("所属类别", class_Family)) {
            this.comboBoxFamily.requestFocus();
            return;
        }
        /*
         * 《开设时间》
         */
        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();
        if (!FormChecked.mustSelect("上课时间", class_Time)) {
            this.comboBoxTime.requestFocus();
            return;
        }
        /*
         * 《负责教师》
         */
        String class_Teacher = this.comboBoxTeacher.getSelectedItem().toString();
        if (!FormChecked.mustSelect("负责教师", class_Teacher)) {
            this.comboBoxTeacher.requestFocus();
            return;
        }
        /*
         * 《班级描述》
         */
        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_InsertTime = SQLOperate.getPreciseDate();
        String class_UpdateTime = SQLOperate.getPreciseDate();
        String class_UpdateName = "边疆";

        /**
         * 生成 SQL 语句
         */
        sqlStr = "Insert into Classes" + "(" + "Class_ID," + "Class_Name," + "Class_Family," + "Class_StartTime," + "Class_Time," + "Class_Teacher," + "Class_Describe," + "Class_Remarks," + "Class_InsertTime," + "Class_UpdateTime," + "Class_UpdateName" + ")" + "values" + "(" + "'" + class_ID + "'," + "'" + class_Name + "'," + "'" + class_Family + "'," + "'" + class_StartTime + "'," + "'" + class_Time + "'," + "'" + class_Teacher + "'," + "'" + class_Describe + "'," + "'" + class_Remarks + "'," + "'" + class_InsertTime + "'," + "'" + class_UpdateTime + "'," + "'" + class_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("Classes", tableClasses);
        SQLOperate.addItem(comboBoxClass, "Class_Name", "Classes", "", "");
        ObjectClasses.tableClassesRowCountFile = ObjectClasses.tableClassesRowFile.setTableRowFile(ObjectClasses.tableClassesRowCount);
        initial();
    }

}