break;

      case 2:
        try{
          if (queryDataSet3.isOpen()) queryDataSet3.close();
          String sql = "select * from family where sid = \'"+sid+ "\'";

          queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
              database1, sql, null, true, Load.ALL));
          //JOptionPane.showMessageDialog(this,sql);
          queryDataSet3.open();

        }catch(Exception ex){JOptionPane.showMessageDialog(this,ex.toString());}
        break;
      case 3:
        try{
          if (queryDataSet4.isOpen()) queryDataSet4.close();
          String sql = "select * from honor where sid = \'"+sid+ "\'";

          queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
              database1, sql, null, true, Load.ALL));
          //JOptionPane.showMessageDialog(this,sql);
          queryDataSet4.open();

        }catch(Exception ex){JOptionPane.showMessageDialog(this,ex.toString());}
        break;
      case 4:
        try{
          if (queryDataSet5.isOpen()) queryDataSet5.close();
          String sql = "select * from train where sid = \'"+sid+ "\'";

          queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
              database1, sql, null, true, Load.ALL));
          //JOptionPane.showMessageDialog(this,sql);
          queryDataSet5.open();

        }catch(Exception ex){JOptionPane.showMessageDialog(this,ex.toString());}
        break;

      default:break;

    }

  }
  void jTabbedPane1_stateChanged(ChangeEvent e) {
   // JOptionPane.showMessageDialog(this,jTabbedPane1.getSelectedIndex()+"");
   otherRefresh();
  }

  void jButton1_actionPerformed(ActionEvent e) {
    switch(jTabbedPane1.getSelectedIndex()){
      case 0:
        queryDataSet1.insertRow(false);
        break;
      case 1:
        queryDataSet2.insertRow(false);
        break;

      case 2:
        queryDataSet3.insertRow(false);
        break;
      case 3:
        queryDataSet4.insertRow(false);
        break;
      case 4:
        queryDataSet5.insertRow(false);
        break;

      default:break;

    }

  }

  void jButton2_actionPerformed(ActionEvent e) {
    String sid;
    if(queryDataSet1.getRowCount()==0)
      sid="";
    else
      sid=queryDataSet1.getString("stano");

    switch(jTabbedPane1.getSelectedIndex()){
      case 0:
        try{
           queryDataSet1.post();
           queryDataSet1.saveChanges();
           queryDataSet1.refresh();
         }catch(Exception ex){
           queryDataSet1.refresh();
           JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.ERROR_MESSAGE);
         }
        break;
      case 1:
        if(queryDataSet1.getRowCount()==0)
          break;
        if(jdbTextField20.getText().length()==0)
        {
          JOptionPane.showMessageDialog(this,"開始時間不能為空","提示",JOptionPane.INFORMATION_MESSAGE);
          break;
        }
        try{
           queryDataSet2.setString("sid",sid);
           queryDataSet2.post();
           queryDataSet2.saveChanges();
           queryDataSet2.refresh();
         }catch(Exception ex){
           queryDataSet2.refresh();
           JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.ERROR_MESSAGE);
         }

        break;

      case 2:
        if(queryDataSet1.getRowCount()==0)
          break;
        if(jdbTextField29.getText().length()==0)
        {
          JOptionPane.showMessageDialog(this,"家屬姓名不能為空","提示",JOptionPane.INFORMATION_MESSAGE);
          break;
        }
        try{
           queryDataSet3.setString("sid",sid);
           queryDataSet3.post();
           queryDataSet3.saveChanges();
           queryDataSet3.refresh();
         }catch(Exception ex){
           queryDataSet3.refresh();
           JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.ERROR_MESSAGE);
         }

        break;
      case 3:
        if(queryDataSet1.getRowCount()==0)
          break;
        if(jdbTextField214.getText().length()==0)
        {
          JOptionPane.showMessageDialog(this,"獎懲類型不能為空","提示",JOptionPane.INFORMATION_MESSAGE);
          break;
        }
        try{
           queryDataSet4.setString("sid",sid);
           queryDataSet4.post();
           queryDataSet4.saveChanges();
           queryDataSet4.refresh();
         }catch(Exception ex){
           queryDataSet4.refresh();
           JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.ERROR_MESSAGE);
         }

        break;
      case 4:
        if(queryDataSet1.getRowCount()==0)
          break;
        if(jdbTextField219.getText().length()==0)
        {
          JOptionPane.showMessageDialog(this,"培訓課程不能為空","提示",JOptionPane.INFORMATION_MESSAGE);
          break;
        }
        try{
           queryDataSet5.setString("sid",sid);
           queryDataSet5.post();
           queryDataSet5.saveChanges();
           queryDataSet5.refresh();
         }catch(Exception ex){
           queryDataSet5.refresh();
           JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.ERROR_MESSAGE);
         }

        break;

      default:break;

    }

  }

  void jButton3_actionPerformed(ActionEvent e) {
    switch(jTabbedPane1.getSelectedIndex()){
      case 0:
        try{
          queryDataSet1.deleteRow();
          queryDataSet1.post();
          queryDataSet1.saveChanges();
          queryDataSet1.refresh();
        }catch(Exception ex){
          queryDataSet1.refresh();
          JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.ERROR_MESSAGE);
        }

        break;
      case 1:
        try{
          queryDataSet2.deleteRow();
          queryDataSet2.post();
          queryDataSet2.saveChanges();
          queryDataSet2.refresh();
        }catch(Exception ex){
          queryDataSet2.refresh();
          JOptionPane.showMessageDialog(this,"刪除失敗","提示",JOptionPane.ERROR_MESSAGE);
        }

        break;

      case 2:
        try{
          queryDataSet3.deleteRow();
          queryDataSet3.post();
          queryDataSet3.saveChanges();
          queryDataSet3.refresh();
        }catch(Exception ex){
          queryDataSet3.refresh();
          JOptionPane.showMessageDialog(this,"刪除失敗","提示",JOptionPane.ERROR_MESSAGE);
        }

        break;
      case 3:
        try{
          queryDataSet4.deleteRow();
          queryDataSet4.post();
          queryDataSet4.saveChanges();
          queryDataSet4.refresh();
        }catch(Exception ex){
          queryDataSet4.refresh();
          JOptionPane.showMessageDialog(this,"刪除失敗","提示",JOptionPane.ERROR_MESSAGE);
        }

        break;
      case 4:
        try{
          queryDataSet5.deleteRow();
          queryDataSet5.post();
          queryDataSet5.saveChanges();
          queryDataSet5.refresh();
        }catch(Exception ex){
          queryDataSet5.refresh();
          JOptionPane.showMessageDialog(this,"刪除失敗","提示",JOptionPane.ERROR_MESSAGE);
        }

        break;

      default:break;

    }

  }

  void jButton4_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  void queryDataSet1_dataChanged(DataChangeEvent e) {
    otherRefresh();
  }

  void jdbTable1_mouseClicked(MouseEvent e) {
    otherRefresh();

  }
}

