基于Spring MVC学生信息管理子系统的实现，java设计与开发

• 基于Spring MVC学生信息管理子系统的实现mysql数据库创建语句
• 基于Spring MVC学生信息管理子系统的实现oracle数据库创建语句
• 基于Spring MVC学生信息管理子系统的实现sqlserver数据库创建语句
• 基于Spring MVC学生信息管理子系统的实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 基于Spring MVC学生信息管理子系统的实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计

基于Spring MVC学生信息管理子系统的实现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_gg(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '公告',
	showDate varchar(100) comment '日期'
) comment '公告';

管理用品表创建语句如下：

create table t_glyp(
	id int primary key auto_increment comment '主键',
	glypName varchar(100) comment '用品名称'
) comment '管理用品';

管理用品领取表创建语句如下：

create table t_glyplq(
	id int primary key auto_increment comment '主键',
	glypId varchar(100) comment '管理用品',
	studentId int comment '学生'
) comment '管理用品领取';

迎新工作人员表创建语句如下：

create table t_gzry(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	studentName varchar(100) comment '姓名',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	idcard varchar(100) comment '身份证'
) comment '迎新工作人员';

军训用品表创建语句如下：

create table t_jxyp(
	id int primary key auto_increment comment '主键',
	jxypName varchar(100) comment '用品名称'
) comment '军训用品';

军训用品领取表创建语句如下：

create table t_jxyplq(
	id int primary key auto_increment comment '主键',
	jxypId varchar(100) comment '军训用品',
	studentId int comment '学生'
) comment '军训用品领取';

评论表创建语句如下：

create table t_pinglun(
	id int primary key auto_increment comment '主键',
	studentId int comment '用户',
	content varchar(100) comment '内容',
	answer varchar(100) comment '回答',
	insertDate datetime comment '日期',
	status varchar(100) comment '状态'
) comment '评论';

宿舍表创建语句如下：

create table t_ss(
	id int primary key auto_increment comment '主键',
	ssName varchar(100) comment '宿舍编号'
) comment '宿舍';

宿舍选择表创建语句如下：

create table t_ssxz(
	id int primary key auto_increment comment '主键',
	ssId 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 '姓名',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	idcard varchar(100) comment '身份证',
	bj varchar(100) comment '班级'
) comment '新生';

通知表创建语句如下：

create table t_tz(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '通知',
	showDate varchar(100) comment '日期'
) comment '通知';

资讯新闻表创建语句如下：

create table t_zxxw(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	pic varchar(100) comment '图片'
) comment '资讯新闻';

