- 基于SSM的建筑工地设备管控系统mysql数据库创建语句
- 基于SSM的建筑工地设备管控系统oracle数据库创建语句
- 基于SSM的建筑工地设备管控系统sqlserver数据库创建语句
- 基于SSM的建筑工地设备管控系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于SSM的建筑工地设备管控系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于SSM的建筑工地设备管控系统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_ckdj(
id int primary key auto_increment comment '主键',
customerId int comment '管理员',
ckdjName varchar(100) comment '设备名称',
v1 varchar(100) comment '对接人',
v2 varchar(100) comment '出库人',
showDate datetime comment '出库时间',
v3 int comment '数量',
v4 varchar(100) comment '种类',
v5 int comment '价格',
gd varchar(100) comment '工地',
v6 varchar(100) comment '库房',
v7 varchar(100) comment '货架',
remark 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 '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '普通管理员';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
cotnent varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '公告';
入库登记表创建语句如下：
create table t_rkdj(
id int primary key auto_increment comment '主键',
customerId int comment '管理员',
rkdjName varchar(100) comment '设备名称',
v1 varchar(100) comment '对接人',
v2 varchar(100) comment '入库人',
showDate datetime comment '入库时间',
v3 int comment '数量',
v4 varchar(100) comment '种类',
v5 int comment '价格',
gd varchar(100) comment '工地',
v6 varchar(100) comment '库房',
v7 varchar(100) comment '货架',
remark varchar(100) comment '备注'
) comment '入库登记';
上报维修表创建语句如下：
create table t_sbwx(
id int primary key auto_increment comment '主键',
customerId int comment '上报人',
title varchar(100) comment '标题',
insertDate datetime comment '上报时间',
types varchar(100) comment '类型',
pic varchar(100) comment '图片',
status varchar(100) comment '状态',
back varchar(100) comment '回复',
remark varchar(100) comment '备注说明'
) comment '上报维修';
申请设备表创建语句如下：
create table t_sqsb(
id int primary key auto_increment comment '主键',
customerId int comment '上报人',
title varchar(100) comment '标题',
sb varchar(100) comment '设备',
sl int comment '数量',
insertDate datetime comment '申请时间',
status varchar(100) comment '状态',
remark varchar(100) comment '申请说明',
back varchar(100) comment '回复'
) comment '申请设备';
管理员消息表创建语句如下：
create table t_xiaoxi(
id int primary key auto_increment comment '主键',
customerId int comment '管理员',
title varchar(100) comment '标题',
remark varchar(100) comment '内容',
insertDate datetime comment '消息时间'
) comment '管理员消息';
基于SSM的建筑工地设备管控系统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_ckdj(
id integer,
customerId int,
ckdjName varchar(100),
v1 varchar(100),
v2 varchar(100),
showDate datetime,
v3 int,
v4 varchar(100),
v5 int,
gd varchar(100),
v6 varchar(100),
v7 varchar(100),
remark varchar(100)
);
--出库登记字段加注释
comment on column t_ckdj.id is '主键';
comment on column t_ckdj.customerId is '管理员';
comment on column t_ckdj.ckdjName is '设备名称';
comment on column t_ckdj.v1 is '对接人';
comment on column t_ckdj.v2 is '出库人';
comment on column t_ckdj.showDate is '出库时间';
comment on column t_ckdj.v3 is '数量';
comment on column t_ckdj.v4 is '种类';
comment on column t_ckdj.v5 is '价格';
comment on column t_ckdj.gd is '工地';
comment on column t_ckdj.v6 is '库房';
comment on column t_ckdj.v7 is '货架';
comment on column t_ckdj.remark is '备注';
--出库登记表加注释
comment on table t_ckdj is '出库登记';
普通管理员表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex 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.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
--普通管理员表加注释
comment on table t_customer is '普通管理员';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.cotnent is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
入库登记表创建语句如下：
create table t_rkdj(
id integer,
customerId int,
rkdjName varchar(100),
v1 varchar(100),
v2 varchar(100),
showDate datetime,
v3 int,
v4 varchar(100),
v5 int,
gd varchar(100),
v6 varchar(100),
v7 varchar(100),
remark varchar(100)
);
--入库登记字段加注释
comment on column t_rkdj.id is '主键';
comment on column t_rkdj.customerId is '管理员';
comment on column t_rkdj.rkdjName is '设备名称';
comment on column t_rkdj.v1 is '对接人';
comment on column t_rkdj.v2 is '入库人';
comment on column t_rkdj.showDate is '入库时间';
comment on column t_rkdj.v3 is '数量';
comment on column t_rkdj.v4 is '种类';
comment on column t_rkdj.v5 is '价格';
comment on column t_rkdj.gd is '工地';
comment on column t_rkdj.v6 is '库房';
comment on column t_rkdj.v7 is '货架';
comment on column t_rkdj.remark is '备注';
--入库登记表加注释
comment on table t_rkdj is '入库登记';
上报维修表创建语句如下：
create table t_sbwx(
id integer,
customerId int,
title varchar(100),
insertDate datetime,
types varchar(100),
pic varchar(100),
status varchar(100),
back varchar(100),
remark varchar(100)
);
--上报维修字段加注释
comment on column t_sbwx.id is '主键';
comment on column t_sbwx.customerId is '上报人';
comment on column t_sbwx.title is '标题';
comment on column t_sbwx.insertDate is '上报时间';
comment on column t_sbwx.types is '类型';
comment on column t_sbwx.pic is '图片';
comment on column t_sbwx.status is '状态';
comment on column t_sbwx.back is '回复';
comment on column t_sbwx.remark is '备注说明';
--上报维修表加注释
comment on table t_sbwx is '上报维修';
申请设备表创建语句如下：
create table t_sqsb(
id integer,
customerId int,
title varchar(100),
sb varchar(100),
sl int,
insertDate datetime,
status varchar(100),
remark varchar(100),
back varchar(100)
);
--申请设备字段加注释
comment on column t_sqsb.id is '主键';
comment on column t_sqsb.customerId is '上报人';
comment on column t_sqsb.title is '标题';
comment on column t_sqsb.sb is '设备';
comment on column t_sqsb.sl is '数量';
comment on column t_sqsb.insertDate is '申请时间';
comment on column t_sqsb.status is '状态';
comment on column t_sqsb.remark is '申请说明';
comment on column t_sqsb.back is '回复';
--申请设备表加注释
comment on table t_sqsb is '申请设备';
管理员消息表创建语句如下：
create table t_xiaoxi(
id integer,
customerId int,
title varchar(100),
remark varchar(100),
insertDate datetime
);
--管理员消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.customerId is '管理员';
comment on column t_xiaoxi.title is '标题';
comment on column t_xiaoxi.remark is '内容';
comment on column t_xiaoxi.insertDate is '消息时间';
--管理员消息表加注释
comment on table t_xiaoxi is '管理员消息';
oracle特有，对应序列如下：
create sequence s_t_ckdj;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_rkdj;
create sequence s_t_sbwx;
create sequence s_t_sqsb;
create sequence s_t_xiaoxi;
基于SSM的建筑工地设备管控系统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_ckdj(
id int identity(1,1) primary key not null,--主键
customerId int,--管理员
ckdjName varchar(100),--设备名称
v1 varchar(100),--对接人
v2 varchar(100),--出库人
showDate datetime,--出库时间
v3 int,--数量
v4 varchar(100),--种类
v5 int,--价格
gd varchar(100),--工地
v6 varchar(100),--库房
v7 varchar(100),--货架
remark varchar(100)--备注
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
cotnent varchar(100),--内容
showDate datetime--日期
);
入库登记表创建语句如下：
--入库登记表注释
create table t_rkdj(
id int identity(1,1) primary key not null,--主键
customerId int,--管理员
rkdjName varchar(100),--设备名称
v1 varchar(100),--对接人
v2 varchar(100),--入库人
showDate datetime,--入库时间
v3 int,--数量
v4 varchar(100),--种类
v5 int,--价格
gd varchar(100),--工地
v6 varchar(100),--库房
v7 varchar(100),--货架
remark varchar(100)--备注
);
上报维修表创建语句如下：
--上报维修表注释
create table t_sbwx(
id int identity(1,1) primary key not null,--主键
customerId int,--上报人
title varchar(100),--标题
insertDate datetime,--上报时间
types varchar(100),--类型
pic varchar(100),--图片
status varchar(100),--状态
back varchar(100),--回复
remark varchar(100)--备注说明
);
申请设备表创建语句如下：
--申请设备表注释
create table t_sqsb(
id int identity(1,1) primary key not null,--主键
customerId int,--上报人
title varchar(100),--标题
sb varchar(100),--设备
sl int,--数量
insertDate datetime,--申请时间
status varchar(100),--状态
remark varchar(100),--申请说明
back varchar(100)--回复
);
管理员消息表创建语句如下：
--管理员消息表注释
create table t_xiaoxi(
id int identity(1,1) primary key not null,--主键
customerId int,--管理员
title varchar(100),--标题
remark varchar(100),--内容
insertDate datetime--消息时间
);
登录后主页.jpg?x-oss-process=style/00001)
基于SSM的建筑工地设备管控系统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_ckdj")
public class Ckdj {
//主键
@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 ckdjName;
//对接人
private String v1;
//出库人
private String v2;
//出库时间
private Date showDate;
//数量
private Integer v3;
//种类
private String v4;
//价格
private Integer v5;
//工地
private String gd;
//库房
private String v6;
//货架
private String v7;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCkdjName() {return ckdjName;}
public void setCkdjName(String ckdjName) {this.ckdjName = ckdjName;}
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public String getGd() {return gd;}
public void setGd(String gd) {this.gd = gd;}
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 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_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 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 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 getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}公告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 title;
//图片
private String pic;
//内容
private String cotnent;
//日期
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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_rkdj")
public class Rkdj {
//主键
@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 rkdjName;
//对接人
private String v1;
//入库人
private String v2;
//入库时间
private Date showDate;
//数量
private Integer v3;
//种类
private String v4;
//价格
private Integer v5;
//工地
private String gd;
//库房
private String v6;
//货架
private String v7;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getRkdjName() {return rkdjName;}
public void setRkdjName(String rkdjName) {this.rkdjName = rkdjName;}
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public String getGd() {return gd;}
public void setGd(String gd) {this.gd = gd;}
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 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_sbwx")
public class Sbwx {
//主键
@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 Date insertDate;
//类型
private String types;
//图片
private String pic;
//状态
private String status;
//回复
private String back;
//备注说明
private String remark;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
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_sqsb")
public class Sqsb {
//主键
@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 sb;
//数量
private Integer sl;
//申请时间
private Date insertDate;
//状态
private String status;
//申请说明
private String remark;
//回复
private String back;
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 getSb() {return sb;}
public void setSb(String sb) {this.sb = sb;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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_xiaoxi")
public class Xiaoxi {
//主键
@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 remark;
//消息时间
private Date insertDate;
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}基于SSM的建筑工地设备管控系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
出库登记javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//出库登记
public class Ckdj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//管理员
private Integer customerId;
//设备名称
private String ckdjName;
//对接人
private String v1;
//出库人
private String v2;
//出库时间
private Date showDate;
//数量
private Integer v3;
//种类
private String v4;
//价格
private Integer v5;
//工地
private String gd;
//库房
private String v6;
//货架
private String v7;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCkdjName() {return ckdjName;}
public void setCkdjName(String ckdjName) {this.ckdjName = ckdjName;}
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public String getGd() {return gd;}
public void setGd(String gd) {this.gd = gd;}
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 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 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 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 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 getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}公告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 title;
//图片
private String pic;
//内容
private String cotnent;
//日期
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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 Rkdj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//管理员
private Integer customerId;
//设备名称
private String rkdjName;
//对接人
private String v1;
//入库人
private String v2;
//入库时间
private Date showDate;
//数量
private Integer v3;
//种类
private String v4;
//价格
private Integer v5;
//工地
private String gd;
//库房
private String v6;
//货架
private String v7;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getRkdjName() {return rkdjName;}
public void setRkdjName(String rkdjName) {this.rkdjName = rkdjName;}
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public String getGd() {return gd;}
public void setGd(String gd) {this.gd = gd;}
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 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 Sbwx 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 Date insertDate;
//类型
private String types;
//图片
private String pic;
//状态
private String status;
//回复
private String back;
//备注说明
private String remark;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
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 Sqsb 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 sb;
//数量
private Integer sl;
//申请时间
private Date insertDate;
//状态
private String status;
//申请说明
private String remark;
//回复
private String back;
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 getSb() {return sb;}
public void setSb(String sb) {this.sb = sb;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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 Xiaoxi 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 remark;
//消息时间
private Date insertDate;
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}