基于SpringMVC和Spring学生综合考评系统应用,javaweb课程设计

基于SpringMVC和Spring学生综合考评系统应用登录注册界面

基于SpringMVC和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_jxj(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	jxjType varchar(100) comment '奖学金类型',
	jxjje int comment '奖学金金额',
	jxjDay datetime comment '奖学金日期'
) comment '奖学金';

考勤表创建语句如下:


create table t_kq(
	id int primary key auto_increment comment '主键',
	kqFlag varchar(100) comment '考勤类别',
	studentId int comment '学生',
	kqDate datetime comment '考勤日期'
) comment '考勤';

学生日志表创建语句如下:


create table t_rz(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	content varchar(100) comment '日志',
	insertDate datetime comment '日期'
) comment '学生日志';

学生表创建语句如下:


create table t_student(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	studentName varchar(100) comment '姓名',
	yx varchar(100) comment '院系',
	nj varchar(100) comment '年级',
	bj varchar(100) comment '班级',
	phone varchar(100) comment '手机',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	idcard varchar(100) comment '身份证'
) comment '学生';

处分表创建语句如下:


create table t_wj_cf(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	name varchar(100) comment '处分说明',
	content varchar(100) comment '处分内容',
	wjDate datetime comment '违纪日期'
) comment '处分';

违纪申报表创建语句如下:


create table t_wj_sh(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	name varchar(100) comment '申报标题',
	content varchar(100) comment '申报内容',
	sbr varchar(100) comment '申报人',
	wjDate datetime comment '申请日期'
) comment '违纪申报';

违纪申诉表创建语句如下:


create table t_wj_ss(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	name varchar(100) comment '申诉标题',
	content varchar(100) comment '申诉内容',
	ssr varchar(100) comment '申诉人',
	wjDate datetime comment '申诉日期'
) comment '违纪申诉';

基于SpringMVC和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_jxj(
	id integer,
	studentId int,
	jxjType varchar(100),
	jxjje int,
	jxjDay datetime
);
--奖学金字段加注释
comment on column t_jxj.id is '主键';
comment on column t_jxj.studentId is '学生';
comment on column t_jxj.jxjType is '奖学金类型';
comment on column t_jxj.jxjje is '奖学金金额';
comment on column t_jxj.jxjDay is '奖学金日期';
--奖学金表加注释
comment on table t_jxj is '奖学金';

考勤表创建语句如下:


create table t_kq(
	id integer,
	kqFlag varchar(100),
	studentId int,
	kqDate datetime
);
--考勤字段加注释
comment on column t_kq.id is '主键';
comment on column t_kq.kqFlag is '考勤类别';
comment on column t_kq.studentId is '学生';
comment on column t_kq.kqDate is '考勤日期';
--考勤表加注释
comment on table t_kq is '考勤';

学生日志表创建语句如下:


create table t_rz(
	id integer,
	studentId int,
	content varchar(100),
	insertDate datetime
);
--学生日志字段加注释
comment on column t_rz.id is '主键';
comment on column t_rz.studentId is '学生';
comment on column t_rz.content is '日志';
comment on column t_rz.insertDate is '日期';
--学生日志表加注释
comment on table t_rz is '学生日志';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	yx varchar(100),
	nj varchar(100),
	bj varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	idcard 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.yx is '院系';
comment on column t_student.nj is '年级';
comment on column t_student.bj is '班级';
comment on column t_student.phone is '手机';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.idcard is '身份证';
--学生表加注释
comment on table t_student is '学生';

处分表创建语句如下:


create table t_wj_cf(
	id integer,
	studentId int,
	name varchar(100),
	content varchar(100),
	wjDate datetime
);
--处分字段加注释
comment on column t_wj_cf.id is '主键';
comment on column t_wj_cf.studentId is '学生';
comment on column t_wj_cf.name is '处分说明';
comment on column t_wj_cf.content is '处分内容';
comment on column t_wj_cf.wjDate is '违纪日期';
--处分表加注释
comment on table t_wj_cf is '处分';

违纪申报表创建语句如下:


