租房管理系统的设计与实现

租房管理系统的设计与实现登录注册界面

租房管理系统的设计与实现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 '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	headPic varchar(100) comment '头像',
	email varchar(100) comment '邮箱',
	phone varchar(100) comment '电话',
	sfz varchar(100) comment '身份证'
) comment '用户';

财务表创建语句如下:


create table t_cw(
	id int primary key auto_increment comment '主键',
	types varchar(100) comment '金额类型',
	rzcz varchar(100) comment '入账出账',
	showDate datetime comment '日期',
	fee int comment '金额',
	content varchar(100) comment '详细记录'
) comment '财务';

房屋表创建语句如下:


create table t_fw(
	id int primary key auto_increment comment '主键',
	fwName varchar(100) comment '房屋编号',
	lx varchar(100) comment '类型',
	sl int comment '面积',
	dz varchar(100) comment '地址',
	pic varchar(100) comment '图片'
) comment '房屋';

合同表创建语句如下:


create table t_ht(
	id int primary key auto_increment comment '主键',
	htName varchar(100) comment '合同编号',
	fwName varchar(100) comment '房屋编号',
	customer1Id int comment '房东',
	customer2Id int comment '租户',
	beginDate datetime comment '开始日期',
	endDate datetime comment '结束日期',
	fee int comment '合同金额',
	content varchar(100) comment '详细内容',
	yj int comment '押金',
	pic varchar(100) comment '拍照',
	fileUrl varchar(100) comment '合同附件',
	status varchar(100) comment '状态'
) comment '合同';

普通管理员表创建语句如下:


create table t_ptadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ptadminName varchar(100) comment '姓名',
	email varchar(100) comment '邮箱',
	phone varchar(100) comment '电话'
) comment '普通管理员';

预定单表创建语句如下:


create table t_ydd(
	id int primary key auto_increment comment '主键',
	fwName varchar(100) comment '房屋编号',
	customer2Id int comment '租户',
	yd int comment '预定金额',
	insertDate datetime comment '发起日期',
	endDate datetime comment '结束日期'
) comment '预定单';

租房管理系统的设计与实现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,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	headPic varchar(100),
	email varchar(100),
	phone varchar(100),
	sfz varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.headPic is '头像';
comment on column t_customer.email is '邮箱';
comment on column t_customer.phone is '电话';
comment on column t_customer.sfz is '身份证';
--用户表加注释
comment on table t_customer is '用户';

财务表创建语句如下:


create table t_cw(
	id integer,
	types varchar(100),
	rzcz varchar(100),
	showDate datetime,
	fee int,
	content varchar(100)
);
--财务字段加注释
comment on column t_cw.id is '主键';
comment on column t_cw.types is '金额类型';
comment on column t_cw.rzcz is '入账出账';
comment on column t_cw.showDate is '日期';
comment on column t_cw.fee is '金额';
comment on column t_cw.content is '详细记录';
--财务表加注释
comment on table t_cw is '财务';

房屋表创建语句如下:


create table t_fw(
	id integer,
	fwName varchar(100),
	lx varchar(100),
	sl int,
	dz varchar(100),
	pic varchar(100)
);
--房屋字段加注释
comment on column t_fw.id is '主键';
comment on column t_fw.fwName is '房屋编号';
comment on column t_fw.lx is '类型';
comment on column t_fw.sl is '面积';
comment on column t_fw.dz is '地址';
comment on column t_fw.pic is '图片';
--房屋表加注释
comment on table t_fw is '房屋';

合同表创建语句如下:


