论文投稿与评审系统
论文投稿与评审系统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_