- 社区服务管理系统mysql数据库创建语句
- 社区服务管理系统oracle数据库创建语句
- 社区服务管理系统sqlserver数据库创建语句
- 社区服务管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 社区服务管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
社区服务管理系统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_bx(
id int primary key auto_increment comment '主键',
customerId int comment '业主',
title varchar(100) comment '报修标题',
pic varchar(100) comment '图片',
content varchar(100) comment '详细说明',
address varchar(100) comment '住宅地址',
lxr varchar(100) comment '联系人',
lxdh varchar(100) comment '联系电话',
insertDate datetime comment '报修日期',
wxr varchar(100) comment '维修人',
shcd varchar(100) comment '损坏程度',
fee varchar(100) comment '费用',
jg varchar(100) comment '结果',
status varchar(100) comment '状态'
) comment '报修';
业主表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
email varchar(100) comment '邮箱',
phone varchar(100) comment '电话',
zz varchar(100) comment '住址'
) comment '业主';
房屋出租表创建语句如下：
create table t_fwcz(
id int primary key auto_increment comment '主键',
types varchar(100) comment '发布类型',
customerId int comment '业主',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '详细说明',
address varchar(100) comment '房屋地址',
lxr varchar(100) comment '联系人',
lxdh varchar(100) comment '联系电话',
insertDate datetime comment '发布日期'
) comment '房屋出租';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
pic varchar(100) comment '图片',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
缴费表创建语句如下：
create table t_jf(
id int primary key auto_increment comment '主键',
customerId int comment '业主',
title varchar(100) comment '缴费项目',
fee int comment '缴费金额',
pic varchar(100) comment '图片',
content varchar(100) comment '详细说明',
address varchar(100) comment '住宅地址',
showDate datetime comment '费用日期'
) comment '缴费';
老人表创建语句如下：
create table t_laoren(
id int primary key auto_increment comment '主键',
laorenName varchar(100) comment '姓名',
sex varchar(100) comment '性别',
age varchar(100) comment '年龄',
phone varchar(100) comment '电话',
birthday varchar(100) comment '生日',
jb varchar(100) comment '历史疾病',
headPic varchar(100) comment '头像',
jjlxr varchar(100) comment '紧急联系人',
jjlxdh varchar(100) comment '紧急联系电话',
qtbz varchar(100) comment '其他备注'
) comment '老人';
楼房表创建语句如下：
create table t_lf(
id int primary key auto_increment comment '主键',
lfName varchar(100) comment '楼房编号',
rs varchar(100) comment '入住人数',
wz varchar(100) comment '位置',
content varchar(100) comment '备注'
) comment '楼房';
老人服务表创建语句如下：
create table t_lrfw(
id int primary key auto_increment comment '主键',
customerId int comment '业主',
laorenId int comment '老人',
title varchar(100) comment '说明',
insertDate datetime comment '发起日期',
yladminId int comment '医疗人员',
content varchar(100) comment '治疗备注',
pf varchar(100) comment '评分',
pj 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 '密码',
ptadmin varchar(100) comment '姓名',
email varchar(100) comment '邮箱',
phone varchar(100) comment '电话'
) comment '普通管理员';
维修人员表创建语句如下：
create table t_wxadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
wxadminName varchar(100) comment '姓名',
email varchar(100) comment '邮箱',
phone varchar(100) comment '电话'
) comment '维修人员';
物业员工表创建语句如下：
create table t_wyyg(
id int primary key auto_increment comment '主键',
xm varchar(100) comment '姓名',
sj varchar(100) comment '手机号',
xb varchar(100) comment '性别',
zz varchar(100) comment '职责',
sfz varchar(100) comment '身份证',
pic varchar(100) comment '头像'
) comment '物业员工';
医疗人员表创建语句如下：
create table t_yladmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
yladminName varchar(100) comment '姓名',
email varchar(100) comment '邮箱',
phone varchar(100) 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_bx(
id integer,
customerId int,
title varchar(100),
pic varchar(100),
content varchar(100),
address varchar(100),
lxr varchar(100),
lxdh varchar(100),
insertDate datetime,
wxr varchar(100),
shcd varchar(100),
fee varchar(100),
jg varchar(100),
status varchar(100)
);
--报修字段加注释
comment on column t_bx.id is '主键';
comment on column t_bx.customerId is '业主';
comment on column t_bx.title is '报修标题';
comment on column t_bx.pic is '图片';
comment on column t_bx.content is '详细说明';
comment on column t_bx.address is '住宅地址';
comment on column t_bx.lxr is '联系人';
comment on column t_bx.lxdh is '联系电话';
comment on column t_bx.insertDate is '报修日期';
comment on column t_bx.wxr is '维修人';
comment on column t_bx.shcd is '损坏程度';
comment on column t_bx.fee is '费用';
comment on column t_bx.jg is '结果';
comment on column t_bx.status is '状态';
--报修表加注释
comment on table t_bx is '报修';
业主表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
email varchar(100),
phone varchar(100),
zz 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.email is '邮箱';
comment on column t_customer.phone is '电话';
comment on column t_customer.zz is '住址';
--业主表加注释
comment on table t_customer is '业主';
房屋出租表创建语句如下：
create table t_fwcz(
id integer,
types varchar(100),
customerId int,
title varchar(100),
pic varchar(100),
content varchar(100),
address varchar(100),
lxr varchar(100),
lxdh varchar(100),
insertDate datetime
);
--房屋出租字段加注释
comment on column t_fwcz.id is '主键';
comment on column t_fwcz.types is '发布类型';
comment on column t_fwcz.customerId is '业主';
comment on column t_fwcz.title is '标题';
comment on column t_fwcz.pic is '图片';
comment on column t_fwcz.content is '详细说明';
comment on column t_fwcz.address is '房屋地址';
comment on column t_fwcz.lxr is '联系人';
comment on column t_fwcz.lxdh is '联系电话';
comment on column t_fwcz.insertDate is '发布日期';
--房屋出租表加注释
comment on table t_fwcz is '房屋出租';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
pic varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
缴费表创建语句如下：
create table t_jf(
id integer,
customerId int,
title varchar(100),
fee int,
pic varchar(100),
content varchar(100),
address varchar(100),
showDate datetime
);
--缴费字段加注释
comment on column t_jf.id is '主键';
comment on column t_jf.customerId is '业主';
comment on column t_jf.title is '缴费项目';
comment on column t_jf.fee is '缴费金额';
comment on column t_jf.pic is '图片';
comment on column t_jf.content is '详细说明';
comment on column t_jf.address is '住宅地址';
comment on column t_jf.showDate is '费用日期';
--缴费表加注释
comment on table t_jf is '缴费';
老人表创建语句如下：
create table t_laoren(
id integer,
laorenName varchar(100),
sex varchar(100),
age varchar(100),
phone varchar(100),
birthday varchar(100),
jb varchar(100),
headPic varchar(100),
jjlxr varchar(100),
jjlxdh varchar(100),
qtbz varchar(100)
);
--老人字段加注释
comment on column t_laoren.id is '主键';
comment on column t_laoren.laorenName is '姓名';
comment on column t_laoren.sex is '性别';
comment on column t_laoren.age is '年龄';
comment on column t_laoren.phone is '电话';
comment on column t_laoren.birthday is '生日';
comment on column t_laoren.jb is '历史疾病';
comment on column t_laoren.headPic is '头像';
comment on column t_laoren.jjlxr is '紧急联系人';
comment on column t_laoren.jjlxdh is '紧急联系电话';
comment on column t_laoren.qtbz is '其他备注';
--老人表加注释
comment on table t_laoren is '老人';
楼房表创建语句如下：
create table t_lf(
id integer,
lfName varchar(100),
rs varchar(100),
wz varchar(100),
content varchar(100)
);
--楼房字段加注释
comment on column t_lf.id is '主键';
comment on column t_lf.lfName is '楼房编号';
comment on column t_lf.rs is '入住人数';
comment on column t_lf.wz is '位置';
comment on column t_lf.content is '备注';
--楼房表加注释
comment on table t_lf is '楼房';
老人服务表创建语句如下：
create table t_lrfw(
id integer,
customerId int,
laorenId int,
title varchar(100),
insertDate datetime,
yladminId int,
content varchar(100),
pf varchar(100),
pj varchar(100),
status varchar(100)
);
--老人服务字段加注释
comment on column t_lrfw.id is '主键';
comment on column t_lrfw.customerId is '业主';
comment on column t_lrfw.laorenId is '老人';
comment on column t_lrfw.title is '说明';
comment on column t_lrfw.insertDate is '发起日期';
comment on column t_lrfw.yladminId is '医疗人员';
comment on column t_lrfw.content is '治疗备注';
comment on column t_lrfw.pf is '评分';
comment on column t_lrfw.pj is '评语';
comment on column t_lrfw.status is '状态';
--老人服务表加注释
comment on table t_lrfw is '老人服务';
普通管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadmin 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.ptadmin is '姓名';
comment on column t_ptadmin.email is '邮箱';
comment on column t_ptadmin.phone is '电话';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';
维修人员表创建语句如下：
create table t_wxadmin(
id integer,
username varchar(100),
password varchar(100),
wxadminName varchar(100),
email varchar(100),
phone varchar(100)
);
--维修人员字段加注释
comment on column t_wxadmin.id is '主键';
comment on column t_wxadmin.username is '账号';
comment on column t_wxadmin.password is '密码';
comment on column t_wxadmin.wxadminName is '姓名';
comment on column t_wxadmin.email is '邮箱';
comment on column t_wxadmin.phone is '电话';
--维修人员表加注释
comment on table t_wxadmin is '维修人员';
物业员工表创建语句如下：
create table t_wyyg(
id integer,
xm varchar(100),
sj varchar(100),
xb varchar(100),
zz varchar(100),
sfz varchar(100),
pic varchar(100)
);
--物业员工字段加注释
comment on column t_wyyg.id is '主键';
comment on column t_wyyg.xm is '姓名';
comment on column t_wyyg.sj is '手机号';
comment on column t_wyyg.xb is '性别';
comment on column t_wyyg.zz is '职责';
comment on column t_wyyg.sfz is '身份证';
comment on column t_wyyg.pic is '头像';
--物业员工表加注释
comment on table t_wyyg is '物业员工';
医疗人员表创建语句如下：
create table t_yladmin(
id integer,
username varchar(100),
password varchar(100),
yladminName varchar(100),
email varchar(100),
phone varchar(100)
);
--医疗人员字段加注释
comment on column t_yladmin.id is '主键';
comment on column t_yladmin.username is '账号';
comment on column t_yladmin.password is '密码';
comment on column t_yladmin.yladminName is '姓名';
comment on column t_yladmin.email is '邮箱';
comment on column t_yladmin.phone is '电话';
--医疗人员表加注释
comment on table t_yladmin is '医疗人员';
oracle特有，对应序列如下：
create sequence s_t_bx;
create sequence s_t_customer;
create sequence s_t_fwcz;
create sequence s_t_gg;
create sequence s_t_jf;
create sequence s_t_laoren;
create sequence s_t_lf;
create sequence s_t_lrfw;
create sequence s_t_ptadmin;
create sequence s_t_wxadmin;
create sequence s_t_wyyg;
create sequence s_t_yladmin;
社区服务管理系统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_bx(
id int identity(1,1) primary key not null,--主键
customerId int,--业主
title varchar(100),--报修标题
pic varchar(100),--图片
content varchar(100),--详细说明
address varchar(100),--住宅地址
lxr varchar(100),--联系人
lxdh varchar(100),--联系电话
insertDate datetime,--报修日期
wxr varchar(100),--维修人
shcd varchar(100),--损坏程度
fee varchar(100),--费用
jg varchar(100),--结果
status varchar(100)--状态
);
业主表创建语句如下：
--业主表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
email varchar(100),--邮箱
phone varchar(100),--电话
zz varchar(100)--住址
);
房屋出租表创建语句如下：
--房屋出租表注释
create table t_fwcz(
id int identity(1,1) primary key not null,--主键
types varchar(100),--发布类型
customerId int,--业主
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--详细说明
address varchar(100),--房屋地址
lxr varchar(100),--联系人
lxdh varchar(100),--联系电话
insertDate datetime--发布日期
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
pic varchar(100),--图片
showDate datetime,--日期
v3 varchar(100)--内容
);
缴费表创建语句如下：
--缴费表注释
create table t_jf(
id int identity(1,1) primary key not null,--主键
customerId int,--业主
title varchar(100),--缴费项目
fee int,--缴费金额
pic varchar(100),--图片
content varchar(100),--详细说明
address varchar(100),--住宅地址
showDate datetime--费用日期
);
老人表创建语句如下：
--老人表注释
create table t_laoren(
id int identity(1,1) primary key not null,--主键
laorenName varchar(100),--姓名
sex varchar(100),--性别
age varchar(100),--年龄
phone varchar(100),--电话
birthday varchar(100),--生日
jb varchar(100),--历史疾病
headPic varchar(100),--头像
jjlxr varchar(100),--紧急联系人
jjlxdh varchar(100),--紧急联系电话
qtbz varchar(100)--其他备注
);
楼房表创建语句如下：
--楼房表注释
create table t_lf(
id int identity(1,1) primary key not null,--主键
lfName varchar(100),--楼房编号
rs varchar(100),--入住人数
wz varchar(100),--位置
content varchar(100)--备注
);
老人服务表创建语句如下：
--老人服务表注释
create table t_lrfw(
id int identity(1,1) primary key not null,--主键
customerId int,--业主
laorenId int,--老人
title varchar(100),--说明
insertDate datetime,--发起日期
yladminId int,--医疗人员
content varchar(100),--治疗备注
pf varchar(100),--评分
pj varchar(100),--评语
status varchar(100)--状态
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadmin varchar(100),--姓名
email varchar(100),--邮箱
phone varchar(100)--电话
);
维修人员表创建语句如下：
--维修人员表注释
create table t_wxadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
wxadminName varchar(100),--姓名
email varchar(100),--邮箱
phone varchar(100)--电话
);
物业员工表创建语句如下：
--物业员工表注释
create table t_wyyg(
id int identity(1,1) primary key not null,--主键
xm varchar(100),--姓名
sj varchar(100),--手机号
xb varchar(100),--性别
zz varchar(100),--职责
sfz varchar(100),--身份证
pic varchar(100)--头像
);
医疗人员表创建语句如下：
--医疗人员表注释
create table t_yladmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
yladminName varchar(100),--姓名
email varchar(100),--邮箱
phone varchar(100)--电话
);
登录后主页.jpg?x-oss-process=style/00001)
社区服务管理系统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_bx")
public class Bx {
//主键
@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 title;
//图片
private String pic;
//详细说明
private String content;
//住宅地址
private String address;
//联系人
private String lxr;
//联系电话
private String lxdh;
//报修日期
private Date insertDate;
//维修人
private String wxr;
//损坏程度
private String shcd;
//费用
private String fee;
//结果
private String jg;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getWxr() {return wxr;}
public void setWxr(String wxr) {this.wxr = wxr;}
public String getShcd() {return shcd;}
public void setShcd(String shcd) {this.shcd = shcd;}
public String getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public String getJg() {return jg;}
public void setJg(String jg) {this.jg = jg;}
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_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 email;
//电话
private String phone;
//住址
private String zz;
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 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 getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
}房屋出租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_fwcz")
public class Fwcz {
//主键
@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 Integer customerId;
//标题
private String title;
//图片
private String pic;
//详细说明
private String content;
//房屋地址
private String address;
//联系人
private String lxr;
//联系电话
private String lxdh;
//发布日期
private Date insertDate;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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_gg")
public class Gg {
//主键
@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 pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}缴费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_jf")
public class Jf {
//主键
@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 title;
//缴费金额
private Integer fee;
//图片
private String pic;
//详细说明
private String content;
//住宅地址
private String address;
//费用日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}老人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_laoren")
public class Laoren {
//主键
@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 laorenName;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//生日
private String birthday;
//历史疾病
private String jb;
//头像
private String headPic;
//紧急联系人
private String jjlxr;
//紧急联系电话
private String jjlxdh;
//其他备注
private String qtbz;
public String getLaorenName() {return laorenName;}
public void setLaorenName(String laorenName) {this.laorenName = laorenName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getJjlxr() {return jjlxr;}
public void setJjlxr(String jjlxr) {this.jjlxr = jjlxr;}
public String getJjlxdh() {return jjlxdh;}
public void setJjlxdh(String jjlxdh) {this.jjlxdh = jjlxdh;}
public String getQtbz() {return qtbz;}
public void setQtbz(String qtbz) {this.qtbz = qtbz;}
}楼房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_lf")
public class Lf {
//主键
@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 lfName;
//入住人数
private String rs;
//位置
private String wz;
//备注
private String content;
public String getLfName() {return lfName;}
public void setLfName(String lfName) {this.lfName = lfName;}
public String getRs() {return rs;}
public void setRs(String rs) {this.rs = rs;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
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_lrfw")
public class Lrfw {
//主键
@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 Integer laorenId;
//说明
private String title;
//发起日期
private Date insertDate;
//医疗人员
private Integer yladminId;
//治疗备注
private String content;
//评分
private String pf;
//评语
private String pj;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getLaorenId() {return laorenId;}
public void setLaorenId(Integer laorenId) {this.laorenId = laorenId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getYladminId() {return yladminId;}
public void setYladminId(Integer yladminId) {this.yladminId = yladminId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPf() {return pf;}
public void setPf(String pf) {this.pf = pf;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
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 ptadmin;
//邮箱
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 getPtadmin() {return ptadmin;}
public void setPtadmin(String ptadmin) {this.ptadmin = ptadmin;}
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_wxadmin")
public class Wxadmin {
//主键
@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 wxadminName;
//邮箱
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 getWxadminName() {return wxadminName;}
public void setWxadminName(String wxadminName) {this.wxadminName = wxadminName;}
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_wyyg")
public class Wyyg {
//主键
@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 xm;
//手机号
private String sj;
//性别
private String xb;
//职责
private String zz;
//身份证
private String sfz;
//头像
private String pic;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getSj() {return sj;}
public void setSj(String sj) {this.sj = sj;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
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_yladmin")
public class Yladmin {
//主键
@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 yladminName;
//邮箱
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 getYladminName() {return yladminName;}
public void setYladminName(String yladminName) {this.yladminName = yladminName;}
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;}
}社区服务管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
报修javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//报修
public class Bx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//业主
private Integer customerId;
//报修标题
private String title;
//图片
private String pic;
//详细说明
private String content;
//住宅地址
private String address;
//联系人
private String lxr;
//联系电话
private String lxdh;
//报修日期
private Date insertDate;
//维修人
private String wxr;
//损坏程度
private String shcd;
//费用
private String fee;
//结果
private String jg;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getWxr() {return wxr;}
public void setWxr(String wxr) {this.wxr = wxr;}
public String getShcd() {return shcd;}
public void setShcd(String shcd) {this.shcd = shcd;}
public String getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public String getJg() {return jg;}
public void setJg(String jg) {this.jg = jg;}
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 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 email;
//电话
private String phone;
//住址
private String zz;
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 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 getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
}房屋出租javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//房屋出租
public class Fwcz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发布类型
private String types;
//业主
private Integer customerId;
//标题
private String title;
//图片
private String pic;
//详细说明
private String content;
//房屋地址
private String address;
//联系人
private String lxr;
//联系电话
private String lxdh;
//发布日期
private Date insertDate;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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 Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}缴费javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//缴费
public class Jf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//业主
private Integer customerId;
//缴费项目
private String title;
//缴费金额
private Integer fee;
//图片
private String pic;
//详细说明
private String content;
//住宅地址
private String address;
//费用日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}老人javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//老人
public class Laoren extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String laorenName;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//生日
private String birthday;
//历史疾病
private String jb;
//头像
private String headPic;
//紧急联系人
private String jjlxr;
//紧急联系电话
private String jjlxdh;
//其他备注
private String qtbz;
public String getLaorenName() {return laorenName;}
public void setLaorenName(String laorenName) {this.laorenName = laorenName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getJjlxr() {return jjlxr;}
public void setJjlxr(String jjlxr) {this.jjlxr = jjlxr;}
public String getJjlxdh() {return jjlxdh;}
public void setJjlxdh(String jjlxdh) {this.jjlxdh = jjlxdh;}
public String getQtbz() {return qtbz;}
public void setQtbz(String qtbz) {this.qtbz = qtbz;}
}楼房javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//楼房
public class Lf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//楼房编号
private String lfName;
//入住人数
private String rs;
//位置
private String wz;
//备注
private String content;
public String getLfName() {return lfName;}
public void setLfName(String lfName) {this.lfName = lfName;}
public String getRs() {return rs;}
public void setRs(String rs) {this.rs = rs;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
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 Lrfw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//业主
private Integer customerId;
//老人
private Integer laorenId;
//说明
private String title;
//发起日期
private Date insertDate;
//医疗人员
private Integer yladminId;
//治疗备注
private String content;
//评分
private String pf;
//评语
private String pj;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getLaorenId() {return laorenId;}
public void setLaorenId(Integer laorenId) {this.laorenId = laorenId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getYladminId() {return yladminId;}
public void setYladminId(Integer yladminId) {this.yladminId = yladminId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPf() {return pf;}
public void setPf(String pf) {this.pf = pf;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
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 ptadmin;
//邮箱
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 getPtadmin() {return ptadmin;}
public void setPtadmin(String ptadmin) {this.ptadmin = ptadmin;}
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 Wxadmin 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 wxadminName;
//邮箱
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 getWxadminName() {return wxadminName;}
public void setWxadminName(String wxadminName) {this.wxadminName = wxadminName;}
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 Wyyg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String xm;
//手机号
private String sj;
//性别
private String xb;
//职责
private String zz;
//身份证
private String sfz;
//头像
private String pic;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getSj() {return sj;}
public void setSj(String sj) {this.sj = sj;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
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 Yladmin 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 yladminName;
//邮箱
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 getYladminName() {return yladminName;}
public void setYladminName(String yladminName) {this.yladminName = yladminName;}
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;}
}