基于Spring MVC学生信息管理子系统的实现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_gg(
	id integer,
	title varchar(100),
	showDate varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '公告';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';

管理用品表创建语句如下：

create table t_glyp(
	id integer,
	glypName varchar(100)
);
--管理用品字段加注释
comment on column t_glyp.id is '主键';
comment on column t_glyp.glypName is '用品名称';
--管理用品表加注释
comment on table t_glyp is '管理用品';

管理用品领取表创建语句如下：

create table t_glyplq(
	id integer,
	glypId varchar(100),
	studentId int
);
--管理用品领取字段加注释
comment on column t_glyplq.id is '主键';
comment on column t_glyplq.glypId is '管理用品';
comment on column t_glyplq.studentId is '学生';
--管理用品领取表加注释
comment on table t_glyplq is '管理用品领取';

迎新工作人员表创建语句如下：

create table t_gzry(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	sex varchar(100),
	age varchar(100),
	idcard varchar(100)
);
--迎新工作人员字段加注释
comment on column t_gzry.id is '主键';
comment on column t_gzry.username is '账号';
comment on column t_gzry.password is '密码';
comment on column t_gzry.studentName is '姓名';
comment on column t_gzry.sex is '性别';
comment on column t_gzry.age is '年龄';
comment on column t_gzry.idcard is '身份证';
--迎新工作人员表加注释
comment on table t_gzry is '迎新工作人员';

军训用品表创建语句如下：

create table t_jxyp(
	id integer,
	jxypName varchar(100)
);
--军训用品字段加注释
comment on column t_jxyp.id is '主键';
comment on column t_jxyp.jxypName is '用品名称';
--军训用品表加注释
comment on table t_jxyp is '军训用品';

军训用品领取表创建语句如下：

create table t_jxyplq(
	id integer,
	jxypId varchar(100),
	studentId int
);
--军训用品领取字段加注释
comment on column t_jxyplq.id is '主键';
comment on column t_jxyplq.jxypId is '军训用品';
comment on column t_jxyplq.studentId is '学生';
--军训用品领取表加注释
comment on table t_jxyplq is '军训用品领取';

评论表创建语句如下：

create table t_pinglun(
	id integer,
	studentId int,
	content varchar(100),
	answer varchar(100),
	insertDate datetime,
	status varchar(100)
);
--评论字段加注释
comment on column t_pinglun.id is '主键';
comment on column t_pinglun.studentId is '用户';
comment on column t_pinglun.content is '内容';
comment on column t_pinglun.answer is '回答';
comment on column t_pinglun.insertDate is '日期';
comment on column t_pinglun.status is '状态';
--评论表加注释
comment on table t_pinglun is '评论';

宿舍表创建语句如下：

create table t_ss(
	id integer,
	ssName varchar(100)
);
--宿舍字段加注释
comment on column t_ss.id is '主键';
comment on column t_ss.ssName is '宿舍编号';
--宿舍表加注释
comment on table t_ss is '宿舍';

宿舍选择表创建语句如下：

create table t_ssxz(
	id integer,
	ssId varchar(100),
	studentId int
);
--宿舍选择字段加注释
comment on column t_ssxz.id is '主键';
comment on column t_ssxz.ssId is '宿舍';
comment on column t_ssxz.studentId is '学生';
--宿舍选择表加注释
comment on table t_ssxz is '宿舍选择';

新生表创建语句如下：

create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	sex varchar(100),
	age varchar(100),
	idcard varchar(100),
	bj 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.sex is '性别';
comment on column t_student.age is '年龄';
comment on column t_student.idcard is '身份证';
comment on column t_student.bj is '班级';
--新生表加注释
comment on table t_student is '新生';

通知表创建语句如下：

create table t_tz(
	id integer,
	title varchar(100),
	showDate varchar(100)
);
--通知字段加注释
comment on column t_tz.id is '主键';
comment on column t_tz.title is '通知';
comment on column t_tz.showDate is '日期';
--通知表加注释
comment on table t_tz is '通知';

资讯新闻表创建语句如下：

create table t_zxxw(
	id integer,
	title varchar(100),
	content varchar(100),
	pic varchar(100)
);
--资讯新闻字段加注释
comment on column t_zxxw.id is '主键';
comment on column t_zxxw.title is '标题';
comment on column t_zxxw.content is '内容';
comment on column t_zxxw.pic is '图片';
--资讯新闻表加注释
comment on table t_zxxw is '资讯新闻';

oracle特有，对应序列如下：

create sequence s_t_gg;
create sequence s_t_glyp;
create sequence s_t_glyplq;
create sequence s_t_gzry;
create sequence s_t_jxyp;
create sequence s_t_jxyplq;
create sequence s_t_pinglun;
create sequence s_t_ss;
create sequence s_t_ssxz;
create sequence s_t_student;
create sequence s_t_tz;
create sequence s_t_zxxw;

基于Spring MVC学生信息管理子系统的实现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_gg(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--公告
	showDate varchar(100)--日期
);

管理用品表创建语句如下：

--管理用品表注释
create table t_glyp(
	id int identity(1,1) primary key not null,--主键
	glypName varchar(100)--用品名称
);

管理用品领取表创建语句如下：

--管理用品领取表注释
create table t_glyplq(
	id int identity(1,1) primary key not null,--主键
	glypId varchar(100),--管理用品
	studentId int--学生
);

迎新工作人员表创建语句如下：

--迎新工作人员表注释
create table t_gzry(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	sex varchar(100),--性别
	age varchar(100),--年龄
	idcard varchar(100)--身份证
);

军训用品表创建语句如下：

--军训用品表注释
create table t_jxyp(
	id int identity(1,1) primary key not null,--主键
	jxypName varchar(100)--用品名称
);

军训用品领取表创建语句如下：

--军训用品领取表注释
create table t_jxyplq(
	id int identity(1,1) primary key not null,--主键
	jxypId varchar(100),--军训用品
	studentId int--学生
);

评论表创建语句如下：

--评论表注释
create table t_pinglun(
	id int identity(1,1) primary key not null,--主键
	studentId int,--用户
	content varchar(100),--内容
	answer varchar(100),--回答
	insertDate datetime,--日期
	status varchar(100)--状态
);

宿舍表创建语句如下：

--宿舍表注释
create table t_ss(
	id int identity(1,1) primary key not null,--主键
	ssName varchar(100)--宿舍编号
);

宿舍选择表创建语句如下：

--宿舍选择表注释
create table t_ssxz(
	id int identity(1,1) primary key not null,--主键
	ssId 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),--姓名
	sex varchar(100),--性别
	age varchar(100),--年龄
	idcard varchar(100),--身份证
	bj varchar(100)--班级
);

