功能介绍
本系统用户角色有:管理员、财务、教练、学员
用户端功能有:教练查看、学习计划管理、学习进度管理、考试安排查看、考试 成绩查看、缴费信息管理、招生宣传查看。
管理端功能有:财务管理、教练管理、学员管理、教练分配管理、学习计划管理、学习进度管理、车辆信息管理、车辆维护管理、考试 安排管理、缴费信息管理、招聘宣传管理;
教练端功能有:车辆信息管理、车辆维护管理、学员信息查看 、学习计划管理、学习进度管理;
财务端功能有:车辆维护管理、缴费信息管理、个人中心。
更多功能请看运行截图!
使用技术
开发语言:Java
使用框架:ssm
前端技术:JavaScript、VUE.js(2.X)、css3
数据库:MySQL 5.7
数据库管理工具:Navicat或sqlyog
开发工具:IDEA或Eclipse均可
项目截图
数据库脚本
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: jspm7e3c8
-- ------------------------------------------------------
-- 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: `jspm7e3c8`
--
/*!40000 DROP DATABASE IF EXISTS `jspm7e3c8`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jspm7e3c8` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `jspm7e3c8`;
--
-- Table structure for table `caiwu`
--
DROP TABLE IF EXISTS `caiwu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caiwu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`caiwuzhanghao` varchar(200) NOT NULL COMMENT '财务账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`caiwuxingming` varchar(200) NOT NULL COMMENT '财务姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
PRIMARY KEY (`id`),
UNIQUE KEY `caiwuzhanghao` (`caiwuzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='财务';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `caiwu`
--
LOCK TABLES `caiwu` WRITE;
/*!40000 ALTER TABLE `caiwu` DISABLE KEYS */;
INSERT INTO `caiwu` VALUES (31,'2022-04-28 04:09:40','财务账号1','123456','财务姓名1','男','13823888881','440300199101010001'),(32,'2022-04-28 04:09:40','财务账号2','123456','财务姓名2','男','13823888882','440300199202020002'),(33,'2022-04-28 04:09:40','财务账号3','123456','财务姓名3','男','13823888883','440300199303030003'),(34,'2022-04-28 04:09:40','财务账号4','123456','财务姓名4','男','13823888884','440300199404040004'),(35,'2022-04-28 04:09:40','财务账号5','123456','财务姓名5','男','13823888885','440300199505050005'),(36,'2022-04-28 04:09:40','财务账号6','123456','财务姓名6','男','13823888886','440300199606060006');
/*!40000 ALTER TABLE `caiwu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cheliangweihu`
--
DROP TABLE IF EXISTS `cheliangweihu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cheliangweihu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`cheliangbianhao` varchar(200) DEFAULT NULL COMMENT '车辆编号',
`cheliangpinpai` varchar(200) DEFAULT NULL COMMENT '车辆品牌',
`weihuleixing` varchar(200) DEFAULT NULL COMMENT '维护类型',
`weihujine` float DEFAULT NULL COMMENT '维护金额',
`weihushijian` date DEFAULT NULL COMMENT '维护时间',
`weihuneirong` longtext COMMENT '维护内容',
`jiaolianzhanghao` varchar(200) DEFAULT NULL COMMENT '教练账号',
`jiaolianxingming` varchar(200) DEFAULT NULL COMMENT '教练姓名',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='车辆维护';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cheliangweihu`
--
LOCK TABLES `cheliangweihu` WRITE;
/*!40000 ALTER TABLE `cheliangweihu` DISABLE KEYS */;
INSERT INTO `cheliangweihu` VALUES (81,'2022-04-28 04:09:40','车辆编号1','车辆品牌1','加油',1,'2022-04-28','维护内容1','教练账号1','教练姓名1','是','','未支付'),(82,'2022-04-28 04:09:40','车辆编号2','车辆品牌2','加油',2,'2022-04-28','维护内容2','教练账号2','教练姓名2','是','','未支付'),(83,'2022-04-28 04:09:40','车辆编号3','车辆品牌3','加油',3,'2022-04-28','维护内容3','教练账号3','教练姓名3','是','','未支付'),(84,'2022-04-28 04:09:40','车辆编号4','车辆品牌4','加油',4,'2022-04-28','维护内容4','教练账号4','教练姓名4','是','','未支付'),(85,'2022-04-28 04:09:40','车辆编号5','车辆品牌5','加油',5,'2022-04-28','维护内容5','教练账号5','教练姓名5','是','','未支付'),(86,'2022-04-28 04:09:40','车辆编号6','车辆品牌6','加油',6,'2022-04-28','维护内容6','教练账号6','教练姓名6','是','','未支付');
/*!40000 ALTER TABLE `cheliangweihu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cheliangxinxi`
--
DROP TABLE IF EXISTS `cheliangxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cheliangxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`cheliangbianhao` varchar(200) DEFAULT NULL COMMENT '车辆编号',
`cheliangpinpai` varchar(200) DEFAULT NULL COMMENT '车辆品牌',
`chejiahao` varchar(200) DEFAULT NULL COMMENT '车架号',
`huandangfangshi` varchar(200) DEFAULT NULL COMMENT '换挡方式',
`cheliangnianxian` varchar(200) DEFAULT NULL COMMENT '车辆年限',
`tianjiashijian` date DEFAULT NULL COMMENT '添加时间',
`jiaolianzhanghao` varchar(200) DEFAULT NULL COMMENT '教练账号',
`jiaolianxingming` varchar(200) DEFAULT NULL COMMENT '教练姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='车辆信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cheliangxinxi`
--
LOCK TABLES `cheliangxinxi` WRITE;
/*!40000 ALTER TABLE `cheliangxinxi` DISABLE KEYS */;
INSERT INTO `cheliangxinxi` VALUES (71,'2022-04-28 04:09:40','车辆编号1','车辆品牌1','车架号1','手动挡','车辆年限1','2022-04-28','教练账号1','教练姓名1'),(72,'2022-04-28 04:09:40','车辆编号2','车辆品牌2','车架号2','手动挡','车辆年限2','2022-04-28','教练账号2','教练姓名2'),(73,'2022-04-28 04:09:40','车辆编号3','车辆品牌3','车架号3','手动挡','车辆年限3','2022-04-28','教练账号3','教练姓名3'),(74,'2022-04-28 04:09:40','车辆编号4','车辆品牌4','车架号4','手动挡','车辆年限4','2022-04-28','教练账号4','教练姓名4'),(75,'2022-04-28 04:09:40','车辆编号5','车辆品牌5','车架号5','手动挡','车辆年限5','2022-04-28','教练账号5','教练姓名5'),(76,'2022-04-28 04:09:40','车辆编号6','车辆品牌6','车架号6','手动挡','车辆年限6','2022-04-28','教练账号6','教练姓名6');
/*!40000 ALTER TABLE `cheliangxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- 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/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaofeixinxi`
--
DROP TABLE IF EXISTS `jiaofeixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaofeixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`feiyongmingcheng` varchar(200) DEFAULT NULL COMMENT '费用名称',
`feiyongleixing` varchar(200) DEFAULT NULL COMMENT '费用类型',
`feiyongjine` float DEFAULT NULL COMMENT '费用金额',
`feiyongmiaoshu` longtext COMMENT '费用描述',
`fasongshijian` date DEFAULT NULL COMMENT '发送时间',
`xueyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '学员账号',
`xueyuanxingming` varchar(200) DEFAULT NULL COMMENT '学员姓名',
`caiwuzhanghao` varchar(200) DEFAULT NULL COMMENT '财务账号',
`caiwuxingming` varchar(200) DEFAULT NULL COMMENT '财务姓名',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='缴费信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaofeixinxi`
--
LOCK TABLES `jiaofeixinxi` WRITE;
/*!40000 ALTER TABLE `jiaofeixinxi` DISABLE KEYS */;
INSERT INTO `jiaofeixinxi` VALUES (111,'2022-04-28 04:09:40','费用名称1','费用类型1',1,'费用描述1','2022-04-28','学员账号1','学员姓名1','财务账号1','财务姓名1','是','','未支付'),(112,'2022-04-28 04:09:40','费用名称2','费用类型2',2,'费用描述2','2022-04-28','学员账号2','学员姓名2','财务账号2','财务姓名2','是','','未支付'),(113,'2022-04-28 04:09:40','费用名称3','费用类型3',3,'费用描述3','2022-04-28','学员账号3','学员姓名3','财务账号3','财务姓名3','是','','未支付'),(114,'2022-04-28 04:09:40','费用名称4','费用类型4',4,'费用描述4','2022-04-28','学员账号4','学员姓名4','财务账号4','财务姓名4','是','','未支付'),(115,'2022-04-28 04:09:40','费用名称5','费用类型5',5,'费用描述5','2022-04-28','学员账号5','学员姓名5','财务账号5','财务姓名5','是','','未支付'),(116,'2022-04-28 04:09:40','费用名称6','费用类型6',6,'费用描述6','2022-04-28','学员账号6','学员姓名6','财务账号6','财务姓名6','是','','未支付');
/*!40000 ALTER TABLE `jiaofeixinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaolian`
--
DROP TABLE IF EXISTS `jiaolian`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaolian` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiaolianzhanghao` varchar(200) NOT NULL COMMENT '教练账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`jiaolianxingming` varchar(200) NOT NULL COMMENT '教练姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
PRIMARY KEY (`id`),
UNIQUE KEY `jiaolianzhanghao` (`jiaolianzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='教练';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaolian`
--
LOCK TABLES `jiaolian` WRITE;
/*!40000 ALTER TABLE `jiaolian` DISABLE KEYS */;
INSERT INTO `jiaolian` VALUES (21,'2022-04-28 04:09:40','教练账号1','123456','教练姓名1','男',1,'13823888881','440300199101010001'),(22,'2022-04-28 04:09:40','教练账号2','123456','教练姓名2','男',2,'13823888882','440300199202020002'),(23,'2022-04-28 04:09:40','教练账号3','123456','教练姓名3','男',3,'13823888883','440300199303030003'),(24,'2022-04-28 04:09:40','教练账号4','123456','教练姓名4','男',4,'13823888884','440300199404040004'),(25,'2022-04-28 04:09:40','教练账号5','123456','教练姓名5','男',5,'13823888885','440300199505050005'),(26,'2022-04-28 04:09:40','教练账号6','123456','教练姓名6','男',6,'13823888886','440300199606060006');
/*!40000 ALTER TABLE `jiaolian` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaolianfenpei`
--
DROP TABLE IF EXISTS `jiaolianfenpei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaolianfenpei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiaolianzhanghao` varchar(200) DEFAULT NULL COMMENT '教练账号',
`jiaolianxingming` varchar(200) DEFAULT NULL COMMENT '教练姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`jiaolianjieshao` longtext COMMENT '教练介绍',
`xueyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '学员账号',
`xueyuanxingming` varchar(200) DEFAULT NULL COMMENT '学员姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='教练分配';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaolianfenpei`
--
LOCK TABLES `jiaolianfenpei` WRITE;
/*!40000 ALTER TABLE `jiaolianfenpei` DISABLE KEYS */;
INSERT INTO `jiaolianfenpei` VALUES (41,'2022-04-28 04:09:40','教练账号1','教练姓名1','性别1',1,'13823888881','教练介绍1','学员账号1','学员姓名1'),(42,'2022-04-28 04:09:40','教练账号2','教练姓名2','性别2',2,'13823888882','教练介绍2','学员账号2','学员姓名2'),(43,'2022-04-28 04:09:40','教练账号3','教练姓名3','性别3',3,'13823888883','教练介绍3','学员账号3','学员姓名3'),(44,'2022-04-28 04:09:40','教练账号4','教练姓名4','性别4',4,'13823888884','教练介绍4','学员账号4','学员姓名4'),(45,'2022-04-28 04:09:40','教练账号5','教练姓名5','性别5',5,'13823888885','教练介绍5','学员账号5','学员姓名5'),(46,'2022-04-28 04:09:40','教练账号6','教练姓名6','性别6',6,'13823888886','教练介绍6','学员账号6','学员姓名6');
/*!40000 ALTER TABLE `jiaolianfenpei` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kaoshianpai`
--
DROP TABLE IF EXISTS `kaoshianpai`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaoshianpai` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xueyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '学员账号',
`xueyuanxingming` varchar(200) DEFAULT NULL COMMENT '学员姓名',
`kaoshixiangmu` varchar(200) DEFAULT NULL COMMENT '考试项目',
`kaoshishijian` datetime DEFAULT NULL COMMENT '考试时间',
`kaoshididian` varchar(200) DEFAULT NULL COMMENT '考试地点',
`zhuyishixiang` longtext COMMENT '注意事项',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='考试安排';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kaoshianpai`
--
LOCK TABLES `kaoshianpai` WRITE;
/*!40000 ALTER TABLE `kaoshianpai` DISABLE KEYS */;
INSERT INTO `kaoshianpai` VALUES (91,'2022-04-28 04:09:40','学员账号1','学员姓名1','科目一','2022-04-28 12:09:40','考试地点1','注意事项1'),(92,'2022-04-28 04:09:40','学员账号2','学员姓名2','科目一','2022-04-28 12:09:40','考试地点2','注意事项2'),(93,'2022-04-28 04:09:40','学员账号3','学员姓名3','科目一','2022-04-28 12:09:40','考试地点3','注意事项3'),(94,'2022-04-28 04:09:40','学员账号4','学员姓名4','科目一','2022-04-28 12:09:40','考试地点4','注意事项4'),(95,'2022-04-28 04:09:40','学员账号5','学员姓名5','科目一','2022-04-28 12:09:40','考试地点5','注意事项5'),(96,'2022-04-28 04:09:40','学员账号6','学员姓名6','科目一','2022-04-28 12:09:40','考试地点6','注意事项6');
/*!40000 ALTER TABLE `kaoshianpai` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kaoshichengji`
--
DROP TABLE IF EXISTS `kaoshichengji`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaoshichengji` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xueyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '学员账号',
`xueyuanxingming` varchar(200) DEFAULT NULL COMMENT '学员姓名',
`kaoshixiangmu` varchar(200) DEFAULT NULL COMMENT '考试项目',
`kaoshishijian` date DEFAULT NULL COMMENT '考试时间',
`kaoshichengji` float DEFAULT NULL COMMENT '考试成绩',
`kaoshijieguo` varchar(200) DEFAULT NULL COMMENT '考试结果',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='考试成绩';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kaoshichengji`
--
LOCK TABLES `kaoshichengji` WRITE;
/*!40000 ALTER TABLE `kaoshichengji` DISABLE KEYS */;
INSERT INTO `kaoshichengji` VALUES (101,'2022-04-28 04:09:40','学员账号1','学员姓名1','考试项目1','2022-04-28',1,'通过'),(102,'2022-04-28 04:09:40','学员账号2','学员姓名2','考试项目2','2022-04-28',2,'通过'),(103,'2022-04-28 04:09:40','学员账号3','学员姓名3','考试项目3','2022-04-28',3,'通过'),(104,'2022-04-28 04:09:40','学员账号4','学员姓名4','考试项目4','2022-04-28',4,'通过'),(105,'2022-04-28 04:09:40','学员账号5','学员姓名5','考试项目5','2022-04-28',5,'通过'),(106,'2022-04-28 04:09:40','学员账号6','学员姓名6','考试项目6','2022-04-28',6,'通过');
/*!40000 ALTER TABLE `kaoshichengji` 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 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- 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-04-28 04:09:40');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xuexijihua`
--
DROP TABLE IF EXISTS `xuexijihua`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuexijihua` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xueyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '学员账号',
`xueyuanxingming` varchar(200) DEFAULT NULL COMMENT '学员姓名',
`lianxishijian` datetime DEFAULT NULL COMMENT '练习时间',
`lianxishizhang` varchar(200) DEFAULT NULL COMMENT '练习时长',
`lianxididian` varchar(200) DEFAULT NULL COMMENT '练习地点',
`lianxineirong` longtext COMMENT '练习内容',
`jiaolianzhanghao` varchar(200) DEFAULT NULL COMMENT '教练账号',
`jiaolianxingming` varchar(200) DEFAULT NULL COMMENT '教练姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='学习计划';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xuexijihua`
--
LOCK TABLES `xuexijihua` WRITE;
/*!40000 ALTER TABLE `xuexijihua` DISABLE KEYS */;
INSERT INTO `xuexijihua` VALUES (51,'2022-04-28 04:09:40','学员账号1','学员姓名1','2022-04-28 12:09:40','练习时长1','练习地点1','练习内容1','教练账号1','教练姓名1'),(52,'2022-04-28 04:09:40','学员账号2','学员姓名2','2022-04-28 12:09:40','练习时长2','练习地点2','练习内容2','教练账号2','教练姓名2'),(53,'2022-04-28 04:09:40','学员账号3','学员姓名3','2022-04-28 12:09:40','练习时长3','练习地点3','练习内容3','教练账号3','教练姓名3'),(54,'2022-04-28 04:09:40','学员账号4','学员姓名4','2022-04-28 12:09:40','练习时长4','练习地点4','练习内容4','教练账号4','教练姓名4'),(55,'2022-04-28 04:09:40','学员账号5','学员姓名5','2022-04-28 12:09:40','练习时长5','练习地点5','练习内容5','教练账号5','教练姓名5'),(56,'2022-04-28 04:09:40','学员账号6','学员姓名6','2022-04-28 12:09:40','练习时长6','练习地点6','练习内容6','教练账号6','教练姓名6');
/*!40000 ALTER TABLE `xuexijihua` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xuexijindu`
--
DROP TABLE IF EXISTS `xuexijindu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuexijindu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xueyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '学员账号',
`xueyuanxingming` varchar(200) DEFAULT NULL COMMENT '学员姓名',
`xuexineirong` longtext COMMENT '学习内容',
`xuexishizhang` varchar(200) DEFAULT NULL COMMENT '学习时长',
`xuexijindu` varchar(200) DEFAULT NULL COMMENT '学习进度',
`tianjiariqi` date DEFAULT NULL COMMENT '添加日期',
`jiaolianzhanghao` varchar(200) DEFAULT NULL COMMENT '教练账号',
`jiaolianxingming` varchar(200) DEFAULT NULL COMMENT '教练姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='学习进度';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xuexijindu`
--
LOCK TABLES `xuexijindu` WRITE;
/*!40000 ALTER TABLE `xuexijindu` DISABLE KEYS */;
INSERT INTO `xuexijindu` VALUES (61,'2022-04-28 04:09:40','学员账号1','学员姓名1','学习内容1','学习时长1','已学会','2022-04-28','教练账号1','教练姓名1'),(62,'2022-04-28 04:09:40','学员账号2','学员姓名2','学习内容2','学习时长2','已学会','2022-04-28','教练账号2','教练姓名2'),(63,'2022-04-28 04:09:40','学员账号3','学员姓名3','学习内容3','学习时长3','已学会','2022-04-28','教练账号3','教练姓名3'),(64,'2022-04-28 04:09:40','学员账号4','学员姓名4','学习内容4','学习时长4','已学会','2022-04-28','教练账号4','教练姓名4'),(65,'2022-04-28 04:09:40','学员账号5','学员姓名5','学习内容5','学习时长5','已学会','2022-04-28','教练账号5','教练姓名5'),(66,'2022-04-28 04:09:40','学员账号6','学员姓名6','学习内容6','学习时长6','已学会','2022-04-28','教练账号6','教练姓名6');
/*!40000 ALTER TABLE `xuexijindu` 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 '学员姓名',
`xingbie` 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=17 DEFAULT CHARSET=utf8 COMMENT='学员';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xueyuan`
--
LOCK TABLES `xueyuan` WRITE;
/*!40000 ALTER TABLE `xueyuan` DISABLE KEYS */;
INSERT INTO `xueyuan` VALUES (11,'2022-04-28 04:09:40','学员账号1','123456','学员姓名1','男','13823888881','440300199101010001'),(12,'2022-04-28 04:09:40','学员账号2','123456','学员姓名2','男','13823888882','440300199202020002'),(13,'2022-04-28 04:09:40','学员账号3','123456','学员姓名3','男','13823888883','440300199303030003'),(14,'2022-04-28 04:09:40','学员账号4','123456','学员姓名4','男','13823888884','440300199404040004'),(15,'2022-04-28 04:09:40','学员账号5','123456','学员姓名5','男','13823888885','440300199505050005'),(16,'2022-04-28 04:09:40','学员账号6','123456','学员姓名6','男','13823888886','440300199606060006');
/*!40000 ALTER TABLE `xueyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zhaoshengxuanchuan`
--
DROP TABLE IF EXISTS `zhaoshengxuanchuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zhaoshengxuanchuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`biaoti` varchar(200) DEFAULT NULL COMMENT '标题',
`jianjie` longtext COMMENT '简介',
`neirong` longtext COMMENT '内容',
`fabushijian` date DEFAULT NULL COMMENT '发布时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COMMENT='招生宣传';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zhaoshengxuanchuan`
--
LOCK TABLES `zhaoshengxuanchuan` WRITE;
/*!40000 ALTER TABLE `zhaoshengxuanchuan` DISABLE KEYS */;
INSERT INTO `zhaoshengxuanchuan` VALUES (121,'2022-04-28 04:09:40','标题1','简介1','内容1','2022-04-28'),(122,'2022-04-28 04:09:40','标题2','简介2','内容2','2022-04-28'),(123,'2022-04-28 04:09:40','标题3','简介3','内容3','2022-04-28'),(124,'2022-04-28 04:09:40','标题4','简介4','内容4','2022-04-28'),(125,'2022-04-28 04:09:40','标题5','简介5','内容5','2022-04-28'),(126,'2022-04-28 04:09:40','标题6','简介6','内容6','2022-04-28');
/*!40000 ALTER TABLE `zhaoshengxuanchuan` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-04-28 12:11:00