项目描述
该项目包含了用户管理、部门管理、职位管理、员工管理、公告管理、下载中心等多个模块,页面使用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);
更多推荐
java基于ssm的人事管理系统
发布评论