基于BS架构的小饭桌学生管理系统开发与设计

设计题目 基于B/S架构的小饭桌学生管理系统的设计与实现      

一、选题背景与意义    

小区附近有一家小学,所以小区里有许多小饭桌,但是小饭桌多是家庭经营,学生信息多用纸笔记录,效率低下,管理混乱,所以需要设计一种统一的、完善的、安全的、易于管理的学生管理系统,能够有效减轻管理员的工作压力和工作冗杂度,从而提高管理水平

二、设计内容

1. 设计内容:

主要涉及到jsp、ssh框架、数据库等技术,服务器端使用java进行实现。运用HTML语言对网站的jsp静态页面进行精细的加工,并使用jstl标签对数据进行动态操作。其次,将spring+springMVC+hibernate框架整合对后台逻辑进行开发

功能:

①信息上传:管理员可以上传、修改、删除学生信息,当日菜谱信息,也可以根据当日实际情况上传学生考勤信息,家长可以上传对小饭桌的评价和建议。

②浏览:学生家长登陆后可以查看当日菜谱信息,自己孩子的考勤信息,其他家长对小饭桌的评价信息。

③输出:可以输出缴费报表,查看当月小饭桌收入。

④用户控制:含注册、登录、个人信息管理、权限控制等用户功能。

  1. 预期效果:

通过实现以上内容,家长在注册以后,可以很方便的通过浏览器端来查看小饭桌情况,孩子的考勤信息,当月的费用明细。管理员也可以很方便的记录小饭桌情况,自动计算收入,脱离手工记账的原始模式。

 

三、设计方案

    该软件系统服务于电子文档、服务于用户,所以整个系统的结构设计离不开这两个中心元素。

    该软件系统前台使用div+css来进行网页布局,使用javascript+ajax来实现一些异步请求,后台使用struts2以及servlet来处理请求,使用hibernate来负责数据持久化,使用spring来进行业务处理和声明式事务处理,数据库使用sqlserver等主流数据库。

 

基于BS架构的小饭桌学生管理系统开发与设计登录注册界面

基于BS架构的小饭桌学生管理系统开发与设计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_cp(
	id int primary key auto_increment comment '主键',
	xfzId int comment '小饭桌',
	cpName varchar(100) comment '菜品名称',
	pic varchar(100) comment '图片',
	fee int comment '价格',
	content varchar(100) comment '内容'
) comment '菜品';

考勤表创建语句如下:


create table t_kq(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	xfzId int comment '小饭桌',
	cpNames varchar(100) comment '菜品列表',
	fee int comment '总价格',
	content varchar(100) comment '备注',
	showDate datetime comment '消费日期'
) comment '考勤';

考勤表创建语句如下:


create table t_kqss(
	id int primary key auto_increment comment '主键',
	xfzId int comment '小饭桌',
	studentId int comment '学生',
	showDate datetime comment '日期',
	fee int comment '金额'
) comment '考勤';

评价和建议表创建语句如下:


create table t_pjjy(
	id int primary key auto_increment comment '主键',
	ptadminId int comment '家长',
	xfzId int comment '小饭桌',
	content varchar(100) comment '评论',
	insertDate datetime comment '日期'
) comment '评价和建议';

家长表创建语句如下:


create table t_ptadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	ptadminName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	studentId int 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像'
) comment '学生';

小饭桌表创建语句如下:


create table t_xfz(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	xfzName varchar(100) comment '小饭桌名称',
	address varchar(100) comment '地址',
	pic varchar(100) comment '图片',
	lxr varchar(100) comment '联系人',
	lxdh varchar(100) comment '联系电话'
) comment '小饭桌';

表创建语句如下:


create table t_xfzxs(
	id int primary key auto_increment comment '主键',
	xfzId int comment '小饭桌',
	studentId int comment '学生'
) comment '';

基于BS架构的小饭桌学生管理系统开发与设计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_cp(
	id integer,
	xfzId int,
	cpName varchar(100),
	pic varchar(100),
	fee int,
	content varchar(100)
);
--菜品字段加注释
comment on column t_cp.id is '主键';
comment on column t_cp.xfzId is '小饭桌';
comment on column t_cp.cpName is '菜品名称';
comment on column t_cp.pic is '图片';
comment on column t_cp.fee is '价格';
comment on column t_cp.content is '内容';
--菜品表加注释
comment on table t_cp is '菜品';

