📄 empondutyquery.java~66~
字号:
jPanel7.add(jRadioButton10, new XYConstraints(1, 2, -1, -1));
jPanel7.add(jComboBox2, new XYConstraints(72, 3, 84, -1));
this.getContentPane().add(jPanel6, new XYConstraints(215, 196, 164, 35));
this.getContentPane().add(jPanel5, new XYConstraints(215, 157, 244, 36));
this.getContentPane().add(jScrollPane1,
new XYConstraints(2, 3, 457, 152));
this.getContentPane().add(jPanel3, new XYConstraints(383, 196, 76, 73));
buttonGroup1.add(jRadioButton8);//
buttonGroup1.add(jRadioButton15); //按员工ID
buttonGroup1.add(jRadioButton17); //按姓名查询
buttonGroup1.add(jRadioButton9); //按部门
buttonGroup1.add(jRadioButton10); //按职务
buttonGroup2.add(jRadioButton1); //1
buttonGroup2.add(jRadioButton2); //2
buttonGroup2.add(jRadioButton3); //3
buttonGroup2.add(jRadioButton4); //4
buttonGroup2.add(jRadioButton5); //5
buttonGroup2.add(jRadioButton6); //6
buttonGroup2.add(jRadioButton7); //7
jTextField1.setEnabled(false); //按员工ID
jTextField2.setEnabled(false); //按姓名查询
jComboBox1.setEnabled(false); //按部门
jComboBox1.addItem(" ");
jComboBox1.addItem("服务部");
jComboBox1.addItem("客房部");
jComboBox2.setEnabled(false); //按职务
jComboBox2.addItem(" ");
jComboBox2.addItem("经理");
jComboBox2.addItem("前台");
jComboBox2.addItem("服务员");
}
public void jButton1_actionPerformed(ActionEvent e) { //查询
if (jRadioButton8.isSelected()) {
if (buttonGroup2.getSelection() == jRadioButton1.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Mon as 星期一上午为1下午为9 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Mon < > '0'; ");
return;
}
if (buttonGroup2.getSelection() == jRadioButton2.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Tues as 星期二上午为1下午为9 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Tues < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton3.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Wed as 星期三上午为1下午为9 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Wed < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton4.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Thurs as 星期四上午为1下午为9 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Thurs < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton5.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Fri as 星期五上午为1下午为9 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Fri < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton6.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Sat as 星期六上午为1下午为9 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Sat < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton7.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Sun as 星期日上午为1下午为9 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Sun < > '0';");
return;
}
}
if (buttonGroup1.getSelection() == jRadioButton15.getModel()) { //按员工ID
String strOnEmpID = jTextField1.getText();
if (buttonGroup2.getSelection() == jRadioButton1.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Mon as 星期一上午为1下午为9 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_Employee.EmpID = '" +
strOnEmpID +
"' AND HIMS_OnDuty_Date.Mon < > '0'; ");
return;
}
if (buttonGroup2.getSelection() == jRadioButton2.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Tues as 星期二上午为2下午为10 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_Employee.EmpID = '" +
strOnEmpID +
"' AND HIMS_OnDuty_Date.Tues < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton3.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Wed as 星期三上午为3下午为11 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_Employee.EmpID = '" +
strOnEmpID +
"' AND HIMS_OnDuty_Date.Wed < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton4.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Thurs as 星期四上午为4下午为12 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_Employee.EmpID = '" +
strOnEmpID +
"' AND HIMS_OnDuty_Date.Thurs < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton5.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Fri as 星期五上午为5下午为13 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_Employee.EmpID = '" +
strOnEmpID +
"' AND HIMS_OnDuty_Date.Fri < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton6.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Sat as 星期六上午为6下午为14 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_Employee.EmpID = '" +
strOnEmpID +
"' AND HIMS_OnDuty_Date.Sat < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton7.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Sun as 星期日上午为7下午为8 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_Employee.EmpID = '" +
strOnEmpID +
"' AND HIMS_OnDuty_Date.Sun < > '0';");
return;
}
}
//-------------------------------------------------------------------------------------------
if (buttonGroup1.getSelection() == jRadioButton17.getModel()) { //按姓名查询
String strOnName = jTextField2.getText();
if (buttonGroup2.getSelection() == jRadioButton1.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Mon as 星期一上午为1下午为9 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Mon < > '0' AND HIMS_Employee.Name like '%" +
strOnName + "%'; ");
return;
} else if (buttonGroup2.getSelection() == jRadioButton2.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Tues as 星期二上午为2下午为10 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Tues < > '0' AND HIMS_Employee.Name like '%" +
strOnName + "%';");
return;
} else if (buttonGroup2.getSelection() == jRadioButton3.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Wed as 星期三上午为3下午为11 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Wed < > '0'AND HIMS_Employee.Name like '%" +
strOnName + "%';");
return;
} else if (buttonGroup2.getSelection() == jRadioButton4.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Thurs as 星期四上午为4下午为12 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Thurs < > '0' AND HIMS_Employee.Name like '%" +
strOnName + "%';");
return;
} else if (buttonGroup2.getSelection() == jRadioButton5.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Fri as 星期五上午为5下午为13 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Fri < > '0' AND HIMS_Employee.Name like '%" +
strOnName + "%';");
return;
} else if (buttonGroup2.getSelection() == jRadioButton6.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Sat as 星期六上午为6下午为14 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Sat < > '0' AND HIMS_Employee.Name like '%" +
strOnName +
"%';");
return;
} else if (buttonGroup2.getSelection() == jRadioButton7.getModel()) {
table.fetch("Select HIMS_Employee.EmpID as 员工ID, Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注,Sun as 星期日上午为7下午为8 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Sun < > '0' AND HIMS_Employee.Name like '%" +
strOnName +
"%';");
return;
}
}
//-------------------------------------------------------------------------------------------
if (buttonGroup1.getSelection() == jRadioButton9.getModel()) { //按部门查询
String strDepartment = null;
try {
strDepartment = jComboBox1.getSelectedItem().toString();
} catch (Exception ex) {
strDepartment = "";
}
if (buttonGroup2.getSelection() == jRadioButton1.getModel()) {
table.fetch("Select Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Mon < > '0'; ");
return;
}
if (buttonGroup2.getSelection() == jRadioButton2.getModel()) {
table.fetch("Select Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Tues < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton3.getModel()) {
table.fetch("Select Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Wed < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton4.getModel()) {
table.fetch("Select Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Thurs < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton5.getModel()) {
table.fetch("Select Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Fri < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton6.getModel()) {
table.fetch("Select Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID AND HIMS_OnDuty_Date.Sat < > '0';");
return;
}
if (buttonGroup2.getSelection() == jRadioButton7.getModel()) {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -