基于WEB的教师信息管理系统,毕业设计java

基于WEB的教师信息管理系统登录注册界面

基于WEB的教师信息管理系统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_dj(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	djName varchar(100) comment '得奖名称',
	djContent varchar(100) comment '得奖描述',
	djPic varchar(100) comment '得奖图片',
	djDate varchar(100) comment '得奖日期'
) comment '老师得奖记录';

老师教课记录表创建语句如下:


create table t_jk(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	jkDayBegin varchar(100) comment '教课开始时间',
	jkDayEnd varchar(100) comment '教课结束时间',
	jkAddress varchar(100) comment '教课地点',
	jkName varchar(100) comment '教课学校',
	jkClass varchar(100) comment '教课班级',
	jkxd varchar(100) comment '教课心得'
) comment '老师教课记录';

校领导表创建语句如下:


create table t_ld(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ldName varchar(100) comment '姓名',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	phone varchar(100) comment '电话',
	idcard varchar(100) comment '身份证'
) comment '校领导';

校领导评语表创建语句如下:


create table t_pingyu(
	id int primary key auto_increment comment '主键',
	ld int comment '校领导',
	pyDate varchar(100) comment '评语时间',
	pyContent varchar(100) comment '评语内容',
	teacherId int comment '老师'
) comment '校领导评语';

老师日志表创建语句如下:


create table t_rz(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	rzTitle varchar(100) comment '日志标题',
	rzContent varchar(100) comment '内容',
	rzDate datetime 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 '姓名',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	phone varchar(100) comment '电话',
	idcard varchar(100) comment '身份证'
) comment '老师';

基于WEB的教师信息管理系统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_dj(
	id integer,
	teacherId int,
	djName varchar(100),
	djContent varchar(100),
	djPic varchar(100),
	djDate varchar(100)
);
--老师得奖记录字段加注释
comment on column t_dj.id is '主键';
comment on column t_dj.teacherId is '老师';
comment on column t_dj.djName is '得奖名称';
comment on column t_dj.djContent is '得奖描述';
comment on column t_dj.djPic is '得奖图片';
comment on column t_dj.djDate is '得奖日期';
--老师得奖记录表加注释
comment on table t_dj is '老师得奖记录';

老师教课记录表创建语句如下:


create table t_jk(
	id integer,
	teacherId int,
	jkDayBegin varchar(100),
	jkDayEnd varchar(100),
	jkAddress varchar(100),
	jkName varchar(100),
	jkClass varchar(100),
	jkxd varchar(100)
);
--老师教课记录字段加注释
comment on column t_jk.id is '主键';
comment on column t_jk.teacherId is '老师';
comment on column t_jk.jkDayBegin is '教课开始时间';
comment on column t_jk.jkDayEnd is '教课结束时间';
comment on column t_jk.jkAddress is '教课地点';
comment on column t_jk.jkName is '教课学校';
comment on column t_jk.jkClass is '教课班级';
comment on column t_jk.jkxd is '教课心得';
--老师教课记录表加注释
comment on table t_jk is '老师教课记录';

校领导表创建语句如下:


create table t_ld(
	id integer,
	username varchar(100),
	password varchar(100),
	ldName varchar(100),
	sex varchar(100),
	age varchar(100),
	phone varchar(100),
	idcard varchar(100)
);
--校领导字段加注释
comment on column t_ld.id is '主键';
comment on column t_ld.username is '账号';
comment on column t_ld.password is '密码';
comment on column t_ld.ldName is '姓名';
comment on column t_ld.sex is '性别';
comment on column t_ld.age is '年龄';
comment on column t_ld.phone is '电话';
comment on column t_ld.idcard is '身份证';
--校领导表加注释
comment on table t_ld is '校领导';

校领导评语表创建语句如下:


create table t_pingyu(
	id integer,
	ld int,
	pyDate varchar(100),
	pyContent varchar(100),
	teacherId int
);
--校领导评语字段加注释
comment on column t_pingyu.id is '主键';
comment on column t_pingyu.ld is '校领导';
comment on column t_pingyu.pyDate is '评语时间';
comment on column t_pingyu.pyContent is '评语内容';
comment on column t_pingyu.teacherId is '老师';
--校领导评语表加注释
comment on table t_pingyu is '校领导评语';

