Java毕业设计_期刊稿件处理系统开发

期刊稿件处理系统开发

期刊稿件处理系统开发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_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 ‘编辑’;
SQLCopy
用户表创建语句如下：
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 ‘用户’;
SQLCopy
稿件表创建语句如下：
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 ‘稿件’;
SQLCopy
评级人表创建语句如下：
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 ‘评级人’;
SQLCopy
审稿人表创建语句如下：
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 ‘审稿人’;
SQLCopy
稿件类型表创建语句如下：
create table t_types1(
id int primary key auto_increment comment ‘主键’,
types1Name varchar(100) comment ‘稿件类型名称’
) comment ‘稿件类型’;
SQLCopy
期刊类型表创建语句如下：
create table t_types2(
id int primary key auto_increment comment ‘主键’,
types2Name varchar(100) comment ‘期刊类型名称’
) comment ‘期刊类型’;
SQLCopy
基金类型表创建语句如下：
create table t_types3(
id int primary key auto_increment comment ‘主键’,
types3Name varchar(100) comment ‘基金类型名称’
) comment ‘基金类型’;
SQLCopy
消息表创建语句如下：
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 ‘消息’;
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_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 ‘编辑’;
SQLCopy
用户表创建语句如下：
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 ‘用户’;
SQLCopy
稿件表创建语句如下：
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 ‘稿件’;
SQLCopy
评级人表创建语句如下：
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 ‘评级人’;
SQLCopy
审稿人表创建语句如下：
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_sg