create table t_wj_sh(
	id integer,
	studentId int,
	name varchar(100),
	content varchar(100),
	sbr varchar(100),
	wjDate datetime
);
--违纪申报字段加注释
comment on column t_wj_sh.id is '主键';
comment on column t_wj_sh.studentId is '学生';
comment on column t_wj_sh.name is '申报标题';
comment on column t_wj_sh.content is '申报内容';
comment on column t_wj_sh.sbr is '申报人';
comment on column t_wj_sh.wjDate is '申请日期';
--违纪申报表加注释
comment on table t_wj_sh is '违纪申报';

违纪申诉表创建语句如下:


create table t_wj_ss(
	id integer,
	studentId int,
	name varchar(100),
	content varchar(100),
	ssr varchar(100),
	wjDate datetime
);
--违纪申诉字段加注释
comment on column t_wj_ss.id is '主键';
comment on column t_wj_ss.studentId is '学生';
comment on column t_wj_ss.name is '申诉标题';
comment on column t_wj_ss.content is '申诉内容';
comment on column t_wj_ss.ssr is '申诉人';
comment on column t_wj_ss.wjDate is '申诉日期';
--违纪申诉表加注释
comment on table t_wj_ss is '违纪申诉';

oracle特有,对应序列如下:


create sequence s_t_jxj;
create sequence s_t_kq;
create sequence s_t_rz;
create sequence s_t_student;
create sequence s_t_wj_cf;
create sequence s_t_wj_sh;
create sequence s_t_wj_ss;

基于SpringMVC和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_jxj(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	jxjType varchar(100),--奖学金类型
	jxjje int,--奖学金金额
	jxjDay datetime--奖学金日期
);

考勤表创建语句如下:


--考勤表注释
create table t_kq(
	id int identity(1,1) primary key not null,--主键
	kqFlag varchar(100),--考勤类别
	studentId int,--学生
	kqDate datetime--考勤日期
);

学生日志表创建语句如下:


--学生日志表注释
create table t_rz(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	content varchar(100),--日志
	insertDate datetime--日期
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	yx varchar(100),--院系
	nj varchar(100),--年级
	bj varchar(100),--班级
	phone varchar(100),--手机
	age varchar(100),--年龄
	sex varchar(100),--性别
	idcard varchar(100)--身份证
);

处分表创建语句如下:


--处分表注释
create table t_wj_cf(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	name varchar(100),--处分说明
	content varchar(100),--处分内容
	wjDate datetime--违纪日期
);

违纪申报表创建语句如下:


--违纪申报表注释
create table t_wj_sh(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	name varchar(100),--申报标题
	content varchar(100),--申报内容
	sbr varchar(100),--申报人
	wjDate datetime--申请日期
);

违纪申诉表创建语句如下:


--违纪申诉表注释
create table t_wj_ss(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	name varchar(100),--申诉标题
	content varchar(100),--申诉内容
	ssr varchar(100),--申诉人
	wjDate datetime--申诉日期
);

基于SpringMVC和Spring学生综合考评系统应用登录后主页

基于SpringMVC和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_jxj")
public class Jxj {
//主键
@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 jxjType;
//奖学金金额
private Integer jxjje;
//奖学金日期
private Date jxjDay;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getJxjType() {return jxjType;}
public void setJxjType(String jxjType) {this.jxjType = jxjType;}
public Integer getJxjje() {return jxjje;}
public void setJxjje(Integer jxjje) {this.jxjje = jxjje;}
public Date getJxjDay() {return jxjDay;}
public void setJxjDay(Date jxjDay) {this.jxjDay = jxjDay;}
}

