基于Web的企业员工经验库管理系统的设计与实现

基于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_jy(
	id int primary key auto_increment comment '主键',
	ygId int comment '员工',
	jyName varchar(100) comment '名称',
	content varchar(100) comment '内容',
	fileUrl varchar(100) comment '文件',
	showDate datetime comment '日期'
) comment '经验';

经验订阅表创建语句如下:


create table t_jydy(
	id int primary key auto_increment comment '主键',
	jyId int comment '经验',
	ygId int comment '员工'
) comment '经验订阅';

经验评论表创建语句如下:


create table t_jypl(
	id int primary key auto_increment comment '主键',
	jyId int comment '经验',
	ygId int comment '员工',
	content varchar(100) comment '评论内容',
	insertDate datetime comment '日期'
) comment '经验评论';

经验更新推送表创建语句如下:


create table t_jyts(
	id int primary key auto_increment comment '主键',
	jyId int comment '经验',
	ygId int comment '员工',
	insertDate datetime comment '日期',
	types varchar(100) comment '类型'
) comment '经验更新推送';

学习计划表创建语句如下:


create table t_xxjh(
	id int primary key auto_increment comment '主键',
	ygId int comment '员工',
	xxjhName varchar(100) comment '名称',
	content varchar(100) comment '内容',
	fileUrl varchar(100) comment '文件',
	showDate varchar(100) comment '添加日期',
	wcd varchar(100) comment '完成度'
) comment '学习计划';

员工表创建语句如下:


create table t_yg(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	gh varchar(100) comment '工号',
	ygName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic 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_jy(
	id integer,
	ygId int,
	jyName varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	showDate datetime
);
--经验字段加注释
comment on column t_jy.id is '主键';
comment on column t_jy.ygId is '员工';
comment on column t_jy.jyName is '名称';
comment on column t_jy.content is '内容';
comment on column t_jy.fileUrl is '文件';
comment on column t_jy.showDate is '日期';
--经验表加注释
comment on table t_jy is '经验';

经验订阅表创建语句如下:


create table t_jydy(
	id integer,
	jyId int,
	ygId int
);
--经验订阅字段加注释
comment on column t_jydy.id is '主键';
comment on column t_jydy.jyId is '经验';
comment on column t_jydy.ygId is '员工';
--经验订阅表加注释
comment on table t_jydy is '经验订阅';

经验评论表创建语句如下:


create table t_jypl(
	id integer,
	jyId int,
	ygId int,
	content varchar(100),
	insertDate datetime
);
--经验评论字段加注释
comment on column t_jypl.id is '主键';
comment on column t_jypl.jyId is '经验';
comment on column t_jypl.ygId is '员工';
comment on column t_jypl.content is '评论内容';
comment on column t_jypl.insertDate is '日期';
--经验评论表加注释
comment on table t_jypl is '经验评论';

经验更新推送表创建语句如下:


create table t_jyts(
	id integer,
	jyId int,
	ygId int,
	insertDate datetime,
	types varchar(100)
);
--经验更新推送字段加注释
comment on column t_jyts.id is '主键';
comment on column t_jyts.jyId is '经验';
comment on column t_jyts.ygId is '员工';
comment on column t_jyts.insertDate is '日期';
comment on column t_jyts.types is '类型';
--经验更新推送表加注释
comment on table t_jyts is '经验更新推送';

学习计划表创建语句如下:


create table t_xxjh(
	id integer,
	ygId int,
	xxjhName varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	showDate varchar(100),
	wcd varchar(100)
);
--学习计划字段加注释
comment on column t_xxjh.id is '主键';
comment on column t_xxjh.ygId is '员工';
comment on column t_xxjh.xxjhName is '名称';
comment on column t_xxjh.content is '内容';
comment on column t_xxjh.fileUrl is '文件';
comment on column t_xxjh.showDate is '添加日期';
comment on column t_xxjh.wcd is '完成度';
--学习计划表加注释
comment on table t_xxjh is '学习计划';

员工表创建语句如下:


create table t_yg(
	id integer,
	username varchar(100),
	password varchar(100),
	gh varchar(100),
	ygName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100)
);
--员工字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.username is '账号';
comment on column t_yg.password is '密码';
comment on column t_yg.gh is '工号';
comment on column t_yg.ygName is '姓名';
comment on column t_yg.age is '年龄';
comment on column t_yg.sex is '性别';
comment on column t_yg.phone is '电话';
comment on column t_yg.pic is '头像';
--员工表加注释
comment on table t_yg is '员工';

oracle特有,对应序列如下:


create sequence s_t_jy;
create sequence s_t_jydy;
create sequence s_t_jypl;
create sequence s_t_jyts;
create sequence s_t_xxjh;
create sequence s_t_yg;

