- 大学生毕业账单mysql数据库创建语句
- 大学生毕业账单oracle数据库创建语句
- 大学生毕业账单sqlserver数据库创建语句
- 大学生毕业账单spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 大学生毕业账单spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
大学生毕业账单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_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '发起日期'
) comment '公告';
教务教学表创建语句如下：
create table t_jwjx(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
kc varchar(100) comment '课程',
ls varchar(100) comment '老师',
xf int comment '学分',
zf int comment '总分',
showDate datetime comment '课程结束日期'
) comment '教务教学';
留言表创建语句如下：
create table t_ly(
id int primary key auto_increment comment '主键',
studentId int 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 '',
zy varchar(100) comment '专业',
xb 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 '',
zy varchar(100) comment '专业',
xb varchar(100) comment '系部'
) comment '老师';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
title varchar(100) comment '内容',
insertDate datetime comment '发起日期'
) comment '通知';
图书借阅表创建语句如下：
create table t_tsjy(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
sjmc varchar(100) comment '书籍名称',
jydd varchar(100) comment '借阅订单编号',
showDate datetime comment '借阅日期',
status varchar(100) comment '',
remark text comment '备注'
) comment '图书借阅';
体质评测表创建语句如下：
create table t_tzpc(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
pb varchar(100) comment '',
ts varchar(100) comment '',
ty varchar(100) comment '',
tg varchar(100) comment '',
jcrq datetime comment '检测日期'
) comment '体质评测';
校园卡消费表创建语句如下：
create table t_xfjl(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
kh varchar(100) comment '卡号',
xfdd varchar(100) comment '消费订单编号',
showDate datetime comment '消费日期',
xfxm int comment '消费金额',
remark text comment '消费项目'
) comment '校园卡消费';
大学生毕业账单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_gonggao(
id integer,
title varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
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_jwjx(
id integer,
studentId int,
kc varchar(100),
ls varchar(100),
xf int,
zf int,
showDate datetime
);
--教务教学字段加注释
comment on column t_jwjx.id is '主键';
comment on column t_jwjx.studentId is '学生';
comment on column t_jwjx.kc is '课程';
comment on column t_jwjx.ls is '老师';
comment on column t_jwjx.xf is '学分';
comment on column t_jwjx.zf is '总分';
comment on column t_jwjx.showDate is '课程结束日期';
--教务教学表加注释
comment on table t_jwjx is '教务教学';
留言表创建语句如下：
create table t_ly(
id integer,
studentId int,
content text,
insertDate datetime,
back text,
status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
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),
zy varchar(100),
xb 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.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '';
comment on column t_student.zy is '专业';
comment on column t_student.xb 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),
zy varchar(100),
xb 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.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '';
comment on column t_teacher.zy is '专业';
comment on column t_teacher.xb is '系部';
--老师表加注释
comment on table t_teacher is '老师';
通知表创建语句如下：
create table t_tongzhi(
id integer,
studentId int,
title varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
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_tsjy(
id integer,
studentId int,
sjmc varchar(100),
jydd varchar(100),
showDate datetime,
status varchar(100),
remark text
);
--图书借阅字段加注释
comment on column t_tsjy.id is '主键';
comment on column t_tsjy.studentId is '学生';
comment on column t_tsjy.sjmc is '书籍名称';
comment on column t_tsjy.jydd is '借阅订单编号';
comment on column t_tsjy.showDate is '借阅日期';
comment on column t_tsjy.status is '';
comment on column t_tsjy.remark is '备注';
--图书借阅表加注释
comment on table t_tsjy is '图书借阅';
体质评测表创建语句如下：
create table t_tzpc(
id integer,
studentId int,
pb varchar(100),
ts varchar(100),
ty varchar(100),
tg varchar(100),
jcrq datetime
);
--体质评测字段加注释
comment on column t_tzpc.id is '主键';
comment on column t_tzpc.studentId is '学生';
comment on column t_tzpc.pb is '';
comment on column t_tzpc.ts is '';
comment on column t_tzpc.ty is '';
comment on column t_tzpc.tg is '';
comment on column t_tzpc.jcrq is '检测日期';
--体质评测表加注释
comment on table t_tzpc is '体质评测';
校园卡消费表创建语句如下：
create table t_xfjl(
id integer,
studentId int,
kh varchar(100),
xfdd varchar(100),
showDate datetime,
xfxm int,
remark text
);
--校园卡消费字段加注释
comment on column t_xfjl.id is '主键';
comment on column t_xfjl.studentId is '学生';
comment on column t_xfjl.kh is '卡号';
comment on column t_xfjl.xfdd is '消费订单编号';
comment on column t_xfjl.showDate is '消费日期';
comment on column t_xfjl.xfxm is '消费金额';
comment on column t_xfjl.remark is '消费项目';
--校园卡消费表加注释
comment on table t_xfjl is '校园卡消费';
oracle特有，对应序列如下：
create sequence s_t_gonggao;
create sequence s_t_jwjx;
create sequence s_t_ly;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_tongzhi;
create sequence s_t_tsjy;
create sequence s_t_tzpc;
create sequence s_t_xfjl;
大学生毕业账单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_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--发起日期
);
教务教学表创建语句如下：
--教务教学表注释
create table t_jwjx(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
kc varchar(100),--课程
ls varchar(100),--老师
xf int,--学分
zf int,--总分
showDate datetime--课程结束日期
);
留言表创建语句如下：
--留言表注释
create table t_ly(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
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),--
zy varchar(100),--专业
xb 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),--
zy varchar(100),--专业
xb varchar(100)--系部
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
title varchar(100),--内容
insertDate datetime--发起日期
);
图书借阅表创建语句如下：
--图书借阅表注释
create table t_tsjy(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
sjmc varchar(100),--书籍名称
jydd varchar(100),--借阅订单编号
showDate datetime,--借阅日期
status varchar(100),--
remark text--备注
);
体质评测表创建语句如下：
--体质评测表注释
create table t_tzpc(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
pb varchar(100),--
ts varchar(100),--
ty varchar(100),--
tg varchar(100),--
jcrq datetime--检测日期
);
校园卡消费表创建语句如下：
--校园卡消费表注释
create table t_xfjl(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
kh varchar(100),--卡号
xfdd varchar(100),--消费订单编号
showDate datetime,--消费日期
xfxm int,--消费金额
remark text--消费项目
);
登录后主页.jpg?x-oss-process=style/00001)
大学生毕业账单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_gonggao")
public class Gonggao {
//主键
@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 content;
//发起日期
private Date insertDate;
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;}
}教务教学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_jwjx")
public class Jwjx {
//主键
@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 Long studentId;
//课程
private String kc;
//老师
private String ls;
//学分
private Integer xf;
//总分
private Integer zf;
//课程结束日期
private Date showDate;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getKc() {return kc;}
public void setKc(String kc) {this.kc = kc;}
public String getLs() {return ls;}
public void setLs(String ls) {this.ls = ls;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public Integer getZf() {return zf;}
public void setZf(Integer zf) {this.zf = zf;}
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_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 Long studentId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getStudentId() {return studentId;}
public void setStudentId(Long 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;}
}学生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 phone;
//年龄
private String age;
//
private String sex;
//专业
private String zy;
//系部
private String xb;
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;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}老师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 phone;
//年龄
private String age;
//
private String sex;
//专业
private String zy;
//系部
private String xb;
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;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}通知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_tongzhi")
public class Tongzhi {
//主键
@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 Long studentId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getStudentId() {return studentId;}
public void setStudentId(Long 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;}
}图书借阅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_tsjy")
public class Tsjy {
//主键
@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 Long studentId;
//书籍名称
private String sjmc;
//借阅订单编号
private String jydd;
//借阅日期
private Date showDate;
//
private String status;
//备注
private String remark;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getSjmc() {return sjmc;}
public void setSjmc(String sjmc) {this.sjmc = sjmc;}
public String getJydd() {return jydd;}
public void setJydd(String jydd) {this.jydd = jydd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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_tzpc")
public class Tzpc {
//主键
@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 Long studentId;
//
private String pb;
//
private String ts;
//
private String ty;
//
private String tg;
//检测日期
private Date jcrq;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getPb() {return pb;}
public void setPb(String pb) {this.pb = pb;}
public String getTs() {return ts;}
public void setTs(String ts) {this.ts = ts;}
public String getTy() {return ty;}
public void setTy(String ty) {this.ty = ty;}
public String getTg() {return tg;}
public void setTg(String tg) {this.tg = tg;}
public Date getJcrq() {return jcrq;}
public void setJcrq(Date jcrq) {this.jcrq = jcrq;}
}校园卡消费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_xfjl")
public class Xfjl {
//主键
@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 Long studentId;
//卡号
private String kh;
//消费订单编号
private String xfdd;
//消费日期
private Date showDate;
//消费金额
private Integer xfxm;
//消费项目
private String remark;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getKh() {return kh;}
public void setKh(String kh) {this.kh = kh;}
public String getXfdd() {return xfdd;}
public void setXfdd(String xfdd) {this.xfdd = xfdd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getXfxm() {return xfxm;}
public void setXfxm(Integer xfxm) {this.xfxm = xfxm;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}大学生毕业账单spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
公告javaBean创建语句如下：
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;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
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;}
}教务教学javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//教务教学
public class Jwjx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long studentId;
//课程
private String kc;
//老师
private String ls;
//学分
private Integer xf;
//总分
private Integer zf;
//课程结束日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getKc() {return kc;}
public void setKc(String kc) {this.kc = kc;}
public String getLs() {return ls;}
public void setLs(String ls) {this.ls = ls;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public Integer getZf() {return zf;}
public void setZf(Integer zf) {this.zf = zf;}
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 Ly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long studentId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getStudentId() {return studentId;}
public void setStudentId(Long 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;}
}学生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 phone;
//年龄
private String age;
//
private String sex;
//专业
private String zy;
//系部
private String xb;
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;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}老师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 phone;
//年龄
private String age;
//
private String sex;
//专业
private String zy;
//系部
private String xb;
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;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}通知javaBean创建语句如下：
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;}
//学生
private Long studentId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getStudentId() {return studentId;}
public void setStudentId(Long 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;}
}图书借阅javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//图书借阅
public class Tsjy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long studentId;
//书籍名称
private String sjmc;
//借阅订单编号
private String jydd;
//借阅日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//
private String status;
//备注
private String remark;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getSjmc() {return sjmc;}
public void setSjmc(String sjmc) {this.sjmc = sjmc;}
public String getJydd() {return jydd;}
public void setJydd(String jydd) {this.jydd = jydd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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 Tzpc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long studentId;
//
private String pb;
//
private String ts;
//
private String ty;
//
private String tg;
//检测日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date jcrq;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getPb() {return pb;}
public void setPb(String pb) {this.pb = pb;}
public String getTs() {return ts;}
public void setTs(String ts) {this.ts = ts;}
public String getTy() {return ty;}
public void setTy(String ty) {this.ty = ty;}
public String getTg() {return tg;}
public void setTg(String tg) {this.tg = tg;}
public Date getJcrq() {return jcrq;}
public void setJcrq(Date jcrq) {this.jcrq = jcrq;}
}校园卡消费javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//校园卡消费
public class Xfjl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long studentId;
//卡号
private String kh;
//消费订单编号
private String xfdd;
//消费日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//消费金额
private Integer xfxm;
//消费项目
private String remark;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getKh() {return kh;}
public void setKh(String kh) {this.kh = kh;}
public String getXfdd() {return xfdd;}
public void setXfdd(String xfdd) {this.xfdd = xfdd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getXfxm() {return xfxm;}
public void setXfxm(Integer xfxm) {this.xfxm = xfxm;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}