老师日志表创建语句如下:


create table t_rz(
	id integer,
	teacherId int,
	rzTitle varchar(100),
	rzContent varchar(100),
	rzDate datetime
);
--老师日志字段加注释
comment on column t_rz.id is '主键';
comment on column t_rz.teacherId is '老师';
comment on column t_rz.rzTitle is '日志标题';
comment on column t_rz.rzContent is '内容';
comment on column t_rz.rzDate is '时间';
--老师日志表加注释
comment on table t_rz is '老师日志';

老师表创建语句如下:


create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	sex varchar(100),
	age varchar(100),
	phone varchar(100),
	idcard 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.sex is '性别';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.idcard is '身份证';
--老师表加注释
comment on table t_teacher is '老师';

oracle特有,对应序列如下:


create sequence s_t_dj;
create sequence s_t_jk;
create sequence s_t_ld;
create sequence s_t_pingyu;
create sequence s_t_rz;
create sequence s_t_teacher;

基于WEB的教师信息管理系统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_dj(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	djName varchar(100),--得奖名称
	djContent varchar(100),--得奖描述
	djPic varchar(100),--得奖图片
	djDate varchar(100)--得奖日期
);

老师教课记录表创建语句如下:


--老师教课记录表注释
create table t_jk(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	jkDayBegin varchar(100),--教课开始时间
	jkDayEnd varchar(100),--教课结束时间
	jkAddress varchar(100),--教课地点
	jkName varchar(100),--教课学校
	jkClass varchar(100),--教课班级
	jkxd varchar(100)--教课心得
);

校领导表创建语句如下:


--校领导表注释
create table t_ld(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ldName varchar(100),--姓名
	sex varchar(100),--性别
	age varchar(100),--年龄
	phone varchar(100),--电话
	idcard varchar(100)--身份证
);

校领导评语表创建语句如下:


--校领导评语表注释
create table t_pingyu(
	id int identity(1,1) primary key not null,--主键
	ld int,--校领导
	pyDate varchar(100),--评语时间
	pyContent varchar(100),--评语内容
	teacherId int--老师
);

老师日志表创建语句如下:


--老师日志表注释
create table t_rz(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	rzTitle varchar(100),--日志标题
	rzContent varchar(100),--内容
	rzDate datetime--时间
);

老师表创建语句如下:


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

基于WEB的教师信息管理系统登录后主页

基于WEB的教师信息管理系统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_dj")
public class Dj {
//主键
@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 String djName;
//得奖描述
private String djContent;
//得奖图片
private String djPic;
//得奖日期
private String djDate;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getDjName() {return djName;}
public void setDjName(String djName) {this.djName = djName;}
public String getDjContent() {return djContent;}
public void setDjContent(String djContent) {this.djContent = djContent;}
public String getDjPic() {return djPic;}
public void setDjPic(String djPic) {this.djPic = djPic;}
public String getDjDate() {return djDate;}
public void setDjDate(String djDate) {this.djDate = djDate;}
}

老师教课记录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_jk")
public class Jk {
//主键
@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 String jkDayBegin;
//教课结束时间
private String jkDayEnd;
//教课地点
private String jkAddress;
//教课学校
private String jkName;
//教课班级
private String jkClass;
//教课心得
private String jkxd;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getJkDayBegin() {return jkDayBegin;}
public void setJkDayBegin(String jkDayBegin) {this.jkDayBegin = jkDayBegin;}
public String getJkDayEnd() {return jkDayEnd;}
public void setJkDayEnd(String jkDayEnd) {this.jkDayEnd = jkDayEnd;}
public String getJkAddress() {return jkAddress;}
public void setJkAddress(String jkAddress) {this.jkAddress = jkAddress;}
public String getJkName() {return jkName;}
public void setJkName(String jkName) {this.jkName = jkName;}
public String getJkClass() {return jkClass;}
public void setJkClass(String jkClass) {this.jkClass = jkClass;}
public String getJkxd() {return jkxd;}
public void setJkxd(String jkxd) {this.jkxd = jkxd;}
}

