📄 empondutyrec.java~24~
字号:
this.getContentPane().add(jPEmpOnDutyInfo02,
new XYConstraints(5, 131, 206, 192));
this.getContentPane().add(jPEmpOnDutyInfo01,
new XYConstraints(5, 7, 206, 122));
jPanel10.add(jCBMoAm, new XYConstraints(24, 4, -1, -1));
jPEmpOnDutyInfo03.add(jLMo, new XYConstraints(74, 26, -1, -1));
jPEmpOnDutyInfo03.add(jLFr, new XYConstraints(177, 26, -1, -1));
jPEmpOnDutyInfo03.add(jLTh, new XYConstraints(152, 26, -1, -1));
jPEmpOnDutyInfo03.add(jLWe, new XYConstraints(126, 26, -1, -1));
jPanel10.add(jCBTuAm, new XYConstraints(51, 4, -1, -1));
jPanel10.add(jCBSuPm, new XYConstraints(2, 42, -1, -1));
jPanel10.add(jCBMoPm, new XYConstraints(24, 42, -1, -1));
jPanel10.add(jCBTuPm, new XYConstraints(51, 42, -1, -1));
jPanel10.add(jCBWePm, new XYConstraints(75, 42, -1, -1));
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 (!judgeval.IsChineseCharacters(strProceeding)) {
JOptionPane.showMessageDialog(null,
"负责事项需是汉字，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTAProceeding.setText("");
return;
}
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()) { //选中状态
strSun = "1";
} else if (jCBSuPm.isSelected()) { //选中状态
strSun = "8";
} else if(jCBSuAm.isSelected() && jCBSuPm.isSelected()){
JOptionPane.showMessageDialog(null,
"不能同时选中两个，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
return;
} else {
strSun = "0";
}
if (jCBMoAm.isSelected()) { //选中状态
strMon = "2";
} else if (jCBMoPm.isSelected()) { //选中状态
strMon = "9";
} else {
strMon = "0";
}
if (jCBTuAm.isSelected()) { //选中状态
strTues = "3";
} else if (jCBTuPm.isSelected()) { //选中状态
strTues = "10";
} else {
strTues = "0";
}
if (jCBWeAm.isSelected()) { //选中状态
strWed = "4";
} else if (jCBWePm.isSelected()) { //选中状态
strWed = "11";
} else {
strWed = "0";
}
if (jCBThAm.isSelected()) { //选中状态
strThurs = "5";
} else if (jCBThPm.isSelected()) { //选中状态
strThurs = "12";
} else {
strThurs = "0";
}
if (jCBFrAm.isSelected()) { //选中状态
strFri = "6";
} else if (jCBFrPm.isSelected()) { //选中状态
strFri = "13";
} else {
strFri = "0";
}
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 +
"'";
Connect1.stmt1.executeUpdate(Connect1.sql1);
Connect2.stmt2.executeUpdate(Connect2.sql2);
JOptionPane.showMessageDialog(this, "修改成功！", "酒店信息管理系统提示",
JOptionPane.INFORMATION_MESSAGE);
jTFEmpQuery.setEnabled(true);
jBEmpQuery.setEnabled(true);
jTFFloorNo.setEnabled(false);
jTFPhone.setEnabled(false);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -