计算机专业课程实验过程管理平台

计算机专业课程实验过程管理平台登录注册界面

计算机专业课程实验过程管理平台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 '班级'
) comment '班级';

教师资料表创建语句如下:


create table t_jszl(
	id int primary key auto_increment comment '主键',
	jszlName varchar(100) comment '资料名称',
	fileUrl varchar(100) comment '文件',
	insertDate datetime comment '上传日期',
	types varchar(100) comment '类型',
	remark varchar(100) comment '备注'
) comment '教师资料';

课程表创建语句如下:


create table t_kc(
	id int primary key auto_increment comment '主键',
	kcName varchar(100) comment '课程名称',
	ls varchar(100) comment '任课老师',
	showDate datetime comment '上课日期',
	address varchar(100) comment '地点',
	remark varchar(100) comment '备注'
) comment '课程';

老师发布作业表创建语句如下:


create table t_lszy(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '作业名称',
	content varchar(100) comment '作业内容',
	fileUrl varchar(100) comment '文件',
	showDate datetime comment '日期'
) comment '老师发布作业';

帖子表创建语句如下:


create table t_luntan(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '描述'
) comment '帖子';

评论表创建语句如下:


create table t_pinglun(
	id int primary key auto_increment comment '主键',
	name varchar(100) comment '姓名',
	content varchar(100) comment '内容',
	insertDate datetime comment '日期',
	luntanId int comment '帖子'
) comment '评论';

普通管理员表创建语句如下:


create table t_ptadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	ptadminName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone 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 '姓名',
	bjId int comment '班级',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	qq varchar(100) comment 'QQ',
	email varchar(100) comment '邮箱',
	pic varchar(100) comment '头像'
) comment '学生';

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


create table t_sybg(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	sybgName varchar(100) comment '报告名称',
	fileUrl varchar(100) comment '文件',
	insertDate datetime comment '上传日期',
	remark varchar(100) comment '备注',
	fs int comment '分数',
	status varchar(100) comment '状态'
) comment '实验报告';

实验室考勤表创建语句如下:


create table t_syskq(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	sysName varchar(100) comment '实验室名称',
	insertDate datetime comment '考勤日期',
	remark varchar(100) comment '备注',
	status 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像'
) comment '老师';

作业表创建语句如下:


