- 基于JSP的房屋出租管理系统系统设计mysql数据库创建语句
- 基于JSP的房屋出租管理系统系统设计oracle数据库创建语句
- 基于JSP的房屋出租管理系统系统设计sqlserver数据库创建语句
- 基于JSP的房屋出租管理系统系统设计spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于JSP的房屋出租管理系统系统设计spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于JSP的房屋出租管理系统系统设计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 '密码',
name varchar(100) comment '姓名',
phone varchar(100) comment '电话',
sex varchar(100) comment '性别',
age varchar(100) comment '年龄'
) comment '客户';
分类表创建语句如下：
create table t_fl(
id int primary key auto_increment comment '主键',
flName varchar(100) comment '分类'
) comment '分类';
房源表创建语句如下：
create table t_fy(
id int primary key auto_increment comment '主键',
adminId int 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 '图片二',
v7 varchar(100) comment '图片三',
flId int comment '分类'
) comment '房源';
合同表创建语句如下：
create table t_ht(
id int primary key auto_increment comment '主键',
htName varchar(100) comment '',
fyId int comment '房源',
customerId int comment '客户',
htBeginDate varchar(100) comment '合同开始时间',
htEndDate varchar(100) comment '合同结束时间',
htUrl varchar(100) comment '合同',
dj varchar(100) comment '定金',
zj varchar(100) comment '租金'
) comment '合同';
举报表创建语句如下：
create table t_jb(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
jbName varchar(100) comment '举报内容'
) comment '举报';
订单表创建语句如下：
create table t_order(
id int primary key auto_increment comment '主键',
fyId int comment '房源',
customerId int comment '用户',
orderName varchar(100) comment '订单编号',
status varchar(100) comment '',
content varchar(100) comment ''
) comment '订单';
评价表创建语句如下：
create table t_pj(
id int primary key auto_increment comment '主键',
fyId int comment '房源',
customerId int comment '用户',
pj varchar(100) comment '评价',
xj varchar(100) comment '星级'
) comment '评价';
收藏表创建语句如下：
create table t_sc(
id int primary key auto_increment comment '主键',
fyId int comment '房源',
customerId int comment '用户'
) comment '收藏';
合同模板表创建语句如下：
create table t_thmb(
id int primary key auto_increment comment '主键',
htmbName varchar(100) comment '名称',
htmbUrl varchar(100) comment '合同'
) comment '合同模板';
寻租表创建语句如下：
create table t_xqsy(
id int primary key auto_increment comment '主键',
customerId int 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 'QQ',
v7 varchar(100) comment '电话号码'
) comment '寻租';
预约表创建语句如下：
create table t_yy(
id int primary key auto_increment comment '主键',
fyId int comment '房源',
customerId int comment '用户',
yyDate varchar(100) comment '预约日期'
) comment '预约';
基于JSP的房屋出租管理系统系统设计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),
name varchar(100),
phone varchar(100),
sex varchar(100),
age 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.name is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.sex is '性别';
comment on column t_customer.age is '年龄';
--客户表加注释
comment on table t_customer is '客户';
分类表创建语句如下：
create table t_fl(
id integer,
flName varchar(100)
);
--分类字段加注释
comment on column t_fl.id is '主键';
comment on column t_fl.flName is '分类';
--分类表加注释
comment on table t_fl is '分类';
房源表创建语句如下：
create table t_fy(
id integer,
adminId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 varchar(100),
flId int
);
--房源字段加注释
comment on column t_fy.id is '主键';
comment on column t_fy.adminId is '录入人';
comment on column t_fy.v1 is '户型';
comment on column t_fy.v2 is '配套设备';
comment on column t_fy.v3 is '位置';
comment on column t_fy.v4 is '租金';
comment on column t_fy.v5 is '图片一';
comment on column t_fy.v6 is '图片二';
comment on column t_fy.v7 is '图片三';
comment on column t_fy.flId is '分类';
--房源表加注释
comment on table t_fy is '房源';
合同表创建语句如下：
create table t_ht(
id integer,
htName varchar(100),
fyId int,
customerId int,
htBeginDate varchar(100),
htEndDate varchar(100),
htUrl varchar(100),
dj varchar(100),
zj varchar(100)
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.htName is '';
comment on column t_ht.fyId is '房源';
comment on column t_ht.customerId is '客户';
comment on column t_ht.htBeginDate is '合同开始时间';
comment on column t_ht.htEndDate is '合同结束时间';
comment on column t_ht.htUrl is '合同';
comment on column t_ht.dj is '定金';
comment on column t_ht.zj is '租金';
--合同表加注释
comment on table t_ht is '合同';
举报表创建语句如下：
create table t_jb(
id integer,
customerId int,
jbName varchar(100)
);
--举报字段加注释
comment on column t_jb.id is '主键';
comment on column t_jb.customerId is '用户';
comment on column t_jb.jbName is '举报内容';
--举报表加注释
comment on table t_jb is '举报';
订单表创建语句如下：
create table t_order(
id integer,
fyId int,
customerId int,
orderName varchar(100),
status varchar(100),
content varchar(100)
);
--订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.fyId is '房源';
comment on column t_order.customerId is '用户';
comment on column t_order.orderName is '订单编号';
comment on column t_order.status is '';
comment on column t_order.content is '';
--订单表加注释
comment on table t_order is '订单';
评价表创建语句如下：
create table t_pj(
id integer,
fyId int,
customerId int,
pj varchar(100),
xj varchar(100)
);
--评价字段加注释
comment on column t_pj.id is '主键';
comment on column t_pj.fyId is '房源';
comment on column t_pj.customerId is '用户';
comment on column t_pj.pj is '评价';
comment on column t_pj.xj is '星级';
--评价表加注释
comment on table t_pj is '评价';
收藏表创建语句如下：
create table t_sc(
id integer,
fyId int,
customerId int
);
--收藏字段加注释
comment on column t_sc.id is '主键';
comment on column t_sc.fyId is '房源';
comment on column t_sc.customerId is '用户';
--收藏表加注释
comment on table t_sc is '收藏';
合同模板表创建语句如下：
create table t_thmb(
id integer,
htmbName varchar(100),
htmbUrl varchar(100)
);
--合同模板字段加注释
comment on column t_thmb.id is '主键';
comment on column t_thmb.htmbName is '名称';
comment on column t_thmb.htmbUrl is '合同';
--合同模板表加注释
comment on table t_thmb is '合同模板';
寻租表创建语句如下：
create table t_xqsy(
id integer,
customerId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 varchar(100)
);
--寻租字段加注释
comment on column t_xqsy.id is '主键';
comment on column t_xqsy.customerId is '用户';
comment on column t_xqsy.v1 is '星座';
comment on column t_xqsy.v2 is '生肖';
comment on column t_xqsy.v3 is '年龄';
comment on column t_xqsy.v4 is '性别';
comment on column t_xqsy.v5 is '籍贯';
comment on column t_xqsy.v6 is 'QQ';
comment on column t_xqsy.v7 is '电话号码';
--寻租表加注释
comment on table t_xqsy is '寻租';
预约表创建语句如下：
create table t_yy(
id integer,
fyId int,
customerId int,
yyDate varchar(100)
);
--预约字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.fyId is '房源';
comment on column t_yy.customerId is '用户';
comment on column t_yy.yyDate is '预约日期';
--预约表加注释
comment on table t_yy is '预约';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_fl;
create sequence s_t_fy;
create sequence s_t_ht;
create sequence s_t_jb;
create sequence s_t_order;
create sequence s_t_pj;
create sequence s_t_sc;
create sequence s_t_thmb;
create sequence s_t_xqsy;
create sequence s_t_yy;
基于JSP的房屋出租管理系统系统设计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),--密码
name varchar(100),--姓名
phone varchar(100),--电话
sex varchar(100),--性别
age varchar(100)--年龄
);
分类表创建语句如下：
--分类表注释
create table t_fl(
id int identity(1,1) primary key not null,--主键
flName varchar(100)--分类
);
房源表创建语句如下：
--房源表注释
create table t_fy(
id int identity(1,1) primary key not null,--主键
adminId int,--录入人
v1 varchar(100),--户型
v2 varchar(100),--配套设备
v3 varchar(100),--位置
v4 varchar(100),--租金
v5 varchar(100),--图片一
v6 varchar(100),--图片二
v7 varchar(100),--图片三
flId int--分类
);
合同表创建语句如下：
--合同表注释
create table t_ht(
id int identity(1,1) primary key not null,--主键
htName varchar(100),--
fyId int,--房源
customerId int,--客户
htBeginDate varchar(100),--合同开始时间
htEndDate varchar(100),--合同结束时间
htUrl varchar(100),--合同
dj varchar(100),--定金
zj varchar(100)--租金
);
举报表创建语句如下：
--举报表注释
create table t_jb(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
jbName varchar(100)--举报内容
);
订单表创建语句如下：
--订单表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
fyId int,--房源
customerId int,--用户
orderName varchar(100),--订单编号
status varchar(100),--
content varchar(100)--
);
评价表创建语句如下：
--评价表注释
create table t_pj(
id int identity(1,1) primary key not null,--主键
fyId int,--房源
customerId int,--用户
pj varchar(100),--评价
xj varchar(100)--星级
);
收藏表创建语句如下：
--收藏表注释
create table t_sc(
id int identity(1,1) primary key not null,--主键
fyId int,--房源
customerId int--用户
);
合同模板表创建语句如下：
--合同模板表注释
create table t_thmb(
id int identity(1,1) primary key not null,--主键
htmbName varchar(100),--名称
htmbUrl varchar(100)--合同
);
寻租表创建语句如下：
--寻租表注释
create table t_xqsy(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
v1 varchar(100),--星座
v2 varchar(100),--生肖
v3 varchar(100),--年龄
v4 varchar(100),--性别
v5 varchar(100),--籍贯
v6 varchar(100),--QQ
v7 varchar(100)--电话号码
);
预约表创建语句如下：
--预约表注释
create table t_yy(
id int identity(1,1) primary key not null,--主键
fyId int,--房源
customerId int,--用户
yyDate varchar(100)--预约日期
);
登录后主页.jpg?x-oss-process=style/00001)
基于JSP的房屋出租管理系统系统设计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 name;
//电话
private String phone;
//性别
private String sex;
//年龄
private String age;
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 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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
}分类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_fl")
public class Fl {
//主键
@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 flName;
public String getFlName() {return flName;}
public void setFlName(String flName) {this.flName = flName;}
}房源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_fy")
public class Fy {
//主键
@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 Integer adminId;
//户型
private String v1;
//配套设备
private String v2;
//位置
private String v3;
//租金
private String v4;
//图片一
private String v5;
//图片二
private String v6;
//图片三
private String v7;
//分类
private Integer flId;
public Integer getAdminId() {return adminId;}
public void setAdminId(Integer adminId) {this.adminId = adminId;}
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;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
}合同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 Integer fyId;
//客户
private Integer customerId;
//合同开始时间
private String htBeginDate;
//合同结束时间
private String htEndDate;
//合同
private String htUrl;
//定金
private String dj;
//租金
private String zj;
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getHtBeginDate() {return htBeginDate;}
public void setHtBeginDate(String htBeginDate) {this.htBeginDate = htBeginDate;}
public String getHtEndDate() {return htEndDate;}
public void setHtEndDate(String htEndDate) {this.htEndDate = htEndDate;}
public String getHtUrl() {return htUrl;}
public void setHtUrl(String htUrl) {this.htUrl = htUrl;}
public String getDj() {return dj;}
public void setDj(String dj) {this.dj = dj;}
public String getZj() {return zj;}
public void setZj(String zj) {this.zj = zj;}
}举报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_jb")
public class Jb {
//主键
@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 Integer customerId;
//举报内容
private String jbName;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getJbName() {return jbName;}
public void setJbName(String jbName) {this.jbName = jbName;}
}订单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 Integer fyId;
//用户
private Integer customerId;
//订单编号
private String orderName;
//
private String status;
//
private String content;
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getOrderName() {return orderName;}
public void setOrderName(String orderName) {this.orderName = orderName;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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_pj")
public class Pj {
//主键
@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 Integer fyId;
//用户
private Integer customerId;
//评价
private String pj;
//星级
private String xj;
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
public String getXj() {return xj;}
public void setXj(String xj) {this.xj = xj;}
}收藏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_sc")
public class Sc {
//主键
@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 Integer fyId;
//用户
private Integer customerId;
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}合同模板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_thmb")
public class Thmb {
//主键
@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 htmbName;
//合同
private String htmbUrl;
public String getHtmbName() {return htmbName;}
public void setHtmbName(String htmbName) {this.htmbName = htmbName;}
public String getHtmbUrl() {return htmbUrl;}
public void setHtmbUrl(String htmbUrl) {this.htmbUrl = htmbUrl;}
}寻租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_xqsy")
public class Xqsy {
//主键
@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 Integer customerId;
//星座
private String v1;
//生肖
private String v2;
//年龄
private String v3;
//性别
private String v4;
//籍贯
private String v5;
//QQ
private String v6;
//电话号码
private String v7;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}预约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_yy")
public class Yy {
//主键
@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 Integer fyId;
//用户
private Integer customerId;
//预约日期
private String yyDate;
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYyDate() {return yyDate;}
public void setYyDate(String yyDate) {this.yyDate = yyDate;}
}基于JSP的房屋出租管理系统系统设计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 name;
//电话
private String phone;
//性别
private String sex;
//年龄
private String age;
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 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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
}分类javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//分类
public class Fl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//分类
private String flName;
public String getFlName() {return flName;}
public void setFlName(String flName) {this.flName = flName;}
}房源javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//房源
public class Fy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//录入人
private Integer adminId;
//户型
private String v1;
//配套设备
private String v2;
//位置
private String v3;
//租金
private String v4;
//图片一
private String v5;
//图片二
private String v6;
//图片三
private String v7;
//分类
private Integer flId;
public Integer getAdminId() {return adminId;}
public void setAdminId(Integer adminId) {this.adminId = adminId;}
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;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public Integer getFlId() {return flId;}
public void setFlId(Integer flId) {this.flId = flId;}
}合同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 Integer fyId;
//客户
private Integer customerId;
//合同开始时间
private String htBeginDate;
//合同结束时间
private String htEndDate;
//合同
private String htUrl;
//定金
private String dj;
//租金
private String zj;
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getHtBeginDate() {return htBeginDate;}
public void setHtBeginDate(String htBeginDate) {this.htBeginDate = htBeginDate;}
public String getHtEndDate() {return htEndDate;}
public void setHtEndDate(String htEndDate) {this.htEndDate = htEndDate;}
public String getHtUrl() {return htUrl;}
public void setHtUrl(String htUrl) {this.htUrl = htUrl;}
public String getDj() {return dj;}
public void setDj(String dj) {this.dj = dj;}
public String getZj() {return zj;}
public void setZj(String zj) {this.zj = zj;}
}举报javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//举报
public class Jb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//举报内容
private String jbName;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getJbName() {return jbName;}
public void setJbName(String jbName) {this.jbName = jbName;}
}订单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 Integer fyId;
//用户
private Integer customerId;
//订单编号
private String orderName;
//
private String status;
//
private String content;
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getOrderName() {return orderName;}
public void setOrderName(String orderName) {this.orderName = orderName;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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 Pj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//房源
private Integer fyId;
//用户
private Integer customerId;
//评价
private String pj;
//星级
private String xj;
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
public String getXj() {return xj;}
public void setXj(String xj) {this.xj = xj;}
}收藏javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//收藏
public class Sc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//房源
private Integer fyId;
//用户
private Integer customerId;
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}合同模板javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//合同模板
public class Thmb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String htmbName;
//合同
private String htmbUrl;
public String getHtmbName() {return htmbName;}
public void setHtmbName(String htmbName) {this.htmbName = htmbName;}
public String getHtmbUrl() {return htmbUrl;}
public void setHtmbUrl(String htmbUrl) {this.htmbUrl = htmbUrl;}
}寻租javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//寻租
public class Xqsy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//星座
private String v1;
//生肖
private String v2;
//年龄
private String v3;
//性别
private String v4;
//籍贯
private String v5;
//QQ
private String v6;
//电话号码
private String v7;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}预约javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//预约
public class Yy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//房源
private Integer fyId;
//用户
private Integer customerId;
//预约日期
private String yyDate;
public Integer getFyId() {return fyId;}
public void setFyId(Integer fyId) {this.fyId = fyId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYyDate() {return yyDate;}
public void setYyDate(String yyDate) {this.yyDate = yyDate;}
}