中小学教育反馈系统的设计与实现
中小学教育反馈系统的设计与实现mysql数据库创建语句
中小学教育反馈系统的设计与实现oracle数据库创建语句
中小学教育反馈系统的设计与实现sqlserver数据库创建语句
中小学教育反馈系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
中小学教育反馈系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频:shangyepingtai.xin
中小学教育反馈系统的设计与实现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_banji(
id int primary key auto_increment comment ‘主键’,
banjiName varchar(100) comment ‘班号’,
bjbh varchar(100) comment ‘班级编号’,
fdy varchar(100) comment ‘辅导员’,
jsh varchar(100) comment ‘教室号’,
bzr varchar(100) comment ‘班主任’,
nj varchar(100) comment ‘年级’
) comment ‘班级’;
SQLCopy
成绩表创建语句如下:
create table t_cj(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
kcName varchar(100) comment ‘课程’,
fs varchar(100) comment ‘分数’
) comment ‘成绩’;
SQLCopy
课程表创建语句如下:
create table t_kc(
id int primary key auto_increment comment ‘主键’,
kcName varchar(100) comment ‘课程’,
sksj varchar(100) comment ‘上课时间’,
skdd varchar(100) comment ‘上课地点’,
ls varchar(100) comment ‘老师’,
banjiId int 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 ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
banjiId int comment ‘班级’
) comment ‘学生’;
SQLCopy
校园通知表创建语句如下:
create table t_tongzhi(
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_xiaoyuan(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
types varchar(100) comment ‘类型’,
pic varchar(100) comment ‘图片’,
fileUrl varchar(100) comment ‘附件’,
content varchar(100) comment ‘详细内容’,
showDate 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_banji(
id integer,
banjiName varchar(100),
bjbh varchar(100),
fdy varchar(100),
jsh varchar(100),
bzr varchar(100),
nj varchar(100)
);
–班级字段加注释
comment on column t_banji.id is ‘主键’;
comment on column t_banji.banjiName is ‘班号’;
comment on column t_banji.bjbh is ‘班级编号’;
comment on column t_banji.fdy is ‘辅导员’;
comment on column t_banji.jsh is ‘教室号’;
comment on column t_banji.bzr is ‘班主任’;
comment on column t_banji.nj is ‘年级’;
–班级表加注释
comment on table t_banji is ‘班级’;
SQLCopy
成绩表创建语句如下:
create table t_cj(
id integer,
studentId int,
kcName varchar(100),
fs varchar(100)
);
–成绩字段加注释
comment on column t_cj.id is ‘主键’;
comment on column t_cj.studentId is ‘学生’;
comment on column t_cj.kcName is ‘课程’;
comment on column t_cj.fs is ‘分数’;
–成绩表加注释
comment on table t_cj is ‘成绩’;
SQLCopy
课程表创建语句如下:
create table t_kc(
id integer,
kcName varchar(100),
sksj varchar(100),
skdd varchar(100),
ls varchar(100),
banjiId int
);
–课程字段加注释
comment on column t_kc.id is ‘主键’;
comment on column t_kc.kcName is ‘课程’;
comment on column t_kc.sksj is ‘上课时间’;
comment on column t_kc.skdd is ‘上课地点’;
comment on column t_kc.ls is ‘老师’;
comment on column t_kc.banjiId is ‘班级’;
–课程表加注释
comment on table t_kc is ‘课程’;
SQLCopy
学生表创建语句如下:
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
banjiId int
);
–学生字段加注释
comment on column t_student.id