create table t_zy(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	zyName varchar(100) comment '作业名称',
	fileUrl varchar(100) comment '文件',
	insertDate datetime comment '上传日期',
	remark varchar(100) comment '备注',
	fs int comment '分数',
	status varchar(100) comment '状态',
	pgDate datetime 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_bj(
	id integer,
	bjName varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
--班级表加注释
comment on table t_bj is '班级';

教师资料表创建语句如下:


create table t_jszl(
	id integer,
	jszlName varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	types varchar(100),
	remark varchar(100)
);
--教师资料字段加注释
comment on column t_jszl.id is '主键';
comment on column t_jszl.jszlName is '资料名称';
comment on column t_jszl.fileUrl is '文件';
comment on column t_jszl.insertDate is '上传日期';
comment on column t_jszl.types is '类型';
comment on column t_jszl.remark is '备注';
--教师资料表加注释
comment on table t_jszl is '教师资料';

课程表创建语句如下:


create table t_kc(
	id integer,
	kcName varchar(100),
	ls varchar(100),
	showDate datetime,
	address varchar(100),
	remark varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.ls is '任课老师';
comment on column t_kc.showDate is '上课日期';
comment on column t_kc.address is '地点';
comment on column t_kc.remark is '备注';
--课程表加注释
comment on table t_kc is '课程';

老师发布作业表创建语句如下:


create table t_lszy(
	id integer,
	title varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	showDate datetime
);
--老师发布作业字段加注释
comment on column t_lszy.id is '主键';
comment on column t_lszy.title is '作业名称';
comment on column t_lszy.content is '作业内容';
comment on column t_lszy.fileUrl is '文件';
comment on column t_lszy.showDate is '日期';
--老师发布作业表加注释
comment on table t_lszy is '老师发布作业';

帖子表创建语句如下:


create table t_luntan(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100)
);
--帖子字段加注释
comment on column t_luntan.id is '主键';
comment on column t_luntan.title is '标题';
comment on column t_luntan.pic is '图片';
comment on column t_luntan.content is '描述';
--帖子表加注释
comment on table t_luntan is '帖子';

评论表创建语句如下:


create table t_pinglun(
	id integer,
	name varchar(100),
	content varchar(100),
	insertDate datetime,
	luntanId int
);
--评论字段加注释
comment on column t_pinglun.id is '主键';
comment on column t_pinglun.name is '姓名';
comment on column t_pinglun.content is '内容';
comment on column t_pinglun.insertDate is '日期';
comment on column t_pinglun.luntanId is '帖子';
--评论表加注释
comment on table t_pinglun is '评论';

普通管理员表创建语句如下:


create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码 ';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
comment on column t_ptadmin.phone is '电话';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	bjId int,
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	qq varchar(100),
	email varchar(100),
	pic 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.bjId is '班级';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.qq is 'QQ';
comment on column t_student.email is '邮箱';
comment on column t_student.pic is '头像';
--学生表加注释
comment on table t_student is '学生';

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


create table t_sybg(
	id integer,
	studentId int,
	sybgName varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	remark varchar(100),
	fs int,
	status varchar(100)
);
--实验报告字段加注释
comment on column t_sybg.id is '主键';
comment on column t_sybg.studentId is '学生';
comment on column t_sybg.sybgName is '报告名称';
comment on column t_sybg.fileUrl is '文件';
comment on column t_sybg.insertDate is '上传日期';
comment on column t_sybg.remark is '备注';
comment on column t_sybg.fs is '分数';
comment on column t_sybg.status is '状态';
--实验报告表加注释
comment on table t_sybg is '实验报告';

实验室考勤表创建语句如下:


create table t_syskq(
	id integer,
	studentId int,
	sysName varchar(100),
	insertDate datetime,
	remark varchar(100),
	status varchar(100)
);
--实验室考勤字段加注释
comment on column t_syskq.id is '主键';
comment on column t_syskq.studentId is '学生';
comment on column t_syskq.sysName is '实验室名称';
comment on column t_syskq.insertDate is '考勤日期';
comment on column t_syskq.remark is '备注';
comment on column t_syskq.status is '状态';
--实验室考勤表加注释
comment on table t_syskq is '实验室考勤';

老师表创建语句如下:


create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic 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.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.pic is '头像';
--老师表加注释
comment on table t_teacher is '老师';

作业表创建语句如下:


create table t_zy(
	id integer,
	studentId int,
	zyName varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	remark varchar(100),
	fs int,
	status varchar(100),
	pgDate datetime
);
--作业字段加注释
comment on column t_zy.id is '主键';
comment on column t_zy.studentId is '学生';
comment on column t_zy.zyName is '作业名称';
comment on column t_zy.fileUrl is '文件';
comment on column t_zy.insertDate is '上传日期';
comment on column t_zy.remark is '备注';
comment on column t_zy.fs is '分数';
comment on column t_zy.status is '状态';
comment on column t_zy.pgDate is '';
--作业表加注释
comment on table t_zy is '作业';

oracle特有,对应序列如下:


create sequence s_t_bj;
create sequence s_t_jszl;
create sequence s_t_kc;
create sequence s_t_lszy;
create sequence s_t_luntan;
create sequence s_t_pinglun;
create sequence s_t_ptadmin;
create sequence s_t_student;
create sequence s_t_sybg;
create sequence s_t_syskq;
create sequence s_t_teacher;
create sequence s_t_zy;

计算机专业课程实验过程管理平台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)--班级
);

教师资料表创建语句如下:


--教师资料表注释
create table t_jszl(
	id int identity(1,1) primary key not null,--主键
	jszlName varchar(100),--资料名称
	fileUrl varchar(100),--文件
	insertDate datetime,--上传日期
	types varchar(100),--类型
	remark varchar(100)--备注
);

课程表创建语句如下:


--课程表注释
create table t_kc(
	id int identity(1,1) primary key not null,--主键
	kcName varchar(100),--课程名称
	ls varchar(100),--任课老师
	showDate datetime,--上课日期
	address varchar(100),--地点
	remark varchar(100)--备注
);

老师发布作业表创建语句如下:


--老师发布作业表注释
create table t_lszy(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--作业名称
	content varchar(100),--作业内容
	fileUrl varchar(100),--文件
	showDate datetime--日期
);

帖子表创建语句如下:


--帖子表注释
create table t_luntan(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100)--描述
);

评论表创建语句如下:


--评论表注释
create table t_pinglun(
	id int identity(1,1) primary key not null,--主键
	name varchar(100),--姓名
	content varchar(100),--内容
	insertDate datetime,--日期
	luntanId int--帖子
);

普通管理员表创建语句如下:


--普通管理员表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	ptadminName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	studentName varchar(100),--姓名
	bjId int,--班级
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	qq varchar(100),--QQ
	email varchar(100),--邮箱
	pic varchar(100)--头像
);

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


--实验报告表注释
create table t_sybg(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	sybgName varchar(100),--报告名称
	fileUrl varchar(100),--文件
	insertDate datetime,--上传日期
	remark varchar(100),--备注
	fs int,--分数
	status varchar(100)--状态
);

实验室考勤表创建语句如下:


--实验室考勤表注释
create table t_syskq(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	sysName varchar(100),--实验室名称
	insertDate datetime,--考勤日期
	remark varchar(100),--备注
	status varchar(100)--状态
);

老师表创建语句如下:


--老师表注释
create table t_teacher(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	teacherName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100)--头像
);

