酒店预订系统包括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-mappingPUBLIC "-//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-mappingPUBLIC "-//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-mappingPUBLIC "-//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-mappingPUBLIC "-//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>暂时先写到这里,吃完饭继续……
新闻热点
疑难解答