基于ssh的宾馆管理系统(xfa36)_mysql_oracle代码分享

• 基于ssh的宾馆管理系统mysql数据库创建语句
• 基于ssh的宾馆管理系统oracle数据库创建语句
• 基于ssh的宾馆管理系统sqlserver数据库创建语句
• 基于ssh的宾馆管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 基于ssh的宾馆管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

基于ssh的宾馆管理系统mysql数据库版本源码：

超级管理员表创建语句如下：

create table t_admin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '超级管理员账号',
	password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');

客户表创建语句如下：

create table t_customer(
	id int primary key auto_increment comment '主键',
	customerName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	sex varchar(100) comment '',
	age varchar(100) comment '年龄',
	birthday varchar(100) comment '出生日期',
	idcard varchar(100) comment '身份证',
	headPic varchar(100) comment '头像',
	status varchar(100) comment ''
) comment '客户';

消费订单表创建语句如下：

create table t_order(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	roomId int comment '房间号',
	lx varchar(100) comment '',
	beginDate datetime comment '开始日期',
	endDate datetime comment '结束日期',
	yj int comment '押金',
	kc int comment '扣除金额',
	kcsm text comment '押金扣除说明',
	insertDate datetime comment '订单生成日期',
	czr varchar(100) comment '操作人',
	status varchar(100) comment ''
) comment '消费订单';

使用日志表创建语句如下：

create table t_rizhi(
	id int primary key auto_increment comment '主键',
	syr varchar(100) comment '使用人',
	cd varchar(100) comment '使用菜单',
	insertDate datetime comment '使用日期'
) comment '使用日志';

房间表创建语句如下：

create table t_room(
	id int primary key auto_increment comment '主键',
	roomName varchar(100) comment '房间编号',
	typesName varchar(100) comment '',
	daydj int comment '一天价格',
	zdfdj int comment '钟点房价格',
	status varchar(100) comment ''
) comment '房间';

用户表创建语句如下：

create table t_user(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	xm varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '',
	phone varchar(100) comment '电话',
	gw varchar(100) comment '岗位'
) comment '用户';

支出清单表创建语句如下：

create table t_zhichu(
	id int primary key auto_increment comment '主键',
	lx varchar(100) comment '',
	showDate datetime comment '日期',
	fee int comment '金额',
	remark text comment '备注',
	fzr varchar(100) comment '负责人'
) comment '支出清单';

基于ssh的宾馆管理系统oracle数据库版本源码：

超级管理员表创建语句如下：

create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

客户表创建语句如下：

create table t_customer(
	id integer,
	customerName varchar(100),
	phone varchar(100),
	sex varchar(100),
	age varchar(100),
	birthday varchar(100),
	idcard varchar(100),
	headPic varchar(100),
	status varchar(100)
);
--客户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.sex is '';
comment on column t_customer.age is '年龄';
comment on column t_customer.birthday is '出生日期';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.headPic is '头像';
comment on column t_customer.status is '';
--客户表加注释
comment on table t_customer is '客户';

消费订单表创建语句如下：

create table t_order(
	id integer,
	customerId int,
	roomId int,
	lx varchar(100),
	beginDate datetime,
	endDate datetime,
	yj int,
	kc int,
	kcsm text,
	insertDate datetime,
	czr varchar(100),
	status varchar(100)
);
--消费订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '用户';
comment on column t_order.roomId is '房间号';
comment on column t_order.lx is '';
comment on column t_order.beginDate is '开始日期';
comment on column t_order.endDate is '结束日期';
comment on column t_order.yj is '押金';
comment on column t_order.kc is '扣除金额';
comment on column t_order.kcsm is '押金扣除说明';
comment on column t_order.insertDate is '订单生成日期';
comment on column t_order.czr is '操作人';
comment on column t_order.status is '';
--消费订单表加注释
comment on table t_order is '消费订单';

使用日志表创建语句如下：

create table t_rizhi(
	id integer,
	syr varchar(100),
	cd varchar(100),
	insertDate datetime
);
--使用日志字段加注释
comment on column t_rizhi.id is '主键';
comment on column t_rizhi.syr is '使用人';
comment on column t_rizhi.cd is '使用菜单';
comment on column t_rizhi.insertDate is '使用日期';
--使用日志表加注释
comment on table t_rizhi is '使用日志';

