基于java的酒店管理系统的设计与实现_java酒店管理系统源码

public class LoginFrame extends JFrame {
private JPanel contentPane;
private JTextField textField;
private JPasswordField passwordField;
private JTextField textField_1;
private CaptchaUtils cpt;
private BufferedImage image1;
private String code;
private JLabel label_6;
//创建deskservice对象
private DeskService deskService=new DeskServiceImpl();
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
LoginFrame frame = new LoginFrame();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
public LoginFrame() {
setBackground(Color.GREEN);
setTitle("KING'S  LANDING");
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setBounds(500, 250, 624, 524);
contentPane = new JPanel(){
protected void paintComponent(Graphics g){
super.paintComponent(g);
ImageIcon images=new ImageIcon("images/624524.jpg");
g.drawImage(images.getImage(),0,0,null);
}
};	
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
JLabel label_1 = new JLabel("\u7528\u6237\u540D");
label_1.setBackground(Color.WHITE);
label_1.setForeground(Color.WHITE);
label_1.setFont(new Font("微软雅黑", Font.PLAIN, 15));
label_1.setIcon(new ImageIcon(LoginFrame.class.getResource("/images/yonghu.png")));
textField = new JTextField();
textField.setBackground(Color.WHITE);
textField.setColumns(10);
label_6=new JLabel();
label_6.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent e) {
cpt=new CaptchaUtils();
//获取画布
image1=cpt.getBuffImg();
//获取随机数
code=cpt.getCode();
ImageIcon icon=new ImageIcon(image1,"jpeg");
label_6.setIcon(icon);
}
});
/**
* 验证码
*/
cpt=new CaptchaUtils();
//获取画布
image1=cpt.getBuffImg();
//获取随机数
code=cpt.getCode();
ImageIcon icon=new ImageIcon(image1,"jpeg");
label_6.setIcon(icon);
JLabel label_2 = new JLabel("\u5BC6\u7801");
label_2.setForeground(Color.WHITE);
label_2.setFont(new Font("微软雅黑", Font.PLAIN, 15));
label_2.setIcon(new ImageIcon(LoginFrame.class.getResource("/images/mima.png")));
JButton button = new JButton("\u767B\u5F55");
//设置按钮的透明
button.setContentAreaFilled(false);
//给按钮上的字设置颜色
button.setForeground(Color.WHITE);
button.setBackground(Color.WHITE);
button.setFont(new Font("微软雅黑", Font.PLAIN, 20));
button.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent e) {
//获取输入的用户名和密码
String name=textField.getText();
char[]array=passwordField.getPassword();
String password=new String(array);
System.out.println("name:"+name);
System.out.println("password:"+password);
//用户输入的验证码
String codeFrame=textField_1.getText();
if(!(code.equalsIgnoreCase((codeFrame)))){
JOptionPane.showMessageDialog(null, "验证码错误,请重新输入！");
return;
}
DeskDaoImpl deskDao=new DeskDaoImpl();
Desk desk=new Desk(name,password);
int code=deskDao.LoginDesk(desk);
//判断是否是管理员登录
if(code==1){
//登录成功
new HomeFrame().setVisible(true);
//符合 则跳转到管理员的后台管理界面
dispose();
return ;
}
else{
boolean bool=deskService.LoginDeskService(desk);
if(!bool){
JOptionPane.showMessageDialog(null, "账号或密码错误,请重新输入！");
return;
}
//登录成功
new HomeFrame().setVisible(true);
dispose();
}
});
}

@Override
//开房监听事件
public void mouseClicked(MouseEvent e) {
//获取输入的房间号
int houseId=Integer.parseInt(textField.getText());
//获取输入的姓名
String name=p_name.getText();
//获取输入的年龄
int age=Integer.parseInt(p_age.getText());
//获取输入的入住天数
int day=Integer.parseInt(p_day.getText());
//获取输入的身份证号
String id=p_id.getText();
//获取输入的性别
String sex=p_sex.getText();
//获取房间类型
String type=p_type.getText();
//封装到Guest实体中
Guest guest=new Guest();
guest.setG_roomid(houseId);
guest.setG_name(name);
guest.setG_age(age);
guest.setG_days(day);
guest.setG_id(id);
guest.setG_sex(sex);
//封装到Room实体中
Room room=new Room();
room.setR_id(houseId);
//判断年龄是否合理
if(!(age>0&&age<100)){
JOptionPane.showMessageDialog(null, "年龄输入不合理，请重新输入！");
return;
}
//判断性别是否合理
if(!(sex.equals("男")||sex.equals("女"))){
JOptionPane.showMessageDialog(null, "性别只能是男或女，请重新输入！");
return;
}
//入住天数不能小于1
if(!(day>0)){
JOptionPane.showMessageDialog(null, "入住天数不能小于1天，请重新输入！");
return;
}
boolean bool=rs.OpenRoom(room);
if(!bool){
//房间已满则开房失败
JOptionPane.showMessageDialog(null, "该房间已满，请更换房间！");
return;
}
if(!(type.equals("标准房")||type.equals("套房")||type.equals("双人房")||type.equals("豪华套房"))){
JOptionPane.showMessageDialog(null, "输入的信息有误，开房失败！");
return;
}
boolean bool1=gsi.AddGuest(guest);
if(bool1){
//身份证不符合格式也失败
JOptionPane.showMessageDialog(null, "身份证不符合格式，开房失败！");
return;
}
}
});

CREATE TABLE `NewTable` (
`d_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '前台id' ,
`d_name`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '姓名' ,
`d_password`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '密码' ,
INDEX `d_id` (`d_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=112
ROW_FORMAT=COMPACT
;

CREATE TABLE `NewTable` (
`g_roomid`  int(11) NULL DEFAULT NULL COMMENT '房间id' ,
`g_id`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '顾客编号' ,
`g_name`  varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '姓名' ,
`g_sex`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '性别' ,
`g_age`  int(11) NULL DEFAULT NULL COMMENT '年龄' ,
`g_days`  int(11) NULL DEFAULT NULL COMMENT '入住天数' ,
`g_time`  datetime NULL DEFAULT NULL COMMENT '入住日期' 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
ROW_FORMAT=COMPACT
;

CREATE TABLE `NewTable` (
`r_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT 'roo  id' ,
`r_type`  varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'room 类型' ,
`r_price`  double NULL DEFAULT NULL COMMENT 'room价格' ,
`r_local`  varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'room位置' ,
`r_state`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'room状态' ,
INDEX `r_id` (`r_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=106
ROW_FORMAT=COMPACT
;