dialogupdatecourses.java

学员信息管理系统

                        jLabel4.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        scrollPaneDescribe = new JScrollPane();
                        panelNorth.add(scrollPaneDescribe);
                        scrollPaneDescribe.setBounds(98, 175, 196, 154);
                        {
                            textAreaDescribe = new JTextArea();
                            scrollPaneDescribe.setViewportView(textAreaDescribe);
                            textAreaDescribe.setLineWrap(true);
                            textAreaDescribe.setFont(new java.awt.Font("宋体", 0, 12));
                        }
                    }
                    {
                        scrollPaneAim = new JScrollPane();
                        panelNorth.add(scrollPaneAim);
                        scrollPaneAim.setBounds(427, 175, 196, 154);
                        {
                            textAreaAim = new JTextArea();
                            scrollPaneAim.setViewportView(textAreaAim);
                            textAreaAim.setLineWrap(true);
                            textAreaAim.setFont(new java.awt.Font("宋体", 0, 12));
                        }
                    }
                }
                {
                    panelDown = new JPanel();
                    panelCenter.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);
                            }
                        });
                    }
                    {
                        buttonExit = new JButton();
                        panelDown.add(buttonExit);
                        buttonExit.setText("取消修改信息");
                        buttonExit.setFont(new java.awt.Font("宋体", 0, 12));
                        buttonExit.addActionListener(new ActionListener() {
                            public void actionPerformed(ActionEvent evt) {
                                buttonExitActionPerformed(evt);
                            }
                        });
                    }
                }
            }
            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 Courses where ID = " + id;
        rs = SQLOperate.getResultSet(sqlStr);
        try {
            if (rs.next()) {
                this.textFieldID.setText(rs.getString("Courses_ID"));
                this.coursesID = rs.getString("Courses_ID");
                this.textFieldName.setText(rs.getString("Courses_Name"));
                this.comboBoxFamily.setSelectedItem(rs.getString("Courses_Family"));
                this.comboBoxTerm.setSelectedItem(rs.getString("Courses_Term"));
                this.textAreaDescribe.setText(rs.getString("Courses_Describe"));
                this.textAreaAim.setText(rs.getString("Courses_Aim"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    /**
     * 获取表单并进行验证，更新数据库
     */
    private void update() {
        /*
         * 《课程编号》
         */
        String courses_ID = this.textFieldID.getText().trim();
        if (!FormChecked.mustNotNull("课程编号", courses_ID)) {
            this.textFieldID.requestFocus();
            return;
        }
        if (!FormChecked.mustNumber("课程编号", courses_ID)) {
            this.textFieldID.requestFocus();
            return;
        }
        if (!FormChecked.charEqualNumber("课程编号", courses_ID, 5)) {
            this.textFieldID.requestFocus();
            return;
        }
        if (!courses_ID.equals(coursesID))
            if (!FormChecked.mustNotRepeat("课程编号", courses_ID, "Courses", "Courses_ID")) {
                this.textFieldID.requestFocus();
                return;
            }
        if (!FormChecked.charCheck("课程编号", courses_ID)) {
            this.textFieldID.requestFocus();
            return;
        }
        /*
         * 《课程名称》
         */
        String courses_Name = this.textFieldName.getText().trim();
        if (!FormChecked.mustNotNull("课程名称", courses_Name)) {
            this.textFieldName.requestFocus();
            return;
        }
        if (!FormChecked.charCheck("课程名称", courses_Name)) {
            this.textFieldName.requestFocus();
            return;
        }
        /*
         * 《所属类别》
         */
        String courses_Family = this.comboBoxFamily.getSelectedItem().toString();
        /*
         * 《所属学期》
         */
        String courses_Term = this.comboBoxTerm.getSelectedItem().toString();
        /*
         * 《课程描述》
         */
        String courses_Describe = this.textAreaDescribe.getText();
        if (!FormChecked.charCheck("课程描述", courses_Describe)) {
            this.textAreaDescribe.requestFocus();
            return;
        }
        /*
         * 《课程目标》
         */
        String courses_Aim = this.textAreaAim.getText();
        if (!FormChecked.charCheck("课程目标", courses_Aim)) {
            this.textAreaAim.requestFocus();
            return;
        }
        /*
         * 自动向数据库插入，插入时间、更新时间、更新人
         */
        // String courses_InsertTime = SQLOperate.getPreciseDate();
        String courses_UpdateTime = SQLOperate.getPreciseDate();
        String courses_UpdateName = "边疆";

        /**
         * 生成 SQL 语句
         */
        sqlStr = "Update Courses set " + "Courses_ID = " + courses_ID + " , " + "Courses_Name = '" + courses_Name + "' , " + "Courses_Family = '" + courses_Family + "' , " + "Courses_Term = '" + courses_Term + "' , " + "Courses_Describe = '" + courses_Describe + "' , " + "Courses_Aim = '" + courses_Aim + "' , " + "Courses_UpdateTime = '" + courses_UpdateTime + "' , " + "Courses_UpdateName = '" + courses_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();
    }
}