人工智能学院学生体能健康管理系统的设计与实现

    #############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_cj(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	v1 double comment '50米秒速成绩',
    	v2 double comment '1000米分钟数成绩',
    	v3 double comment '坐位体前屈厘米数成绩',
    	v4 int(11) comment '引体向上个数成绩',
    	v5 int(11) comment '跳绳个数',
    	showDate datetime comment '日期'
    ) comment '成绩';
    
    create table t_dljh(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	xm varchar(100) comment '锻炼项目',
    	title varchar(1000) comment '内容',
    	insertDate datetime comment '发起日期'
    ) comment '锻炼计划';
    
    create table t_gonggao(
    	id int primary key auto_increment comment '主键',
    	title varchar(1000) comment '标题',
    	content text comment '内容',
    	insertDate datetime comment '发起日期'
    ) comment '公告';
    
    create table t_ly(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	content text comment '内容',
    	insertDate datetime comment '发起日期',
    	back text 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 '姓名',
    	phone varchar(100) comment '电话',
    	age varchar(100) comment '年龄',
    	sex 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 '姓名',
    	phone varchar(100) comment '电话',
    	age varchar(100) comment '年龄',
    	sex varchar(100) comment '性别'
    ) comment '老师';
    
    create table t_tongzhi(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	title varchar(1000) comment '内容',
    	insertDate datetime 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_cj(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	v1 double comment '50米秒速成绩',
    	v2 double comment '1000米分钟数成绩',
    	v3 double comment '坐位体前屈厘米数成绩',
    	v4 int(11) comment '引体向上个数成绩',
    	v5 int(11) comment '跳绳个数',
    	showDate datetime comment '日期'
    ) comment '成绩';
    
    create table t_dljh(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	xm varchar(100) comment '锻炼项目',
    	title varchar(1000) comment '内容',
    	insertDate datetime comment '发起日期'
    ) comment '锻炼计划';
    
    create table t_gonggao(
    	id int primary key auto_increment comment '主键',
    	title varchar(1000) comment '标题',
    	content text comment '内容',
    	insertDate datetime comment '发起日期'
    ) comment '公告';
    
    create table t_ly(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	content text comment '内容',
    	insertDate datetime comment '发起日期',
    	back text 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 '姓名',
    	phone varchar(100) comment '电话',
    	age varchar(100) comment '年龄',
    	sex 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 '姓名',
    	phone varchar(100) comment '电话',
    	age varchar(100) comment '年龄',
    	sex varchar(100) comment '性别'
    ) comment '老师';
    
    create table t_tongzhi(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	title varchar(1000) comment '内容',
    	insertDate datetime comment '发起日期'
    ) comment '通知';
    
    create table t_cj(
    	id integer,
    	studentId int(11),
    	v1 double,
    	v2 double,
    	v3 double,
    	v4 int(11),
    	v5 int(11),
    	showDate datetime
    );
    --成绩字段加注释
    comment on column t_cj.id is '主键';
    comment on column t_cj.id is '主键唯一ID';
    comment on column t_cj.studentId is '学生';
    comment on column t_cj.v1 is '50米秒速成绩';
    comment on column t_cj.v2 is '1000米分钟数成绩';
    comment on column t_cj.v3 is '坐位体前屈厘米数成绩';
    comment on column t_cj.v4 is '引体向上个数成绩';
    comment on column t_cj.v5 is '跳绳个数';
    comment on column t_cj.showDate is '日期';
    --成绩表加注释
    comment on table t_cj is '成绩';
    
    create table t_dljh(
    	id integer,
    	studentId int(11),
    	xm varchar(100),
    	title varchar(1000),
    	insertDate datetime
    );
    --锻炼计划字段加注释
    comment on column t_dljh.id is '主键';
    comment on column t_dljh.id is '主键唯一ID';
    comment on column t_dljh.studentId is '学生';
    comment on column t_dljh.xm is '锻炼项目';
    comment on column t_dljh.title is '内容';
    comment on column t_dljh.insertDate is '发起日期';
    --锻炼计划表加注释
    comment on table t_dljh is '锻炼计划';
    
    create table t_gonggao(
    	id integer,
    	title varchar(1000),
    	content text,
    	insertDate datetime
    );
    --公告字段加注释
    comment on column t_gonggao.id is '主键';
    comment on column t_gonggao.id is '主键唯一ID';
    comment on column t_gonggao.title is '标题';
    comment on column t_gonggao.content is '内容';
    comment on column t_gonggao.insertDate is '发起日期';
    --公告表加注释
    comment on table t_gonggao is '公告';
    
    create table t_ly(
    	id integer,
    	studentId int(11),
    	content text,
    	insertDate datetime,
    	back text,
    	status varchar(100)
    );
    --留言字段加注释
    comment on column t_ly.id is '主键';
    comment on column t_ly.id is '主键唯一ID';
    comment on column t_ly.studentId is '学生';
    comment on column t_ly.content is '内容';
    comment on column t_ly.insertDate is '发起日期';
    comment on column t_ly.back is '回复';
    comment on column t_ly.status is '状态';
    --留言表加注释
    comment on table t_ly is '留言';
    
    create table t_student(
    	id integer,
    	username varchar(100),
    	password varchar(100),
    	studentName varchar(100),
    	phone varchar(100),
    	age varchar(100),
    	sex varchar(100)
    );
    --学生字段加注释
    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.studentName is '姓名';
    comment on column t_student.phone is '电话';
    comment on column t_student.age is '年龄';
    comment on column t_student.sex is '性别';
    --学生表加注释
    comment on table t_student is '学生';
    
    create table t_teacher(
    	id integer,
    	username varchar(100),
    	password varchar(100),
    	teacherName varchar(100),
    	phone varchar(100),
    	age varchar(100),
    	sex 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.phone is '电话';
    comment on column t_teacher.age is '年龄';
    comment on column t_teacher.sex is '性别';
    --老师表加注释
    comment on table t_teacher is '老师';
    
    create table t_tongzhi(
    	id integer,
    	studentId int(11),
    	title varchar(1000),
    	insertDate datetime
    );
    --通知字段加注释
    comment on column t_tongzhi.id is '主键';
    comment on column t_tongzhi.id is '主键唯一ID';
    comment on column t_tongzhi.studentId is '学生';
    comment on column t_tongzhi.title is '内容';
    comment on column t_tongzhi.insertDate is '发起日期';
    --通知表加注释
    comment on table t_tongzhi 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_cj(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	v1 double comment '50米秒速成绩',
    	v2 double comment '1000米分钟数成绩',
    	v3 double comment '坐位体前屈厘米数成绩',
    	v4 int(11) comment '引体向上个数成绩',
    	v5 int(11) comment '跳绳个数',
    	showDate datetime comment '日期'
    ) comment '成绩';
    
    create table t_dljh(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	xm varchar(100) comment '锻炼项目',
    	title varchar(1000) comment '内容',
    	insertDate datetime comment '发起日期'
    ) comment '锻炼计划';
    
    create table t_gonggao(
    	id int primary key auto_increment comment '主键',
    	title varchar(1000) comment '标题',
    	content text comment '内容',
    	insertDate datetime comment '发起日期'
    ) comment '公告';
    
    create table t_ly(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	content text comment '内容',
    	insertDate datetime comment '发起日期',
    	back text 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 '姓名',
    	phone varchar(100) comment '电话',
    	age varchar(100) comment '年龄',
    	sex 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 '姓名',
    	phone varchar(100) comment '电话',
    	age varchar(100) comment '年龄',
    	sex varchar(100) comment '性别'
    ) comment '老师';
    
    create table t_tongzhi(
    	id int primary key auto_increment comment '主键',
    	studentId int(11) comment '学生',
    	title varchar(1000) comment '内容',
    	insertDate datetime comment '发起日期'
    ) comment '通知';
    
    create table t_cj(
    	id integer,
    	studentId int(11),
    	v1 double,
    	v2 double,
    	v3 double,
    	v4 int(11),
    	v5 int(11),
    	showDate datetime
    );
    --成绩字段加注释
    comment on column t_cj.id is '主键';
    comment on column t_cj.id is '主键唯一ID';
    comment on column t_cj.studentId is '学生';
    comment on column t_cj.v1 is '50米秒速成绩';
    comment on column t_cj.v2 is '1000米分钟数成绩';
    comment on column t_cj.v3 is '坐位体前屈厘米数成绩';
    comment on column t_cj.v4 is '引体向上个数成绩';
    comment on column t_cj.v5 is '跳绳个数';
    comment on column t_cj.showDate is '日期';
    --成绩表加注释
    comment on table t_cj is '成绩';
    
    create table t_dljh(
    	id integer,
    	studentId int(11),
    	xm varchar(100),
    	title varchar(1000),
    	insertDate datetime
    );
    --锻炼计划字段加注释
    comment on column t_dljh.id is '主键';
    comment on column t_dljh.id is '主键唯一ID';
    comment on column t_dljh.studentId is '学生';
    comment on column t_dljh.xm is '锻炼项目';
    comment on column t_dljh.title is '内容';
    comment on column t_dljh.insertDate is '发起日期';
    --锻炼计划表加注释
    comment on table t_dljh is '锻炼计划';
    
    create table t_gonggao(
    	id integer,
    	title varchar(1000),
    	content text,
    	insertDate datetime
    );
    --公告字段加注释
    comment on column t_gonggao.id is '主键';
    comment on column t_gonggao.id is '主键唯一ID';
    comment on column t_gonggao.title is '标题';
    comment on column t_gonggao.content is '内容';
    comment on column t_gonggao.insertDate is '发起日期';
    --公告表加注释
    comment on table t_gonggao is '公告';
    
    create table t_ly(
    	id integer,
    	studentId int(11),
    	content text,
    	insertDate datetime,
    	back text,
    	status varchar(100)
    );
    --留言字段加注释
    comment on column t_ly.id is '主键';
    comment on column t_ly.id is '主键唯一ID';
    comment on column t_ly.studentId is '学生';
    comment on column t_ly.content is '内容';
    comment on column t_ly.insertDate is '发起日期';
    comment on column t_ly.back is '回复';
    comment on column t_ly.status is '状态';
    --留言表加注释
    comment on table t_ly is '留言';
    
    create table t_student(
    	id integer,
    	username varchar(100),
    	password varchar(100),
    	studentName varchar(100),
    	phone varchar(100),
    	age varchar(100),
    	sex varchar(100)
    );
    --学生字段加注释
    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.studentName is '姓名';
    comment on column t_student.phone is '电话';
    comment on column t_student.age is '年龄';
    comment on column t_student.sex is '性别';
    --学生表加注释
    comment on table t_student is '学生';
    
    create table t_teacher(
    	id integer,
    	username varchar(100),
    	password varchar(100),
    	teacherName varchar(100),
    	phone varchar(100),
    	age varchar(100),
    	sex 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.phone is '电话';
    comment on column t_teacher.age is '年龄';
    comment on column t_teacher.sex is '性别';
    --老师表加注释
    comment on table t_teacher is '老师';
    
    create table t_tongzhi(
    	id integer,
    	studentId int(11),
    	title varchar(1000),
    	insertDate datetime
    );
    --通知字段加注释
    comment on column t_tongzhi.id is '主键';
    comment on column t_tongzhi.id is '主键唯一ID';
    comment on column t_tongzhi.studentId is '学生';
    comment on column t_tongzhi.title is '内容';
    comment on column t_tongzhi.insertDate is '发起日期';
    --通知表加注释
    comment on table t_tongzhi is '通知';
    
    --成绩表注释
    create table t_cj(
    	id int identity(1,1) primary key not null,--主键
    	studentId int(11),--学生
    	v1 double,--50米秒速成绩
    	v2 double,--1000米分钟数成绩
    	v3 double,--坐位体前屈厘米数成绩
    	v4 int(11),--引体向上个数成绩
    	v5 int(11),--跳绳个数
    	showDate datetime--日期
    );
    
    --锻炼计划表注释
    create table t_dljh(
    	id int identity(1,1) primary key not null,--主键
    	studentId int(11),--学生
    	xm varchar(100),--锻炼项目
    	title varchar(1000),--内容
    	insertDate datetime--发起日期
    );
    
    --公告表注释
    create table t_gonggao(
    	id int identity(1,1) primary key not null,--主键
    	title varchar(1000),--标题
    	content text,--内容
    	insertDate datetime--发起日期
    );
    
    --留言表注释
    create table t_ly(
    	id int identity(1,1) primary key not null,--主键
    	studentId int(11),--学生
    	content text,--内容
    	insertDate datetime,--发起日期
    	back text,--回复
    	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),--姓名
    	phone varchar(100),--电话
    	age varchar(100),--年龄
    	sex varchar(100)--性别
    );
    
    --老师表注释
    create table t_teacher(
    	id int identity(1,1) primary key not null,--主键
    	username varchar(100),--工号
    	password varchar(100),--密码
    	teacherName varchar(100),--姓名
    	phone varchar(100),--电话
    	age varchar(100),--年龄
    	sex varchar(100)--性别
    );
    
    --通知表注释
    create table t_tongzhi(
    	id int identity(1,1) primary key not null,--主键
    	studentId int(11),--学生
    	title varchar(1000),--内容
    	insertDate datetime--发起日期
    );
    
    
    
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    
    AI助手

    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;}
    //主键唯一ID
    private int id;
    //学生
    private int studentId;
    //50米秒速成绩
    private String v1;
    //1000米分钟数成绩
    private String v2;
    //坐位体前屈厘米数成绩
    private String v3;
    //引体向上个数成绩
    private int v4;
    //跳绳个数
    private int v5;
    //日期
    private Date showDate;
    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 getV1() {return v1;}
    public void setV1(String v1) {this.v1 = v1;}
    public String getV2() {return v2;}
    public void setV2(String v2) {this.v2 = v2;}
    public String getV3() {return v3;}
    public void setV3(String v3) {this.v3 = v3;}
    public int getV4() {return v4;}
    public void setV4(int v4) {this.v4 = v4;}
    public int getV5() {return v5;}
    public void setV5(int v5) {this.v5 = v5;}
    public Date getShowDate() {return showDate;}
    public void setShowDate(Date showDate) {this.showDate = showDate;}
    }
    
    
    
    package project.model;
    import org.springframework.format.annotation.DateTimeFormat;
    import java.util.Date;
    
    //锻炼计划
    public class Dljh  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 xm;
    //内容
    private String title;
    //发起日期
    private Date insertDate;
    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 getXm() {return xm;}
    public void setXm(String xm) {this.xm = xm;}
    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 Gonggao  extends BaseBean{
    //主键
    private Integer id;
    public Integer getId() {return id;}
    public void setId(Integer id) {this.id = id;}
    //主键唯一ID
    private int id;
    //标题
    private String title;
    //内容
    private String content;
    //发起日期
    private Date insertDate;
    public int getId() {return id;}
    public void setId(int id) {this.id = id;}
    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;}
    }
    
    
    
    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;}
    //主键唯一ID
    private int id;
    //学生
    private int studentId;
    //内容
    private String content;
    //发起日期
    private Date insertDate;
    //回复
    private String back;
    //状态
    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 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 getBack() {return back;}
    public void setBack(String back) {this.back = back;}
    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 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 String studentName;
    //电话
    private String phone;
    //年龄
    private String age;
    //性别
    private String sex;
    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 getStudentName() {return studentName;}
    public void setStudentName(String studentName) {this.studentName = studentName;}
    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;}
    }
    
    
    
    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 phone;
    //年龄
    private String age;
    //性别
    private String sex;
    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 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;}
    }
    
    
    
    package project.model;
    import org.springframework.format.annotation.DateTimeFormat;
    import java.util.Date;
    
    //通知
    public class Tongzhi  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;
    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;}
    }
    
    
    
    
    
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    
    AI助手