教师管理系统(xba35)_mysql_oracle代码分享

• 教师管理系统mysql数据库创建语句
• 教师管理系统oracle数据库创建语句
• 教师管理系统sqlserver数据库创建语句
• 教师管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 教师管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

教师管理系统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 '标题',
	content text comment '内容',
	showDate datetime comment '显示日期'
) comment '公告';

奖励惩罚表创建语句如下：

create table t_jlcf(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '奖惩名称',
	dj varchar(100) comment '',
	lx varchar(100) comment '',
	jcr varchar(100) comment '奖惩人',
	showDate datetime comment '时间'
) comment '奖励惩罚';

课程表创建语句如下：

create table t_kc(
	id int primary key auto_increment comment '主键',
	kcName varchar(100) comment '课程',
	teacherId int comment '老师',
	skdd varchar(100) comment '上课地点',
	sksj varchar(100) comment '上课时间'
) comment '课程';

科研项目表创建语句如下：

create table t_kyxm(
	id int primary key auto_increment comment '主键',
	kyxmName varchar(100) comment '项目名称',
	xmbh varchar(100) comment '项目编号',
	xmlb varchar(100) comment '项目类别',
	xmfzr varchar(100) comment '项目负责人',
	cyz text comment '项目参与人',
	kycg text comment '科研成果',
	fileUrl varchar(100) comment '附件'
) comment '科研项目';

留言信息表创建语句如下：