房间表创建语句如下：

create table t_room(
	id integer,
	roomName varchar(100),
	typesName varchar(100),
	daydj int,
	zdfdj int,
	status varchar(100)
);
--房间字段加注释
comment on column t_room.id is '主键';
comment on column t_room.roomName is '房间编号';
comment on column t_room.typesName is '';
comment on column t_room.daydj is '一天价格';
comment on column t_room.zdfdj is '钟点房价格';
comment on column t_room.status is '';
--房间表加注释
comment on table t_room is '房间';

用户表创建语句如下：

create table t_user(
	id integer,
	username varchar(100),
	password varchar(100),
	xm varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	gw varchar(100)
);
--用户字段加注释
comment on column t_user.id is '主键';
comment on column t_user.username is '账号';
comment on column t_user.password is '密码';
comment on column t_user.xm is '姓名';
comment on column t_user.age is '年龄';
comment on column t_user.sex is '';
comment on column t_user.phone is '电话';
comment on column t_user.gw is '岗位';
--用户表加注释
comment on table t_user is '用户';

支出清单表创建语句如下：

create table t_zhichu(
	id integer,
	lx varchar(100),
	showDate datetime,
	fee int,
	remark text,
	fzr varchar(100)
);
--支出清单字段加注释
comment on column t_zhichu.id is '主键';
comment on column t_zhichu.lx is '';
comment on column t_zhichu.showDate is '日期';
comment on column t_zhichu.fee is '金额';
comment on column t_zhichu.remark is '备注';
comment on column t_zhichu.fzr is '负责人';
--支出清单表加注释
comment on table t_zhichu is '支出清单';

oracle特有，对应序列如下：

create sequence s_t_customer;
create sequence s_t_order;
create sequence s_t_rizhi;
create sequence s_t_room;
create sequence s_t_user;
create sequence s_t_zhichu;

基于ssh的宾馆管理系统sqlserver数据库版本源码：

超级管理员表创建语句如下：

--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

客户表创建语句如下：

--客户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	customerName varchar(100),--姓名
	phone varchar(100),--电话
	sex varchar(100),--
	age varchar(100),--年龄
	birthday varchar(100),--出生日期
	idcard varchar(100),--身份证
	headPic varchar(100),--头像
	status varchar(100)--
);

消费订单表创建语句如下：

--消费订单表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	roomId int,--房间号
	lx varchar(100),--
	beginDate datetime,--开始日期
	endDate datetime,--结束日期
	yj int,--押金
	kc int,--扣除金额
	kcsm text,--押金扣除说明
	insertDate datetime,--订单生成日期
	czr varchar(100),--操作人
	status varchar(100)--
);

使用日志表创建语句如下：

--使用日志表注释
create table t_rizhi(
	id int identity(1,1) primary key not null,--主键
	syr varchar(100),--使用人
	cd varchar(100),--使用菜单
	insertDate datetime--使用日期
);

房间表创建语句如下：

--房间表注释
create table t_room(
	id int identity(1,1) primary key not null,--主键
	roomName varchar(100),--房间编号
	typesName varchar(100),--
	daydj int,--一天价格
	zdfdj int,--钟点房价格
	status varchar(100)--
);

用户表创建语句如下：

--用户表注释
create table t_user(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	xm varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--
	phone varchar(100),--电话
	gw varchar(100)--岗位
);

支出清单表创建语句如下：

--支出清单表注释
create table t_zhichu(
	id int identity(1,1) primary key not null,--主键
	lx varchar(100),--
	showDate datetime,--日期
	fee int,--金额
	remark text,--备注
	fzr varchar(100)--负责人
);

基于ssh的宾馆管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：

