paneladdstudents.java

学员信息管理系统

                    labelLike = new JLabel();
                    panelCenter.add(labelLike);
                    labelLike.setText("兴趣爱好：");
                    labelLike.setBounds(35, 231, 63, 21);
                    labelLike.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    labelRemarks = new JLabel();
                    panelCenter.add(labelRemarks);
                    labelRemarks.setText("学生点评：");
                    labelRemarks.setBounds(364, 231, 63, 21);
                    labelRemarks.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    textFieldID = new JTextField();
                    panelCenter.add(textFieldID);
                    textFieldID.setBounds(98, 35, 105, 21);
                    textFieldID.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    textFieldName = new JTextField();
                    panelCenter.add(textFieldName);
                    textFieldName.setBounds(98, 63, 105, 21);
                    textFieldName.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxSexModel = new DefaultComboBoxModel(new String[] {
                            "请选择...", "男", "女" });
                    comboBoxSex = new JComboBox();
                    panelCenter.add(comboBoxSex);
                    comboBoxSex.setModel(comboBoxSexModel);
                    comboBoxSex.setBounds(98, 91, 105, 21);
                    comboBoxSex.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxAgeModel = new DefaultComboBoxModel(new String[] { "请选择..." });
                    comboBoxAge = new JComboBox();
                    panelCenter.add(comboBoxAge);
                    comboBoxAge.setModel(comboBoxAgeModel);
                    comboBoxAge.setBounds(98, 119, 105, 21);
                    comboBoxAge.setFont(new java.awt.Font("宋体", 0, 12));
                    for (int i = 18; i < 50; i++) {
                        this.comboBoxAge.addItem(new Integer(i));
                    }
                }
                {
                    textFieldPhone = new JTextField();
                    panelCenter.add(textFieldPhone);
                    textFieldPhone.setBounds(98, 147, 105, 21);
                    textFieldPhone.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    textFieldHandset = new JTextField();
                    panelCenter.add(textFieldHandset);
                    textFieldHandset.setBounds(98, 175, 105, 21);
                    textFieldHandset.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    textFieldAddress = new JTextField();
                    panelCenter.add(textFieldAddress);
                    textFieldAddress.setBounds(98, 203, 105, 21);
                    textFieldAddress.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxNativeModel = new DefaultComboBoxModel(new String[] { "请选择..." });
                    comboBoxNative = new JComboBox();
                    panelCenter.add(comboBoxNative);
                    comboBoxNative.setModel(comboBoxNativeModel);
                    comboBoxNative.setBounds(427, 35, 105, 21);
                    comboBoxNative.setFont(new java.awt.Font("宋体", 0, 12));
                    sqlStr = "Select * from ChinaProvince";
                    rs = SQLOperate.getResultSet(sqlStr);
                    while (rs.next()) {
                        comboBoxNative.addItem(rs.getString("Province"));
                    }
                    SQLOperate.closeRS();
                }
                {
                    ComboBoxModel comboBoxEduModel = new DefaultComboBoxModel(new String[] {
                            "请选择...", "小学", "初中", "中专", "高中", "大专", "大学",
                            "研究生", "硕士", "博士", "博士后" });
                    comboBoxEdu = new JComboBox();
                    panelCenter.add(comboBoxEdu);
                    comboBoxEdu.setModel(comboBoxEduModel);
                    comboBoxEdu.setBounds(427, 63, 105, 21);
                    comboBoxEdu.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxMarryModel = new DefaultComboBoxModel(new String[] {
                            "请选择...", "未婚", "已婚" });
                    comboBoxMarry = new JComboBox();
                    panelCenter.add(comboBoxMarry);
                    comboBoxMarry.setModel(comboBoxMarryModel);
                    comboBoxMarry.setBounds(427, 91, 105, 21);
                    comboBoxMarry.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxWorkModel = new DefaultComboBoxModel(new String[] {
                            "请选择...", "无工作经验", "有工作经验" });
                    comboBoxWork = new JComboBox();
                    panelCenter.add(comboBoxWork);
                    comboBoxWork.setModel(comboBoxWorkModel);
                    comboBoxWork.setBounds(427, 119, 105, 21);
                    comboBoxWork.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxStageModel = new DefaultComboBoxModel(new String[] {
                            "请选择...", "一期(初级)", "二期(中级)", "三期(高级)" });
                    comboBoxStage = new JComboBox();
                    panelCenter.add(comboBoxStage);
                    comboBoxStage.setModel(comboBoxStageModel);
                    comboBoxStage.setBounds(427, 147, 105, 21);
                    comboBoxStage.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxClassModel = new DefaultComboBoxModel();
                    panelCenter.add(comboBoxClass);
                    comboBoxClass.setModel(comboBoxClassModel);
                    comboBoxClass.setBounds(427, 175, 105, 21);
                    comboBoxClass.addItemListener(new ItemListener() {
                        public void itemStateChanged(ItemEvent evt) {
                            comboBoxClassItemStateChanged(evt);
                        }
                    });
                    SQLOperate.addItem(comboBoxClass, "Class_Name", "Classes", "", "");
                }
                {
                    ComboBoxModel comboBoxYModel = new DefaultComboBoxModel();
                    comboBoxY = new JComboBox();
                    panelCenter.add(comboBoxY);
                    comboBoxY.setModel(comboBoxYModel);
                    comboBoxY.setBounds(427, 203, 49, 21);
                    comboBoxY.setFont(new java.awt.Font("宋体", 0, 12));
                    for (int i = 2007; i < 2100; i++) {
                        this.comboBoxY.addItem("" + i);
                    }
                    comboBoxY.setSelectedItem(date[0]);
                }
                {
                    labelY = new JLabel();
                    panelCenter.add(labelY);
                    labelY.setText("年");
                    labelY.setBounds(476, 203, 14, 21);
                    labelY.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel jComboBox1Model = new DefaultComboBoxModel();
                    comboBoxM = new JComboBox();
                    panelCenter.add(comboBoxM);
                    comboBoxM.setModel(jComboBox1Model);
                    comboBoxM.setBounds(490, 203, 42, 21);
                    comboBoxM.setFont(new java.awt.Font("宋体", 0, 12));
                    for (int i = 1; i < 13; i++) {
                        this.comboBoxM.addItem("" + i);
                    }
                    comboBoxM.setSelectedItem(date[1]);
                }
                {
                    labelM = new JLabel();
                    panelCenter.add(labelM);
                    labelM.setText("月");
                    labelM.setBounds(532, 203, 14, 21);
                    labelM.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel jComboBox1Model = new DefaultComboBoxModel();
                    comboBoxD = new JComboBox();
                    panelCenter.add(comboBoxD);
                    comboBoxD.setModel(jComboBox1Model);
                    comboBoxD.setBounds(546, 203, 42, 21);
                    comboBoxD.setFont(new java.awt.Font("宋体", 0, 12));
                    for (int i = 1; i < 32; i++) {
                        this.comboBoxD.addItem("" + i);
                    }
                    comboBoxD.setSelectedItem(date[2]);
                }
                {
                    labelD = new JLabel();
                    panelCenter.add(labelD);
                    labelD.setText("日");
                    labelD.setBounds(588, 203, 14, 21);
                    labelD.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    scrollPaneLike = new JScrollPane();
                    panelCenter.add(scrollPaneLike);
                    scrollPaneLike.setBounds(98, 231, 196, 154);
                    {
                        textAreaLike = new JTextArea();
                        textAreaLike.setLineWrap(true);
                        scrollPaneLike.setViewportView(textAreaLike);
                        textAreaLike.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.setText(" * 格式:10001");
                    jLabel1.setBounds(203, 35, 140, 21);
                    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(" * 最少4个字符(2个汉字)");
                    jLabel2.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel2.setBounds(203, 63, 140, 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, 91, 140, 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(203, 119, 140, 21);
                    jLabel4.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel5 = new JLabel();
                    panelCenter.add(jLabel5);
                    jLabel5.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel5.setBounds(203, 147, 140, 21);
                    jLabel5.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel6 = new JLabel();
                    panelCenter.add(jLabel6);
                    jLabel6.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel6.setBounds(203, 175, 140, 21);
                    jLabel6.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel7 = new JLabel();
                    panelCenter.add(jLabel7);
                    jLabel7.setText(" * ");
                    jLabel7.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel7.setBounds(203, 203, 140, 21);
                    jLabel7.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel8 = new JLabel();
                    panelCenter.add(jLabel8);
                    jLabel8.setText(" * ");
                    jLabel8.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel8.setBounds(532, 35, 140, 21);
                    jLabel8.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel9 = new JLabel();
                    panelCenter.add(jLabel9);
                    jLabel9.setText(" * ");
                    jLabel9.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel9.setBounds(532, 63, 140, 21);
                    jLabel9.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel10 = new JLabel();
                    panelCenter.add(jLabel10);
                    jLabel10.setText(" * ");
                    jLabel10.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel10.setBounds(532, 91, 140, 21);
                    jLabel10.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel11 = new JLabel();
                    panelCenter.add(jLabel11);
                    jLabel11.setText(" * ");
                    jLabel11.setForeground(new java.awt.Color(255, 0, 0));
                    jLabel11.setBounds(532, 119, 140, 21);
                    jLabel11.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    jLabel12 = new JLabel();
                    panelCenter.add(jLabel12);
                    jLabel12.setText(" * ");