基于JSP的双学位管理系统，java毕业设计

• 基于JSP的双学位管理系统mysql数据库创建语句
• 基于JSP的双学位管理系统oracle数据库创建语句
• 基于JSP的双学位管理系统sqlserver数据库创建语句
• 基于JSP的双学位管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 基于JSP的双学位管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

基于JSP的双学位管理系统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_bm(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	bmsj datetime comment '报名时间',
	bmsm varchar(100) comment '报名说明',
	shDate datetime comment '审核日期',
	shsm varchar(100) comment '审核说明',
	status varchar(100) comment '状态'
) comment '报名选修双学位';

学生缴费表创建语句如下：

create table t_jf(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	v1 varchar(100) comment '缴费名称',
	v2 varchar(100) comment '缴费时间',
	v3 varchar(100) comment '缴费说明'
) comment '学生缴费';

课程表创建语句如下：

create table t_kc(
	id int primary key auto_increment comment '主键',
	kcName varchar(100) comment '课程名称',
	address varchar(100) comment '地点',
	kcDate varchar(100) comment '时间'
) comment '课程';

课程选择表创建语句如下：

create table t_kcxz(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	kcId int comment '课程'
) comment '课程选择';

考试成绩表创建语句如下：

create table t_kscj(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	kcId int comment '课程',
	kssj varchar(100) comment '考试时间',
	kscj varchar(100) comment '考试成绩',
	bz 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 '学生名称',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	xh varchar(100) comment '学号'
) comment '学生';

基于JSP的双学位管理系统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_bm(
	id integer,
	studentId int,
	bmsj datetime,
	bmsm varchar(100),
	shDate datetime,
	shsm varchar(100),
	status varchar(100)
);
--报名选修双学位字段加注释
comment on column t_bm.id is '主键';
comment on column t_bm.studentId is '学生';
comment on column t_bm.bmsj is '报名时间';
comment on column t_bm.bmsm is '报名说明';
comment on column t_bm.shDate is '审核日期';
comment on column t_bm.shsm is '审核说明';
comment on column t_bm.status is '状态';
--报名选修双学位表加注释
comment on table t_bm is '报名选修双学位';

学生缴费表创建语句如下：

