基于ssm高校工資管理系統(tǒng)的設(shè)計與實(shí)現(xiàn)-計算機(jī)畢業(yè)設(shè)計源碼+LW文檔
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `name` varchar(100) NOT NULL COMMENT '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gongzifafang`
--
DROP TABLE IF EXISTS `gongzifafang`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gongzifafang` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `gonghao` varchar(200) NOT NULL COMMENT '工號',
? `xingming` varchar(200) NOT NULL COMMENT '姓名',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `zhicheng` varchar(200) DEFAULT NULL COMMENT '職稱',
? `dianhua` varchar(200) DEFAULT NULL COMMENT '電話',
? `xueyuan` varchar(200) DEFAULT NULL COMMENT '學(xué)院',
? `shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份證號',
? `yinxingkahao` varchar(200) DEFAULT NULL COMMENT '銀行卡號',
? `jibengongzi` float DEFAULT NULL COMMENT '基本工資',
? `yingdekeshifei` float DEFAULT NULL COMMENT '應(yīng)得課時費(fèi)',
? `shidekeshifei` float DEFAULT NULL COMMENT '實(shí)得課時費(fèi)',
? `gangweibutie` float DEFAULT NULL COMMENT '崗位補(bǔ)貼',
? `wuxianyijin` float DEFAULT NULL COMMENT '五險一金',
? `gerensuodeshui` float DEFAULT NULL COMMENT '個人所得稅',
? `shijigongzi` float DEFAULT NULL COMMENT '實(shí)際工資',
? `dengjishijian` date DEFAULT NULL COMMENT '登記時間',
? PRIMARY KEY (`id`),
? UNIQUE KEY `gonghao` (`gonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646028114854 DEFAULT CHARSET=utf8 COMMENT='工資發(fā)放';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gongzifafang`
--
LOCK TABLES `gongzifafang` WRITE;
/*!40000 ALTER TABLE `gongzifafang` DISABLE KEYS */;
INSERT INTO `gongzifafang` VALUES (31,'2022-02-28 05:58:16','工號1','姓名1','男','職稱1','13823888881','學(xué)院1','440300199101010001','銀行卡號1',1,1,1,1,1,1,1,'2022-02-28'),(32,'2022-02-28 05:58:16','工號2','姓名2','男','職稱2','13823888882','學(xué)院2','440300199202020002','銀行卡號2',2,2,2,2,2,2,2,'2022-02-28'),(33,'2022-02-28 05:58:16','工號3','姓名3','男','職稱3','13823888883','學(xué)院3','440300199303030003','銀行卡號3',3,3,3,3,3,3,3,'2022-02-28'),(34,'2022-02-28 05:58:16','工號4','姓名4','男','職稱4','13823888884','學(xué)院4','440300199404040004','銀行卡號4',4,4,4,4,4,4,4,'2022-02-28'),(35,'2022-02-28 05:58:16','工號5','姓名5','男','職稱5','13823888885','學(xué)院5','440300199505050005','銀行卡號5',5,5,5,5,5,5,5,'2022-02-28'),(36,'2022-02-28 05:58:16','工號6','姓名6','男','職稱6','13823888886','學(xué)院6','440300199606060006','銀行卡號6',6,6,6,6,6,6,6,'2022-02-28'),(1646028114853,'2022-02-28 06:01:54','111','胡集','男','教授','13612512512','編輯','136125125125125125','123123123123123123123',5555,2321,2211,333,333,33,7733,'2022-02-28');
/*!40000 ALTER TABLE `gongzifafang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaozhiyuangong`
--
DROP TABLE IF EXISTS `jiaozhiyuangong`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaozhiyuangong` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `gonghao` varchar(200) NOT NULL COMMENT '工號',
? `mima` varchar(200) NOT NULL COMMENT '密碼',
? `xingming` varchar(200) NOT NULL COMMENT '姓名',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `zhicheng` varchar(200) DEFAULT NULL COMMENT '職稱',
? `dianhua` varchar(200) DEFAULT NULL COMMENT '電話',
? `nianling` varchar(200) DEFAULT NULL COMMENT '年齡',
? `xueyuan` varchar(200) DEFAULT NULL COMMENT '學(xué)院',
? `shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份證號',
? `yinxingkahao` varchar(200) DEFAULT NULL COMMENT '銀行卡號',
? PRIMARY KEY (`id`),
? UNIQUE KEY `gonghao` (`gonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646028039319 DEFAULT CHARSET=utf8 COMMENT='教職員工';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaozhiyuangong`
--
LOCK TABLES `jiaozhiyuangong` WRITE;
/*!40000 ALTER TABLE `jiaozhiyuangong` DISABLE KEYS */;
INSERT INTO `jiaozhiyuangong` VALUES (11,'2022-02-28 05:58:16','工號1','123456','姓名1','男','職稱1','13823888881','年齡1','學(xué)院1','440300199101010001','銀行卡號1'),(12,'2022-02-28 05:58:16','工號2','123456','姓名2','男','職稱2','13823888882','年齡2','學(xué)院2','440300199202020002','銀行卡號2'),(13,'2022-02-28 05:58:16','工號3','123456','姓名3','男','職稱3','13823888883','年齡3','學(xué)院3','440300199303030003','銀行卡號3'),(14,'2022-02-28 05:58:16','工號4','123456','姓名4','男','職稱4','13823888884','年齡4','學(xué)院4','440300199404040004','銀行卡號4'),(15,'2022-02-28 05:58:16','工號5','123456','姓名5','男','職稱5','13823888885','年齡5','學(xué)院5','440300199505050005','銀行卡號5'),(16,'2022-02-28 05:58:16','工號6','123456','姓名6','男','職稱6','13823888886','年齡6','學(xué)院6','440300199606060006','銀行卡號6'),(1646028039318,'2022-02-28 06:00:39','111','111','胡集','男','教授','13612512512','36','編輯','136125125125125125','123123123123123123123');
/*!40000 ALTER TABLE `jiaozhiyuangong` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kaoqinxinxi`
--
DROP TABLE IF EXISTS `kaoqinxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaoqinxinxi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `nianyuefen` varchar(200) DEFAULT NULL COMMENT '年月份',
? `gonghao` varchar(200) DEFAULT NULL COMMENT '工號',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `chuqinshijian` varchar(200) DEFAULT NULL COMMENT '出勤時間',
? `qingjiatianshu` varchar(200) DEFAULT NULL COMMENT '請假天數(shù)',
? `pingshijiaban` varchar(200) DEFAULT NULL COMMENT '平時加班',
? `zhoumojiaban` varchar(200) DEFAULT NULL COMMENT '周末加班',
? `jiejiarijiaban` varchar(200) DEFAULT NULL COMMENT '節(jié)假日加班',
? `chidaocishu` varchar(200) DEFAULT NULL COMMENT '遲到次數(shù)',
? `zaotuicishu` varchar(200) DEFAULT NULL COMMENT '早退次數(shù)',
? `queqintianshu` varchar(200) DEFAULT NULL COMMENT '缺勤天數(shù)',
? `chuchatianshu` varchar(200) DEFAULT NULL COMMENT '出差天數(shù)',
? `dengjishijian` datetime DEFAULT NULL COMMENT '登記時間',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646028094228 DEFAULT CHARSET=utf8 COMMENT='考勤信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kaoqinxinxi`
--
LOCK TABLES `kaoqinxinxi` WRITE;
/*!40000 ALTER TABLE `kaoqinxinxi` DISABLE KEYS */;
INSERT INTO `kaoqinxinxi` VALUES (21,'2022-02-28 05:58:16','年月份1','工號1','姓名1','出勤時間1','請假天數(shù)1','平時加班1','周末加班1','節(jié)假日加班1','遲到次數(shù)1','早退次數(shù)1','缺勤天數(shù)1','出差天數(shù)1','2022-02-28 13:58:16'),(22,'2022-02-28 05:58:16','年月份2','工號2','姓名2','出勤時間2','請假天數(shù)2','平時加班2','周末加班2','節(jié)假日加班2','遲到次數(shù)2','早退次數(shù)2','缺勤天數(shù)2','出差天數(shù)2','2022-02-28 13:58:16'),(23,'2022-02-28 05:58:16','年月份3','工號3','姓名3','出勤時間3','請假天數(shù)3','平時加班3','周末加班3','節(jié)假日加班3','遲到次數(shù)3','早退次數(shù)3','缺勤天數(shù)3','出差天數(shù)3','2022-02-28 13:58:16'),(24,'2022-02-28 05:58:16','年月份4','工號4','姓名4','出勤時間4','請假天數(shù)4','平時加班4','周末加班4','節(jié)假日加班4','遲到次數(shù)4','早退次數(shù)4','缺勤天數(shù)4','出差天數(shù)4','2022-02-28 13:58:16'),(25,'2022-02-28 05:58:16','年月份5','工號5','姓名5','出勤時間5','請假天數(shù)5','平時加班5','周末加班5','節(jié)假日加班5','遲到次數(shù)5','早退次數(shù)5','缺勤天數(shù)5','出差天數(shù)5','2022-02-28 13:58:16'),(26,'2022-02-28 05:58:16','年月份6','工號6','姓名6','出勤時間6','請假天數(shù)6','平時加班6','周末加班6','節(jié)假日加班6','遲到次數(shù)6','早退次數(shù)6','缺勤天數(shù)6','出差天數(shù)6','2022-02-28 13:58:16'),(1646028094227,'2022-02-28 06:01:33','2022/03','111','胡集','22','1','1','1','1','1','1','1','1','2022-02-28 14:01:18');
/*!40000 ALTER TABLE `kaoqinxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `username` varchar(100) NOT NULL COMMENT '用戶名',
? `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
? `role` varchar(100) DEFAULT NULL COMMENT '角色',
? `token` varchar(200) NOT NULL COMMENT '密碼',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增時間',
? `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '過期時間',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='token表';
