Java项目:医院人事管理系统(java+SSM+JSP+bootstrap+jQuery+mysql)

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50721 Source Host : localhost:3306 Source Schema : hr Target Server Type : MySQL Target Server Version : 50721 File Encoding : 65001 Date: 03/05/2021 22:52:02 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for attendance -- ---------------------------- DROP TABLE IF EXISTS `attendance`; CREATE TABLE `attendance` ( `id` int(10) NOT NULL AUTO_INCREMENT, `employee_number` int(10) DEFAULT NULL, `day` date DEFAULT NULL, `time_type` enum('上午','下午','加班') DEFAULT NULL, `start_time` time DEFAULT NULL, `start_type` enum('正常','迟到','未签到') DEFAULT '未签到', `end_time` time DEFAULT NULL, `end_type` enum('正常','早退','未签到') DEFAULT '未签到', `work_type` enum('上班','请假') DEFAULT NULL, `notes` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of attendance -- ---------------------------- BEGIN; INSERT INTO `attendance` VALUES (1, 1001, '2017-07-07', '下午', '17:01:33', '迟到', '17:25:15', '早退', NULL, NULL); INSERT INTO `attendance` VALUES (2, 1001, '2017-07-08', '上午', '08:53:43', '正常', '11:20:46', '早退', NULL, NULL); INSERT INTO `attendance` VALUES (3, 1001, '2017-07-08', '下午', '14:25:17', '正常', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (4, 1009, '2017-07-10', '上午', '10:29:35', '迟到', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (5, 1009, '2017-07-10', '下午', '16:42:01', '迟到', '16:42:25', '早退', NULL, NULL); INSERT INTO `attendance` VALUES (6, 1009, '2017-07-10', '加班', '19:31:46', '正常', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (7, 1009, '2017-07-11', '上午', '09:21:13', '迟到', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (8, 1009, '2017-07-12', '上午', '09:09:53', '迟到', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (9, 1009, '2017-07-12', '下午', '15:31:03', '迟到', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (10, 1001, '2017-07-12', '下午', '15:34:58', '迟到', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (11, 1007, '2017-07-12', '下午', '15:51:24', '迟到', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (12, 1008, '2017-07-12', '下午', '16:48:03', '迟到', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (13, 1009, '2017-07-12', '加班', '21:02:35', '迟到', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (14, 1010, '2017-07-12', '加班', '21:24:34', '迟到', NULL, '未签到', NULL, NULL); INSERT INTO `attendance` VALUES (15, 1010, '2017-08-06', '下午', '14:25:24', '正常', NULL, '未签到', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for department -- ---------------------------- DROP TABLE IF EXISTS `department`; CREATE TABLE `department` ( `id` int(10) NOT NULL AUTO_INCREMENT, `department_number` int(10) DEFAULT NULL, `name` varchar(20) DEFAULT NULL, `manager` varchar(10) DEFAULT NULL, `telephone` varchar(20) DEFAULT NULL, `address` varchar(50) DEFAULT NULL, `notes` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of department -- ---------------------------- BEGIN; INSERT INTO `department` VALUES (1, 2001, '急诊科', '王生安', '0923-3456180', '住院楼101', ''); INSERT INTO `department` VALUES (2, 2002, '骨科', '贺易', '0923-3456324', '门诊楼304', ''); INSERT INTO `department` VALUES (3, 2003, '内分泌科 ', '周卓浩', '0923-3456909', '门诊楼205', ''); INSERT INTO `department` VALUES (4, 2004, '神经内科 ', '何刚名', '0923-3456231', '门诊楼109', ''); INSERT INTO `department` VALUES (5, 2005, '神经外科', '王成文 ', '0923-3456782', '门诊楼102', ''); INSERT INTO `department` VALUES (6, 2006, '消化内科 ', '严席华', '0923-3456098', '门诊楼201', ''); INSERT INTO `department` VALUES (7, 2007, '检验科', '云介融 ', '0923-3456143', '医技楼104', ''); INSERT INTO `department` VALUES (8, 2008, '体检中心 ', '范湖', '0923-3456677', '医技楼203', ''); INSERT INTO `department` VALUES (9, 2009, '放射科 ', '吴敬序', '0923-3456489', '医技楼305', ''); INSERT INTO `department` VALUES (10, 2010, '护理部 ', '凌月青', '0923-3456210', '住院楼109', ''); INSERT INTO `department` VALUES (11, 2011, '康复理疗科 ', '丁频佟', '0923-3456724', '医技楼208', ''); INSERT INTO `department` VALUES (12, 2012, '药剂科', '王缘', '0923-3456423', '医技楼302', ''); INSERT INTO `department` VALUES (13, 2013, '人事部', '李烨', '0923-2456123', '办公楼108', ''); COMMIT; -- ---------------------------- -- Table structure for employee -- ---------------------------- DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee` ( `id` int(10) NOT NULL AUTO_INCREMENT, `employee_number` int(10) DEFAULT NULL, `name` varchar(10) DEFAULT NULL, `gender` enum('男','女') DEFAULT NULL, `birthday` date DEFAULT NULL, `telephone` varchar(15) DEFAULT '', `email` varchar(30) DEFAULT '', `address` varchar(50) DEFAULT NULL, `photo` varchar(50) DEFAULT '', `education` varchar(20) DEFAULT '', `department_number` int(10) DEFAULT NULL, `position_number` int(10) DEFAULT NULL, `in_time` date DEFAULT NULL, `password` varchar(20) DEFAULT NULL, `notes` varchar(255) DEFAULT '', PRIMARY KEY (`id`), KEY `department_number` (`department_number`), KEY `title_number` (`position_number`), KEY `employee_number` (`employee_number`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of employee -- ---------------------------- BEGIN; INSERT INTO `employee` VALUES (1, 1001, 'admin', '男', '1995-10-18', '15678015439', '12@163.com', '123', '', '123444', 2013, 3009, '2017-02-22', '1001', '123'); INSERT INTO `employee` VALUES (2, 1007, '李烨', '女', '1996-03-04', '18907327612', '', NULL, '', '', 2001, 3003, '2017-01-10', '1007', ''); INSERT INTO `employee` VALUES (3, 1008, '刘旭亮', '男', '1995-06-06', '13464238971', '', '', '', '', 2007, 3003, '2017-06-28', '1008', ''); INSERT INTO `employee` VALUES (4, 1009, '张彤', '男', '1995-09-24', '15810239904', '', '', '', '', 2013, 3010, '2017-02-06', '1009', ''); INSERT INTO `employee` VALUES (5, 1010, '杨杰', '男', '1995-01-26', '17871239756', '', '', '', '', 2013, 3010, '2017-05-12', '1010', ''); INSERT INTO `employee` VALUES (6, 1011, '唐治涛', '男', '1995-03-29', '18832013916', '', '河北沧州', NULL, '大学本科', 2007, 3003, '2017-07-05', 'tzt4', ''); INSERT INTO `employee` VALUES (7, 1012, '张璐', '男', '1997-03-04', '18832050264', '', '河北张家口', NULL, '大学本科', 2013, 3009, '2017-07-05', 'zhanglu', ''); INSERT INTO `employee` VALUES (8, 1013, '李明', '男', '2021-04-17', '123456', '708846508@qq.com', '河北秦皇岛', '', '本科', 2001, 3001, '2021-04-17', '123456', '医科大毕业'); COMMIT; -- ---------------------------- -- Table structure for history -- ---------------------------- DROP TABLE IF EXISTS `history`; CREATE TABLE `history` ( `id` int(10) NOT NULL AUTO_INCREMENT, `employee_number` int(10) DEFAULT NULL, `name` varchar(10) DEFAULT NULL, `gender` enum('男','女') DEFAULT NULL, `birthday` date DEFAULT NULL, `telephone` varchar(20) DEFAULT '', `email` varchar(30) DEFAULT '', `address` varchar(50) DEFAULT '', `photo` varchar(50) DEFAULT '', `education` varchar(20) DEFAULT '', `in_time` date DEFAULT NULL, `out_time` date DEFAULT NULL, `department_number` int(10) DEFAULT NULL, `position_number` int(10) DEFAULT NULL, `status` enum('离职