📄 empondutyrec.java~21~
字号:
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.IsNumberAndLetter(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";
jCBSuPm.setEnabled(false);
} else if (jCBSuPm.isSelected()) { //选中状态
strSun = "8";
jCBSuAm.setEnabled(false);
} 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);
jTAProceeding.setEnabled(false);
jTARemark.setEnabled(false);
jBEdit.setEnabled(false);
jBEditFinish.setEnabled(false);
jBOnDutySet.setEnabled(false);
jCBSuAm.setEnabled(false);
jCBSuPm.setEnabled(false);
jCBMoAm.setEnabled(false);
jCBMoPm.setEnabled(false);
jCBTuAm.setEnabled(false);
jCBTuPm.setEnabled(false);
jCBWeAm.setEnabled(false);
jCBWePm.setEnabled(false);
jCBThAm.setEnabled(false);
jCBThPm.setEnabled(false);
jCBFrAm.setEnabled(false);
jCBFrPm.setEnabled(false);
jCBSaAm.setEnabled(false);
jCBSaPm.setEnabled(false);
} catch (SQLException ex) {
ex.printStackTrace();
} finally {
try {
if (Connect1.con1 != null && Connect2.con2 != null) {
Connect1.con1.close(); //关闭数据库
Connect2.con2.close(); //关闭数据库
Connect1.stmt1.close();
Connect2.stmt2.close();
} //if
} catch (SQLException ex) {
System.out.println(ex);
} //catch
} //finally
}
}
class EmpOnDutyRec_jBEditFinish_actionAdapter implements ActionListener {
private EmpOnDutyRec adaptee;
EmpOnDutyRec_jBEditFinish_actionAdapter(EmpOnDutyRec adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBEditFinish_actionPerformed(e);
}
}
class EmpOnDutyRec_jBEdit_actionAdapter implements ActionListener {
private EmpOnDutyRec adaptee;
EmpOnDutyRec_jBEdit_actionAdapter(EmpOnDutyRec adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBEdit_actionPerformed(e);
}
}
class EmpOnDutyRec_jBOnDutySet_actionAdapter implements ActionListener {
private EmpOnDutyRec adaptee;
EmpOnDutyRec_jBOnDutySet_actionAdapter(EmpOnDutyRec adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBOnDutySet_actionPerformed(e);
}
}
class EmpOnDutyRec_jBQuit_actionAdapter implements ActionListener {
private EmpOnDutyRec adaptee;
EmpOnDutyRec_jBQuit_actionAdapter(EmpOnDutyRec adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBQuit_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -