课程资料管理系统(xga33)_mysql_oracle代码分享

• 课程资料管理系统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_bkzl(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '资料标题',
	fileUrl varchar(100) comment '附件',
	insertDate datetime comment '发布日期',
	content text comment '资料内容',
	status varchar(100) comment '状态',
	teacherId int 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_kczl(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '资料标题',
	fileUrl varchar(100) comment '附件',
	insertDate datetime comment '发布日期',
	content text comment '资料内容',
	status varchar(100) comment '状态',
	teacherId int comment '发布老师',
	back text comment '审核意见'
) comment '课程资料';

考试资料表创建语句如下：

create table t_kszl(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '资料标题',
	fileUrl varchar(100) comment '附件',
	insertDate datetime comment '发布日期',
	content text comment '资料内容',
	status varchar(100) comment '状态',
	teacherId int comment '发布老师',
	back text comment '审核意见'
) comment '考试资料';

留言表创建语句如下：

create table t_ly(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	content text comment '内容',
	insertDate datetime comment '发起日期',
	back text comment '回复',
	status varchar(100) comment '状态'
) comment '留言';

实验资料表创建语句如下：

create table t_syzl(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '资料标题',
	fileUrl varchar(100) comment '附件',
	insertDate datetime comment '发布日期',
	content text comment '资料内容',
	status varchar(100) comment '状态',
	teacherId int comment '发布老师',
	back text 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 '姓名',
	pic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '',
	zc varchar(100) comment '职称',
	zy 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_bkzl(
	id integer,
	title varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	content text,
	status varchar(100),
	teacherId int,
	back text
);
--补考资料字段加注释
comment on column t_bkzl.id is '主键';
comment on column t_bkzl.title is '资料标题';
comment on column t_bkzl.fileUrl is '附件';
comment on column t_bkzl.insertDate is '发布日期';
comment on column t_bkzl.content is '资料内容';
comment on column t_bkzl.status is '状态';
comment on column t_bkzl.teacherId is '发布老师';
comment on column t_bkzl.back is '审核意见';
--补考资料表加注释
comment on table t_bkzl 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_kczl(
	id integer,
	title varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	content text,
	status varchar(100),
	teacherId int,
	back text
);
--课程资料字段加注释
comment on column t_kczl.id is '主键';
comment on column t_kczl.title is '资料标题';
comment on column t_kczl.fileUrl is '附件';
comment on column t_kczl.insertDate is '发布日期';
comment on column t_kczl.content is '资料内容';
comment on column t_kczl.status is '状态';
comment on column t_kczl.teacherId is '发布老师';
comment on column t_kczl.back is '审核意见';
--课程资料表加注释
comment on table t_kczl is '课程资料';

考试资料表创建语句如下：

create table t_kszl(
	id integer,
	title varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	content text,
	status varchar(100),
	teacherId int,
	back text
);
--考试资料字段加注释
comment on column t_kszl.id is '主键';
comment on column t_kszl.title is '资料标题';
comment on column t_kszl.fileUrl is '附件';
comment on column t_kszl.insertDate is '发布日期';
comment on column t_kszl.content is '资料内容';
comment on column t_kszl.status is '状态';
comment on column t_kszl.teacherId is '发布老师';
comment on column t_kszl.back is '审核意见';
--考试资料表加注释
comment on table t_kszl is '考试资料';

留言表创建语句如下：

create table t_ly(
	id integer,
	teacherId int,
	content text,
	insertDate datetime,
	back text,
	status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.teacherId is '老师';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';

实验资料表创建语句如下：

create table t_syzl(
	id integer,
	title varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	content text,
	status varchar(100),
	teacherId int,
	back text
);
--实验资料字段加注释
comment on column t_syzl.id is '主键';
comment on column t_syzl.title is '资料标题';
comment on column t_syzl.fileUrl is '附件';
comment on column t_syzl.insertDate is '发布日期';
comment on column t_syzl.content is '资料内容';
comment on column t_syzl.status is '状态';
comment on column t_syzl.teacherId is '发布老师';
comment on column t_syzl.back is '审核意见';
--实验资料表加注释
comment on table t_syzl is '实验资料';

老师表创建语句如下：

create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	pic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	zc varchar(100),
	zy 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.pic 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.zc is '职称';
comment on column t_teacher.zy is '专业';
--老师表加注释
comment on table t_teacher is '老师';

oracle特有，对应序列如下：

create sequence s_t_bkzl;
create sequence s_t_gonggao;
create sequence s_t_kczl;
create sequence s_t_kszl;
create sequence s_t_ly;
create sequence s_t_syzl;
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_bkzl(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--资料标题
	fileUrl varchar(100),--附件
	insertDate datetime,--发布日期
	content text,--资料内容
	status varchar(100),--状态
	teacherId int,--发布老师
	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_kczl(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--资料标题
	fileUrl varchar(100),--附件
	insertDate datetime,--发布日期
	content text,--资料内容
	status varchar(100),--状态
	teacherId int,--发布老师
	back text--审核意见
);

考试资料表创建语句如下：

--考试资料表注释
create table t_kszl(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--资料标题
	fileUrl varchar(100),--附件
	insertDate datetime,--发布日期
	content text,--资料内容
	status varchar(100),--状态
	teacherId int,--发布老师
	back text--审核意见
);

留言表创建语句如下：

--留言表注释
create table t_ly(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	content text,--内容
	insertDate datetime,--发起日期
	back text,--回复
	status varchar(100)--状态
);

实验资料表创建语句如下：

--实验资料表注释
create table t_syzl(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--资料标题
	fileUrl varchar(100),--附件
	insertDate datetime,--发布日期
	content text,--资料内容
	status varchar(100),--状态
	teacherId int,--发布老师
	back text--审核意见
);

老师表创建语句如下：

--老师表注释
create table t_teacher(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	teacherName varchar(100),--姓名
	pic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--
	zc varchar(100),--职称
	zy 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_bkzl")
public class Bkzl {
//主键
@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 fileUrl;
//发布日期
private Date insertDate;
//资料内容
private String content;
//状态
private String status;
//发布老师
private Long teacherId;
//审核意见
private String back;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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_kczl")
public class Kczl {
//主键
@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 fileUrl;
//发布日期
private Date insertDate;
//资料内容
private String content;
//状态
private String status;
//发布老师
private Long teacherId;
//审核意见
private String back;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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_kszl")
public class Kszl {
//主键
@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 fileUrl;
//发布日期
private Date insertDate;
//资料内容
private String content;
//状态
private String status;
//发布老师
private Long teacherId;
//审核意见
private String back;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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_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 teacherId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

实验资料javaBean创建语句如下：

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

//实验资料
@Table(name = "t_syzl")
public class Syzl {
//主键
@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 fileUrl;
//发布日期
private Date insertDate;
//资料内容
private String content;
//状态
private String status;
//发布老师
private Long teacherId;
//审核意见
private String back;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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_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 pic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//职称
private String zc;
//专业
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}

课程资料管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

补考资料javaBean创建语句如下：

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

//补考资料
public class Bkzl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资料标题
private String title;
//附件
private String fileUrl;
//发布日期
private Date insertDate;
//资料内容
private String content;
//状态
private String status;
//发布老师
private Long teacherId;
//审核意见
private String back;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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 Kczl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资料标题
private String title;
//附件
private String fileUrl;
//发布日期
private Date insertDate;
//资料内容
private String content;
//状态
private String status;
//发布老师
private Long teacherId;
//审核意见
private String back;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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 Kszl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资料标题
private String title;
//附件
private String fileUrl;
//发布日期
private Date insertDate;
//资料内容
private String content;
//状态
private String status;
//发布老师
private Long teacherId;
//审核意见
private String back;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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 Ly  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

实验资料javaBean创建语句如下：

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

//实验资料
public class Syzl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资料标题
private String title;
//附件
private String fileUrl;
//发布日期
private Date insertDate;
//资料内容
private String content;
//状态
private String status;
//发布老师
private Long teacherId;
//审核意见
private String back;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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 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 pic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//职称
private String zc;
//专业
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}