更多成品,定做java毕业设计,请咨询管理员qq:2812491287

基于SSH的高校平时成绩考核助手,java专业毕业设计

基于SSH的高校平时成绩考核助手登录注册界面

基于SSH的高校平时成绩考核助手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_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '教学管理员';

课程表创建语句如下:


create table t_kc(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	kcName varchar(100) comment '课程名称',
	kcls varchar(100) comment '课程老师',
	sksj varchar(100) comment '上课时间',
	skdd varchar(100) comment '上课地点',
	bz varchar(100) comment '备注',
	v1 double comment '',
	v2 double comment '',
	v3 double comment '',
	v4 double comment '',
	zy varchar(100) comment ''
) comment '课程';

课程成绩表创建语句如下:


create table t_kccj(
	id int primary key auto_increment comment '主键',
	kcId int comment '课程',
	studentId int comment '学生',
	v1 int comment '记录作业',
	v2 int comment '课堂提问',
	v3 int comment '实验',
	v4 int comment '上机成绩',
	v5 int comment '平时成绩',
	bz varchar(100) comment '备注'
) comment '课程成绩';

考勤表创建语句如下:


create table t_kq(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	types varchar(100) comment '类型',
	showDate 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 '电话',
	zy 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 '电话'
) comment '老师';

基于SSH的高校平时成绩考核助手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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--教学管理员字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
--教学管理员表加注释
comment on table t_customer is '教学管理员';

课程表创建语句如下:


create table t_kc(
	id integer,
	teacherId int,
	kcName varchar(100),
	kcls varchar(100),
	sksj varchar(100),
	skdd varchar(100),
	bz varchar(100),
	v1 double,
	v2 double,
	v3 double,
	v4 double,
	zy varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.teacherId is '老师';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.kcls is '课程老师';
comment on column t_kc.sksj is '上课时间';
comment on column t_kc.skdd is '上课地点';
comment on column t_kc.bz is '备注';
comment on column t_kc.v1 is '';
comment on column t_kc.v2 is '';
comment on column t_kc.v3 is '';
comment on column t_kc.v4 is '';
comment on column t_kc.zy is '';
--课程表加注释
comment on table t_kc is '课程';

课程成绩表创建语句如下:


create table t_kccj(
	id integer,
	kcId int,
	studentId int,
	v1 int,
	v2 int,
	v3 int,
	v4 int,
	v5 int,
	bz varchar(100)
);
--课程成绩字段加注释
comment on column t_kccj.id is '主键';
comment on column t_kccj.kcId is '课程';
comment on column t_kccj.studentId is '学生';
comment on column t_kccj.v1 is '记录作业';
comment on column t_kccj.v2 is '课堂提问';
comment on column t_kccj.v3 is '实验';
comment on column t_kccj.v4 is '上机成绩';
comment on column t_kccj.v5 is '平时成绩';
comment on column t_kccj.bz is '备注';
--课程成绩表加注释
comment on table t_kccj is '课程成绩';

考勤表创建语句如下:


create table t_kq(
	id integer,
	studentId int,
	types varchar(100),
	showDate varchar(100),
	bz varchar(100)
);
--考勤字段加注释
comment on column t_kq.id is '主键';
comment on column t_kq.studentId is '学生';
comment on column t_kq.types is '类型';
comment on column t_kq.showDate is '日期';
comment on column t_kq.bz is '备注';
--考勤表加注释
comment on table t_kq 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),
	zy 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.zy is '专业';
--学生表加注释
comment on table t_student 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)
);
--老师字段加注释
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 table t_teacher is '老师';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_kc;
create sequence s_t_kccj;
create sequence s_t_kq;
create sequence s_t_student;
create sequence s_t_teacher;

基于SSH的高校平时成绩考核助手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_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

课程表创建语句如下:


--课程表注释
create table t_kc(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	kcName varchar(100),--课程名称
	kcls varchar(100),--课程老师
	sksj varchar(100),--上课时间
	skdd varchar(100),--上课地点
	bz varchar(100),--备注
	v1 double,--
	v2 double,--
	v3 double,--
	v4 double,--
	zy varchar(100)--
);

课程成绩表创建语句如下:


--课程成绩表注释
create table t_kccj(
	id int identity(1,1) primary key not null,--主键
	kcId int,--课程
	studentId int,--学生
	v1 int,--记录作业
	v2 int,--课堂提问
	v3 int,--实验
	v4 int,--上机成绩
	v5 int,--平时成绩
	bz varchar(100)--备注
);

考勤表创建语句如下:


--考勤表注释
create table t_kq(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	types varchar(100),--类型
	showDate 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),--电话
	zy 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)--电话
);

基于SSH的高校平时成绩考核助手登录后主页

基于SSH的高校平时成绩考核助手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_customer")
public class Customer {
//主键
@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 customerName;
//年龄
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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_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 Integer teacherId;
//课程名称
private String kcName;
//课程老师
private String kcls;
//上课时间
private String sksj;
//上课地点
private String skdd;
//备注
private String bz;
//
private Double v1;
//
private Double v2;
//
private Double v3;
//
private Double v4;
//
private String zy;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getKcls() {return kcls;}
public void setKcls(String kcls) {this.kcls = kcls;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public Double getV1() {return v1;}
public void setV1(Double v1) {this.v1 = v1;}
public Double getV2() {return v2;}
public void setV2(Double v2) {this.v2 = v2;}
public Double getV3() {return v3;}
public void setV3(Double v3) {this.v3 = v3;}
public Double getV4() {return v4;}
public void setV4(Double v4) {this.v4 = v4;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}

课程成绩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_kccj")
public class Kccj {
//主键
@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 kcId;
//学生
private Integer studentId;
//记录作业
private Integer v1;
//课堂提问
private Integer v2;
//实验
private Integer v3;
//上机成绩
private Integer v4;
//平时成绩
private Integer v5;
//备注
private String bz;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
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_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 Integer studentId;
//类型
private String types;
//日期
private String showDate;
//备注
private String bz;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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 zy;
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 getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}

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

基于SSH的高校平时成绩考核助手spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

教学管理员javaBean创建语句如下:


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

//教学管理员
public class Customer  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 customerName;
//年龄
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 Kc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//课程名称
private String kcName;
//课程老师
private String kcls;
//上课时间
private String sksj;
//上课地点
private String skdd;
//备注
private String bz;
//
private Double v1;
//
private Double v2;
//
private Double v3;
//
private Double v4;
//
private String zy;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getKcls() {return kcls;}
public void setKcls(String kcls) {this.kcls = kcls;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public Double getV1() {return v1;}
public void setV1(Double v1) {this.v1 = v1;}
public Double getV2() {return v2;}
public void setV2(Double v2) {this.v2 = v2;}
public Double getV3() {return v3;}
public void setV3(Double v3) {this.v3 = v3;}
public Double getV4() {return v4;}
public void setV4(Double v4) {this.v4 = v4;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}

课程成绩javaBean创建语句如下:


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

//课程成绩
public class Kccj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private Integer kcId;
//学生
private Integer studentId;
//记录作业
private Integer v1;
//课堂提问
private Integer v2;
//实验
private Integer v3;
//上机成绩
private Integer v4;
//平时成绩
private Integer v5;
//备注
private String bz;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
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 Kq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//类型
private String types;
//日期
private String showDate;
//备注
private String bz;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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 zy;
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 getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}

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

评论