基于Web的学生作业管理系统的设计与实现

#############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');create table t_banji(id int primary key auto_increment comment '主键',banjiName varchar(100) comment '班级号',fdy varchar(100) comment '辅导员',nj varchar(100) comment '年纪',teacherId int(11) comment ''
) comment '班级';create table t_bjtongzhi(id int primary key auto_increment comment '主键',banjiId int(11) comment '班级',title varchar(1000) comment '内容',insertDate datetime comment '发起日期'
) comment '班级通知';create table t_cc(id int primary key auto_increment comment '主键',clbh varchar(100) comment '车辆编号',showDate datetime comment '日期',khxm varchar(100) comment '客户姓名',dz varchar(100) comment '地址',dh varchar(100) comment '电话',sfz varchar(100) comment '身份证',jsz varchar(100) comment '驾驶证',fzr varchar(100) comment '负责人',mddz varchar(100) comment '门店地址'
) comment '门店出车';create table t_hc(id int primary key auto_increment comment '主键',clbh varchar(100) comment '车辆编号',showDate datetime comment '日期',khxm varchar(100) comment '客户姓名',dz varchar(100) comment '地址',dh varchar(100) comment '电话',sfz varchar(100) comment '身份证',jsz varchar(100) comment '驾驶证',fzr varchar(100) comment '负责人',mddz varchar(100) comment '门店地址',sfsh varchar(100) comment '是否损坏',bcje int(11) comment '补偿金额',remark text comment '备注',fj varchar(100) comment '拍照附件'
) comment '门店还车';create table t_huida(id int primary key auto_increment comment '主键',zuoyeId int(11) comment '作业',teacherId int(11) comment '老师',studentId int(11) comment '学生',pic varchar(100) comment '图片',fileUrl varchar(100) comment '文件',content text comment '内容',insertDate datetime comment '提交日期',status varchar(100) comment '状态',pf int(11) comment '评分',py text comment '评语',pfDate datetime comment '评分日期',dz varchar(50) comment '点赞'
) comment '作业提交';create table t_jiaoliu(id int primary key auto_increment comment '主键',fbr varchar(100) comment '发布人',title varchar(100) comment '标题',pic varchar(100) comment '图片',content text comment '内容'
) comment '讨论平台';create table t_jiaoliulist(id int primary key auto_increment comment '主键',jiaoliuId int(11) comment '交流平台',hdrName varchar(100) comment '回答人',insertDate datetime comment '日期',content text comment '内容'
) comment '讨论平台记录';create table t_jspj(id int primary key auto_increment comment '主键',teacherId int(11) comment '老师',studentId int(11) comment '学生',insertDate datetime comment '日期',content text comment '评价内容',fs int(11) comment '评价分数'
) comment '教师评价';create table t_kecheng(id int primary key auto_increment comment '主键',kechengName varchar(100) comment '课程',teacherId int(11) comment '老师',bjId int(11) comment '',sksj varchar(50) comment ''
) comment '课程';create table t_student(id int primary key auto_increment comment '主键',username varchar(100) comment '账号',password varchar(100) comment '密码',banjiId int(11) comment '班级',studentName varchar(100) comment '姓名',headPic varchar(100) comment '头像',phone varchar(100) comment '电话',age varchar(100) comment '年龄',sex varchar(100) comment '性别',zyId int(11) comment '',xyId int(11) comment ''
) comment '学生';create table t_teacher(id int primary key auto_increment comment '主键',username varchar(100) comment '账号',password varchar(100) comment '密码',teacherName varchar(100) comment '姓名',headPic varchar(100) comment '头像',phone varchar(100) comment '电话',age varchar(100) comment '年龄',sex varchar(100) comment '性别',zw varchar(100) comment '职位'
) comment '老师';create table t_tiwen(id int primary key auto_increment comment '主键',studentId int(11) comment '学生',tiwenName varchar(100) comment '问题',pic varchar(100) comment '图片',content text comment '回答',insertDate datetime comment '时间',status varchar(100) comment '状态'
) comment '学生提问';create table t_xstongzhi(id int primary key auto_increment comment '主键',studentId int(11) comment '学生',title varchar(1000) comment '内容',insertDate datetime comment '发起日期',teacherId int(11) comment ''
) comment '学生通知';create table t_xt(id int primary key auto_increment comment '主键',wt varchar(100) comment '问题',content text comment '答案'
) comment '问题';create table t_xy(id int primary key auto_increment comment '主键',xyName varchar(100) comment '学院'
) comment '学院';create table t_ziyuan(id int primary key auto_increment comment '主键',ziyuanName varchar(100) comment '资源名称',pic varchar(100) comment '图片',fileUrl varchar(100) comment '文件',insertDate datetime comment '时间'
) comment '资源';create table t_zuoye(id int primary key auto_increment comment '主键',teacherId int(11) comment '老师',kechengName varchar(100) comment '课程',banjiId int(11) comment '班级',zuoyeName varchar(100) comment '作业标题',pic varchar(100) comment '图片',fileUrl varchar(100) comment '文件',content text comment '内容',insertDate datetime comment '发布日期',endDate datetime comment ''
) comment '作业发布';create table t_zy(id int primary key auto_increment comment '主键',zyName varchar(100) comment '专业'
) comment '专业';#############oracle数据库创建语句###################
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');create table t_banji(id int primary key auto_increment comment '主键',banjiName varchar(100) comment '班级号',fdy varchar(100) comment '辅导员',nj varchar(100) comment '年纪',teacherId int(11) comment ''
) comment '班级';create table t_bjtongzhi(id int primary key auto_increment comment '主键',banjiId int(11) comment '班级',title varchar(1000) comment '内容',insertDate datetime comment '发起日期'
) comment '班级通知';create table t_cc(id int primary key auto_increment comment '主键',clbh varchar(100) comment '车辆编号',showDate datetime comment '日期',khxm varchar(100) comment '客户姓名',dz varchar(100) comment '地址',dh varchar(100) comment '电话',sfz varchar(100) comment '身份证',jsz varchar(100) comment '驾驶证',fzr varchar(100) comment '负责人',mddz varchar(100) comment '门店地址'
) comment '门店出车';create table t_hc(id int primary key auto_increment comment '主键',clbh varchar(100) comment '车辆编号',showDate datetime comment '日期',khxm varchar(100) comment '客户姓名',dz varchar(100) comment '地址',dh varchar(100) comment '电话',sfz varchar(100) comment '身份证',jsz varchar(100) comment '驾驶证',fzr varchar(100) comment '负责人',mddz varchar(100) comment '门店地址',sfsh varchar(100) comment '是否损坏',bcje int(11) comment '补偿金额',remark text comment '备注',fj varchar(100) comment '拍照附件'
) comment '门店还车';create table t_huida(id int primary key auto_increment comment '主键',zuoyeId int(11) comment '作业',teacherId int(11) comment '老师',studentId int(11) comment '学生',pic varchar(100) comment '图片',fileUrl varchar(100) comment '文件',content text comment '内容',insertDate datetime comment '提交日期',status varchar(100) comment '状态',pf int(11) comment '评分',py text comment '评语',pfDate datetime comment '评分日期',dz varchar(50) comment '点赞'
) comment '作业提交';create table t_jiaoliu(id int primary key auto_increment comment '主键',fbr varchar(100) comment '发布人',title varchar(100) comment '标题',pic varchar(100) comment '图片',content text comment '内容'
) comment '讨论平台';create table t_jiaoliulist(id int primary key auto_increment comment '主键',jiaoliuId int(11) comment '交流平台',hdrName varchar(100) comment '回答人',insertDate datetime comment '日期',content text comment '内容'
) comment '讨论平台记录';create table t_jspj(id int primary key auto_increment comment '主键',teacherId int(11) comment '老师',studentId int(11) comment '学生',insertDate datetime comment '日期',content text comment '评价内容',fs int(11) comment '评价分数'
) comment '教师评价';create table t_kecheng(id int primary key auto_increment comment '主键',kechengName varchar(100) comment '课程',teacherId int(11) comment '老师',bjId int(11) comment '',sksj varchar(50) comment ''
) comment '课程';create table t_student(id int primary key auto_increment comment '主键',username varchar(100) comment '账号',password varchar(100) comment '密码',banjiId int(11) comment '班级',studentName varchar(100) comment '姓名',headPic varchar(100) comment '头像',phone varchar(100) comment '电话',age varchar(100) comment '年龄',sex varchar(100) comment '性别',zyId int(11) comment '',xyId int(11) comment ''
) comment '学生';create table t_teacher(id int primary key auto_increment comment '主键',username varchar(100) comment '账号',password varchar(100) comment '密码',teacherName varchar(100) comment '姓名',headPic varchar(100) comment '头像',phone varchar(100) comment '电话',age varchar(100) comment '年龄',sex varchar(100) comment '性别',zw varchar(100) comment '职位'
) comment '老师';create table t_tiwen(id int primary key auto_increment comment '主键',studentId int(11) comment '学生',tiwenName varchar(100) comment '问题',pic varchar(100) comment '图片',content text comment '回答',insertDate datetime comment '时间',status varchar(100) comment '状态'
) comment '学生提问';create table t_xstongzhi(id int primary key auto_increment comment '主键',studentId int(11) comment '学生',title varchar(1000) comment '内容',insertDate datetime comment '发起日期',teacherId int(11) comment ''
) comment '学生通知';create table t_xt(id int primary key auto_increment comment '主键',wt varchar(100) comment '问题',content text comment '答案'
) comment '问题';create table t_xy(id int primary key auto_increment comment '主键',xyName varchar(100) comment '学院'
) comment '学院';create table t_ziyuan(id int primary key auto_increment comment '主键',ziyuanName varchar(100) comment '资源名称',pic varchar(100) comment '图片',fileUrl varchar(100) comment '文件',insertDate datetime comment '时间'
) comment '资源';create table t_zuoye(id int primary key auto_increment comment '主键',teacherId int(11) comment '老师',kechengName varchar(100) comment '课程',banjiId int(11) comment '班级',zuoyeName varchar(100) comment '作业标题',pic varchar(100) comment '图片',fileUrl varchar(100) comment '文件',content text comment '内容',insertDate datetime comment '发布日期',endDate datetime comment ''
) comment '作业发布';create table t_zy(id int primary key auto_increment comment '主键',zyName varchar(100) comment '专业'
) comment '专业';create table t_banji(id integer,banjiName varchar(100),fdy varchar(100),nj varchar(100),teacherId int(11)
);
--班级字段加注释
comment on column t_banji.id is '主键';
comment on column t_banji.id is '主键唯一ID';
comment on column t_banji.banjiName is '班级号';
comment on column t_banji.fdy is '辅导员';
comment on column t_banji.nj is '年纪';
comment on column t_banji.teacherId is '';
--班级表加注释
comment on table t_banji is '班级';create table t_bjtongzhi(id integer,banjiId int(11),title varchar(1000),insertDate datetime
);
--班级通知字段加注释
comment on column t_bjtongzhi.id is '主键';
comment on column t_bjtongzhi.id is '主键唯一ID';
comment on column t_bjtongzhi.banjiId is '班级';
comment on column t_bjtongzhi.title is '内容';
comment on column t_bjtongzhi.insertDate is '发起日期';
--班级通知表加注释
comment on table t_bjtongzhi is '班级通知';create table t_cc(id integer,clbh varchar(100),showDate datetime,khxm varchar(100),dz varchar(100),dh varchar(100),sfz varchar(100),jsz varchar(100),fzr varchar(100),mddz varchar(100)
);
--门店出车字段加注释
comment on column t_cc.id is '主键';
comment on column t_cc.id is '主键唯一ID';
comment on column t_cc.clbh is '车辆编号';
comment on column t_cc.showDate is '日期';
comment on column t_cc.khxm is '客户姓名';
comment on column t_cc.dz is '地址';
comment on column t_cc.dh is '电话';
comment on column t_cc.sfz is '身份证';
comment on column t_cc.jsz is '驾驶证';
comment on column t_cc.fzr is '负责人';
comment on column t_cc.mddz is '门店地址';
--门店出车表加注释
comment on table t_cc is '门店出车';create table t_hc(id integer,clbh varchar(100),showDate datetime,khxm varchar(100),dz varchar(100),dh varchar(100),sfz varchar(100),jsz varchar(100),fzr varchar(100),mddz varchar(100),sfsh varchar(100),bcje int(11),remark text,fj varchar(100)
);
--门店还车字段加注释
comment on column t_hc.id is '主键';
comment on column t_hc.id is '主键唯一ID';
comment on column t_hc.clbh is '车辆编号';
comment on column t_hc.showDate is '日期';
comment on column t_hc.khxm is '客户姓名';
comment on column t_hc.dz is '地址';
comment on column t_hc.dh is '电话';
comment on column t_hc.sfz is '身份证';
comment on column t_hc.jsz is '驾驶证';
comment on column t_hc.fzr is '负责人';
comment on column t_hc.mddz is '门店地址';
comment on column t_hc.sfsh is '是否损坏';
comment on column t_hc.bcje is '补偿金额';
comment on column t_hc.remark is '备注';
comment on column t_hc.fj is '拍照附件';
--门店还车表加注释
comment on table t_hc is '门店还车';create table t_huida(id integer,zuoyeId int(11),teacherId int(11),studentId int(11),pic varchar(100),fileUrl varchar(100),content text,insertDate datetime,status varchar(100),pf int(11),py text,pfDate datetime,dz varchar(50)
);
--作业提交字段加注释
comment on column t_huida.id is '主键';
comment on column t_huida.id is '主键唯一ID';
comment on column t_huida.zuoyeId is '作业';
comment on column t_huida.teacherId is '老师';
comment on column t_huida.studentId is '学生';
comment on column t_huida.pic is '图片';
comment on column t_huida.fileUrl is '文件';
comment on column t_huida.content is '内容';
comment on column t_huida.insertDate is '提交日期';
comment on column t_huida.status is '状态';
comment on column t_huida.pf is '评分';
comment on column t_huida.py is '评语';
comment on column t_huida.pfDate is '评分日期';
comment on column t_huida.dz is '点赞';
--作业提交表加注释
comment on table t_huida is '作业提交';create table t_jiaoliu(id integer,fbr varchar(100),title varchar(100),pic varchar(100),content text
);
--讨论平台字段加注释
comment on column t_jiaoliu.id is '主键';
comment on column t_jiaoliu.id is '主键唯一ID';
comment on column t_jiaoliu.fbr is '发布人';
comment on column t_jiaoliu.title is '标题';
comment on column t_jiaoliu.pic is '图片';
comment on column t_jiaoliu.content is '内容';
--讨论平台表加注释
comment on table t_jiaoliu is '讨论平台';create table t_jiaoliulist(id integer,jiaoliuId int(11),hdrName varchar(100),insertDate datetime,content text
);
--讨论平台记录字段加注释
comment on column t_jiaoliulist.id is '主键';
comment on column t_jiaoliulist.id is '主键唯一ID';
comment on column t_jiaoliulist.jiaoliuId is '交流平台';
comment on column t_jiaoliulist.hdrName is '回答人';
comment on column t_jiaoliulist.insertDate is '日期';
comment on column t_jiaoliulist.content is '内容';
--讨论平台记录表加注释
comment on table t_jiaoliulist is '讨论平台记录';create table t_jspj(id integer,teacherId int(11),studentId int(11),insertDate datetime,content text,fs int(11)
);
--教师评价字段加注释
comment on column t_jspj.id is '主键';
comment on column t_jspj.id is '主键唯一ID';
comment on column t_jspj.teacherId is '老师';
comment on column t_jspj.studentId is '学生';
comment on column t_jspj.insertDate is '日期';
comment on column t_jspj.content is '评价内容';
comment on column t_jspj.fs is '评价分数';
--教师评价表加注释
comment on table t_jspj is '教师评价';create table t_kecheng(id integer,kechengName varchar(100),teacherId int(11),bjId int(11),sksj varchar(50)
);
--课程字段加注释
comment on column t_kecheng.id is '主键';
comment on column t_kecheng.id is '主键唯一ID';
comment on column t_kecheng.kechengName is '课程';
comment on column t_kecheng.teacherId is '老师';
comment on column t_kecheng.bjId is '';
comment on column t_kecheng.sksj is '';
--课程表加注释
comment on table t_kecheng is '课程';create table t_student(id integer,username varchar(100),password varchar(100),banjiId int(11),studentName varchar(100),headPic varchar(100),phone varchar(100),age varchar(100),sex varchar(100),zyId int(11),xyId int(11)
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.id is '主键唯一ID';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码';
comment on column t_student.banjiId is '班级';
comment on column t_student.studentName is '姓名';
comment on column t_student.headPic is '头像';
comment on column t_student.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.zyId is '';
comment on column t_student.xyId is '';
--学生表加注释
comment on table t_student is '学生';create table t_teacher(id integer,username varchar(100),password varchar(100),teacherName varchar(100),headPic varchar(100),phone varchar(100),age varchar(100),sex varchar(100),zw varchar(100)
);
--老师字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.id is '主键唯一ID';
comment on column t_teacher.username is '账号';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '姓名';
comment on column t_teacher.headPic is '头像';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.zw is '职位';
--老师表加注释
comment on table t_teacher is '老师';create table t_tiwen(id integer,studentId int(11),tiwenName varchar(100),pic varchar(100),content text,insertDate datetime,status varchar(100)
);
--学生提问字段加注释
comment on column t_tiwen.id is '主键';
comment on column t_tiwen.id is '主键唯一ID';
comment on column t_tiwen.studentId is '学生';
comment on column t_tiwen.tiwenName is '问题';
comment on column t_tiwen.pic is '图片';
comment on column t_tiwen.content is '回答';
comment on column t_tiwen.insertDate is '时间';
comment on column t_tiwen.status is '状态';
--学生提问表加注释
comment on table t_tiwen is '学生提问';create table t_xstongzhi(id integer,studentId int(11),title varchar(1000),insertDate datetime,teacherId int(11)
);
--学生通知字段加注释
comment on column t_xstongzhi.id is '主键';
comment on column t_xstongzhi.id is '主键唯一ID';
comment on column t_xstongzhi.studentId is '学生';
comment on column t_xstongzhi.title is '内容';
comment on column t_xstongzhi.insertDate is '发起日期';
comment on column t_xstongzhi.teacherId is '';
--学生通知表加注释
comment on table t_xstongzhi is '学生通知';create table t_xt(id integer,wt varchar(100),content text
);
--问题字段加注释
comment on column t_xt.id is '主键';
comment on column t_xt.id is '主键唯一ID';
comment on column t_xt.wt is '问题';
comment on column t_xt.content is '答案';
--问题表加注释
comment on table t_xt is '问题';create table t_xy(id integer,xyName varchar(100)
);
--学院字段加注释
comment on column t_xy.id is '主键';
comment on column t_xy.id is '主键唯一ID';
comment on column t_xy.xyName is '学院';
--学院表加注释
comment on table t_xy is '学院';create table t_ziyuan(id integer,ziyuanName varchar(100),pic varchar(100),fileUrl varchar(100),insertDate datetime
);
--资源字段加注释
comment on column t_ziyuan.id is '主键';
comment on column t_ziyuan.id is '主键唯一ID';
comment on column t_ziyuan.ziyuanName is '资源名称';
comment on column t_ziyuan.pic is '图片';
comment on column t_ziyuan.fileUrl is '文件';
comment on column t_ziyuan.insertDate is '时间';
--资源表加注释
comment on table t_ziyuan is '资源';create table t_zuoye(id integer,teacherId int(11),kechengName varchar(100),banjiId int(11),zuoyeName varchar(100),pic varchar(100),fileUrl varchar(100),content text,insertDate datetime,endDate datetime
);
--作业发布字段加注释
comment on column t_zuoye.id is '主键';
comment on column t_zuoye.id is '主键唯一ID';
comment on column t_zuoye.teacherId is '老师';
comment on column t_zuoye.kechengName is '课程';
comment on column t_zuoye.banjiId is '班级';
comment on column t_zuoye.zuoyeName is '作业标题';
comment on column t_zuoye.pic is '图片';
comment on column t_zuoye.fileUrl is '文件';
comment on column t_zuoye.content is '内容';
comment on column t_zuoye.insertDate is '发布日期';
comment on column t_zuoye.endDate is '';
--作业发布表加注释
comment on table t_zuoye is '作业发布';create table t_zy(id integer,zyName varchar(100)
);
--专业字段加注释
comment on column t_zy.id is '主键';
comment on column t_zy.id is '主键唯一ID';
comment on column t_zy.zyName is '专业';
--专业表加注释
comment on table t_zy is '专业';#############sqlserver数据库创建语句###################
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');create table t_banji(id int primary key auto_increment comment '主键',banjiName varchar(100) comment '班级号',fdy varchar(100) comment '辅导员',nj varchar(100) comment '年纪',teacherId int(11) comment ''
) comment '班级';create table t_bjtongzhi(id int primary key auto_increment comment '主键',banjiId int(11) comment '班级',title varchar(1000) comment '内容',insertDate datetime comment '发起日期'
) comment '班级通知';create table t_cc(id int primary key auto_increment comment '主键',clbh varchar(100) comment '车辆编号',showDate datetime comment '日期',khxm varchar(100) comment '客户姓名',dz varchar(100) comment '地址',dh varchar(100) comment '电话',sfz varchar(100) comment '身份证',jsz varchar(100) comment '驾驶证',fzr varchar(100) comment '负责人',mddz varchar(100) comment '门店地址'
) comment '门店出车';create table t_hc(id int primary key auto_increment comment '主键',clbh varchar(100) comment '车辆编号',showDate datetime comment '日期',khxm varchar(100) comment '客户姓名',dz varchar(100) comment '地址',dh varchar(100) comment '电话',sfz varchar(100) comment '身份证',jsz varchar(100) comment '驾驶证',fzr varchar(100) comment '负责人',mddz varchar(100) comment '门店地址',sfsh varchar(100) comment '是否损坏',bcje int(11) comment '补偿金额',remark text comment '备注',fj varchar(100) comment '拍照附件'
) comment '门店还车';create table t_huida(id int primary key auto_increment comment '主键',zuoyeId int(11) comment '作业',teacherId int(11) comment '老师',studentId int(11) comment '学生',pic varchar(100) comment '图片',fileUrl varchar(100) comment '文件',content text comment '内容',insertDate datetime comment '提交日期',status varchar(100) comment '状态',pf int(11) comment '评分',py text comment '评语',pfDate datetime comment '评分日期',dz varchar(50) comment '点赞'
) comment '作业提交';create table t_jiaoliu(id int primary key auto_increment comment '主键',fbr varchar(100) comment '发布人',title varchar(100) comment '标题',pic varchar(100) comment '图片',content text comment '内容'
) comment '讨论平台';create table t_jiaoliulist(id int primary key auto_increment comment '主键',jiaoliuId int(11) comment '交流平台',hdrName varchar(100) comment '回答人',insertDate datetime comment '日期',content text comment '内容'
) comment '讨论平台记录';create table t_jspj(id int primary key auto_increment comment '主键',teacherId int(11) comment '老师',studentId int(11) comment '学生',insertDate datetime comment '日期',content text comment '评价内容',fs int(11) comment '评价分数'
) comment '教师评价';create table t_kecheng(id int primary key auto_increment comment '主键',kechengName varchar(100) comment '课程',teacherId int(11) comment '老师',bjId int(11) comment '',sksj varchar(50) comment ''
) comment '课程';create table t_student(id int primary key auto_increment comment '主键',username varchar(100) comment '账号',password varchar(100) comment '密码',banjiId int(11) comment '班级',studentName varchar(100) comment '姓名',headPic varchar(100) comment '头像',phone varchar(100) comment '电话',age varchar(100) comment '年龄',sex varchar(100) comment '性别',zyId int(11) comment '',xyId int(11) comment ''
) comment '学生';create table t_teacher(id int primary key auto_increment comment '主键',username varchar(100) comment '账号',password varchar(100) comment '密码',teacherName varchar(100) comment '姓名',headPic varchar(100) comment '头像',phone varchar(100) comment '电话',age varchar(100) comment '年龄',sex varchar(100) comment '性别',zw varchar(100) comment '职位'
) comment '老师';create table t_tiwen(id int primary key auto_increment comment '主键',studentId int(11) comment '学生',tiwenName varchar(100) comment '问题',pic varchar(100) comment '图片',content text comment '回答',insertDate datetime comment '时间',status varchar(100) comment '状态'
) comment '学生提问';create table t_xstongzhi(id int primary key auto_increment comment '主键',studentId int(11) comment '学生',title varchar(1000) comment '内容',insertDate datetime comment '发起日期',teacherId int(11) comment ''
) comment '学生通知';create table t_xt(id int primary key auto_increment comment '主键',wt varchar(100) comment '问题',content text comment '答案'
) comment '问题';create table t_xy(id int primary key auto_increment comment '主键',xyName varchar(100) comment '学院'
) comment '学院';create table t_ziyuan(id int primary key auto_increment comment '主键',ziyuanName varchar(100) comment '资源名称',pic varchar(100) comment '图片',fileUrl varchar(100) comment '文件',insertDate datetime comment '时间'
) comment '资源';create table t_zuoye(id int primary key auto_increment comment '主键',teacherId int(11) comment '老师',kechengName varchar(100) comment '课程',banjiId int(11) comment '班级',zuoyeName varchar(100) comment '作业标题',pic varchar(100) comment '图片',fileUrl varchar(100) comment '文件',content text comment '内容',insertDate datetime comment '发布日期',endDate datetime comment ''
) comment '作业发布';create table t_zy(id int primary key auto_increment comment '主键',zyName varchar(100) comment '专业'
) comment '专业';create table t_banji(id integer,banjiName varchar(100),fdy varchar(100),nj varchar(100),teacherId int(11)
);
--班级字段加注释
comment on column t_banji.id is '主键';
comment on column t_banji.id is '主键唯一ID';
comment on column t_banji.banjiName is '班级号';
comment on column t_banji.fdy is '辅导员';
comment on column t_banji.nj is '年纪';
comment on column t_banji.teacherId is '';
--班级表加注释
comment on table t_banji is '班级';create table t_bjtongzhi(id integer,banjiId int(11),title varchar(1000),insertDate datetime
);
--班级通知字段加注释
comment on column t_bjtongzhi.id is '主键';
comment on column t_bjtongzhi.id is '主键唯一ID';
comment on column t_bjtongzhi.banjiId is '班级';
comment on column t_bjtongzhi.title is '内容';
comment on column t_bjtongzhi.insertDate is '发起日期';
--班级通知表加注释
comment on table t_bjtongzhi is '班级通知';create table t_cc(id integer,clbh varchar(100),showDate datetime,khxm varchar(100),dz varchar(100),dh varchar(100),sfz varchar(100),jsz varchar(100),fzr varchar(100),mddz varchar(100)
);
--门店出车字段加注释
comment on column t_cc.id is '主键';
comment on column t_cc.id is '主键唯一ID';
comment on column t_cc.clbh is '车辆编号';
comment on column t_cc.showDate is '日期';
comment on column t_cc.khxm is '客户姓名';
comment on column t_cc.dz is '地址';
comment on column t_cc.dh is '电话';
comment on column t_cc.sfz is '身份证';
comment on column t_cc.jsz is '驾驶证';
comment on column t_cc.fzr is '负责人';
comment on column t_cc.mddz is '门店地址';
--门店出车表加注释
comment on table t_cc is '门店出车';create table t_hc(id integer,clbh varchar(100),showDate datetime,khxm varchar(100),dz varchar(100),dh varchar(100),sfz varchar(100),jsz varchar(100),fzr varchar(100),mddz varchar(100),sfsh varchar(100),bcje int(11),remark text,fj varchar(100)
);
--门店还车字段加注释
comment on column t_hc.id is '主键';
comment on column t_hc.id is '主键唯一ID';
comment on column t_hc.clbh is '车辆编号';
comment on column t_hc.showDate is '日期';
comment on column t_hc.khxm is '客户姓名';
comment on column t_hc.dz is '地址';
comment on column t_hc.dh is '电话';
comment on column t_hc.sfz is '身份证';
comment on column t_hc.jsz is '驾驶证';
comment on column t_hc.fzr is '负责人';
comment on column t_hc.mddz is '门店地址';
comment on column t_hc.sfsh is '是否损坏';
comment on column t_hc.bcje is '补偿金额';
comment on column t_hc.remark is '备注';
comment on column t_hc.fj is '拍照附件';
--门店还车表加注释
comment on table t_hc is '门店还车';create table t_huida(id integer,zuoyeId int(11),teacherId int(11),studentId int(11),pic varchar(100),fileUrl varchar(100),content text,insertDate datetime,status varchar(100),pf int(11),py text,pfDate datetime,dz varchar(50)
);
--作业提交字段加注释
comment on column t_huida.id is '主键';
comment on column t_huida.id is '主键唯一ID';
comment on column t_huida.zuoyeId is '作业';
comment on column t_huida.teacherId is '老师';
comment on column t_huida.studentId is '学生';
comment on column t_huida.pic is '图片';
comment on column t_huida.fileUrl is '文件';
comment on column t_huida.content is '内容';
comment on column t_huida.insertDate is '提交日期';
comment on column t_huida.status is '状态';
comment on column t_huida.pf is '评分';
comment on column t_huida.py is '评语';
comment on column t_huida.pfDate is '评分日期';
comment on column t_huida.dz is '点赞';
--作业提交表加注释
comment on table t_huida is '作业提交';create table t_jiaoliu(id integer,fbr varchar(100),title varchar(100),pic varchar(100),content text
);
--讨论平台字段加注释
comment on column t_jiaoliu.id is '主键';
comment on column t_jiaoliu.id is '主键唯一ID';
comment on column t_jiaoliu.fbr is '发布人';
comment on column t_jiaoliu.title is '标题';
comment on column t_jiaoliu.pic is '图片';
comment on column t_jiaoliu.content is '内容';
--讨论平台表加注释
comment on table t_jiaoliu is '讨论平台';create table t_jiaoliulist(id integer,jiaoliuId int(11),hdrName varchar(100),insertDate datetime,content text
);
--讨论平台记录字段加注释
comment on column t_jiaoliulist.id is '主键';
comment on column t_jiaoliulist.id is '主键唯一ID';
comment on column t_jiaoliulist.jiaoliuId is '交流平台';
comment on column t_jiaoliulist.hdrName is '回答人';
comment on column t_jiaoliulist.insertDate is '日期';
comment on column t_jiaoliulist.content is '内容';
--讨论平台记录表加注释
comment on table t_jiaoliulist is '讨论平台记录';create table t_jspj(id integer,teacherId int(11),studentId int(11),insertDate datetime,content text,fs int(11)
);
--教师评价字段加注释
comment on column t_jspj.id is '主键';
comment on column t_jspj.id is '主键唯一ID';
comment on column t_jspj.teacherId is '老师';
comment on column t_jspj.studentId is '学生';
comment on column t_jspj.insertDate is '日期';
comment on column t_jspj.content is '评价内容';
comment on column t_jspj.fs is '评价分数';
--教师评价表加注释
comment on table t_jspj is '教师评价';create table t_kecheng(id integer,kechengName varchar(100),teacherId int(11),bjId int(11),sksj varchar(50)
);
--课程字段加注释
comment on column t_kecheng.id is '主键';
comment on column t_kecheng.id is '主键唯一ID';
comment on column t_kecheng.kechengName is '课程';
comment on column t_kecheng.teacherId is '老师';
comment on column t_kecheng.bjId is '';
comment on column t_kecheng.sksj is '';
--课程表加注释
comment on table t_kecheng is '课程';create table t_student(id integer,username varchar(100),password varchar(100),banjiId int(11),studentName varchar(100),headPic varchar(100),phone varchar(100),age varchar(100),sex varchar(100),zyId int(11),xyId int(11)
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.id is '主键唯一ID';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码';
comment on column t_student.banjiId is '班级';
comment on column t_student.studentName is '姓名';
comment on column t_student.headPic is '头像';
comment on column t_student.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.zyId is '';
comment on column t_student.xyId is '';
--学生表加注释
comment on table t_student is '学生';create table t_teacher(id integer,username varchar(100),password varchar(100),teacherName varchar(100),headPic varchar(100),phone varchar(100),age varchar(100),sex varchar(100),zw varchar(100)
);
--老师字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.id is '主键唯一ID';
comment on column t_teacher.username is '账号';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '姓名';
comment on column t_teacher.headPic is '头像';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.zw is '职位';
--老师表加注释
comment on table t_teacher is '老师';create table t_tiwen(id integer,studentId int(11),tiwenName varchar(100),pic varchar(100),content text,insertDate datetime,status varchar(100)
);
--学生提问字段加注释
comment on column t_tiwen.id is '主键';
comment on column t_tiwen.id is '主键唯一ID';
comment on column t_tiwen.studentId is '学生';
comment on column t_tiwen.tiwenName is '问题';
comment on column t_tiwen.pic is '图片';
comment on column t_tiwen.content is '回答';
comment on column t_tiwen.insertDate is '时间';
comment on column t_tiwen.status is '状态';
--学生提问表加注释
comment on table t_tiwen is '学生提问';create table t_xstongzhi(id integer,studentId int(11),title varchar(1000),insertDate datetime,teacherId int(11)
);
--学生通知字段加注释
comment on column t_xstongzhi.id is '主键';
comment on column t_xstongzhi.id is '主键唯一ID';
comment on column t_xstongzhi.studentId is '学生';
comment on column t_xstongzhi.title is '内容';
comment on column t_xstongzhi.insertDate is '发起日期';
comment on column t_xstongzhi.teacherId is '';
--学生通知表加注释
comment on table t_xstongzhi is '学生通知';create table t_xt(id integer,wt varchar(100),content text
);
--问题字段加注释
comment on column t_xt.id is '主键';
comment on column t_xt.id is '主键唯一ID';
comment on column t_xt.wt is '问题';
comment on column t_xt.content is '答案';
--问题表加注释
comment on table t_xt is '问题';create table t_xy(id integer,xyName varchar(100)
);
--学院字段加注释
comment on column t_xy.id is '主键';
comment on column t_xy.id is '主键唯一ID';
comment on column t_xy.xyName is '学院';
--学院表加注释
comment on table t_xy is '学院';create table t_ziyuan(id integer,ziyuanName varchar(100),pic varchar(100),fileUrl varchar(100),insertDate datetime
);
--资源字段加注释
comment on column t_ziyuan.id is '主键';
comment on column t_ziyuan.id is '主键唯一ID';
comment on column t_ziyuan.ziyuanName is '资源名称';
comment on column t_ziyuan.pic is '图片';
comment on column t_ziyuan.fileUrl is '文件';
comment on column t_ziyuan.insertDate is '时间';
--资源表加注释
comment on table t_ziyuan is '资源';create table t_zuoye(id integer,teacherId int(11),kechengName varchar(100),banjiId int(11),zuoyeName varchar(100),pic varchar(100),fileUrl varchar(100),content text,insertDate datetime,endDate datetime
);
--作业发布字段加注释
comment on column t_zuoye.id is '主键';
comment on column t_zuoye.id is '主键唯一ID';
comment on column t_zuoye.teacherId is '老师';
comment on column t_zuoye.kechengName is '课程';
comment on column t_zuoye.banjiId is '班级';
comment on column t_zuoye.zuoyeName is '作业标题';
comment on column t_zuoye.pic is '图片';
comment on column t_zuoye.fileUrl is '文件';
comment on column t_zuoye.content is '内容';
comment on column t_zuoye.insertDate is '发布日期';
comment on column t_zuoye.endDate is '';
--作业发布表加注释
comment on table t_zuoye is '作业发布';create table t_zy(id integer,zyName varchar(100)
);
--专业字段加注释
comment on column t_zy.id is '主键';
comment on column t_zy.id is '主键唯一ID';
comment on column t_zy.zyName is '专业';
--专业表加注释
comment on table t_zy is '专业';--班级表注释
create table t_banji(id int identity(1,1) primary key not null,--主键banjiName varchar(100),--班级号fdy varchar(100),--辅导员nj varchar(100),--年纪teacherId int(11)--
);--班级通知表注释
create table t_bjtongzhi(id int identity(1,1) primary key not null,--主键banjiId int(11),--班级title varchar(1000),--内容insertDate datetime--发起日期
);--门店出车表注释
create table t_cc(id int identity(1,1) primary key not null,--主键clbh varchar(100),--车辆编号showDate datetime,--日期khxm varchar(100),--客户姓名dz varchar(100),--地址dh varchar(100),--电话sfz varchar(100),--身份证jsz varchar(100),--驾驶证fzr varchar(100),--负责人mddz varchar(100)--门店地址
);--门店还车表注释
create table t_hc(id int identity(1,1) primary key not null,--主键clbh varchar(100),--车辆编号showDate datetime,--日期khxm varchar(100),--客户姓名dz varchar(100),--地址dh varchar(100),--电话sfz varchar(100),--身份证jsz varchar(100),--驾驶证fzr varchar(100),--负责人mddz varchar(100),--门店地址sfsh varchar(100),--是否损坏bcje int(11),--补偿金额remark text,--备注fj varchar(100)--拍照附件
);--作业提交表注释
create table t_huida(id int identity(1,1) primary key not null,--主键zuoyeId int(11),--作业teacherId int(11),--老师studentId int(11),--学生pic varchar(100),--图片fileUrl varchar(100),--文件content text,--内容insertDate datetime,--提交日期status varchar(100),--状态pf int(11),--评分py text,--评语pfDate datetime,--评分日期dz varchar(50)--点赞
);--讨论平台表注释
create table t_jiaoliu(id int identity(1,1) primary key not null,--主键fbr varchar(100),--发布人title varchar(100),--标题pic varchar(100),--图片content text--内容
);--讨论平台记录表注释
create table t_jiaoliulist(id int identity(1,1) primary key not null,--主键jiaoliuId int(11),--交流平台hdrName varchar(100),--回答人insertDate datetime,--日期content text--内容
);--教师评价表注释
create table t_jspj(id int identity(1,1) primary key not null,--主键teacherId int(11),--老师studentId int(11),--学生insertDate datetime,--日期content text,--评价内容fs int(11)--评价分数
);--课程表注释
create table t_kecheng(id int identity(1,1) primary key not null,--主键kechengName varchar(100),--课程teacherId int(11),--老师bjId int(11),--sksj varchar(50)--
);--学生表注释
create table t_student(id int identity(1,1) primary key not null,--主键username varchar(100),--账号password varchar(100),--密码banjiId int(11),--班级studentName varchar(100),--姓名headPic varchar(100),--头像phone varchar(100),--电话age varchar(100),--年龄sex varchar(100),--性别zyId int(11),--xyId int(11)--
);--老师表注释
create table t_teacher(id int identity(1,1) primary key not null,--主键username varchar(100),--账号password varchar(100),--密码teacherName varchar(100),--姓名headPic varchar(100),--头像phone varchar(100),--电话age varchar(100),--年龄sex varchar(100),--性别zw varchar(100)--职位
);--学生提问表注释
create table t_tiwen(id int identity(1,1) primary key not null,--主键studentId int(11),--学生tiwenName varchar(100),--问题pic varchar(100),--图片content text,--回答insertDate datetime,--时间status varchar(100)--状态
);--学生通知表注释
create table t_xstongzhi(id int identity(1,1) primary key not null,--主键studentId int(11),--学生title varchar(1000),--内容insertDate datetime,--发起日期teacherId int(11)--
);--问题表注释
create table t_xt(id int identity(1,1) primary key not null,--主键wt varchar(100),--问题content text--答案
);--学院表注释
create table t_xy(id int identity(1,1) primary key not null,--主键xyName varchar(100)--学院
);--资源表注释
create table t_ziyuan(id int identity(1,1) primary key not null,--主键ziyuanName varchar(100),--资源名称pic varchar(100),--图片fileUrl varchar(100),--文件insertDate datetime--时间
);--作业发布表注释
create table t_zuoye(id int identity(1,1) primary key not null,--主键teacherId int(11),--老师kechengName varchar(100),--课程banjiId int(11),--班级zuoyeName varchar(100),--作业标题pic varchar(100),--图片fileUrl varchar(100),--文件content text,--内容insertDate datetime,--发布日期endDate datetime--
);--专业表注释
create table t_zy(id int identity(1,1) primary key not null,--主键zyName varchar(100)--专业
);

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//班级
public class Banji  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//班级号
private String banjiName;
//辅导员
private String fdy;
//年纪
private String nj;
//
private int teacherId;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getBanjiName() {return banjiName;}
public void setBanjiName(String banjiName) {this.banjiName = banjiName;}
public String getFdy() {return fdy;}
public void setFdy(String fdy) {this.fdy = fdy;}
public String getNj() {return nj;}
public void setNj(String nj) {this.nj = nj;}
public int getTeacherId() {return teacherId;}
public void setTeacherId(int teacherId) {this.teacherId = teacherId;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//班级通知
public class Bjtongzhi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//班级
private int banjiId;
//内容
private String title;
//发起日期
private Date insertDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getBanjiId() {return banjiId;}
public void setBanjiId(int banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//门店出车
public class Cc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//车辆编号
private String clbh;
//日期
private Date showDate;
//客户姓名
private String khxm;
//地址
private String dz;
//电话
private String dh;
//身份证
private String sfz;
//驾驶证
private String jsz;
//负责人
private String fzr;
//门店地址
private String mddz;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getClbh() {return clbh;}
public void setClbh(String clbh) {this.clbh = clbh;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKhxm() {return khxm;}
public void setKhxm(String khxm) {this.khxm = khxm;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJsz() {return jsz;}
public void setJsz(String jsz) {this.jsz = jsz;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getMddz() {return mddz;}
public void setMddz(String mddz) {this.mddz = mddz;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//门店还车
public class Hc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//车辆编号
private String clbh;
//日期
private Date showDate;
//客户姓名
private String khxm;
//地址
private String dz;
//电话
private String dh;
//身份证
private String sfz;
//驾驶证
private String jsz;
//负责人
private String fzr;
//门店地址
private String mddz;
//是否损坏
private String sfsh;
//补偿金额
private int bcje;
//备注
private String remark;
//拍照附件
private String fj;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getClbh() {return clbh;}
public void setClbh(String clbh) {this.clbh = clbh;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKhxm() {return khxm;}
public void setKhxm(String khxm) {this.khxm = khxm;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJsz() {return jsz;}
public void setJsz(String jsz) {this.jsz = jsz;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getMddz() {return mddz;}
public void setMddz(String mddz) {this.mddz = mddz;}
public String getSfsh() {return sfsh;}
public void setSfsh(String sfsh) {this.sfsh = sfsh;}
public int getBcje() {return bcje;}
public void setBcje(int bcje) {this.bcje = bcje;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//作业提交
public class Huida  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//作业
private int zuoyeId;
//老师
private int teacherId;
//学生
private int studentId;
//图片
private String pic;
//文件
private String fileUrl;
//内容
private String content;
//提交日期
private Date insertDate;
//状态
private String status;
//评分
private int pf;
//评语
private String py;
//评分日期
private Date pfDate;
//点赞
private String dz;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getZuoyeId() {return zuoyeId;}
public void setZuoyeId(int zuoyeId) {this.zuoyeId = zuoyeId;}
public int getTeacherId() {return teacherId;}
public void setTeacherId(int teacherId) {this.teacherId = teacherId;}
public int getStudentId() {return studentId;}
public void setStudentId(int studentId) {this.studentId = studentId;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public int getPf() {return pf;}
public void setPf(int pf) {this.pf = pf;}
public String getPy() {return py;}
public void setPy(String py) {this.py = py;}
public Date getPfDate() {return pfDate;}
public void setPfDate(Date pfDate) {this.pfDate = pfDate;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//讨论平台
public class Jiaoliu  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//发布人
private String fbr;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getFbr() {return fbr;}
public void setFbr(String fbr) {this.fbr = fbr;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//讨论平台记录
public class Jiaoliulist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//交流平台
private int jiaoliuId;
//回答人
private String hdrName;
//日期
private Date insertDate;
//内容
private String content;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getJiaoliuId() {return jiaoliuId;}
public void setJiaoliuId(int jiaoliuId) {this.jiaoliuId = jiaoliuId;}
public String getHdrName() {return hdrName;}
public void setHdrName(String hdrName) {this.hdrName = hdrName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//教师评价
public class Jspj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//老师
private int teacherId;
//学生
private int studentId;
//日期
private Date insertDate;
//评价内容
private String content;
//评价分数
private int fs;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getTeacherId() {return teacherId;}
public void setTeacherId(int teacherId) {this.teacherId = teacherId;}
public int getStudentId() {return studentId;}
public void setStudentId(int studentId) {this.studentId = studentId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public int getFs() {return fs;}
public void setFs(int fs) {this.fs = fs;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//课程
public class Kecheng  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//课程
private String kechengName;
//老师
private int teacherId;
//
private int bjId;
//
private String sksj;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getKechengName() {return kechengName;}
public void setKechengName(String kechengName) {this.kechengName = kechengName;}
public int getTeacherId() {return teacherId;}
public void setTeacherId(int teacherId) {this.teacherId = teacherId;}
public int getBjId() {return bjId;}
public void setBjId(int bjId) {this.bjId = bjId;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//学生
public class Student  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//账号
private String username;
//密码
private String password;
//班级
private int banjiId;
//姓名
private String studentName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//
private int zyId;
//
private int xyId;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public int getBanjiId() {return banjiId;}
public void setBanjiId(int banjiId) {this.banjiId = banjiId;}
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public int getZyId() {return zyId;}
public void setZyId(int zyId) {this.zyId = zyId;}
public int getXyId() {return xyId;}
public void setXyId(int xyId) {this.xyId = xyId;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//老师
public class Teacher  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//账号
private String username;
//密码
private String password;
//姓名
private String teacherName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//职位
private String zw;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//学生提问
public class Tiwen  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//学生
private int studentId;
//问题
private String tiwenName;
//图片
private String pic;
//回答
private String content;
//时间
private Date insertDate;
//状态
private String status;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getStudentId() {return studentId;}
public void setStudentId(int studentId) {this.studentId = studentId;}
public String getTiwenName() {return tiwenName;}
public void setTiwenName(String tiwenName) {this.tiwenName = tiwenName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//学生通知
public class Xstongzhi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//学生
private int studentId;
//内容
private String title;
//发起日期
private Date insertDate;
//
private int teacherId;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getStudentId() {return studentId;}
public void setStudentId(int studentId) {this.studentId = studentId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public int getTeacherId() {return teacherId;}
public void setTeacherId(int teacherId) {this.teacherId = teacherId;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//问题
public class Xt  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//问题
private String wt;
//答案
private String content;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getWt() {return wt;}
public void setWt(String wt) {this.wt = wt;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//学院
public class Xy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//学院
private String xyName;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getXyName() {return xyName;}
public void setXyName(String xyName) {this.xyName = xyName;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//资源
public class Ziyuan  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//资源名称
private String ziyuanName;
//图片
private String pic;
//文件
private String fileUrl;
//时间
private Date insertDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getZiyuanName() {return ziyuanName;}
public void setZiyuanName(String ziyuanName) {this.ziyuanName = ziyuanName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//作业发布
public class Zuoye  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//老师
private int teacherId;
//课程
private String kechengName;
//班级
private int banjiId;
//作业标题
private String zuoyeName;
//图片
private String pic;
//文件
private String fileUrl;
//内容
private String content;
//发布日期
private Date insertDate;
//
private Date endDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getTeacherId() {return teacherId;}
public void setTeacherId(int teacherId) {this.teacherId = teacherId;}
public String getKechengName() {return kechengName;}
public void setKechengName(String kechengName) {this.kechengName = kechengName;}
public int getBanjiId() {return banjiId;}
public void setBanjiId(int banjiId) {this.banjiId = banjiId;}
public String getZuoyeName() {return zuoyeName;}
public void setZuoyeName(String zuoyeName) {this.zuoyeName = zuoyeName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//专业
public class Zy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//专业
private String zyName;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
}