高危环境人员安全监管系统(xga50)_mysql

高危环境人员安全监管系统mysql数据库创建语句
高危环境人员安全监管系统oracle数据库创建语句
高危环境人员安全监管系统sqlserver数据库创建语句
高危环境人员安全监管系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
高危环境人员安全监管系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

高危环境人员安全监管系统mysql数据库版本源码：

超级管理员表创建语句如下：


create table t_admin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '超级管理员账号',
	password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');

工作人员表创建语句如下：


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '',
	gzlx varchar(100) comment '工作类型'
) comment '工作人员';

公告表创建语句如下：


create table t_gonggao(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content text comment '内容',
	insertDate datetime comment '发起日期'
) comment '公告';

核查员表创建语句如下：


create table t_hcy(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	hcyName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别'
) comment '核查员';

留言表创建语句如下：


create table t_ly(
	id int primary key auto_increment comment '主键',
	customerId int comment '工作人员',
	content text comment '内容',
	insertDate datetime comment '发起日期',
	back text comment '回复',
	status varchar(100) comment '状态'
) comment '留言';

施工申请表创建语句如下：


create table t_order(
	id int primary key auto_increment comment '主键',
	gzlx varchar(100) comment '工作类型',
	gzmc varchar(100) comment '工作名称',
	gzdd varchar(100) comment '工作地点',
	pic varchar(100) comment '图片',
	fj varchar(100) comment '附件',
	content text comment '详细说明',
	customerId int comment '工作人员',
	insertDate datetime comment '申请日期',
	status varchar(100) comment '状态',
	hcr varchar(100) comment '核查人',
	kcrdh varchar(100) comment '核查人电话',
	jsbg text comment '结束报告',
	jsbgfj varchar(100) comment '结束报告附件'
) comment '施工申请';

施工记录表创建语句如下：


create table t_orderlist(
	id int primary key auto_increment comment '主键',
	orderId int comment '施工申请',
	content text comment '施工记录',
	showDate datetime comment '日期',
	pic varchar(100) comment '拍照'
) comment '施工记录';

审批员表创建语句如下：


create table t_spy(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	spyName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment ''
) comment '审批员';

通知表创建语句如下：


create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	customerId int comment '工作人员',
	title varchar(100) comment '内容',
	insertDate datetime comment '发起日期'
) comment '通知';

高危环境人员安全监管系统oracle数据库版本源码：

超级管理员表创建语句如下：


create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

工作人员表创建语句如下：


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	gzlx 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.gzlx is '工作类型';
--工作人员表加注释
comment on table t_customer is '工作人员';

公告表创建语句如下：