客户javaBean创建语句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//客户
@Table(name = "t_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String customerName;
//电话
private String phone;
//
private String sex;
//年龄
private String age;
//出生日期
private String birthday;
//身份证
private String idcard;
//头像
private String headPic;
//
private String status;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

消费订单javaBean创建语句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//消费订单
@Table(name = "t_order")
public class Order {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//房间号
private Long roomId;
//
private String lx;
//开始日期
private Date beginDate;
//结束日期
private Date endDate;
//押金
private Integer yj;
//扣除金额
private Integer kc;
//押金扣除说明
private String kcsm;
//订单生成日期
private Date insertDate;
//操作人
private String czr;
//
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getRoomId() {return roomId;}
public void setRoomId(Long roomId) {this.roomId = roomId;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getYj() {return yj;}
public void setYj(Integer yj) {this.yj = yj;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public String getKcsm() {return kcsm;}
public void setKcsm(String kcsm) {this.kcsm = kcsm;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

使用日志javaBean创建语句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//使用日志
@Table(name = "t_rizhi")
public class Rizhi {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//使用人
private String syr;
//使用菜单
private String cd;
//使用日期
private Date insertDate;
public String getSyr() {return syr;}
public void setSyr(String syr) {this.syr = syr;}
public String getCd() {return cd;}
public void setCd(String cd) {this.cd = cd;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

房间javaBean创建语句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//房间
@Table(name = "t_room")
public class Room {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//房间编号
private String roomName;
//
private String typesName;
//一天价格
private Integer daydj;
//钟点房价格
private Integer zdfdj;
//
private String status;
public String getRoomName() {return roomName;}
public void setRoomName(String roomName) {this.roomName = roomName;}
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
public Integer getDaydj() {return daydj;}
public void setDaydj(Integer daydj) {this.daydj = daydj;}
public Integer getZdfdj() {return zdfdj;}
public void setZdfdj(Integer zdfdj) {this.zdfdj = zdfdj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

用户javaBean创建语句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//用户
@Table(name = "t_user")
public class User {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String xm;
//年龄
private String age;
//
private String sex;
//电话
private String phone;
//岗位
private String gw;
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 getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getGw() {return gw;}
public void setGw(String gw) {this.gw = gw;}
}

支出清单javaBean创建语句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//支出清单
@Table(name = "t_zhichu")
public class Zhichu {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String lx;
//日期
private Date showDate;
//金额
private Integer fee;
//备注
private String remark;
//负责人
private String fzr;
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
}

基于ssh的宾馆管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

客户javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//客户
public class Customer  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String customerName;
//电话
private String phone;
//
private String sex;
//年龄
private String age;
//出生日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private String birthday;
//身份证
private String idcard;
//头像
private String headPic;
//
private String status;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

消费订单javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//消费订单
public class Order  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//房间号
private Long roomId;
//
private String lx;
//开始日期
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date beginDate;
//结束日期
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date endDate;
//押金
private Integer yj;
//扣除金额
private Integer kc;
//押金扣除说明
private String kcsm;
//订单生成日期
private Date insertDate;
//操作人
private String czr;
//
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getRoomId() {return roomId;}
public void setRoomId(Long roomId) {this.roomId = roomId;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getYj() {return yj;}
public void setYj(Integer yj) {this.yj = yj;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public String getKcsm() {return kcsm;}
public void setKcsm(String kcsm) {this.kcsm = kcsm;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

使用日志javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//使用日志
public class Rizhi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//使用人
private String syr;
//使用菜单
private String cd;
//使用日期
private Date insertDate;
public String getSyr() {return syr;}
public void setSyr(String syr) {this.syr = syr;}
public String getCd() {return cd;}
public void setCd(String cd) {this.cd = cd;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

房间javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//房间
public class Room  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//房间编号
private String roomName;
//
private String typesName;
//一天价格
private Integer daydj;
//钟点房价格
private Integer zdfdj;
//
private String status;
public String getRoomName() {return roomName;}
public void setRoomName(String roomName) {this.roomName = roomName;}
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
public Integer getDaydj() {return daydj;}
public void setDaydj(Integer daydj) {this.daydj = daydj;}
public Integer getZdfdj() {return zdfdj;}
public void setZdfdj(Integer zdfdj) {this.zdfdj = zdfdj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

用户javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//用户
public class User  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String xm;
//年龄
private String age;
//
private String sex;
//电话
private String phone;
//岗位
private String gw;
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 getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getGw() {return gw;}
public void setGw(String gw) {this.gw = gw;}
}

支出清单javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//支出清单
public class Zhichu  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String lx;
//日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//金额
private Integer fee;
//备注
private String remark;
//负责人
private String fzr;
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
}