基于SpringMVC和Hibernate的教材管理子系统的开发,基于java的毕业设计

基于SpringMVC和Hibernate的教材管理子系统的开发登录注册界面

基于SpringMVC和Hibernate的教材管理子系统的开发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_cgjh(
	id int primary key auto_increment comment '主键',
	jcId int comment '教材',
	num int comment '数量',
	cgjhDate varchar(100) comment '采购日期'
) comment '采购计划';

教材表创建语句如下:


create table t_jc(
	id int primary key auto_increment comment '主键',
	jcName varchar(100) comment '教材名称',
	jcBh varchar(100) comment '教材编号',
	jg int comment '价格',
	kc int comment '库存'
) comment '教材';

教材报损表创建语句如下:


create table t_jcbs(
	id int primary key auto_increment comment '主键',
	jcId int comment '教材',
	bsNum int comment '数量',
	bz varchar(100) comment '备注'
) comment '教材报损';

学生领书表创建语句如下:


create table t_stubook(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	num int comment '数量',
	jcId int comment '教材',
	lsDate 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 '姓名',
	xb 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 '老师姓名'
) comment '老师';

老师领书表创建语句如下:


create table t_tecbook(
	id int primary key auto_increment comment '主键',
	teacherId varchar(100) comment '老师',
	num int comment '数量',
	jcId int comment '教材',
	lsDate varchar(100) comment '领书日期'
) comment '老师领书';

推荐教材表创建语句如下:


create table t_tjjc(
	id int primary key auto_increment comment '主键',
	jcId int comment '教材',
	xb varchar(100) comment '系别'
) comment '推荐教材';

基于SpringMVC和Hibernate的教材管理子系统的开发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_cgjh(
	id integer,
	jcId int,
	num int,
	cgjhDate varchar(100)
);
--采购计划字段加注释
comment on column t_cgjh.id is '主键';
comment on column t_cgjh.jcId is '教材';
comment on column t_cgjh.num is '数量';
comment on column t_cgjh.cgjhDate is '采购日期';
--采购计划表加注释
comment on table t_cgjh is '采购计划';

教材表创建语句如下:


create table t_jc(
	id integer,
	jcName varchar(100),
	jcBh varchar(100),
	jg int,
	kc int
);
--教材字段加注释
comment on column t_jc.id is '主键';
comment on column t_jc.jcName is '教材名称';
comment on column t_jc.jcBh is '教材编号';
comment on column t_jc.jg is '价格';
comment on column t_jc.kc is '库存';
--教材表加注释
comment on table t_jc is '教材';

教材报损表创建语句如下:


create table t_jcbs(
	id integer,
	jcId int,
	bsNum int,
	bz varchar(100)
);
--教材报损字段加注释
comment on column t_jcbs.id is '主键';
comment on column t_jcbs.jcId is '教材';
comment on column t_jcbs.bsNum is '数量';
comment on column t_jcbs.bz is '备注';
--教材报损表加注释
comment on table t_jcbs is '教材报损';

学生领书表创建语句如下:


create table t_stubook(
	id integer,
	studentId int,
	num int,
	jcId int,
	lsDate varchar(100)
);
--学生领书字段加注释
comment on column t_stubook.id is '主键';
comment on column t_stubook.studentId is '学生';
comment on column t_stubook.num is '数量';
comment on column t_stubook.jcId is '教材';
comment on column t_stubook.lsDate is '领书日期';
--学生领书表加注释
comment on table t_stubook is '学生领书';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	xb 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.xb is '系别';
--学生表加注释
comment on table t_student is '学生';

老师表创建语句如下:


create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName 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 table t_teacher is '老师';

老师领书表创建语句如下:


create table t_tecbook(
	id integer,
	teacherId varchar(100),
	num int,
	jcId int,
	lsDate varchar(100)
);
--老师领书字段加注释
comment on column t_tecbook.id is '主键';
comment on column t_tecbook.teacherId is '老师';
comment on column t_tecbook.num is '数量';
comment on column t_tecbook.jcId is '教材';
comment on column t_tecbook.lsDate is '领书日期';
--老师领书表加注释
comment on table t_tecbook is '老师领书';

推荐教材表创建语句如下:


create table t_tjjc(
	id integer,
	jcId int,
	xb varchar(100)
);
--推荐教材字段加注释
comment on column t_tjjc.id is '主键';
comment on column t_tjjc.jcId is '教材';
comment on column t_tjjc.xb is '系别';
--推荐教材表加注释
comment on table t_tjjc is '推荐教材';

oracle特有,对应序列如下:


create sequence s_t_cgjh;
create sequence s_t_jc;
create sequence s_t_jcbs;
create sequence s_t_stubook;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_tecbook;
create sequence s_t_tjjc;

基于SpringMVC和Hibernate的教材管理子系统的开发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_cgjh(
	id int identity(1,1) primary key not null,--主键
	jcId int,--教材
	num int,--数量
	cgjhDate varchar(100)--采购日期
);

教材表创建语句如下:


--教材表注释
create table t_jc(
	id int identity(1,1) primary key not null,--主键
	jcName varchar(100),--教材名称
	jcBh varchar(100),--教材编号
	jg int,--价格
	kc int--库存
);

