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

本文档展示了使用Java SSM框架（Spring、SpringMVC、MyBatis）开发的一个工资管理系统数据库设计，包括配置参数、工资发放、教职员工、考勤信息和token表的详细结构。系统采用JDK1.8，Tomcat7服务器，MySQL5.7数据库，Navicat11作为数据库工具，开发软件可选Eclipse、MyEclipse或IDEA，Maven3.3.9进行依赖管理，浏览器推荐使用谷歌。数据库中包含员工的基本信息、工资计算、考勤记录等关键信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

开发语言：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表';