基于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 */;

/*!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 */;

/*!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表’;