开发语言：Java
框架：springboot
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=9 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'),(7,'APIKey','ihML0NfEM0jokUAuBD9tbYtW'),(8,'SecretKey','WK2bRUFf2uNe3oEoQXULpi8Y37aCvFdD');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kaoqinjilu`
--
DROP TABLE IF EXISTS `kaoqinjilu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaoqinjilu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dakaleibie` varchar(200) NOT NULL COMMENT '打卡类别',
`dakashijian` datetime DEFAULT NULL COMMENT '打卡时间',
`yuangonggonghao` varchar(200) DEFAULT NULL COMMENT '员工工号',
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
`renlianshibie` longtext COMMENT '人脸识别',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1680695460368 DEFAULT CHARSET=utf8 COMMENT='考勤记录';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kaoqinjilu`
--
LOCK TABLES `kaoqinjilu` WRITE;
/*!40000 ALTER TABLE `kaoqinjilu` DISABLE KEYS */;
INSERT INTO `kaoqinjilu` VALUES (61,'2023-04-05 11:43:37','上班','2023-04-05 19:43:37','员工工号1','员工姓名1','upload/kaoqinjilu_renlianshibie1.jpg,upload/kaoqinjilu_renlianshibie2.jpg,upload/kaoqinjilu_renlianshibie3.jpg'),(62,'2023-04-05 11:43:37','上班','2023-04-05 19:43:37','员工工号2','员工姓名2','upload/kaoqinjilu_renlianshibie2.jpg,upload/kaoqinjilu_renlianshibie3.jpg,upload/kaoqinjilu_renlianshibie4.jpg'),(63,'2023-04-05 11:43:37','上班','2023-04-05 19:43:37','员工工号3','员工姓名3','upload/kaoqinjilu_renlianshibie3.jpg,upload/kaoqinjilu_renlianshibie4.jpg,upload/kaoqinjilu_renlianshibie5.jpg'),(64,'2023-04-05 11:43:37','上班','2023-04-05 19:43:37','员工工号4','员工姓名4','upload/kaoqinjilu_renlianshibie4.jpg,upload/kaoqinjilu_renlianshibie5.jpg,upload/kaoqinjilu_renlianshibie6.jpg'),(65,'2023-04-05 11:43:37','上班','2023-04-05 19:43:37','员工工号5','员工姓名5','upload/kaoqinjilu_renlianshibie5.jpg,upload/kaoqinjilu_renlianshibie6.jpg,upload/kaoqinjilu_renlianshibie7.jpg'),(66,'2023-04-05 11:43:37','上班','2023-04-05 19:43:37','员工工号6','员工姓名6','upload/kaoqinjilu_renlianshibie6.jpg,upload/kaoqinjilu_renlianshibie7.jpg,upload/kaoqinjilu_renlianshibie8.jpg'),(67,'2023-04-05 11:43:37','上班','2023-04-05 19:43:37','员工工号7','员工姓名7','upload/kaoqinjilu_renlianshibie7.jpg,upload/kaoqinjilu_renlianshibie8.jpg,upload/kaoqinjilu_renlianshibie9.jpg'),(68,'2023-04-05 11:43:37','上班','2023-04-05 19:43:37','员工工号8','员工姓名8','upload/kaoqinjilu_renlianshibie8.jpg,upload/kaoqinjilu_renlianshibie9.jpg,upload/kaoqinjilu_renlianshibie10.jpg'),(1680695460367,'2023-04-05 11:51:00','上班','2023-04-05 19:50:35','333','杨洋','upload/1680695456671.jpeg');
/*!40000 ALTER TABLE `kaoqinjilu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`picture` longtext NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1680695631453 DEFAULT CHARSET=utf8 COMMENT='通知公告';
/*!40101 SET character_set_client = @saved_cs_client */;
如需定做或者获取更多资料，请联系QQ：375279829
客服QQ