- 作业管理系统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_cj(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
kcName varchar(100) comment '课程',
kq int comment '考勤成绩',
cj int comment '学习成绩',
pjf int comment '平均分',
showDate datetime comment '日期'
) comment '学生成绩';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
cotnent varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '公告';
课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
kcName varchar(100) comment '课程名称',
ls varchar(100) comment '老师',
skdd varchar(100) comment '上课地点',
sksj 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 '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex 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 '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '老师';
作业表创建语句如下：
create table t_zuoye(
id int primary key auto_increment comment '主键',
zuoyeName varchar(100) comment '作业',
content varchar(100) comment '内容',
fileUrl varchar(100) comment '附件',
showDate datetime comment '日期'
) comment '作业';
作业上传表创建语句如下：
create table t_zuoyelist(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
zuoyeId int comment '作业',
content varchar(100) comment '说明',
backUrl varchar(100) comment '作业附件',
insertDate datetime 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_cj(
id integer,
studentId int,
kcName varchar(100),
kq int,
cj int,
pjf int,
showDate datetime
);
--学生成绩字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.studentId is '学生';
comment on column t_cj.kcName is '课程';
comment on column t_cj.kq is '考勤成绩';
comment on column t_cj.cj is '学习成绩';
comment on column t_cj.pjf is '平均分';
comment on column t_cj.showDate is '日期';
--学生成绩表加注释
comment on table t_cj is '学生成绩';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.cotnent is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
课程表创建语句如下：
create table t_kc(
id integer,
kcName varchar(100),
ls varchar(100),
skdd varchar(100),
sksj varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.ls is '老师';
comment on column t_kc.skdd is '上课地点';
comment on column t_kc.sksj is '上课时间';
--课程表加注释
comment on table t_kc is '课程';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
phone varchar(100),
age varchar(100),
sex 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.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
--学生表加注释
comment on table t_student is '学生';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
phone varchar(100),
age varchar(100),
sex 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.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
--老师表加注释
comment on table t_teacher is '老师';
作业表创建语句如下：
create table t_zuoye(
id integer,
zuoyeName varchar(100),
content varchar(100),
fileUrl varchar(100),
showDate datetime
);
--作业字段加注释
comment on column t_zuoye.id is '主键';
comment on column t_zuoye.zuoyeName is '作业';
comment on column t_zuoye.content is '内容';
comment on column t_zuoye.fileUrl is '附件';
comment on column t_zuoye.showDate is '日期';
--作业表加注释
comment on table t_zuoye is '作业';
作业上传表创建语句如下：
create table t_zuoyelist(
id integer,
studentId int,
zuoyeId int,
content varchar(100),
backUrl varchar(100),
insertDate datetime
);
--作业上传字段加注释
comment on column t_zuoyelist.id is '主键';
comment on column t_zuoyelist.studentId is '学生';
comment on column t_zuoyelist.zuoyeId is '作业';
comment on column t_zuoyelist.content is '说明';
comment on column t_zuoyelist.backUrl is '作业附件';
comment on column t_zuoyelist.insertDate is '日期';
--作业上传表加注释
comment on table t_zuoyelist is '作业上传';
oracle特有，对应序列如下：
create sequence s_t_cj;
create sequence s_t_gg;
create sequence s_t_kc;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_zuoye;
create sequence s_t_zuoyelist;
作业管理系统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_cj(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
kcName varchar(100),--课程
kq int,--考勤成绩
cj int,--学习成绩
pjf int,--平均分
showDate datetime--日期
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
cotnent varchar(100),--内容
showDate datetime--日期
);
课程表创建语句如下：
--课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
kcName varchar(100),--课程名称
ls varchar(100),--老师
skdd varchar(100),--上课地点
sksj varchar(100)--上课时间
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
作业表创建语句如下：
--作业表注释
create table t_zuoye(
id int identity(1,1) primary key not null,--主键
zuoyeName varchar(100),--作业
content varchar(100),--内容
fileUrl varchar(100),--附件
showDate datetime--日期
);
作业上传表创建语句如下：
--作业上传表注释
create table t_zuoyelist(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
zuoyeId int,--作业
content varchar(100),--说明
backUrl varchar(100),--作业附件
insertDate datetime--日期
);
登录后主页.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_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 Integer studentId;
//课程
private String kcName;
//考勤成绩
private Integer kq;
//学习成绩
private Integer cj;
//平均分
private Integer pjf;
//日期
private Date showDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Integer getKq() {return kq;}
public void setKq(Integer kq) {this.kq = kq;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public Integer getPjf() {return pjf;}
public void setPjf(Integer pjf) {this.pjf = pjf;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}公告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_gg")
public class Gg {
//主键
@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 pic;
//内容
private String cotnent;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}课程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 ls;
//上课地点
private String skdd;
//上课时间
private String sksj;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getLs() {return ls;}
public void setLs(String ls) {this.ls = ls;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
}学生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 phone;
//年龄
private String age;
//性别
private String sex;
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 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;}
}老师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 phone;
//年龄
private String age;
//性别
private String sex;
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 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;}
}作业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_zuoye")
public class Zuoye {
//主键
@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 zuoyeName;
//内容
private String content;
//附件
private String fileUrl;
//日期
private Date showDate;
public String getZuoyeName() {return zuoyeName;}
public void setZuoyeName(String zuoyeName) {this.zuoyeName = zuoyeName;}
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 getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}作业上传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_zuoyelist")
public class Zuoyelist {
//主键
@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 zuoyeId;
//说明
private String content;
//作业附件
private String backUrl;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getZuoyeId() {return zuoyeId;}
public void setZuoyeId(Integer zuoyeId) {this.zuoyeId = zuoyeId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBackUrl() {return backUrl;}
public void setBackUrl(String backUrl) {this.backUrl = backUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}作业管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
学生成绩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 Integer studentId;
//课程
private String kcName;
//考勤成绩
private Integer kq;
//学习成绩
private Integer cj;
//平均分
private Integer pjf;
//日期
private Date showDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Integer getKq() {return kq;}
public void setKq(Integer kq) {this.kq = kq;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public Integer getPjf() {return pjf;}
public void setPjf(Integer pjf) {this.pjf = pjf;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}课程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 ls;
//上课地点
private String skdd;
//上课时间
private String sksj;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getLs() {return ls;}
public void setLs(String ls) {this.ls = ls;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
}学生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 phone;
//年龄
private String age;
//性别
private String sex;
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 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;}
}老师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 phone;
//年龄
private String age;
//性别
private String sex;
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 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;}
}作业javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//作业
public class Zuoye extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//作业
private String zuoyeName;
//内容
private String content;
//附件
private String fileUrl;
//日期
private Date showDate;
public String getZuoyeName() {return zuoyeName;}
public void setZuoyeName(String zuoyeName) {this.zuoyeName = zuoyeName;}
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 getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}作业上传javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//作业上传
public class Zuoyelist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//作业
private Integer zuoyeId;
//说明
private String content;
//作业附件
private String backUrl;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getZuoyeId() {return zuoyeId;}
public void setZuoyeId(Integer zuoyeId) {this.zuoyeId = zuoyeId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBackUrl() {return backUrl;}
public void setBackUrl(String backUrl) {this.backUrl = backUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}