校领导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_ld")
public class Ld {
//主键
@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 ldName;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
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 getLdName() {return ldName;}
public void setLdName(String ldName) {this.ldName = ldName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

校领导评语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_pingyu")
public class Pingyu {
//主键
@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 ld;
//评语时间
private String pyDate;
//评语内容
private String pyContent;
//老师
private Integer teacherId;
public Integer getLd() {return ld;}
public void setLd(Integer ld) {this.ld = ld;}
public String getPyDate() {return pyDate;}
public void setPyDate(String pyDate) {this.pyDate = pyDate;}
public String getPyContent() {return pyContent;}
public void setPyContent(String pyContent) {this.pyContent = pyContent;}
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_rz")
public class Rz {
//主键
@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 String rzTitle;
//内容
private String rzContent;
//时间
private Date rzDate;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getRzTitle() {return rzTitle;}
public void setRzTitle(String rzTitle) {this.rzTitle = rzTitle;}
public String getRzContent() {return rzContent;}
public void setRzContent(String rzContent) {this.rzContent = rzContent;}
public Date getRzDate() {return rzDate;}
public void setRzDate(Date rzDate) {this.rzDate = rzDate;}
}

老师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 sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

基于WEB的教师信息管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

老师得奖记录javaBean创建语句如下:


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

//老师得奖记录
public class Dj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//得奖名称
private String djName;
//得奖描述
private String djContent;
//得奖图片
private String djPic;
//得奖日期
private String djDate;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getDjName() {return djName;}
public void setDjName(String djName) {this.djName = djName;}
public String getDjContent() {return djContent;}
public void setDjContent(String djContent) {this.djContent = djContent;}
public String getDjPic() {return djPic;}
public void setDjPic(String djPic) {this.djPic = djPic;}
public String getDjDate() {return djDate;}
public void setDjDate(String djDate) {this.djDate = djDate;}
}

老师教课记录javaBean创建语句如下:


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

//老师教课记录
public class Jk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//教课开始时间
private String jkDayBegin;
//教课结束时间
private String jkDayEnd;
//教课地点
private String jkAddress;
//教课学校
private String jkName;
//教课班级
private String jkClass;
//教课心得
private String jkxd;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getJkDayBegin() {return jkDayBegin;}
public void setJkDayBegin(String jkDayBegin) {this.jkDayBegin = jkDayBegin;}
public String getJkDayEnd() {return jkDayEnd;}
public void setJkDayEnd(String jkDayEnd) {this.jkDayEnd = jkDayEnd;}
public String getJkAddress() {return jkAddress;}
public void setJkAddress(String jkAddress) {this.jkAddress = jkAddress;}
public String getJkName() {return jkName;}
public void setJkName(String jkName) {this.jkName = jkName;}
public String getJkClass() {return jkClass;}
public void setJkClass(String jkClass) {this.jkClass = jkClass;}
public String getJkxd() {return jkxd;}
public void setJkxd(String jkxd) {this.jkxd = jkxd;}
}

校领导javaBean创建语句如下:


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

//校领导
public class Ld  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 ldName;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
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 getLdName() {return ldName;}
public void setLdName(String ldName) {this.ldName = ldName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

校领导评语javaBean创建语句如下:


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

//校领导评语
public class Pingyu  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//校领导
private Integer ld;
//评语时间
private String pyDate;
//评语内容
private String pyContent;
//老师
private Integer teacherId;
public Integer getLd() {return ld;}
public void setLd(Integer ld) {this.ld = ld;}
public String getPyDate() {return pyDate;}
public void setPyDate(String pyDate) {this.pyDate = pyDate;}
public String getPyContent() {return pyContent;}
public void setPyContent(String pyContent) {this.pyContent = pyContent;}
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 Rz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//日志标题
private String rzTitle;
//内容
private String rzContent;
//时间
private Date rzDate;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getRzTitle() {return rzTitle;}
public void setRzTitle(String rzTitle) {this.rzTitle = rzTitle;}
public String getRzContent() {return rzContent;}
public void setRzContent(String rzContent) {this.rzContent = rzContent;}
public Date getRzDate() {return rzDate;}
public void setRzDate(Date rzDate) {this.rzDate = rzDate;}
}

老师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 sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

源代码下载点这里

评论