- 基于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_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 '电话'
) comment '委托单位';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
检测结果表创建语句如下：
create table t_jcjg(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
wtxxbh varchar(100) comment '委托信息编号',
ypName varchar(100) comment '样品名称',
pic varchar(100) comment '结果图片',
fileUrl varchar(100) comment '结果报告附件',
insertDate datetime comment '结果日期'
) comment '检测结果';
受理人员表创建语句如下：
create table t_sladmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
sladminName varchar(100) comment '姓名',
headPic varchar(100) comment '科室',
phone varchar(100) comment '电话'
) comment '受理人员';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
txName varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '通知';
提醒表创建语句如下：
create table t_tx(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
wtxxbh varchar(100) comment '委托信息编号',
txName varchar(100) comment '提醒标题',
content varchar(100) comment '提醒内容',
insertDate datetime comment '发送日期'
) comment '提醒';
委托信息表创建语句如下：
create table t_wtxx(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
wtxxbh varchar(100) comment '委托信息编号',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '附件',
insertDate datetime comment '提交日期',
content varchar(100) comment '详细内容说明',
back varchar(100) comment '回复',
status varchar(100) comment '状态'
) comment '委托信息';
样品表创建语句如下：
create table t_yp(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
wtxxbh varchar(100) comment '委托信息编号',
ypName varchar(100) comment '样品名称',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '附件',
insertDate datetime comment '提交日期',
content varchar(100) 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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone 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 table t_customer is '委托单位';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
检测结果表创建语句如下：
create table t_jcjg(
id integer,
customerId int,
wtxxbh varchar(100),
ypName varchar(100),
pic varchar(100),
fileUrl varchar(100),
insertDate datetime
);
--检测结果字段加注释
comment on column t_jcjg.id is '主键';
comment on column t_jcjg.customerId is '用户';
comment on column t_jcjg.wtxxbh is '委托信息编号';
comment on column t_jcjg.ypName is '样品名称';
comment on column t_jcjg.pic is '结果图片';
comment on column t_jcjg.fileUrl is '结果报告附件';
comment on column t_jcjg.insertDate is '结果日期';
--检测结果表加注释
comment on table t_jcjg is '检测结果';
受理人员表创建语句如下：
create table t_sladmin(
id integer,
username varchar(100),
password varchar(100),
sladminName varchar(100),
headPic varchar(100),
phone varchar(100)
);
--受理人员字段加注释
comment on column t_sladmin.id is '主键';
comment on column t_sladmin.username is '账号';
comment on column t_sladmin.password is '密码';
comment on column t_sladmin.sladminName is '姓名';
comment on column t_sladmin.headPic is '科室';
comment on column t_sladmin.phone is '电话';
--受理人员表加注释
comment on table t_sladmin is '受理人员';
通知表创建语句如下：
create table t_tongzhi(
id integer,
customerId int,
txName varchar(100),
content varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.txName is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知表加注释
comment on table t_tongzhi is '通知';
提醒表创建语句如下：
create table t_tx(
id integer,
customerId int,
wtxxbh varchar(100),
txName varchar(100),
content varchar(100),
insertDate datetime
);
--提醒字段加注释
comment on column t_tx.id is '主键';
comment on column t_tx.customerId is '用户';
comment on column t_tx.wtxxbh is '委托信息编号';
comment on column t_tx.txName is '提醒标题';
comment on column t_tx.content is '提醒内容';
comment on column t_tx.insertDate is '发送日期';
--提醒表加注释
comment on table t_tx is '提醒';
委托信息表创建语句如下：
create table t_wtxx(
id integer,
customerId int,
wtxxbh varchar(100),
title varchar(100),
pic varchar(100),
fileUrl varchar(100),
insertDate datetime,
content varchar(100),
back varchar(100),
status varchar(100)
);
--委托信息字段加注释
comment on column t_wtxx.id is '主键';
comment on column t_wtxx.customerId is '用户';
comment on column t_wtxx.wtxxbh is '委托信息编号';
comment on column t_wtxx.title is '标题';
comment on column t_wtxx.pic is '图片';
comment on column t_wtxx.fileUrl is '附件';
comment on column t_wtxx.insertDate is '提交日期';
comment on column t_wtxx.content is '详细内容说明';
comment on column t_wtxx.back is '回复';
comment on column t_wtxx.status is '状态';
--委托信息表加注释
comment on table t_wtxx is '委托信息';
样品表创建语句如下：
create table t_yp(
id integer,
customerId int,
wtxxbh varchar(100),
ypName varchar(100),
pic varchar(100),
fileUrl varchar(100),
insertDate datetime,
content varchar(100)
);
--样品字段加注释
comment on column t_yp.id is '主键';
comment on column t_yp.customerId is '用户';
comment on column t_yp.wtxxbh is '委托信息编号';
comment on column t_yp.ypName is '样品名称';
comment on column t_yp.pic is '图片';
comment on column t_yp.fileUrl is '附件';
comment on column t_yp.insertDate is '提交日期';
comment on column t_yp.content is '详细内容说明';
--样品表加注释
comment on table t_yp is '样品';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_jcjg;
create sequence s_t_sladmin;
create sequence s_t_tongzhi;
create sequence s_t_tx;
create sequence s_t_wtxx;
create sequence s_t_yp;
基于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_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)--电话
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
showDate datetime,--日期
v3 varchar(100)--内容
);
检测结果表创建语句如下：
--检测结果表注释
create table t_jcjg(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
wtxxbh varchar(100),--委托信息编号
ypName varchar(100),--样品名称
pic varchar(100),--结果图片
fileUrl varchar(100),--结果报告附件
insertDate datetime--结果日期
);
受理人员表创建语句如下：
--受理人员表注释
create table t_sladmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
sladminName varchar(100),--姓名
headPic varchar(100),--科室
phone varchar(100)--电话
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
txName varchar(100),--标题
content varchar(100),--内容
insertDate datetime--日期
);
提醒表创建语句如下：
--提醒表注释
create table t_tx(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
wtxxbh varchar(100),--委托信息编号
txName varchar(100),--提醒标题
content varchar(100),--提醒内容
insertDate datetime--发送日期
);
委托信息表创建语句如下：
--委托信息表注释
create table t_wtxx(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
wtxxbh varchar(100),--委托信息编号
title varchar(100),--标题
pic varchar(100),--图片
fileUrl varchar(100),--附件
insertDate datetime,--提交日期
content varchar(100),--详细内容说明
back varchar(100),--回复
status varchar(100)--状态
);
样品表创建语句如下：
--样品表注释
create table t_yp(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
wtxxbh varchar(100),--委托信息编号
ypName varchar(100),--样品名称
pic varchar(100),--图片
fileUrl varchar(100),--附件
insertDate datetime,--提交日期
content varchar(100)--详细内容说明
);
登录后主页.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_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;
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;}
}公告javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//公告
@Table(name = "t_gg")
public class Gg {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}检测结果javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//检测结果
@Table(name = "t_jcjg")
public class Jcjg {
//主键
@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 wtxxbh;
//样品名称
private String ypName;
//结果图片
private String pic;
//结果报告附件
private String fileUrl;
//结果日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWtxxbh() {return wtxxbh;}
public void setWtxxbh(String wtxxbh) {this.wtxxbh = wtxxbh;}
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_sladmin")
public class Sladmin {
//主键
@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 sladminName;
//科室
private String headPic;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getSladminName() {return sladminName;}
public void setSladminName(String sladminName) {this.sladminName = sladminName;}
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;}
}通知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 Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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_tx")
public class Tx {
//主键
@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 wtxxbh;
//提醒标题
private String txName;
//提醒内容
private String content;
//发送日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWtxxbh() {return wtxxbh;}
public void setWtxxbh(String wtxxbh) {this.wtxxbh = wtxxbh;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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_wtxx")
public class Wtxx {
//主键
@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 wtxxbh;
//标题
private String title;
//图片
private String pic;
//附件
private String fileUrl;
//提交日期
private Date insertDate;
//详细内容说明
private String content;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWtxxbh() {return wtxxbh;}
public void setWtxxbh(String wtxxbh) {this.wtxxbh = wtxxbh;}
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_yp")
public class Yp {
//主键
@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 wtxxbh;
//样品名称
private String ypName;
//图片
private String pic;
//附件
private String fileUrl;
//提交日期
private Date insertDate;
//详细内容说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWtxxbh() {return wtxxbh;}
public void setWtxxbh(String wtxxbh) {this.wtxxbh = wtxxbh;}
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}基于SSM的食品药品检验业务网上受理系统的设计与实现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;
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;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}检测结果javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//检测结果
public class Jcjg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//委托信息编号
private String wtxxbh;
//样品名称
private String ypName;
//结果图片
private String pic;
//结果报告附件
private String fileUrl;
//结果日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWtxxbh() {return wtxxbh;}
public void setWtxxbh(String wtxxbh) {this.wtxxbh = wtxxbh;}
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Sladmin 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 sladminName;
//科室
private String headPic;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getSladminName() {return sladminName;}
public void setSladminName(String sladminName) {this.sladminName = sladminName;}
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;}
}通知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 Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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 Tx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//委托信息编号
private String wtxxbh;
//提醒标题
private String txName;
//提醒内容
private String content;
//发送日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWtxxbh() {return wtxxbh;}
public void setWtxxbh(String wtxxbh) {this.wtxxbh = wtxxbh;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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 Wtxx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//委托信息编号
private String wtxxbh;
//标题
private String title;
//图片
private String pic;
//附件
private String fileUrl;
//提交日期
private Date insertDate;
//详细内容说明
private String content;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWtxxbh() {return wtxxbh;}
public void setWtxxbh(String wtxxbh) {this.wtxxbh = wtxxbh;}
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Yp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//委托信息编号
private String wtxxbh;
//样品名称
private String ypName;
//图片
private String pic;
//附件
private String fileUrl;
//提交日期
private Date insertDate;
//详细内容说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWtxxbh() {return wtxxbh;}
public void setWtxxbh(String wtxxbh) {this.wtxxbh = wtxxbh;}
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}