作业表创建语句如下:


--作业表注释
create table t_zy(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	zyName varchar(100),--作业名称
	fileUrl varchar(100),--文件
	insertDate datetime,--上传日期
	remark varchar(100),--备注
	fs int,--分数
	status varchar(100),--状态
	pgDate datetime--
);

计算机专业课程实验过程管理平台登录后主页

计算机专业课程实验过程管理平台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;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}

教师资料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_jszl")
public class Jszl {
//主键
@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 jszlName;
//文件
private String fileUrl;
//上传日期
private Date insertDate;
//类型
private String types;
//备注
private String remark;
public String getJszlName() {return jszlName;}
public void setJszlName(String jszlName) {this.jszlName = jszlName;}
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 getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

课程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_kc")
public class Kc {
//主键
@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 kcName;
//任课老师
private String ls;
//上课日期
private Date showDate;
//地点
private String address;
//备注
private String remark;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getLs() {return ls;}
public void setLs(String ls) {this.ls = ls;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

老师发布作业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_lszy")
public class Lszy {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//作业名称
private String title;
//作业内容
private String content;
//文件
private String fileUrl;
//日期
private Date showDate;
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_luntan")
public class Luntan {
//主键
@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;
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;}
}

评论javaBean创建语句如下:


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

//评论
@Table(name = "t_pinglun")
public class Pinglun {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String name;
//内容
private String content;
//日期
private Date insertDate;
//帖子
private Integer luntanId;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 Integer getLuntanId() {return luntanId;}
public void setLuntanId(Integer luntanId) {this.luntanId = luntanId;}
}

普通管理员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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 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_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 Integer bjId;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//QQ
private String qq;
//邮箱
private String email;
//头像
private String pic;
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

实验报告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_sybg")
public class Sybg {
//主键
@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 sybgName;
//文件
private String fileUrl;
//上传日期
private Date insertDate;
//备注
private String remark;
//分数
private Integer fs;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getSybgName() {return sybgName;}
public void setSybgName(String sybgName) {this.sybgName = sybgName;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
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_syskq")
public class Syskq {
//主键
@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 sysName;
//考勤日期
private Date insertDate;
//备注
private String remark;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_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 age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

作业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_zy")
public class Zy {
//主键
@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 zyName;
//文件
private String fileUrl;
//上传日期
private Date insertDate;
//备注
private String remark;
//分数
private Integer fs;
//状态
private String status;
//
private Date pgDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getPgDate() {return pgDate;}
public void setPgDate(Date pgDate) {this.pgDate = pgDate;}
}

计算机专业课程实验过程管理平台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;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}

教师资料javaBean创建语句如下:


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

//教师资料
public class Jszl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资料名称
private String jszlName;
//文件
private String fileUrl;
//上传日期
private Date insertDate;
//类型
private String types;
//备注
private String remark;
public String getJszlName() {return jszlName;}
public void setJszlName(String jszlName) {this.jszlName = jszlName;}
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 getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

课程javaBean创建语句如下:


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

//课程
public class Kc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程名称
private String kcName;
//任课老师
private String ls;
//上课日期
private Date showDate;
//地点
private String address;
//备注
private String remark;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getLs() {return ls;}
public void setLs(String ls) {this.ls = ls;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

老师发布作业javaBean创建语句如下:


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

//老师发布作业
public class Lszy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//作业名称
private String title;
//作业内容
private String content;
//文件
private String fileUrl;
//日期
private Date showDate;
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Luntan  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;
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;}
}

评论javaBean创建语句如下:


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

//评论
public class Pinglun  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String name;
//内容
private String content;
//日期
private Date insertDate;
//帖子
private Integer luntanId;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 Integer getLuntanId() {return luntanId;}
public void setLuntanId(Integer luntanId) {this.luntanId = luntanId;}
}

普通管理员javaBean创建语句如下:


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

//普通管理员
public class Ptadmin  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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 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 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 Integer bjId;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//QQ
private String qq;
//邮箱
private String email;
//头像
private String pic;
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

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


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

//实验报告
public class Sybg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//报告名称
private String sybgName;
//文件
private String fileUrl;
//上传日期
private Date insertDate;
//备注
private String remark;
//分数
private Integer fs;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getSybgName() {return sybgName;}
public void setSybgName(String sybgName) {this.sybgName = sybgName;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
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 Syskq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//实验室名称
private String sysName;
//考勤日期
private Date insertDate;
//备注
private String remark;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 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 age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

作业javaBean创建语句如下:


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

//作业
public class Zy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//作业名称
private String zyName;
//文件
private String fileUrl;
//上传日期
private Date insertDate;
//备注
private String remark;
//分数
private Integer fs;
//状态
private String status;
//
private Date pgDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getPgDate() {return pgDate;}
public void setPgDate(Date pgDate) {this.pgDate = pgDate;}
}

评论