专家库管理系统的设计与开发

专家酬金管理系统

要提供一个可以实现对专家等信息管理的同时还可以生成自定义报表的系统。通过人员竞赛信息录入、人员酬金计算、自定义项目报表生成的信息管理等功能模块来实现专家库的综合管理。系统采用B/S开发模式,开发工具选择JAVA、JSP、JavaScript、Html语言,采用Tomcat服务器技术,后台数据库选用My SQL。基于目前报表插件无法实现的功能,开发出一个具有自定义编辑数据库信息功能的组件的一套信息管理系统,实现了信息管理的高效性与安全性。本系统可以让用户在前端方便快捷地实现库管理中各种报表的生成与设计、管理人员数据库信息、计算项目酬金等操作,该系统不仅仅是一个信息管理系统,更是一个报表自定义设计系统。

专家库管理系统的设计与开发登录注册界面

专家库管理系统的设计与开发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_bsxm(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '比赛名称',
	v2 varchar(100) comment '组织机构',
	v3 varchar(100) comment '联系电话'
) comment '比赛项目';

专家酬金计算表创建语句如下:


create table t_cj(
	id int primary key auto_increment comment '主键',
	zjId int comment '专家',
	xmbh varchar(100) comment '项目编号',
	title varchar(100) comment '标题',
	bl varchar(100) comment '比例',
	fee int comment '酬金额'
) comment '专家酬金计算';

会议信息表创建语句如下:


