paneladdcourses.java

学员信息管理系统

package com.javasme.panel;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.BorderFactory;
import javax.swing.ComboBoxModel;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.border.BevelBorder;

import com.javasme.data.SQLOperate;
import com.javasme.longs.LookAndFeel;
import com.javasme.longs.ObjectClasses;
import com.javasme.util.FormChecked;

public class PanelAddCourses extends javax.swing.JPanel {

    /**
     * 
     */
    private static final long serialVersionUID = 1L;

    private JPanel            panelCenter;

    private JComboBox         comboBoxTerm;

    private JLabel            labelAim;

    private JLabel            labelDescribe;

    private JLabel            labelFamily;

    private JLabel            labelTerm;

    private JTextArea         textAreaAim;

    private JScrollPane       scrollPaneAim;

    private JLabel            jLabel4;

    private JLabel            jLabel3;

    private JLabel            jLabel2;

    private JLabel            jLabel1;

    private JTextField        textFieldID;

    private JTextArea         textAreaDescribe;

    private JScrollPane       scrollPaneDescribe;

    private JComboBox         comboBoxFamily;

    private JTextField        textFieldName;

    private JLabel            labelName;

    private JLabel            labelID;

    private JButton           buttonReset;

    private JButton           buttonSubmit;

    private JPanel            panelDown;

    private JTable            tableCourses     = ObjectClasses.tableCourses;

    private String            sqlStr;

    private Statement         st;

    public PanelAddCourses() {
        super();
        initGUI();
        /**
         * 风格设置
         */
        LookAndFeel.UpdateLookAndFeel(this);
    }

    private void initGUI() {
        try {
            setPreferredSize(new Dimension(700, 500));
            BorderLayout thisLayout = new BorderLayout();
            this.setLayout(thisLayout);
            this.setBorder(BorderFactory.createTitledBorder("添加课程"));
            this.setBackground(new java.awt.Color(236, 233, 216));
            {
                panelCenter = new JPanel();
                this.add(panelCenter, BorderLayout.CENTER);
                panelCenter.setBorder(BorderFactory.createEtchedBorder(BevelBorder.LOWERED));
                panelCenter.setLayout(null);
                panelCenter.setBackground(new java.awt.Color(236, 233, 216));
                {
                    labelID = new JLabel();
                    panelCenter.add(labelID);
                    labelID.setText("课程编号：");
                    labelID.setBounds(35, 63, 63, 21);
                    labelID.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    labelName = new JLabel();
                    panelCenter.add(labelName);
                    labelName.setText("课程名称：");
                    labelName.setBounds(35, 119, 63, 21);
                    labelName.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    labelFamily = new JLabel();
                    panelCenter.add(labelFamily);
                    labelFamily.setText("所属类别：");
                    labelFamily.setBounds(364, 63, 63, 21);
                    labelFamily.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    labelTerm = new JLabel();
                    panelCenter.add(labelTerm);
                    labelTerm.setText("所属学期：");
                    labelTerm.setBounds(364, 119, 63, 21);
                    labelTerm.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    labelDescribe = new JLabel();
                    panelCenter.add(labelDescribe);
                    labelDescribe.setText("课程描述：");
                    labelDescribe.setBounds(35, 175, 63, 21);
                    labelDescribe.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    labelAim = new JLabel();
                    panelCenter.add(labelAim);
                    labelAim.setText("课程目标：");
                    labelAim.setBounds(364, 175, 63, 21);
                    labelAim.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    textFieldID = new JTextField();
                    panelCenter.add(textFieldID);
                    textFieldID.setBounds(98, 63, 105, 21);
                    textFieldID.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    textFieldName = new JTextField();
                    panelCenter.add(textFieldName);
                    textFieldName.setBounds(98, 119, 105, 21);
                    textFieldName.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxNativeModel = new DefaultComboBoxModel(new String[] {
                            "请选择...", "软件类", "网络类" });
                    comboBoxFamily = new JComboBox();
                    panelCenter.add(comboBoxFamily);
                    comboBoxFamily.setModel(comboBoxNativeModel);
                    comboBoxFamily.setBounds(427, 63, 105, 21);
                    comboBoxFamily.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxEduModel = new DefaultComboBoxModel(new String[] {
                            "请选择...", "一期(初级)", "二期(中级)", "三期(高级)" });
                    comboBoxTerm = new JComboBox();
                    panelCenter.add(comboBoxTerm);
                    comboBoxTerm.setModel(comboBoxEduModel);
                    comboBoxTerm.setSelectedItem("高中");
                    comboBoxTerm.setBounds(427, 119, 105, 21);
                    comboBoxTerm.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    scrollPaneDescribe = new JScrollPane();
                    panelCenter.add(scrollPaneDescribe);
                    scrollPaneDescribe.setBounds(98, 175, 196, 154);
                    {
                        textAreaDescribe = new JTextArea();
                        textAreaDescribe.setLineWrap(true);
                        scrollPaneDescribe.setViewportView(textAreaDescribe);
                        textAreaDescribe.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                }
                {
                    scrollPaneAim = new JScrollPane();
                    panelCenter.add(scrollPaneAim);
                    scrollPaneAim.setBounds(427, 175, 196, 154);
                    {
                        textAreaAim = new JTextArea();
                        textAreaAim.setLineWrap(true);
                        scrollPaneAim.setViewportView(textAreaAim);
                        textAreaAim.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                }
                {
                    jLabel1 = new JLabel();
                    panelCenter.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();
                    panelCenter.add(jLabel2);
                    jLabel2.setText(" * ");
                    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(532, 63, 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(532, 119, 126, 21);
                    jLabel4.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.comboBoxFamily.setSelectedIndex(0);
        this.comboBoxTerm.setSelectedIndex(0);
        this.textAreaDescribe.setText("");
        this.textAreaAim.setText("");
    }

    private void insert() {
        /*
         * 《课程编号》
         */
        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 (!FormChecked.mustNotRepeat("课程编号", courses_ID, "Courses", "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();
        if (!FormChecked.mustSelect("所属类别", courses_Family)) {
            this.comboBoxFamily.requestFocus();
            return;
        }
        /*
         * 《所属学期》
         */
        String courses_Term = this.comboBoxTerm.getSelectedItem().toString();
        if (!FormChecked.mustSelect("所属学期", courses_Term)) {
            this.comboBoxTerm.requestFocus();
            return;
        }
        /*
         * 《课程描述》
         */
        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 = "Insert into Courses" + "(" + "Courses_ID," + "Courses_Name," + "Courses_Family," + "Courses_Term," + "Courses_Describe," + "Courses_Aim," + "Courses_InsertTime," + "Courses_UpdateTime," + "Courses_UpdateName" + ")" + "values" + "(" + "'" + courses_ID + "'," + "'" + courses_Name + "'," + "'" + courses_Family + "'," + "'" + courses_Term + "'," + "'" + courses_Describe + "'," + "'" + courses_Aim + "'," + "'" + courses_InsertTime + "'," + "'" + courses_UpdateTime + "'," + "'" + courses_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("Courses", tableCourses);
        ObjectClasses.tableCoursesRowCountFile = ObjectClasses.tableCoursesRowFile.setTableRowFile(ObjectClasses.tableCoursesRowCount);
        initial();
    }
}