论文投稿与评审系统

论文投稿与评审系统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’);
SQLCopy
公告表创建语句如下：
create table t_gonggao(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’,
showDate datetime comment ‘日期’
) comment ‘公告’;
SQLCopy
论文评审表创建语句如下：
create table t_lunwen(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
lwlxId int comment ‘论文类型’,
title varchar(100) comment ‘标题’,
fileUrl varchar(100) comment ‘附件’,
insertDate datetime comment ‘日期’,
remark varchar(100) comment ‘备注’,
back varchar(100) comment ‘评语’,
pf int comment ‘评分’,
status varchar(100) comment ‘状态’,
isgb varchar(100) comment ‘是否公布’
) comment ‘论文评审’;
SQLCopy
论文类型表创建语句如下：
create table t_lwlx(
id int primary key auto_increment comment ‘主键’,
lwlxName varchar(100) comment ‘论文类型’
) comment ‘论文类型’;
SQLCopy
评审专家表创建语句如下：
create table t_pszj(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
pszjName varchar(100) comment ‘姓名’,
headPic varchar(100) comment ‘头像’,
phone varchar(100) comment ‘电话’,
sex varchar(100) comment ‘性别’
) comment ‘评审专家’;
SQLCopy
学生表创建语句如下：
create table t_student(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
studentName varchar(100) comment ‘姓名’,
headPic varchar(100) comment ‘头像’,
phone varchar(100) comment ‘电话’,
sex varchar(100) comment ‘性别’
) comment ‘学生’;
SQLCopy

论文投稿与评审系统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 ‘超级管理员’;
SQLCopy
公告表创建语句如下：
create table t_gonggao(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
–公告字段加注释
comment on column t_gonggao.id is ‘主键’;
comment on column t_gonggao.title is ‘标题’;
comment on column t_gonggao.pic is ‘图片’;
comment on column t_gonggao.content is ‘内容’;
comment on column t_gonggao.showDate is ‘日期’;
–公告表加注释
comment on table t_gonggao is ‘公告’;
SQLCopy
论文评审表创建语句如下：
create table t_lunwen(
id integer,
studentId int,
lwlxId int,
title varchar(100),
fileUrl varchar(100),
insertDate datetime,
remark varchar(100),
back varchar(100),
pf int,
status varchar(100),
isgb varchar(100)
);
–论文评审字段加注释
comment on column t_lunwen.id is ‘主键’;
comment on column t_lunwen.studentId is ‘学生’;
comment on column t_lunwen.lwlxId is ‘论文类型’;
comment on column t_lunwen.title is ‘标题’;
comment on column t_lunwen.fileUrl is ‘附件’;
comment on column t_lunwen.insertDate is ‘日期’;
comment on column t_lunwen.remark is ‘备注’;
comment on column t_lunwen.back is ‘评语’;
comment on column t_lunwen.pf is ‘评分’;
comment on column t_lunwen.status is ‘状态’;
comment on column t_lunwen.isgb is ‘是否公布’;
–论文评审表加注释
comment on table t_lunwen is ‘论文评审’;
SQLCopy
论文类型表创建语句如下：
create table t_lwlx(
id integer,
lwlxName varchar(100)
);
–论文类型字段加注释
comment on column t_lwlx.id is ‘主键’;
comment on column t_lwlx.lwlxName is ‘论文类型’;
–论文类型表加注释
comment on table t_lwlx is ‘论文类型’;
SQLCopy
评审专家表创建语句如下：
create table t_pszj(
id integer,
username varchar(100),
password varchar(100),
pszjName varchar(100),
headPic varchar(100),
phone varchar(100),
sex varchar(100)
);
–评审专家字段加注释
comment on column t_pszj.id is ‘主键’;
comment on column t_pszj.username is ‘账号’;
comment on column t_pszj.password is ‘密码’;
comment on column t_pszj.pszjName is ‘姓名’;
comment on column t_pszj.headPic is ‘头像’;
comment on column t_pszj.phone is ‘电话’;
comment on column t_pszj.sex is ‘性别’;
–评审专家表加注释
comment on table t_pszj is ‘评审专家’;
SQLCopy
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
headPic varchar(100),
phone varchar(100),
sex varchar(100)
);
–学生字段加注释
comment on column t_student.id is ‘主键’;
comment on column t_student.username is ‘账号’;
comment on column t_student.password is ‘密码’;
comment on column t_student.studentName is ‘姓名’;
comment on column t_student.headPic is ‘头像’;
comment on column t_student.phone is ‘电话’;
comment on column t_student.sex is ‘性别’;
–学生表加注释
comment on table t_student is ‘学生’;
SQLCopy
oracle特有，对应序列如下：
create sequence s_t_gonggao;
create sequence s_t_lunwen;
create sequence s_t_lwlx;
create sequence s_t_pszj;
create sequence s_t_student;
SQLCopy

