基于J2EE的课外实训系统

基于J2EE的课外实训系统登录注册界面

基于J2EE的课外实训系统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_bj(
	id int primary key auto_increment comment '主键',
	bjName varchar(100) comment '班级',
	bzr varchar(100) comment '班主任'
) comment '班级';

校内资讯表创建语句如下:


create table t_gg(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '标题',
	showDate datetime comment '日期',
	v3 varchar(100) comment '内容'
) comment '校内资讯';

共享资料表创建语句如下:


create table t_gxzl(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '资料名称',
	v2 varchar(100) comment '资料附件',
	showDate datetime comment '日期'
) comment '共享资料';

留言表创建语句如下:


create table t_ly(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	v1 varchar(100) comment '标题',
	content varchar(100) comment '留言内容',
	insertDate datetime comment '日期',
	back varchar(100) comment '回复内容',
	status varchar(100) 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 '头像',
	xh varchar(100) comment '学号',
	phone varchar(100) comment '电话',
	bjId int comment '班级',
	sxgsId int comment '实训公司'
) comment '学生';

实训报告表创建语句如下:


create table t_sxbg(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	sxgsId int comment '实训公司',
	v1 varchar(100) comment '报告标题',
	content varchar(100) comment '报告内容',
	fj varchar(100) comment '附件',
	insertDate datetime comment '日期',
	back varchar(100) comment '批阅内容',
	status varchar(100) comment '状态'
) comment '实训报告';

实训公司表创建语句如下:


create table t_sxgs(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	sxgsName varchar(100) comment '实训公司名称',
	lxr varchar(100) comment '联系人',
	phone varchar(100) comment '电话',
	v1 varchar(100) comment '实训内容',
	v2 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 '姓名',
	headPic varchar(100) comment '头像',
	xh varchar(100) comment '工号',
	phone varchar(100) comment '电话'
) comment '老师';

通知表创建语句如下:


create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	v1 varchar(100) comment '标题',
	insertDate datetime comment '日期',
	v3 varchar(100) comment '内容'
) comment '通知';

基于J2EE的课外实训系统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_bj(
	id integer,
	bjName varchar(100),
	bzr varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
comment on column t_bj.bzr is '班主任';
--班级表加注释
comment on table t_bj is '班级';

校内资讯表创建语句如下:


create table t_gg(
	id integer,
	v1 varchar(100),
	showDate datetime,
	v3 varchar(100)
);
--校内资讯字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--校内资讯表加注释
comment on table t_gg is '校内资讯';

共享资料表创建语句如下:


create table t_gxzl(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	showDate datetime
);
--共享资料字段加注释
comment on column t_gxzl.id is '主键';
comment on column t_gxzl.v1 is '资料名称';
comment on column t_gxzl.v2 is '资料附件';
comment on column t_gxzl.showDate is '日期';
--共享资料表加注释
comment on table t_gxzl is '共享资料';

留言表创建语句如下:


create table t_ly(
	id integer,
	studentId int,
	v1 varchar(100),
	content varchar(100),
	insertDate datetime,
	back varchar(100),
	status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.studentId is '学生';
comment on column t_ly.v1 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_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	headPic varchar(100),
	xh varchar(100),
	phone varchar(100),
	bjId int,
	sxgsId 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.xh is '学号';
comment on column t_student.phone is '电话';
comment on column t_student.bjId is '班级';
comment on column t_student.sxgsId is '实训公司';
--学生表加注释
comment on table t_student is '学生';

实训报告表创建语句如下:


create table t_sxbg(
	id integer,
	studentId int,
	sxgsId int,
	v1 varchar(100),
	content varchar(100),
	fj varchar(100),
	insertDate datetime,
	back varchar(100),
	status varchar(100)
);
--实训报告字段加注释
comment on column t_sxbg.id is '主键';
comment on column t_sxbg.studentId is '学生';
comment on column t_sxbg.sxgsId is '实训公司';
comment on column t_sxbg.v1 is '报告标题';
comment on column t_sxbg.content is '报告内容';
comment on column t_sxbg.fj is '附件';
comment on column t_sxbg.insertDate is '日期';
comment on column t_sxbg.back is '批阅内容';
comment on column t_sxbg.status is '状态';
--实训报告表加注释
comment on table t_sxbg is '实训报告';

实训公司表创建语句如下:


create table t_sxgs(
	id integer,
	username varchar(100),
	password varchar(100),
	sxgsName varchar(100),
	lxr varchar(100),
	phone varchar(100),
	v1 varchar(100),
	v2 varchar(100)
);
--实训公司字段加注释
comment on column t_sxgs.id is '主键';
comment on column t_sxgs.username is '账号';
comment on column t_sxgs.password is '密码';
comment on column t_sxgs.sxgsName is '实训公司名称';
comment on column t_sxgs.lxr is '联系人';
comment on column t_sxgs.phone is '电话';
comment on column t_sxgs.v1 is '实训内容';
comment on column t_sxgs.v2 is '规章制度';
--实训公司表加注释
comment on table t_sxgs is '实训公司';

老师表创建语句如下:


create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	headPic varchar(100),
	xh varchar(100),
	phone 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.headPic is '头像';
comment on column t_teacher.xh is '工号';
comment on column t_teacher.phone is '电话';
--老师表加注释
comment on table t_teacher is '老师';

通知表创建语句如下:


create table t_tongzhi(
	id integer,
	studentId int,
	v1 varchar(100),
	insertDate datetime,
	v3 varchar(100)
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.studentId is '学生';
comment on column t_tongzhi.v1 is '标题';
comment on column t_tongzhi.insertDate is '日期';
comment on column t_tongzhi.v3 is '内容';
--通知表加注释
comment on table t_tongzhi is '通知';

oracle特有,对应序列如下:


create sequence s_t_bj;
create sequence s_t_gg;
create sequence s_t_gxzl;
create sequence s_t_ly;
create sequence s_t_student;
create sequence s_t_sxbg;
create sequence s_t_sxgs;
create sequence s_t_teacher;
create sequence s_t_tongzhi;

基于J2EE的课外实训系统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_bj(
	id int identity(1,1) primary key not null,--主键
	bjName varchar(100),--班级
	bzr varchar(100)--班主任
);

校内资讯表创建语句如下:


--校内资讯表注释
create table t_gg(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--标题
	showDate datetime,--日期
	v3 varchar(100)--内容
);

共享资料表创建语句如下:


--共享资料表注释
create table t_gxzl(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--资料名称
	v2 varchar(100),--资料附件
	showDate datetime--日期
);

留言表创建语句如下:


--留言表注释
create table t_ly(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	v1 varchar(100),--标题
	content varchar(100),--留言内容
	insertDate datetime,--日期
	back varchar(100),--回复内容
	status varchar(100)--状态
);

学生表创建语句如下:


--学生表注释
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),--头像
	xh varchar(100),--学号
	phone varchar(100),--电话
	bjId int,--班级
	sxgsId int--实训公司
);

实训报告表创建语句如下:


--实训报告表注释
create table t_sxbg(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	sxgsId int,--实训公司
	v1 varchar(100),--报告标题
	content varchar(100),--报告内容
	fj varchar(100),--附件
	insertDate datetime,--日期
	back varchar(100),--批阅内容
	status varchar(100)--状态
);

实训公司表创建语句如下:


--实训公司表注释
create table t_sxgs(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	sxgsName varchar(100),--实训公司名称
	lxr varchar(100),--联系人
	phone varchar(100),--电话
	v1 varchar(100),--实训内容
	v2 varchar(100)--规章制度
);

老师表创建语句如下:


--老师表注释
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),--头像
	xh varchar(100),--工号
	phone varchar(100)--电话
);