考勤表创建语句如下:


create table t_kq(
	id integer,
	studentId int,
	xfzId int,
	cpNames varchar(100),
	fee int,
	content varchar(100),
	showDate datetime
);
--考勤字段加注释
comment on column t_kq.id is '主键';
comment on column t_kq.studentId is '学生';
comment on column t_kq.xfzId is '小饭桌';
comment on column t_kq.cpNames is '菜品列表';
comment on column t_kq.fee is '总价格';
comment on column t_kq.content is '备注';
comment on column t_kq.showDate is '消费日期';
--考勤表加注释
comment on table t_kq is '考勤';

考勤表创建语句如下:


create table t_kqss(
	id integer,
	xfzId int,
	studentId int,
	showDate datetime,
	fee int
);
--考勤字段加注释
comment on column t_kqss.id is '主键';
comment on column t_kqss.xfzId is '小饭桌';
comment on column t_kqss.studentId is '学生';
comment on column t_kqss.showDate is '日期';
comment on column t_kqss.fee is '金额';
--考勤表加注释
comment on table t_kqss is '考勤';

评价和建议表创建语句如下:


create table t_pjjy(
	id integer,
	ptadminId int,
	xfzId int,
	content varchar(100),
	insertDate datetime
);
--评价和建议字段加注释
comment on column t_pjjy.id is '主键';
comment on column t_pjjy.ptadminId is '家长';
comment on column t_pjjy.xfzId is '小饭桌';
comment on column t_pjjy.content is '评论';
comment on column t_pjjy.insertDate is '日期';
--评价和建议表加注释
comment on table t_pjjy is '评价和建议';

家长表创建语句如下:


create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	studentId int
);
--家长字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码 ';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.studentId is '学生';
--家长表加注释
comment on table t_ptadmin is '家长';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic 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.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.pic is '头像';
--学生表加注释
comment on table t_student is '学生';

小饭桌表创建语句如下:


create table t_xfz(
	id integer,
	username varchar(100),
	password varchar(100),
	xfzName varchar(100),
	address varchar(100),
	pic varchar(100),
	lxr varchar(100),
	lxdh varchar(100)
);
--小饭桌字段加注释
comment on column t_xfz.id is '主键';
comment on column t_xfz.username is '账号';
comment on column t_xfz.password is '密码 ';
comment on column t_xfz.xfzName is '小饭桌名称';
comment on column t_xfz.address is '地址';
comment on column t_xfz.pic is '图片';
comment on column t_xfz.lxr is '联系人';
comment on column t_xfz.lxdh is '联系电话';
--小饭桌表加注释
comment on table t_xfz is '小饭桌';

表创建语句如下:


create table t_xfzxs(
	id integer,
	xfzId int,
	studentId int
);
--字段加注释
comment on column t_xfzxs.id is '主键';
comment on column t_xfzxs.xfzId is '小饭桌';
comment on column t_xfzxs.studentId is '学生';
--表加注释
comment on table t_xfzxs is '';

oracle特有,对应序列如下:


create sequence s_t_cp;
create sequence s_t_kq;
create sequence s_t_kqss;
create sequence s_t_pjjy;
create sequence s_t_ptadmin;
create sequence s_t_student;
create sequence s_t_xfz;
create sequence s_t_xfzxs;

基于BS架构的小饭桌学生管理系统开发与设计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_cp(
	id int identity(1,1) primary key not null,--主键
	xfzId int,--小饭桌
	cpName varchar(100),--菜品名称
	pic varchar(100),--图片
	fee int,--价格
	content varchar(100)--内容
);

考勤表创建语句如下:


--考勤表注释
create table t_kq(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	xfzId int,--小饭桌
	cpNames varchar(100),--菜品列表
	fee int,--总价格
	content varchar(100),--备注
	showDate datetime--消费日期
);

考勤表创建语句如下:


