java基于ssm的人事管理系统

java基于ssm的人事管理系统

项目描述

该项目包含了用户管理、部门管理、职位管理、员工管理、公告管理、下载中心等多个模块,页面使用JQuery框架完成动态功能,用户管理、部门管理等模块包含了项目开发中常用的增删改查动作,下载中心包含了 Spring MVC的文件上传、下载等功能

运行环境
jdk8+tomcat8+mysql+eclipse+maven
项目技术
spring+spring mvc+mybatis+jsp+jquery

数据库文件

截图:






数据库表：
CREATE TABLE dept_inf (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(50) DEFAULT NULL,
remark varchar(300) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

– Records of dept_inf

INSERT INTO dept_inf VALUES (‘1’, ‘技术部’, ‘技术部’);
INSERT INTO dept_inf VALUES (‘2’, ‘运营部’, ‘运营部’);
INSERT INTO dept_inf VALUES (‘3’, ‘财务部’, ‘财务部’);
INSERT INTO dept_inf VALUES (‘5’, ‘总公办’, ‘总公办’);
INSERT INTO dept_inf VALUES (‘6’, ‘市场部’, ‘市场部’);
INSERT INTO dept_inf VALUES (‘7’, ‘教学部’, ‘教学部’);
INSERT INTO dept_inf VALUES (‘28’, ‘123’, ‘123’);
INSERT INTO dept_inf VALUES (‘29’, ‘1’, ‘1’);

– Table structure for document_inf

DROP TABLE IF EXISTS document_inf;
CREATE TABLE document_inf (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(50) DEFAULT NULL,
filename varchar(300) DEFAULT NULL,
remark varchar(300) DEFAULT NULL,
create_date varchar(20) DEFAULT NULL,
user_id int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

– Records of document_inf

INSERT INTO document_inf VALUES (‘1’, ‘2,2’, ‘01.jpg’, null, null, null);
INSERT INTO document_inf VALUES (‘2’, ‘2,2’, ‘01.jpg’, null, null, null);
INSERT INTO document_inf VALUES (‘3’, ‘4’, ‘2.jpg’, ‘4’, null, null);
INSERT INTO document_inf VALUES (‘4’, ‘1’, ‘1.jpg’, ‘1’, null, null);
INSERT INTO document_inf VALUES (‘5’, ‘2’, ‘1.jpg’, ‘2’, null, null);
INSERT INTO document_inf VALUES (‘6’, ‘2’, ‘1.jpg’, ‘2’, null, null);
INSERT INTO document_inf VALUES (‘7’, ‘3’, ‘5.jpg’, ‘3’, null, null);
INSERT INTO document_inf VALUES (‘8’, ‘2’, ‘5.jpg’, ‘2’, null, null);

– Table structure for employee_inf

DROP TABLE IF EXISTS employee_inf;
CREATE TABLE employee_inf (
id int(11) NOT NULL AUTO_INCREMENT,
dept_id int(11) DEFAULT NULL,
job_id int(11) DEFAULT NULL,
name varchar(20) DEFAULT NULL,
card_id varchar(20) DEFAULT NULL,
address varchar(50) DEFAULT NULL,
post_code varchar(50) DEFAULT NULL,
tel varchar(20) DEFAULT NULL,
phone varchar(11) DEFAULT NULL,
qq_num varchar(10) DEFAULT NULL,
email varchar(50) DEFAULT NULL,
sex int(11) DEFAULT NULL,
party varchar(10) DEFAULT NULL,
birthday char(20) DEFAULT NULL,
race varchar(100) DEFAULT NULL,
education varchar(10) DEFAULT NULL,
speciality varchar(20) DEFAULT NULL,
hobby varchar(100) DEFAULT NULL,
remark varchar(500) DEFAULT NULL,
create_date varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

– Records of employee_inf

INSERT INTO employee_inf VALUES (‘1’, ‘1’, ‘8’, ‘爱丽丝’, ‘4328011988’, ‘广州天河’, ‘510000’, ‘020-77777777’, ‘13902001111’, ‘36750066’, ‘251425887@qq’, ‘0’, ‘党员’, ‘1980-01-01 00:00:00’, ‘满’, ‘本科’, ‘美声’, ‘唱歌’, ‘四大天王’, ‘2016-03-14 11:35:18’);
INSERT INTO employee_inf VALUES (‘2’, ‘3’, ‘1’, ‘杰克’, ‘22623’, ‘43234’, ‘42427424’, ‘42242’, ‘4247242’, ‘42424’, ‘251425887@qq’, ‘2’, null, null, null, ‘1’, null, null, null, ‘2016-03-14 11:35:18’);
INSERT INTO employee_inf VALUES (‘3’, ‘1’, ‘2’, ‘bb’, ‘432801197711251038’, ‘广州’, ‘510000’, ‘020-99999999’, ‘13907351532’, ‘36750064’, ‘36750064@qq’, ‘1’, ‘党员’, ‘1977-11-25 00:00:00’, ‘汉’, ‘本科’, ‘计算机’, ‘爬山’, ‘无’, ‘2016-07-14 09:54:52’);
INSERT INTO employee_inf VALUES (‘4’, null, null, ‘1’, ‘2’, ‘7’, null, null, ‘6’, null, ‘5’, ‘3’, null, null, null, ‘4’, null, null, null, null);
INSERT INTO employee_inf VALUES (‘5’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, null, null, ‘1’, null, ‘1’, ‘1’, null, null, null, ‘1’, null, null, null, null);