create table t_gonggao(
	id integer,
	title varchar(100),
	content text,
	insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发起日期';
--公告表加注释
comment on table t_gonggao is '公告';

核查员表创建语句如下：


create table t_hcy(
	id integer,
	username varchar(100),
	password varchar(100),
	hcyName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--核查员字段加注释
comment on column t_hcy.id is '主键';
comment on column t_hcy.username is '账号';
comment on column t_hcy.password is '密码';
comment on column t_hcy.hcyName is '姓名';
comment on column t_hcy.phone is '电话';
comment on column t_hcy.age is '年龄';
comment on column t_hcy.sex is '性别';
--核查员表加注释
comment on table t_hcy is '核查员';

留言表创建语句如下：


create table t_ly(
	id integer,
	customerId int,
	content text,
	insertDate datetime,
	back text,
	status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.customerId is '工作人员';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';

施工申请表创建语句如下：


create table t_order(
	id integer,
	gzlx varchar(100),
	gzmc varchar(100),
	gzdd varchar(100),
	pic varchar(100),
	fj varchar(100),
	content text,
	customerId int,
	insertDate datetime,
	status varchar(100),
	hcr varchar(100),
	kcrdh varchar(100),
	jsbg text,
	jsbgfj varchar(100)
);
--施工申请字段加注释
comment on column t_order.id is '主键';
comment on column t_order.gzlx is '工作类型';
comment on column t_order.gzmc is '工作名称';
comment on column t_order.gzdd is '工作地点';
comment on column t_order.pic is '图片';
comment on column t_order.fj is '附件';
comment on column t_order.content is '详细说明';
comment on column t_order.customerId is '工作人员';
comment on column t_order.insertDate is '申请日期';
comment on column t_order.status is '状态';
comment on column t_order.hcr is '核查人';
comment on column t_order.kcrdh is '核查人电话';
comment on column t_order.jsbg is '结束报告';
comment on column t_order.jsbgfj is '结束报告附件';
--施工申请表加注释
comment on table t_order is '施工申请';

施工记录表创建语句如下：


create table t_orderlist(
	id integer,
	orderId int,
	content text,
	showDate datetime,
	pic varchar(100)
);
--施工记录字段加注释
comment on column t_orderlist.id is '主键';
comment on column t_orderlist.orderId is '施工申请';
comment on column t_orderlist.content is '施工记录';
comment on column t_orderlist.showDate is '日期';
comment on column t_orderlist.pic is '拍照';
--施工记录表加注释
comment on table t_orderlist is '施工记录';

审批员表创建语句如下：


create table t_spy(
	id integer,
	username varchar(100),
	password varchar(100),
	spyName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--审批员字段加注释
comment on column t_spy.id is '主键';
comment on column t_spy.username is '账号';
comment on column t_spy.password is '密码';
comment on column t_spy.spyName is '姓名';
comment on column t_spy.phone is '电话';
comment on column t_spy.age is '年龄';
comment on column t_spy.sex is '';
--审批员表加注释
comment on table t_spy is '审批员';

通知表创建语句如下：


create table t_tongzhi(
	id integer,
	customerId int,
	title varchar(100),
	insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '工作人员';
comment on column t_tongzhi.title is '内容';
comment on column t_tongzhi.insertDate is '发起日期';
--通知表加注释
comment on table t_tongzhi is '通知';

oracle特有，对应序列如下：


create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_hcy;
create sequence s_t_ly;
create sequence s_t_order;
create sequence s_t_orderlist;
create sequence s_t_spy;
create sequence s_t_tongzhi;

高危环境人员安全监管系统sqlserver数据库版本源码：

超级管理员表创建语句如下：


--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

工作人员表创建语句如下：


--工作人员表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--
	gzlx varchar(100)--工作类型
);

公告表创建语句如下：


--公告表注释
create table t_gonggao(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content text,--内容
	insertDate datetime--发起日期
);

核查员表创建语句如下：


--核查员表注释
create table t_hcy(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	hcyName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--性别
);

留言表创建语句如下：


--留言表注释
create table t_ly(
	id int identity(1,1) primary key not null,--主键
	customerId int,--工作人员
	content text,--内容
	insertDate datetime,--发起日期
	back text,--回复
	status varchar(100)--状态
);

施工申请表创建语句如下：


--施工申请表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	gzlx varchar(100),--工作类型
	gzmc varchar(100),--工作名称
	gzdd varchar(100),--工作地点
	pic varchar(100),--图片
	fj varchar(100),--附件
	content text,--详细说明
	customerId int,--工作人员
	insertDate datetime,--申请日期
	status varchar(100),--状态
	hcr varchar(100),--核查人
	kcrdh varchar(100),--核查人电话
	jsbg text,--结束报告
	jsbgfj varchar(100)--结束报告附件
);

施工记录表创建语句如下：


--施工记录表注释
create table t_orderlist(
	id int identity(1,1) primary key not null,--主键
	orderId int,--施工申请
	content text,--施工记录
	showDate datetime,--日期
	pic varchar(100)--拍照
);

审批员表创建语句如下：


--审批员表注释
create table t_spy(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	spyName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--
);

通知表创建语句如下：


--通知表注释
create table t_tongzhi(
	id int identity(1,1) primary key not null,--主键
	customerId int,--工作人员
	title varchar(100),--内容
	insertDate datetime--发起日期
);

高危环境人员安全监管系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：

工作人员javaBean创建语句如下：


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//工作人员
@Table(name = "t_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//工作类型
private String gzlx;
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 String getGzlx() {return gzlx;}
public void setGzlx(String gzlx) {this.gzlx = gzlx;}
}

公告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_gonggao")
public class Gonggao {
//主键
@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 content;
//发起日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_hcy")
public class Hcy {
//主键
@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 hcyName;
//电话
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 getHcyName() {return hcyName;}
public void setHcyName(String hcyName) {this.hcyName = hcyName;}
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_ly")
public class Ly {
//主键
@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 Long customerId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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_order")
public class Order {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//工作类型
private String gzlx;
//工作名称
private String gzmc;
//工作地点
private String gzdd;
//图片
private String pic;
//附件
private String fj;
//详细说明
private String content;
//工作人员
private Long customerId;
//申请日期
private Date insertDate;
//状态
private String status;
//核查人
private String hcr;
//核查人电话
private String kcrdh;
//结束报告
private String jsbg;
//结束报告附件
private String jsbgfj;
public String getGzlx() {return gzlx;}
public void setGzlx(String gzlx) {this.gzlx = gzlx;}
public String getGzmc() {return gzmc;}
public void setGzmc(String gzmc) {this.gzmc = gzmc;}
public String getGzdd() {return gzdd;}
public void setGzdd(String gzdd) {this.gzdd = gzdd;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
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 getHcr() {return hcr;}
public void setHcr(String hcr) {this.hcr = hcr;}
public String getKcrdh() {return kcrdh;}
public void setKcrdh(String kcrdh) {this.kcrdh = kcrdh;}
public String getJsbg() {return jsbg;}
public void setJsbg(String jsbg) {this.jsbg = jsbg;}
public String getJsbgfj() {return jsbgfj;}
public void setJsbgfj(String jsbgfj) {this.jsbgfj = jsbgfj;}
}

施工记录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_orderlist")
public class Orderlist {
//主键
@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 Long orderId;
//施工记录
private String content;
//日期
private Date showDate;
//拍照
private String pic;
public Long getOrderId() {return orderId;}
public void setOrderId(Long orderId) {this.orderId = orderId;}
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;}
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_spy")
public class Spy {
//主键
@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 spyName;
//电话
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 getSpyName() {return spyName;}
public void setSpyName(String spyName) {this.spyName = spyName;}
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_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 Long customerId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long 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;}
}

高危环境人员安全监管系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

工作人员javaBean创建语句如下：


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

//工作人员
public class Customer  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//工作类型
private String gzlx;
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 String getGzlx() {return gzlx;}
public void setGzlx(String gzlx) {this.gzlx = gzlx;}
}

公告javaBean创建语句如下：


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

//公告
public class Gonggao  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Hcy  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 hcyName;
//电话
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 getHcyName() {return hcyName;}
public void setHcyName(String hcyName) {this.hcyName = hcyName;}
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 Ly  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//工作人员
private Long customerId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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 Order  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//工作类型
private String gzlx;
//工作名称
private String gzmc;
//工作地点
private String gzdd;
//图片
private String pic;
//附件
private String fj;
//详细说明
private String content;
//工作人员
private Long customerId;
//申请日期
private Date insertDate;
//状态
private String status;
//核查人
private String hcr;
//核查人电话
private String kcrdh;
//结束报告
private String jsbg;
//结束报告附件
private String jsbgfj;
public String getGzlx() {return gzlx;}
public void setGzlx(String gzlx) {this.gzlx = gzlx;}
public String getGzmc() {return gzmc;}
public void setGzmc(String gzmc) {this.gzmc = gzmc;}
public String getGzdd() {return gzdd;}
public void setGzdd(String gzdd) {this.gzdd = gzdd;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
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 getHcr() {return hcr;}
public void setHcr(String hcr) {this.hcr = hcr;}
public String getKcrdh() {return kcrdh;}
public void setKcrdh(String kcrdh) {this.kcrdh = kcrdh;}
public String getJsbg() {return jsbg;}
public void setJsbg(String jsbg) {this.jsbg = jsbg;}
public String getJsbgfj() {return jsbgfj;}
public void setJsbgfj(String jsbgfj) {this.jsbgfj = jsbgfj;}
}

施工记录javaBean创建语句如下：


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

//施工记录
public class Orderlist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//施工申请
private Long orderId;
//施工记录
private String content;
//日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//拍照
private String pic;
public Long getOrderId() {return orderId;}
public void setOrderId(Long orderId) {this.orderId = orderId;}
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;}
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 Spy  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 spyName;
//电话
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 getSpyName() {return spyName;}
public void setSpyName(String spyName) {this.spyName = spyName;}
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 Tongzhi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//工作人员
private Long customerId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long 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;}
}

高危环境人员安全监管系统(xga50)_mysql_oracle代码分享

高危环境人员安全监管系统mysql数据库版本源码：

高危环境人员安全监管系统oracle数据库版本源码：

高危环境人员安全监管系统sqlserver数据库版本源码：

高危环境人员安全监管系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：

高危环境人员安全监管系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

相关毕业设计源码

评论