- 基于SSM网上在线批改系统mysql数据库创建语句
- 基于SSM网上在线批改系统oracle数据库创建语句
- 基于SSM网上在线批改系统sqlserver数据库创建语句
- 基于SSM网上在线批改系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于SSM网上在线批改系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于SSM网上在线批改系统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_fbzy(
id int primary key auto_increment comment '主键',
teacherId int comment '教师',
bjId int comment '班级',
kmId int comment '科目',
content varchar(100) comment '内容',
title varchar(100) comment '作业标题',
fileUrl varchar(100) comment '附件',
jzDate datetime comment '截止时间',
status varchar(100) comment '状态'
) comment '发布作业';
科目表创建语句如下：
create table t_km(
id int primary key auto_increment comment '主键',
kmName varchar(100) comment '科目'
) comment '科目';
学生表创建语句如下：
create table t_student(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
xh varchar(100) comment '学号',
studentName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
pic varchar(100) comment '头像',
bjId int comment '班级'
) comment '学生';
老师表创建语句如下：
create table t_teacher(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
jsh varchar(100) comment '教师号',
teacherName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
pic varchar(100) comment '头像'
) comment '老师';
上传的作业表创建语句如下：
create table t_zysc(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
fbzyId int comment '作业',
content varchar(100) comment '内容',
fileUrl varchar(100) comment '附件',
insertDate datetime comment '提交时间',
df int comment '打分',
status varchar(100) comment '状态'
) comment '上传的作业';
基于SSM网上在线批改系统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_fbzy(
id integer,
teacherId int,
bjId int,
kmId int,
content varchar(100),
title varchar(100),
fileUrl varchar(100),
jzDate datetime,
status varchar(100)
);
--发布作业字段加注释
comment on column t_fbzy.id is '主键';
comment on column t_fbzy.teacherId is '教师';
comment on column t_fbzy.bjId is '班级';
comment on column t_fbzy.kmId is '科目';
comment on column t_fbzy.content is '内容';
comment on column t_fbzy.title is '作业标题';
comment on column t_fbzy.fileUrl is '附件';
comment on column t_fbzy.jzDate is '截止时间';
comment on column t_fbzy.status is '状态';
--发布作业表加注释
comment on table t_fbzy is '发布作业';
科目表创建语句如下：
create table t_km(
id integer,
kmName varchar(100)
);
--科目字段加注释
comment on column t_km.id is '主键';
comment on column t_km.kmName is '科目';
--科目表加注释
comment on table t_km is '科目';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
xh varchar(100),
studentName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
pic varchar(100),
bjId int
);
--学生字段加注释
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.xh 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.pic is '头像';
comment on column t_student.bjId is '班级';
--学生表加注释
comment on table t_student is '学生';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
jsh varchar(100),
teacherName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
pic 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.jsh 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 column t_teacher.pic is '头像';
--老师表加注释
comment on table t_teacher is '老师';
上传的作业表创建语句如下：
create table t_zysc(
id integer,
studentId int,
fbzyId int,
content varchar(100),
fileUrl varchar(100),
insertDate datetime,
df int,
status varchar(100)
);
--上传的作业字段加注释
comment on column t_zysc.id is '主键';
comment on column t_zysc.studentId is '学生';
comment on column t_zysc.fbzyId is '作业';
comment on column t_zysc.content is '内容';
comment on column t_zysc.fileUrl is '附件';
comment on column t_zysc.insertDate is '提交时间';
comment on column t_zysc.df is '打分';
comment on column t_zysc.status is '状态';
--上传的作业表加注释
comment on table t_zysc is '上传的作业';
oracle特有，对应序列如下：
create sequence s_t_bj;
create sequence s_t_fbzy;
create sequence s_t_km;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_zysc;
基于SSM网上在线批改系统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_fbzy(
id int identity(1,1) primary key not null,--主键
teacherId int,--教师
bjId int,--班级
kmId int,--科目
content varchar(100),--内容
title varchar(100),--作业标题
fileUrl varchar(100),--附件
jzDate datetime,--截止时间
status varchar(100)--状态
);
科目表创建语句如下：
--科目表注释
create table t_km(
id int identity(1,1) primary key not null,--主键
kmName varchar(100)--科目
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
xh varchar(100),--学号
studentName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
pic varchar(100),--头像
bjId int--班级
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
jsh varchar(100),--教师号
teacherName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
pic varchar(100)--头像
);
上传的作业表创建语句如下：
--上传的作业表注释
create table t_zysc(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
fbzyId int,--作业
content varchar(100),--内容
fileUrl varchar(100),--附件
insertDate datetime,--提交时间
df int,--打分
status varchar(100)--状态
);
登录后主页.jpg?x-oss-process=style/00001)
基于SSM网上在线批改系统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_fbzy")
public class Fbzy {
//主键
@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 Integer bjId;
//科目
private Integer kmId;
//内容
private String content;
//作业标题
private String title;
//附件
private String fileUrl;
//截止时间
private Date jzDate;
//状态
private String status;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getKmId() {return kmId;}
public void setKmId(Integer kmId) {this.kmId = kmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getJzDate() {return jzDate;}
public void setJzDate(Date jzDate) {this.jzDate = jzDate;}
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_km")
public class Km {
//主键
@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 kmName;
public String getKmName() {return kmName;}
public void setKmName(String kmName) {this.kmName = kmName;}
}学生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 xh;
//姓名
private String studentName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//班级
private Integer bjId;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}老师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 jsh;
//姓名
private String teacherName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
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 getJsh() {return jsh;}
public void setJsh(String jsh) {this.jsh = jsh;}
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;}
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_zysc")
public class Zysc {
//主键
@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 fbzyId;
//内容
private String content;
//附件
private String fileUrl;
//提交时间
private Date insertDate;
//打分
private Integer df;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getFbzyId() {return fbzyId;}
public void setFbzyId(Integer fbzyId) {this.fbzyId = fbzyId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getDf() {return df;}
public void setDf(Integer df) {this.df = df;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}基于SSM网上在线批改系统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 Fbzy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教师
private Integer teacherId;
//班级
private Integer bjId;
//科目
private Integer kmId;
//内容
private String content;
//作业标题
private String title;
//附件
private String fileUrl;
//截止时间
private Date jzDate;
//状态
private String status;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getKmId() {return kmId;}
public void setKmId(Integer kmId) {this.kmId = kmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getJzDate() {return jzDate;}
public void setJzDate(Date jzDate) {this.jzDate = jzDate;}
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 Km extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//科目
private String kmName;
public String getKmName() {return kmName;}
public void setKmName(String kmName) {this.kmName = kmName;}
}学生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 xh;
//姓名
private String studentName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//班级
private Integer bjId;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}老师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 jsh;
//姓名
private String teacherName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
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 getJsh() {return jsh;}
public void setJsh(String jsh) {this.jsh = jsh;}
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;}
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 Zysc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//作业
private Integer fbzyId;
//内容
private String content;
//附件
private String fileUrl;
//提交时间
private Date insertDate;
//打分
private Integer df;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getFbzyId() {return fbzyId;}
public void setFbzyId(Integer fbzyId) {this.fbzyId = fbzyId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getDf() {return df;}
public void setDf(Integer df) {this.df = df;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}