class Base_Dialog_jTabbedPane1_changeAdapter implements javax.swing.event.ChangeListener {
  Base_Dialog adaptee;

  Base_Dialog_jTabbedPane1_changeAdapter(Base_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void stateChanged(ChangeEvent e) {
    adaptee.jTabbedPane1_stateChanged(e);
  }
}

class Base_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Base_Dialog adaptee;

  Base_Dialog_jButton1_actionAdapter(Base_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Base_Dialog_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Base_Dialog adaptee;

  Base_Dialog_jButton2_actionAdapter(Base_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class Base_Dialog_jButton3_actionAdapter implements java.awt.event.ActionListener {
  Base_Dialog adaptee;

  Base_Dialog_jButton3_actionAdapter(Base_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class Base_Dialog_jButton4_actionAdapter implements java.awt.event.ActionListener {
  Base_Dialog adaptee;

  Base_Dialog_jButton4_actionAdapter(Base_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class Base_Dialog_queryDataSet1_dataChangeAdapter extends com.borland.dx.dataset.DataChangeAdapter {
  Base_Dialog adaptee;

  Base_Dialog_queryDataSet1_dataChangeAdapter(Base_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void dataChanged(DataChangeEvent e) {
    adaptee.queryDataSet1_dataChanged(e);
  }
}

class Base_Dialog_jdbTable1_mouseAdapter extends java.awt.event.MouseAdapter {
  Base_Dialog adaptee;

  Base_Dialog_jdbTable1_mouseAdapter(Base_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jdbTable1_mouseClicked(e);
  }
}