column35.setTableName("family");
    column35.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column35.setServerColumnName("sid");
    column35.setSqlType(12);
    column36.setCaption("姓名");
    column36.setColumnName("name");
    column36.setDataType(com.borland.dx.dataset.Variant.STRING);
    column36.setPrecision(10);
    column36.setTableName("family");
    column36.setServerColumnName("name");
    column36.setSqlType(12);
    column37.setCaption("關(guān)系");
    column37.setColumnName("relation");
    column37.setDataType(com.borland.dx.dataset.Variant.STRING);
    column37.setPrecision(10);
    column37.setTableName("family");
    column37.setServerColumnName("relation");
    column37.setSqlType(12);
    column38.setCaption("電話");
    column38.setColumnName("tel");
    column38.setDataType(com.borland.dx.dataset.Variant.STRING);
    column38.setPrecision(10);
    column38.setTableName("family");
    column38.setServerColumnName("tel");
    column38.setSqlType(12);
    column39.setCaption("單位");
    column39.setColumnName("com");
    column39.setDataType(com.borland.dx.dataset.Variant.STRING);
    column39.setPrecision(32);
    column39.setTableName("family");
    column39.setServerColumnName("com");
    column39.setSqlType(12);
    column40.setCaption("備注");
    column40.setColumnName("brief");
    column40.setDataType(com.borland.dx.dataset.Variant.STRING);
    column40.setSearchable(false);
    column40.setTableName("family");
    column40.setServerColumnName("brief");
    queryDataSet3.setColumns(new Column[] {column34, column35, column36, column37, column38, column39, column40});
    column41.setCaption("備注");
    column41.setColumnName("brief");
    column41.setDataType(com.borland.dx.dataset.Variant.STRING);
    column41.setSearchable(false);
    column41.setTableName("family");
    column41.setServerColumnName("brief");
    queryDataSet3.setColumns(new Column[] {column34, column35, column36, column37, column38, column39, column41});
    column43.setColumnName("sid");
    column43.setDataType(com.borland.dx.dataset.Variant.STRING);
    column43.setPrecision(16);
    column43.setTableName("honor");
    column43.setVisible(com.borland.jb.util.TriStateProperty.TRUE);
    column43.setServerColumnName("sid");
    column43.setSqlType(12);
    column45.setCaption("事件");
    column45.setColumnName("topic");
    column45.setDataType(com.borland.dx.dataset.Variant.STRING);
    column45.setPrecision(32);
    column45.setTableName("honor");
    column45.setServerColumnName("topic");
    column45.setSqlType(12);
    column47.setCaption("處理時(shí)間");
    column47.setColumnName("mdate");
    column47.setDataType(com.borland.dx.dataset.Variant.STRING);
    column47.setPrecision(18);
    column47.setTableName("honor");
    column47.setServerColumnName("mdate");
    column47.setSqlType(12);
    queryDataSet4.setColumns(new Column[] {column43, column45, column47});
    queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from honor;", null, true, Load.ALL));
    column42.setColumnName("id");
    column42.setDataType(com.borland.dx.dataset.Variant.INT);
    column42.setRowId(true);
    column42.setTableName("honor");
    column42.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column42.setServerColumnName("id");
    column42.setSqlType(4);
    column44.setColumnName("sid");
    column44.setDataType(com.borland.dx.dataset.Variant.STRING);
    column44.setPrecision(16);
    column44.setTableName("honor");
    column44.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column44.setServerColumnName("sid");
    column44.setSqlType(12);
    column46.setCaption("獎(jiǎng)懲類型");
    column46.setColumnName("sort");
    column46.setDataType(com.borland.dx.dataset.Variant.STRING);
    column46.setPrecision(16);
    column46.setTableName("honor");
    column46.setServerColumnName("sort");
    column46.setSqlType(12);
    column48.setCaption("事件");
    column48.setColumnName("topic");
    column48.setDataType(com.borland.dx.dataset.Variant.STRING);
    column48.setPrecision(32);
    column48.setTableName("honor");
    column48.setServerColumnName("topic");
    column48.setSqlType(12);
    column49.setCaption("處理部門");
    column49.setColumnName("dep");
    column49.setDataType(com.borland.dx.dataset.Variant.STRING);
    column49.setPrecision(18);
    column49.setTableName("honor");
    column49.setServerColumnName("dep");
    column49.setSqlType(12);
    column50.setCaption("處理日期");
    column50.setColumnName("mdate");
    column50.setDataType(com.borland.dx.dataset.Variant.STRING);
    column50.setPrecision(18);
    column50.setTableName("honor");
    column50.setServerColumnName("mdate");
    column50.setSqlType(12);
    column51.setCaption("處理結(jié)果");
    column51.setColumnName("des");
    column51.setDataType(com.borland.dx.dataset.Variant.STRING);
    column51.setSearchable(false);
    column51.setTableName("honor");
    column51.setServerColumnName("des");
    queryDataSet4.setColumns(new Column[] {column42, column44, column46, column48, column49, column50, column51});
    queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from train;", null, true, Load.ALL));
    column52.setColumnName("id");
    column52.setDataType(com.borland.dx.dataset.Variant.INT);
    column52.setRowId(true);
    column52.setTableName("train");
    column52.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column52.setServerColumnName("id");
    column52.setSqlType(4);
    column53.setColumnName("sid");
    column53.setDataType(com.borland.dx.dataset.Variant.STRING);
    column53.setPrecision(16);
    column53.setTableName("train");
    column53.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column53.setServerColumnName("sid");
    column53.setSqlType(12);
    column54.setCaption("培訓(xùn)課程");
    column54.setColumnName("course");
    column54.setDataType(com.borland.dx.dataset.Variant.STRING);
    column54.setPrecision(32);
    column54.setTableName("train");
    column54.setServerColumnName("course");
    column54.setSqlType(12);
    column55.setCaption("培訓(xùn)期限");
    column55.setColumnName("dlimit");
    column55.setDataType(com.borland.dx.dataset.Variant.STRING);
    column55.setPrecision(32);
    column55.setTableName("train");
    column55.setServerColumnName("dlimit");
    column55.setSqlType(12);
    column56.setCaption("開(kāi)始日期");
    column56.setColumnName("sdate");
    column56.setDataType(com.borland.dx.dataset.Variant.STRING);
    column56.setPrecision(32);
    column56.setTableName("train");
    column56.setServerColumnName("sdate");
    column56.setSqlType(12);
    column57.setCaption("結(jié)束日期");
    column57.setColumnName("edate");
    column57.setDataType(com.borland.dx.dataset.Variant.STRING);
    column57.setPrecision(32);
    column57.setTableName("train");
    column57.setServerColumnName("edate");
    column57.setSqlType(12);
    column58.setCaption("培訓(xùn)單位");
    column58.setColumnName("trcom");
    column58.setDataType(com.borland.dx.dataset.Variant.STRING);
    column58.setPrecision(32);
    column58.setTableName("train");
    column58.setServerColumnName("trcom");
    column58.setSqlType(12);
    column59.setCaption("獲得證書");
    column59.setColumnName("certi");
    column59.setDataType(com.borland.dx.dataset.Variant.STRING);
    column59.setPrecision(32);
    column59.setTableName("train");
    column59.setServerColumnName("certi");
    column59.setSqlType(12);
    queryDataSet5.setColumns(new Column[] {column52, column53, column54, column55, column56, column57, column58, column59});
    jdbTable5.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
    jdbTable5.setDataSet(queryDataSet5);
    jdbTable4.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
    jdbTable4.setDataSet(queryDataSet4);
    jdbTable3.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
    jdbTable3.setDataSet(queryDataSet3);
    jdbTextField21.setColumnName("edate");
    jdbTextField21.setDataSet(queryDataSet2);
    jdbTextField22.setColumnName("dep");
    jdbTextField22.setDataSet(queryDataSet2);
    jdbTextField27.setColumnName("relation");
    jdbTextField27.setDataSet(queryDataSet3);
    jdbTextField28.setColumnName("com");
    jdbTextField28.setDataSet(queryDataSet3);
    jdbTextField212.setColumnName("topic");
    jdbTextField212.setDataSet(queryDataSet4);
    jdbTextField213.setColumnName("mdate");
    jdbTextField213.setDataSet(queryDataSet4);
    jdbTextField217.setColumnName("dlimit");
    jdbTextField217.setDataSet(queryDataSet5);
    jdbTextField218.setColumnName("edate");
    jdbTextField218.setDataSet(queryDataSet5);
    jdbTextField2110.setColumnName("certi");
    jdbTextField2110.setDataSet(queryDataSet5);
    jLabel30.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel30.setText("員工列表：");
    jPanel6.setBorder(null);
    this.setResizable(false);
    this.setTitle("基本檔案管理");
    getContentPane().add(panel1);
    panel1.add(jTabbedPane1,  new GridBagConstraints(1, 0, 1, 2, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(17, 9, 0, 16), 8, 15));
    panel1.add(tableScrollPane1,  new GridBagConstraints(0, 1, 1, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(8, 14, 0, 0), -271, -76));
    panel1.add(jPanel6,  new GridBagConstraints(0, 2, 2, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(11, 14, 15, 16), 65, 13));
    jPanel6.add(jButton3, new XYConstraints(339, 11, 78, -1));
    jPanel6.add(jButton2, new XYConstraints(203, 11, 78, -1));
    jPanel6.add(jButton4, new XYConstraints(477, 10, 78, -1));
    jPanel6.add(jButton1, new XYConstraints(71, 11, 78, -1));
    panel1.add(jLabel30,  new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(17, 21, 0, 129), 0, 0));
    tableScrollPane1.getViewport().add(jdbTable1, null);
    jTabbedPane1.add(jPanel2,    "基本資料");
    jPanel2.add(jdbTextField1,    new XYConstraints(84, 20, 90, -1));
    jPanel2.add(jdbTextField2,     new XYConstraints(268, 20, 119, -1));
    jPanel2.add(jLabel2,  new XYConstraints(189, 20, -1, -1));
    jPanel2.add(jLabel3,  new XYConstraints(189, 50, -1, -1));
    jPanel2.add(jLabel4, new XYConstraints(16, 50, -1, -1));
    jPanel2.add(jdbTextField4,  new XYConstraints(84, 48, 90, -1));
    jPanel2.add(jdbTextField3,  new XYConstraints(268, 47, 119, -1));
    jPanel2.add(jdbTextField6,  new XYConstraints(84, 76, 90, -1));
    jPanel2.add(jLabel6, new XYConstraints(16, 78, -1, -1));
    jPanel2.add(jLabel5,  new XYConstraints(189, 77, -1, -1));
    jPanel2.add(jdbTextField5,  new XYConstraints(268, 76, 119, -1));
    jPanel2.add(jdbTextField8,  new XYConstraints(84, 105, 90, -1));
    jPanel2.add(jLabel8,  new XYConstraints(16, 107, -1, -1));
    jPanel2.add(jLabel7,  new XYConstraints(189, 106, -1, -1));
    jPanel2.add(jdbTextField7,  new XYConstraints(268, 105, 119, -1));
    jPanel2.add(jdbTextField10,  new XYConstraints(84, 134, 90, -1));
    jPanel2.add(jLabel10,  new XYConstraints(16, 136, -1, -1));
    jPanel2.add(jLabel9,  new XYConstraints(189, 137, -1, -1));
    jPanel2.add(jdbTextField9,   new XYConstraints(268, 134, 119, -1));
    jPanel2.add(jdbTextField12,  new XYConstraints(84, 161, 90, -1));
    jPanel2.add(jLabel12,  new XYConstraints(16, 163, -1, -1));
    jPanel2.add(jLabel11,  new XYConstraints(189, 164, -1, -1));
    jPanel2.add(jdbTextField11,  new XYConstraints(268, 161, 119, -1));
    jPanel2.add(jdbTextField14,  new XYConstraints(84, 189, 90, -1));
    jPanel2.add(jLabel14,  new XYConstraints(16, 191, -1, -1));
    jPanel2.add(jLabel13,  new XYConstraints(189, 192, -1, -1));
    jPanel2.add(jdbTextField13,  new XYConstraints(268, 189, 119, -1));
    jPanel2.add(jdbTextField16,  new XYConstraints(84, 217, 90, -1));
    jPanel2.add(jLabel16,  new XYConstraints(16, 218, -1, -1));
    jPanel2.add(jLabel15,  new XYConstraints(189, 220, -1, -1));
    jPanel2.add(jdbTextField15, new XYConstraints(267, 217, 119, -1));
    jPanel2.add(jdbTextField18, new XYConstraints(84, 245, 90, -1));
    jPanel2.add(jLabel18,  new XYConstraints(16, 247, -1, -1));
    jPanel2.add(jLabel17,  new XYConstraints(189, 248, -1, -1));
    jPanel2.add(jdbTextField17, new XYConstraints(268, 245, 119, -1));
    jPanel2.add(jdbTextField110,   new XYConstraints(84, 273, 303, -1));
    jPanel2.add(jLabel110,  new XYConstraints(16, 275, -1, -1));
    jPanel2.add(jLabel19,  new XYConstraints(16, 304, -1, -1));
    jPanel2.add(jdbTextField19,    new XYConstraints(84, 302, 303, -1));
    jPanel2.add(jLabel1,        new XYConstraints(16, 20, -1, -1));
    jTabbedPane1.add(jPanel1,     "工作經(jīng)歷");
    jPanel1.add(tableScrollPane2, new XYConstraints(13, 17, 391, 187));
    jPanel1.add(jLabel21,  new XYConstraints(213, 226, -1, -1));
    jPanel1.add(jdbTextField23, new XYConstraints(100, 256, 93, -1));
    jPanel1.add(jLabel22, new XYConstraints(213, 257, -1, -1));
    jPanel1.add(jLabel23, new XYConstraints(28, 257, -1, -1));
    jPanel1.add(jdbTextField22, new XYConstraints(290, 256, 102, -1));
    jPanel1.add(jLabel20,  new XYConstraints(28, 226, -1, -1));
    jPanel1.add(jdbTextField20,  new XYConstraints(100, 225, 93, -1));
    jPanel1.add(jdbTextField21,  new XYConstraints(290, 225, 102, -1));
    jPanel1.add(jdbTextField25,   new XYConstraints(100, 287, 292, -1));
    jPanel1.add(jLabel25, new XYConstraints(28, 288, -1, -1));
    tableScrollPane2.getViewport().add(jdbTable2, null);
    jTabbedPane1.add(jPanel3,   "家庭成員");
    jPanel3.add(tableScrollPane3, new XYConstraints(7, 12, 398, 179));
    jPanel3.add(jdbTextField24, new XYConstraints(99, 239, 93, -1));
    jPanel3.add(jLabel29, new XYConstraints(27, 240, -1, -1));
    jPanel3.add(jLabel26, new XYConstraints(27, 209, -1, -1));
    jPanel3.add(jdbTextField29, new XYConstraints(99, 208, 93, -1));
    jPanel3.add(jLabel24, new XYConstraints(212, 209, -1, -1));
    jPanel3.add(jdbTextField27, new XYConstraints(289, 208, 102, -1));
    jPanel3.add(jLabel27, new XYConstraints(212, 240, -1, -1));
    jPanel3.add(jdbTextField28, new XYConstraints(289, 239, 102, -1));
    jPanel3.add(jLabel28, new XYConstraints(27, 271, -1, -1));
    jPanel3.add(jdbTextField26, new XYConstraints(99, 270, 292, -1));
    tableScrollPane3.getViewport().add(jdbTable3, null);
    jTabbedPane1.add(jPanel4,   "獎(jiǎng)懲記錄");
    jPanel4.add(tableScrollPane4, new XYConstraints(10, 12, 395, 182));
    jPanel4.add(jdbTextField210, new XYConstraints(96, 242, 93, -1));
    jPanel4.add(jLabel214, new XYConstraints(24, 243, -1, -1));
    jPanel4.add(jLabel211, new XYConstraints(24, 212, -1, -1));
    jPanel4.add(jdbTextField214, new XYConstraints(96, 211, 93, -1));
    jPanel4.add(jLabel210, new XYConstraints(209, 212, -1, -1));
    jPanel4.add(jdbTextField212, new XYConstraints(286, 211, 102, -1));
    jPanel4.add(jLabel212, new XYConstraints(209, 243, -1, -1));
    jPanel4.add(jdbTextField213, new XYConstraints(286, 242, 102, -1));
    jPanel4.add(jLabel213, new XYConstraints(24, 274, -1, -1));
    jPanel4.add(jdbTextField211, new XYConstraints(96, 273, 292, -1));
    tableScrollPane4.getViewport().add(jdbTable4, null);
    jTabbedPane1.add(jPanel5,   "培訓(xùn)經(jīng)歷");
    jPanel5.add(tableScrollPane5,  new XYConstraints(9, 13, 397, 187));
    tableScrollPane5.getViewport().add(jdbTable5, null);
    jPanel5.add(jdbTextField215, new XYConstraints(100, 247, 93, -1));
    jPanel5.add(jLabel216, new XYConstraints(28, 217, -1, -1));
    jPanel5.add(jdbTextField219, new XYConstraints(100, 216, 93, -1));
    jPanel5.add(jLabel215, new XYConstraints(213, 217, -1, -1));
    jPanel5.add(jdbTextField217, new XYConstraints(290, 216, 102, -1));
    jPanel5.add(jLabel219, new XYConstraints(28, 248, -1, -1));
    jPanel5.add(jLabel217, new XYConstraints(213, 248, -1, -1));
    jPanel5.add(jdbTextField218, new XYConstraints(290, 247, 102, -1));
    jPanel5.add(jLabel218, new XYConstraints(28, 279, -1, -1));
    jPanel5.add(jdbTextField216,     new XYConstraints(100, 278, 93, -1));
    jPanel5.add(jLabel2110,  new XYConstraints(213, 279, -1, -1));
    jPanel5.add(jdbTextField2110,  new XYConstraints(290, 278, 102, -1));
  }
  void otherRefresh(){
    if(jTabbedPane1.getSelectedIndex()<=0){
      return;
    }
    String sid;
    if(queryDataSet1.getRowCount()==0)
      sid="";
    else
      sid=queryDataSet1.getString("stano");
    switch(jTabbedPane1.getSelectedIndex()){
      //case 0:
      case 1:
        try{
          if (queryDataSet2.isOpen()) queryDataSet2.close();
          String sql = "select * from history where sid = \'"+sid+ "\'";

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

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