酒店预订系统包括4项功能。
- 管理员管理:系统中设计了管理员管理菜单,在该菜单中可以直接跳转到房间管理、订单管理、客户管理的响应页面,并完成对房间、订单和客户信息的增加、删除和修改。
- 房间管理:实现按房间号查询指定房间以及添加、删除和修改房间信息的功能。
- 订单管理:实现按订单号查询、按客户编号及房间号查询指定订单、修改预定订单、取消预定订单等功能。
- 客户管理:实现客户信息录入、查询、修改以及删除的功能。
项目文件如下:
项目运行效果(实在不好意思拿出手):
Hibernate持久层设计
1.创建持久化类
系统中共包含4个持久化类,分别是Admin、Room、Order和User。其中Admin类用来描述酒店管理员的信息 ,Room类用来描述酒店中各个房间的信息,Order类用来描述客户预定房间的订单信息,而User类则用来描述客户的信息。
Admin.java类代码如下:
package com.integration.entity;
public class Admin {
private int adminid;
private String username;
private String password;
public int getAdminid() {
return adminid;
}
public void setAdminid(int adminid) {
this.adminid = adminid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
Room.java类:
package com.integration.entity;
public class Room {
private int roomid;
private String name;
private double price;
private String category;
private int status;
public int getStatus() {
return status;
}
public void setStatus(int status) {
this.status = status;
}
public int getRoomid() {
return roomid;
}
public void setRoomid(int roomid) {
this.roomid = roomid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getCategory() {
return category;
}
public void setCategory(String category) {
this.category = category;
}
}
Order.java类:
package com.integration.entity;
public class Order {
private int orderid;
private int roomid;
private int userid;
public int getOrderid() {
return orderid;
}
public void setOrderid(int orderid) {
this.orderid = orderid;
}
public int getRoomid() {
return roomid;
}
public void setRoomid(int roomid) {
this.roomid = roomid;
}
public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}
}
User.java类:
package com.integration.entity;
public class User {
private int userid;
private String username;
private String password;
private String mobile;
private String email;
public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
}
2.创建映射文件
持久化类创建完成之后,下面编写映射文件,系统一共有Order.hbm.xml、Admin.hbm.xml、Room.hbm.xml以及User.hbm.xml这4个映射文件。
Order.hbm.xml映射文件:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.integration.entity.Order" table="h_order">
<id name="orderid" column="orderid" type="int">
<generator class="identity"> <!-- 主键id的生成方式为自增 -->
</generator>
</id>
<property name="userid" column="userid" type="int"></property>
<property name="roomid" column="roomid" type="int"></property>
</class>
</hibernate-mapping>
Admin.hbm.xml映射文件:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.integration.entity.Admin" table="admin">
<id name="adminid" column="adminid" type="int">
<generator class="identity"> <!-- 主键id的生成方式为自增 -->
</generator>
</id>
<property name="username" column="username" type="string"></property>
<property name="password" column="password" type="string"></property>
</class>
</hibernate-mapping>
Room.hbm.xml映射文件:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.integration.entity.Room" table="room">
<id name="roomid" column="roomid" type="int">
<generator class="identity"> <!-- 主键id的生成方式为自增 -->
</generator>
</id>
<property name="name" column="name" type="string"></property>
<property name="price" column="price" type="double"></property>
<property name="category" column="category" type="string"></property>
<property name="status" column="status" type="int"></property>
</class>
</hibernate-mapping>
User.hbm.xml映射文件:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.integration.entity.User" table="user">
<id name="userid" column="userid" type="int">
<generator class="identity"> <!-- 主键id的生成方式为自增 -->
</generator>
</id>
<property name="username" column="username" type="string"></property>
<property name="password" column="password" type="string"></property>
<property name="mobile" column="mobile" type="string"></property>
<property name="email" column="email" type="string"></property>
</class>
</hibernate-mapping>
暂时先写到这里,吃完饭继续……