基于Servlet+MySQL,+Mybatis+Vue实现的人事工资管理系统.zip

-- MySQL dump 10.13 Distrib 8.0.25, for Win64 (x86_64) -- -- Host: localhost Database: emp_ms -- ------------------------------------------------------ -- Server version 8.0.25 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `department` -- DROP TABLE IF EXISTS `department`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `department` ( `id` int NOT NULL AUTO_INCREMENT, `dep_name` varchar(255) NOT NULL, `manager_id` int NOT NULL, PRIMARY KEY (`id`), KEY `manager_id` (`manager_id`), CONSTRAINT `department_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `employee` (`id`), CONSTRAINT `department_ibfk_2` FOREIGN KEY (`manager_id`) REFERENCES `employee` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department` -- LOCK TABLES `department` WRITE; /*!40000 ALTER TABLE `department` DISABLE KEYS */; INSERT INTO `department` VALUES (1,'财政部',8001),(2,'人事部',8002),(3,'市场部',8004),(4,'生产部',8003),(5,'信息部',8074); /*!40000 ALTER TABLE `department` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employee` -- DROP TABLE IF EXISTS `employee`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `employee` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `passwd` varchar(255) NOT NULL, `sex` char(2) NOT NULL, `rate` float DEFAULT '0', `birth` date NOT NULL, `address` varchar(255) NOT NULL, `cardId` varchar(20) NOT NULL, `tel` varchar(20) NOT NULL, `dep_id` int NOT NULL, `job_id` int NOT NULL, PRIMARY KEY (`id`), KEY `idx_emp_id` (`id`), KEY `job_id` (`job_id`), KEY `dep_id` (`dep_id`), CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`dep_id`) REFERENCES `department` (`id`), CONSTRAINT `employee_ibfk_3` FOREIGN KEY (`job_id`) REFERENCES `job` (`id`), CONSTRAINT `employee_ibfk_4` FOREIGN KEY (`dep_id`) REFERENCES `department` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8391 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `employee` -- LOCK TABLES `employee` WRITE; /*!40000 ALTER TABLE `employee` DISABLE KEYS */; INSERT INTO `employee` VALUES (8001,'佚名wz','123456123456','男',0.4,'2002-05-08','吉林省','220182200001013213','18245644564',1,1),(8002,'佚名f','123456123456','男',0.6,'2002-04-16','吉林省','318153987998798799','15464656546',2,10),(8003,'佚名l','123456123456','男',0.3,'2000-08-03','吉林省','532730198708246240','18298390167',4,23),(8004,'佚名wq','123456123456','男',0.3,'1972-08-05','吉林省','152301197208059650','18995513128',3,16),(8005,'俟司信茜','123456','女',0,'1988-02-06','四川省阿坝藏族羌族自治州','513200198802062466','18995513128',3,17),(8006,'明中厚','123456','男',0,'1997-06-15','广西壮族自治区桂林市雁山区','450311199706156892','18995513128',4,29),(8007,'芮歌永','123456','男',0,'1991-06-17','湖北省武汉市黄陂区','420116199106174398','18995513128',4,29),(8008,'康世','123456','男',0.3,'1985-10-16','湖北省武汉市青山区','420107198510169776','18995513128',1,7),(8009,'束凯茜','123123','女',0,'1982-02-23','西藏自治区阿里地区札达县','542522198202233566','18995513128',4,29),(8010,'于单娜','123456','女',0.2,'1971-09-16','河北省承德市滦平县','130824197109169244','18995513128',5,33),(8011,'景园','123456','女',0.3,'1988-03-28','山东省菏泽地区单县','372925198803289740','18995513128',1,7),(8012,'卫芸','123456','女',0.3,'1983-06-17','河北省沧州市孟村回族自治县','130930198306179545','18995513128',4,28),(8013,'胡信美','123456','女',0,'1999-08-12','江苏省南通市港闸区','320611199908127763','18995513128',1,3),(8014,'武筠','123456','女',0,'1995-10-28','西藏自治区林芝地区波密县','542625199510287020','18995513128',4,26),(8015,'马玉以','123456','男',0.2,'1990-09-07','河北省邢台市市辖区','130501199009078837','18995513128',5,33),(8016,'乔加月','123456','女',0,'1980-09-15','山西省长治市黎城县','140426198009153103','18995513128',1,6),(8017,'毛琬','123456','女',0,'1994-09-01','四川省巴中地区','513700199409016860','18995513128',5,35),(8018,'彭家辉','124242','男',0,'1996-10-17','广东省梅州市兴宁市','441481199610173712','18995513128',2,15),(8019,'汪被行','123456','男',0,'1994-11-07','湖南省益阳市桃江县','430922199411075874','18995513128',1,3),(8020,'骆九风','123456','男',0,'1996-04-10','福建省福州市','350100199604108853','18995513128',5,31),(8021,'俞蕊','123456','女',0.3,'1977-09-24','辽宁省铁岭市昌图县','211224197709247064','18995513128',5,35),(8022,'松瑶','123456','女',0,'1982-04-05','黑龙江省大庆市萨尔图区','230602198204053003','18995513128',4,4),(8023,'孙兴','123456','男',0,'1978-06-11','江苏省盐城市大丰市','32098219780611709X','18995513128',2,13),(8024,'强钰娴','031214','女',0,'1970-06-16','湖南省湘潭市','430300197006152987','18995513128',5,37),(8025,'贺翔','123456','男',0,'1992-02-13','湖南省邵阳市绥宁县','430527199202136538','18995513128',5,31),(8026,'郁马萍','123456','女',0,'1981-07-25','四川省泸州市泸县','510521198107259705','18995513128',1,8),(8027,'尹笑敬','123456','男',0,'1985-12-01','山东省德州市临邑县','371424198512014419','18995513128',4,27),(8028,'邢器平','123456','男',0,'1970-11-08','山西省太原市尖草坪区','140108197011087770','18995513128',4,29),(8029,'步妍','123456','女',0,'1976-12-18','广东省汕头市潮阳市','44058219761218904X','18995513128',5,31),(8030,'宣静','123456','女',0,'1972-01-13','四川省绵阳市安县','510724197201131666','18995513128',3,19),(8031,'葛秀','123456','女',0.4,'1987-01-18','广西壮族自治区柳州地区武宣县','452225198701186283','18995513128',1,8),(8032,'车轮','123456','男',0.4,'1984-11-27','江西省宜春地区','362200198411271798','18995513128',1,8),(8033,'于都雅','123456','女',0,'1993-07-28','北京市市辖区','110100199307283802','18995513128',4,24),(8034,'都无爱','123456','女',0,'1987-02-16','河北省邢台市临西县','130535198702168223','18995513128',4,26),(8035,'茹凯振','123456','男',0.4,'1973-01-04','安徽省阜阳市颍泉区','34120419730104665X','18995513128',1,8),(8036,'冀栋','123456','男',0.3,'1974-06-13','安徽省淮北市相山区','340603197406137739','18995513128',1,7),(8037,'百里婵','123456','女',0,'1993-02-21','黑龙江省绥化地区海伦市','232304199302213368','18995513128',4,26),(8038,'崔忠慧','123456','女',0.3,'1975-12-24','安徽省黄山市屯溪区','341002197512248821','18995513128',2,14),(8039,'束贝菊','123456','女',0.3,'1986-07-27','江苏省徐州市泉山区','320311198607278268','13140375456',2,14),(8040,'逄泽','123456','男',0,'1999-05-29','宁夏回族自治区银川市市辖区','640101199905293998','18995513128',2,15),(8041,'干百卡坚','123456','男',0,'1980-02-09','黑龙江省双鸭山市友谊县','230522198002096013','18995513128',3,18),(8042,'刁哲','123456','男',0,'1974-01-08','陕西省延安市宝塔区','610602197401086054','18995513128',3,18),(8043,'伊好翠','123456','女',0.3,'1970-01-23','湖北省省直