- 期刊稿件处理系统开发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_bianji(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
bianjiName varchar(100) comment '编辑姓名',
phone varchar(100) comment '电话',
age 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 '年龄',
pf int comment '评分'
) comment '用户';
稿件表创建语句如下：
create table t_gaojian(
id int primary key auto_increment comment '主键',
customerId int comment '',
title varchar(100) comment '稿件ID',
fileUrl varchar(100) comment '附件',
types1Id int comment '稿件',
types2Id int comment '期刊',
types3Id int comment '基金',
insertDate datetime comment '发起日期',
bianjiId int comment '编辑',
bianjiBack varchar(100) comment '编辑回复',
sgr1Id int comment '审稿人1',
sgrback1 varchar(100) comment '审稿人1回复',
sgrstatus1 varchar(100) comment '审稿人1状态',
sgr2Id int comment '审稿人2',
sgrback2 varchar(100) comment '审稿人回复',
sgrstatus2 varchar(100) comment '审稿人状态',
status varchar(100) comment '最终状态'
) comment '稿件';
评级人表创建语句如下：
create table t_pjr(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
pjrName varchar(100) comment '评级人姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄'
) comment '评级人';
审稿人表创建语句如下：
create table t_sgr(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
sgrName varchar(100) comment '审稿人姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
pf int comment '评分',
types1Id int comment '稿件',
types2Id int comment '期刊',
types3Id int comment '基金'
) comment '审稿人';
稿件类型表创建语句如下：
create table t_types1(
id int primary key auto_increment comment '主键',
types1Name varchar(100) comment '稿件类型名称'
) comment '稿件类型';
期刊类型表创建语句如下：
create table t_types2(
id int primary key auto_increment comment '主键',
types2Name varchar(100) comment '期刊类型名称'
) comment '期刊类型';
基金类型表创建语句如下：
create table t_types3(
id int primary key auto_increment comment '主键',
types3Name varchar(100) comment '基金类型名称'
) comment '基金类型';
消息表创建语句如下：
create table t_xiaoxi(
id int primary key auto_increment comment '主键',
customerId int comment '发起人',
bianjiId 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_bianji(
id integer,
username varchar(100),
password varchar(100),
bianjiName varchar(100),
phone varchar(100),
age varchar(100)
);
--编辑字段加注释
comment on column t_bianji.id is '主键';
comment on column t_bianji.username is '账号';
comment on column t_bianji.password is '密码';
comment on column t_bianji.bianjiName is '编辑姓名';
comment on column t_bianji.phone is '电话';
comment on column t_bianji.age is '年龄';
--编辑表加注释
comment on table t_bianji is '编辑';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
pf int
);
--用户字段加注释
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.pf is '评分';
--用户表加注释
comment on table t_customer is '用户';
稿件表创建语句如下：
create table t_gaojian(
id integer,
customerId int,
title varchar(100),
fileUrl varchar(100),
types1Id int,
types2Id int,
types3Id int,
insertDate datetime,
bianjiId int,
bianjiBack varchar(100),
sgr1Id int,
sgrback1 varchar(100),
sgrstatus1 varchar(100),
sgr2Id int,
sgrback2 varchar(100),
sgrstatus2 varchar(100),
status varchar(100)
);
--稿件字段加注释
comment on column t_gaojian.id is '主键';
comment on column t_gaojian.customerId is '';
comment on column t_gaojian.title is '稿件ID';
comment on column t_gaojian.fileUrl is '附件';
comment on column t_gaojian.types1Id is '稿件';
comment on column t_gaojian.types2Id is '期刊';
comment on column t_gaojian.types3Id is '基金';
comment on column t_gaojian.insertDate is '发起日期';
comment on column t_gaojian.bianjiId is '编辑';
comment on column t_gaojian.bianjiBack is '编辑回复';
comment on column t_gaojian.sgr1Id is '审稿人1';
comment on column t_gaojian.sgrback1 is '审稿人1回复';
comment on column t_gaojian.sgrstatus1 is '审稿人1状态';
comment on column t_gaojian.sgr2Id is '审稿人2';
comment on column t_gaojian.sgrback2 is '审稿人回复';
comment on column t_gaojian.sgrstatus2 is '审稿人状态';
comment on column t_gaojian.status is '最终状态';
--稿件表加注释
comment on table t_gaojian is '稿件';
评级人表创建语句如下：
create table t_pjr(
id integer,
username varchar(100),
password varchar(100),
pjrName varchar(100),
phone varchar(100),
age varchar(100)
);
--评级人字段加注释
comment on column t_pjr.id is '主键';
comment on column t_pjr.username is '账号';
comment on column t_pjr.password is '密码';
comment on column t_pjr.pjrName is '评级人姓名';
comment on column t_pjr.phone is '电话';
comment on column t_pjr.age is '年龄';
--评级人表加注释
comment on table t_pjr is '评级人';
审稿人表创建语句如下：
create table t_sgr(
id integer,
username varchar(100),
password varchar(100),
sgrName varchar(100),
phone varchar(100),
age varchar(100),
pf int,
types1Id int,
types2Id int,
types3Id int
);
--审稿人字段加注释
comment on column t_sgr.id is '主键';
comment on column t_sgr.username is '账号';
comment on column t_sgr.password is '密码';
comment on column t_sgr.sgrName is '审稿人姓名';
comment on column t_sgr.phone is '电话';
comment on column t_sgr.age is '年龄';
comment on column t_sgr.pf is '评分';
comment on column t_sgr.types1Id is '稿件';
comment on column t_sgr.types2Id is '期刊';
comment on column t_sgr.types3Id is '基金';
--审稿人表加注释
comment on table t_sgr is '审稿人';
稿件类型表创建语句如下：
create table t_types1(
id integer,
types1Name varchar(100)
);
--稿件类型字段加注释
comment on column t_types1.id is '主键';
comment on column t_types1.types1Name is '稿件类型名称';
--稿件类型表加注释
comment on table t_types1 is '稿件类型';
期刊类型表创建语句如下：
create table t_types2(
id integer,
types2Name varchar(100)
);
--期刊类型字段加注释
comment on column t_types2.id is '主键';
comment on column t_types2.types2Name is '期刊类型名称';
--期刊类型表加注释
comment on table t_types2 is '期刊类型';
基金类型表创建语句如下：
create table t_types3(
id integer,
types3Name varchar(100)
);
--基金类型字段加注释
comment on column t_types3.id is '主键';
comment on column t_types3.types3Name is '基金类型名称';
--基金类型表加注释
comment on table t_types3 is '基金类型';
消息表创建语句如下：
create table t_xiaoxi(
id integer,
customerId int,
bianjiId int,
title varchar(100),
insertDate datetime
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.customerId is '发起人';
comment on column t_xiaoxi.bianjiId is '接收人';
comment on column t_xiaoxi.title is '消息';
comment on column t_xiaoxi.insertDate is '日期';
--消息表加注释
comment on table t_xiaoxi is '消息';
oracle特有，对应序列如下：
create sequence s_t_bianji;
create sequence s_t_customer;
create sequence s_t_gaojian;
create sequence s_t_pjr;
create sequence s_t_sgr;
create sequence s_t_types1;
create sequence s_t_types2;
create sequence s_t_types3;
create sequence s_t_xiaoxi;
期刊稿件处理系统开发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_bianji(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
bianjiName varchar(100),--编辑姓名
phone varchar(100),--电话
age 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),--年龄
pf int--评分
);
稿件表创建语句如下：
--稿件表注释
create table t_gaojian(
id int identity(1,1) primary key not null,--主键
customerId int,--
title varchar(100),--稿件ID
fileUrl varchar(100),--附件
types1Id int,--稿件
types2Id int,--期刊
types3Id int,--基金
insertDate datetime,--发起日期
bianjiId int,--编辑
bianjiBack varchar(100),--编辑回复
sgr1Id int,--审稿人1
sgrback1 varchar(100),--审稿人1回复
sgrstatus1 varchar(100),--审稿人1状态
sgr2Id int,--审稿人2
sgrback2 varchar(100),--审稿人回复
sgrstatus2 varchar(100),--审稿人状态
status varchar(100)--最终状态
);
评级人表创建语句如下：
--评级人表注释
create table t_pjr(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
pjrName varchar(100),--评级人姓名
phone varchar(100),--电话
age varchar(100)--年龄
);
审稿人表创建语句如下：
--审稿人表注释
create table t_sgr(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
sgrName varchar(100),--审稿人姓名
phone varchar(100),--电话
age varchar(100),--年龄
pf int,--评分
types1Id int,--稿件
types2Id int,--期刊
types3Id int--基金
);
稿件类型表创建语句如下：
--稿件类型表注释
create table t_types1(
id int identity(1,1) primary key not null,--主键
types1Name varchar(100)--稿件类型名称
);
期刊类型表创建语句如下：
--期刊类型表注释
create table t_types2(
id int identity(1,1) primary key not null,--主键
types2Name varchar(100)--期刊类型名称
);
基金类型表创建语句如下：
--基金类型表注释
create table t_types3(
id int identity(1,1) primary key not null,--主键
types3Name varchar(100)--基金类型名称
);
消息表创建语句如下：
--消息表注释
create table t_xiaoxi(
id int identity(1,1) primary key not null,--主键
customerId int,--发起人
bianjiId int,--接收人
title varchar(100),--消息
insertDate datetime--日期
);
登录后主页.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_bianji")
public class Bianji {
//主键
@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 bianjiName;
//电话
private String phone;
//年龄
private String age;
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 getBianjiName() {return bianjiName;}
public void setBianjiName(String bianjiName) {this.bianjiName = bianjiName;}
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;}
}用户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 Integer pf;
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 Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
}稿件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_gaojian")
public class Gaojian {
//主键
@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;
//稿件ID
private String title;
//附件
private String fileUrl;
//稿件
private Integer types1Id;
//期刊
private Integer types2Id;
//基金
private Integer types3Id;
//发起日期
private Date insertDate;
//编辑
private Integer bianjiId;
//编辑回复
private String bianjiBack;
//审稿人1
private Integer sgr1Id;
//审稿人1回复
private String sgrback1;
//审稿人1状态
private String sgrstatus1;
//审稿人2
private Integer sgr2Id;
//审稿人回复
private String sgrback2;
//审稿人状态
private String sgrstatus2;
//最终状态
private String status;
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Integer getTypes1Id() {return types1Id;}
public void setTypes1Id(Integer types1Id) {this.types1Id = types1Id;}
public Integer getTypes2Id() {return types2Id;}
public void setTypes2Id(Integer types2Id) {this.types2Id = types2Id;}
public Integer getTypes3Id() {return types3Id;}
public void setTypes3Id(Integer types3Id) {this.types3Id = types3Id;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getBianjiId() {return bianjiId;}
public void setBianjiId(Integer bianjiId) {this.bianjiId = bianjiId;}
public String getBianjiBack() {return bianjiBack;}
public void setBianjiBack(String bianjiBack) {this.bianjiBack = bianjiBack;}
public Integer getSgr1Id() {return sgr1Id;}
public void setSgr1Id(Integer sgr1Id) {this.sgr1Id = sgr1Id;}
public String getSgrback1() {return sgrback1;}
public void setSgrback1(String sgrback1) {this.sgrback1 = sgrback1;}
public String getSgrstatus1() {return sgrstatus1;}
public void setSgrstatus1(String sgrstatus1) {this.sgrstatus1 = sgrstatus1;}
public Integer getSgr2Id() {return sgr2Id;}
public void setSgr2Id(Integer sgr2Id) {this.sgr2Id = sgr2Id;}
public String getSgrback2() {return sgrback2;}
public void setSgrback2(String sgrback2) {this.sgrback2 = sgrback2;}
public String getSgrstatus2() {return sgrstatus2;}
public void setSgrstatus2(String sgrstatus2) {this.sgrstatus2 = sgrstatus2;}
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_pjr")
public class Pjr {
//主键
@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 pjrName;
//电话
private String phone;
//年龄
private String age;
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 getPjrName() {return pjrName;}
public void setPjrName(String pjrName) {this.pjrName = pjrName;}
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;}
}审稿人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_sgr")
public class Sgr {
//主键
@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 sgrName;
//电话
private String phone;
//年龄
private String age;
//评分
private Integer pf;
//稿件
private Integer types1Id;
//期刊
private Integer types2Id;
//基金
private Integer types3Id;
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 getSgrName() {return sgrName;}
public void setSgrName(String sgrName) {this.sgrName = sgrName;}
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 Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public Integer getTypes1Id() {return types1Id;}
public void setTypes1Id(Integer types1Id) {this.types1Id = types1Id;}
public Integer getTypes2Id() {return types2Id;}
public void setTypes2Id(Integer types2Id) {this.types2Id = types2Id;}
public Integer getTypes3Id() {return types3Id;}
public void setTypes3Id(Integer types3Id) {this.types3Id = types3Id;}
}稿件类型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_types1")
public class Types1 {
//主键
@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 types1Name;
public String getTypes1Name() {return types1Name;}
public void setTypes1Name(String types1Name) {this.types1Name = types1Name;}
}期刊类型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_types2")
public class Types2 {
//主键
@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 types2Name;
public String getTypes2Name() {return types2Name;}
public void setTypes2Name(String types2Name) {this.types2Name = types2Name;}
}基金类型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_types3")
public class Types3 {
//主键
@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 types3Name;
public String getTypes3Name() {return types3Name;}
public void setTypes3Name(String types3Name) {this.types3Name = types3Name;}
}消息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 Integer bianjiId;
//消息
private String title;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getBianjiId() {return bianjiId;}
public void setBianjiId(Integer bianjiId) {this.bianjiId = bianjiId;}
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 Bianji 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 bianjiName;
//电话
private String phone;
//年龄
private String age;
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 getBianjiName() {return bianjiName;}
public void setBianjiName(String bianjiName) {this.bianjiName = bianjiName;}
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;}
}用户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 Integer pf;
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 Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
}稿件javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//稿件
public class Gaojian extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer customerId;
//稿件ID
private String title;
//附件
private String fileUrl;
//稿件
private Integer types1Id;
//期刊
private Integer types2Id;
//基金
private Integer types3Id;
//发起日期
private Date insertDate;
//编辑
private Integer bianjiId;
//编辑回复
private String bianjiBack;
//审稿人1
private Integer sgr1Id;
//审稿人1回复
private String sgrback1;
//审稿人1状态
private String sgrstatus1;
//审稿人2
private Integer sgr2Id;
//审稿人回复
private String sgrback2;
//审稿人状态
private String sgrstatus2;
//最终状态
private String status;
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Integer getTypes1Id() {return types1Id;}
public void setTypes1Id(Integer types1Id) {this.types1Id = types1Id;}
public Integer getTypes2Id() {return types2Id;}
public void setTypes2Id(Integer types2Id) {this.types2Id = types2Id;}
public Integer getTypes3Id() {return types3Id;}
public void setTypes3Id(Integer types3Id) {this.types3Id = types3Id;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getBianjiId() {return bianjiId;}
public void setBianjiId(Integer bianjiId) {this.bianjiId = bianjiId;}
public String getBianjiBack() {return bianjiBack;}
public void setBianjiBack(String bianjiBack) {this.bianjiBack = bianjiBack;}
public Integer getSgr1Id() {return sgr1Id;}
public void setSgr1Id(Integer sgr1Id) {this.sgr1Id = sgr1Id;}
public String getSgrback1() {return sgrback1;}
public void setSgrback1(String sgrback1) {this.sgrback1 = sgrback1;}
public String getSgrstatus1() {return sgrstatus1;}
public void setSgrstatus1(String sgrstatus1) {this.sgrstatus1 = sgrstatus1;}
public Integer getSgr2Id() {return sgr2Id;}
public void setSgr2Id(Integer sgr2Id) {this.sgr2Id = sgr2Id;}
public String getSgrback2() {return sgrback2;}
public void setSgrback2(String sgrback2) {this.sgrback2 = sgrback2;}
public String getSgrstatus2() {return sgrstatus2;}
public void setSgrstatus2(String sgrstatus2) {this.sgrstatus2 = sgrstatus2;}
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 Pjr 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 pjrName;
//电话
private String phone;
//年龄
private String age;
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 getPjrName() {return pjrName;}
public void setPjrName(String pjrName) {this.pjrName = pjrName;}
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;}
}审稿人javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//审稿人
public class Sgr 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 sgrName;
//电话
private String phone;
//年龄
private String age;
//评分
private Integer pf;
//稿件
private Integer types1Id;
//期刊
private Integer types2Id;
//基金
private Integer types3Id;
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 getSgrName() {return sgrName;}
public void setSgrName(String sgrName) {this.sgrName = sgrName;}
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 Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public Integer getTypes1Id() {return types1Id;}
public void setTypes1Id(Integer types1Id) {this.types1Id = types1Id;}
public Integer getTypes2Id() {return types2Id;}
public void setTypes2Id(Integer types2Id) {this.types2Id = types2Id;}
public Integer getTypes3Id() {return types3Id;}
public void setTypes3Id(Integer types3Id) {this.types3Id = types3Id;}
}稿件类型javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//稿件类型
public class Types1 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//稿件类型名称
private String types1Name;
public String getTypes1Name() {return types1Name;}
public void setTypes1Name(String types1Name) {this.types1Name = types1Name;}
}期刊类型javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//期刊类型
public class Types2 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//期刊类型名称
private String types2Name;
public String getTypes2Name() {return types2Name;}
public void setTypes2Name(String types2Name) {this.types2Name = types2Name;}
}基金类型javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//基金类型
public class Types3 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//基金类型名称
private String types3Name;
public String getTypes3Name() {return types3Name;}
public void setTypes3Name(String types3Name) {this.types3Name = types3Name;}
}消息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 Integer bianjiId;
//消息
private String title;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getBianjiId() {return bianjiId;}
public void setBianjiId(Integer bianjiId) {this.bianjiId = bianjiId;}
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;}
}