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