基于ssm高校工资管理系统设计与实现-计算机毕业设计源码+LW文档

开发语言：Java

框架：ssm

JDK版本：JDK1.8

服务器：tomcat7

数据库：mysql 5.7（一定要5.7版本）

数据库工具：Navicat11

开发软件：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 '配置参数名称',

`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',

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 '创建时间',

`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 '学院',

`shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份证号',

`yinxingkahao` varchar(200) DEFAULT NULL COMMENT '银行卡号',

`jibengongzi` float DEFAULT NULL COMMENT '基本工资',

`yingdekeshifei` float DEFAULT NULL COMMENT '应得课时费',

`shidekeshifei` float DEFAULT NULL COMMENT '实得课时费',

`gangweibutie` float DEFAULT NULL COMMENT '岗位补贴',

`wuxianyijin` float DEFAULT NULL COMMENT '五险一金',

`gerensuodeshui` float DEFAULT NULL COMMENT '个人所得税',

`shijigongzi` float DEFAULT NULL COMMENT '实际工资',

`dengjishijian` date DEFAULT NULL COMMENT '登记时间',

PRIMARY KEY (`id`),

UNIQUE KEY `gonghao` (`gonghao`)

) ENGINE=InnoDB AUTO_INCREMENT=1646028114854 DEFAULT CHARSET=utf8 COMMENT='工资发放';

/*!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','学院1','440300199101010001','银行卡号1',1,1,1,1,1,1,1,'2022-02-28'),(32,'2022-02-28 05:58:16','工号2','姓名2','男','职称2','13823888882','学院2','440300199202020002','银行卡号2',2,2,2,2,2,2,2,'2022-02-28'),(33,'2022-02-28 05:58:16','工号3','姓名3','男','职称3','13823888883','学院3','440300199303030003','银行卡号3',3,3,3,3,3,3,3,'2022-02-28'),(34,'2022-02-28 05:58:16','工号4','姓名4','男','职称4','13823888884','学院4','440300199404040004','银行卡号4',4,4,4,4,4,4,4,'2022-02-28'),(35,'2022-02-28 05:58:16','工号5','姓名5','男','职称5','13823888885','学院5','440300199505050005','银行卡号5',5,5,5,5,5,5,5,'2022-02-28'),(36,'2022-02-28 05:58:16','工号6','姓名6','男','职称6','13823888886','学院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 '创建时间',

`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 '学院',

`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','学院1','440300199101010001','银行卡号1'),(12,'2022-02-28 05:58:16','工号2','123456','姓名2','男','职称2','13823888882','年龄2','学院2','440300199202020002','银行卡号2'),(13,'2022-02-28 05:58:16','工号3','123456','姓名3','男','职称3','13823888883','年龄3','学院3','440300199303030003','银行卡号3'),(14,'2022-02-28 05:58:16','工号4','123456','姓名4','男','职称4','13823888884','年龄4','学院4','440300199404040004','银行卡号4'),(15,'2022-02-28 05:58:16','工号5','123456','姓名5','男','职称5','13823888885','年龄5','学院5','440300199505050005','银行卡号5'),(16,'2022-02-28 05:58:16','工号6','123456','姓名6','男','职称6','13823888886','年龄6','学院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 '创建时间',

`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 '请假天数',

`pingshijiaban` varchar(200) DEFAULT NULL COMMENT '平时加班',

`zhoumojiaban` varchar(200) DEFAULT NULL COMMENT '周末加班',

`jiejiarijiaban` varchar(200) DEFAULT NULL COMMENT '节假日加班',

`chidaocishu` varchar(200) DEFAULT NULL COMMENT '迟到次数',

`zaotuicishu` varchar(200) DEFAULT NULL COMMENT '早退次数',

`queqintianshu` varchar(200) DEFAULT NULL COMMENT '缺勤天数',

`chuchatianshu` varchar(200) DEFAULT NULL COMMENT '出差天数',

`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','请假天数1','平时加班1','周末加班1','节假日加班1','迟到次数1','早退次数1','缺勤天数1','出差天数1','2022-02-28 13:58:16'),(22,'2022-02-28 05:58:16','年月份2','工号2','姓名2','出勤时间2','请假天数2','平时加班2','周末加班2','节假日加班2','迟到次数2','早退次数2','缺勤天数2','出差天数2','2022-02-28 13:58:16'),(23,'2022-02-28 05:58:16','年月份3','工号3','姓名3','出勤时间3','请假天数3','平时加班3','周末加班3','节假日加班3','迟到次数3','早退次数3','缺勤天数3','出差天数3','2022-02-28 13:58:16'),(24,'2022-02-28 05:58:16','年月份4','工号4','姓名4','出勤时间4','请假天数4','平时加班4','周末加班4','节假日加班4','迟到次数4','早退次数4','缺勤天数4','出差天数4','2022-02-28 13:58:16'),(25,'2022-02-28 05:58:16','年月份5','工号5','姓名5','出勤时间5','请假天数5','平时加班5','周末加班5','节假日加班5','迟到次数5','早退次数5','缺勤天数5','出差天数5','2022-02-28 13:58:16'),(26,'2022-02-28 05:58:16','年月份6','工号6','姓名6','出勤时间6','请假天数6','平时加班6','周末加班6','节假日加班6','迟到次数6','早退次数6','缺勤天数6','出差天数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表';