- 基于jsp校友信息管理系统的设计与实现mysql数据库创建语句
- 基于jsp校友信息管理系统的设计与实现oracle数据库创建语句
- 基于jsp校友信息管理系统的设计与实现sqlserver数据库创建语句
- 基于jsp校友信息管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于jsp校友信息管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于jsp校友信息管理系统的设计与实现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_banji(
id int primary key auto_increment comment '主键',
banjiName varchar(100) comment '班号',
bjbh varchar(100) comment '班级编号',
fdy varchar(100) comment '辅导员',
bzr varchar(100) comment '班主任'
) comment '班级';
校友活动表创建语句如下：
create table t_huodong(
id int primary key auto_increment comment '主键',
studentId int comment '发起人',
title varchar(100) comment '活动名称',
content varchar(100) comment '内容',
pic varchar(100) comment '图片',
hdsj datetime comment '活动时间',
status varchar(100) comment '状态'
) comment '校友活动';
校友活动人员表创建语句如下：
create table t_huodonglist(
id int primary key auto_increment comment '主键',
huodongId int comment '活动',
studentId int comment '参加人',
insertDate datetime 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
banjiId int 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
banjiId int comment '班级'
) comment '老师';
校园新闻表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '详细内容',
showDate datetime comment '日期'
) comment '校园新闻';
邮件表创建语句如下：
create table t_xiaoxi(
id int primary key auto_increment comment '主键',
studentId int comment '发起人',
toId int comment '接收人',
title varchar(100) comment '消息',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '附件',
insertDate datetime comment '日期'
) comment '邮件';
基于jsp校友信息管理系统的设计与实现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_banji(
id integer,
banjiName varchar(100),
bjbh varchar(100),
fdy varchar(100),
bzr varchar(100)
);
--班级字段加注释
comment on column t_banji.id is '主键';
comment on column t_banji.banjiName is '班号';
comment on column t_banji.bjbh is '班级编号';
comment on column t_banji.fdy is '辅导员';
comment on column t_banji.bzr is '班主任';
--班级表加注释
comment on table t_banji is '班级';
校友活动表创建语句如下：
create table t_huodong(
id integer,
studentId int,
title varchar(100),
content varchar(100),
pic varchar(100),
hdsj datetime,
status varchar(100)
);
--校友活动字段加注释
comment on column t_huodong.id is '主键';
comment on column t_huodong.studentId is '发起人';
comment on column t_huodong.title is '活动名称';
comment on column t_huodong.content is '内容';
comment on column t_huodong.pic is '图片';
comment on column t_huodong.hdsj is '活动时间';
comment on column t_huodong.status is '状态';
--校友活动表加注释
comment on table t_huodong is '校友活动';
校友活动人员表创建语句如下：
create table t_huodonglist(
id integer,
huodongId int,
studentId int,
insertDate datetime
);
--校友活动人员字段加注释
comment on column t_huodonglist.id is '主键';
comment on column t_huodonglist.huodongId is '活动';
comment on column t_huodonglist.studentId is '参加人';
comment on column t_huodonglist.insertDate is '报名时间';
--校友活动人员表加注释
comment on table t_huodonglist is '校友活动人员';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
banjiId int
);
--学生字段加注释
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.headPic 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.banjiId is '班级';
--学生表加注释
comment on table t_student is '学生';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
banjiId int
);
--老师字段加注释
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.headPic 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.banjiId is '班级';
--老师表加注释
comment on table t_teacher is '老师';
校园新闻表创建语句如下：
create table t_tongzhi(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
--校园新闻字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.pic is '图片';
comment on column t_tongzhi.content is '详细内容';
comment on column t_tongzhi.showDate is '日期';
--校园新闻表加注释
comment on table t_tongzhi is '校园新闻';
邮件表创建语句如下：
create table t_xiaoxi(
id integer,
studentId int,
toId int,
title varchar(100),
pic varchar(100),
fileUrl varchar(100),
insertDate datetime
);
--邮件字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.studentId is '发起人';
comment on column t_xiaoxi.toId is '接收人';
comment on column t_xiaoxi.title is '消息';
comment on column t_xiaoxi.pic is '图片';
comment on column t_xiaoxi.fileUrl is '附件';
comment on column t_xiaoxi.insertDate is '日期';
--邮件表加注释
comment on table t_xiaoxi is '邮件';
oracle特有，对应序列如下：
create sequence s_t_banji;
create sequence s_t_huodong;
create sequence s_t_huodonglist;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_tongzhi;
create sequence s_t_xiaoxi;
基于jsp校友信息管理系统的设计与实现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_banji(
id int identity(1,1) primary key not null,--主键
banjiName varchar(100),--班号
bjbh varchar(100),--班级编号
fdy varchar(100),--辅导员
bzr varchar(100)--班主任
);
校友活动表创建语句如下：
--校友活动表注释
create table t_huodong(
id int identity(1,1) primary key not null,--主键
studentId int,--发起人
title varchar(100),--活动名称
content varchar(100),--内容
pic varchar(100),--图片
hdsj datetime,--活动时间
status varchar(100)--状态
);
校友活动人员表创建语句如下：
--校友活动人员表注释
create table t_huodonglist(
id int identity(1,1) primary key not null,--主键
huodongId int,--活动
studentId int,--参加人
insertDate datetime--报名时间
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
banjiId int--班级
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
banjiId int--班级
);
校园新闻表创建语句如下：
--校园新闻表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--详细内容
showDate datetime--日期
);
邮件表创建语句如下：
--邮件表注释
create table t_xiaoxi(
id int identity(1,1) primary key not null,--主键
studentId int,--发起人
toId int,--接收人
title varchar(100),--消息
pic varchar(100),--图片
fileUrl varchar(100),--附件
insertDate datetime--日期
);
登录后主页.jpg?x-oss-process=style/00001)
基于jsp校友信息管理系统的设计与实现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_banji")
public class Banji {
//主键
@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 banjiName;
//班级编号
private String bjbh;
//辅导员
private String fdy;
//班主任
private String bzr;
public String getBanjiName() {return banjiName;}
public void setBanjiName(String banjiName) {this.banjiName = banjiName;}
public String getBjbh() {return bjbh;}
public void setBjbh(String bjbh) {this.bjbh = bjbh;}
public String getFdy() {return fdy;}
public void setFdy(String fdy) {this.fdy = fdy;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}校友活动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_huodong")
public class Huodong {
//主键
@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 title;
//内容
private String content;
//图片
private String pic;
//活动时间
private Date hdsj;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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;}
public Date getHdsj() {return hdsj;}
public void setHdsj(Date hdsj) {this.hdsj = hdsj;}
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_huodonglist")
public class Huodonglist {
//主键
@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 huodongId;
//参加人
private Integer studentId;
//报名时间
private Date insertDate;
public Integer getHuodongId() {return huodongId;}
public void setHuodongId(Integer huodongId) {this.huodongId = huodongId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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_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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//班级
private Integer banjiId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
}老师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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//班级
private Integer banjiId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
}校园新闻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 String title;
//图片
private String pic;
//详细内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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_xiaoxi")
public class Xiaoxi {
//主键
@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 toId;
//消息
private String title;
//图片
private String pic;
//附件
private String fileUrl;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}基于jsp校友信息管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
班级javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级
public class Banji extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班号
private String banjiName;
//班级编号
private String bjbh;
//辅导员
private String fdy;
//班主任
private String bzr;
public String getBanjiName() {return banjiName;}
public void setBanjiName(String banjiName) {this.banjiName = banjiName;}
public String getBjbh() {return bjbh;}
public void setBjbh(String bjbh) {this.bjbh = bjbh;}
public String getFdy() {return fdy;}
public void setFdy(String fdy) {this.fdy = fdy;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}校友活动javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//校友活动
public class Huodong extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发起人
private Integer studentId;
//活动名称
private String title;
//内容
private String content;
//图片
private String pic;
//活动时间
private Date hdsj;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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;}
public Date getHdsj() {return hdsj;}
public void setHdsj(Date hdsj) {this.hdsj = hdsj;}
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 Huodonglist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//活动
private Integer huodongId;
//参加人
private Integer studentId;
//报名时间
private Date insertDate;
public Integer getHuodongId() {return huodongId;}
public void setHuodongId(Integer huodongId) {this.huodongId = huodongId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//班级
private Integer banjiId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
}老师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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//班级
private Integer banjiId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 Integer getBanjiId() {return banjiId;}
public void setBanjiId(Integer banjiId) {this.banjiId = banjiId;}
}校园新闻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 String title;
//图片
private String pic;
//详细内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 Xiaoxi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发起人
private Integer studentId;
//接收人
private Integer toId;
//消息
private String title;
//图片
private String pic;
//附件
private String fileUrl;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}