基于SSM的班级日常事务管理系统
基于SSM的班级日常事务管理系统mysql数据库创建语句
基于SSM的班级日常事务管理系统oracle数据库创建语句
基于SSM的班级日常事务管理系统sqlserver数据库创建语句
基于SSM的班级日常事务管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于SSM的班级日常事务管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频:shangyepingtai.xin
基于SSM的班级日常事务管理系统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 ‘主键’,
xy varchar(100) comment ‘学院’,
nj varchar(100) comment ‘年级’,
zy varchar(100) comment ‘专业’,
banjiName varchar(100) comment ‘班级’,
bzr varchar(100) comment ‘班主任’
) comment ‘班级’;
SQLCopy
班费开支表创建语句如下:
create table t_bfkz(
id int primary key auto_increment comment ‘主键’,
banjiId int comment ‘班级’,
types varchar(100) comment ‘收支类型’,
title varchar(100) comment ‘班费支出说明’,
content varchar(100) comment ‘详细说明’,
fee int comment ‘金额’,
showDate datetime comment ‘使用日期’
) comment ‘班费开支’;
SQLCopy
班级公告表创建语句如下:
create table t_bjgg(
id int primary key auto_increment comment ‘主键’,
banjiId int comment ‘班级’,
title varchar(100) comment ‘标题’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘日期’,
remark varchar(100) comment ‘详情’
) comment ‘班级公告’;
SQLCopy
班级奖励惩罚表创建语句如下:
create table t_bjjc(
id int primary key auto_increment comment ‘主键’,
banjiId int comment ‘班级’,
types varchar(100) comment ‘奖励惩罚’,
title varchar(100) comment ‘标题’,
content varchar(100) comment ‘详细说明’,
showDate datetime comment ‘日期’
) comment ‘班级奖励惩罚’;
SQLCopy
班级考勤表创建语句如下:
create table t_bjkq(
id int primary key auto_increment comment ‘主键’,
banjiId int comment ‘班级’,
studentId int comment ‘学生’,
kc varchar(100) comment ‘课程’,
skrq datetime comment ‘上课日期’,
iskq varchar(100) comment ‘是否缺课’
) comment ‘班级考勤’;
SQLCopy
班级收费表创建语句如下:
create table t_bjsf(
id int primary key auto_increment comment ‘主键’,
banjiId int comment ‘班级’,
title varchar(100) comment ‘收费标题’,
fee int comment ‘收费金额’,
showDate datetime comment ‘日期’
) comment ‘班级收费’;
SQLCopy
班级相册表创建语句如下:
create table t_bjxc(
id int primary key auto_increment comment ‘主键’,
banjiId int comment ‘班级’,
title varchar(100) comment ‘相册标题’,
fileUrl varchar(100) comment ‘图片’
) comment ‘班级相册’;
SQLCopy
成绩表创建语句如下:
create table t_chengji(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
banjiId int comment ‘班级’,
title varchar(100) comment ‘课程’,
fs int comment ‘分数’
) comment ‘成绩’;
SQLCopy
课程表创建语句如下:
create table t_kc(
id int primary key auto_increment comment ‘主键’,
banjiId int comment ‘班级’,
title varchar(100) comment ‘课程名称’,
skls varchar(100) comment ‘上课老师’,
sksj varchar(100) comment ‘上课时间’,
skdd varchar(100) comment ‘上课地点’
) comment ‘课程’;
SQLCopy
考试表创建语句如下:
create table t_ks(
id int primary key auto_increment comment ‘主键’,
banjiId int comment ‘班级’,
title varchar(100) comment ‘考试类型’,
skls varchar(100) comment ‘考试课程’,
sksj varchar(100) comment ‘考试时间’,
skdd varchar(100) comment ‘考试地点’
) comment ‘考试’;
SQLCopy
请假表创建语句如下:
create table t_qingjia(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
banjiId int comment ‘班级’,
title varchar(100) comment ‘请假标题’,
content varchar(100) comment ‘说明’,
qjBeginDate datetime comment ‘请假开始日期’,
qjEndate datetime comment ‘请假结束日期’,
status 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 ‘姓名’,
zy varchar(100) comment ‘专业’,
phone varchar(100) comment ‘电话’,
banjiId int comment ‘班级’,
ss varchar(100) comment ‘宿舍’,
sfz varchar(100) comment ‘身份证’,
js varchar(100) 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 ‘姓名’,
zy varchar(100) comment ‘专业’,
phone varchar(100) comment ‘电话’
) comment ‘老师’;
SQLCopy
作业表创建语句如下:
create table t_zuoye(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
banjiId int comment ‘班级’,
title varchar(100) comment ‘作业名称’,
fileUrl varchar(100) comment ‘作业附件’,
insertDate datetime comment ‘上传日期日期’
) comment ‘作业’;
SQLCopy
基于SSM的班级日常事务管理系统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,
xy varchar(100),
nj varchar(100),
zy varchar(100),
banjiName varchar(100),
bzr varchar(100)
);
–班级字段加注释
comment on column t_banji.id is ‘主键’;
comment on column t_banji.xy is ‘学院’;
comment on column t_banji.nj is ‘年级’;
comment on column t_banji.zy is ‘专业’;
comment on column t_banji.banjiName is ‘班级’;
comment on column t_banji.bzr is ‘班主任’;
–班级表加注释
comment on table t_banji is ‘班级’;
SQLCopy
班费开支表创建语句如下:
create table t_bfkz(
id integer,
banjiId int,
types varchar(100),
title varchar(100),
content varchar(100),
fee int,
showDate datetime
);
–班费开支字段加注释
comment on column t_bfkz.id is ‘主键’;
comment on column t_bfkz.banjiId is ‘班级’;
comment on column t_bfkz.types is ‘收支类型’;
comment on column t_bfkz.title is ‘班费支出说明’;
comment on column t_bfkz.content is ‘详细说明’;
comment on column t_bfkz.fee is ‘金额’;
comment on column t_bfkz.showDate is ‘使用日期’;
–班费开支表加注释
comment on table t_bfkz is ‘班费开支’;
SQLCopy
班级公告表创建语句如下:
create table t_bjgg(
id integer,
banjiId int,
title varchar(100),
content varchar(100),
insertDate datetime,
remark varchar(100)
);
–班级公告字段加注释
comment on column t_bjgg.id is ‘主键’;
comment on column t_bjgg.banjiId is ‘班级’;
comment on column t_bjgg.title is ‘标题’;
comment on column t_bjgg.content is ‘内容’;
comment on column t_bjgg.insertDate is ‘日期’;
comment on column t_bjgg.remark is ‘详情’;
–班级公告表加注释
comment on table t_bjgg is ‘班级公告’;
SQLCopy
班级奖励惩罚表创建语句如下:
create table t_bjjc(
id integer,
banjiId int,
types varchar(100),
title varchar(100),
content varchar(100),
showDate datetime
);
–班级奖励惩罚字段加注释
comment on column t_bjjc.id is ‘主键’;
comment on column t_bjjc.banjiId is ‘班级’;
comment on column t_bjjc.types is ‘奖励惩罚’;
comment on column t_bjjc.title is ‘标题’;
comment on column t_bjjc.content is ‘详细说明’;
comment on column t_bjjc.showDate is ‘日期’;
–班级奖励惩罚表加注释
comment on table t_bjjc is ‘班级奖励惩罚’;
SQLCopy
班级考勤表创建语句如下:
create table t_bjkq(
id integer,
banjiId int,
studentId int,
kc varchar(100),
skrq datetime,
iskq varchar(100)
);
–班级考勤字段加注释
comment on column t_bjkq.id is ‘主键’;
comment on column t_bjkq.banjiId is ‘班级’;
comment on column t_bjkq.studentId is ‘学生’;
comment on column t_bjkq.kc is ‘课程’;
comment on column t_bjkq.skrq is ‘上课日期’;
comment on column t_bjkq.iskq is ‘是否缺课’;
–班级考勤表加注释
comment on table t_bjkq is ‘班级考勤’;
SQLCopy
班级收费表创建语句如下:
create table t_bjsf(
id integer,
banjiId int,
title varchar(100),
fee int,
showDate datetime
);
–班级收费字段加注释
comment on column t_bjsf.id is ‘主键’;
comment on column t_bjsf.banjiId is ‘班级’;
comment on column t_bjsf.title is ‘收费标题’;
comment on column t_bjsf.fee is ‘收费金额’;
comment on column t_bjsf.showDate is ‘日期’;
–班级收费表加注释
comment on table t_bjsf is ‘班级收费’;
SQLCopy
班级相册表创建语句如下:
create table t_bjxc(
id integer,
banjiId int,
title varchar(100),
fileUrl varchar(100)
);
–班级相册字段加注释
comment on column t_bjxc.id is ‘主键’;
comment on column t_bjxc.banjiId is ‘班级’;
comment on column t_bjxc.title is ‘相册标题’;
comment on column t_bjxc.fileUrl is ‘图片’;
–班级相册表加注释
comment on table t_bjxc is ‘班级相册’;
SQLCopy
成绩表创建语句如下:
create table t_chengji(
id integer,
studentId int,
banjiId int,
title varchar(100),
fs int
);
–成绩字段加注释
comment on column t_chengji.id is ‘主键’;
comment on column t_chengji.studentId is ‘学生’;
comment on column t_chengji.banjiId is ‘班级’;
comment on column t_chengji.title is ‘课程’;
comment on column t_chengji.fs is ‘分数’;
–成绩表加注释
comment on table t_chengji is ‘成绩’;
SQLCopy
课程表创建语句如下:
create table t_kc(
id integer,
banjiId int,
title varchar(100),
skls varchar(100),
sksj varchar(100),
skdd varchar(100)
);
–课程字段加注释
comment on column t_kc.id is ‘主键’;
comment on column t_kc.banjiId is ‘班级’;
comment on column t_kc.title is ‘课程名称’;
comment on column t_kc.skls is ‘上课老师’;
comment on column t_kc.sksj is ‘上课时间’;
comment on column t_kc.skdd is ‘上课地点’;
–课程表加注释
comment on table t_kc is ‘课程’;
SQLCopy
考试表创建语句如下:
create table t_ks(
id integer,
banjiId int,
title varchar(100),
skls varchar(100),
sksj varchar(100),
skdd varchar(100)
);
–考试字段加注释
comment on column t_ks.id is ‘主键’;
comment on column t_ks.banjiId is ‘班级’;
comment on column t_ks.title is ‘考试类型’;
comment on column t_ks.skls is ‘考试课程’;
comment on column t_ks.sksj is ‘考试时间’;
comment on column t_ks.skdd is ‘考试地点’;
–考试表加注释
comment on table t_ks is ‘考试’;
SQLCopy
请假表创建语句如下:
create table t_qingjia(
id integer,
studentId int,
banjiId int,
title varchar(100),
content varchar(100),
qjBeginDate datetime,
qjEndate datetime,
s