create table t_jf(
	id integer,
	studentId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--学生缴费字段加注释
comment on column t_jf.id is '主键';
comment on column t_jf.studentId is '学生';
comment on column t_jf.v1 is '缴费名称';
comment on column t_jf.v2 is '缴费时间';
comment on column t_jf.v3 is '缴费说明';
--学生缴费表加注释
comment on table t_jf is '学生缴费';

课程表创建语句如下：

create table t_kc(
	id integer,
	kcName varchar(100),
	address varchar(100),
	kcDate varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.address is '地点';
comment on column t_kc.kcDate is '时间';
--课程表加注释
comment on table t_kc is '课程';

课程选择表创建语句如下：

create table t_kcxz(
	id integer,
	studentId int,
	kcId int
);
--课程选择字段加注释
comment on column t_kcxz.id is '主键';
comment on column t_kcxz.studentId is '学生';
comment on column t_kcxz.kcId is '课程';
--课程选择表加注释
comment on table t_kcxz is '课程选择';

考试成绩表创建语句如下：

create table t_kscj(
	id integer,
	studentId int,
	kcId int,
	kssj varchar(100),
	kscj varchar(100),
	bz varchar(100)
);
--考试成绩字段加注释
comment on column t_kscj.id is '主键';
comment on column t_kscj.studentId is '学生';
comment on column t_kscj.kcId is '课程';
comment on column t_kscj.kssj is '考试时间';
comment on column t_kscj.kscj is '考试成绩';
comment on column t_kscj.bz is '备注';
--考试成绩表加注释
comment on table t_kscj is '考试成绩';

学生表创建语句如下：

create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	xh 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.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.xh is '学号';
--学生表加注释
comment on table t_student is '学生';

oracle特有，对应序列如下：

create sequence s_t_bm;
create sequence s_t_jf;
create sequence s_t_kc;
create sequence s_t_kcxz;
create sequence s_t_kscj;
create sequence s_t_student;

基于JSP的双学位管理系统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_bm(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	bmsj datetime,--报名时间
	bmsm varchar(100),--报名说明
	shDate datetime,--审核日期
	shsm varchar(100),--审核说明
	status varchar(100)--状态
);

学生缴费表创建语句如下：

--学生缴费表注释
create table t_jf(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	v1 varchar(100),--缴费名称
	v2 varchar(100),--缴费时间
	v3 varchar(100)--缴费说明
);

课程表创建语句如下：

--课程表注释
create table t_kc(
	id int identity(1,1) primary key not null,--主键
	kcName varchar(100),--课程名称
	address varchar(100),--地点
	kcDate varchar(100)--时间
);

课程选择表创建语句如下：

--课程选择表注释
create table t_kcxz(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	kcId int--课程
);

考试成绩表创建语句如下：

--考试成绩表注释
create table t_kscj(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	kcId int,--课程
	kssj varchar(100),--考试时间
	kscj varchar(100),--考试成绩
	bz varchar(100)--备注
);

学生表创建语句如下：

--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	studentName varchar(100),--学生名称
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	xh varchar(100)--学号
);

基于JSP的双学位管理系统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_bm")
public class Bm {
//主键
@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 Date bmsj;
//报名说明
private String bmsm;
//审核日期
private Date shDate;
//审核说明
private String shsm;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getBmsj() {return bmsj;}
public void setBmsj(Date bmsj) {this.bmsj = bmsj;}
public String getBmsm() {return bmsm;}
public void setBmsm(String bmsm) {this.bmsm = bmsm;}
public Date getShDate() {return shDate;}
public void setShDate(Date shDate) {this.shDate = shDate;}
public String getShsm() {return shsm;}
public void setShsm(String shsm) {this.shsm = shsm;}
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_jf")
public class Jf {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//缴费名称
private String v1;
//缴费时间
private String v2;
//缴费说明
private String v3;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

课程javaBean创建语句如下：

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

//课程
@Table(name = "t_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 address;
//时间
private String kcDate;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getKcDate() {return kcDate;}
public void setKcDate(String kcDate) {this.kcDate = kcDate;}
}

课程选择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_kcxz")
public class Kcxz {
//主键
@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 kcId;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
}

考试成绩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_kscj")
public class Kscj {
//主键
@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 kcId;
//考试时间
private String kssj;
//考试成绩
private String kscj;
//备注
private String bz;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public String getKssj() {return kssj;}
public void setKssj(String kssj) {this.kssj = kssj;}
public String getKscj() {return kscj;}
public void setKscj(String kscj) {this.kscj = kscj;}
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_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 age;
//性别
private String sex;
//电话
private String phone;
//学号
private String xh;
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 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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
}

基于JSP的双学位管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

报名选修双学位javaBean创建语句如下：

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

//报名选修双学位
public class Bm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//报名时间
private Date bmsj;
//报名说明
private String bmsm;
//审核日期
private Date shDate;
//审核说明
private String shsm;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getBmsj() {return bmsj;}
public void setBmsj(Date bmsj) {this.bmsj = bmsj;}
public String getBmsm() {return bmsm;}
public void setBmsm(String bmsm) {this.bmsm = bmsm;}
public Date getShDate() {return shDate;}
public void setShDate(Date shDate) {this.shDate = shDate;}
public String getShsm() {return shsm;}
public void setShsm(String shsm) {this.shsm = shsm;}
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 Jf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//缴费名称
private String v1;
//缴费时间
private String v2;
//缴费说明
private String v3;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

课程javaBean创建语句如下：

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

//课程
public class Kc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程名称
private String kcName;
//地点
private String address;
//时间
private String kcDate;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getKcDate() {return kcDate;}
public void setKcDate(String kcDate) {this.kcDate = kcDate;}
}

课程选择javaBean创建语句如下：

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

//课程选择
public class Kcxz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//课程
private Integer kcId;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
}

考试成绩javaBean创建语句如下：

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

//考试成绩
public class Kscj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//课程
private Integer kcId;
//考试时间
private String kssj;
//考试成绩
private String kscj;
//备注
private String bz;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public String getKssj() {return kssj;}
public void setKssj(String kssj) {this.kssj = kssj;}
public String getKscj() {return kscj;}
public void setKscj(String kscj) {this.kscj = kscj;}
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 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 age;
//性别
private String sex;
//电话
private String phone;
//学号
private String xh;
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 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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
}