高校科研管理系统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_gg(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
cotnent varchar(100) comment ‘内容’,
showDate datetime comment ‘日期’
) comment ‘公告’;
SQLCopy
科研处表创建语句如下:
create table t_kyc(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
kycName varchar(100) comment ‘负责人姓名’,
phone varchar(100) comment ‘电话’
) comment ‘科研处’;
SQLCopy
项目申请表创建语句如下:
create table t_order(
id int primary key auto_increment comment ‘主键’,
teacherId int comment ‘老师’,
xmmc varchar(100) comment ‘项目名称’,
types varchar(100) comment ‘类型’,
content varchar(100) comment ‘申请内容’,
fileUrl varchar(100) comment ‘附件’,
insertDate datetime comment ‘申请日期’,
status varchar(100) comment ‘状态’,
back1 varchar(100) comment ‘科研处回复’,
back1Date datetime comment ‘科研处回复日期’,
back2 varchar(100) comment ‘院领导回复’,
back2Date datetime comment ‘院领导回复日期’
) comment ‘项目申请’;
SQLCopy
老师表创建语句如下:
create table t_teacher(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
teacherName varchar(100) comment ‘姓名’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’
) comment ‘老师’;
SQLCopy
院领导表创建语句如下:
create table t_yld(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
yldName varchar(100) comment ‘领导姓名’,
phone 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_gg(
id integer,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
showDate datetime
);
–公告字段加注释
comment on column t_gg.id is ‘主键’;
comment on column t_gg.title is ‘标题’;
comment on column t_gg.pic is ‘图片’;
comment on column t_gg.cotnent is ‘内容’;
comment on column t_gg.showDate is ‘日期’;
–公告表加注释
comment on table t_gg is ‘公告’;
SQLCopy
科研处表创建语句如下:
create table t_kyc(
id integer,
username varchar(100),
password varchar(100),
kycName varchar(100),
phone varchar(100)
);
–科研处字段加注释
comment on column t_kyc.id is ‘主键’;
comment on column t_kyc.username is ‘账号’;
comment on column t_kyc.password is ‘密码’;
comment on column t_kyc.kycName is ‘负责人姓名’;
comment on column t_kyc.phone is ‘电话’;
–科研处表加注释
comment on table t_kyc is ‘科研处’;
SQLCopy
项目申请表创建语句如下:
create table t_order(
id integer,
teacherId int,
xmmc varchar(100),
types varchar(100),
content varchar(100),
fileUrl varchar(100),
insertDate datetime,
status varchar(100),
back1 varchar(100),
back1Date datetime,
back2 varchar(100),
back2Date datetime
);
–项目申请字段加注释
comment on column t_order.id is ‘主键’;
comment on column t_order.teacherId is ‘老师’;
comment on column t_order.xmmc is ‘项目名称’;
comment on column t_order.types is ‘类型’;
comment on column t_order.content is ‘申请内容’;
comment on column t_order.fileUrl is ‘附件’;
comment on column t_order.insertDate is ‘申请日期’;