- 高校教师网上职称申报系统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_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '发起日期'
) comment '公告';
留言表创建语句如下：
create table t_ly(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
content text comment '内容',
insertDate datetime comment '发起日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '留言';
职称申报评审表创建语句如下：
create table t_order(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
xm varchar(100) comment '姓名',
sex varchar(100) comment '',
nl varchar(100) comment '年龄',
zjlx varchar(100) comment '',
zjhm varchar(100) comment '证件号码',
rzsj text comment '任职时间',
cfile1 varchar(100) comment '发表的文章',
cfile2 varchar(100) comment '科研项目',
cfile3 varchar(100) comment '获得的奖励',
status varchar(100) comment '状态',
insertDate datetime comment '发起日期',
back text comment '回复',
gs text 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 '',
status varchar(100) comment ''
) comment '老师';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
title varchar(100) comment '内容',
insertDate datetime 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_gonggao(
id integer,
title varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发起日期';
--公告表加注释
comment on table t_gonggao is '公告';
留言表创建语句如下：
create table t_ly(
id integer,
teacherId int,
content text,
insertDate datetime,
back text,
status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.teacherId is '老师';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';
职称申报评审表创建语句如下：
create table t_order(
id integer,
teacherId int,
xm varchar(100),
sex varchar(100),
nl varchar(100),
zjlx varchar(100),
zjhm varchar(100),
rzsj text,
cfile1 varchar(100),
cfile2 varchar(100),
cfile3 varchar(100),
status varchar(100),
insertDate datetime,
back text,
gs text
);
--职称申报评审字段加注释
comment on column t_order.id is '主键';
comment on column t_order.teacherId is '老师';
comment on column t_order.xm is '姓名';
comment on column t_order.sex is '';
comment on column t_order.nl is '年龄';
comment on column t_order.zjlx is '';
comment on column t_order.zjhm is '证件号码';
comment on column t_order.rzsj is '任职时间';
comment on column t_order.cfile1 is '发表的文章';
comment on column t_order.cfile2 is '科研项目';
comment on column t_order.cfile3 is '获得的奖励';
comment on column t_order.status is '状态';
comment on column t_order.insertDate is '发起日期';
comment on column t_order.back is '回复';
comment on column t_order.gs is '公示表';
--职称申报评审表加注释
comment on table t_order 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),
status 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 column t_teacher.status is '';
--老师表加注释
comment on table t_teacher is '老师';
通知表创建语句如下：
create table t_tongzhi(
id integer,
teacherId int,
title varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.teacherId is '老师';
comment on column t_tongzhi.title is '内容';
comment on column t_tongzhi.insertDate is '发起日期';
--通知表加注释
comment on table t_tongzhi is '通知';
oracle特有，对应序列如下：
create sequence s_t_gonggao;
create sequence s_t_ly;
create sequence s_t_order;
create sequence s_t_teacher;
create sequence s_t_tongzhi;
高校教师网上职称申报系统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_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--发起日期
);
留言表创建语句如下：
--留言表注释
create table t_ly(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
content text,--内容
insertDate datetime,--发起日期
back text,--回复
status varchar(100)--状态
);
职称申报评审表创建语句如下：
--职称申报评审表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
xm varchar(100),--姓名
sex varchar(100),--
nl varchar(100),--年龄
zjlx varchar(100),--
zjhm varchar(100),--证件号码
rzsj text,--任职时间
cfile1 varchar(100),--发表的文章
cfile2 varchar(100),--科研项目
cfile3 varchar(100),--获得的奖励
status varchar(100),--状态
insertDate datetime,--发起日期
back text,--回复
gs text--公示表
);
老师表创建语句如下：
--老师表注释
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),--
status varchar(100)--
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
title varchar(100),--内容
insertDate datetime--发起日期
);
登录后主页.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_gonggao")
public class Gonggao {
//主键
@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 insertDate;
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;}
}留言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_ly")
public class Ly {
//主键
@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 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 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_order")
public class Order {
//主键
@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 xm;
//
private String sex;
//年龄
private String nl;
//
private String zjlx;
//证件号码
private String zjhm;
//任职时间
private String rzsj;
//发表的文章
private String cfile1;
//科研项目
private String cfile2;
//获得的奖励
private String cfile3;
//状态
private String status;
//发起日期
private Date insertDate;
//回复
private String back;
//公示表
private String gs;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getNl() {return nl;}
public void setNl(String nl) {this.nl = nl;}
public String getZjlx() {return zjlx;}
public void setZjlx(String zjlx) {this.zjlx = zjlx;}
public String getZjhm() {return zjhm;}
public void setZjhm(String zjhm) {this.zjhm = zjhm;}
public String getRzsj() {return rzsj;}
public void setRzsj(String rzsj) {this.rzsj = rzsj;}
public String getCfile1() {return cfile1;}
public void setCfile1(String cfile1) {this.cfile1 = cfile1;}
public String getCfile2() {return cfile2;}
public void setCfile2(String cfile2) {this.cfile2 = cfile2;}
public String getCfile3() {return cfile3;}
public void setCfile3(String cfile3) {this.cfile3 = cfile3;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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 getGs() {return gs;}
public void setGs(String gs) {this.gs = gs;}
}老师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;
//
private String status;
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;}
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_tongzhi")
public class Tongzhi {
//主键
@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 Date insertDate;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}高校教师网上职称申报系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gonggao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
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;}
}留言javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言
public class Ly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//内容
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 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 Order extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//姓名
private String xm;
//
private String sex;
//年龄
private String nl;
//
private String zjlx;
//证件号码
private String zjhm;
//任职时间
private String rzsj;
//发表的文章
private String cfile1;
//科研项目
private String cfile2;
//获得的奖励
private String cfile3;
//状态
private String status;
//发起日期
private Date insertDate;
//回复
private String back;
//公示表
private String gs;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getNl() {return nl;}
public void setNl(String nl) {this.nl = nl;}
public String getZjlx() {return zjlx;}
public void setZjlx(String zjlx) {this.zjlx = zjlx;}
public String getZjhm() {return zjhm;}
public void setZjhm(String zjhm) {this.zjhm = zjhm;}
public String getRzsj() {return rzsj;}
public void setRzsj(String rzsj) {this.rzsj = rzsj;}
public String getCfile1() {return cfile1;}
public void setCfile1(String cfile1) {this.cfile1 = cfile1;}
public String getCfile2() {return cfile2;}
public void setCfile2(String cfile2) {this.cfile2 = cfile2;}
public String getCfile3() {return cfile3;}
public void setCfile3(String cfile3) {this.cfile3 = cfile3;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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 getGs() {return gs;}
public void setGs(String gs) {this.gs = gs;}
}老师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;
//
private String status;
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;}
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 Tongzhi 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 Date insertDate;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}