校园学生帮扶系统(xga28)_mysql

校园学生帮扶系统mysql数据库创建语句
校园学生帮扶系统oracle数据库创建语句
校园学生帮扶系统sqlserver数据库创建语句
校园学生帮扶系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
校园学生帮扶系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

校园学生帮扶系统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_bf(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	studentId int comment '学生',
	showDate datetime comment '开始日期',
	remark text comment '备注',
	status varchar(100) comment ''
) comment '帮扶记录';

帮扶交流表创建语句如下：


create table t_bfjl(
	id int primary key auto_increment comment '主键',
	bfId int comment '帮扶记录',
	xm varchar(100) comment '姓名',
	insertDate datetime comment '日期',
	content text comment '内容'
) comment '帮扶交流';

帮扶计划详情表创建语句如下：


create table t_bflist(
	id int primary key auto_increment comment '主键',
	bfId int comment '帮扶记录',
	title varchar(100) comment '标题',
	content text comment '内容',
	showDate datetime comment '时间'
) comment '帮扶计划详情';

申请帮扶表创建语句如下：


create table t_bfqq(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	title varchar(100) comment '帮扶请求说明',
	insertDate datetime comment '发起日期',
	status varchar(100) comment '状态',
	back text comment '回复'
) comment '申请帮扶';

公告表创建语句如下：


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_ly(
	id int primary key auto_increment comment '主键',
	customerId int comment '学生',
	title varchar(100) comment '内容',
	insertDate datetime comment '留言日期'
) comment '老师领导留言';

日志表创建语句如下：


create table t_rz(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	title varchar(100) comment '日志标题',
	showDate datetime comment '日志日期',
	content text 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 '',
	xh varchar(100) comment '学号',
	xy varchar(100) comment '学院',
	zy 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 '',
	xy varchar(100) comment '学院',
	zy varchar(100) comment '专业',
	kc varchar(100) comment '所带专业课名称',
	js varchar(100) 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_bf(
	id integer,
	teacherId int,
	studentId int,
	showDate datetime,
	remark text,
	status varchar(100)
);
--帮扶记录字段加注释
comment on column t_bf.id is '主键';
comment on column t_bf.teacherId is '老师';
comment on column t_bf.studentId is '学生';
comment on column t_bf.showDate is '开始日期';
comment on column t_bf.remark is '备注';
comment on column t_bf.status is '';
--帮扶记录表加注释
comment on table t_bf is '帮扶记录';

帮扶交流表创建语句如下：


create table t_bfjl(
	id integer,
	bfId int,
	xm varchar(100),
	insertDate datetime,
	content text
);
--帮扶交流字段加注释
comment on column t_bfjl.id is '主键';
comment on column t_bfjl.bfId is '帮扶记录';
comment on column t_bfjl.xm is '姓名';
comment on column t_bfjl.insertDate is '日期';
comment on column t_bfjl.content is '内容';
--帮扶交流表加注释
comment on table t_bfjl is '帮扶交流';

帮扶计划详情表创建语句如下：


create table t_bflist(
	id integer,
	bfId int,
	title varchar(100),
	content text,
	showDate datetime
);
--帮扶计划详情字段加注释
comment on column t_bflist.id is '主键';
comment on column t_bflist.bfId is '帮扶记录';
comment on column t_bflist.title is '标题';
comment on column t_bflist.content is '内容';
comment on column t_bflist.showDate is '时间';
--帮扶计划详情表加注释
comment on table t_bflist is '帮扶计划详情';

申请帮扶表创建语句如下：


create table t_bfqq(
	id integer,
	studentId int,
	title varchar(100),
	insertDate datetime,
	status varchar(100),
	back text
);
--申请帮扶字段加注释
comment on column t_bfqq.id is '主键';
comment on column t_bfqq.studentId is '学生';
comment on column t_bfqq.title is '帮扶请求说明';
comment on column t_bfqq.insertDate is '发起日期';
comment on column t_bfqq.status is '状态';
comment on column t_bfqq.back is '回复';
--申请帮扶表加注释
comment on table t_bfqq 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_ly(
	id integer,
	customerId int,
	title varchar(100),
	insertDate datetime
);
--老师领导留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.customerId is '学生';
comment on column t_ly.title is '内容';
comment on column t_ly.insertDate is '留言日期';
--老师领导留言表加注释
comment on table t_ly is '老师领导留言';

日志表创建语句如下：


create table t_rz(
	id integer,
	teacherId int,
	title varchar(100),
	showDate datetime,
	content text
);
--日志字段加注释
comment on column t_rz.id is '主键';
comment on column t_rz.teacherId is '老师';
comment on column t_rz.title is '日志标题';
comment on column t_rz.showDate is '日志日期';
comment on column t_rz.content is '内容';
--日志表加注释
comment on table t_rz 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),
	xh varchar(100),
	xy varchar(100),
	zy 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.xh is '学号';
comment on column t_student.xy is '学院';
comment on column t_student.zy 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),
	xy varchar(100),
	zy varchar(100),
	kc varchar(100),
	js 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.xy is '学院';
