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.com’, ‘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.com’, ‘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.com’, ‘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);