📄 empondutyrec.java
字号:
jPanel10.add(jCBThPm, new XYConstraints(102, 42, -1, -1));
jPanel10.add(jCBFrPm, new XYConstraints(126, 42, -1, -1));
jPanel10.add(jCBSaPm, new XYConstraints(148, 42, -1, -1));
jPanel10.add(jCBWeAm, new XYConstraints(75, 4, -1, -1));
jPanel10.add(jCBThAm, new XYConstraints(102, 4, -1, -1));
jPanel10.add(jCBFrAm, new XYConstraints(126, 4, -1, -1));
jPanel10.add(jCBSaAm, new XYConstraints(148, 4, -1, -1));
jPEmpOnDutyInfo02.add(jLFloorNo, new XYConstraints(5, 6, -1, -1));
jPEmpOnDutyInfo04.add(jScrollPane2, new XYConstraints(6, 25, 209, 160));
jScrollPane2.getViewport().add(jTARemark);
jPEmpOnDutyInfo02.add(jTFFloorNo, new XYConstraints(83, 6, 111, -1));
jPEmpOnDutyInfo02.add(jTFPhone, new XYConstraints(83, 161, 111, -1));
jPEmpOnDutyInfo02.add(jLPhone, new XYConstraints(5, 162, -1, -1));
jPEmpOnDutyInfo02.add(jLProceeding, new XYConstraints(5, 37, -1, -1));
jPEmpOnDutyInfo02.add(jScrollPane1, new XYConstraints(83, 32, 111, 115));
jScrollPane1.getViewport().add(jTAProceeding);
jPEdit.add(jBEdit, new XYConstraints(5, 3, 80, 28));
jPEdit.add(jBEditFinish, new XYConstraints(5, 39, 80, 28));
this.getContentPane().add(jPQuit, new XYConstraints(444, 287, 93, 36));
jPQuit.add(jBQuit, new XYConstraints(3, 3, 80, 25));
this.getContentPane().add(jPEdit, new XYConstraints(444, 131, 93, 73));
jPEmpQueryID.add(jBEmpQuery, new XYConstraints(5, 83, 80, 28));
jPEmpQueryID.add(jTFEmpQuery, new XYConstraints(5, 41, 80, 22));
jPEmpQueryID.add(jLQuery, new XYConstraints(18, 9, -1, 23));
this.getContentPane().add(jPEmpQueryID,
new XYConstraints(444, 7, 93, 122));
SetFormCenter wcenter = new SetFormCenter();
wcenter.setcenter(this);
}
public void jBQuit_actionPerformed(ActionEvent e) { //退出
this.setVisible(false);
}
public void jBOnDutySet_actionPerformed(ActionEvent e) { //设置工作日
jCBSuAm.setEnabled(true);
jCBSuPm.setEnabled(true);
jCBMoAm.setEnabled(true);
jCBMoPm.setEnabled(true);
jCBTuAm.setEnabled(true);
jCBTuPm.setEnabled(true);
jCBWeAm.setEnabled(true);
jCBWePm.setEnabled(true);
jCBThAm.setEnabled(true);
jCBThPm.setEnabled(true);
jCBFrAm.setEnabled(true);
jCBFrPm.setEnabled(true);
jCBSaAm.setEnabled(true);
jCBSaPm.setEnabled(true);
}
public void jBEdit_actionPerformed(ActionEvent e) { //修改
jTFEmpQuery.setEnabled(false);
jBEmpQuery.setEnabled(false);
jBOnDutySet.setEnabled(true);
jTFFloorNo.setEnabled(true);
jTFPhone.setEnabled(true);
jTAProceeding.setEnabled(true);
jTARemark.setEnabled(true);
jBEditFinish.setEnabled(true);
jBEdit.setEnabled(false);
}
public void jBEditFinish_actionPerformed(ActionEvent e) { //修改完成
String strFloorNo = jTFFloorNo.getText(); //负责楼层
if (!judgeval.IsNumberAndLetter(strFloorNo)) {
JOptionPane.showMessageDialog(null,
"负责楼层需是数字或字母，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFFloorNo.setText("");
return;
}
if (strFloorNo.length() > 4) {
JOptionPane.showMessageDialog(null,
"负责楼层不能超过4个字符，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFFloorNo.setText("");
return;
}
String strProceeding = jTAProceeding.getText(); //负责事项
if (strProceeding.length() > 60) {
JOptionPane.showMessageDialog(null,
"负责楼层不能超过30个汉字，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTAProceeding.setText("");
return;
}
String strEmpPhone = jTFPhone.getText();
if (!judgeval.isFigure(strEmpPhone)) {
JOptionPane.showMessageDialog(null,
"联系电话必须是数字，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFPhone.setText("");
return;
}
if (strEmpPhone.length() > 8) {
JOptionPane.showMessageDialog(null,
"联系电话不能超过8个数字，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFPhone.setText("");
return;
}
String strEmpRemark = jTARemark.getText(); //备注
if (strProceeding.length() > 500) {
JOptionPane.showMessageDialog(null,
"不能超过250个汉字，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTARemark.setText("");
return;
}
String strMon = null;
String strTues = null;
String strWed = null;
String strThurs = null;
String strFri = null;
String strSat = null;
String strSun = null;
if (jCBSuAm.isSelected() && jCBSuPm.isSelected()) { //星期日
JOptionPane.showMessageDialog(null,
"星期天上下午不能同时选中两个，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jCBSuAm.setSelected(false);
jCBSuPm.setSelected(false);
return;
} else if (jCBSuAm.isSelected()) { //选中状态
strSun = "1";
} else if (jCBSuPm.isSelected()) { //选中状态
strSun = "8";
} else {
strSun = "0";
}
if (jCBMoAm.isSelected() && jCBMoPm.isSelected()) { //星期一
JOptionPane.showMessageDialog(null,
"星期一上下午不能同时选中两个，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jCBMoAm.setSelected(false);
jCBMoPm.setSelected(false);
return;
} else if (jCBMoAm.isSelected()) { //选中状态
strMon = "2";
} else if (jCBMoPm.isSelected()) { //选中状态
strMon = "9";
} else {
strMon = "0";
}
if (jCBTuAm.isSelected() && jCBTuPm.isSelected()) { //星期二
JOptionPane.showMessageDialog(null,
"星期二上下午不能同时选中两个，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jCBTuAm.setSelected(false);
jCBTuPm.setSelected(false);
return;
} else if (jCBTuAm.isSelected()) { //选中状态
strTues = "3";
} else if (jCBTuPm.isSelected()) { //选中状态
strTues = "10";
} else {
strTues = "0";
}
if (jCBWeAm.isSelected() && jCBWePm.isSelected()) { //星期三
JOptionPane.showMessageDialog(null,
"星期三上下午不能同时选中两个，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jCBWeAm.setSelected(false);
jCBWePm.setSelected(false);
return;
} else if (jCBWeAm.isSelected()) { //选中状态
strWed = "4";
} else if (jCBWePm.isSelected()) { //选中状态
strWed = "11";
} else {
strWed = "0";
}
if (jCBThAm.isSelected() && jCBThPm.isSelected()) { //星期四
JOptionPane.showMessageDialog(null,
"星期四上下午不能同时选中两个，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jCBThAm.setSelected(false);
jCBThPm.setSelected(false);
return;
} else if (jCBThAm.isSelected()) { //选中状态
strThurs = "5";
} else if (jCBThPm.isSelected()) { //选中状态
strThurs = "12";
} else {
strThurs = "0";
}
if (jCBFrAm.isSelected() && jCBFrPm.isSelected()) { //星期五
JOptionPane.showMessageDialog(null,
"星期五上下午不能同时选中两个，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jCBFrAm.setSelected(false);
jCBFrPm.setSelected(false);
return;
} else if (jCBFrAm.isSelected()) { //选中状态
strFri = "6";
} else if (jCBFrPm.isSelected()) { //选中状态
strFri = "13";
} else {
strFri = "0";
}
if (jCBSaAm.isSelected() && jCBSaPm.isSelected()) { //星期六
JOptionPane.showMessageDialog(null,
"星期六上下午不能同时选中两个，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jCBSaAm.setSelected(false);
jCBSaPm.setSelected(false);
return;
} else if (jCBSaAm.isSelected()) { //选中状态
strSat = "7";
} else if (jCBSaPm.isSelected()) { //选中状态
strSat = "14";
} else {
strSat = "0";
}
//-------------------------------------------------------------------------
try {
Connect1 = new DataConnect();
Connect2 = new DataConnect();
Connect1.con1 = DriverManager.getConnection(Connect1.url); //建立连接
Connect2.con2 = DriverManager.getConnection(Connect2.url); //建立连接
Connect1.stmt1 = Connect1.con1.createStatement(); //创建语句
Connect2.stmt2 = Connect2.con2.createStatement(); //创建语句
Connect1.sql1 = " UPDATE HIMS_OnDuty SET EmpID = '" + strEmpuserID +
"' , FloorNo = '" + strFloorNo +
"', Proceeding = '" + strProceeding +
"', EmpPhone= '" +
strEmpPhone + "', EmpRemark = '" + strEmpRemark +
"' where EmpID = '" + strEmpuserID +
"'";
Connect2.sql2 = " UPDATE HIMS_OnDuty_Date SET EmpID = '" +
strEmpuserID +
"', Mon = '" + strMon + "', Tues= '" +
strTues + "', Wed = '"
+ strWed + "', Thurs = '" + strThurs +
"', Fri= '" + strFri + "', Sat = '"
+ strSat + "', Sun = '" + strSun +
"' where EmpID = '" + strEmpuserID +
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -