"heck_time,student_gcheck.gcheck_title,student_gcheck.gcheck_disc " +
      "FROM student.dbo.student_gcheck", null, true, Load.ALL));
    column17.setColumnName("gcheck_time");
    column17.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    column17.setEditMask("yyyy-MM-dd");
    column17.setSchemaName("dbo");
    column17.setTableName("student_gcheck");
    column17.setServerColumnName("gcheck_time");
    column17.setSqlType(93);
    column20.setCaption("獲獎時間");
    column20.setColumnName("gcheck_time");
    column20.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    column20.setEditMask("yyyy-MM-dd");
    column20.setSchemaName("dbo");
    column20.setTableName("student_gcheck");
    column20.setServerColumnName("gcheck_time");
    column20.setSqlType(93);
    jdbTable4.setDataSet(qSet_jiangli);
    column21.setColumnName("gcheck_id");
    column21.setDataType(com.borland.dx.dataset.Variant.INT);
    column21.setRowId(true);
    column21.setSchemaName("dbo");
    column21.setTableName("student_gcheck");
    column21.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column21.setServerColumnName("gcheck_id");
    column21.setSqlType(4);
    column22.setColumnName("gcheck_no");
    column22.setDataType(com.borland.dx.dataset.Variant.INT);
    column22.setSchemaName("dbo");
    column22.setTableName("student_gcheck");
    column22.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column22.setServerColumnName("gcheck_no");
    column22.setSqlType(4);
    column23.setColumnName("gcheck_name");
    column23.setDataType(com.borland.dx.dataset.Variant.STRING);
    column23.setPrecision(10);
    column23.setSchemaName("dbo");
    column23.setTableName("student_gcheck");
    column23.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column23.setServerColumnName("gcheck_name");
    column23.setSqlType(1);
    column24.setCaption("獲獎名稱");
    column24.setColumnName("gcheck_title");
    column24.setDataType(com.borland.dx.dataset.Variant.STRING);
    column24.setPrecision(50);
    column24.setSchemaName("dbo");
    column24.setTableName("student_gcheck");
    column24.setWidth(10);
    column24.setServerColumnName("gcheck_title");
    column24.setSqlType(12);
    column25.setCaption("具體說明");
    column25.setColumnName("gcheck_disc");
    column25.setDataType(com.borland.dx.dataset.Variant.STRING);
    column25.setPrecision(50);
    column25.setSchemaName("dbo");
    column25.setTableName("student_gcheck");
    column25.setWidth(20);
    column25.setServerColumnName("gcheck_disc");
    column25.setSqlType(12);
    qSet_jiangli.setColumns(new Column[] {column21, column22, column23, column20, column24, column25});
    jdbNavToolBar3.setAlignment(FlowLayout.CENTER);    this.getContentPane().add(jTabbedPane1,
                              new PaneConstraints("jTabbedPane1", "jTabbedPane1",
                                                  PaneConstraints.ROOT, 1.0f));
    jTabbedPane1.add(jPanel1, "個人信息管理");
    jPanel1.add(jPanel5, BorderLayout.CENTER);
    jPanel5.add(jdbNavToolBar1, BorderLayout.SOUTH);
    jPanel5.add(jPanel6, BorderLayout.NORTH);
    jPanel6.add(jPanel7, BorderLayout.NORTH);
    jPanel7.add(jLabel1, null);
    jPanel6.add(jPanel8, BorderLayout.CENTER);
    jPanel8.add(jLabel2,    new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 28, 19));
    jPanel8.add(jdbTextField3,      new GridBagConstraints(1, 0, 2, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 75, 13));
    jPanel8.add(jLabel4,     new GridBagConstraints(3, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 31, 19));
    jPanel8.add(jdbTextField4,   new GridBagConstraints(4, 0, 1, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 57, 13));
    jPanel8.add(jLabel6,   new GridBagConstraints(5, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 40, 19));
    jPanel8.add(jdbTextField5,   new GridBagConstraints(6, 0, 1, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 57, 13));
    jPanel8.add(jButton1,   new GridBagConstraints(7, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 3), 16, 10));
    jPanel8.add(jLabel3,    new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 30, 19));
    jPanel8.add(jPanel19,     new GridBagConstraints(2, 1, 1, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.VERTICAL, new Insets(0, 0, 0, 0), -3, 25));
    jPanel8.add(jLabel5,            new GridBagConstraints(3, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.EAST, GridBagConstraints.NONE, new Insets(0, 0, 0, 1), 30, 19));
    jPanel8.add(jdbTextField7,   new GridBagConstraints(4, 1, 1, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 7, 13));
    jPanel8.add(jLabel7,   new GridBagConstraints(5, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 40, 19));
    jPanel8.add(jdbTextField8,   new GridBagConstraints(6, 1, 1, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 57, 13));
    jPanel8.add(jButton2,   new GridBagConstraints(7, 1, 1, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 3), 16, 10));
    jPanel5.add(tableScrollPane1, BorderLayout.CENTER);
    tableScrollPane1.getViewport().add(jdbTable1, null);
    jTabbedPane1.add(jPanel2, "選課信息管理");
    jTabbedPane1.add(jPanel3, "獎勵信息管理");
    jPanel3.add(jPanel13, BorderLayout.NORTH);
    jPanel13.add(jLabel14, null);
    jPanel13.add(jdbNavField3, null);
    jPanel13.add(jLabel16, null);
    jPanel13.add(jdbTextField12, null);
    jPanel13.add(jLabel17, null);
    jPanel13.add(jdbTextField13, null);
    jPanel13.add(jLabel15, null);
    jPanel3.add(jPanel15,  BorderLayout.SOUTH);
    jPanel15.add(tableScrollPane4, BorderLayout.CENTER);    jPanel15.add(jdbNavToolBar3,  BorderLayout.SOUTH);
    tableScrollPane4.getViewport().add(jdbTable4, null);
    jPanel3.add(jPanel14, BorderLayout.CENTER);
    jPanel14.add(jPanel16, BorderLayout.WEST);
    jPanel16.add(jLabel18,  new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 17, 14));
    jPanel16.add(jLabel19,  new GridBagConstraints(0, 1, 1, 2, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 13, 10));
    jPanel16.add(jdbTextField1,   new GridBagConstraints(1, 0, 2, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 89, 2));
    jPanel16.add(jdbTextField2,        new GridBagConstraints(1, 2, 3, 2, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 91, 0));
    jPanel14.add(jPanel17, BorderLayout.CENTER);
    jPanel17.add(jdbTextArea1, BorderLayout.CENTER);
    jPanel17.add(jLabel20, BorderLayout.NORTH);
    jPanel14.add(jPanel18,  BorderLayout.EAST);
    jPanel18.add(jButton5,  BorderLayout.NORTH);
    jPanel18.add(jButton6, BorderLayout.CENTER);
    jTabbedPane1.add(jPanel4, "職務信息管理");
    jPanel2.add(jPanel9, BorderLayout.NORTH);
    jPanel9.add(jLabel8, null);
    jPanel9.add(jdbNavField2, null);
    jPanel9.add(jLabel9, null);
    jPanel9.add(jdbTextField11, null);
    jPanel9.add(jLabel10, null);
    jPanel9.add(jdbTextField9, null);
    jPanel9.add(jLabel11, null);
    jPanel9.add(jdbTextField10, null);
    jPanel2.add(jdbNavToolBar2, BorderLayout.SOUTH);
    jPanel2.add(jPanel10, BorderLayout.WEST);
    jPanel10.add(jLabel12, BorderLayout.NORTH);
    jPanel10.add(tableScrollPane2, BorderLayout.CENTER);
    tableScrollPane2.getViewport().add(jdbTable2, null);
    jPanel2.add(jPanel11, BorderLayout.EAST);
    jPanel11.add(jLabel13, BorderLayout.NORTH);
    jPanel11.add(tableScrollPane3, BorderLayout.CENTER);
    tableScrollPane3.getViewport().add(jdbTable3, null);
    jPanel2.add(jPanel12, BorderLayout.CENTER);
    jPanel12.add(jButton3, new XYConstraints(4, 89, -1, 31));
    jPanel12.add(jButton4, new XYConstraints(2, 153, 59, 33));
    jPanel19.add(jdbRadioButton1, null);
    jPanel19.add(jdbRadioButton2, null);
    buttonGroup1.add(jdbRadioButton2);
    buttonGroup1.add(jdbRadioButton1);
    jPanel7.add(jdbNavField1, null);
    jPanel13.add(jdbTextField14, null);
  }

  void jButton1_actionPerformed(ActionEvent e) {
    queryDataSet2.saveChanges();
  }

  void jButton3_actionPerformed(ActionEvent e) {
    if ( queryDataSet2.isEmpty() ) return;
    if ( queryDataSet1.isEmpty() ) return;

    if (!queryDataSet4.isOpen()) queryDataSet4.open();
    queryDataSet4.last();
      int i = queryDataSet4.getInt("count_id");
    queryDataSet4.setInt("count_id", ++i);
    queryDataSet4.post();
    queryDataSet4.saveChanges( queryDataSet4 );

    if (! qSet_course.isOpen() ) qSet_course.open();
    try {
      qSet_course.insertRow(false);
      qSet_course.setInt("count_id", i);
      qSet_course.setInt("course_id", queryDataSet2.getInt("student_id"));
      qSet_course.setString("course_name",
                            queryDataSet2.getString("student_name"));
      qSet_course.setInt("course_no", queryDataSet1.getInt("course_code"));
      qSet_course.post();
      qSet_course.saveChanges(qSet_course);
    }catch (Exception ex ){
        qSet_course.refresh();
    }
  }

  void jButton4_actionPerformed(ActionEvent e) {
    if (! qSet_course.isOpen() ) qSet_course.open();
    if ( qSet_course.isEmpty() ) return;

    qSet_course.deleteRow();
    qSet_course.saveChanges( qSet_course );
  }

  void qSet_course_filterRow(ReadRow row, RowFilterResponse response) {
    if ( row.getInt("course_id" )== queryDataSet2.getInt("student_id") )
    {
      response.add();
    }else{
      response.ignore();
    }
  }

  void queryDataSet2_masterNavigating(MasterNavigateEvent e) {

  }

  void jPanel2_focusGained(FocusEvent e) {
    qSet_course.refilter();
  }

  void queryDataSet2_navigated(NavigationEvent e) {
    qSet_course.refilter();
  }

}

class MainFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jButton1_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class MainFrame_jButton3_actionAdapter implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jButton3_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class MainFrame_jButton4_actionAdapter implements java.awt.event.ActionListener {
  MainFrame adaptee;

  MainFrame_jButton4_actionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class MainFrame_qSet_course_rowFilterAdapter implements com.borland.dx.dataset.RowFilterListener {
  MainFrame adaptee;

  MainFrame_qSet_course_rowFilterAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void filterRow(ReadRow row, RowFilterResponse response) {
    adaptee.qSet_course_filterRow(row, response);
  }
}


class MainFrame_queryDataSet2_navigationAdapter implements com.borland.dx.dataset.NavigationListener {
  MainFrame adaptee;

  MainFrame_queryDataSet2_navigationAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void navigated(NavigationEvent e) {
    adaptee.queryDataSet2_navigated(e);
  }
}