?? base_dialog.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);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -