基于spring的自动阅卷系统

基于spring的自动阅卷系统登录注册界面

基于spring的自动阅卷系统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_sj(
	id int primary key auto_increment comment '主键',
	xh varchar(100) comment '学号',
	xm varchar(100) comment '姓名',
	bj varchar(100) comment '班级',
	sj varchar(100) comment '试卷',
	cj int comment '成绩'
) comment '试卷';

题目表创建语句如下:


create table t_tk(
	id int primary key auto_increment comment '主键',
	types varchar(100) comment '类型',
	bh varchar(100) comment '题目编号',
	content varchar(100) comment '题目内容',
	da varchar(100) comment '答案',
	fs int comment '分数'
) comment '题目';

自动阅卷记录表创建语句如下:


create table t_yj(
	id int primary key auto_increment comment '主键',
	num int comment '试卷数量',
	ys int comment '用时(秒)'
) comment '自动阅卷记录';

基于spring的自动阅卷系统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_sj(
	id integer,
	xh varchar(100),
	xm varchar(100),
	bj varchar(100),
	sj varchar(100),
	cj int
);
--试卷字段加注释
comment on column t_sj.id is '主键';
comment on column t_sj.xh is '学号';
comment on column t_sj.xm is '姓名';
comment on column t_sj.bj is '班级';
comment on column t_sj.sj is '试卷';
comment on column t_sj.cj is '成绩';
--试卷表加注释
comment on table t_sj is '试卷';

题目表创建语句如下:


create table t_tk(
	id integer,
	types varchar(100),
	bh varchar(100),
	content varchar(100),
	da varchar(100),
	fs int
);
--题目字段加注释
comment on column t_tk.id is '主键';
comment on column t_tk.types is '类型';
comment on column t_tk.bh is '题目编号';
comment on column t_tk.content is '题目内容';
comment on column t_tk.da is '答案';
comment on column t_tk.fs is '分数';
--题目表加注释
comment on table t_tk is '题目';

自动阅卷记录表创建语句如下:


create table t_yj(
	id integer,
	num int,
	ys int
);
--自动阅卷记录字段加注释
comment on column t_yj.id is '主键';
comment on column t_yj.num is '试卷数量';
comment on column t_yj.ys is '用时(秒)';
--自动阅卷记录表加注释
comment on table t_yj is '自动阅卷记录';

oracle特有,对应序列如下:


create sequence s_t_sj;
create sequence s_t_tk;
create sequence s_t_yj;

基于spring的自动阅卷系统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_sj(
	id int identity(1,1) primary key not null,--主键
	xh varchar(100),--学号
	xm varchar(100),--姓名
	bj varchar(100),--班级
	sj varchar(100),--试卷
	cj int--成绩
);

题目表创建语句如下:


--题目表注释
create table t_tk(
	id int identity(1,1) primary key not null,--主键
	types varchar(100),--类型
	bh varchar(100),--题目编号
	content varchar(100),--题目内容
	da varchar(100),--答案
	fs int--分数
);

自动阅卷记录表创建语句如下:


--自动阅卷记录表注释
create table t_yj(
	id int identity(1,1) primary key not null,--主键
	num int,--试卷数量
	ys int--用时(秒)
);

基于spring的自动阅卷系统登录后主页

基于spring的自动阅卷系统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_sj")
public class Sj {
//主键
@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 xh;
//姓名
private String xm;
//班级
private String bj;
//试卷
private String sj;
//成绩
private Integer cj;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getSj() {return sj;}
public void setSj(String sj) {this.sj = sj;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
}

题目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_tk")
public class Tk {
//主键
@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 types;
//题目编号
private String bh;
//题目内容
private String content;
//答案
private String da;
//分数
private Integer fs;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getDa() {return da;}
public void setDa(String da) {this.da = da;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
}

自动阅卷记录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_yj")
public class Yj {
//主键
@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 num;
//用时(秒)
private Integer ys;
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getYs() {return ys;}
public void setYs(Integer ys) {this.ys = ys;}
}

基于spring的自动阅卷系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

试卷javaBean创建语句如下:


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

//试卷
public class Sj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学号
private String xh;
//姓名
private String xm;
//班级
private String bj;
//试卷
private String sj;
//成绩
private Integer cj;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getSj() {return sj;}
public void setSj(String sj) {this.sj = sj;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
}

题目javaBean创建语句如下:


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

//题目
public class Tk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String types;
//题目编号
private String bh;
//题目内容
private String content;
//答案
private String da;
//分数
private Integer fs;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getDa() {return da;}
public void setDa(String da) {this.da = da;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
}

自动阅卷记录javaBean创建语句如下:


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

//自动阅卷记录
public class Yj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//试卷数量
private Integer num;
//用时(秒)
private Integer ys;
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getYs() {return ys;}
public void setYs(Integer ys) {this.ys = ys;}
}

源代码下载点这里

评论