通知表创建语句如下:


--通知表注释
create table t_tongzhi(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	v1 varchar(100),--标题
	insertDate datetime,--日期
	v3 varchar(100)--内容
);

基于J2EE的课外实训系统登录后主页

基于J2EE的课外实训系统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_bj")
public class Bj {
//主键
@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 bjName;
//班主任
private String bzr;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
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_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 v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

共享资料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_gxzl")
public class Gxzl {
//主键
@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 v1;
//资料附件
private String v2;
//日期
private Date showDate;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
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_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 Integer studentId;
//标题
private String v1;
//留言内容
private String content;
//日期
private Date insertDate;
//回复内容
private String back;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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_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 xh;
//电话
private String phone;
//班级
private Integer bjId;
//实训公司
private Integer sxgsId;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getSxgsId() {return sxgsId;}
public void setSxgsId(Integer sxgsId) {this.sxgsId = sxgsId;}
}

实训报告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_sxbg")
public class Sxbg {
//主键
@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 sxgsId;
//报告标题
private String v1;
//报告内容
private String content;
//附件
private String fj;
//日期
private Date insertDate;
//批阅内容
private String back;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getSxgsId() {return sxgsId;}
public void setSxgsId(Integer sxgsId) {this.sxgsId = sxgsId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
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_sxgs")
public class Sxgs {
//主键
@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 sxgsName;
//联系人
private String lxr;
//电话
private String phone;
//实训内容
private String v1;
//规章制度
private String v2;
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 getSxgsName() {return sxgsName;}
public void setSxgsName(String sxgsName) {this.sxgsName = sxgsName;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

老师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 xh;
//电话
private String phone;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

通知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 Integer studentId;
//标题
private String v1;
//日期
private Date insertDate;
//内容
private String v3;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

基于J2EE的课外实训系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

班级javaBean创建语句如下:


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

//班级
public class Bj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private String bjName;
//班主任
private String bzr;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
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 Gg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

共享资料javaBean创建语句如下:


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

//共享资料
public class Gxzl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资料名称
private String v1;
//资料附件
private String v2;
//日期
private Date showDate;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
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 Ly  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//标题
private String v1;
//留言内容
private String content;
//日期
private Date insertDate;
//回复内容
private String back;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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 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 xh;
//电话
private String phone;
//班级
private Integer bjId;
//实训公司
private Integer sxgsId;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getSxgsId() {return sxgsId;}
public void setSxgsId(Integer sxgsId) {this.sxgsId = sxgsId;}
}

实训报告javaBean创建语句如下:


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

//实训报告
public class Sxbg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//实训公司
private Integer sxgsId;
//报告标题
private String v1;
//报告内容
private String content;
//附件
private String fj;
//日期
private Date insertDate;
//批阅内容
private String back;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getSxgsId() {return sxgsId;}
public void setSxgsId(Integer sxgsId) {this.sxgsId = sxgsId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
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 Sxgs  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 sxgsName;
//联系人
private String lxr;
//电话
private String phone;
//实训内容
private String v1;
//规章制度
private String v2;
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 getSxgsName() {return sxgsName;}
public void setSxgsName(String sxgsName) {this.sxgsName = sxgsName;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

老师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 xh;
//电话
private String phone;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

通知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 Integer studentId;
//标题
private String v1;
//日期
private Date insertDate;
//内容
private String v3;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

评论