- 教学质量监控系统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_dd(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ddName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '督导';
督导问卷表创建语句如下：
create table t_ddwj(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
ddId int comment '督导',
v1 varchar(100) comment '您对这堂课的评价',
v2 varchar(100) comment '这堂课学生的投入程度',
v3 varchar(100) comment '这堂课老师讲授的够不够深入透彻',
v4 varchar(100) comment '老师在课堂上与学生的互动',
v5 varchar(100) comment '老师在课堂上的综合表现',
content 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_xswj(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
studentId int comment '学生',
v1 varchar(100) comment '你对这堂课的评价',
v2 varchar(100) comment '这堂课你理解掌握的程度',
v3 varchar(100) comment '这堂课老师讲授的够不够深入透彻',
v4 varchar(100) comment '老师对课堂问题的解决方法',
v5 varchar(100) comment '你觉得老师讲授对你学习的帮助',
content 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_dd(
id integer,
username varchar(100),
password varchar(100),
ddName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--督导字段加注释
comment on column t_dd.id is '主键';
comment on column t_dd.username is '账号';
comment on column t_dd.password is '密码';
comment on column t_dd.ddName is '姓名';
comment on column t_dd.phone is '电话';
comment on column t_dd.age is '年龄';
comment on column t_dd.sex is '性别';
--督导表加注释
comment on table t_dd is '督导';
督导问卷表创建语句如下：
create table t_ddwj(
id integer,
teacherId int,
ddId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
content varchar(100)
);
--督导问卷字段加注释
comment on column t_ddwj.id is '主键';
comment on column t_ddwj.teacherId is '老师';
comment on column t_ddwj.ddId is '督导';
comment on column t_ddwj.v1 is '您对这堂课的评价';
comment on column t_ddwj.v2 is '这堂课学生的投入程度';
comment on column t_ddwj.v3 is '这堂课老师讲授的够不够深入透彻';
comment on column t_ddwj.v4 is '老师在课堂上与学生的互动';
comment on column t_ddwj.v5 is '老师在课堂上的综合表现';
comment on column t_ddwj.content is '建议';
--督导问卷表加注释
comment on table t_ddwj 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_xswj(
id integer,
teacherId int,
studentId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
content varchar(100)
);
--学生问卷字段加注释
comment on column t_xswj.id is '主键';
comment on column t_xswj.teacherId is '老师';
comment on column t_xswj.studentId is '学生';
comment on column t_xswj.v1 is '你对这堂课的评价';
comment on column t_xswj.v2 is '这堂课你理解掌握的程度';
comment on column t_xswj.v3 is '这堂课老师讲授的够不够深入透彻';
comment on column t_xswj.v4 is '老师对课堂问题的解决方法';
comment on column t_xswj.v5 is '你觉得老师讲授对你学习的帮助';
comment on column t_xswj.content is '建议';
--学生问卷表加注释
comment on table t_xswj is '学生问卷';
oracle特有，对应序列如下：
create sequence s_t_dd;
create sequence s_t_ddwj;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_xswj;
教学质量监控系统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_dd(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ddName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
督导问卷表创建语句如下：
--督导问卷表注释
create table t_ddwj(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
ddId int,--督导
v1 varchar(100),--您对这堂课的评价
v2 varchar(100),--这堂课学生的投入程度
v3 varchar(100),--这堂课老师讲授的够不够深入透彻
v4 varchar(100),--老师在课堂上与学生的互动
v5 varchar(100),--老师在课堂上的综合表现
content 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_xswj(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
studentId int,--学生
v1 varchar(100),--你对这堂课的评价
v2 varchar(100),--这堂课你理解掌握的程度
v3 varchar(100),--这堂课老师讲授的够不够深入透彻
v4 varchar(100),--老师对课堂问题的解决方法
v5 varchar(100),--你觉得老师讲授对你学习的帮助
content varchar(100)--建议
);
登录后主页.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_dd")
public class Dd {
//主键
@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 ddName;
//电话
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 getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
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_ddwj")
public class Ddwj {
//主键
@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 ddId;
//您对这堂课的评价
private String v1;
//这堂课学生的投入程度
private String v2;
//这堂课老师讲授的够不够深入透彻
private String v3;
//老师在课堂上与学生的互动
private String v4;
//老师在课堂上的综合表现
private String v5;
//建议
private String content;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getDdId() {return ddId;}
public void setDdId(Integer ddId) {this.ddId = ddId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
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_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_xswj")
public class Xswj {
//主键
@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 studentId;
//你对这堂课的评价
private String v1;
//这堂课你理解掌握的程度
private String v2;
//这堂课老师讲授的够不够深入透彻
private String v3;
//老师对课堂问题的解决方法
private String v4;
//你觉得老师讲授对你学习的帮助
private String v5;
//建议
private String content;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}教学质量监控系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
督导javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//督导
public class Dd 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 ddName;
//电话
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 getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
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 Ddwj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//督导
private Integer ddId;
//您对这堂课的评价
private String v1;
//这堂课学生的投入程度
private String v2;
//这堂课老师讲授的够不够深入透彻
private String v3;
//老师在课堂上与学生的互动
private String v4;
//老师在课堂上的综合表现
private String v5;
//建议
private String content;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getDdId() {return ddId;}
public void setDdId(Integer ddId) {this.ddId = ddId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
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 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 Xswj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//学生
private Integer studentId;
//你对这堂课的评价
private String v1;
//这堂课你理解掌握的程度
private String v2;
//这堂课老师讲授的够不够深入透彻
private String v3;
//老师对课堂问题的解决方法
private String v4;
//你觉得老师讲授对你学习的帮助
private String v5;
//建议
private String content;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}