开发语言：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 */;
