- 公寓管理系统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_baoxiu(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
ssId int comment '宿舍',
insertDate datetime comment '报修时间',
v1 varchar(100) comment '简单说明',
v2 varchar(100) comment '详细问题',
v3 varchar(100) comment '图片',
status varchar(100) comment '状态',
back 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
ssId int comment '宿舍',
status varchar(100) comment '状态'
) comment '用户';
公寓设备表创建语句如下：
create table t_gysb(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '设备名称',
v2 varchar(100) comment '设备位置',
v3 varchar(100) comment '设备作用',
v4 varchar(100) comment '负责人',
status varchar(100) comment '状态'
) comment '公寓设备';
宿舍检查表创建语句如下：
create table t_jiancha(
id int primary key auto_increment comment '主键',
ssId int comment '宿舍',
jianchaDate datetime comment '检查时间',
v1 varchar(100) comment '检查人',
v2 varchar(100) comment '备注',
status varchar(100) comment '是否违规'
) comment '宿舍检查';
宿舍缴费表创建语句如下：
create table t_jiaofei(
id int primary key auto_increment comment '主键',
ssId int comment '宿舍',
types varchar(100) comment '缴费类型',
fee int comment '缴费金额',
content varchar(100) comment '费用说明',
showDate varchar(100) comment '缴费月份',
status varchar(100) comment '状态'
) comment '宿舍缴费';
来访登记表创建语句如下：
create table t_lfdj(
id int primary key auto_increment comment '主键',
customerName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
sex varchar(100) comment '性别',
ssId int comment '到访宿舍',
beginDate datetime comment '到访时间',
endDate datetime comment '结束时间',
remark varchar(100) comment '备注'
) comment '来访登记';
公寓设备保养表创建语句如下：
create table t_sbby(
id int primary key auto_increment comment '主键',
gysbId int comment '设备',
a1 varchar(100) comment '保养编号',
a2 varchar(100) comment '保养人',
a3 datetime comment '保养时间',
a4 varchar(100) comment '备注'
) comment '公寓设备保养';
宿舍表创建语句如下：
create table t_ss(
id int primary key auto_increment comment '主键',
ssName varchar(100) comment '宿舍编号',
ssWz varchar(100) comment '宿舍位置'
) comment '宿舍';
公寓通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '说明',
showDate datetime comment '时间'
) comment '公寓通知';
退宿调宿表创建语句如下：
create table t_tsts(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
v1 varchar(100) comment '退宿调宿说明',
v2 varchar(100) comment '原有宿舍编号',
v3 varchar(100) comment '当前宿舍编号',
showDate datetime 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex 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_baoxiu(
id integer,
customerId int,
ssId int,
insertDate datetime,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
status varchar(100),
back varchar(100)
);
--宿舍报修字段加注释
comment on column t_baoxiu.id is '主键';
comment on column t_baoxiu.customerId is '用户';
comment on column t_baoxiu.ssId is '宿舍';
comment on column t_baoxiu.insertDate is '报修时间';
comment on column t_baoxiu.v1 is '简单说明';
comment on column t_baoxiu.v2 is '详细问题';
comment on column t_baoxiu.v3 is '图片';
comment on column t_baoxiu.status is '状态';
comment on column t_baoxiu.back is '维修说明';
--宿舍报修表加注释
comment on table t_baoxiu is '宿舍报修';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
ssId int,
status 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.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.ssId is '宿舍';
comment on column t_customer.status is '状态';
--用户表加注释
comment on table t_customer is '用户';
公寓设备表创建语句如下：
create table t_gysb(
id integer,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
status varchar(100)
);
--公寓设备字段加注释
comment on column t_gysb.id is '主键';
comment on column t_gysb.v1 is '设备名称';
comment on column t_gysb.v2 is '设备位置';
comment on column t_gysb.v3 is '设备作用';
comment on column t_gysb.v4 is '负责人';
comment on column t_gysb.status is '状态';
--公寓设备表加注释
comment on table t_gysb is '公寓设备';
宿舍检查表创建语句如下：
create table t_jiancha(
id integer,
ssId int,
jianchaDate datetime,
v1 varchar(100),
v2 varchar(100),
status varchar(100)
);
--宿舍检查字段加注释
comment on column t_jiancha.id is '主键';
comment on column t_jiancha.ssId is '宿舍';
comment on column t_jiancha.jianchaDate is '检查时间';
comment on column t_jiancha.v1 is '检查人';
comment on column t_jiancha.v2 is '备注';
comment on column t_jiancha.status is '是否违规';
--宿舍检查表加注释
comment on table t_jiancha is '宿舍检查';
宿舍缴费表创建语句如下：
create table t_jiaofei(
id integer,
ssId int,
types varchar(100),
fee int,
content varchar(100),
showDate varchar(100),
status varchar(100)
);
--宿舍缴费字段加注释
comment on column t_jiaofei.id is '主键';
comment on column t_jiaofei.ssId is '宿舍';
comment on column t_jiaofei.types is '缴费类型';
comment on column t_jiaofei.fee is '缴费金额';
comment on column t_jiaofei.content is '费用说明';
comment on column t_jiaofei.showDate is '缴费月份';
comment on column t_jiaofei.status is '状态';
--宿舍缴费表加注释
comment on table t_jiaofei is '宿舍缴费';
来访登记表创建语句如下：
create table t_lfdj(
id integer,
customerName varchar(100),
phone varchar(100),
sex varchar(100),
ssId int,
beginDate datetime,
endDate datetime,
remark varchar(100)
);
--来访登记字段加注释
comment on column t_lfdj.id is '主键';
comment on column t_lfdj.customerName is '姓名';
comment on column t_lfdj.phone is '电话';
comment on column t_lfdj.sex is '性别';
comment on column t_lfdj.ssId is '到访宿舍';
comment on column t_lfdj.beginDate is '到访时间';
comment on column t_lfdj.endDate is '结束时间';
comment on column t_lfdj.remark is '备注';
--来访登记表加注释
comment on table t_lfdj is '来访登记';
公寓设备保养表创建语句如下：
create table t_sbby(
id integer,
gysbId int,
a1 varchar(100),
a2 varchar(100),
a3 datetime,
a4 varchar(100)
);
--公寓设备保养字段加注释
comment on column t_sbby.id is '主键';
comment on column t_sbby.gysbId is '设备';
comment on column t_sbby.a1 is '保养编号';
comment on column t_sbby.a2 is '保养人';
comment on column t_sbby.a3 is '保养时间';
comment on column t_sbby.a4 is '备注';
--公寓设备保养表加注释
comment on table t_sbby is '公寓设备保养';
宿舍表创建语句如下：
create table t_ss(
id integer,
ssName varchar(100),
ssWz varchar(100)
);
--宿舍字段加注释
comment on column t_ss.id is '主键';
comment on column t_ss.ssName is '宿舍编号';
comment on column t_ss.ssWz is '宿舍位置';
--宿舍表加注释
comment on table t_ss is '宿舍';
公寓通知表创建语句如下：
create table t_tongzhi(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
--公寓通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.pic is '图片';
comment on column t_tongzhi.content is '说明';
comment on column t_tongzhi.showDate is '时间';
--公寓通知表加注释
comment on table t_tongzhi is '公寓通知';
退宿调宿表创建语句如下：
create table t_tsts(
id integer,
customerId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
showDate datetime
);
--退宿调宿字段加注释
comment on column t_tsts.id is '主键';
comment on column t_tsts.customerId is '用户';
comment on column t_tsts.v1 is '退宿调宿说明';
comment on column t_tsts.v2 is '原有宿舍编号';
comment on column t_tsts.v3 is '当前宿舍编号';
comment on column t_tsts.showDate is '操作时间';
--退宿调宿表加注释
comment on table t_tsts is '退宿调宿';
维修管理员表创建语句如下：
create table t_wxadmin(
id integer,
username varchar(100),
password varchar(100),
wxadminName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex 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.headPic is '头像';
comment on column t_wxadmin.phone is '电话';
comment on column t_wxadmin.age is '年龄';
comment on column t_wxadmin.sex is '性别';
--维修管理员表加注释
comment on table t_wxadmin is '维修管理员';
oracle特有，对应序列如下：
create sequence s_t_baoxiu;
create sequence s_t_customer;
create sequence s_t_gysb;
create sequence s_t_jiancha;
create sequence s_t_jiaofei;
create sequence s_t_lfdj;
create sequence s_t_sbby;
create sequence s_t_ss;
create sequence s_t_tongzhi;
create sequence s_t_tsts;
create sequence s_t_wxadmin;
公寓管理系统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_baoxiu(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
ssId int,--宿舍
insertDate datetime,--报修时间
v1 varchar(100),--简单说明
v2 varchar(100),--详细问题
v3 varchar(100),--图片
status varchar(100),--状态
back varchar(100)--维修说明
);
用户表创建语句如下：
--用户表注释
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),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
ssId int,--宿舍
status varchar(100)--状态
);
公寓设备表创建语句如下：
--公寓设备表注释
create table t_gysb(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--设备名称
v2 varchar(100),--设备位置
v3 varchar(100),--设备作用
v4 varchar(100),--负责人
status varchar(100)--状态
);
宿舍检查表创建语句如下：
--宿舍检查表注释
create table t_jiancha(
id int identity(1,1) primary key not null,--主键
ssId int,--宿舍
jianchaDate datetime,--检查时间
v1 varchar(100),--检查人
v2 varchar(100),--备注
status varchar(100)--是否违规
);
宿舍缴费表创建语句如下：
--宿舍缴费表注释
create table t_jiaofei(
id int identity(1,1) primary key not null,--主键
ssId int,--宿舍
types varchar(100),--缴费类型
fee int,--缴费金额
content varchar(100),--费用说明
showDate varchar(100),--缴费月份
status varchar(100)--状态
);
来访登记表创建语句如下：
--来访登记表注释
create table t_lfdj(
id int identity(1,1) primary key not null,--主键
customerName varchar(100),--姓名
phone varchar(100),--电话
sex varchar(100),--性别
ssId int,--到访宿舍
beginDate datetime,--到访时间
endDate datetime,--结束时间
remark varchar(100)--备注
);
公寓设备保养表创建语句如下：
--公寓设备保养表注释
create table t_sbby(
id int identity(1,1) primary key not null,--主键
gysbId int,--设备
a1 varchar(100),--保养编号
a2 varchar(100),--保养人
a3 datetime,--保养时间
a4 varchar(100)--备注
);
宿舍表创建语句如下：
--宿舍表注释
create table t_ss(
id int identity(1,1) primary key not null,--主键
ssName varchar(100),--宿舍编号
ssWz varchar(100)--宿舍位置
);
公寓通知表创建语句如下：
--公寓通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--说明
showDate datetime--时间
);
退宿调宿表创建语句如下：
--退宿调宿表注释
create table t_tsts(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
v1 varchar(100),--退宿调宿说明
v2 varchar(100),--原有宿舍编号
v3 varchar(100),--当前宿舍编号
showDate datetime--操作时间
);
维修管理员表创建语句如下：
--维修管理员表注释
create table t_wxadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
wxadminName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex 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_baoxiu")
public class Baoxiu {
//主键
@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 ssId;
//报修时间
private Date insertDate;
//简单说明
private String v1;
//详细问题
private String v2;
//图片
private String v3;
//状态
private String status;
//维修说明
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}用户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 phone;
//年龄
private String age;
//性别
private String sex;
//宿舍
private Integer ssId;
//状态
private String status;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
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_gysb")
public class Gysb {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称
private String v1;
//设备位置
private String v2;
//设备作用
private String v3;
//负责人
private String v4;
//状态
private String status;
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 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_jiancha")
public class Jiancha {
//主键
@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 ssId;
//检查时间
private Date jianchaDate;
//检查人
private String v1;
//备注
private String v2;
//是否违规
private String status;
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
public Date getJianchaDate() {return jianchaDate;}
public void setJianchaDate(Date jianchaDate) {this.jianchaDate = jianchaDate;}
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 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_jiaofei")
public class Jiaofei {
//主键
@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 ssId;
//缴费类型
private String types;
//缴费金额
private Integer fee;
//费用说明
private String content;
//缴费月份
private String showDate;
//状态
private String status;
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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_lfdj")
public class Lfdj {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String customerName;
//电话
private String phone;
//性别
private String sex;
//到访宿舍
private Integer ssId;
//到访时间
private Date beginDate;
//结束时间
private Date endDate;
//备注
private String remark;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
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 String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}公寓设备保养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_sbby")
public class Sbby {
//主键
@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 gysbId;
//保养编号
private String a1;
//保养人
private String a2;
//保养时间
private Date a3;
//备注
private String a4;
public Integer getGysbId() {return gysbId;}
public void setGysbId(Integer gysbId) {this.gysbId = gysbId;}
public String getA1() {return a1;}
public void setA1(String a1) {this.a1 = a1;}
public String getA2() {return a2;}
public void setA2(String a2) {this.a2 = a2;}
public Date getA3() {return a3;}
public void setA3(Date a3) {this.a3 = a3;}
public String getA4() {return a4;}
public void setA4(String a4) {this.a4 = a4;}
}宿舍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_ss")
public class Ss {
//主键
@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 ssName;
//宿舍位置
private String ssWz;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public String getSsWz() {return ssWz;}
public void setSsWz(String ssWz) {this.ssWz = ssWz;}
}公寓通知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_tongzhi")
public class Tongzhi {
//主键
@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 title;
//图片
private String pic;
//说明
private String content;
//时间
private Date showDate;
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 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_tsts")
public class Tsts {
//主键
@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 Date showDate;
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 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_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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}公寓管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
宿舍报修javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//宿舍报修
public class Baoxiu extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//宿舍
private Integer ssId;
//报修时间
private Date insertDate;
//简单说明
private String v1;
//详细问题
private String v2;
//图片
private String v3;
//状态
private String status;
//维修说明
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}用户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 phone;
//年龄
private String age;
//性别
private String sex;
//宿舍
private Integer ssId;
//状态
private String status;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
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 Gysb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称
private String v1;
//设备位置
private String v2;
//设备作用
private String v3;
//负责人
private String v4;
//状态
private String status;
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 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 Jiancha extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宿舍
private Integer ssId;
//检查时间
private Date jianchaDate;
//检查人
private String v1;
//备注
private String v2;
//是否违规
private String status;
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
public Date getJianchaDate() {return jianchaDate;}
public void setJianchaDate(Date jianchaDate) {this.jianchaDate = jianchaDate;}
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 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 Jiaofei extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宿舍
private Integer ssId;
//缴费类型
private String types;
//缴费金额
private Integer fee;
//费用说明
private String content;
//缴费月份
private String showDate;
//状态
private String status;
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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 Lfdj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String customerName;
//电话
private String phone;
//性别
private String sex;
//到访宿舍
private Integer ssId;
//到访时间
private Date beginDate;
//结束时间
private Date endDate;
//备注
private String remark;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
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 String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}公寓设备保养javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公寓设备保养
public class Sbby extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备
private Integer gysbId;
//保养编号
private String a1;
//保养人
private String a2;
//保养时间
private Date a3;
//备注
private String a4;
public Integer getGysbId() {return gysbId;}
public void setGysbId(Integer gysbId) {this.gysbId = gysbId;}
public String getA1() {return a1;}
public void setA1(String a1) {this.a1 = a1;}
public String getA2() {return a2;}
public void setA2(String a2) {this.a2 = a2;}
public Date getA3() {return a3;}
public void setA3(Date a3) {this.a3 = a3;}
public String getA4() {return a4;}
public void setA4(String a4) {this.a4 = a4;}
}宿舍javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//宿舍
public class Ss extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宿舍编号
private String ssName;
//宿舍位置
private String ssWz;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public String getSsWz() {return ssWz;}
public void setSsWz(String ssWz) {this.ssWz = ssWz;}
}公寓通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公寓通知
public class Tongzhi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//说明
private String content;
//时间
private Date showDate;
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 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 Tsts 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 Date showDate;
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 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 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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}