column13.setTableName("student_info");
    column13.setWidth(10);
    column13.setServerColumnName("student_tel");
    column13.setSqlType(12);
    column14.setCaption("聯系地址");
    column14.setColumnName("student_address");
    column14.setDataType(com.borland.dx.dataset.Variant.STRING);
    column14.setPrecision(150);
    column14.setSchemaName("dbo");
    column14.setTableName("student_info");
    column14.setWidth(14);
    column14.setServerColumnName("student_address");
    column14.setSqlType(12);
    queryDataSet2.setColumns(new Column[] {column9, column10, column11, column12, column8, column13, column14});
    queryDataSet2.addNavigationListener(new MainFrame_queryDataSet2_navigationAdapter(this));
    jPanel1.setFont(new java.awt.Font("SansSerif", 0, 12));
    jPanel1.setPreferredSize(new Dimension(472, 580));
    jPanel5.setFont(new java.awt.Font("SansSerif", 0, 12));
    tableScrollPane1.setFont(new java.awt.Font("SansSerif", 0, 12));
    tableScrollPane1.getViewport().setFont(new java.awt.Font("SansSerif", 0, 12));
    this.setFont(new java.awt.Font("SansSerif", 0, 12));
    jPanel2.setFont(new java.awt.Font("SansSerif", 0, 12));
    jPanel2.setLayout(borderLayout4);
    jLabel8.setText("學號：");
    jLabel9.setRequestFocusEnabled(true);
    jLabel9.setText("姓名: ");
    jLabel10.setText("班級: ");
    jLabel11.setText("性別: ");
    jdbNavToolBar2.setEnabled(false);
    jdbNavToolBar2.setAlignment(FlowLayout.CENTER);
    jPanel10.setMinimumSize(new Dimension(300, 10));
    jPanel10.setPreferredSize(new Dimension(300, 10));
    jPanel10.setLayout(borderLayout5);
    jLabel12.setText("學校設置可選課程信息");
    jPanel11.setMinimumSize(new Dimension(200, 10));
    jPanel11.setPreferredSize(new Dimension(200, 10));
    jPanel11.setLayout(borderLayout6);
    jLabel13.setText("個人已選課程信息");
    jButton3.setText("選課");
    jButton3.addActionListener(new MainFrame_jButton3_actionAdapter(this));
    jButton4.setText("退課");
    jButton4.addActionListener(new MainFrame_jButton4_actionAdapter(this));
    jPanel12.setLayout(xYLayout1);
    queryDataSet1.setReadOnly(false);
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_coursecode.course_code,student_coursecode.course_name,student_coursecode.course_period" +
      ",student_coursecode.course_credit,student_coursecode.course_teacher,student_coursecode.course_address" +
      " FROM student.dbo.student_coursecode", null, true, Load.ALL));
    column1.setCaption("課程代號");
    column1.setColumnName("course_code");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setRowId(true);
    column1.setSchemaName("dbo");
    column1.setTableName("student_coursecode");
    column1.setWidth(10);
    column1.setServerColumnName("course_code");
    column1.setSqlType(4);
    column2.setCaption("課程名稱");
    column2.setColumnName("course_name");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(50);
    column2.setSchemaName("dbo");
    column2.setTableName("student_coursecode");
    column2.setWidth(10);
    column2.setServerColumnName("course_name");
    column2.setSqlType(12);
    column3.setCaption("課程學時");
    column3.setColumnName("course_period");
    column3.setDataType(com.borland.dx.dataset.Variant.INT);
    column3.setSchemaName("dbo");
    column3.setTableName("student_coursecode");
    column3.setWidth(10);
    column3.setServerColumnName("course_period");
    column3.setSqlType(4);
    column4.setCaption("課程學分");
    column4.setColumnName("course_credit");
    column4.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
    column4.setSchemaName("dbo");
    column4.setTableName("student_coursecode");
    column4.setWidth(10);
    column4.setServerColumnName("course_credit");
    column4.setSqlType(6);
    column5.setCaption("任課老師");
    column5.setColumnName("course_teacher");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setPrecision(50);
    column5.setSchemaName("dbo");
    column5.setTableName("student_coursecode");
    column5.setWidth(10);
    column5.setServerColumnName("course_teacher");
    column5.setSqlType(12);
    column6.setCaption("上課地點");
    column6.setColumnName("course_address");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setPrecision(50);
    column6.setSchemaName("dbo");
    column6.setTableName("student_coursecode");
    column6.setWidth(10);
    column6.setServerColumnName("course_address");
    column6.setSqlType(12);
    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6});
    jdbTable2.setDataSet(queryDataSet1);
    jdbTable2.setEditable(false);
    column7.setCaption("學生姓名");
    column7.setColumnName("course_name");
    column7.setDataType(com.borland.dx.dataset.Variant.STRING);
    column7.setPrecision(50);
    column7.setSchemaName("dbo");
    column7.setTableName("student_course");
    column7.setWidth(10);
    column7.setServerColumnName("course_name");
    column7.setSqlType(12);
    jLabel14.setText("學號：");
    jLabel15.setText("性別: ");
    jLabel16.setRequestFocusEnabled(true);
    jLabel16.setText("姓名: ");
    jLabel17.setText("班級: ");
    jPanel3.setLayout(borderLayout7);
    jPanel15.setMinimumSize(new Dimension(200, 100));
    jPanel15.setPreferredSize(new Dimension(200, 250));
    jPanel15.setLayout(borderLayout8);
    jPanel14.setLayout(borderLayout9);
    jPanel14.setMinimumSize(new Dimension(300, 50));
    jPanel14.setPreferredSize(new Dimension(300, 50));
    jPanel14.setVerifyInputWhenFocusTarget(true);
    jPanel13.setPreferredSize(new Dimension(404, 40));
    jPanel16.setPreferredSize(new Dimension(280, 10));
    jPanel16.setLayout(gridBagLayout1);
    jLabel18.setText("獲獎時間:");
    jLabel19.setText("獲獎名稱:");
    jdbTextField1.setText("jdbTextField1");
    jdbTextField1.setColumnName("gcheck_time");
    jdbTextField1.setDataSet(qSet_jiangli);
    jdbTextField2.setText("jdbTextField2");
    jdbTextField2.setColumnName("gcheck_title");
    jdbTextField2.setDataSet(qSet_jiangli);
    jdbTextArea1.setText("jdbTextArea1");
    jdbTextArea1.setColumnName("gcheck_disc");
    jdbTextArea1.setDataSet(qSet_jiangli);
    jPanel17.setLayout(borderLayout10);
    jButton5.setText("增加");
    jButton6.setText("取消");
    jPanel18.setLayout(borderLayout11);
    borderLayout11.setVgap(10);
    jLabel20.setText("獲獎內容具體描述:");
    jdbTextField3.setEnabled(true);
    jdbTextField3.setAlignmentX((float) 0.5);
    jdbTextField3.setDoubleBuffered(false);
    jdbTextField3.setMinimumSize(new Dimension(10, 22));
    jdbTextField3.setPreferredSize(new Dimension(15, 22));
    jdbTextField3.setMargin(new Insets(1, 3, 1, 3));
    jdbTextField3.setText("");
    jdbTextField3.setHorizontalAlignment(SwingConstants.LEFT);
    jdbTextField3.setColumnName("student_name");
    jdbTextField3.setDataSet(queryDataSet2);
    jdbTextField3.setEnablePopupMenu(true);
    jdbTextField3.setPostOnFocusLost(true);
    jdbTextField4.setDebugGraphicsOptions(0);
    jdbTextField4.setText("jdbTextField4");
    jdbTextField4.setColumnName("student_class");
    jdbTextField4.setDataSet(queryDataSet2);
    jdbTextField5.setText("jdbTextField5");
    jdbTextField5.setColumnName("student_tel");
    jdbTextField5.setDataSet(queryDataSet2);
    jdbTextField7.setDisabledTextColor(Color.gray);
    jdbTextField7.setText("jdbTextField7");
    jdbTextField7.setColumnName("student_birthday");
    jdbTextField7.setDataSet(queryDataSet2);
    jdbTextField8.setText("jdbTextField8");
    jdbTextField8.setColumnName("student_address");
    jdbTextField8.setDataSet(queryDataSet2);
    jdbRadioButton2.setSelected(false);
    jdbRadioButton2.setText("女");
    jdbRadioButton2.setButtonGroup(buttonGroup1);
    jdbRadioButton2.setColumnName("student_sex");
    jdbRadioButton2.setDataSet(queryDataSet2);
    jdbRadioButton2.setSelectedDataValue("女");
    jdbRadioButton1.setActionCommand("男");
    jdbRadioButton1.setContentAreaFilled(true);
    jdbRadioButton1.setSelected(true);
    jdbRadioButton1.setText("男");
    jdbRadioButton1.setButtonGroup(buttonGroup1);
    jdbRadioButton1.setColumnName("student_sex");
    jdbRadioButton1.setDataSet(queryDataSet2);
    jdbRadioButton1.setSelectedDataValue("男");
    jdbNavField1.setMinimumSize(new Dimension(100, 22));
    jdbNavField1.setPreferredSize(new Dimension(100, 22));
    jdbNavField1.setText("jdbNavField1");
    jdbNavField1.setColumnName("student_id");
    jdbNavField1.setDataSet(queryDataSet2);
    jdbTextField9.setEnabled(true);

    jdbTextField9.setPreferredSize(new Dimension(70, 22));
    jdbTextField9.setEditable(false);
    jdbTextField9.setText("jdbTextField9");
    jdbTextField9.setColumns(0);
    jdbTextField9.setColumnName("student_class");
    jdbTextField9.setDataSet(queryDataSet2);
    jdbTextField10.setEnabled(true);
    jdbTextField10.setPreferredSize(new Dimension(50, 22));
    jdbTextField10.setEditable(false);
    jdbTextField10.setText("jdbTextField10");
    jdbTextField10.setColumnName("student_sex");
    jdbTextField10.setDataSet(queryDataSet2);
    queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_count.count_id FROM student.dbo.student_count", null, true, Load.ALL));
    qSet_course.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_course.count_id,student_course.course_id,student_course.course_name,student_course.cou" +
      "rse_no FROM student.dbo.student_course", null, true, Load.ALL));
    column15.setColumnName("count_id");
    column15.setDataType(com.borland.dx.dataset.Variant.INT);
    column15.setRowId(true);
    column15.setSchemaName("dbo");
    column15.setTableName("student_course");
    column15.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column15.setServerColumnName("count_id");
    column15.setSqlType(4);
    column16.setColumnName("course_id");
    column16.setDataType(com.borland.dx.dataset.Variant.INT);
    column16.setSchemaName("dbo");
    column16.setTableName("student_course");
    column16.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column16.setServerColumnName("course_id");
    column16.setSqlType(4);
    column18.setCaption("學生姓名");
    column18.setColumnName("course_name");
    column18.setDataType(com.borland.dx.dataset.Variant.STRING);
    column18.setPrecision(50);
    column18.setSchemaName("dbo");
    column18.setTableName("student_course");
    column18.setWidth(10);
    column18.setServerColumnName("course_name");
    column18.setSqlType(12);
    column19.setCaption("所選課程編號");
    column19.setColumnName("course_no");
    column19.setDataType(com.borland.dx.dataset.Variant.INT);
    column19.setSchemaName("dbo");
    column19.setTableName("student_course");
    column19.setServerColumnName("course_no");
    column19.setSqlType(4);
    qSet_course.setColumns(new Column[] {column15, column16, column18, column19});
    qSet_course.addRowFilterListener(new MainFrame_qSet_course_rowFilterAdapter(this));
    jdbTable3.setDataSet(qSet_course);
    jdbTextField11.setMinimumSize(new Dimension(70, 22));
    jdbTextField11.setPreferredSize(new Dimension(70, 22));
    jdbTextField11.setEditable(false);
    jdbTextField11.setText("jdbTextField11");
    jdbTextField11.setColumnName("student_name");
    jdbTextField11.setDataSet(queryDataSet2);
    jdbNavField2.setDataSet(queryDataSet2);
    jdbNavField2.setColumnName("student_id");
    jdbNavField2.setPreferredSize(new Dimension(70, 22));
    jdbNavField2.setMinimumSize(new Dimension(70, 22));
    jdbNavField3.setMinimumSize(new Dimension(70, 22));
    jdbNavField3.setPreferredSize(new Dimension(70, 22));
    jdbNavField3.setColumnName("student_id");
    jdbNavField3.setDataSet(queryDataSet2);
    jdbTextField12.setDataSet(queryDataSet2);
    jdbTextField12.setColumnName("student_name");
    jdbTextField12.setText("jdbTextField11");
    jdbTextField12.setEditable(false);
    jdbTextField12.setPreferredSize(new Dimension(70, 22));
    jdbTextField12.setMinimumSize(new Dimension(70, 22));
    jdbTextField13.setDataSet(queryDataSet2);
    jdbTextField13.setColumnName("student_class");
    jdbTextField13.setColumns(0);
    jdbTextField13.setText("jdbTextField9");
    jdbTextField13.setEditable(false);
    jdbTextField13.setPreferredSize(new Dimension(70, 22));
    jdbTextField13.setEnabled(true);
    jdbTextField14.setDataSet(queryDataSet2);
    jdbTextField14.setColumnName("student_sex");
    jdbTextField14.setText("jdbTextField10");
    jdbTextField14.setEditable(false);
    jdbTextField14.setPreferredSize(new Dimension(50, 22));
    jdbTextField14.setEnabled(true);
    qSet_jiangli.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_gcheck.gcheck_id,student_gcheck.gcheck_no,student_gcheck.gcheck_name,student_gcheck.gc" +
      "heck_time,student_gcheck.gcheck_title,student_gcheck.gcheck_disc " +
      "FROM student.dbo.student_gcheck", null, true, Load.ALL));
    column20.setCaption("獲獎時間");
    column20.setColumnName("gcheck_time");
    column20.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    column20.setEditMask("yyyy-MM-dd");
    column20.setDisplayMask( "yyyy-MM-dd");
    column20.setSchemaName("dbo");