- 学生成绩管理系统mysql数据库创建语句
- 学生成绩管理系统oracle数据库创建语句
- 学生成绩管理系统sqlserver数据库创建语句
- 学生成绩管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 学生成绩管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
学生成绩管理系统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_bj(
id int primary key auto_increment comment '主键',
bjName varchar(100) comment '班级'
) comment '班级';
学生成绩表创建语句如下：
create table t_cj(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
xqId int comment '学期',
kcId int comment '课程',
allcj int comment '总成绩',
qzcj int comment '期中成绩',
pscj int comment '平时',
qmcj int comment '期末'
) comment '学生成绩';
公告表创建语句如下：
create table t_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '发布时间',
fbr varchar(100) comment '发布人'
) comment '公告';
课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
xqId int comment '学期',
kcName varchar(100) comment '课程名称',
bh varchar(100) comment '课程编号',
kclx varchar(100) comment '',
teacherId int comment '老师',
xs varchar(100) comment '学时',
xf int comment '',
js varchar(100) comment '教室'
) comment '课程';
考试安排表创建语句如下：
create table t_ks(
id int primary key auto_increment comment '主键',
xqId int comment '学期',
kssj varchar(100) comment '考试时间',
kskm varchar(100) comment '考试科目',
ksdd varchar(100) comment '考试地点',
kssc varchar(100) comment '考试时长'
) comment '考试安排';
普通管理员表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ptadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
xy 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 '姓名',
xh varchar(100) comment '学号',
bjId int comment '班级',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
xy varchar(100) comment '学院',
zy varchar(100) comment '专业',
xb varchar(100) comment '系别',
sfz varchar(100) comment '身份证',
jj text comment '简介',
pic 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 '姓名',
gh varchar(100) comment '工号',
xy varchar(100) comment '学院',
zc varchar(100) comment '职称',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
pic varchar(100) comment '头像',
jj text comment '人物简介'
) comment '老师';
学期表表创建语句如下：
create table t_xq(
id int primary key auto_increment comment '主键',
xqName varchar(100) comment '学期名',
nian varchar(100) comment '',
startDate varchar(100) comment '开始时间'
) comment '学期表';
学生成绩管理系统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_bj(
id integer,
bjName varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
--班级表加注释
comment on table t_bj is '班级';
学生成绩表创建语句如下：
create table t_cj(
id integer,
studentId int,
xqId int,
kcId int,
allcj int,
qzcj int,
pscj int,
qmcj int
);
--学生成绩字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.studentId is '学生';
comment on column t_cj.xqId is '学期';
comment on column t_cj.kcId is '课程';
comment on column t_cj.allcj is '总成绩';
comment on column t_cj.qzcj is '期中成绩';
comment on column t_cj.pscj is '平时';
comment on column t_cj.qmcj is '期末';
--学生成绩表加注释
comment on table t_cj is '学生成绩';
公告表创建语句如下：
create table t_gonggao(
id integer,
title varchar(100),
content text,
insertDate datetime,
fbr varchar(100)
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发布时间';
comment on column t_gonggao.fbr is '发布人';
--公告表加注释
comment on table t_gonggao is '公告';
课程表创建语句如下：
create table t_kc(
id integer,
xqId int,
kcName varchar(100),
bh varchar(100),
kclx varchar(100),
teacherId int,
xs varchar(100),
xf int,
js varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.xqId is '学期';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.bh is '课程编号';
comment on column t_kc.kclx is '';
comment on column t_kc.teacherId is '老师';
comment on column t_kc.xs is '学时';
comment on column t_kc.xf is '';
comment on column t_kc.js is '教室';
--课程表加注释
comment on table t_kc is '课程';
考试安排表创建语句如下：
create table t_ks(
id integer,
xqId int,
kssj varchar(100),
kskm varchar(100),
ksdd varchar(100),
kssc varchar(100)
);
--考试安排字段加注释
comment on column t_ks.id is '主键';
comment on column t_ks.xqId is '学期';
comment on column t_ks.kssj is '考试时间';
comment on column t_ks.kskm is '考试科目';
comment on column t_ks.ksdd is '考试地点';
comment on column t_ks.kssc is '考试时长';
--考试安排表加注释
comment on table t_ks is '考试安排';
普通管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
xy varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '';
comment on column t_ptadmin.xy is '学院';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
xh varchar(100),
bjId int,
phone varchar(100),
age varchar(100),
sex varchar(100),
xy varchar(100),
zy varchar(100),
xb varchar(100),
sfz varchar(100),
jj text,
pic 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.xh is '学号';
comment on column t_student.bjId 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.xy is '学院';
comment on column t_student.zy is '专业';
comment on column t_student.xb is '系别';
comment on column t_student.sfz is '身份证';
comment on column t_student.jj is '简介';
comment on column t_student.pic is '头像';
--学生表加注释
comment on table t_student is '学生';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
gh varchar(100),
xy varchar(100),
zc varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
pic varchar(100),
jj text
);
--老师字段加注释
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.gh is '工号';
comment on column t_teacher.xy is '学院';
comment on column t_teacher.zc is '职称';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '';
comment on column t_teacher.pic is '头像';
comment on column t_teacher.jj is '人物简介';
--老师表加注释
comment on table t_teacher is '老师';
学期表表创建语句如下：
create table t_xq(
id integer,
xqName varchar(100),
nian varchar(100),
startDate varchar(100)
);
--学期表字段加注释
comment on column t_xq.id is '主键';
comment on column t_xq.xqName is '学期名';
comment on column t_xq.nian is '';
comment on column t_xq.startDate is '开始时间';
--学期表表加注释
comment on table t_xq is '学期表';
oracle特有，对应序列如下：
create sequence s_t_bj;
create sequence s_t_cj;
create sequence s_t_gonggao;
create sequence s_t_kc;
create sequence s_t_ks;
create sequence s_t_ptadmin;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_xq;
学生成绩管理系统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_bj(
id int identity(1,1) primary key not null,--主键
bjName varchar(100)--班级
);
学生成绩表创建语句如下：
--学生成绩表注释
create table t_cj(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
xqId int,--学期
kcId int,--课程
allcj int,--总成绩
qzcj int,--期中成绩
pscj int,--平时
qmcj int--期末
);
公告表创建语句如下：
--公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime,--发布时间
fbr varchar(100)--发布人
);
课程表创建语句如下：
--课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
xqId int,--学期
kcName varchar(100),--课程名称
bh varchar(100),--课程编号
kclx varchar(100),--
teacherId int,--老师
xs varchar(100),--学时
xf int,--
js varchar(100)--教室
);
考试安排表创建语句如下：
--考试安排表注释
create table t_ks(
id int identity(1,1) primary key not null,--主键
xqId int,--学期
kssj varchar(100),--考试时间
kskm varchar(100),--考试科目
ksdd varchar(100),--考试地点
kssc varchar(100)--考试时长
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadminName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
xy varchar(100)--学院
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
xh varchar(100),--学号
bjId int,--班级
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
xy varchar(100),--学院
zy varchar(100),--专业
xb varchar(100),--系别
sfz varchar(100),--身份证
jj text,--简介
pic varchar(100)--头像
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
gh varchar(100),--工号
xy varchar(100),--学院
zc varchar(100),--职称
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
pic varchar(100),--头像
jj text--人物简介
);
学期表表创建语句如下：
--学期表表注释
create table t_xq(
id int identity(1,1) primary key not null,--主键
xqName varchar(100),--学期名
nian varchar(100),--
startDate varchar(100)--开始时间
);
登录后主页.jpg?x-oss-process=style/00001)
学生成绩管理系统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_bj")
public class Bj {
//主键
@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 bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}学生成绩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_cj")
public class Cj {
//主键
@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 Long studentId;
//学期
private Long xqId;
//课程
private Long kcId;
//总成绩
private Integer allcj;
//期中成绩
private Integer qzcj;
//平时
private Integer pscj;
//期末
private Integer qmcj;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Long getXqId() {return xqId;}
public void setXqId(Long xqId) {this.xqId = xqId;}
public Long getKcId() {return kcId;}
public void setKcId(Long kcId) {this.kcId = kcId;}
public Integer getAllcj() {return allcj;}
public void setAllcj(Integer allcj) {this.allcj = allcj;}
public Integer getQzcj() {return qzcj;}
public void setQzcj(Integer qzcj) {this.qzcj = qzcj;}
public Integer getPscj() {return pscj;}
public void setPscj(Integer pscj) {this.pscj = pscj;}
public Integer getQmcj() {return qmcj;}
public void setQmcj(Integer qmcj) {this.qmcj = qmcj;}
}公告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_gonggao")
public class Gonggao {
//主键
@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 title;
//内容
private String content;
//发布时间
private Date insertDate;
//发布人
private String fbr;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getFbr() {return fbr;}
public void setFbr(String fbr) {this.fbr = fbr;}
}课程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 Long xqId;
//课程名称
private String kcName;
//课程编号
private String bh;
//
private String kclx;
//老师
private Long teacherId;
//学时
private String xs;
//
private Integer xf;
//教室
private String js;
public Long getXqId() {return xqId;}
public void setXqId(Long xqId) {this.xqId = xqId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getKclx() {return kclx;}
public void setKclx(String kclx) {this.kclx = kclx;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getXs() {return xs;}
public void setXs(String xs) {this.xs = xs;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}考试安排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_ks")
public class Ks {
//主键
@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 Long xqId;
//考试时间
private String kssj;
//考试科目
private String kskm;
//考试地点
private String ksdd;
//考试时长
private String kssc;
public Long getXqId() {return xqId;}
public void setXqId(Long xqId) {this.xqId = xqId;}
public String getKssj() {return kssj;}
public void setKssj(String kssj) {this.kssj = kssj;}
public String getKskm() {return kskm;}
public void setKskm(String kskm) {this.kskm = kskm;}
public String getKsdd() {return ksdd;}
public void setKsdd(String ksdd) {this.ksdd = ksdd;}
public String getKssc() {return kssc;}
public void setKssc(String kssc) {this.kssc = kssc;}
}普通管理员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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//学院
private String xy;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
}学生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 xh;
//班级
private Long bjId;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//学院
private String xy;
//专业
private String zy;
//系别
private String xb;
//身份证
private String sfz;
//简介
private String jj;
//头像
private String pic;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public Long getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
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 getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJj() {return jj;}
public void setJj(String jj) {this.jj = jj;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}老师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 gh;
//学院
private String xy;
//职称
private String zc;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//头像
private String pic;
//人物简介
private String jj;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getJj() {return jj;}
public void setJj(String jj) {this.jj = jj;}
}学期表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_xq")
public class Xq {
//主键
@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 xqName;
//
private String nian;
//开始时间
private String startDate;
public String getXqName() {return xqName;}
public void setXqName(String xqName) {this.xqName = xqName;}
public String getNian() {return nian;}
public void setNian(String nian) {this.nian = nian;}
public String getStartDate() {return startDate;}
public void setStartDate(String startDate) {this.startDate = startDate;}
}学生成绩管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
班级javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级
public class Bj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private String bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}学生成绩javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学生成绩
public class Cj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long studentId;
//学期
private Long xqId;
//课程
private Long kcId;
//总成绩
private Integer allcj;
//期中成绩
private Integer qzcj;
//平时
private Integer pscj;
//期末
private Integer qmcj;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Long getXqId() {return xqId;}
public void setXqId(Long xqId) {this.xqId = xqId;}
public Long getKcId() {return kcId;}
public void setKcId(Long kcId) {this.kcId = kcId;}
public Integer getAllcj() {return allcj;}
public void setAllcj(Integer allcj) {this.allcj = allcj;}
public Integer getQzcj() {return qzcj;}
public void setQzcj(Integer qzcj) {this.qzcj = qzcj;}
public Integer getPscj() {return pscj;}
public void setPscj(Integer pscj) {this.pscj = pscj;}
public Integer getQmcj() {return qmcj;}
public void setQmcj(Integer qmcj) {this.qmcj = qmcj;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gonggao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发布时间
private Date insertDate;
//发布人
private String fbr;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
public String getFbr() {return fbr;}
public void setFbr(String fbr) {this.fbr = fbr;}
}课程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 Long xqId;
//课程名称
private String kcName;
//课程编号
private String bh;
//
private String kclx;
//老师
private Long teacherId;
//学时
private String xs;
//
private Integer xf;
//教室
private String js;
public Long getXqId() {return xqId;}
public void setXqId(Long xqId) {this.xqId = xqId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getKclx() {return kclx;}
public void setKclx(String kclx) {this.kclx = kclx;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getXs() {return xs;}
public void setXs(String xs) {this.xs = xs;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}考试安排javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//考试安排
public class Ks extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学期
private Long xqId;
//考试时间
private String kssj;
//考试科目
private String kskm;
//考试地点
private String ksdd;
//考试时长
private String kssc;
public Long getXqId() {return xqId;}
public void setXqId(Long xqId) {this.xqId = xqId;}
public String getKssj() {return kssj;}
public void setKssj(String kssj) {this.kssj = kssj;}
public String getKskm() {return kskm;}
public void setKskm(String kskm) {this.kskm = kskm;}
public String getKsdd() {return ksdd;}
public void setKsdd(String ksdd) {this.ksdd = ksdd;}
public String getKssc() {return kssc;}
public void setKssc(String kssc) {this.kssc = kssc;}
}普通管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//普通管理员
public class Ptadmin 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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//学院
private String xy;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
}学生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 xh;
//班级
private Long bjId;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//学院
private String xy;
//专业
private String zy;
//系别
private String xb;
//身份证
private String sfz;
//简介
private String jj;
//头像
private String pic;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public Long getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
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 getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJj() {return jj;}
public void setJj(String jj) {this.jj = jj;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}老师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 gh;
//学院
private String xy;
//职称
private String zc;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//头像
private String pic;
//人物简介
private String jj;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getXy() {return xy;}
public void setXy(String xy) {this.xy = xy;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getJj() {return jj;}
public void setJj(String jj) {this.jj = jj;}
}学期表javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学期表
public class Xq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学期名
private String xqName;
//
private String nian;
//开始时间
private String startDate;
public String getXqName() {return xqName;}
public void setXqName(String xqName) {this.xqName = xqName;}
public String getNian() {return nian;}
public void setNian(String nian) {this.nian = nian;}
public String getStartDate() {return startDate;}
public void setStartDate(String startDate) {this.startDate = startDate;}
}