comment on column t_teacher.zy is '专业';
comment on column t_teacher.kc is '所带专业课名称';
comment on column t_teacher.js is '';
--老师领导表加注释
comment on table t_teacher is '老师领导';

oracle特有，对应序列如下：


create sequence s_t_bf;
create sequence s_t_bfjl;
create sequence s_t_bflist;
create sequence s_t_bfqq;
create sequence s_t_gonggao;
create sequence s_t_ly;
create sequence s_t_rz;
create sequence s_t_student;
create sequence s_t_teacher;

校园学生帮扶系统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_bf(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	studentId int,--学生
	showDate datetime,--开始日期
	remark text,--备注
	status varchar(100)--
);

帮扶交流表创建语句如下：


--帮扶交流表注释
create table t_bfjl(
	id int identity(1,1) primary key not null,--主键
	bfId int,--帮扶记录
	xm varchar(100),--姓名
	insertDate datetime,--日期
	content text--内容
);

帮扶计划详情表创建语句如下：


--帮扶计划详情表注释
create table t_bflist(
	id int identity(1,1) primary key not null,--主键
	bfId int,--帮扶记录
	title varchar(100),--标题
	content text,--内容
	showDate datetime--时间
);

申请帮扶表创建语句如下：


--申请帮扶表注释
create table t_bfqq(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	title varchar(100),--帮扶请求说明
	insertDate datetime,--发起日期
	status varchar(100),--状态
	back text--回复
);

公告表创建语句如下：


--公告表注释
create table t_gonggao(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content text,--内容
	insertDate datetime--发起日期
);

老师领导留言表创建语句如下：


--老师领导留言表注释
create table t_ly(
	id int identity(1,1) primary key not null,--主键
	customerId int,--学生
	title varchar(100),--内容
	insertDate datetime--留言日期
);

日志表创建语句如下：


--日志表注释
create table t_rz(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	title varchar(100),--日志标题
	showDate datetime,--日志日期
	content text--内容
);

学生表创建语句如下：


--学生表注释
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),--
	xh varchar(100),--学号
	xy varchar(100),--学院
	zy 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),--
	xy varchar(100),--学院
	zy varchar(100),--专业
	kc varchar(100),--所带专业课名称
	js varchar(100)--
);

校园学生帮扶系统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_bf")
public class Bf {
//主键
@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 teacherId;
//学生
private Long studentId;
//开始日期
private Date showDate;
//备注
private String remark;
//
private String status;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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_bfjl")
public class Bfjl {
//主键
@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 bfId;
//姓名
private String xm;
//日期
private Date insertDate;
//内容
private String content;
public Long getBfId() {return bfId;}
public void setBfId(Long bfId) {this.bfId = bfId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_bflist")
public class Bflist {
//主键
@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 bfId;
//标题
private String title;
//内容
private String content;
//时间
private Date showDate;
public Long getBfId() {return bfId;}
public void setBfId(Long bfId) {this.bfId = bfId;}
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 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_bfqq")
public class Bfqq {
//主键
@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;
//状态
private String status;
//回复
private String back;
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;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

公告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_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 customerId;
//内容
private String title;
//留言日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
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_rz")
public class Rz {
//主键
@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 teacherId;
//日志标题
private String title;
//日志日期
private Date showDate;
//内容
private String content;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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_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 xh;
//学院
private String xy;
//专业
private String zy;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}

老师领导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 xy;
//专业
private String zy;
//所带专业课名称
private String kc;
//
private String js;
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 getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getKc() {return kc;}
public void setKc(String kc) {this.kc = kc;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}

校园学生帮扶系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

帮扶记录javaBean创建语句如下：


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

//帮扶记录
public class Bf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//学生
private Long studentId;
//开始日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//备注
private String remark;
//
private String status;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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 Bfjl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//帮扶记录
private Long bfId;
//姓名
private String xm;
//日期
private Date insertDate;
//内容
private String content;
public Long getBfId() {return bfId;}
public void setBfId(Long bfId) {this.bfId = bfId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Bflist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//帮扶记录
private Long bfId;
//标题
private String title;
//内容
private String content;
//时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getBfId() {return bfId;}
public void setBfId(Long bfId) {this.bfId = bfId;}
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 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 Bfqq  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;
//状态
private String status;
//回复
private String back;
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;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

公告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 Ly  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long customerId;
//内容
private String title;
//留言日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
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 Rz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//日志标题
private String title;
//日志日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//内容
private String content;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 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 xh;
//学院
private String xy;
//专业
private String zy;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}

老师领导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 xy;
//专业
private String zy;
//所带专业课名称
private String kc;
//
private String js;
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 getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getKc() {return kc;}
public void setKc(String kc) {this.kc = kc;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}

校园学生帮扶系统(xga28)_mysql_oracle代码分享

校园学生帮扶系统mysql数据库版本源码：

校园学生帮扶系统oracle数据库版本源码：

校园学生帮扶系统sqlserver数据库版本源码：

校园学生帮扶系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：

校园学生帮扶系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

相关毕业设计源码

评论