create table t_ht(
	id integer,
	htName varchar(100),
	fwName varchar(100),
	customer1Id int,
	customer2Id int,
	beginDate datetime,
	endDate datetime,
	fee int,
	content varchar(100),
	yj int,
	pic varchar(100),
	fileUrl varchar(100),
	status varchar(100)
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.htName is '合同编号';
comment on column t_ht.fwName is '房屋编号';
comment on column t_ht.customer1Id is '房东';
comment on column t_ht.customer2Id is '租户';
comment on column t_ht.beginDate is '开始日期';
comment on column t_ht.endDate is '结束日期';
comment on column t_ht.fee is '合同金额';
comment on column t_ht.content is '详细内容';
comment on column t_ht.yj is '押金';
comment on column t_ht.pic is '拍照';
comment on column t_ht.fileUrl is '合同附件';
comment on column t_ht.status is '状态';
--合同表加注释
comment on table t_ht is '合同';

普通管理员表创建语句如下:


create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	email varchar(100),
	phone varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.email is '邮箱';
comment on column t_ptadmin.phone is '电话';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';

预定单表创建语句如下:


create table t_ydd(
	id integer,
	fwName varchar(100),
	customer2Id int,
	yd int,
	insertDate datetime,
	endDate datetime
);
--预定单字段加注释
comment on column t_ydd.id is '主键';
comment on column t_ydd.fwName is '房屋编号';
comment on column t_ydd.customer2Id is '租户';
comment on column t_ydd.yd is '预定金额';
comment on column t_ydd.insertDate is '发起日期';
comment on column t_ydd.endDate is '结束日期';
--预定单表加注释
comment on table t_ydd is '预定单';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_cw;
create sequence s_t_fw;
create sequence s_t_ht;
create sequence s_t_ptadmin;
create sequence s_t_ydd;

租房管理系统的设计与实现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,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	headPic varchar(100),--头像
	email varchar(100),--邮箱
	phone varchar(100),--电话
	sfz varchar(100)--身份证
);

财务表创建语句如下:


--财务表注释
create table t_cw(
	id int identity(1,1) primary key not null,--主键
	types varchar(100),--金额类型
	rzcz varchar(100),--入账出账
	showDate datetime,--日期
	fee int,--金额
	content varchar(100)--详细记录
);

房屋表创建语句如下:


--房屋表注释
create table t_fw(
	id int identity(1,1) primary key not null,--主键
	fwName varchar(100),--房屋编号
	lx varchar(100),--类型
	sl int,--面积
	dz varchar(100),--地址
	pic varchar(100)--图片
);

合同表创建语句如下:


--合同表注释
create table t_ht(
	id int identity(1,1) primary key not null,--主键
	htName varchar(100),--合同编号
	fwName varchar(100),--房屋编号
	customer1Id int,--房东
	customer2Id int,--租户
	beginDate datetime,--开始日期
	endDate datetime,--结束日期
	fee int,--合同金额
	content varchar(100),--详细内容
	yj int,--押金
	pic varchar(100),--拍照
	fileUrl varchar(100),--合同附件
	status varchar(100)--状态
);

普通管理员表创建语句如下:


--普通管理员表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ptadminName varchar(100),--姓名
	email varchar(100),--邮箱
	phone varchar(100)--电话
);

预定单表创建语句如下:


--预定单表注释
create table t_ydd(
	id int identity(1,1) primary key not null,--主键
	fwName varchar(100),--房屋编号
	customer2Id int,--租户
	yd int,--预定金额
	insertDate datetime,--发起日期
	endDate datetime--结束日期
);

租房管理系统的设计与实现登录后主页

