📄 roominfosetting.java
字号:
jTFGetRoomID.setText("");
return;
}
if (!judgeval.IsNumberAndLetter(strRoomifID)) {
JOptionPane.showMessageDialog(null,
"客房ID只能用字母或数字表示，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFGetRoomID.setText("");
return;
}
if (strRoomifID.length() != 4) {
JOptionPane.showMessageDialog(null,
"客房ID要为4位，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFGetRoomID.setText("");
return;
}
try {
//-----------------------------------------------------------------------------------------------------
Connect1.Connnect(); //装入驱动
Connect1.con1 = DriverManager.getConnection(Connect1.url); //建立连接
Connect1.stmt1 = Connect1.con1.createStatement(); //创建语句
Connect1.sql1 = "SELECT * FROM HIMS_RoomInfo";
rs1l = Connect1.stmt1.executeQuery(Connect1.sql1);
//-----------------------------------------------------------------------------------------------------
while (rs1l.next()) {
String strRoomID = rs1l.getString("RoomID");
if (strRoomID.equals(strRoomifID)) {
JOptionPane.showMessageDialog(null, "您所输入的ID已存在！", "系统警告",
JOptionPane.WARNING_MESSAGE);
jTFGetRoomID.setText("");
return;
}
} //while
JOptionPane.showMessageDialog(null, "您所输入的ID可以使用！", "系统提示",
JOptionPane.WARNING_MESSAGE);
jBNewBuildFinish.setEnabled(true);
jBValRoomID.setEnabled(false);
jTFGetRoomID.setText(strRoomifID);
jTFGetRoomID.setEnabled(false);
jTFStandardPri.setEnabled(true);
jTFRebatePri.setEnabled(true);
jTFRoomArea.setEnabled(true);
jTFBedNo.setEnabled(true);
jCBRoomClass.setEnabled(true);
jTAPlace.setEnabled(true);
jTARoomIntro.setEnabled(true);
jTARemark.setEnabled(true);
} catch (SQLException ex) {
ex.printStackTrace();
} finally {
try {
if (Connect1.con1 != null) {
Connect1.con1.close(); //关闭数据库admin
Connect1.stmt1.close();
} //if
} catch (SQLException ex) {
System.out.println(ex);
} //catch
} //finally
}
public void jBNewBuildFinish_actionPerformed(ActionEvent e) { //新建完成
String strRoomID = jTFGetRoomID.getText();
String strClass = jCBRoomClass.getSelectedItem().toString();
if (strClass.equals(" ")) {
JOptionPane.showMessageDialog(null,
"客房类型不能为空，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
return;
}
String strRoomArea = jTFRoomArea.getText();
if (!judgeval.IsNumberAndLetter(strRoomArea)) {
JOptionPane.showMessageDialog(null,
"客房面积需由数字和字母组成，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFRoomArea.setText("");
return;
}
String strBedNo = jTFBedNo.getText();
if (!judgeval.isFigure(strBedNo)) {
JOptionPane.showMessageDialog(null,
"房位数必须是数字，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFBedNo.setText("");
return;
}
if (strBedNo.length() > 4) {
JOptionPane.showMessageDialog(null,
"房位数不能超过四位，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFBedNo.setText("");
return;
}
String strStandardPri = jTFStandardPri.getText();
if (!judgeval.isFigureWhitPoint(strStandardPri)) {
JOptionPane.showMessageDialog(null,
"标准价必须是数字或格式不标准，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFStandardPri.setText("");
return;
}
if (strStandardPri.equals("")) {
JOptionPane.showMessageDialog(null,
"标准价不能为空，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFStandardPri.setText("");
return;
}
String strRebatePri = jTFRebatePri.getText();
if (!judgeval.isFigureWhitPoint(strRebatePri)) {
JOptionPane.showMessageDialog(null,
"折扣价必须是数字或格式不标准，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTFRebatePri.setText("");
return;
}
String strPlace = jTAPlace.getText();
if (strPlace.length() > 100) {
JOptionPane.showMessageDialog(null,
"具体位置不能超过50个汉字，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTAPlace.setText("");
return;
}
String strRoomIntro = jTARoomIntro.getText();
if (strRoomIntro.length() > 500) {
JOptionPane.showMessageDialog(null,
"具体位置不能超过250个汉字，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTARoomIntro.setText("");
return;
}
String strRemark = jTARemark.getText();
if (strRoomIntro.length() > 500) {
JOptionPane.showMessageDialog(null,
"备注不能超过250个汉字，请重新输入！",
"酒店信息管理系统警告",
JOptionPane.WARNING_MESSAGE);
jTARemark.setText("");
return;
}
//-------------------------------------------------------------------------
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 = " INSERT INTO HIMS_RoomInfo (RoomID,Class,RoomArea,BedNo,StandardPri,RebatePri,place,RoomIntro,Remark) VALUES('"
+ strRoomID + "' , '" + strClass + "', '" +
strRoomArea +
"', '" + strBedNo + "', '"
+ strStandardPri + "', '" + strRebatePri + "', '" +
strPlace + "','" + strRoomIntro + "','" + strRemark +
"')";
Connect2.sql2 =
" INSERT INTO HIMS_RoomState (RoomID,OnUser,Reason,StartDate,EndDate) VALUES('"
+ strRoomID + "' ,'2' ,null,null,null)";
Connect1.stmt1.executeUpdate(Connect1.sql1);
Connect2.stmt2.executeUpdate(Connect2.sql2);
JOptionPane.showMessageDialog(null,
"新建成功！请设置房间的初始状态！！",
"酒店信息管理系统提示",
JOptionPane.INFORMATION_MESSAGE);
strSearchRoomID = strRoomID;
jBSetRoomState.setEnabled(true);
jTFQueryRoomID.setEnabled(true);
jBQueryRoomID.setEnabled(true);
jBEdit.setEnabled(false);
jBDelete.setEnabled(false);
jBNewBuildFinish.setEnabled(false);
jBNewBuild.setEnabled(true);
jCBRoomClass.setEnabled(false);
jTFStandardPri.setEnabled(false);
jTFRebatePri.setEnabled(false);
jTARoomIntro.setEnabled(false);
jTARemark.setEnabled(false);
jTFRoomArea.setEnabled(false);
jTFBedNo.setEnabled(false);
jTAPlace.setEnabled(false);
jTFGetRoomID.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
}
public void jBDelete_actionPerformed(ActionEvent e) { //删除
int inChoose = JOptionPane.showConfirmDialog(null, "真的要删除吗！",
"系统提示",
JOptionPane.YES_NO_OPTION);
if (inChoose == 0) { //inchoose为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 = "Delete from HIMS_RoomInfo WHERE RoomID='" +
jTFGetRoomID.getText() + "'"; //删除用户的SQL语句
Connect2.sql2 = "Delete from HIMS_RoomState WHERE RoomID='" +
jTFGetRoomID.getText() + "'"; //删除用户的SQL语句
Connect1.stmt1.executeUpdate(Connect1.sql1);
Connect2.stmt2.executeUpdate(Connect2.sql2);
jTFGetRoomID.setText("");
jCBRoomClass.removeAllItems();
jTFStandardPri.setText("");
jTFRebatePri.setText("");
jTFRoomArea.setText("");
jTFBedNo.setText("");
jTAPlace.setText("");
jTARoomIntro.setText("");
jTARemark.setText("");
} catch (SQLException ex) {
System.err.println("SQLException:" + ex.getMessage());
} 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
JOptionPane.showMessageDialog(null, "删除成功！",
"酒店信息管理系统提示",
JOptionPane.WARNING_MESSAGE);
}
}
public void jBEdit_actionPerformed(ActionEvent e) { //修改
jBSetRoomState.setEnabled(true);
strSearchRoomID = jTFGetRoomID.getText();
jBEdit.setEnabled(false);
jBEditFinish.setEnabled(true);
jBDelete.setEnabled(false);
jBNewBuild.setEnabled(false);
jTFQueryRoomID.setEnabled(false);
jBQueryRoomID.setEnabled(false);
jTFGetRoomID.setEnabled(false);
jTFStandardPri.setEnabled(true);
jTFRebatePri.setEnabled(true);
jTFRoomArea.setEnabled(true);
jTFBedNo.setEnabled(true);
jCBRoomClass.setEnabled(true);
jCBRoomClass.addItem(" ");
jCBRoomClass.addItem("标准单人间");
jCBRoomClass.addItem("标准双人间");
jCBRoomClass.addItem("标准四人间");
jCBRoomClass.addItem("家庭间");
jCBRoomClass.addItem("商务间");
jCBRoomClass.addItem("经济间");
jCBRoomClass.addItem("豪华套房");
jTAPlace.setEnabled(true);
jTARoomIntro.setEnabled(true);
jTARemark.setEnabled(true);
}
public void jBQueryRoomID_actionPerformed(ActionEvent e) { //查找
String strRoomifID = jTFQueryRoomID.getText();
try {
//-----------------------------------------------------------------------------------------------------
Connect1 = new DataConnect();
Connect1.con1 = DriverManager.getConnection(Connect1.url); //建立连接
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -