功能介绍
角色为用户、管理员、驾校。框架界面分为用户操作界面、管理员操作界面和驾校操作界面。用户的功能设计为:
(1)个人资料管理功能,可以针对自己的信息资料进行修改管理;
(2)报名入口功能,本界面里展示了不同的驾校信息,可以按照要求进行报名;
(3)学员报名管理功能,本界面里展示了自己所有报名的驾校,可以根据具体情况进行修改;
(4)练车预约功能,可以根据自己的时间进行预约练车;
(5)考试信息功能,可以浏览自己需要参加的考试以及要求进行自我安排;
(6)考试预约功能,在线填写预约信息实现考试的预约;
(7)我的收藏管理功能,管理自己收藏的所有信息;
(8)试卷列表功能,可以查询所有的试卷,选择适合自己的试卷进行考试;
(9)理论考试记录功能,查询考试记录信息;
(10)错题本功能,自己曾经做错的题目都在本界面保存,方便用户进行针对性的学习。
管理员的功能设计为:
(1)驾考文章管理功能,可以发布、编辑、删除驾考文章信息;
(2)个人中心功能,本功能可以修改管理员的个人资料;
(3)学员管理功能,此功能可以对用户的账号、资料等进行审核管理;
(4)驾校管理功能,对驾校的账号、密码等进行管理;
(5)驾照类型管理功能,对不同型号的车需要考不同的驾照,本功能负责类型的管理;
(6)报名入口管理功能,实现学员报名入口信息的审核管理;
(7)学员报名管理功能,实现审核学员报名的功能;
(8)练车预约功能,可以审核学员的预约练车信息;
(9)考试场地管理功能,安排考试的场地;
(10)考试场次管理,安排考试的不同场次;
(11)考试信息管理功能,对考试的内容进行安排;
(12)考试预约管理功能,审核学员的考试预约;
(13)试卷管理功能,可以设置试卷;
(14)试题管理功能,对试题信息进行添加管理;
(15)系统管理功能,发布和管理公告信息、轮播图。
驾校的功能设计为:
(1)个人中心功能,实现对驾校资料的管理;
(2)学员管理功能,实现对自己学员信息的资料管理;
(3)驾考文章管理功能,实现浏览文章信息和管理文章信息;
(4)报名入口管理功能,发布报名信息和管理报名信息;
(5)学员报名管理功能,查询和处理学员的报名;
(6)练车预约功能,审核学员的练车预约并进行安排;
(7)考试信息管理功能,实现考试内容信息的安排管理;
(8)考试预约管理功能,审核学员的预约考试。
数据库脚本
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: ssm856p8
-- ------------------------------------------------------
-- Server version 5.7.31
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `ssm856p8`
--
/*!40000 DROP DATABASE IF EXISTS `ssm856p8`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm856p8` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `ssm856p8`;
--
-- Table structure for table `baomingrukou`
--
DROP TABLE IF EXISTS `baomingrukou`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `baomingrukou` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiaxiaozhanghao` varchar(200) DEFAULT NULL COMMENT '驾校账号',
`jiaxiaomingcheng` varchar(200) DEFAULT NULL COMMENT '驾校名称',
`jiaxiaodizhi` varchar(200) DEFAULT NULL COMMENT '驾校地址',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`jiazhaoleixing` varchar(200) DEFAULT NULL COMMENT '驾照类型',
`xuechefeiyong` int(11) DEFAULT NULL COMMENT '学车费用',
`feiyongshuoming` longtext COMMENT '费用说明',
`fabushijian` date DEFAULT NULL COMMENT '发布时间',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401395541 DEFAULT CHARSET=utf8 COMMENT='报名入口';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `config`
--
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/1639401284236.jpg'),(2,'picture2','upload/1639397873538.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussbaomingrukou`
--
DROP TABLE IF EXISTS `discussbaomingrukou`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussbaomingrukou` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8 COMMENT='报名入口评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussbaomingrukou`
--
LOCK TABLES `discussbaomingrukou` WRITE;
/*!40000 ALTER TABLE `discussbaomingrukou` DISABLE KEYS */;
INSERT INTO `discussbaomingrukou` VALUES (181,'2022-12-13 12:05:19',1,1,'用户名1','评论内容1','回复内容1'),(182,'2022-12-13 12:05:19',2,2,'用户名2','评论内容2','回复内容2'),(183,'2022-12-13 12:05:19',3,3,'用户名3','评论内容3','回复内容3'),(184,'2022-12-13 12:05:19',4,4,'用户名4','评论内容4','回复内容4'),(185,'2022-12-13 12:05:19',5,5,'用户名5','评论内容5','回复内容5'),(186,'2022-12-13 12:05:19',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussbaomingrukou` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussjiakaowenzhang`
--
DROP TABLE IF EXISTS `discussjiakaowenzhang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussjiakaowenzhang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639402724269 DEFAULT CHARSET=utf8 COMMENT='驾考文章评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussjiakaowenzhang`
--
LOCK TABLES `discussjiakaowenzhang` WRITE;
/*!40000 ALTER TABLE `discussjiakaowenzhang` DISABLE KEYS */;
INSERT INTO `discussjiakaowenzhang` VALUES (171,'2022-12-13 12:05:19',1,1,'用户名1','评论内容1','回复内容1'),(172,'2022-12-13 12:05:19',2,2,'用户名2','评论内容2','回复内容2'),(173,'2022-12-13 12:05:19',3,3,'用户名3','评论内容3','回复内容3'),(174,'2022-12-13 12:05:19',4,4,'用户名4','评论内容4','回复内容4'),(175,'2022-12-13 12:05:19',5,5,'用户名5','评论内容5','回复内容5'),(176,'2022-12-13 12:05:19',6,6,'用户名6','评论内容6','回复内容6'),(1639398209707,'2022-12-13 12:23:29',1639398025803,1639398187581,'1','很实用','可以回复评论,也可以删除'),(1639398779668,'2022-12-13 12:32:59',1639398025803,1639398722897,'4','可以评论',''),(1639402562823,'2022-12-13 13:36:01',1639401384292,1639402534653,'7','很实用',''),(1639402724268,'2022-12-13 13:38:43',1639401384292,1639402701758,'8','ERFEW','');
/*!40000 ALTER TABLE `discussjiakaowenzhang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusskaoshixinxi`
--
DROP TABLE IF EXISTS `discusskaoshixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusskaoshixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639402588634 DEFAULT CHARSET=utf8 COMMENT='考试信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discusskaoshixinxi`
--
LOCK TABLES `discusskaoshixinxi` WRITE;
/*!40000 ALTER TABLE `discusskaoshixinxi` DISABLE KEYS */;
INSERT INTO `discusskaoshixinxi` VALUES (191,'2022-12-13 12:05:19',1,1,'用户名1','评论内容1','回复内容1'),(192,'2022-12-13 12:05:19',2,2,'用户名2','评论内容2','回复内容2'),(193,'2022-12-13 12:05:19',3,3,'用户名3','评论内容3','回复内容3'),(194,'2022-12-13 12:05:19',4,4,'用户名4','评论内容4','回复内容4'),(195,'2022-12-13 12:05:19',5,5,'用户名5','评论内容5','回复内容5'),(196,'2022-12-13 12:05:19',6,6,'用户名6','评论内容6','回复内容6'),(1639398830390,'2022-12-13 12:33:50',1639398080794,1639398722897,'4','fdt',''),(1639402588633,'2022-12-13 13:36:28',106,1639402534653,'7','ddwre','');
/*!40000 ALTER TABLE `discusskaoshixinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `exampaper`
--
DROP TABLE IF EXISTS `exampaper`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `exampaper` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`name` varchar(200) NOT NULL COMMENT '试卷名称',
`time` int(11) NOT NULL COMMENT '理论考试时长(分钟)',
`status` int(11) NOT NULL DEFAULT '0' COMMENT '试卷状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401090393 DEFAULT CHARSET=utf8 COMMENT='试卷表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `exampaper`
--
LOCK TABLES `exampaper` WRITE;
/*!40000 ALTER TABLE `exampaper` DISABLE KEYS */;
INSERT INTO `exampaper` VALUES (1639401090392,'2022-12-13 13:11:30','科目四考试',30,1);
/*!40000 ALTER TABLE `exampaper` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `examquestion`
--
DROP TABLE IF EXISTS `examquestion`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `examquestion` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`paperid` bigint(20) NOT NULL COMMENT '所属试卷id(外键)',
`papername` varchar(200) NOT NULL COMMENT '试卷名称',
`questionname` varchar(200) NOT NULL COMMENT '试题名称',
`options` longtext COMMENT '选项,json字符串',
`score` bigint(20) DEFAULT '0' COMMENT '分值',
`answer` varchar(200) DEFAULT NULL COMMENT '正确答案',
`analysis` longtext COMMENT '答案解析',
`type` bigint(20) DEFAULT '0' COMMENT '试题类型,0:单选题 1:多选题 2:判断题 3:填空题(暂不考虑多项填空)',
`sequence` bigint(20) DEFAULT '100' COMMENT '试题排序,值越大排越前面',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401273845 DEFAULT CHARSET=utf8 COMMENT='试题表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `examquestion`
--
LOCK TABLES `examquestion` WRITE;
/*!40000 ALTER TABLE `examquestion` DISABLE KEYS */;
INSERT INTO `examquestion` VALUES (1639401173608,'2022-12-13 13:12:53',1639401090392,'科目四考试','下长坡时,控制车速最正确做法是','[{\"text\":\"A.空档滑行\",\"code\":\"A\"},{\"text\":\"B.使用驻车制动器\",\"code\":\"B\"},{\"text\":\"C.踩下离合器踏板滑行\",\"code\":\"C\"},{\"text\":\"D.挂低速挡\",\"code\":\"D\"}]',30,'D','填写正确答案解析',0,1),(1639401209573,'2022-12-13 13:13:28',1639401090392,'科目四考试','眼睛明暗适应过程不会影响行车安全','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',30,'B','会影响行车安全',2,3),(1639401273844,'2022-12-13 13:14:33',1639401090392,'科目四考试','驾驶汽车在冰雪道路上怎么安全行驶','[{\"text\":\"A.开启雾灯行驶\",\"code\":\"A\"},{\"text\":\"B.利用发动机制动\",\"code\":\"B\"},{\"text\":\"C.必须降低车速\",\"code\":\"C\"},{\"text\":\"D.必要时安装防滑链\",\"code\":\"D\"}]',40,'B,C,D','FRTRE',1,2);
/*!40000 ALTER TABLE `examquestion` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `examrecord`
--
DROP TABLE IF EXISTS `examrecord`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `examrecord` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`paperid` bigint(20) NOT NULL COMMENT '试卷id(外键)',
`papername` varchar(200) NOT NULL COMMENT '试卷名称',
`questionid` bigint(20) NOT NULL COMMENT '试题id(外键)',
`questionname` varchar(200) NOT NULL COMMENT '试题名称',
`options` longtext COMMENT '选项,json字符串',
`score` bigint(20) DEFAULT '0' COMMENT '分值',
`answer` varchar(200) DEFAULT NULL COMMENT '正确答案',
`analysis` longtext COMMENT '答案解析',
`myscore` bigint(20) NOT NULL DEFAULT '0' COMMENT '试题得分',
`myanswer` varchar(200) DEFAULT NULL COMMENT '考生答案',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639402859108 DEFAULT CHARSET=utf8 COMMENT='理论考试记录表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `jiakaowenzhang`
--
DROP TABLE IF EXISTS `jiakaowenzhang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiakaowenzhang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`biaoti` varchar(200) DEFAULT NULL COMMENT '标题',
`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
`neirong` longtext COMMENT '内容',
`fabushijian` date DEFAULT NULL COMMENT '发布时间',
`jiaxiaozhanghao` varchar(200) DEFAULT NULL COMMENT '驾校账号',
`jiaxiaomingcheng` varchar(200) DEFAULT NULL COMMENT '驾校名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401384293 DEFAULT CHARSET=utf8 COMMENT='驾考文章';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `jiaxiao`
--
DROP TABLE IF EXISTS `jiaxiao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaxiao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiaxiaozhanghao` varchar(200) NOT NULL COMMENT '驾校账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`jiaxiaomingcheng` varchar(200) NOT NULL COMMENT '驾校名称',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`lianxiren` varchar(200) DEFAULT NULL COMMENT '联系人',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
`jiaxiaodizhi` varchar(200) DEFAULT NULL COMMENT '驾校地址',
PRIMARY KEY (`id`),
UNIQUE KEY `jiaxiaozhanghao` (`jiaxiaozhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401346810 DEFAULT CHARSET=utf8 COMMENT='驾校';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `jiazhaoleixing`
--
DROP TABLE IF EXISTS `jiazhaoleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiazhaoleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiazhaoleixing` varchar(200) NOT NULL COMMENT '驾照类型',
PRIMARY KEY (`id`),
UNIQUE KEY `jiazhaoleixing` (`jiazhaoleixing`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401054485 DEFAULT CHARSET=utf8 COMMENT='驾照类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiazhaoleixing`
--
LOCK TABLES `jiazhaoleixing` WRITE;
/*!40000 ALTER TABLE `jiazhaoleixing` DISABLE KEYS */;
INSERT INTO `jiazhaoleixing` VALUES (41,'2022-12-13 12:05:19','驾照类型1'),(42,'2022-12-13 12:05:19','驾照类型2'),(43,'2022-12-13 12:05:19','驾照类型3'),(1639397595973,'2022-12-13 12:13:15','A1'),(1639401054484,'2022-12-13 13:10:54','C1');
/*!40000 ALTER TABLE `jiazhaoleixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kaoshichangci`
--
DROP TABLE IF EXISTS `kaoshichangci`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaoshichangci` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`kaoshichangci` varchar(200) NOT NULL COMMENT '考试场次',
PRIMARY KEY (`id`),
UNIQUE KEY `kaoshichangci` (`kaoshichangci`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401076784 DEFAULT CHARSET=utf8 COMMENT='考试场次';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kaoshichangci`
--
LOCK TABLES `kaoshichangci` WRITE;
/*!40000 ALTER TABLE `kaoshichangci` DISABLE KEYS */;
INSERT INTO `kaoshichangci` VALUES (91,'2022-12-13 12:05:19','考试场次1'),(92,'2022-12-13 12:05:19','考试场次2'),(93,'2022-12-13 12:05:19','考试场次3'),(94,'2022-12-13 12:05:19','考试场次4'),(95,'2022-12-13 12:05:19','考试场次5'),(96,'2022-12-13 12:05:19','考试场次6'),(1639400413622,'2022-12-13 13:00:13','第一场'),(1639401076783,'2022-12-13 13:11:16','第二场');
/*!40000 ALTER TABLE `kaoshichangci` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kaoshichangdi`
--
DROP TABLE IF EXISTS `kaoshichangdi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaoshichangdi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`kaoshichangdi` varchar(200) NOT NULL COMMENT '考试场地',
PRIMARY KEY (`id`),
UNIQUE KEY `kaoshichangdi` (`kaoshichangdi`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401066454 DEFAULT CHARSET=utf8 COMMENT='考试场地';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kaoshichangdi`
--
LOCK TABLES `kaoshichangdi` WRITE;
/*!40000 ALTER TABLE `kaoshichangdi` DISABLE KEYS */;
INSERT INTO `kaoshichangdi` VALUES (81,'2022-12-13 12:05:19','考试场地1'),(82,'2022-12-13 12:05:19','考试场地2'),(83,'2022-12-13 12:05:19','考试场地3'),(84,'2022-12-13 12:05:19','考试场地4'),(85,'2022-12-13 12:05:19','考试场地5'),(86,'2022-12-13 12:05:19','考试场地6'),(1639400393468,'2022-12-13 12:59:52','中英驾校'),(1639401066453,'2022-12-13 13:11:06','城西驾校');
/*!40000 ALTER TABLE `kaoshichangdi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kaoshixinxi`
--
DROP TABLE IF EXISTS `kaoshixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaoshixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`kaoshikemu` varchar(200) DEFAULT NULL COMMENT '考试科目',
`fengmiantu` varchar(200) DEFAULT NULL COMMENT '封面图',
`kaoshineirong` longtext COMMENT '考试内容',
`kaoshichangdi` varchar(200) DEFAULT NULL COMMENT '考试场地',
`kaoshiriqi` date DEFAULT NULL COMMENT '考试日期',
`kaoshichangci` varchar(200) DEFAULT NULL COMMENT '考试场次',
`jiezhishijian` datetime DEFAULT NULL COMMENT '截止时间',
`jiaxiaozhanghao` varchar(200) DEFAULT NULL COMMENT '驾校账号',
`jiaxiaomingcheng` varchar(200) DEFAULT NULL COMMENT '驾校名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401428921 DEFAULT CHARSET=utf8 COMMENT='考试信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kaoshixinxi`
--
--
-- Table structure for table `kaoshiyuyue`
--
DROP TABLE IF EXISTS `kaoshiyuyue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaoshiyuyue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`kaoshikemu` varchar(200) DEFAULT NULL COMMENT '考试科目',
`fengmiantu` varchar(200) DEFAULT NULL COMMENT '封面图',
`kaoshichangdi` varchar(200) DEFAULT NULL COMMENT '考试场地',
`kaoshiriqi` varchar(200) DEFAULT NULL COMMENT '考试日期',
`kaoshichangci` varchar(200) DEFAULT NULL COMMENT '考试场次',
`yuyueshijian` datetime DEFAULT NULL COMMENT '预约时间',
`jiaxiaozhanghao` varchar(200) DEFAULT NULL COMMENT '驾校账号',
`jiaxiaomingcheng` varchar(200) DEFAULT NULL COMMENT '驾校名称',
`xueyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '学员账号',
`xueyuanxingming` varchar(200) DEFAULT NULL COMMENT '学员姓名',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639402755306 DEFAULT CHARSET=utf8 COMMENT='考试预约';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `liancheyuyue`
--
DROP TABLE IF EXISTS `liancheyuyue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liancheyuyue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiaxiaozhanghao` varchar(200) DEFAULT NULL COMMENT '驾校账号',
`jiaxiaomingcheng` varchar(200) DEFAULT NULL COMMENT '驾校名称',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`jiaxiaodizhi` varchar(200) DEFAULT NULL COMMENT '驾校地址',
`yuyuekemu` varchar(200) DEFAULT NULL COMMENT '预约科目',
`yuyueshijian` datetime DEFAULT NULL COMMENT '预约时间',
`xueyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '学员账号',
`xueyuanxingming` varchar(200) DEFAULT NULL COMMENT '学员姓名',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639402818207 DEFAULT CHARSET=utf8 COMMENT='练车预约';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `liancheyuyue`
--
--
-- 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` varchar(200) NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639401319553 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '收藏名称',
`picture` varchar(200) NOT NULL COMMENT '收藏图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639402751357 DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
INSERT INTO `storeup` VALUES (1639398771930,'2022-12-13 12:32:51',1639398722897,1639398025803,'jiakaowenzhang','倒车入库技巧','upload/1639398015886.jpg','1'),(1639402557258,'2022-12-13 13:35:56',1639402534653,1639401384292,'jiakaowenzhang','倒车入库技巧','upload/1639401365893.jpg','1'),(1639402570691,'2022-12-13 13:36:09',1639402534653,1639401395540,'baomingrukou','中英驾校','upload/1639401355067.jpg','1'),(1639402718735,'2022-12-13 13:38:37',1639402701758,1639401384292,'jiakaowenzhang','倒车入库技巧','upload/1639401365893.jpg','1'),(1639402736153,'2022-12-13 13:38:55',1639402701758,1639401395540,'baomingrukou','中英驾校','upload/1639401355067.jpg','1');
/*!40000 ALTER TABLE `storeup` 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=11 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-12-13 12:05:19');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xueyuan`
--
DROP TABLE IF EXISTS `xueyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xueyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xueyuanzhanghao` varchar(200) NOT NULL COMMENT '学员账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xueyuanxingming` varchar(200) NOT NULL COMMENT '学员姓名',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
PRIMARY KEY (`id`),
UNIQUE KEY `xueyuanzhanghao` (`xueyuanzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1639402701759 DEFAULT CHARSET=utf8 COMMENT='学员';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xueyuan`
--
--
-- Table structure for table `xueyuanbaoming`
--
DROP TABLE IF EXISTS `xueyuanbaoming`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xueyuanbaoming` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiaxiaozhanghao` varchar(200) DEFAULT NULL COMMENT '驾校账号',
`jiaxiaomingcheng` varchar(200) DEFAULT NULL COMMENT '驾校名称',
`jiaxiaodizhi` varchar(200) DEFAULT NULL COMMENT '驾校地址',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`jiazhaoleixing` varchar(200) DEFAULT NULL COMMENT '驾照类型',
`xuechefeiyong` varchar(200) DEFAULT NULL COMMENT '学车费用',
`baomingshijian` date DEFAULT NULL COMMENT '报名时间',
`xueyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '学员账号',
`xueyuanxingming` varchar(200) DEFAULT NULL COMMENT '学员姓名',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1639402739061 DEFAULT CHARSET=utf8 COMMENT='学员报名';
/*!40101 SET character_set_client = @saved_cs_client */;
项目截图