package AdmOrder;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import Adm.AdmLogin;
import UserFunction.SpecificNotice;
public class CheckIn extends JFrame{
public CheckIn() {
super("办理入住");
Container c = this.getContentPane();
c.setLayout(new FlowLayout());
JTextField[] t = { new JTextField("输入订单号: ",7),
new JTextField("编号", 5),
new JTextField("输入房间号: ",7),
new JTextField("编号", 5),
new JTextField("输入办理时间: ", 8),
new JTextField("时间", 10)
};
t[0].setEditable(false);
t[2].setEditable(false);
t[4].setEditable(false);
JButton btn1 = new JButton(" 办理入住 ");
for(int i= 0;i<6;i++)
{
c.add(t[i]);
}
c.add(btn1);
btn1.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载成功");
String url = "jdbc:mysql://localhost:3306/oneHotel?useSSl=true";
String user = "root";
String password = "523721wu";
Connection conn = DriverManager.getConnection(url,user,password);
PreparedStatement psql;
psql = conn.prepareStatement("INSERT \r\n"
+ "INTO handel \r\n"
+ "VALUES('"+AdmLogin.id+"',?,?,?);");
psql.setString(1, t[1].getText());
psql.setString(2, t[3].getText());
psql.setString(3, t[5].getText());
psql.executeUpdate();
psql.close();
conn.close();
}catch(Exception e1){
e1.printStackTrace();
}
try {//更新订单状态
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载成功");
String url = "jdbc:mysql://localhost:3306/oneHotel?useSSl=true";
String user = "root";
String password = "523721wu";
Connection conn = DriverManager.getConnection(url,user,password);
PreparedStatement psql;
psql = conn.prepareStatement("UPDATE roomorder\r\n"
+ "SET OrderStatus = 0\r\n"
+ "WHERE OrderNo = ?;");
psql.setString(1, t[1].getText());
psql.executeUpdate();
psql.close();
conn.close();
}catch(Exception e1){
e1.printStackTrace();
}
try {//更新房间状态
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载成功");
String url = "jdbc:mysql://localhost:3306/oneHotel?useSSl=true";
String user = "root";
String password = "523721wu";
Connection conn = DriverManager.getConnection(url,user,password);
PreparedStatement psql;
psql = conn.prepareStatement("UPDATE room\r\n"
+ "SET RoomStatus = 0\r\n"
+ "WHERE RoomNo = ?;");
psql.setString(1, t[3].getText());
psql.executeUpdate();
psql.close();
conn.close();
}catch(Exception e1){
e1.printStackTrace();
}
JOptionPane.showMessageDialog(null, "办理入住成功");
}
});
JPanel bottom2 = new JPanel();
JTextField[] t2 = {
new JTextField("输入房间号: ", 7),
new JTextField("编号", 6)
};
t2[0].setEditable(false);
for(int i= 0;i<2;i++)
{
bottom2.add(t2[i]);
}
JButton btn2 = new JButton(" 办理退房 ");
c.add(bottom2);
c.add(btn2);
btn2.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
try {//更新房间状态
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("加载成功");
String url = "jdbc:mysql://localhost:3306/oneHotel?useSSl=true";
String user = "root";
String password = "523721wu";
Connection conn = DriverManager.getConnection(url,user,password);
PreparedStatement psql;
psql = conn.prepareStatement("UPDATE room\r\n"
+ "SET RoomStatus = 1\r\n"
+ "WHERE RoomNo = ?;");
psql.setString(1, t2[1].getText());
psql.executeUpdate();
psql.close();
conn.close();
}catch(Exception e1){
e1.printStackTrace();
}
JOptionPane.showMessageDialog(null, "退房成功");
}
});
}
public static void main(String[] args) {
// TODO Auto-generated method stub
CheckIn app = new CheckIn();
app.setSize(200, 500);
app.setVisible(true);
}
}
酒店管理系统实现源码.zip （81个子文件） 
test bin Adm 
AdmGUI.class 2KB AdmGUI$1.class 770B AdmGUI$4.class 776B AdmLogin$1.class 3KB AdmGUI$8.class 829B AdmGUI$9.class 753B AdmGUI$2.class 776B AdmLogin.class 2KB AdmGUI$5.class 774B AdmGUI$6.class 772B AdmGUI$3.class 774B AdmGUI$7.class 762B SeeUser.class 3KB UserFunction SpecificNotice.class 4KB SeekNotice.class 4KB ModifyInfor.class 4KB UserPlaceOrder.class 2KB SeekNotice$1.class 1KB UserMyOrder.class 3KB SpecificNotice$1.class 2KB UserPlaceOrder$1.class 3KB module-info.class 187B AdmNotice ManageNotice$1.class 2KB SeeOwnNotice$1.class 2KB SendOutNotice.class 2KB ViewAllNotice.class 3KB ManageNotice.class 2KB SeeOwnNotice.class 4KB SendOutNotice$1.class 2KB User UserFunctionGUI$1.class 829B UserGUI.class 1KB UserGUI$1.class 936B UserFunctionGUI$4.class 837B UserLogin$1.class 3KB UserFunctionGUI$5.class 838B UserFunctionGUI.class 2KB UserFunctionGUI$2.class 844B UserFunctionGUI$3.class 835B UserGUI$2.class 962B UserRegister$1.class 2KB UserRegister.class 2KB UserLogin.class 2KB AdmOrder CheckIn.class 2KB CheckIn$2.class 2KB AdmHandleOrder.class 3KB CheckIn$1.class 3KB UserAllOrder$1.class 837B UserAllOrder.class 4KB AdmRoom CheckRoomStatus$1.class 1KB OrderInfoSumFrm.class 3KB CheckRoomStatus.class 4KB CheckRoomNum.class 3KB RoomUsedPeople.class 3KB .settings org.eclipse.jdt.core.prefs 781B src module-info.java 62B Adm AdmGUI.java 4KB SeeUser.java 2KB AdmLogin.java 2KB UserFunction SpecificNotice.java 5KB ModifyInfor.java 3KB UserMyOrder.java 2KB UserPlaceOrder.java 4KB SeekNotice.java 3KB AdmNotice SendOutNotice.java 2KB ViewAllNotice.java 2KB SeeOwnNotice.java 4KB ManageNotice.java 3KB User UserLogin.java 2KB UserFunctionGUI.java 2KB UserRegister.java 3KB UserGUI.java 1KB AdmOrder CheckIn.java 5KB AdmHandleOrder.java 2KB UserAllOrder.java 3KB AdmRoom OrderInfoSumFrm.java 2KB CheckRoomNum.java 2KB RoomUsedPeople.java 2KB CheckRoomStatus.java 3KB .project 380B .classpath 470B lib 
mysql-connector-java-8.0.25.jar 2.32MB资源评论
