功能介绍

角色为用户、管理员、驾校。框架界面分为用户操作界面、管理员操作界面和驾校操作界面。用户的功能设计为：

（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 version5.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,'-12-13 12:05:19',1,1,'用户名1','评论内容1','回复内容1'),(182,'-12-13 12:05:19',2,2,'用户名2','评论内容2','回复内容2'),(183,'-12-13 12:05:19',3,3,'用户名3','评论内容3','回复内容3'),(184,'-12-13 12:05:19',4,4,'用户名4','评论内容4','回复内容4'),(185,'-12-13 12:05:19',5,5,'用户名5','评论内容5','回复内容5'),(186,'-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,'-12-13 12:05:19',1,1,'用户名1','评论内容1','回复内容1'),(172,'-12-13 12:05:19',2,2,'用户名2','评论内容2','回复内容2'),(173,'-12-13 12:05:19',3,3,'用户名3','评论内容3','回复内容3'),(174,'-12-13 12:05:19',4,4,'用户名4','评论内容4','回复内容4'),(175,'-12-13 12:05:19',5,5,'用户名5','评论内容5','回复内容5'),(176,'-12-13 12:05:19',6,6,'用户名6','评论内容6','回复内容6'),(1639398209707,'-12-13 12:23:29',1639398025803,1639398187581,'1','很实用','可以回复评论，也可以删除'),(1639398779668,'-12-13 12:32:59',1639398025803,1639398722897,'4','可以评论',''),(1639402562823,'-12-13 13:36:01',1639401384292,1639402534653,'7','很实用',''),(1639402724268,'-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,'-12-13 12:05:19',1,1,'用户名1','评论内容1','回复内容1'),(192,'-12-13 12:05:19',2,2,'用户名2','评论内容2','回复内容2'),(193,'-12-13 12:05:19',3,3,'用户名3','评论内容3','回复内容3'),(194,'-12-13 12:05:19',4,4,'用户名4','评论内容4','回复内容4'),(195,'-12-13 12:05:19',5,5,'用户名5','评论内容5','回复内容5'),(196,'-12-13 12:05:19',6,6,'用户名6','评论内容6','回复内容6'),(1639398830390,'-12-13 12:33:50',1639398080794,1639398722897,'4','fdt',''),(1639402588633,'-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,'-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,'-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,'-12-13 13:13:28',1639401090392,'科目四考试','眼睛明暗适应过程不会影响行车安全','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',30,'B','会影响行车安全',2,3),(1639401273844,'-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,'-12-13 12:05:19','驾照类型1'),(42,'-12-13 12:05:19','驾照类型2'),(43,'-12-13 12:05:19','驾照类型3'),(1639397595973,'-12-13 12:13:15','A1'),(1639401054484,'-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,'-12-13 12:05:19','考试场次1'),(92,'-12-13 12:05:19','考试场次2'),(93,'-12-13 12:05:19','考试场次3'),(94,'-12-13 12:05:19','考试场次4'),(95,'-12-13 12:05:19','考试场次5'),(96,'-12-13 12:05:19','考试场次6'),(1639400413622,'-12-13 13:00:13','第一场'),(1639401076783,'-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,'-12-13 12:05:19','考试场地1'),(82,'-12-13 12:05:19','考试场地2'),(83,'-12-13 12:05:19','考试场地3'),(84,'-12-13 12:05:19','考试场地4'),(85,'-12-13 12:05:19','考试场地5'),(86,'-12-13 12:05:19','考试场地6'),(1639400393468,'-12-13 12:59:52','中英驾校'),(1639401066453,'-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,'-12-13 12:32:51',1639398722897,1639398025803,'jiakaowenzhang','倒车入库技巧','upload/1639398015886.jpg','1'),(1639402557258,'-12-13 13:35:56',1639402534653,1639401384292,'jiakaowenzhang','倒车入库技巧','upload/1639401365893.jpg','1'),(1639402570691,'-12-13 13:36:09',1639402534653,1639401395540,'baomingrukou','中英驾校','upload/1639401355067.jpg','1'),(1639402718735,'-12-13 13:38:37',1639402701758,1639401384292,'jiakaowenzhang','倒车入库技巧','upload/1639401365893.jpg','1'),(1639402736153,'-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','管理员','-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 */;

项目截图

如果觉得《微信小程序优选驾考驾照考试预约+后台管理系统SSM-JAVA【数据库设计 论文 源码 开题报告】》对你有帮助，请点赞、收藏，并留下你的观点哦！