租房管理系统的设计与实现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 username;
//密码
private String password;
//姓名
private String customerName;
//头像
private String headPic;
//邮箱
private String email;
//电话
private String phone;
//身份证
private String sfz;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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_cw")
public class Cw {
//主键
@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 types;
//入账出账
private String rzcz;
//日期
private Date showDate;
//金额
private Integer fee;
//详细记录
private String content;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getRzcz() {return rzcz;}
public void setRzcz(String rzcz) {this.rzcz = rzcz;}
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

房屋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_fw")
public class Fw {
//主键
@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 fwName;
//类型
private String lx;
//面积
private Integer sl;
//地址
private String dz;
//图片
private String pic;
public String getFwName() {return fwName;}
public void setFwName(String fwName) {this.fwName = fwName;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

合同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_ht")
public class Ht {
//主键
@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 htName;
//房屋编号
private String fwName;
//房东
private Integer customer1Id;
//租户
private Integer customer2Id;
//开始日期
private Date beginDate;
//结束日期
private Date endDate;
//合同金额
private Integer fee;
//详细内容
private String content;
//押金
private Integer yj;
//拍照
private String pic;
//合同附件
private String fileUrl;
//状态
private String status;
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public String getFwName() {return fwName;}
public void setFwName(String fwName) {this.fwName = fwName;}
public Integer getCustomer1Id() {return customer1Id;}
public void setCustomer1Id(Integer customer1Id) {this.customer1Id = customer1Id;}
public Integer getCustomer2Id() {return customer2Id;}
public void setCustomer2Id(Integer customer2Id) {this.customer2Id = customer2Id;}
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 getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getYj() {return yj;}
public void setYj(Integer yj) {this.yj = yj;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//邮箱
private String email;
//电话
private String phone;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

预定单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_ydd")
public class Ydd {
//主键
@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 fwName;
//租户
private Integer customer2Id;
//预定金额
private Integer yd;
//发起日期
private Date insertDate;
//结束日期
private Date endDate;
public String getFwName() {return fwName;}
public void setFwName(String fwName) {this.fwName = fwName;}
public Integer getCustomer2Id() {return customer2Id;}
public void setCustomer2Id(Integer customer2Id) {this.customer2Id = customer2Id;}
public Integer getYd() {return yd;}
public void setYd(Integer yd) {this.yd = yd;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
}

租房管理系统的设计与实现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 username;
//密码
private String password;
//姓名
private String customerName;
//头像
private String headPic;
//邮箱
private String email;
//电话
private String phone;
//身份证
private String sfz;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 Cw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//金额类型
private String types;
//入账出账
private String rzcz;
//日期
private Date showDate;
//金额
private Integer fee;
//详细记录
private String content;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getRzcz() {return rzcz;}
public void setRzcz(String rzcz) {this.rzcz = rzcz;}
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

房屋javaBean创建语句如下:


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

//房屋
public class Fw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//房屋编号
private String fwName;
//类型
private String lx;
//面积
private Integer sl;
//地址
private String dz;
//图片
private String pic;
public String getFwName() {return fwName;}
public void setFwName(String fwName) {this.fwName = fwName;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

合同javaBean创建语句如下:


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

//合同
public class Ht  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//合同编号
private String htName;
//房屋编号
private String fwName;
//房东
private Integer customer1Id;
//租户
private Integer customer2Id;
//开始日期
private Date beginDate;
//结束日期
private Date endDate;
//合同金额
private Integer fee;
//详细内容
private String content;
//押金
private Integer yj;
//拍照
private String pic;
//合同附件
private String fileUrl;
//状态
private String status;
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public String getFwName() {return fwName;}
public void setFwName(String fwName) {this.fwName = fwName;}
public Integer getCustomer1Id() {return customer1Id;}
public void setCustomer1Id(Integer customer1Id) {this.customer1Id = customer1Id;}
public Integer getCustomer2Id() {return customer2Id;}
public void setCustomer2Id(Integer customer2Id) {this.customer2Id = customer2Id;}
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 getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getYj() {return yj;}
public void setYj(Integer yj) {this.yj = yj;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Ptadmin  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 ptadminName;
//邮箱
private String email;
//电话
private String phone;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

预定单javaBean创建语句如下:


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

//预定单
public class Ydd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//房屋编号
private String fwName;
//租户
private Integer customer2Id;
//预定金额
private Integer yd;
//发起日期
private Date insertDate;
//结束日期
private Date endDate;
public String getFwName() {return fwName;}
public void setFwName(String fwName) {this.fwName = fwName;}
public Integer getCustomer2Id() {return customer2Id;}
public void setCustomer2Id(Integer customer2Id) {this.customer2Id = customer2Id;}
public Integer getYd() {return yd;}
public void setYd(Integer yd) {this.yd = yd;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
}

评论