美联英语学员学习管理系统的设计与实现

美联英语学员学习管理系统的设计与实现登录注册界面

美联英语学员学习管理系统的设计与实现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_pk(
	id int primary key auto_increment comment '主键',
	showDate datetime comment '课程日期',
	kcDate varchar(100) comment '上课时间段',
	kcName varchar(100) comment '课程名称',
	kcAddress varchar(100) comment '上课地点',
	teacherId int comment '老师'
) comment '排课';

上课表创建语句如下:


create table t_sk(
	id int primary key auto_increment comment '主键',
	pkId int comment '排课',
	stuId int comment '学生',
	teacherName varchar(100) comment '老师',
	status varchar(100) comment '状态',
	xj varchar(100) comment '星级',
	content varchar(100) comment '评价'
) comment '上课';

学员表创建语句如下:


create table t_stu(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	stuName varchar(100) comment '姓名',
	age varchar(100) comment '年里',
	sex varchar(100) comment '性别',
	phone 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_yy(
	id int primary key auto_increment comment '主键',
	stuId int comment '申请人',
	content varchar(100) comment '申请说明',
	reback varchar(100) comment '回复',
	yyDate datetime comment '考试日期',
	status 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_pk(
	id integer,
	showDate datetime,
	kcDate varchar(100),
	kcName varchar(100),
	kcAddress varchar(100),
	teacherId int
);
--排课字段加注释
comment on column t_pk.id is '主键';
comment on column t_pk.showDate is '课程日期';
comment on column t_pk.kcDate is '上课时间段';
comment on column t_pk.kcName is '课程名称';
comment on column t_pk.kcAddress is '上课地点';
comment on column t_pk.teacherId is '老师';
--排课表加注释
comment on table t_pk is '排课';

上课表创建语句如下:


create table t_sk(
	id integer,
	pkId int,
	stuId int,
	teacherName varchar(100),
	status varchar(100),
	xj varchar(100),
	content varchar(100)
);
--上课字段加注释
comment on column t_sk.id is '主键';
comment on column t_sk.pkId is '排课';
comment on column t_sk.stuId is '学生';
comment on column t_sk.teacherName is '老师';
comment on column t_sk.status is '状态';
comment on column t_sk.xj is '星级';
comment on column t_sk.content is '评价';
--上课表加注释
comment on table t_sk is '上课';

学员表创建语句如下:


create table t_stu(
	id integer,
	username varchar(100),
	password varchar(100),
	stuName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--学员字段加注释
comment on column t_stu.id is '主键';
comment on column t_stu.username is '账号';
comment on column t_stu.password is '密码';
comment on column t_stu.stuName is '姓名';
comment on column t_stu.age is '年里';
comment on column t_stu.sex is '性别';
comment on column t_stu.phone is '电话';
--学员表加注释
comment on table t_stu 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_yy(
	id integer,
	stuId int,
	content varchar(100),
	reback varchar(100),
	yyDate datetime,
	status varchar(100)
);
--预约升级考试字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.stuId is '申请人';
comment on column t_yy.content is '申请说明';
comment on column t_yy.reback is '回复';
comment on column t_yy.yyDate is '考试日期';
comment on column t_yy.status is '状态';
--预约升级考试表加注释
comment on table t_yy is '预约升级考试';

oracle特有,对应序列如下:


create sequence s_t_pk;
create sequence s_t_sk;
create sequence s_t_stu;
create sequence s_t_teacher;
create sequence s_t_yy;

美联英语学员学习管理系统的设计与实现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_pk(
	id int identity(1,1) primary key not null,--主键
	showDate datetime,--课程日期
	kcDate varchar(100),--上课时间段
	kcName varchar(100),--课程名称
	kcAddress varchar(100),--上课地点
	teacherId int--老师
);

上课表创建语句如下:


--上课表注释
create table t_sk(
	id int identity(1,1) primary key not null,--主键
	pkId int,--排课
	stuId int,--学生
	teacherName varchar(100),--老师
	status varchar(100),--状态
	xj varchar(100),--星级
	content varchar(100)--评价
);

学员表创建语句如下:


--学员表注释
create table t_stu(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	stuName varchar(100),--姓名
	age varchar(100),--年里
	sex varchar(100),--性别
	phone 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_yy(
	id int identity(1,1) primary key not null,--主键
	stuId int,--申请人
	content varchar(100),--申请说明
	reback varchar(100),--回复
	yyDate datetime,--考试日期
	status varchar(100)--状态
);

美联英语学员学习管理系统的设计与实现登录后主页

美联英语学员学习管理系统的设计与实现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_pk")
public class Pk {
//主键
@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 Date showDate;
//上课时间段
private String kcDate;
//课程名称
private String kcName;
//上课地点
private String kcAddress;
//老师
private Integer teacherId;
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKcDate() {return kcDate;}
public void setKcDate(String kcDate) {this.kcDate = kcDate;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getKcAddress() {return kcAddress;}
public void setKcAddress(String kcAddress) {this.kcAddress = kcAddress;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}

上课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_sk")
public class Sk {
//主键
@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 pkId;
//学生
private Integer stuId;
//老师
private String teacherName;
//状态
private String status;
//星级
private String xj;
//评价
private String content;
public Integer getPkId() {return pkId;}
public void setPkId(Integer pkId) {this.pkId = pkId;}
public Integer getStuId() {return stuId;}
public void setStuId(Integer stuId) {this.stuId = stuId;}
public String getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getXj() {return xj;}
public void setXj(String xj) {this.xj = xj;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

学员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_stu")
public class Stu {
//主键
@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 stuName;
//年里
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 getStuName() {return stuName;}
public void setStuName(String stuName) {this.stuName = stuName;}
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_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_yy")
public class Yy {
//主键
@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 stuId;
//申请说明
private String content;
//回复
private String reback;
//考试日期
private Date yyDate;
//状态
private String status;
public Integer getStuId() {return stuId;}
public void setStuId(Integer stuId) {this.stuId = stuId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getReback() {return reback;}
public void setReback(String reback) {this.reback = reback;}
public Date getYyDate() {return yyDate;}
public void setYyDate(Date yyDate) {this.yyDate = yyDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

美联英语学员学习管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

排课javaBean创建语句如下:


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

//排课
public class Pk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程日期
private Date showDate;
//上课时间段
private String kcDate;
//课程名称
private String kcName;
//上课地点
private String kcAddress;
//老师
private Integer teacherId;
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKcDate() {return kcDate;}
public void setKcDate(String kcDate) {this.kcDate = kcDate;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getKcAddress() {return kcAddress;}
public void setKcAddress(String kcAddress) {this.kcAddress = kcAddress;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}

上课javaBean创建语句如下:


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

//上课
public class Sk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//排课
private Integer pkId;
//学生
private Integer stuId;
//老师
private String teacherName;
//状态
private String status;
//星级
private String xj;
//评价
private String content;
public Integer getPkId() {return pkId;}
public void setPkId(Integer pkId) {this.pkId = pkId;}
public Integer getStuId() {return stuId;}
public void setStuId(Integer stuId) {this.stuId = stuId;}
public String getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getXj() {return xj;}
public void setXj(String xj) {this.xj = xj;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

学员javaBean创建语句如下:


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

//学员
public class Stu  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 stuName;
//年里
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 getStuName() {return stuName;}
public void setStuName(String stuName) {this.stuName = stuName;}
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 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 Yy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//申请人
private Integer stuId;
//申请说明
private String content;
//回复
private String reback;
//考试日期
private Date yyDate;
//状态
private String status;
public Integer getStuId() {return stuId;}
public void setStuId(Integer stuId) {this.stuId = stuId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getReback() {return reback;}
public void setReback(String reback) {this.reback = reback;}
public Date getYyDate() {return yyDate;}
public void setYyDate(Date yyDate) {this.yyDate = yyDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

源代码下载点这里

评论