酒店預(yù)訂系統(tǒng)包括4項(xiàng)功能。
管理員管理:系統(tǒng)中設(shè)計(jì)了管理員管理菜單,在該菜單中可以直接跳轉(zhuǎn)到房間管理、訂單管理、客戶管理的響應(yīng)頁面,并完成對(duì)房間、訂單和客戶信息的增加、刪除和修改。房間管理:實(shí)現(xiàn)按房間號(hào)查詢指定房間以及添加、刪除和修改房間信息的功能。訂單管理:實(shí)現(xiàn)按訂單號(hào)查詢、按客戶編號(hào)及房間號(hào)查詢指定訂單、修改預(yù)定訂單、取消預(yù)定訂單等功能。客戶管理:實(shí)現(xiàn)客戶信息錄入、查詢、修改以及刪除的功能。項(xiàng)目文件如下: 
項(xiàng)目運(yùn)行效果(實(shí)在不好意思拿出手): 
Hibernate持久層設(shè)計(jì) 1.創(chuàng)建持久化類 系統(tǒng)中共包含4個(gè)持久化類,分別是Admin、Room、Order和User。其中Admin類用來描述酒店管理員的信息 ,Room類用來描述酒店中各個(gè)房間的信息,Order類用來描述客戶預(yù)定房間的訂單信息,而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.創(chuàng)建映射文件 持久化類創(chuàng)建完成之后,下面編寫映射文件,系統(tǒng)一共有Order.hbm.xml、Admin.hbm.xml、Room.hbm.xml以及User.hbm.xml這4個(gè)映射文件。
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>暫時(shí)先寫到這里,吃完飯繼續(xù)……
新聞熱點(diǎn)
疑難解答
圖片精選
網(wǎng)友關(guān)注