- 基于SSM的班级日常事务管理系统mysql数据库创建语句
- 基于SSM的班级日常事务管理系统oracle数据库创建语句
- 基于SSM的班级日常事务管理系统sqlserver数据库创建语句
- 基于SSM的班级日常事务管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于SSM的班级日常事务管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于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');
班级表创建语句如下：
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 '班级';
班费开支表创建语句如下：
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 '班费开支';
班级公告表创建语句如下：
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 '班级公告';
班级奖励惩罚表创建语句如下：
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 '班级奖励惩罚';
班级考勤表创建语句如下：
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 '班级考勤';
班级收费表创建语句如下：
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 '班级收费';
班级相册表创建语句如下：
create table t_bjxc(
id int primary key auto_increment comment '主键',
banjiId int comment '班级',
title varchar(100) comment '相册标题',
fileUrl varchar(100) comment '图片'
) comment '班级相册';
成绩表创建语句如下：
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 '成绩';
课程表创建语句如下：
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 '课程';
考试表创建语句如下：
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 '考试';
请假表创建语句如下：
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 '请假';
学生表创建语句如下：
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 '学生';
老师表创建语句如下：
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 '老师';
作业表创建语句如下：
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 '作业';
基于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 '超级管理员';
班级表创建语句如下：
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 '班级';
班费开支表创建语句如下：
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 '班费开支';
班级公告表创建语句如下：
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 '班级公告';
班级奖励惩罚表创建语句如下：
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 '班级奖励惩罚';
班级考勤表创建语句如下：
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 '班级考勤';
班级收费表创建语句如下：
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 '班级收费';
班级相册表创建语句如下：
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 '班级相册';
成绩表创建语句如下：
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 '成绩';
课程表创建语句如下：
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 '课程';
考试表创建语句如下：
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 '考试';
请假表创建语句如下：
create table t_qingjia(
id integer,
studentId int,
banjiId int,
title varchar(100),
content varchar(100),
qjBeginDate datetime,
qjEndate datetime,
status varchar(100)
);
--请假字段加注释
comment on column t_qingjia.id is '主键';
comment on column t_qingjia.studentId is '学生';
comment on column t_qingjia.banjiId is '班级';
comment on column t_qingjia.title is '请假标题';
comment on column t_qingjia.content is '说明';
comment on column t_qingjia.qjBeginDate is '请假开始日期';
comment on column t_qingjia.qjEndate is '请假结束日期';
comment on column t_qingjia.status is '状态';
--请假表加注释
comment on table t_qingjia is '请假';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
zy varchar(100),
phone varchar(100),
banjiId int,
ss varchar(100),
sfz varchar(100),
js varchar(100)
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '学号';
comment on column t_student.password is '密码';
comment on column t_student.studentName is '姓名';
comment on column t_student.zy is '专业';
comment on column t_student.phone is '电话';
comment on column t_student.banjiId is '班级';
comment on column t_student.ss is '宿舍';
comment on column t_student.sfz is '身份证';
comment on column t_student.js is '角色';
--学生表加注释
comment on table t_student is '学生';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
zy varchar(100),
phone varchar(100)
);
--老师字段加注释
comment on column t_teacher.id is '主键';
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.zy is '专业';
comment on column t_teacher.phone is '电话';
--老师表加注释
comment on table t_teacher is '老师';
作业表创建语句如下：
create table t_zuoye(
id integer,
studentId int,
banjiId int,
title varchar(100),
fileUrl varchar(100),
insertDate datetime
);
--作业字段加注释
comment on column t_zuoye.id is '主键';
comment on column t_zuoye.studentId is '学生';
comment on column t_zuoye.banjiId is '班级';
comment on column t_zuoye.title is '作业名称';
comment on column t_zuoye.fileUrl is '作业附件';
comment on column t_zuoye.insertDate is '上传日期日期';
--作业表加注释
comment on table t_zuoye is '作业';
oracle特有，对应序列如下：
create sequence s_t_banji;
create sequence s_t_bfkz;
create sequence s_t_bjgg;
create sequence s_t_bjjc;
create sequence s_t_bjkq;
create sequence s_t_bjsf;
create sequence s_t_bjxc;
create sequence s_t_chengji;
create sequence s_t_kc;
create sequence s_t_ks;
create sequence s_t_qingjia;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_zuoye;
基于SSM的班级日常事务管理系统sqlserver数据库版本源码：
超级管理员表创建语句如下：
--超级管理员
create table t_admin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--超级管理员账号
password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');
班级表创建语句如下：
--班级表注释
create table t_banji(
id int identity(1,1) primary key not null,--主键
xy varchar(100),--学院
nj varchar(100),--年级
zy varchar(100),--专业
banjiName varchar(100),--班级
bzr varchar(100)--班主任
);
班费开支表创建语句如下：
--班费开支表注释
create table t_bfkz(
id int identity(1,1) primary key not null,--主键
banjiId int,--班级
types varchar(100),--收支类型
title varchar(100),--班费支出说明
content varchar(100),--详细说明
fee int,--金额
showDate datetime--使用日期
);
班级公告表创建语句如下：
--班级公告表注释
create table t_bjgg(
id int identity(1,1) primary key not null,--主键
banjiId int,--班级
title varchar(100),--标题
content varchar(100),--内容
insertDate datetime,--日期
remark varchar(100)--详情
);
班级奖励惩罚表创建语句如下：
--班级奖励惩罚表注释
create table t_bjjc(
id int identity(1,1) primary key not null,--主键
banjiId int,--班级
types varchar(100),--奖励惩罚
title varchar(100),--标题
content varchar(100),--详细说明
showDate datetime--日期
);
班级考勤表创建语句如下：
--班级考勤表注释
create table t_bjkq(
id int identity(1,1) primary key not null,--主键
banjiId int,--班级
studentId int,--学生
kc varchar(100),--课程
skrq datetime,--上课日期
iskq varchar(100)--是否缺课
);
班级收费表创建语句如下：
--班级收费表注释
create table t_bjsf(
id int identity(1,1) primary key not null,--主键
banjiId int,--班级
title varchar(100),--收费标题
fee int,--收费金额
showDate datetime--日期
);
班级相册表创建语句如下：
--班级相册表注释
create table t_bjxc(
id int identity(1,1) primary key not null,--主键
banjiId int,--班级
title varchar(100),--相册标题
fileUrl varchar(100)--图片
);
成绩表创建语句如下：
--成绩表注释
create table t_chengji(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
banjiId int,--班级
title varchar(100),--课程
fs int--分数
);
课程表创建语句如下：
--课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
banjiId int,--班级
title varchar(100),--课程名称
skls varchar(100),--上课老师
sksj varchar(100),--上课时间
skdd varchar(100)--上课地点
);
考试表创建语句如下：
--考试表注释
create table t_ks(
id int identity(1,1) primary key not null,--主键
banjiId int,--班级
title varchar(100),--考试类型
skls varchar(100),--考试课程
sksj varchar(100),--考试时间
skdd varchar(100)--考试地点
);
请假表创建语句如下：
--请假表注释
create table t_qingjia(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
banjiId int,--班级
title varchar(100),--请假标题
content varchar(100),--说明
qjBeginDate datetime,--请假开始日期
qjEndate datetime,--请假结束日期
status varchar(100)--状态
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--学号
password varchar(100),--密码
studentName varchar(100),--姓名
zy varchar(100),--专业
phone varchar(100),--电话
banjiId int,--班级
ss varchar(100),--宿舍
sfz varchar(100),--身份证
js varchar(100)--角色
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
zy varchar(100),--专业
phone varchar(100)--电话
);
作业表创建语句如下：
--作业表注释
create table t_zuoye(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
banjiId int,--班级
title varchar(100),--作业名称
fileUrl varchar(100),--作业附件
insertDate datetime--上传日期日期
);
登录后主页.jpg?x-oss-process=style/00001)
基于SSM的班级日常事务管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：
班级javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//班级
@Table(name = "t_banji")
public class Banji {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学院
private String xy;
//年级
private String nj;
//专业
private String zy;
//班级
private String banjiName;
//班主任
private String bzr;
public String getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getNj() {return nj;}
public void setNj(String nj) {this.nj = nj;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getBanjiName() {return banjiName;}
public void setBanjiName(String banjiName) {this.banjiName = banjiName;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}班费开支javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//班费开支
@Table(name = "t_bfkz")
public class Bfkz {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//收支类型
private String types;
//班费支出说明
private String title;
//详细说明
private String content;
//金额
private Integer fee;
//使用日期
private Date showDate;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}班级公告javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//班级公告
@Table(name = "t_bjgg")
public class Bjgg {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//标题
private String title;
//内容
private String content;
//日期
private Date insertDate;
//详情
private String remark;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}班级奖励惩罚javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//班级奖励惩罚
@Table(name = "t_bjjc")
public class Bjjc {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//奖励惩罚
private String types;
//标题
private String title;
//详细说明
private String content;
//日期
private Date showDate;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}班级考勤javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//班级考勤
@Table(name = "t_bjkq")
public class Bjkq {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//学生
private Integer studentId;
//课程
private String kc;
//上课日期
private Date skrq;
//是否缺课
private String iskq;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getKc() {return kc;}
public void setKc(String kc) {this.kc = kc;}
public Date getSkrq() {return skrq;}
public void setSkrq(Date skrq) {this.skrq = skrq;}
public String getIskq() {return iskq;}
public void setIskq(String iskq) {this.iskq = iskq;}
}班级收费javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//班级收费
@Table(name = "t_bjsf")
public class Bjsf {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//收费标题
private String title;
//收费金额
private Integer fee;
//日期
private Date showDate;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}班级相册javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//班级相册
@Table(name = "t_bjxc")
public class Bjxc {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//相册标题
private String title;
//图片
private String fileUrl;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}成绩javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//成绩
@Table(name = "t_chengji")
public class Chengji {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//班级
private Integer banjiId;
//课程
private String title;
//分数
private Integer fs;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
}课程javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//课程
@Table(name = "t_kc")
public class Kc {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//课程名称
private String title;
//上课老师
private String skls;
//上课时间
private String sksj;
//上课地点
private String skdd;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getSkls() {return skls;}
public void setSkls(String skls) {this.skls = skls;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
}考试javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//考试
@Table(name = "t_ks")
public class Ks {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//考试类型
private String title;
//考试课程
private String skls;
//考试时间
private String sksj;
//考试地点
private String skdd;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getSkls() {return skls;}
public void setSkls(String skls) {this.skls = skls;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
}请假javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//请假
@Table(name = "t_qingjia")
public class Qingjia {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//班级
private Integer banjiId;
//请假标题
private String title;
//说明
private String content;
//请假开始日期
private Date qjBeginDate;
//请假结束日期
private Date qjEndate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getQjBeginDate() {return qjBeginDate;}
public void setQjBeginDate(Date qjBeginDate) {this.qjBeginDate = qjBeginDate;}
public Date getQjEndate() {return qjEndate;}
public void setQjEndate(Date qjEndate) {this.qjEndate = qjEndate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}学生javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//学生
@Table(name = "t_student")
public class Student {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学号
private String username;
//密码
private String password;
//姓名
private String studentName;
//专业
private String zy;
//电话
private String phone;
//班级
private Integer banjiId;
//宿舍
private String ss;
//身份证
private String sfz;
//角色
private String js;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getSs() {return ss;}
public void setSs(String ss) {this.ss = ss;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}老师javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//老师
@Table(name = "t_teacher")
public class Teacher {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String teacherName;
//专业
private String zy;
//电话
private String phone;
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 getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}作业javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//作业
@Table(name = "t_zuoye")
public class Zuoye {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//班级
private Integer banjiId;
//作业名称
private String title;
//作业附件
private String fileUrl;
//上传日期日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}基于SSM的班级日常事务管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
班级javaBean创建语句如下：
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;}
//学院
private String xy;
//年级
private String nj;
//专业
private String zy;
//班级
private String banjiName;
//班主任
private String bzr;
public String getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getNj() {return nj;}
public void setNj(String nj) {this.nj = nj;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getBanjiName() {return banjiName;}
public void setBanjiName(String banjiName) {this.banjiName = banjiName;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}班费开支javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班费开支
public class Bfkz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//收支类型
private String types;
//班费支出说明
private String title;
//详细说明
private String content;
//金额
private Integer fee;
//使用日期
private Date showDate;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}班级公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级公告
public class Bjgg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//标题
private String title;
//内容
private String content;
//日期
private Date insertDate;
//详情
private String remark;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}班级奖励惩罚javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级奖励惩罚
public class Bjjc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//奖励惩罚
private String types;
//标题
private String title;
//详细说明
private String content;
//日期
private Date showDate;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}班级考勤javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级考勤
public class Bjkq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//学生
private Integer studentId;
//课程
private String kc;
//上课日期
private Date skrq;
//是否缺课
private String iskq;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getKc() {return kc;}
public void setKc(String kc) {this.kc = kc;}
public Date getSkrq() {return skrq;}
public void setSkrq(Date skrq) {this.skrq = skrq;}
public String getIskq() {return iskq;}
public void setIskq(String iskq) {this.iskq = iskq;}
}班级收费javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级收费
public class Bjsf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//收费标题
private String title;
//收费金额
private Integer fee;
//日期
private Date showDate;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}班级相册javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级相册
public class Bjxc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//相册标题
private String title;
//图片
private String fileUrl;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}成绩javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//成绩
public class Chengji extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//班级
private Integer banjiId;
//课程
private String title;
//分数
private Integer fs;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
}课程javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//课程
public class Kc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//课程名称
private String title;
//上课老师
private String skls;
//上课时间
private String sksj;
//上课地点
private String skdd;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getSkls() {return skls;}
public void setSkls(String skls) {this.skls = skls;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
}考试javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//考试
public class Ks extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer banjiId;
//考试类型
private String title;
//考试课程
private String skls;
//考试时间
private String sksj;
//考试地点
private String skdd;
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getSkls() {return skls;}
public void setSkls(String skls) {this.skls = skls;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
}请假javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//请假
public class Qingjia extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//班级
private Integer banjiId;
//请假标题
private String title;
//说明
private String content;
//请假开始日期
private Date qjBeginDate;
//请假结束日期
private Date qjEndate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getQjBeginDate() {return qjBeginDate;}
public void setQjBeginDate(Date qjBeginDate) {this.qjBeginDate = qjBeginDate;}
public Date getQjEndate() {return qjEndate;}
public void setQjEndate(Date qjEndate) {this.qjEndate = qjEndate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}学生javaBean创建语句如下：
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;}
//学号
private String username;
//密码
private String password;
//姓名
private String studentName;
//专业
private String zy;
//电话
private String phone;
//班级
private Integer banjiId;
//宿舍
private String ss;
//身份证
private String sfz;
//角色
private String js;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getSs() {return ss;}
public void setSs(String ss) {this.ss = ss;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}老师javaBean创建语句如下：
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;}
//账号
private String username;
//密码
private String password;
//姓名
private String teacherName;
//专业
private String zy;
//电话
private String phone;
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 getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}作业javaBean创建语句如下：
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;}
//学生
private Integer studentId;
//班级
private Integer banjiId;
//作业名称
private String title;
//作业附件
private String fileUrl;
//上传日期日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}