create table t_hyxx(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '会议名称',
	v2 int 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '普通管理员';

人员表创建语句如下:


create table t_ry(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '姓名',
	v2 varchar(100) comment '身份证号',
	v3 varchar(100) comment '银行卡号',
	v4 varchar(100) comment '开户行',
	v5 varchar(100) comment '手机号',
	v6 varchar(100) comment '部门',
	v7 varchar(100) comment '工作单位',
	v8 int comment '酬金(每天)',
	v9 varchar(100) comment '工资代码',
	v10 varchar(100) comment '人员属性'
) comment '人员';

税率表创建语句如下:


create table t_sl(
	id int primary key auto_increment comment '主键',
	v1 double comment '税率'
) comment '税率';

专家表创建语句如下:


create table t_zj(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	zjName varchar(100) comment '姓名',
	gh varchar(100) comment '工号',
	zw varchar(100) comment '职务',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone 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_bsxm(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--比赛项目字段加注释
comment on column t_bsxm.id is '主键';
comment on column t_bsxm.v1 is '比赛名称';
comment on column t_bsxm.v2 is '组织机构';
comment on column t_bsxm.v3 is '联系电话';
--比赛项目表加注释
comment on table t_bsxm is '比赛项目';

专家酬金计算表创建语句如下:


create table t_cj(
	id integer,
	zjId int,
	xmbh varchar(100),
	title varchar(100),
	bl varchar(100),
	fee int
);
--专家酬金计算字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.zjId is '专家';
comment on column t_cj.xmbh is '项目编号';
comment on column t_cj.title is '标题';
comment on column t_cj.bl is '比例';
comment on column t_cj.fee is '酬金额';
--专家酬金计算表加注释
comment on table t_cj is '专家酬金计算';

会议信息表创建语句如下:


create table t_hyxx(
	id integer,
	v1 varchar(100),
	v2 int
);
--会议信息字段加注释
comment on column t_hyxx.id is '主键';
comment on column t_hyxx.v1 is '会议名称';
comment on column t_hyxx.v2 is '天数';
--会议信息表加注释
comment on table t_hyxx is '会议信息';

普通管理员表创建语句如下:


create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone 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.age is '年龄';
comment on column t_ptadmin.sex is '性别';
comment on column t_ptadmin.phone is '电话';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';

人员表创建语句如下:


create table t_ry(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100),
	v8 int,
	v9 varchar(100),
	v10 varchar(100)
);
--人员字段加注释
comment on column t_ry.id is '主键';
comment on column t_ry.v1 is '姓名';
comment on column t_ry.v2 is '身份证号';
comment on column t_ry.v3 is '银行卡号';
comment on column t_ry.v4 is '开户行';
comment on column t_ry.v5 is '手机号';
comment on column t_ry.v6 is '部门';
comment on column t_ry.v7 is '工作单位';
comment on column t_ry.v8 is '酬金(每天)';
comment on column t_ry.v9 is '工资代码';
comment on column t_ry.v10 is '人员属性';
--人员表加注释
comment on table t_ry is '人员';

税率表创建语句如下:


create table t_sl(
	id integer,
	v1 double
);
--税率字段加注释
comment on column t_sl.id is '主键';
comment on column t_sl.v1 is '税率';
--税率表加注释
comment on table t_sl is '税率';

专家表创建语句如下:


create table t_zj(
	id integer,
	username varchar(100),
	password varchar(100),
	zjName varchar(100),
	gh varchar(100),
	zw varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--专家字段加注释
comment on column t_zj.id is '主键';
comment on column t_zj.username is '账号';
comment on column t_zj.password is '密码 ';
comment on column t_zj.zjName is '姓名';
comment on column t_zj.gh is '工号';
comment on column t_zj.zw is '职务';
comment on column t_zj.age is '年龄';
comment on column t_zj.sex is '性别';
comment on column t_zj.phone is '电话';
--专家表加注释
comment on table t_zj is '专家';

oracle特有,对应序列如下:


create sequence s_t_bsxm;
create sequence s_t_cj;
create sequence s_t_hyxx;
create sequence s_t_ptadmin;
create sequence s_t_ry;
create sequence s_t_sl;
create sequence s_t_zj;

专家库管理系统的设计与开发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_bsxm(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--比赛名称
	v2 varchar(100),--组织机构
	v3 varchar(100)--联系电话
);

专家酬金计算表创建语句如下:


--专家酬金计算表注释
create table t_cj(
	id int identity(1,1) primary key not null,--主键
	zjId int,--专家
	xmbh varchar(100),--项目编号
	title varchar(100),--标题
	bl varchar(100),--比例
	fee int--酬金额
);

会议信息表创建语句如下:


--会议信息表注释
create table t_hyxx(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--会议名称
	v2 int--天数
);

普通管理员表创建语句如下:


--普通管理员表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	ptadminName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

人员表创建语句如下:


--人员表注释
create table t_ry(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--姓名
	v2 varchar(100),--身份证号
	v3 varchar(100),--银行卡号
	v4 varchar(100),--开户行
	v5 varchar(100),--手机号
	v6 varchar(100),--部门
	v7 varchar(100),--工作单位
	v8 int,--酬金(每天)
	v9 varchar(100),--工资代码
	v10 varchar(100)--人员属性
);

税率表创建语句如下:


--税率表注释
create table t_sl(
	id int identity(1,1) primary key not null,--主键
	v1 double--税率
);

专家表创建语句如下:


--专家表注释
create table t_zj(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	zjName varchar(100),--姓名
	gh varchar(100),--工号
	zw varchar(100),--职务
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone 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_bsxm")
public class Bsxm {
//主键
@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 v1;
//组织机构
private String v2;
//联系电话
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

专家酬金计算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_cj")
public class Cj {
//主键
@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 zjId;
//项目编号
private String xmbh;
//标题
private String title;
//比例
private String bl;
//酬金额
private Integer fee;
public Integer getZjId() {return zjId;}
public void setZjId(Integer zjId) {this.zjId = zjId;}
public String getXmbh() {return xmbh;}
public void setXmbh(String xmbh) {this.xmbh = xmbh;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getBl() {return bl;}
public void setBl(String bl) {this.bl = bl;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}

会议信息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_hyxx")
public class Hyxx {
//主键
@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 v1;
//天数
private Integer v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
}

普通管理员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 age;
//性别
private String sex;
//电话
private String phone;
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 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;}
}

人员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 String v1;
//身份证号
private String v2;
//银行卡号
private String v3;
//开户行
private String v4;
//手机号
private String v5;
//部门
private String v6;
//工作单位
private String v7;
//酬金(每天)
private Integer v8;
//工资代码
private String v9;
//人员属性
private String v10;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public Integer getV8() {return v8;}
public void setV8(Integer v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
}

税率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_sl")
public class Sl {
//主键
@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 Double v1;
public Double getV1() {return v1;}
public void setV1(Double v1) {this.v1 = v1;}
}

专家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_zj")
public class Zj {
//主键
@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 zjName;
//工号
private String gh;
//职务
private String zw;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getZjName() {return zjName;}
public void setZjName(String zjName) {this.zjName = zjName;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
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;}
}

专家库管理系统的设计与开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

比赛项目javaBean创建语句如下:


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

//比赛项目
public class Bsxm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//比赛名称
private String v1;
//组织机构
private String v2;
//联系电话
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

专家酬金计算javaBean创建语句如下:


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

//专家酬金计算
public class Cj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//专家
private Integer zjId;
//项目编号
private String xmbh;
//标题
private String title;
//比例
private String bl;
//酬金额
private Integer fee;
public Integer getZjId() {return zjId;}
public void setZjId(Integer zjId) {this.zjId = zjId;}
public String getXmbh() {return xmbh;}
public void setXmbh(String xmbh) {this.xmbh = xmbh;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getBl() {return bl;}
public void setBl(String bl) {this.bl = bl;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}

会议信息javaBean创建语句如下:


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

//会议信息
public class Hyxx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会议名称
private String v1;
//天数
private Integer v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
}

普通管理员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 age;
//性别
private String sex;
//电话
private String phone;
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 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;}
}

人员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 String v1;
//身份证号
private String v2;
//银行卡号
private String v3;
//开户行
private String v4;
//手机号
private String v5;
//部门
private String v6;
//工作单位
private String v7;
//酬金(每天)
private Integer v8;
//工资代码
private String v9;
//人员属性
private String v10;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public Integer getV8() {return v8;}
public void setV8(Integer v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
}

税率javaBean创建语句如下:


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

//税率
public class Sl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//税率
private Double v1;
public Double getV1() {return v1;}
public void setV1(Double v1) {this.v1 = v1;}
}

专家javaBean创建语句如下:


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

//专家
public class Zj  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 zjName;
//工号
private String gh;
//职务
private String zw;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getZjName() {return zjName;}
public void setZjName(String zjName) {this.zjName = zjName;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
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;}
}

源代码下载点这里

评论