dialogupdatestudents.java

学员信息管理系统

package com.javasme.dialog;

import java.awt.BorderLayout;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
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.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
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.util.FormChecked;

public class DialogUpdateStudents extends javax.swing.JDialog {

    /**
     * 
     */
    private static final long serialVersionUID = -2749855000006225026L;

    private JLabel            labelWork;

    private JTextField        textFieldPhone;

    private JButton           buttonExit;

    private JButton           buttonReset;

    private JButton           buttonSubmit;

    private JPanel            panelDown;

    private JTextArea         textAreaRemarks;

    private JScrollPane       scrollPaneRemarks;

    private JTextArea         textAreaLike;

    private JScrollPane       scrollPaneLike;

    private JLabel            jLabel14;

    private JLabel            jLabel13;

    private JLabel            jLabel12;

    private JLabel            jLabel11;

    private JLabel            jLabel10;

    private JLabel            jLabel9;

    private JLabel            jLabel8;

    private JLabel            jLabel7;

    private JLabel            jLabel6;

    private JLabel            jLabel5;

    private JLabel            jLabel4;

    private JLabel            jLabel3;

    private JLabel            jLabel2;

    private JLabel            jLabel1;

    private JLabel            labelD;

    private JComboBox         comboBoxD;

    private JLabel            labelM;

    private JComboBox         comboBoxM;

    private JLabel            labelY;

    private JComboBox         comboBoxY;

    private JComboBox         comboBoxStage;

    private JComboBox         comboBoxWork;

    private JComboBox         comboBoxMarry;

    private JComboBox         comboBoxEdu;

    private JComboBox         comboBoxNative;

    private JComboBox         comboBoxClass;

    private JTextField        textFieldAddress;

    private JTextField        textFieldHandset;

    private JComboBox         comboBoxAge;

    private JComboBox         comboBoxSex;

    private JTextField        textFieldName;

    private JLabel            labelRemarks;

    private JLabel            labelLike;

    private JLabel            labelStartClassTime;

    private JLabel            labelClass;

    private JLabel            labelStage;

    private JLabel            labelMarry;

    private JLabel            labelEdu;

    private JLabel            labelNative;

    private JLabel            labelAddress;

    private JLabel            labelHandset;

    private JLabel            labelPhone;

    private JLabel            labelAge;

    private JLabel            labelSex;

    private JLabel            labelName;

    private JLabel            labelID;

    private JTextField        textFieldID;

    private JPanel            panelNorth;

    private JPanel            panelCenter;

    private String            sqlStr;

    private ResultSet         rs;

    private Statement         st;

    private String            id;

    private String            date;

    private String            studentID;

    public DialogUpdateStudents(JFrame frame, String id) {
        super(frame, true);
        this.id = id;
        initGUI();
        /**
         * 风格设置
         */
        LookAndFeel.UpdateLookAndFeel(this);
        initial();
    }

    private void initGUI() {
        try {
            {
                panelCenter = new JPanel();
                BorderLayout panelCenterLayout = new BorderLayout();
                panelCenter.setLayout(panelCenterLayout);
                getContentPane().add(panelCenter, BorderLayout.CENTER);
                panelCenter.setBorder(BorderFactory.createTitledBorder("修改学生信息"));
                panelCenter.setPreferredSize(new java.awt.Dimension(669, 502));
                panelCenter.setBackground(new java.awt.Color(236, 233, 216));
                {
                    panelNorth = new JPanel();
                    panelCenter.add(panelNorth, BorderLayout.CENTER);
                    panelNorth.setPreferredSize(new java.awt.Dimension(641, 420));
                    panelNorth.setLayout(null);
                    panelNorth.setBorder(BorderFactory.createEtchedBorder(BevelBorder.LOWERED));
                    panelNorth.setBackground(new java.awt.Color(236, 233, 216));
                    {
                        textFieldID = new JTextField();
                        panelNorth.add(textFieldID);
                        textFieldID.setBounds(98, 35, 105, 21);
                        textFieldID.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelID = new JLabel();
                        panelNorth.add(labelID);
                        labelID.setText("学生编号：");
                        labelID.setBounds(35, 35, 63, 21);
                        labelID.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelName = new JLabel();
                        panelNorth.add(labelName);
                        labelName.setText("学生姓名：");
                        labelName.setBounds(35, 63, 63, 21);
                        labelName.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelSex = new JLabel();
                        panelNorth.add(labelSex);
                        labelSex.setText("学生性别：");
                        labelSex.setBounds(35, 91, 63, 21);
                        labelSex.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelAge = new JLabel();
                        panelNorth.add(labelAge);
                        labelAge.setText("学生年龄：");
                        labelAge.setBounds(35, 119, 63, 21);
                        labelAge.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelPhone = new JLabel();
                        panelNorth.add(labelPhone);
                        labelPhone.setText("电话号码：");
                        labelPhone.setBounds(35, 147, 63, 21);
                        labelPhone.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelHandset = new JLabel();
                        panelNorth.add(labelHandset);
                        labelHandset.setText("手机号码：");
                        labelHandset.setBounds(35, 175, 63, 21);
                        labelHandset.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelAddress = new JLabel();
                        panelNorth.add(labelAddress);
                        labelAddress.setText("家庭住址：");
                        labelAddress.setBounds(35, 203, 63, 21);
                        labelAddress.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelNative = new JLabel();
                        panelNorth.add(labelNative);
                        labelNative.setText("学生籍贯：");
                        labelNative.setBounds(364, 35, 63, 21);
                        labelNative.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelEdu = new JLabel();
                        panelNorth.add(labelEdu);
                        labelEdu.setText("学生学历：");
                        labelEdu.setBounds(364, 63, 63, 21);
                        labelEdu.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelMarry = new JLabel();
                        panelNorth.add(labelMarry);
                        labelMarry.setText("婚姻状况：");
                        labelMarry.setBounds(364, 91, 63, 21);
                        labelMarry.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelWork = new JLabel();
                        panelNorth.add(labelWork);
                        labelWork.setText("工作经验：");
                        labelWork.setBounds(364, 119, 63, 21);
                        labelWork.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelStage = new JLabel();
                        panelNorth.add(labelStage);
                        labelStage.setText("学习阶段：");
                        labelStage.setBounds(364, 147, 63, 21);
                        labelStage.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelClass = new JLabel();
                        panelNorth.add(labelClass);
                        labelClass.setText("所在班级：");
                        labelClass.setBounds(364, 175, 63, 21);
                        labelClass.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                    {
                        labelStartClassTime = new JLabel();
                        panelNorth.add(labelStartClassTime);
                        labelStartClassTime.setText("入学时间：");
                        labelStartClassTime.setBounds(364, 203, 63, 21);