微信小程序优选驾考驾照考试预约+后台管理系统SSM-JAVA【数据库设计、论文、源码、开题报告】

功能介绍

角色为用户、管理员、驾校。框架界面分为用户操作界面、管理员操作界面和驾校操作界面。用户的功能设计为:
(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 */;




项目截图

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

  • 1
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值