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

作业管理系统

作业管理系统登录注册界面

作业管理系统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--日期
);

作业管理系统登录后主页

作业管理系统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;}
}

评论