考勤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_kq")
public class Kq {
//主键
@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 kqFlag;
//学生
private Integer studentId;
//考勤日期
private Date kqDate;
public String getKqFlag() {return kqFlag;}
public void setKqFlag(String kqFlag) {this.kqFlag = kqFlag;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getKqDate() {return kqDate;}
public void setKqDate(Date kqDate) {this.kqDate = kqDate;}
}

学生日志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_rz")
public class Rz {
//主键
@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 content;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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_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 yx;
//年级
private String nj;
//班级
private String bj;
//手机
private String phone;
//年龄
private String age;
//性别
private String sex;
//身份证
private String idcard;
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 getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getNj() {return nj;}
public void setNj(String nj) {this.nj = nj;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

处分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_wj_cf")
public class Wj_cf {
//主键
@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 name;
//处分内容
private String content;
//违纪日期
private Date wjDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getWjDate() {return wjDate;}
public void setWjDate(Date wjDate) {this.wjDate = wjDate;}
}

违纪申报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_wj_sh")
public class Wj_sh {
//主键
@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 name;
//申报内容
private String content;
//申报人
private String sbr;
//申请日期
private Date wjDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 String getSbr() {return sbr;}
public void setSbr(String sbr) {this.sbr = sbr;}
public Date getWjDate() {return wjDate;}
public void setWjDate(Date wjDate) {this.wjDate = wjDate;}
}

违纪申诉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_wj_ss")
public class Wj_ss {
//主键
@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 name;
//申诉内容
private String content;
//申诉人
private String ssr;
//申诉日期
private Date wjDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 String getSsr() {return ssr;}
public void setSsr(String ssr) {this.ssr = ssr;}
public Date getWjDate() {return wjDate;}
public void setWjDate(Date wjDate) {this.wjDate = wjDate;}
}

基于SpringMVC和Spring学生综合考评系统应用spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

奖学金javaBean创建语句如下:


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

//奖学金
public class Jxj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//奖学金类型
private String jxjType;
//奖学金金额
private Integer jxjje;
//奖学金日期
private Date jxjDay;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getJxjType() {return jxjType;}
public void setJxjType(String jxjType) {this.jxjType = jxjType;}
public Integer getJxjje() {return jxjje;}
public void setJxjje(Integer jxjje) {this.jxjje = jxjje;}
public Date getJxjDay() {return jxjDay;}
public void setJxjDay(Date jxjDay) {this.jxjDay = jxjDay;}
}

考勤javaBean创建语句如下:


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

//考勤
public class Kq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//考勤类别
private String kqFlag;
//学生
private Integer studentId;
//考勤日期
private Date kqDate;
public String getKqFlag() {return kqFlag;}
public void setKqFlag(String kqFlag) {this.kqFlag = kqFlag;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getKqDate() {return kqDate;}
public void setKqDate(Date kqDate) {this.kqDate = kqDate;}
}

学生日志javaBean创建语句如下:


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

//学生日志
public class Rz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//日志
private String content;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 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 yx;
//年级
private String nj;
//班级
private String bj;
//手机
private String phone;
//年龄
private String age;
//性别
private String sex;
//身份证
private String idcard;
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 getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getNj() {return nj;}
public void setNj(String nj) {this.nj = nj;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

处分javaBean创建语句如下:


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

//处分
public class Wj_cf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//处分说明
private String name;
//处分内容
private String content;
//违纪日期
private Date wjDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getWjDate() {return wjDate;}
public void setWjDate(Date wjDate) {this.wjDate = wjDate;}
}

违纪申报javaBean创建语句如下:


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

//违纪申报
public class Wj_sh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//申报标题
private String name;
//申报内容
private String content;
//申报人
private String sbr;
//申请日期
private Date wjDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 String getSbr() {return sbr;}
public void setSbr(String sbr) {this.sbr = sbr;}
public Date getWjDate() {return wjDate;}
public void setWjDate(Date wjDate) {this.wjDate = wjDate;}
}

违纪申诉javaBean创建语句如下:


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

//违纪申诉
public class Wj_ss  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//申诉标题
private String name;
//申诉内容
private String content;
//申诉人
private String ssr;
//申诉日期
private Date wjDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 String getSsr() {return ssr;}
public void setSsr(String ssr) {this.ssr = ssr;}
public Date getWjDate() {return wjDate;}
public void setWjDate(Date wjDate) {this.wjDate = wjDate;}
}

源代码下载点这里

评论