create table t_liuyan(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	title varchar(100) comment '标题',
	content text comment '内容',
	insertDate datetime comment '留言日期',
	back text comment '回复',
	status 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 '姓名',
	bh varchar(100) comment '编号',
	sr varchar(100) comment '出生日期',
	mz varchar(100) comment '民族',
	zzmm varchar(100) comment '政治面貌',
	zc varchar(100) comment '职称',
	jzdw varchar(100) comment '就职单位',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex 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_gg(
	id integer,
	title varchar(100),
	content text,
	showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.content is '内容';
comment on column t_gg.showDate is '显示日期';
--公告表加注释
comment on table t_gg is '公告';

奖励惩罚表创建语句如下：

create table t_jlcf(
	id integer,
	title varchar(100),
	dj varchar(100),
	lx varchar(100),
	jcr varchar(100),
	showDate datetime
);
--奖励惩罚字段加注释
comment on column t_jlcf.id is '主键';
comment on column t_jlcf.title is '奖惩名称';
comment on column t_jlcf.dj is '';
comment on column t_jlcf.lx is '';
comment on column t_jlcf.jcr is '奖惩人';
comment on column t_jlcf.showDate is '时间';
--奖励惩罚表加注释
comment on table t_jlcf is '奖励惩罚';

课程表创建语句如下：

create table t_kc(
	id integer,
	kcName varchar(100),
	teacherId int,
	skdd varchar(100),
	sksj varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程';
comment on column t_kc.teacherId is '老师';
comment on column t_kc.skdd is '上课地点';
comment on column t_kc.sksj is '上课时间';
--课程表加注释
comment on table t_kc is '课程';

科研项目表创建语句如下：

create table t_kyxm(
	id integer,
	kyxmName varchar(100),
	xmbh varchar(100),
	xmlb varchar(100),
	xmfzr varchar(100),
	cyz text,
	kycg text,
	fileUrl varchar(100)
);
--科研项目字段加注释
comment on column t_kyxm.id is '主键';
comment on column t_kyxm.kyxmName is '项目名称';
comment on column t_kyxm.xmbh is '项目编号';
comment on column t_kyxm.xmlb is '项目类别';
comment on column t_kyxm.xmfzr is '项目负责人';
comment on column t_kyxm.cyz is '项目参与人';
comment on column t_kyxm.kycg is '科研成果';
comment on column t_kyxm.fileUrl is '附件';
--科研项目表加注释
comment on table t_kyxm is '科研项目';

留言信息表创建语句如下：

create table t_liuyan(
	id integer,
	teacherId int,
	title varchar(100),
	content text,
	insertDate datetime,
	back text,
	status varchar(100)
);
--留言信息字段加注释
comment on column t_liuyan.id is '主键';
comment on column t_liuyan.teacherId is '老师';
comment on column t_liuyan.title is '标题';
comment on column t_liuyan.content is '内容';
comment on column t_liuyan.insertDate is '留言日期';
comment on column t_liuyan.back is '回复';
comment on column t_liuyan.status is '状态';
--留言信息表加注释
comment on table t_liuyan is '留言信息';

老师表创建语句如下：

create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	bh varchar(100),
	sr varchar(100),
	mz varchar(100),
	zzmm varchar(100),
	zc varchar(100),
	jzdw 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.bh is '编号';
comment on column t_teacher.sr is '出生日期';
comment on column t_teacher.mz is '民族';
comment on column t_teacher.zzmm is '政治面貌';
comment on column t_teacher.zc is '职称';
comment on column t_teacher.jzdw 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 '老师';

oracle特有，对应序列如下：

create sequence s_t_gg;
create sequence s_t_jlcf;
create sequence s_t_kc;
create sequence s_t_kyxm;
create sequence s_t_liuyan;
create sequence s_t_teacher;

教师管理系统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),--标题
	content text,--内容
	showDate datetime--显示日期
);

奖励惩罚表创建语句如下：

--奖励惩罚表注释
create table t_jlcf(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--奖惩名称
	dj varchar(100),--
	lx varchar(100),--
	jcr varchar(100),--奖惩人
	showDate datetime--时间
);

课程表创建语句如下：

--课程表注释
create table t_kc(
	id int identity(1,1) primary key not null,--主键
	kcName varchar(100),--课程
	teacherId int,--老师
	skdd varchar(100),--上课地点
	sksj varchar(100)--上课时间
);

科研项目表创建语句如下：

--科研项目表注释
create table t_kyxm(
	id int identity(1,1) primary key not null,--主键
	kyxmName varchar(100),--项目名称
	xmbh varchar(100),--项目编号
	xmlb varchar(100),--项目类别
	xmfzr varchar(100),--项目负责人
	cyz text,--项目参与人
	kycg text,--科研成果
	fileUrl varchar(100)--附件
);

留言信息表创建语句如下：

--留言信息表注释
create table t_liuyan(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	title varchar(100),--标题
	content text,--内容
	insertDate datetime,--留言日期
	back text,--回复
	status varchar(100)--状态
);

老师表创建语句如下：

--老师表注释
create table t_teacher(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	teacherName varchar(100),--姓名
	bh varchar(100),--编号
	sr varchar(100),--出生日期
	mz varchar(100),--民族
	zzmm varchar(100),--政治面貌
	zc varchar(100),--职称
	jzdw varchar(100),--就职单位
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex 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_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 content;
//显示日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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_jlcf")
public class Jlcf {
//主键
@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 dj;
//
private String lx;
//奖惩人
private String jcr;
//时间
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getDj() {return dj;}
public void setDj(String dj) {this.dj = dj;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getJcr() {return jcr;}
public void setJcr(String jcr) {this.jcr = jcr;}
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_kc")
public class Kc {
//主键
@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 kcName;
//老师
private Long teacherId;
//上课地点
private String skdd;
//上课时间
private String sksj;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
}

科研项目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_kyxm")
public class Kyxm {
//主键
@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 kyxmName;
//项目编号
private String xmbh;
//项目类别
private String xmlb;
//项目负责人
private String xmfzr;
//项目参与人
private String cyz;
//科研成果
private String kycg;
//附件
private String fileUrl;
public String getKyxmName() {return kyxmName;}
public void setKyxmName(String kyxmName) {this.kyxmName = kyxmName;}
public String getXmbh() {return xmbh;}
public void setXmbh(String xmbh) {this.xmbh = xmbh;}
public String getXmlb() {return xmlb;}
public void setXmlb(String xmlb) {this.xmlb = xmlb;}
public String getXmfzr() {return xmfzr;}
public void setXmfzr(String xmfzr) {this.xmfzr = xmfzr;}
public String getCyz() {return cyz;}
public void setCyz(String cyz) {this.cyz = cyz;}
public String getKycg() {return kycg;}
public void setKycg(String kycg) {this.kycg = kycg;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}

留言信息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_liuyan")
public class Liuyan {
//主键
@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 Long teacherId;
//标题
private String title;
//内容
private String content;
//留言日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 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_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 bh;
//出生日期
private String sr;
//民族
private String mz;
//政治面貌
private String zzmm;
//职称
private String zc;
//就职单位
private String jzdw;
//电话
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 getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getSr() {return sr;}
public void setSr(String sr) {this.sr = sr;}
public String getMz() {return mz;}
public void setMz(String mz) {this.mz = mz;}
public String getZzmm() {return zzmm;}
public void setZzmm(String zzmm) {this.zzmm = zzmm;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getJzdw() {return jzdw;}
public void setJzdw(String jzdw) {this.jzdw = jzdw;}
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;}
}

教师管理系统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 content;
//显示日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Jlcf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//奖惩名称
private String title;
//
private String dj;
//
private String lx;
//奖惩人
private String jcr;
//时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getDj() {return dj;}
public void setDj(String dj) {this.dj = dj;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getJcr() {return jcr;}
public void setJcr(String jcr) {this.jcr = jcr;}
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 Kc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private String kcName;
//老师
private Long teacherId;
//上课地点
private String skdd;
//上课时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private String sksj;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
}

科研项目javaBean创建语句如下：

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

//科研项目
public class Kyxm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目名称
private String kyxmName;
//项目编号
private String xmbh;
//项目类别
private String xmlb;
//项目负责人
private String xmfzr;
//项目参与人
private String cyz;
//科研成果
private String kycg;
//附件
private String fileUrl;
public String getKyxmName() {return kyxmName;}
public void setKyxmName(String kyxmName) {this.kyxmName = kyxmName;}
public String getXmbh() {return xmbh;}
public void setXmbh(String xmbh) {this.xmbh = xmbh;}
public String getXmlb() {return xmlb;}
public void setXmlb(String xmlb) {this.xmlb = xmlb;}
public String getXmfzr() {return xmfzr;}
public void setXmfzr(String xmfzr) {this.xmfzr = xmfzr;}
public String getCyz() {return cyz;}
public void setCyz(String cyz) {this.cyz = cyz;}
public String getKycg() {return kycg;}
public void setKycg(String kycg) {this.kycg = kycg;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}

留言信息javaBean创建语句如下：

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

//留言信息
public class Liuyan  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//标题
private String title;
//内容
private String content;
//留言日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 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 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 bh;
//出生日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private String sr;
//民族
private String mz;
//政治面貌
private String zzmm;
//职称
private String zc;
//就职单位
private String jzdw;
//电话
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 getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getSr() {return sr;}
public void setSr(String sr) {this.sr = sr;}
public String getMz() {return mz;}
public void setMz(String mz) {this.mz = mz;}
public String getZzmm() {return zzmm;}
public void setZzmm(String zzmm) {this.zzmm = zzmm;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getJzdw() {return jzdw;}
public void setJzdw(String jzdw) {this.jzdw = jzdw;}
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;}
}