通知表创建语句如下：

--通知表注释
create table t_tz(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--通知
	showDate varchar(100)--日期
);

资讯新闻表创建语句如下：

--资讯新闻表注释
create table t_zxxw(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	pic varchar(100)--图片
);

基于Spring MVC学生信息管理子系统的实现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_gg")
public class Gg {
//主键
@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 showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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_glyp")
public class Glyp {
//主键
@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 glypName;
public String getGlypName() {return glypName;}
public void setGlypName(String glypName) {this.glypName = glypName;}
}

管理用品领取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_glyplq")
public class Glyplq {
//主键
@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 glypId;
//学生
private Integer studentId;
public String getGlypId() {return glypId;}
public void setGlypId(String glypId) {this.glypId = glypId;}
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_gzry")
public class Gzry {
//主键
@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 sex;
//年龄
private String age;
//身份证
private String idcard;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

军训用品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_jxyp")
public class Jxyp {
//主键
@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 jxypName;
public String getJxypName() {return jxypName;}
public void setJxypName(String jxypName) {this.jxypName = jxypName;}
}

军训用品领取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_jxyplq")
public class Jxyplq {
//主键
@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 jxypId;
//学生
private Integer studentId;
public String getJxypId() {return jxypId;}
public void setJxypId(String jxypId) {this.jxypId = jxypId;}
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_pinglun")
public class Pinglun {
//主键
@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 String content;
//回答
private String answer;
//日期
private Date insertDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_ss")
public class Ss {
//主键
@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 ssName;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
}

宿舍选择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_ssxz")
public class Ssxz {
//主键
@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 ssId;
//学生
private Integer studentId;
public String getSsId() {return ssId;}
public void setSsId(String ssId) {this.ssId = ssId;}
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 sex;
//年龄
private String age;
//身份证
private String idcard;
//班级
private String bj;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
}

通知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 showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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_zxxw")
public class Zxxw {
//主键
@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 String pic;
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 String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

基于Spring MVC学生信息管理子系统的实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

公告javaBean创建语句如下：

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

//公告
public class Gg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//公告
private String title;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Glyp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用品名称
private String glypName;
public String getGlypName() {return glypName;}
public void setGlypName(String glypName) {this.glypName = glypName;}
}

管理用品领取javaBean创建语句如下：

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

//管理用品领取
public class Glyplq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//管理用品
private String glypId;
//学生
private Integer studentId;
public String getGlypId() {return glypId;}
public void setGlypId(String glypId) {this.glypId = glypId;}
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 Gzry  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 sex;
//年龄
private String age;
//身份证
private String idcard;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

军训用品javaBean创建语句如下：

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

//军训用品
public class Jxyp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用品名称
private String jxypName;
public String getJxypName() {return jxypName;}
public void setJxypName(String jxypName) {this.jxypName = jxypName;}
}

军训用品领取javaBean创建语句如下：

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

//军训用品领取
public class Jxyplq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//军训用品
private String jxypId;
//学生
private Integer studentId;
public String getJxypId() {return jxypId;}
public void setJxypId(String jxypId) {this.jxypId = jxypId;}
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 Pinglun  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer studentId;
//内容
private String content;
//回答
private String answer;
//日期
private Date insertDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Ss  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宿舍编号
private String ssName;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
}

宿舍选择javaBean创建语句如下：

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

//宿舍选择
public class Ssxz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宿舍
private String ssId;
//学生
private Integer studentId;
public String getSsId() {return ssId;}
public void setSsId(String ssId) {this.ssId = ssId;}
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 sex;
//年龄
private String age;
//身份证
private String idcard;
//班级
private String bj;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
}

通知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 showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Zxxw  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 String pic;
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 String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}