--考勤表注释
create table t_kqss(
	id int identity(1,1) primary key not null,--主键
	xfzId int,--小饭桌
	studentId int,--学生
	showDate datetime,--日期
	fee int--金额
);

评价和建议表创建语句如下:


--评价和建议表注释
create table t_pjjy(
	id int identity(1,1) primary key not null,--主键
	ptadminId int,--家长
	xfzId int,--小饭桌
	content varchar(100),--评论
	insertDate datetime--日期
);

家长表创建语句如下:


--家长表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	ptadminName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	studentId int--学生
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	studentName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100)--头像
);

小饭桌表创建语句如下:


--小饭桌表注释
create table t_xfz(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	xfzName varchar(100),--小饭桌名称
	address varchar(100),--地址
	pic varchar(100),--图片
	lxr varchar(100),--联系人
	lxdh varchar(100)--联系电话
);

表创建语句如下:


--表注释
create table t_xfzxs(
	id int identity(1,1) primary key not null,--主键
	xfzId int,--小饭桌
	studentId int--学生
);

基于BS架构的小饭桌学生管理系统开发与设计登录后主页

基于BS架构的小饭桌学生管理系统开发与设计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_cp")
public class Cp {
//主键
@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 xfzId;
//菜品名称
private String cpName;
//图片
private String pic;
//价格
private Integer fee;
//内容
private String content;
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

考勤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_kq")
public class Kq {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//小饭桌
private Integer xfzId;
//菜品列表
private String cpNames;
//总价格
private Integer fee;
//备注
private String content;
//消费日期
private Date showDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
public String getCpNames() {return cpNames;}
public void setCpNames(String cpNames) {this.cpNames = cpNames;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

考勤javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//考勤
@Table(name = "t_kqss")
public class Kqss {
//主键
@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 xfzId;
//学生
private Integer studentId;
//日期
private Date showDate;
//金额
private Integer fee;
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}

评价和建议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_pjjy")
public class Pjjy {
//主键
@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 ptadminId;
//小饭桌
private Integer xfzId;
//评论
private String content;
//日期
private Date insertDate;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//学生
private Integer studentId;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
}

学生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 age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

小饭桌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_xfz")
public class Xfz {
//主键
@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 xfzName;
//地址
private String address;
//图片
private String pic;
//联系人
private String lxr;
//联系电话
private String lxdh;
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 getXfzName() {return xfzName;}
public void setXfzName(String xfzName) {this.xfzName = xfzName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}

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_xfzxs")
public class Xfzxs {
//主键
@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 xfzId;
//学生
private Integer studentId;
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
}

基于BS架构的小饭桌学生管理系统开发与设计spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

菜品javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//菜品
public class Cp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//小饭桌
private Integer xfzId;
//菜品名称
private String cpName;
//图片
private String pic;
//价格
private Integer fee;
//内容
private String content;
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

考勤javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//考勤
public class Kq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//小饭桌
private Integer xfzId;
//菜品列表
private String cpNames;
//总价格
private Integer fee;
//备注
private String content;
//消费日期
private Date showDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
public String getCpNames() {return cpNames;}
public void setCpNames(String cpNames) {this.cpNames = cpNames;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

考勤javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//考勤
public class Kqss  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//小饭桌
private Integer xfzId;
//学生
private Integer studentId;
//日期
private Date showDate;
//金额
private Integer fee;
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}

评价和建议javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//评价和建议
public class Pjjy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//家长
private Integer ptadminId;
//小饭桌
private Integer xfzId;
//评论
private String content;
//日期
private Date insertDate;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
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 Ptadmin  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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//学生
private Integer studentId;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
}

学生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 age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

小饭桌javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//小饭桌
public class Xfz  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 xfzName;
//地址
private String address;
//图片
private String pic;
//联系人
private String lxr;
//联系电话
private String lxdh;
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 getXfzName() {return xfzName;}
public void setXfzName(String xfzName) {this.xfzName = xfzName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}

javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//
public class Xfzxs  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//小饭桌
private Integer xfzId;
//学生
private Integer studentId;
public Integer getXfzId() {return xfzId;}
public void setXfzId(Integer xfzId) {this.xfzId = xfzId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
}

源代码下载点这里

评论