- 考试安全平台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_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
sex varchar(100) comment '性别',
age varchar(100) comment '年龄',
phone varchar(100) comment '电话',
headPic varchar(100) comment '头像',
sfz varchar(100) comment '身份证',
address varchar(100) comment '地址',
js varchar(100) comment ''
) comment '用户';
考试地点表创建语句如下：
create table t_dd(
id int primary key auto_increment comment '主键',
ddName varchar(100) comment '考试地点'
) comment '考试地点';
考试课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
kcName varchar(100) comment '考试课程'
) comment '考试课程';
考试表创建语句如下：
create table t_ks(
id int primary key auto_increment comment '主键',
ksName varchar(100) comment '考试名称',
ddId int comment '考试地点',
kcId int comment '考试课程',
jkId int comment '监考老师',
showDate datetime comment '考试日期',
sxw varchar(100) comment '',
remark text comment '备注'
) comment '考试';
考生列表表创建语句如下：
create table t_kslist(
id int primary key auto_increment comment '主键',
ksId int comment '所属考试',
customerId int comment '考生'
) comment '考生列表';
个人消息表创建语句如下：
create table t_message(
id int primary key auto_increment comment '主键',
customerId int comment '发送人',
toId int comment '接收人',
title varchar(100) comment '标题',
headPic varchar(100) comment '图片',
content varchar(100) comment '内容',
insertDate datetime comment '日期',
status varchar(100) comment '状态'
) comment '个人消息';
系统通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '标题',
headPic varchar(100) comment '图片',
content varchar(100) comment '内容',
insertDate datetime comment '日期',
status varchar(100) comment '状态',
batchId varchar(100) comment ''
) comment '系统通知';
考试预约表创建语句如下：
create table t_yy(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '标题',
content varchar(100) comment '说明',
showDate datetime comment '预约日期',
status varchar(100) comment '状态',
back text 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),
sex varchar(100),
age varchar(100),
phone varchar(100),
headPic varchar(100),
sfz varchar(100),
address varchar(100),
js 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.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.phone is '电话';
comment on column t_customer.headPic is '头像';
comment on column t_customer.sfz is '身份证';
comment on column t_customer.address is '地址';
comment on column t_customer.js is '';
--用户表加注释
comment on table t_customer is '用户';
考试地点表创建语句如下：
create table t_dd(
id integer,
ddName varchar(100)
);
--考试地点字段加注释
comment on column t_dd.id is '主键';
comment on column t_dd.ddName is '考试地点';
--考试地点表加注释
comment on table t_dd is '考试地点';
考试课程表创建语句如下：
create table t_kc(
id integer,
kcName varchar(100)
);
--考试课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '考试课程';
--考试课程表加注释
comment on table t_kc is '考试课程';
考试表创建语句如下：
create table t_ks(
id integer,
ksName varchar(100),
ddId int,
kcId int,
jkId int,
showDate datetime,
sxw varchar(100),
remark text
);
--考试字段加注释
comment on column t_ks.id is '主键';
comment on column t_ks.ksName is '考试名称';
comment on column t_ks.ddId is '考试地点';
comment on column t_ks.kcId is '考试课程';
comment on column t_ks.jkId is '监考老师';
comment on column t_ks.showDate is '考试日期';
comment on column t_ks.sxw is '';
comment on column t_ks.remark is '备注';
--考试表加注释
comment on table t_ks is '考试';
考生列表表创建语句如下：
create table t_kslist(
id integer,
ksId int,
customerId int
);
--考生列表字段加注释
comment on column t_kslist.id is '主键';
comment on column t_kslist.ksId is '所属考试';
comment on column t_kslist.customerId is '考生';
--考生列表表加注释
comment on table t_kslist is '考生列表';
个人消息表创建语句如下：
create table t_message(
id integer,
customerId int,
toId int,
title varchar(100),
headPic varchar(100),
content varchar(100),
insertDate datetime,
status varchar(100)
);
--个人消息字段加注释
comment on column t_message.id is '主键';
comment on column t_message.customerId is '发送人';
comment on column t_message.toId is '接收人';
comment on column t_message.title is '标题';
comment on column t_message.headPic is '图片';
comment on column t_message.content is '内容';
comment on column t_message.insertDate is '日期';
comment on column t_message.status is '状态';
--个人消息表加注释
comment on table t_message is '个人消息';
系统通知表创建语句如下：
create table t_tongzhi(
id integer,
customerId int,
title varchar(100),
headPic varchar(100),
content varchar(100),
insertDate datetime,
status varchar(100),
batchId varchar(100)
);
--系统通知字段加注释
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.headPic is '图片';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
comment on column t_tongzhi.status is '状态';
comment on column t_tongzhi.batchId is '';
--系统通知表加注释
comment on table t_tongzhi is '系统通知';
考试预约表创建语句如下：
create table t_yy(
id integer,
customerId int,
title varchar(100),
content varchar(100),
showDate datetime,
status varchar(100),
back text
);
--考试预约字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.customerId is '用户';
comment on column t_yy.title is '标题';
comment on column t_yy.content is '说明';
comment on column t_yy.showDate is '预约日期';
comment on column t_yy.status is '状态';
comment on column t_yy.back is '回复';
--考试预约表加注释
comment on table t_yy is '考试预约';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_dd;
create sequence s_t_kc;
create sequence s_t_ks;
create sequence s_t_kslist;
create sequence s_t_message;
create sequence s_t_tongzhi;
create sequence s_t_yy;
考试安全平台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),--姓名
sex varchar(100),--性别
age varchar(100),--年龄
phone varchar(100),--电话
headPic varchar(100),--头像
sfz varchar(100),--身份证
address varchar(100),--地址
js varchar(100)--
);
考试地点表创建语句如下：
--考试地点表注释
create table t_dd(
id int identity(1,1) primary key not null,--主键
ddName varchar(100)--考试地点
);
考试课程表创建语句如下：
--考试课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
kcName varchar(100)--考试课程
);
考试表创建语句如下：
--考试表注释
create table t_ks(
id int identity(1,1) primary key not null,--主键
ksName varchar(100),--考试名称
ddId int,--考试地点
kcId int,--考试课程
jkId int,--监考老师
showDate datetime,--考试日期
sxw varchar(100),--
remark text--备注
);
考生列表表创建语句如下：
--考生列表表注释
create table t_kslist(
id int identity(1,1) primary key not null,--主键
ksId int,--所属考试
customerId int--考生
);
个人消息表创建语句如下：
--个人消息表注释
create table t_message(
id int identity(1,1) primary key not null,--主键
customerId int,--发送人
toId int,--接收人
title varchar(100),--标题
headPic varchar(100),--图片
content varchar(100),--内容
insertDate datetime,--日期
status varchar(100)--状态
);
系统通知表创建语句如下：
--系统通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--标题
headPic varchar(100),--图片
content varchar(100),--内容
insertDate datetime,--日期
status varchar(100),--状态
batchId varchar(100)--
);
考试预约表创建语句如下：
--考试预约表注释
create table t_yy(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--标题
content varchar(100),--说明
showDate datetime,--预约日期
status varchar(100),--状态
back text--回复
);
登录后主页.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_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 sex;
//年龄
private String age;
//电话
private String phone;
//头像
private String headPic;
//身份证
private String sfz;
//地址
private String address;
//
private String js;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}考试地点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_dd")
public class Dd {
//主键
@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 ddName;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
}考试课程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_kc")
public class Kc {
//主键
@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 kcName;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
}考试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_ks")
public class Ks {
//主键
@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 ksName;
//考试地点
private Long ddId;
//考试课程
private Long kcId;
//监考老师
private Long jkId;
//考试日期
private Date showDate;
//
private String sxw;
//备注
private String remark;
public String getKsName() {return ksName;}
public void setKsName(String ksName) {this.ksName = ksName;}
public Long getDdId() {return ddId;}
public void setDdId(Long ddId) {this.ddId = ddId;}
public Long getKcId() {return kcId;}
public void setKcId(Long kcId) {this.kcId = kcId;}
public Long getJkId() {return jkId;}
public void setJkId(Long jkId) {this.jkId = jkId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getSxw() {return sxw;}
public void setSxw(String sxw) {this.sxw = sxw;}
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_kslist")
public class Kslist {
//主键
@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 ksId;
//考生
private Long customerId;
public Long getKsId() {return ksId;}
public void setKsId(Long ksId) {this.ksId = ksId;}
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
}个人消息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_message")
public class Message {
//主键
@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 toId;
//标题
private String title;
//图片
private String headPic;
//内容
private String content;
//日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 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_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 title;
//图片
private String headPic;
//内容
private String content;
//日期
private Date insertDate;
//状态
private String status;
//
private String batchId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBatchId() {return batchId;}
public void setBatchId(String batchId) {this.batchId = batchId;}
}考试预约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_yy")
public class Yy {
//主键
@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 String content;
//预约日期
private Date showDate;
//状态
private String status;
//回复
private String back;
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 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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}考试安全平台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 sex;
//年龄
private String age;
//电话
private String phone;
//头像
private String headPic;
//身份证
private String sfz;
//地址
private String address;
//
private String js;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}考试地点javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//考试地点
public class Dd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//考试地点
private String ddName;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
}考试课程javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//考试课程
public class Kc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//考试课程
private String kcName;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
}考试javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//考试
public class Ks extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//考试名称
private String ksName;
//考试地点
private Long ddId;
//考试课程
private Long kcId;
//监考老师
private Long jkId;
//考试日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//
private String sxw;
//备注
private String remark;
public String getKsName() {return ksName;}
public void setKsName(String ksName) {this.ksName = ksName;}
public Long getDdId() {return ddId;}
public void setDdId(Long ddId) {this.ddId = ddId;}
public Long getKcId() {return kcId;}
public void setKcId(Long kcId) {this.kcId = kcId;}
public Long getJkId() {return jkId;}
public void setJkId(Long jkId) {this.jkId = jkId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getSxw() {return sxw;}
public void setSxw(String sxw) {this.sxw = sxw;}
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 Kslist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//所属考试
private Long ksId;
//考生
private Long customerId;
public Long getKsId() {return ksId;}
public void setKsId(Long ksId) {this.ksId = ksId;}
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
}个人消息javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//个人消息
public class Message extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发送人
private Integer customerId;
//接收人
private Integer toId;
//标题
private String title;
//图片
private String headPic;
//内容
private String content;
//日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 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 Tongzhi 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 headPic;
//内容
private String content;
//日期
private Date insertDate;
//状态
private String status;
//
private String batchId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBatchId() {return batchId;}
public void setBatchId(String batchId) {this.batchId = batchId;}
}考试预约javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//考试预约
public class Yy 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 String content;
//预约日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//状态
private String status;
//回复
private String back;
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 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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}