教材报损表创建语句如下:


--教材报损表注释
create table t_jcbs(
	id int identity(1,1) primary key not null,--主键
	jcId int,--教材
	bsNum int,--数量
	bz varchar(100)--备注
);

学生领书表创建语句如下:


--学生领书表注释
create table t_stubook(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	num int,--数量
	jcId int,--教材
	lsDate varchar(100)--领书日期
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	xb varchar(100)--系别
);

老师表创建语句如下:


--老师表注释
create table t_teacher(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	teacherName varchar(100)--老师姓名
);

老师领书表创建语句如下:


--老师领书表注释
create table t_tecbook(
	id int identity(1,1) primary key not null,--主键
	teacherId varchar(100),--老师
	num int,--数量
	jcId int,--教材
	lsDate varchar(100)--领书日期
);

推荐教材表创建语句如下:


--推荐教材表注释
create table t_tjjc(
	id int identity(1,1) primary key not null,--主键
	jcId int,--教材
	xb varchar(100)--系别
);

基于SpringMVC和Hibernate的教材管理子系统的开发登录后主页

基于SpringMVC和Hibernate的教材管理子系统的开发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_cgjh")
public class Cgjh {
//主键
@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 jcId;
//数量
private Integer num;
//采购日期
private String cgjhDate;
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getCgjhDate() {return cgjhDate;}
public void setCgjhDate(String cgjhDate) {this.cgjhDate = cgjhDate;}
}

教材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_jc")
public class Jc {
//主键
@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 jcName;
//教材编号
private String jcBh;
//价格
private Integer jg;
//库存
private Integer kc;
public String getJcName() {return jcName;}
public void setJcName(String jcName) {this.jcName = jcName;}
public String getJcBh() {return jcBh;}
public void setJcBh(String jcBh) {this.jcBh = jcBh;}
public Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
}

教材报损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_jcbs")
public class Jcbs {
//主键
@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 jcId;
//数量
private Integer bsNum;
//备注
private String bz;
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public Integer getBsNum() {return bsNum;}
public void setBsNum(Integer bsNum) {this.bsNum = bsNum;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
}

学生领书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_stubook")
public class Stubook {
//主键
@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 num;
//教材
private Integer jcId;
//领书日期
private String lsDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public String getLsDate() {return lsDate;}
public void setLsDate(String lsDate) {this.lsDate = lsDate;}
}

学生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 xb;
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 getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}

老师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;
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;}
}

老师领书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_tecbook")
public class Tecbook {
//主键
@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 teacherId;
//数量
private Integer num;
//教材
private Integer jcId;
//领书日期
private String lsDate;
public String getTeacherId() {return teacherId;}
public void setTeacherId(String teacherId) {this.teacherId = teacherId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public String getLsDate() {return lsDate;}
public void setLsDate(String lsDate) {this.lsDate = lsDate;}
}

推荐教材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_tjjc")
public class Tjjc {
//主键
@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 jcId;
//系别
private String xb;
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}

基于SpringMVC和Hibernate的教材管理子系统的开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

采购计划javaBean创建语句如下:


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

//采购计划
public class Cgjh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教材
private Integer jcId;
//数量
private Integer num;
//采购日期
private String cgjhDate;
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getCgjhDate() {return cgjhDate;}
public void setCgjhDate(String cgjhDate) {this.cgjhDate = cgjhDate;}
}

教材javaBean创建语句如下:


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

//教材
public class Jc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教材名称
private String jcName;
//教材编号
private String jcBh;
//价格
private Integer jg;
//库存
private Integer kc;
public String getJcName() {return jcName;}
public void setJcName(String jcName) {this.jcName = jcName;}
public String getJcBh() {return jcBh;}
public void setJcBh(String jcBh) {this.jcBh = jcBh;}
public Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
}

教材报损javaBean创建语句如下:


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

//教材报损
public class Jcbs  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教材
private Integer jcId;
//数量
private Integer bsNum;
//备注
private String bz;
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public Integer getBsNum() {return bsNum;}
public void setBsNum(Integer bsNum) {this.bsNum = bsNum;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
}

学生领书javaBean创建语句如下:


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

//学生领书
public class Stubook  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//数量
private Integer num;
//教材
private Integer jcId;
//领书日期
private String lsDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public String getLsDate() {return lsDate;}
public void setLsDate(String lsDate) {this.lsDate = lsDate;}
}

学生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 xb;
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 getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}

老师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;
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;}
}

老师领书javaBean创建语句如下:


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

//老师领书
public class Tecbook  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private String teacherId;
//数量
private Integer num;
//教材
private Integer jcId;
//领书日期
private String lsDate;
public String getTeacherId() {return teacherId;}
public void setTeacherId(String teacherId) {this.teacherId = teacherId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public String getLsDate() {return lsDate;}
public void setLsDate(String lsDate) {this.lsDate = lsDate;}
}

推荐教材javaBean创建语句如下:


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

//推荐教材
public class Tjjc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教材
private Integer jcId;
//系别
private String xb;
public Integer getJcId() {return jcId;}
public void setJcId(Integer jcId) {this.jcId = jcId;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}

评论