基于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_jy(
	id int identity(1,1) primary key not null,--主键
	ygId int,--员工
	jyName varchar(100),--名称
	content varchar(100),--内容
	fileUrl varchar(100),--文件
	showDate datetime--日期
);

经验订阅表创建语句如下:


--经验订阅表注释
create table t_jydy(
	id int identity(1,1) primary key not null,--主键
	jyId int,--经验
	ygId int--员工
);

经验评论表创建语句如下:


--经验评论表注释
create table t_jypl(
	id int identity(1,1) primary key not null,--主键
	jyId int,--经验
	ygId int,--员工
	content varchar(100),--评论内容
	insertDate datetime--日期
);

经验更新推送表创建语句如下:


--经验更新推送表注释
create table t_jyts(
	id int identity(1,1) primary key not null,--主键
	jyId int,--经验
	ygId int,--员工
	insertDate datetime,--日期
	types varchar(100)--类型
);

学习计划表创建语句如下:


--学习计划表注释
create table t_xxjh(
	id int identity(1,1) primary key not null,--主键
	ygId int,--员工
	xxjhName varchar(100),--名称
	content varchar(100),--内容
	fileUrl varchar(100),--文件
	showDate varchar(100),--添加日期
	wcd varchar(100)--完成度
);

员工表创建语句如下:


--员工表注释
create table t_yg(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	gh varchar(100),--工号
	ygName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic 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_jy")
public class Jy {
//主键
@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 ygId;
//名称
private String jyName;
//内容
private String content;
//文件
private String fileUrl;
//日期
private Date showDate;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public String getJyName() {return jyName;}
public void setJyName(String jyName) {this.jyName = jyName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_jydy")
public class Jydy {
//主键
@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 jyId;
//员工
private Integer ygId;
public Integer getJyId() {return jyId;}
public void setJyId(Integer jyId) {this.jyId = jyId;}
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
}

经验评论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_jypl")
public class Jypl {
//主键
@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 jyId;
//员工
private Integer ygId;
//评论内容
private String content;
//日期
private Date insertDate;
public Integer getJyId() {return jyId;}
public void setJyId(Integer jyId) {this.jyId = jyId;}
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
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_jyts")
public class Jyts {
//主键
@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 jyId;
//员工
private Integer ygId;
//日期
private Date insertDate;
//类型
private String types;
public Integer getJyId() {return jyId;}
public void setJyId(Integer jyId) {this.jyId = jyId;}
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}

学习计划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_xxjh")
public class Xxjh {
//主键
@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 ygId;
//名称
private String xxjhName;
//内容
private String content;
//文件
private String fileUrl;
//添加日期
private String showDate;
//完成度
private String wcd;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public String getXxjhName() {return xxjhName;}
public void setXxjhName(String xxjhName) {this.xxjhName = xxjhName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getWcd() {return wcd;}
public void setWcd(String wcd) {this.wcd = wcd;}
}

员工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_yg")
public class Yg {
//主键
@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 gh;
//姓名
private String ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

基于Web的企业员工经验库管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

经验javaBean创建语句如下:


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

//经验
public class Jy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer ygId;
//名称
private String jyName;
//内容
private String content;
//文件
private String fileUrl;
//日期
private Date showDate;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public String getJyName() {return jyName;}
public void setJyName(String jyName) {this.jyName = jyName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Jydy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//经验
private Integer jyId;
//员工
private Integer ygId;
public Integer getJyId() {return jyId;}
public void setJyId(Integer jyId) {this.jyId = jyId;}
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
}

经验评论javaBean创建语句如下:


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

//经验评论
public class Jypl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//经验
private Integer jyId;
//员工
private Integer ygId;
//评论内容
private String content;
//日期
private Date insertDate;
public Integer getJyId() {return jyId;}
public void setJyId(Integer jyId) {this.jyId = jyId;}
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
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 Jyts  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//经验
private Integer jyId;
//员工
private Integer ygId;
//日期
private Date insertDate;
//类型
private String types;
public Integer getJyId() {return jyId;}
public void setJyId(Integer jyId) {this.jyId = jyId;}
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}

学习计划javaBean创建语句如下:


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

//学习计划
public class Xxjh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer ygId;
//名称
private String xxjhName;
//内容
private String content;
//文件
private String fileUrl;
//添加日期
private String showDate;
//完成度
private String wcd;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public String getXxjhName() {return xxjhName;}
public void setXxjhName(String xxjhName) {this.xxjhName = xxjhName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getWcd() {return wcd;}
public void setWcd(String wcd) {this.wcd = wcd;}
}

员工javaBean创建语句如下:


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

//员工
public class Yg  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 gh;
//姓名
private String ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

源代码下载点这里

评论