- 基于java的教师档案管理系统mysql数据库创建语句
- 基于java的教师档案管理系统oracle数据库创建语句
- 基于java的教师档案管理系统sqlserver数据库创建语句
- 基于java的教师档案管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于java的教师档案管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于java的教师档案管理系统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_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_jxjy(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
zjdw varchar(100) comment '职教单位',
beginDate datetime comment '职教开始日期',
endDate datetime comment '职教集数日期',
remark varchar(100) comment '备注'
) comment '老师教学经验';
档案管理员表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ptadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄'
) comment '档案管理员';
老师获奖荣誉表创建语句如下：
create table t_ry(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
rymc varchar(100) comment '荣誉名称',
showDate datetime comment '获奖日期',
remark varchar(100) comment '备注',
pic 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
birthday varchar(100) comment '生日',
sfz varchar(100) comment '身份证',
email varchar(100) comment '邮箱',
zc varchar(100) comment '职称',
tc varchar(100) comment '特长'
) comment '老师';
基于java的教师档案管理系统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_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_jxjy(
id integer,
teacherId int,
zjdw varchar(100),
beginDate datetime,
endDate datetime,
remark varchar(100)
);
--老师教学经验字段加注释
comment on column t_jxjy.id is '主键';
comment on column t_jxjy.teacherId is '老师';
comment on column t_jxjy.zjdw is '职教单位';
comment on column t_jxjy.beginDate is '职教开始日期';
comment on column t_jxjy.endDate is '职教集数日期';
comment on column t_jxjy.remark is '备注';
--老师教学经验表加注释
comment on table t_jxjy is '老师教学经验';
档案管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
phone varchar(100),
age varchar(100)
);
--档案管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.age is '年龄';
--档案管理员表加注释
comment on table t_ptadmin is '档案管理员';
老师获奖荣誉表创建语句如下：
create table t_ry(
id integer,
teacherId int,
rymc varchar(100),
showDate datetime,
remark varchar(100),
pic varchar(100)
);
--老师获奖荣誉字段加注释
comment on column t_ry.id is '主键';
comment on column t_ry.teacherId is '老师';
comment on column t_ry.rymc is '荣誉名称';
comment on column t_ry.showDate is '获奖日期';
comment on column t_ry.remark is '备注';
comment on column t_ry.pic is '证书拍照';
--老师获奖荣誉表加注释
comment on table t_ry is '老师获奖荣誉';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
birthday varchar(100),
sfz varchar(100),
email varchar(100),
zc varchar(100),
tc 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.headPic is '头像';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.birthday is '生日';
comment on column t_teacher.sfz is '身份证';
comment on column t_teacher.email is '邮箱';
comment on column t_teacher.zc is '职称';
comment on column t_teacher.tc is '特长';
--老师表加注释
comment on table t_teacher is '老师';
oracle特有，对应序列如下：
create sequence s_t_gg;
create sequence s_t_jxjy;
create sequence s_t_ptadmin;
create sequence s_t_ry;
create sequence s_t_teacher;
基于java的教师档案管理系统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_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
cotnent varchar(100),--内容
showDate datetime--日期
);
老师教学经验表创建语句如下：
--老师教学经验表注释
create table t_jxjy(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
zjdw varchar(100),--职教单位
beginDate datetime,--职教开始日期
endDate datetime,--职教集数日期
remark varchar(100)--备注
);
档案管理员表创建语句如下：
--档案管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadminName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100)--年龄
);
老师获奖荣誉表创建语句如下：
--老师获奖荣誉表注释
create table t_ry(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
rymc varchar(100),--荣誉名称
showDate datetime,--获奖日期
remark varchar(100),--备注
pic varchar(100)--证书拍照
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
birthday varchar(100),--生日
sfz varchar(100),--身份证
email varchar(100),--邮箱
zc varchar(100),--职称
tc varchar(100)--特长
);
登录后主页.jpg?x-oss-process=style/00001)
基于java的教师档案管理系统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_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_jxjy")
public class Jxjy {
//主键
@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 zjdw;
//职教开始日期
private Date beginDate;
//职教集数日期
private Date endDate;
//备注
private String remark;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getZjdw() {return zjdw;}
public void setZjdw(String zjdw) {this.zjdw = zjdw;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}档案管理员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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//电话
private String phone;
//年龄
private String age;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}老师获奖荣誉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_ry")
public class Ry {
//主键
@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 rymc;
//获奖日期
private Date showDate;
//备注
private String remark;
//证书拍照
private String pic;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getRymc() {return rymc;}
public void setRymc(String rymc) {this.rymc = rymc;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}老师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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//生日
private String birthday;
//身份证
private String sfz;
//邮箱
private String email;
//职称
private String zc;
//特长
private String tc;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getTc() {return tc;}
public void setTc(String tc) {this.tc = tc;}
}基于java的教师档案管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
公告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 Jxjy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//职教单位
private String zjdw;
//职教开始日期
private Date beginDate;
//职教集数日期
private Date endDate;
//备注
private String remark;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getZjdw() {return zjdw;}
public void setZjdw(String zjdw) {this.zjdw = zjdw;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}档案管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//档案管理员
public class Ptadmin 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 ptadminName;
//电话
private String phone;
//年龄
private String age;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}老师获奖荣誉javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//老师获奖荣誉
public class Ry extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//荣誉名称
private String rymc;
//获奖日期
private Date showDate;
//备注
private String remark;
//证书拍照
private String pic;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getRymc() {return rymc;}
public void setRymc(String rymc) {this.rymc = rymc;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}老师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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//生日
private String birthday;
//身份证
private String sfz;
//邮箱
private String email;
//职称
private String zc;
//特长
private String tc;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getTc() {return tc;}
public void setTc(String tc) {this.tc = tc;}
}