论文投稿与评审系统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’);
SQLCopy
公告表创建语句如下：
–公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,–主键
title varchar(100),–标题
pic varchar(100),–图片
content varchar(100),–内容
showDate datetime–日期
);
SQLCopy
论文评审表创建语句如下：
–论文评审表注释
create table t_lunwen(
id int identity(1,1) primary key not null,–主键
studentId int,–学生
lwlxId int,–论文类型
title varchar(100),–标题
fileUrl varchar(100),–附件
insertDate datetime,–日期
remark varchar(100),–备注
back varchar(100),–评语
pf int,–评分
status varchar(100),–状态
isgb varchar(100)–是否公布
);
SQLCopy
论文类型表创建语句如下：
–论文类型表注释
create table t_lwlx(
id int identity(1,1) primary key not null,–主键
lwlxName varchar(100)–论文类型
);
SQLCopy
评审专家表创建语句如下：
–评审专家表注释
create table t_pszj(
id int identity(1,1) primary key not null,–主键
username varchar(100),–账号
password varchar(100),–密码
pszjName varchar(100),–姓名
headPic varchar(100),–头像
phone varchar(100),–电话
sex varchar(100)–性别
);
SQLCopy
学生表创建语句如下：
–学生表注释
create table t_student(
id int identity(1,1) primary key not null,–主键
username varchar(100),–账号
password varchar(100),–密码
studentName varchar(100),–姓名
headPic varchar(100),–头像
phone varchar(100),–电话
sex varchar(100)–性别
);
SQLCopy

论文投稿与评审系统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_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 pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}
JavaCopy
论文评审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_lunwen”)
public class Lunwen {
//主键
@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 studentId;
//论文类型
private Integer lwlxId;
//标题
private String title;
//附件
private String fileUrl;
//日期
private Date insertDate;
//备注
private String remark;
//评语
private String back;
//评分
private Integer pf;
//状态
private String status;
//是否公布
private String isgb;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getLwlxId() {return lwlxId;}
public void setLwlxId(Integer lwlxId) {this.lwlxId = lwlxId;}
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getIsgb() {return isgb;}
public void setIsgb(String isgb) {this.isgb = isgb;}
}
JavaCopy
论文类型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_lwlx”)
public class Lwlx {
//主键
@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 lwlxName;
public String getLwlxName() {return lwlxName;}
public void setLwlxName(String lwlxName) {this.lwlxName = lwlxName;}
}
JavaCopy
评审专家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_pszj”)
public class Pszj {
//主键
@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 pszjName;
//头像
private String headPic;
//电话
private String phone;
//性别
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 getPszjName() {return pszjName;}
public void setPszjName(String pszjName) {this.pszjName = pszjName;}
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}
JavaCopy
学生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_student”)
public class Student {
//主键
@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 studentName;
//头像
private String headPic;
//电话
private String phone;
//性别
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}
JavaCopy

论文投稿与评审系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

公告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 pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}
JavaCopy
论文评审javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//论文评审
public class Lunwen extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//论文类型
private Integer lwlxId;
//标题
private String title;
//附件
private String fileUrl;
//日期
private Date insertDate;
//备注
private String remark;
//评语
private String back;
//评分
private Integer pf;
//状态
private String status;
//是否公布
private String isgb;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getLwlxId() {return lwlxId;}
public void setLwlxId(Integer lwlxId) {this.lwlxId = lwlxId;}
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getIsgb() {return isgb;}
public void setIsgb(String isgb) {this.isgb = isgb;}
}
JavaCopy
论文类型javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//论文类型
public class Lwlx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//论文类型
private String lwlxName;
public String getLwlxName() {return lwlxName;}
public void setLwlxName(String lwlxName) {this.lwlxName = lwlxName;}
}
JavaCopy
评审专家javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//评审专家
public class Pszj 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 pszjName;
//头像
private String headPic;
//电话
private String phone;
//性别
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 getPszjName() {return pszjName;}
public void setPszjName(String pszjName) {this.pszjName = pszjName;}
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}
JavaCopy
学生javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//学生
public class Student 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 studentName;
//头像
private String headPic;
//电话
private String phone;
//性别
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}
JavaCopy