基于CS的客房管理系统的设计与实现

基于CS的客房管理系统的设计与实现登录注册界面

基于CS的客房管理系统的设计与实现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 '主键',
	name varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	sfz varchar(100) comment '身份证'
) comment '客户';

客房经营信息表创建语句如下:


create table t_kfjy(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '客房',
	v2 varchar(100) comment '客户',
	v3 varchar(100) comment '入房时间',
	v4 varchar(100) comment '退房时间',
	v5 varchar(100) comment '金额',
	v6 varchar(100) comment '备注'
) comment '客房经营信息';

客房类型表创建语句如下:


create table t_kflx(
	id int primary key auto_increment comment '主键',
	k1 varchar(100) comment '类型名称',
	k2 varchar(100) comment '面积',
	k3 varchar(100) comment '床位',
	k4 varchar(100) comment '价格'
) comment '客房类型';

客房信息表创建语句如下:


create table t_kfxx(
	id int primary key auto_increment comment '主键',
	x1 varchar(100) comment '客房号',
	x2 varchar(100) comment '客房类型',
	x3 varchar(100) comment '客房位置'
) comment '客房信息';

基于CS的客房管理系统的设计与实现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,
	name varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	sfz varchar(100)
);
--客户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.name is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.sfz is '身份证';
--客户表加注释
comment on table t_customer is '客户';

客房经营信息表创建语句如下:


create table t_kfjy(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--客房经营信息字段加注释
comment on column t_kfjy.id is '主键';
comment on column t_kfjy.v1 is '客房';
comment on column t_kfjy.v2 is '客户';
comment on column t_kfjy.v3 is '入房时间';
comment on column t_kfjy.v4 is '退房时间';
comment on column t_kfjy.v5 is '金额';
comment on column t_kfjy.v6 is '备注';
--客房经营信息表加注释
comment on table t_kfjy is '客房经营信息';

客房类型表创建语句如下:


create table t_kflx(
	id integer,
	k1 varchar(100),
	k2 varchar(100),
	k3 varchar(100),
	k4 varchar(100)
);
--客房类型字段加注释
comment on column t_kflx.id is '主键';
comment on column t_kflx.k1 is '类型名称';
comment on column t_kflx.k2 is '面积';
comment on column t_kflx.k3 is '床位';
comment on column t_kflx.k4 is '价格';
--客房类型表加注释
comment on table t_kflx is '客房类型';

客房信息表创建语句如下:


create table t_kfxx(
	id integer,
	x1 varchar(100),
	x2 varchar(100),
	x3 varchar(100)
);
--客房信息字段加注释
comment on column t_kfxx.id is '主键';
comment on column t_kfxx.x1 is '客房号';
comment on column t_kfxx.x2 is '客房类型';
comment on column t_kfxx.x3 is '客房位置';
--客房信息表加注释
comment on table t_kfxx is '客房信息';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_kfjy;
create sequence s_t_kflx;
create sequence s_t_kfxx;

基于CS的客房管理系统的设计与实现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,--主键
	name varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--性别
	sfz varchar(100)--身份证
);

客房经营信息表创建语句如下:


--客房经营信息表注释
create table t_kfjy(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--客房
	v2 varchar(100),--客户
	v3 varchar(100),--入房时间
	v4 varchar(100),--退房时间
	v5 varchar(100),--金额
	v6 varchar(100)--备注
);

客房类型表创建语句如下:


--客房类型表注释
create table t_kflx(
	id int identity(1,1) primary key not null,--主键
	k1 varchar(100),--类型名称
	k2 varchar(100),--面积
	k3 varchar(100),--床位
	k4 varchar(100)--价格
);

客房信息表创建语句如下:


--客房信息表注释
create table t_kfxx(
	id int identity(1,1) primary key not null,--主键
	x1 varchar(100),--客房号
	x2 varchar(100),--客房类型
	x3 varchar(100)--客房位置
);

基于CS的客房管理系统的设计与实现登录后主页

基于CS的客房管理系统的设计与实现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 name;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//身份证
private String sfz;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
}

客房经营信息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_kfjy")
public class Kfjy {
//主键
@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 v1;
//客户
private String v2;
//入房时间
private String v3;
//退房时间
private String v4;
//金额
private String v5;
//备注
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

客房类型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_kflx")
public class Kflx {
//主键
@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 k1;
//面积
private String k2;
//床位
private String k3;
//价格
private String k4;
public String getK1() {return k1;}
public void setK1(String k1) {this.k1 = k1;}
public String getK2() {return k2;}
public void setK2(String k2) {this.k2 = k2;}
public String getK3() {return k3;}
public void setK3(String k3) {this.k3 = k3;}
public String getK4() {return k4;}
public void setK4(String k4) {this.k4 = k4;}
}

客房信息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_kfxx")
public class Kfxx {
//主键
@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 x1;
//客房类型
private String x2;
//客房位置
private String x3;
public String getX1() {return x1;}
public void setX1(String x1) {this.x1 = x1;}
public String getX2() {return x2;}
public void setX2(String x2) {this.x2 = x2;}
public String getX3() {return x3;}
public void setX3(String x3) {this.x3 = x3;}
}

基于CS的客房管理系统的设计与实现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 name;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//身份证
private String sfz;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
}

客房经营信息javaBean创建语句如下:


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

//客房经营信息
public class Kfjy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客房
private String v1;
//客户
private String v2;
//入房时间
private String v3;
//退房时间
private String v4;
//金额
private String v5;
//备注
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

客房类型javaBean创建语句如下:


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

//客房类型
public class Kflx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型名称
private String k1;
//面积
private String k2;
//床位
private String k3;
//价格
private String k4;
public String getK1() {return k1;}
public void setK1(String k1) {this.k1 = k1;}
public String getK2() {return k2;}
public void setK2(String k2) {this.k2 = k2;}
public String getK3() {return k3;}
public void setK3(String k3) {this.k3 = k3;}
public String getK4() {return k4;}
public void setK4(String k4) {this.k4 = k4;}
}

客房信息javaBean创建语句如下:


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

//客房信息
public class Kfxx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客房号
private String x1;
//客房类型
private String x2;
//客房位置
private String x3;
public String getX1() {return x1;}
public void setX1(String x1) {this.x1 = x1;}
public String getX2() {return x2;}
public void setX2(String x2) {this.x2 = x2;}
public String getX3() {return x3;}
public void setX3(String x3) {this.x3 = x3;}
}

源代码下载点这里

评论