base_dialog.java

包含了7个java经典案例

    column15.setTableName("baseinfo");
    column15.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column15.setServerColumnName("recno");
    column15.setSqlType(12);
    column16.setColumnName("politics");
    column16.setDataType(com.borland.dx.dataset.Variant.STRING);
    column16.setPrecision(12);
    column16.setTableName("baseinfo");
    column16.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column16.setServerColumnName("politics");
    column16.setSqlType(12);
    column17.setColumnName("slevel");
    column17.setDataType(com.borland.dx.dataset.Variant.STRING);
    column17.setPrecision(18);
    column17.setTableName("baseinfo");
    column17.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column17.setServerColumnName("slevel");
    column17.setSqlType(12);
    column18.setColumnName("married");
    column18.setDataType(com.borland.dx.dataset.Variant.STRING);
    column18.setPrecision(8);
    column18.setTableName("baseinfo");
    column18.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column18.setServerColumnName("married");
    column18.setSqlType(12);
    column19.setColumnName("indate");
    column19.setDataType(com.borland.dx.dataset.Variant.STRING);
    column19.setPrecision(18);
    column19.setTableName("baseinfo");
    column19.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column19.setServerColumnName("indate");
    column19.setSqlType(12);
    column20.setColumnName("body");
    column20.setDataType(com.borland.dx.dataset.Variant.STRING);
    column20.setPrecision(8);
    column20.setTableName("baseinfo");
    column20.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column20.setServerColumnName("body");
    column20.setSqlType(12);
    column21.setColumnName("baryear");
    column21.setDataType(com.borland.dx.dataset.Variant.STRING);
    column21.setPrecision(8);
    column21.setTableName("baseinfo");
    column21.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column21.setServerColumnName("baryear");
    column21.setSqlType(12);
    column22.setColumnName("barstart");
    column22.setDataType(com.borland.dx.dataset.Variant.STRING);
    column22.setPrecision(18);
    column22.setTableName("baseinfo");
    column22.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column22.setServerColumnName("barstart");
    column22.setSqlType(12);
    column23.setColumnName("barend");
    column23.setDataType(com.borland.dx.dataset.Variant.STRING);
    column23.setPrecision(18);
    column23.setTableName("baseinfo");
    column23.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column23.setServerColumnName("barend");
    column23.setSqlType(12);
    column24.setColumnName("pcode");
    column24.setDataType(com.borland.dx.dataset.Variant.STRING);
    column24.setPrecision(8);
    column24.setTableName("baseinfo");
    column24.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column24.setServerColumnName("pcode");
    column24.setSqlType(12);
    column25.setColumnName("address");
    column25.setDataType(com.borland.dx.dataset.Variant.STRING);
    column25.setPrecision(64);
    column25.setTableName("baseinfo");
    column25.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column25.setServerColumnName("address");
    column25.setSqlType(12);
    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
    jdbTable1.setDataSet(queryDataSet1);
    jdbTable1.addMouseListener(new Base_Dialog_jdbTable1_mouseAdapter(this));
    column26.setColumnName("brief");
    column26.setDataType(com.borland.dx.dataset.Variant.STRING);
    column26.setSearchable(false);
    column26.setTableName("baseinfo");
    column26.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column26.setServerColumnName("brief");
    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6, column7, column8, column9, column10, column11, column12,
        column13, column14, column15, column16, column17, column18, column19, column20, column21, column22, column23, column24, column25, column26});
    queryDataSet1.addDataChangeListener(new Base_Dialog_queryDataSet1_dataChangeAdapter(this));
    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel1.setText("员工号：");
    jdbTextField2.setText("");
    jdbTextField2.setColumnName("cardno");
    jdbTextField2.setDataSet(queryDataSet1);
    jLabel2.setText("身份证号：");
    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel3.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel3.setText("档案编号：");
    jdbTextField3.setText("");
    jdbTextField3.setColumnName("recno");
    jdbTextField3.setDataSet(queryDataSet1);
    jLabel4.setText("姓名：");
    jLabel4.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel5.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel5.setText("政治面貌：");
    jdbTextField5.setText("");
    jdbTextField5.setColumnName("politics");
    jdbTextField5.setDataSet(queryDataSet1);
    jLabel6.setText("性别：");
    jLabel6.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel7.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel7.setText("健康状况：");
    jdbTextField7.setText("");
    jdbTextField7.setColumnName("body");
    jdbTextField7.setDataSet(queryDataSet1);
    jLabel8.setText("生日：");
    jLabel8.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel9.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel9.setText("婚姻状况：");
    jdbTextField9.setText("");
    jdbTextField9.setColumnName("married");
    jdbTextField9.setDataSet(queryDataSet1);
    jLabel10.setText("部门：");
    jLabel10.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel10.setRequestFocusEnabled(true);
    jdbTextField11.setText("");
    jdbTextField11.setColumnName("indate");
    jdbTextField11.setDataSet(queryDataSet1);
    jLabel11.setText("入司时间：");
    jLabel11.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel12.setRequestFocusEnabled(true);
    jLabel12.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel12.setText("职称：");
    jdbTextField13.setText("");
    jdbTextField13.setColumnName("baryear");
    jdbTextField13.setDataSet(queryDataSet1);
    jLabel13.setText("合同期限：");
    jLabel13.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel14.setRequestFocusEnabled(true);
    jLabel14.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel14.setText("民族：");
    jdbTextField15.setText("");
    jdbTextField15.setColumnName("barstart");
    jdbTextField15.setDataSet(queryDataSet1);
    jLabel15.setText("合同开始：");
    jLabel15.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel16.setRequestFocusEnabled(true);
    jLabel16.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel16.setText("学历：");
    jdbTextField17.setText("");
    jdbTextField17.setColumnName("barend");
    jdbTextField17.setDataSet(queryDataSet1);
    jLabel17.setText("合同结束：");
    jLabel17.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel18.setRequestFocusEnabled(true);
    jLabel18.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel18.setText("专业：");
    jdbTextField19.setText("");
    jdbTextField19.setColumnName("brief");
    jdbTextField19.setDataSet(queryDataSet1);
    jLabel19.setText("备注：");
    jLabel19.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel110.setRequestFocusEnabled(true);
    jLabel110.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel110.setText("住址：");
    jdbTextField1.setColumnName("stano");
    jdbTextField1.setDataSet(queryDataSet1);
    jdbTextField4.setColumnName("name");
    jdbTextField4.setDataSet(queryDataSet1);
    jdbTextField6.setColumnName("sex");
    jdbTextField6.setDataSet(queryDataSet1);
    jdbTextField8.setColumnName("birth");
    jdbTextField8.setDataSet(queryDataSet1);
    jdbTextField10.setColumnName("dep");
    jdbTextField10.setDataSet(queryDataSet1);
    jdbTextField12.setColumnName("duty");
    jdbTextField12.setDataSet(queryDataSet1);
    jdbTextField14.setColumnName("folk");
    jdbTextField14.setDataSet(queryDataSet1);
    jdbTextField16.setColumnName("level");
    jdbTextField16.setDataSet(queryDataSet1);
    jdbTextField18.setColumnName("special");
    jdbTextField18.setDataSet(queryDataSet1);
    jdbTextField110.setColumnName("address");
    jdbTextField110.setDataSet(queryDataSet1);
    jPanel1.setLayout(xYLayout4);
    jLabel20.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel20.setText("开始时间：");
    jLabel21.setText("结束时间：");
    jLabel21.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbTextField20.setText("");
    jdbTextField20.setColumnName("sdate");
    jdbTextField20.setDataSet(queryDataSet2);
    jLabel22.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel22.setText("所在部门：");
    jLabel23.setText("所在公司：");
    jLabel23.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbTextField23.setText("");
    jdbTextField23.setColumnName("company");
    jdbTextField23.setDataSet(queryDataSet2);
    jLabel25.setText("从事工作：");
    jLabel25.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbTextField25.setText("");
    jdbTextField25.setColumnName("duty");
    jdbTextField25.setDataSet(queryDataSet2);
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from history;", null, true, Load.ALL));
    column27.setColumnName("id");
    column27.setDataType(com.borland.dx.dataset.Variant.INT);
    column27.setRowId(true);
    column27.setTableName("history");
    column27.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column27.setWidth(10);
    column27.setServerColumnName("id");
    column27.setSqlType(4);
    column28.setCaption("员工号");
    column28.setColumnName("sid");
    column28.setDataType(com.borland.dx.dataset.Variant.STRING);
    column28.setPrecision(16);
    column28.setTableName("history");
    column28.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column28.setWidth(10);
    column28.setServerColumnName("sid");
    column28.setSqlType(12);
    column29.setCaption("开始时间");
    column29.setColumnName("sdate");
    column29.setDataType(com.borland.dx.dataset.Variant.STRING);
    column29.setPrecision(32);
    column29.setTableName("history");
    column29.setWidth(10);
    column29.setServerColumnName("sdate");
    column29.setSqlType(12);
    column30.setCaption("结束时间");
    column30.setColumnName("edate");
    column30.setDataType(com.borland.dx.dataset.Variant.STRING);
    column30.setPrecision(32);
    column30.setTableName("history");
    column30.setWidth(10);
    column30.setServerColumnName("edate");
    column30.setSqlType(12);
    column31.setCaption("单位");
    column31.setColumnName("company");
    column31.setDataType(com.borland.dx.dataset.Variant.STRING);
    column31.setPrecision(32);
    column31.setTableName("history");
    column31.setWidth(10);
    column31.setServerColumnName("company");
    column31.setSqlType(12);
    jdbTable2.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
    jdbTable2.setDataSet(queryDataSet2);
    column32.setCaption("部门");
    column32.setColumnName("dep");
    column32.setDataType(com.borland.dx.dataset.Variant.STRING);
    column32.setPrecision(32);
    column32.setTableName("history");
    column32.setWidth(10);
    column32.setServerColumnName("dep");
    column32.setSqlType(12);
    column33.setCaption("职务");
    column33.setColumnName("duty");
    column33.setDataType(com.borland.dx.dataset.Variant.STRING);
    column33.setPrecision(32);
    column33.setTableName("history");
    column33.setWidth(10);
    column33.setServerColumnName("duty");
    column33.setSqlType(12);
    queryDataSet2.setColumns(new Column[] {column27, column28, column29, column30, column31, column32, column33});
    jPanel3.setLayout(xYLayout5);
    jPanel4.setLayout(xYLayout6);
    jPanel5.setLayout(xYLayout7);
    jdbTextField24.setText("");
    jdbTextField24.setColumnName("tel");
    jdbTextField24.setDataSet(queryDataSet3);
    jLabel24.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel24.setText("关系：");
    jdbTextField26.setText("");
    jdbTextField26.setColumnName("brief");
    jdbTextField26.setDataSet(queryDataSet3);
    jLabel26.setText("姓名：");
    jLabel26.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel27.setText("单位：");
    jLabel27.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel28.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel28.setText("备注：");
    jLabel29.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel29.setText("电话：");
    jdbTextField29.setText("");
    jdbTextField29.setColumnName("name");
    jdbTextField29.setDataSet(queryDataSet3);
    jdbTextField210.setText("");
    jdbTextField210.setColumnName("dep");
    jdbTextField210.setDataSet(queryDataSet4);
    jLabel210.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel210.setText("事件：");
    jdbTextField211.setText("");
    jdbTextField211.setColumnName("des");
    jdbTextField211.setDataSet(queryDataSet4);
    jLabel211.setText("奖惩类型：");
    jLabel211.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel212.setText("处理时间：");
    jLabel212.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel213.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel213.setText("处理结果：");
    jLabel214.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel214.setText("处理部门：");
    jdbTextField214.setText("");
    jdbTextField214.setColumnName("sort");
    jdbTextField214.setDataSet(queryDataSet4);
    jdbTextField215.setText("");
    jdbTextField215.setColumnName("sdate");
    jdbTextField215.setDataSet(queryDataSet5);
    jLabel215.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel215.setText("培训期限：");
    jdbTextField216.setText("");
    jdbTextField216.setColumnName("trcom");
    jdbTextField216.setDataSet(queryDataSet5);
    jLabel216.setText("培训课程：");
    jLabel216.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel217.setText("结束时间：");
    jLabel217.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel218.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel218.setText("培训单位：");
    jLabel219.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel219.setText("开始时间：");
    jdbTextField219.setText("");
    jdbTextField219.setColumnName("course");
    jdbTextField219.setDataSet(queryDataSet5);
    jLabel2110.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel2110.setText("获得证书：");
    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from family", null, true, Load.ALL));
    column34.setColumnName("id");
    column34.setDataType(com.borland.dx.dataset.Variant.INT);
    column34.setRowId(true);
    column34.setTableName("family");
    column34.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column34.setServerColumnName("id");
    column34.setSqlType(4);
    column35.setCaption("员工号");
    column35.setColumnName("sid");
    column35.setDataType(com.borland.dx.dataset.Variant.STRING);
    column35.setPrecision(16);