📄 base_dialog.java
字号:
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("关系");
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("处理时间");
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("奖惩类型");
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("处理结果");
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("培训课程");
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("培训期限");
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("开始日期");
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("结束日期");
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("培训单位");
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, "工作经历");
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, "奖惩记录");
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, "培训经历");
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());}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -