课程管理系统

课程管理系统登录注册界面

课程管理系统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_kjcl(
	id int primary key auto_increment comment '主键',
	types varchar(100) comment '类型',
	title varchar(100) comment '标题',
	fileUrl varchar(100) comment '文件',
	content varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '课件材料';

留言表创建语句如下:


create table t_ly(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	content varchar(100) comment '留言内容',
	insertDate datetime comment '留言日期',
	back varchar(100) comment '回复内容',
	backDate datetime comment '回复日期',
	status varchar(100) comment '状态'
) comment '留言';

教学视频表创建语句如下:


create table t_sp(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	fileUrl varchar(100) comment '视频路径',
	content varchar(100) comment '说明',
	showDate datetime comment '日期'
) comment '教学视频';

学生表创建语句如下:


create table t_student(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	studentName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	xn varchar(100) comment '',
	xq varchar(100) comment ''
) comment '学生';

任课老师表创建语句如下:


create table t_teacher(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	teacherName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '任课老师';

学生作业表创建语句如下:


create table t_xszy(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	title varchar(100) comment '作业说明',
	fileUrl varchar(100) comment '作业',
	insertDate datetime comment '日期'
) comment '学生作业';

消息通知表创建语句如下:


create table t_xxtz(
	id int primary key auto_increment comment '主键',
	types varchar(100) comment '类型',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate 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_kjcl(
	id integer,
	types varchar(100),
	title varchar(100),
	fileUrl varchar(100),
	content varchar(100),
	showDate datetime
);
--课件材料字段加注释
comment on column t_kjcl.id is '主键';
comment on column t_kjcl.types is '类型';
comment on column t_kjcl.title is '标题';
comment on column t_kjcl.fileUrl is '文件';
comment on column t_kjcl.content is '内容';
comment on column t_kjcl.showDate is '日期';
--课件材料表加注释
comment on table t_kjcl is '课件材料';

留言表创建语句如下:


create table t_ly(
	id integer,
	studentId int,
	content varchar(100),
	insertDate datetime,
	back varchar(100),
	backDate datetime,
	status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.studentId is '学生';
comment on column t_ly.content is '留言内容';
comment on column t_ly.insertDate is '留言日期';
comment on column t_ly.back is '回复内容';
comment on column t_ly.backDate is '回复日期';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';

教学视频表创建语句如下:


create table t_sp(
	id integer,
	title varchar(100),
	fileUrl varchar(100),
	content varchar(100),
	showDate datetime
);
--教学视频字段加注释
comment on column t_sp.id is '主键';
comment on column t_sp.title is '标题';
comment on column t_sp.fileUrl is '视频路径';
comment on column t_sp.content is '说明';
comment on column t_sp.showDate is '日期';
--教学视频表加注释
comment on table t_sp is '教学视频';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	xn varchar(100),
	xq varchar(100)
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码';
comment on column t_student.studentName is '姓名';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.xn is '';
comment on column t_student.xq is '';
--学生表加注释
comment on table t_student is '学生';

任课老师表创建语句如下:


create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--任课老师字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.username is '账号';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '姓名';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.phone is '电话';
--任课老师表加注释
comment on table t_teacher is '任课老师';

学生作业表创建语句如下:


create table t_xszy(
	id integer,
	studentId int,
	title varchar(100),
	fileUrl varchar(100),
	insertDate datetime
);
--学生作业字段加注释
comment on column t_xszy.id is '主键';
comment on column t_xszy.studentId is '学生';
comment on column t_xszy.title is '作业说明';
comment on column t_xszy.fileUrl is '作业';
comment on column t_xszy.insertDate is '日期';
--学生作业表加注释
comment on table t_xszy is '学生作业';

消息通知表创建语句如下:


create table t_xxtz(
	id integer,
	types varchar(100),
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime
);
--消息通知字段加注释
comment on column t_xxtz.id is '主键';
comment on column t_xxtz.types is '类型';
comment on column t_xxtz.title is '标题';
comment on column t_xxtz.pic is '图片';
comment on column t_xxtz.content is '内容';
comment on column t_xxtz.showDate is '日期';
--消息通知表加注释
comment on table t_xxtz is '消息通知';

oracle特有,对应序列如下:


create sequence s_t_kjcl;
create sequence s_t_ly;
create sequence s_t_sp;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_xszy;
create sequence s_t_xxtz;

课程管理系统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_kjcl(
	id int identity(1,1) primary key not null,--主键
	types varchar(100),--类型
	title varchar(100),--标题
	fileUrl varchar(100),--文件
	content varchar(100),--内容
	showDate datetime--日期
);

留言表创建语句如下:


--留言表注释
create table t_ly(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	content varchar(100),--留言内容
	insertDate datetime,--留言日期
	back varchar(100),--回复内容
	backDate datetime,--回复日期
	status varchar(100)--状态
);

教学视频表创建语句如下:


--教学视频表注释
create table t_sp(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	fileUrl varchar(100),--视频路径
	content varchar(100),--说明
	showDate datetime--日期
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	xn varchar(100),--
	xq varchar(100)--
);

任课老师表创建语句如下:


--任课老师表注释
create table t_teacher(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	teacherName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

学生作业表创建语句如下:


--学生作业表注释
create table t_xszy(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	title varchar(100),--作业说明
	fileUrl varchar(100),--作业
	insertDate datetime--日期
);

消息通知表创建语句如下:


--消息通知表注释
create table t_xxtz(
	id int identity(1,1) primary key not null,--主键
	types varchar(100),--类型
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate 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_kjcl")
public class Kjcl {
//主键
@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 types;
//标题
private String title;
//文件
private String fileUrl;
//内容
private String content;
//日期
private Date showDate;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_ly")
public class Ly {
//主键
@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 content;
//留言日期
private Date insertDate;
//回复内容
private String back;
//回复日期
private Date backDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Date getBackDate() {return backDate;}
public void setBackDate(Date backDate) {this.backDate = backDate;}
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_sp")
public class Sp {
//主键
@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 fileUrl;
//说明
private String content;
//日期
private Date showDate;
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 String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_student")
public class Student {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String studentName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//
private String xn;
//
private String xq;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getXn() {return xn;}
public void setXn(String xn) {this.xn = xn;}
public String getXq() {return xq;}
public void setXq(String xq) {this.xq = xq;}
}

任课老师javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//任课老师
@Table(name = "t_teacher")
public class Teacher {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String teacherName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

学生作业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_xszy")
public class Xszy {
//主键
@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 title;
//作业
private String fileUrl;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

消息通知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_xxtz")
public class Xxtz {
//主键
@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 types;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

课程管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

课件材料javaBean创建语句如下:


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

//课件材料
public class Kjcl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String types;
//标题
private String title;
//文件
private String fileUrl;
//内容
private String content;
//日期
private Date showDate;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Ly  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//留言内容
private String content;
//留言日期
private Date insertDate;
//回复内容
private String back;
//回复日期
private Date backDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Date getBackDate() {return backDate;}
public void setBackDate(Date backDate) {this.backDate = backDate;}
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 Sp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//视频路径
private String fileUrl;
//说明
private String content;
//日期
private Date showDate;
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 String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Student  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String studentName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//
private String xn;
//
private String xq;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getXn() {return xn;}
public void setXn(String xn) {this.xn = xn;}
public String getXq() {return xq;}
public void setXq(String xq) {this.xq = xq;}
}

任课老师javaBean创建语句如下:


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

//任课老师
public class Teacher  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String teacherName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

学生作业javaBean创建语句如下:


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

//学生作业
public class Xszy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//作业说明
private String title;
//作业
private String fileUrl;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

消息通知javaBean创建语句如下:


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

//消息通知
public class Xxtz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String types;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

源代码下载点这里

评论