- 基于java的家校通管理系统mysql数据库创建语句
- 基于java的家校通管理系统oracle数据库创建语句
- 基于java的家校通管理系统sqlserver数据库创建语句
- 基于java的家校通管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于java的家校通管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于java的家校通管理系统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_bj(
id int primary key auto_increment comment '主键',
bjName varchar(100) comment '班级名称'
) comment '班级';
成绩表创建语句如下：
create table t_cj(
id int primary key auto_increment comment '主键',
kcId int comment '课程',
xsId int comment '学生',
types varchar(100) comment '类型',
cj varchar(100) comment '成绩',
py varchar(100) comment '评语',
teacherId int comment ''
) comment '成绩';
家长表创建语句如下：
create table t_jz(
id int primary key auto_increment comment '主键',
username varchar(100) comment '姓名',
password varchar(100) comment '密码',
jzName varchar(100) comment '家长名称',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '家长';
课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
kcName varchar(100) comment '课程名称',
bjId int comment '班级',
teacherId int comment '老师',
jc varchar(100) comment '教材',
nr varchar(100) comment '内容'
) comment '课程';
留言表创建语句如下：
create table t_ly(
id int primary key auto_increment comment '主键',
jzId int comment '家长',
teacherId int comment '老师',
content varchar(100) comment '内容',
back varchar(100) comment '回复',
status varchar(100) comment '状态'
) comment '留言';
信息通知表创建语句如下：
create table t_message(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
messageName varchar(100) comment '标题',
showDate varchar(100) comment '时间',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
types varchar(100) comment '通知类型'
) comment '信息通知';
请假表创建语句如下：
create table t_qj(
id int primary key auto_increment comment '主键',
xsId int comment '学生',
qjName varchar(100) comment '请假简要说明',
types varchar(100) comment '请假类型',
beginDate varchar(100) comment '开始时间',
endDate varchar(100) comment '结束时间',
content varchar(100) comment '内容',
teacherId int 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 '老师名称',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
email varchar(100) comment '邮箱',
bjId int comment '班级',
kcId int comment '课程'
) comment '老师';
校级通知表创建语句如下：
create table t_tz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
showDate varchar(100) comment '日期'
) comment '校级通知';
学生表创建语句如下：
create table t_xs(
id int primary key auto_increment comment '主键',
xsName varchar(100) comment '学生姓名',
xh varchar(100) comment '学号',
jzId varchar(100) comment '家长',
dh varchar(100) comment '电话',
dz varchar(100) comment '地址',
dw varchar(100) comment '单位',
bjId int comment '班级'
) comment '学生';
作业表创建语句如下：
create table t_zy(
id int primary key auto_increment comment '主键',
xsId int comment '学生',
zyName varchar(100) comment '作业名称',
types varchar(100) comment '类型',
dj varchar(100) comment '等级',
jzsfqz varchar(100) comment '家长是否签字',
sjqk varchar(100) comment '上交情况',
dzqk varchar(100) comment '订正情况',
hpqk varchar(100) comment '回批情况',
sjDate varchar(100) comment '上交日期',
teacherId int comment ''
) comment '作业';
基于java的家校通管理系统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_bj(
id integer,
bjName varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级名称';
--班级表加注释
comment on table t_bj is '班级';
成绩表创建语句如下：
create table t_cj(
id integer,
kcId int,
xsId int,
types varchar(100),
cj varchar(100),
py varchar(100),
teacherId int
);
--成绩字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.kcId is '课程';
comment on column t_cj.xsId is '学生';
comment on column t_cj.types is '类型';
comment on column t_cj.cj is '成绩';
comment on column t_cj.py is '评语';
comment on column t_cj.teacherId is '';
--成绩表加注释
comment on table t_cj is '成绩';
家长表创建语句如下：
create table t_jz(
id integer,
username varchar(100),
password varchar(100),
jzName varchar(100),
age varchar(100),
sex varchar(100)
);
--家长字段加注释
comment on column t_jz.id is '主键';
comment on column t_jz.username is '姓名';
comment on column t_jz.password is '密码';
comment on column t_jz.jzName is '家长名称';
comment on column t_jz.age is '年龄';
comment on column t_jz.sex is '性别';
--家长表加注释
comment on table t_jz is '家长';
课程表创建语句如下：
create table t_kc(
id integer,
kcName varchar(100),
bjId int,
teacherId int,
jc varchar(100),
nr varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.bjId is '班级';
comment on column t_kc.teacherId is '老师';
comment on column t_kc.jc is '教材';
comment on column t_kc.nr is '内容';
--课程表加注释
comment on table t_kc is '课程';
留言表创建语句如下：
create table t_ly(
id integer,
jzId int,
teacherId int,
content varchar(100),
back varchar(100),
status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.jzId is '家长';
comment on column t_ly.teacherId is '老师';
comment on column t_ly.content is '内容';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';
信息通知表创建语句如下：
create table t_message(
id integer,
teacherId int,
messageName varchar(100),
showDate varchar(100),
pic varchar(100),
content varchar(100),
types varchar(100)
);
--信息通知字段加注释
comment on column t_message.id is '主键';
comment on column t_message.teacherId is '老师';
comment on column t_message.messageName is '标题';
comment on column t_message.showDate is '时间';
comment on column t_message.pic is '图片';
comment on column t_message.content is '内容';
comment on column t_message.types is '通知类型';
--信息通知表加注释
comment on table t_message is '信息通知';
请假表创建语句如下：
create table t_qj(
id integer,
xsId int,
qjName varchar(100),
types varchar(100),
beginDate varchar(100),
endDate varchar(100),
content varchar(100),
teacherId int
);
--请假字段加注释
comment on column t_qj.id is '主键';
comment on column t_qj.xsId is '学生';
comment on column t_qj.qjName is '请假简要说明';
comment on column t_qj.types is '请假类型';
comment on column t_qj.beginDate is '开始时间';
comment on column t_qj.endDate is '结束时间';
comment on column t_qj.content is '内容';
comment on column t_qj.teacherId is '';
--请假表加注释
comment on table t_qj is '请假';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
age varchar(100),
sex varchar(100),
email varchar(100),
bjId int,
kcId int
);
--老师字段加注释
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.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.email is '邮箱';
comment on column t_teacher.bjId is '班级';
comment on column t_teacher.kcId is '课程';
--老师表加注释
comment on table t_teacher is '老师';
校级通知表创建语句如下：
create table t_tz(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate varchar(100)
);
--校级通知字段加注释
comment on column t_tz.id is '主键';
comment on column t_tz.title is '标题';
comment on column t_tz.pic is '图片';
comment on column t_tz.content is '内容';
comment on column t_tz.showDate is '日期';
--校级通知表加注释
comment on table t_tz is '校级通知';
学生表创建语句如下：
create table t_xs(
id integer,
xsName varchar(100),
xh varchar(100),
jzId varchar(100),
dh varchar(100),
dz varchar(100),
dw varchar(100),
bjId int
);
--学生字段加注释
comment on column t_xs.id is '主键';
comment on column t_xs.xsName is '学生姓名';
comment on column t_xs.xh is '学号';
comment on column t_xs.jzId is '家长';
comment on column t_xs.dh is '电话';
comment on column t_xs.dz is '地址';
comment on column t_xs.dw is '单位';
comment on column t_xs.bjId is '班级';
--学生表加注释
comment on table t_xs is '学生';
作业表创建语句如下：
create table t_zy(
id integer,
xsId int,
zyName varchar(100),
types varchar(100),
dj varchar(100),
jzsfqz varchar(100),
sjqk varchar(100),
dzqk varchar(100),
hpqk varchar(100),
sjDate varchar(100),
teacherId int
);
--作业字段加注释
comment on column t_zy.id is '主键';
comment on column t_zy.xsId is '学生';
comment on column t_zy.zyName is '作业名称';
comment on column t_zy.types is '类型';
comment on column t_zy.dj is '等级';
comment on column t_zy.jzsfqz is '家长是否签字';
comment on column t_zy.sjqk is '上交情况';
comment on column t_zy.dzqk is '订正情况';
comment on column t_zy.hpqk is '回批情况';
comment on column t_zy.sjDate is '上交日期';
comment on column t_zy.teacherId is '';
--作业表加注释
comment on table t_zy is '作业';
oracle特有，对应序列如下：
create sequence s_t_bj;
create sequence s_t_cj;
create sequence s_t_jz;
create sequence s_t_kc;
create sequence s_t_ly;
create sequence s_t_message;
create sequence s_t_qj;
create sequence s_t_teacher;
create sequence s_t_tz;
create sequence s_t_xs;
create sequence s_t_zy;
基于java的家校通管理系统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_bj(
id int identity(1,1) primary key not null,--主键
bjName varchar(100)--班级名称
);
成绩表创建语句如下：
--成绩表注释
create table t_cj(
id int identity(1,1) primary key not null,--主键
kcId int,--课程
xsId int,--学生
types varchar(100),--类型
cj varchar(100),--成绩
py varchar(100),--评语
teacherId int--
);
家长表创建语句如下：
--家长表注释
create table t_jz(
id int identity(1,1) primary key not null,--主键
username varchar(100),--姓名
password varchar(100),--密码
jzName varchar(100),--家长名称
age varchar(100),--年龄
sex varchar(100)--性别
);
课程表创建语句如下：
--课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
kcName varchar(100),--课程名称
bjId int,--班级
teacherId int,--老师
jc varchar(100),--教材
nr varchar(100)--内容
);
留言表创建语句如下：
--留言表注释
create table t_ly(
id int identity(1,1) primary key not null,--主键
jzId int,--家长
teacherId int,--老师
content varchar(100),--内容
back varchar(100),--回复
status varchar(100)--状态
);
信息通知表创建语句如下：
--信息通知表注释
create table t_message(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
messageName varchar(100),--标题
showDate varchar(100),--时间
pic varchar(100),--图片
content varchar(100),--内容
types varchar(100)--通知类型
);
请假表创建语句如下：
--请假表注释
create table t_qj(
id int identity(1,1) primary key not null,--主键
xsId int,--学生
qjName varchar(100),--请假简要说明
types varchar(100),--请假类型
beginDate varchar(100),--开始时间
endDate varchar(100),--结束时间
content varchar(100),--内容
teacherId int--
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--姓名
password varchar(100),--密码
teacherName varchar(100),--老师名称
age varchar(100),--年龄
sex varchar(100),--性别
email varchar(100),--邮箱
bjId int,--班级
kcId int--课程
);
校级通知表创建语句如下：
--校级通知表注释
create table t_tz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
showDate varchar(100)--日期
);
学生表创建语句如下：
--学生表注释
create table t_xs(
id int identity(1,1) primary key not null,--主键
xsName varchar(100),--学生姓名
xh varchar(100),--学号
jzId varchar(100),--家长
dh varchar(100),--电话
dz varchar(100),--地址
dw varchar(100),--单位
bjId int--班级
);
作业表创建语句如下：
--作业表注释
create table t_zy(
id int identity(1,1) primary key not null,--主键
xsId int,--学生
zyName varchar(100),--作业名称
types varchar(100),--类型
dj varchar(100),--等级
jzsfqz varchar(100),--家长是否签字
sjqk varchar(100),--上交情况
dzqk varchar(100),--订正情况
hpqk varchar(100),--回批情况
sjDate varchar(100),--上交日期
teacherId int--
);
登录后主页.jpg?x-oss-process=style/00001)
基于java的家校通管理系统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_bj")
public class Bj {
//主键
@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 bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}成绩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_cj")
public class Cj {
//主键
@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 kcId;
//学生
private Integer xsId;
//类型
private String types;
//成绩
private String cj;
//评语
private String py;
//
private Integer teacherId;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public Integer getXsId() {return xsId;}
public void setXsId(Integer xsId) {this.xsId = xsId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
public String getPy() {return py;}
public void setPy(String py) {this.py = py;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}家长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_jz")
public class Jz {
//主键
@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 jzName;
//年龄
private String age;
//性别
private String sex;
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 getJzName() {return jzName;}
public void setJzName(String jzName) {this.jzName = jzName;}
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;}
}课程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 String kcName;
//班级
private Integer bjId;
//老师
private Integer teacherId;
//教材
private String jc;
//内容
private String nr;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getJc() {return jc;}
public void setJc(String jc) {this.jc = jc;}
public String getNr() {return nr;}
public void setNr(String nr) {this.nr = nr;}
}留言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_ly")
public class Ly {
//主键
@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 jzId;
//老师
private Integer teacherId;
//内容
private String content;
//回复
private String back;
//状态
private String status;
public Integer getJzId() {return jzId;}
public void setJzId(Integer jzId) {this.jzId = jzId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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_message")
public class Message {
//主键
@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 teacherId;
//标题
private String messageName;
//时间
private String showDate;
//图片
private String pic;
//内容
private String content;
//通知类型
private String types;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getMessageName() {return messageName;}
public void setMessageName(String messageName) {this.messageName = messageName;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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 String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}请假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_qj")
public class Qj {
//主键
@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 xsId;
//请假简要说明
private String qjName;
//请假类型
private String types;
//开始时间
private String beginDate;
//结束时间
private String endDate;
//内容
private String content;
//
private Integer teacherId;
public Integer getXsId() {return xsId;}
public void setXsId(Integer xsId) {this.xsId = xsId;}
public String getQjName() {return qjName;}
public void setQjName(String qjName) {this.qjName = qjName;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getBeginDate() {return beginDate;}
public void setBeginDate(String beginDate) {this.beginDate = beginDate;}
public String getEndDate() {return endDate;}
public void setEndDate(String endDate) {this.endDate = endDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}老师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 age;
//性别
private String sex;
//邮箱
private String email;
//班级
private Integer bjId;
//课程
private Integer kcId;
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 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 getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
}校级通知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_tz")
public class Tz {
//主键
@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 title;
//图片
private String pic;
//内容
private String content;
//日期
private String showDate;
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;}
public String getShowDate() {return showDate;}
public void setShowDate(String 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_xs")
public class Xs {
//主键
@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 xsName;
//学号
private String xh;
//家长
private String jzId;
//电话
private String dh;
//地址
private String dz;
//单位
private String dw;
//班级
private Integer bjId;
public String getXsName() {return xsName;}
public void setXsName(String xsName) {this.xsName = xsName;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getJzId() {return jzId;}
public void setJzId(String jzId) {this.jzId = jzId;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}作业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_zy")
public class Zy {
//主键
@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 xsId;
//作业名称
private String zyName;
//类型
private String types;
//等级
private String dj;
//家长是否签字
private String jzsfqz;
//上交情况
private String sjqk;
//订正情况
private String dzqk;
//回批情况
private String hpqk;
//上交日期
private String sjDate;
//
private Integer teacherId;
public Integer getXsId() {return xsId;}
public void setXsId(Integer xsId) {this.xsId = xsId;}
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getDj() {return dj;}
public void setDj(String dj) {this.dj = dj;}
public String getJzsfqz() {return jzsfqz;}
public void setJzsfqz(String jzsfqz) {this.jzsfqz = jzsfqz;}
public String getSjqk() {return sjqk;}
public void setSjqk(String sjqk) {this.sjqk = sjqk;}
public String getDzqk() {return dzqk;}
public void setDzqk(String dzqk) {this.dzqk = dzqk;}
public String getHpqk() {return hpqk;}
public void setHpqk(String hpqk) {this.hpqk = hpqk;}
public String getSjDate() {return sjDate;}
public void setSjDate(String sjDate) {this.sjDate = sjDate;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}基于java的家校通管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
班级javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级
public class Bj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级名称
private String bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}成绩javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//成绩
public class Cj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private Integer kcId;
//学生
private Integer xsId;
//类型
private String types;
//成绩
private String cj;
//评语
private String py;
//
private Integer teacherId;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public Integer getXsId() {return xsId;}
public void setXsId(Integer xsId) {this.xsId = xsId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
public String getPy() {return py;}
public void setPy(String py) {this.py = py;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}家长javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//家长
public class Jz 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 jzName;
//年龄
private String age;
//性别
private String sex;
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 getJzName() {return jzName;}
public void setJzName(String jzName) {this.jzName = jzName;}
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;}
}课程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 String kcName;
//班级
private Integer bjId;
//老师
private Integer teacherId;
//教材
private String jc;
//内容
private String nr;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getJc() {return jc;}
public void setJc(String jc) {this.jc = jc;}
public String getNr() {return nr;}
public void setNr(String nr) {this.nr = nr;}
}留言javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言
public class Ly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//家长
private Integer jzId;
//老师
private Integer teacherId;
//内容
private String content;
//回复
private String back;
//状态
private String status;
public Integer getJzId() {return jzId;}
public void setJzId(Integer jzId) {this.jzId = jzId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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 Message extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//标题
private String messageName;
//时间
private String showDate;
//图片
private String pic;
//内容
private String content;
//通知类型
private String types;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getMessageName() {return messageName;}
public void setMessageName(String messageName) {this.messageName = messageName;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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 String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}请假javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//请假
public class Qj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer xsId;
//请假简要说明
private String qjName;
//请假类型
private String types;
//开始时间
private String beginDate;
//结束时间
private String endDate;
//内容
private String content;
//
private Integer teacherId;
public Integer getXsId() {return xsId;}
public void setXsId(Integer xsId) {this.xsId = xsId;}
public String getQjName() {return qjName;}
public void setQjName(String qjName) {this.qjName = qjName;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getBeginDate() {return beginDate;}
public void setBeginDate(String beginDate) {this.beginDate = beginDate;}
public String getEndDate() {return endDate;}
public void setEndDate(String endDate) {this.endDate = endDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}老师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 age;
//性别
private String sex;
//邮箱
private String email;
//班级
private Integer bjId;
//课程
private Integer kcId;
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 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 getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
}校级通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//校级通知
public class Tz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//日期
private String showDate;
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;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}学生javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学生
public class Xs extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生姓名
private String xsName;
//学号
private String xh;
//家长
private String jzId;
//电话
private String dh;
//地址
private String dz;
//单位
private String dw;
//班级
private Integer bjId;
public String getXsName() {return xsName;}
public void setXsName(String xsName) {this.xsName = xsName;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getJzId() {return jzId;}
public void setJzId(String jzId) {this.jzId = jzId;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}作业javaBean创建语句如下：
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;}
//学生
private Integer xsId;
//作业名称
private String zyName;
//类型
private String types;
//等级
private String dj;
//家长是否签字
private String jzsfqz;
//上交情况
private String sjqk;
//订正情况
private String dzqk;
//回批情况
private String hpqk;
//上交日期
private String sjDate;
//
private Integer teacherId;
public Integer getXsId() {return xsId;}
public void setXsId(Integer xsId) {this.xsId = xsId;}
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getDj() {return dj;}
public void setDj(String dj) {this.dj = dj;}
public String getJzsfqz() {return jzsfqz;}
public void setJzsfqz(String jzsfqz) {this.jzsfqz = jzsfqz;}
public String getSjqk() {return sjqk;}
public void setSjqk(String sjqk) {this.sjqk = sjqk;}
public String getDzqk() {return dzqk;}
public void setDzqk(String dzqk) {this.dzqk = dzqk;}
public String getHpqk() {return hpqk;}
public void setHpqk(String hpqk) {this.hpqk = hpqk;}
public String getSjDate() {return sjDate;}
public void setSjDate(String sjDate) {this.sjDate = sjDate;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}