基于springboot的驾校预约管理系统的设计与实现 （含源码+sql+视频导入教程）

👉文末查看项目功能视频演示+获取源码+sql脚本+视频导入教程视频

1 、功能描述

  基于springboot的驾校预约管理系统5拥有三种角色：管理员、教练、学员

管理员：学员管理、教练管理、车辆管理、车辆关联、维修管理等

教练：学员查看/毕业、添加课程、维修申请等

学员：预约选课，取消预约、练车记录、个人中心

1.1 背景描述

  驾校管理系统是一种针对驾校和驾驶培训中心设计的软件系统，旨在改善和简化驾校的日常运营和管理。该系统通常包括学员信息管理、课程安排、教练员分配、车辆管理、费用结算、学车进度跟踪等功能。通过这些功能，驾校管理系统能够帮助管理者更有效地组织和监督学员的学习进度，合理安排课程时间和资源，并提供教练员和学员之间的有效沟通渠道。此外，系统还可以简化报名流程、考试预约及成绩录入，帮助学员轻松管理自己的学车过程。随着技术的发展，一些驾校管理系统还整合了在线学习和模拟考试等功能，使学车更加便捷高效。通过使用驾校管理系统，驾校和培训中心可以提升管理效率，优化资源利用，同时为学员提供更好的学车体验。

2、项目技术

后端框架：Mybatis、springboot

前端技术：Bootstrap、html、css、JavaScript、JQuery

2.1 springboot

  Spring Boot是由Pivotal团队提供的基于Spring的框架，该框架使用了特定的方式来进行配置，从而使开发人员不再需要定义样板化的配置。Spring Boot集成了绝大部分目前流行的开发框架，就像Maven集成了所有的JAR包一样，Spring Boot集成了几乎所有的框架，使得开发者能快速搭建Spring项目。

2.2 mysql

  MySQL是一款Relational Database Management System，直译过来的意思就是关系型数据库管理系统，MySQL有着它独特的特点，这些特点使他成为目前最流行的RDBMS之一，MySQL想比与其他数据库如ORACLE、DB2等，它属于一款体积小、速度快的数据库，重点是它符合本次毕业设计的真实租赁环境，拥有成本低，开发源码这些特点，这也是选择它的主要原因。

3、开发环境

  • JAVA版本：JDK1.8
  • IDE类型：IDEA、Eclipse都可运行
  • tomcat版本：不需要
  • 数据库类型：MySql（5.5-5.7、8.x版本都可）
  • maven版本：无限制
  • 硬件环境：Windows

4、功能截图+视频演示+文档目录

4.1 登录

登录

4.2 管理员模块

管理员-车辆关联

管理员-维修管理

4.3 教练模块

教练-我的课程

教练-添加课程

教练-车辆维修管理

教练-维修记录

教练-学员毕业

4.4学员模块

学员-预约练车

5 、核心代码实现

5.1 配置代码

server:servlet:context-path: /
spring:datasource:url: jdbc:mysql://127.0.0.1:3306/car-school?useUnicode=true&characterEncoding=utf-8&useSSL=false&tcpRcvBuf=1024000&autoReconnect=true&failOverReadOnly=false&connectTimeout=0&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=trueuserName: rootpassword: rootdriverClassName : com.mysql.cj.jdbc.Driverredis:host: 127.0.0.1port: 6379password:timeout: 120000readTimeout: 120000database: 5jedis:pool:min-idle: 8max-idle: 500max-active: 2000max-wait: 60000locationTemp: /Users/singer/data #上传文件的临时目录mvc:view:prefix: /WEB-INF/suffix: .jspweb:resources:static-locations: classpath:webapp/mybatis:mapper-locations: classpath:mapper/*.xml    # mapper映射文件位置type-aliases-package: com.singulee.carschool.pojo    # 实体类所在的位置configuration:log-impl: org.apache.ibatis.logging.stdout.StdOutImplmapUnderscoreToCamelCase: true

5.2 SQL脚本

/*Navicat Premium Data TransferSource Server         : localhost_3306Source Server Type    : MySQLSource Server Version : 50718Source Host           : localhost:3306Source Schema         : car-schoolTarget Server Type    : MySQLTarget Server Version : 50718File Encoding         : 65001Date: 06/04/2022 15:57:01
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart`  (`carId` int(11) NOT NULL AUTO_INCREMENT COMMENT '车辆id 主键',`carNumber` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车牌',`carDriverClass` int(11) NULL DEFAULT NULL COMMENT '驾驶证类型',`staute` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前状态 维修 正常 报废 备用 ',`cartStartDate` date NULL DEFAULT NULL COMMENT '购入时间',`carEndDate` date NULL DEFAULT NULL COMMENT '结束时间',`extend2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`carId`) USING BTREE,INDEX `cart_driver`(`carDriverClass`) USING BTREE,CONSTRAINT `cart_ibfk_1` FOREIGN KEY (`carDriverClass`) REFERENCES `driver` (`driverId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '������Ϣ' ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of cart
-- ----------------------------
INSERT INTO `cart` VALUES (1, '渝A00001', 1, '正常', '2022-03-09', NULL, NULL);
INSERT INTO `cart` VALUES (2, '渝A12345', 2, '正常', '2022-02-19', NULL, NULL);
INSERT INTO `cart` VALUES (3, '渝C66666', 3, '正常', '2022-03-02', NULL, NULL);
INSERT INTO `cart` VALUES (4, '渝B33333', 7, '正常', '2022-03-01', NULL, NULL);
INSERT INTO `cart` VALUES (5, '渝A88888', 6, '备用', '2022-01-31', NULL, NULL);
INSERT INTO `cart` VALUES (6, '渝A99999', 1, '正常', '2022-02-18', NULL, NULL);
INSERT INTO `cart` VALUES (7, '渝A66666', 1, '正常', '2020-06-10', NULL, NULL);
INSERT INTO `cart` VALUES (8, '渝F99999', 1, '正常', '2016-07-14', NULL, NULL);
INSERT INTO `cart` VALUES (9, '京A12345', 7, '备用', '2019-05-13', NULL, NULL);
INSERT INTO `cart` VALUES (10, '渝A666888', 6, '备用', '2022-03-10', NULL, NULL);
INSERT INTO `cart` VALUES (11, '渝A00002', 7, '备用', '2022-03-10', NULL, NULL);
INSERT INTO `cart` VALUES (12, '渝A00003', 1, '正常', '2022-03-10', NULL, NULL);-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course`  (`courseId` int(11) NOT NULL AUTO_INCREMENT COMMENT '课程 id主键',`courseName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程名称 第N节课 ',`courseBegin` time NULL DEFAULT NULL COMMENT '开始时间',`courseEnd` time NULL DEFAULT NULL COMMENT '结束时间',PRIMARY KEY (`courseId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '课程安排时间' ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES (1, '第一节', '07:20:00', '08:00:00');
INSERT INTO `course` VALUES (2, '第二节', '08:10:00', '08:40:00');
INSERT INTO `course` VALUES (3, '第三节', '08:50:00', '09:30:00');
INSERT INTO `course` VALUES (4, '第四节', '09:40:00', '10:20:00');
INSERT INTO `course` VALUES (5, '第五节', '10:30:00', '11:10:00');
INSERT INTO `course` VALUES (6, '第六节', '11:20:00', '12:10:00');
INSERT INTO `course` VALUES (7, '第七节', '12:20:00', '13:00:00');
INSERT INTO `course` VALUES (8, '第八节', '13:10:00', '13:50:00');
INSERT INTO `course` VALUES (9, '第九节', '14:00:00', '14:40:00');
INSERT INTO `course` VALUES (10, '第十节', '14:50:00', '15:30:00');
INSERT INTO `course` VALUES (11, '第十一节', '15:40:00', '16:20:20');
INSERT INTO `course` VALUES (12, '第十二节', '16:30:30', '17:10:00');
INSERT INTO `course` VALUES (13, '第十三节', '17:20:00', '18:00:00');
INSERT INTO `course` VALUES (14, '第十四节', '18:10:00', '18:40:00');
INSERT INTO `course` VALUES (15, '第十五节', '18:50:00', '19:30:00');
INSERT INTO `course` VALUES (16, '第十六节', '19:40:00', '20:20:00');
INSERT INTO `course` VALUES (17, '第十七节', '20:30:30', '21:10:00');
INSERT INTO `course` VALUES (18, '第十八节', '21:20:00', '22:00:00');
INSERT INTO `course` VALUES (19, '第十九节', '22:10:00', '22:40:00');
INSERT INTO `course` VALUES (20, '第二十节', '22:50:00', '23:30:00');-- ----------------------------
-- Table structure for detail
-- ----------------------------
DROP TABLE IF EXISTS `detail`;
CREATE TABLE `detail`  (`detailId` int(11) NOT NULL AUTO_INCREMENT COMMENT '课程详情ID',`courseId` int(11) NULL DEFAULT NULL COMMENT '课程安排id 外键',`relationshipId` int(11) NULL DEFAULT NULL COMMENT '关系表 外键',`stuSta` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态 0未预约 1 已预约',`courseDate` date NULL DEFAULT NULL COMMENT '课程日期',`extend1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程类类型 ',`extend2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程状态 0 草稿  1 发布',PRIMARY KEY (`detailId`) USING BTREE,INDEX `course_id`(`courseId`) USING BTREE,INDEX `tea_id`(`relationshipId`) USING BTREE,CONSTRAINT `detail_ibfk_1` FOREIGN KEY (`courseId`) REFERENCES `course` (`courseId`) ON DELETE RESTRICT ON UPDATE RESTRICT,CONSTRAINT `detail_ibfk_2` FOREIGN KEY (`relationshipId`) REFERENCES `relationship` (`relationshipId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 366 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '课程安排表' ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of detail
-- ----------------------------
INSERT INTO `detail` VALUES (106, 1, 8, '0', '2019-04-13', '科目二基础', '1');
INSERT INTO `detail` VALUES (107, 2, 8, '1', '2019-04-13', '科目二基础', '1');
INSERT INTO `detail` VALUES (108, 3, 8, '0', '2019-04-13', '科目二基础', '1');
INSERT INTO `detail` VALUES (109, 4, 8, '0', '2019-04-13', '科目二基础', '1');
INSERT INTO `detail` VALUES (110, 5, 8, '1', '2019-04-13', '科目二基础', '1');
INSERT INTO `detail` VALUES (111, 13, 8, '0', '2019-04-13', '科目二', '1');
INSERT INTO `detail` VALUES (112, 14, 8, '0', '2019-04-13', '科目二', '1');
INSERT INTO `detail` VALUES (113, 15, 8, '0', '2019-04-13', '科目二', '1');
INSERT INTO `detail` VALUES (114, 16, 8, '0', '2019-04-13', '科目二', '1');
INSERT INTO `detail` VALUES (115, 17, 8, '0', '2019-04-13', '科目二', '1');
INSERT INTO `detail` VALUES (116, 9, 8, '0', '2019-04-13', '科目三', '1');
INSERT INTO `detail` VALUES (117, 10, 8, '0', '2019-04-13', '科目三', '1');
INSERT INTO `detail` VALUES (118, 11, 8, '1', '2019-04-13', '科目三', '1');
INSERT INTO `detail` VALUES (119, 2, 8, '1', '2019-04-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (120, 4, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (121, 17, 8, '0', '2019-04-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (122, 18, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (123, 20, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (124, 7, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (125, 8, 8, '1', '2019-04-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (126, 9, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (127, 11, 8, '0', '2019-04-14', '科目二', '2');
INSERT INTO `detail` VALUES (128, 12, 8, '0', '2019-04-14', '科目二', '2');
INSERT INTO `detail` VALUES (129, 13, 8, '0', '2019-04-14', '科目二', '2');
INSERT INTO `detail` VALUES (130, 1, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (131, 3, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (132, 5, 8, '1', '2019-04-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (133, 6, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (134, 10, 8, '0', '2019-04-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (135, 15, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (136, 16, 8, '1', '2019-04-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (137, 14, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (138, 19, 8, '0', '2019-04-14', '科目二基础', '2');
INSERT INTO `detail` VALUES (139, 7, 8, '0', '2019-04-16', '科目三', '1');
INSERT INTO `detail` VALUES (140, 8, 8, '0', '2019-04-16', '科目三', '1');
INSERT INTO `detail` VALUES (141, 11, 8, '0', '2019-04-16', '科目三', '1');
INSERT INTO `detail` VALUES (142, 12, 8, '0', '2019-04-16', '科目三', '1');
INSERT INTO `detail` VALUES (143, 16, 8, '0', '2019-04-16', '科目二基础', '1');
INSERT INTO `detail` VALUES (144, 17, 8, '0', '2019-04-16', '科目二基础', '1');
INSERT INTO `detail` VALUES (145, 8, 8, '0', '2019-04-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (146, 9, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (147, 10, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (148, 17, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (149, 18, 8, '0', '2019-04-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (150, 6, 8, '1', '2019-04-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (151, 7, 8, '0', '2019-04-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (152, 11, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (153, 19, 8, '0', '2019-04-17', '科目三', '2');
INSERT INTO `detail` VALUES (154, 20, 8, '0', '2019-04-17', '科目三', '2');
INSERT INTO `detail` VALUES (155, 1, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (156, 2, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (157, 3, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (158, 1, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (159, 4, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (160, 5, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (161, 10, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (162, 11, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (163, 12, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (164, 13, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (165, 14, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (166, 15, 8, '0', '2019-04-17', '科目二基础', '2');
INSERT INTO `detail` VALUES (167, 16, 8, '0', '2019-04-17', '科目二基础', '0');
INSERT INTO `detail` VALUES (168, 17, 8, '0', '2019-04-17', '科目二基础', '0');
INSERT INTO `detail` VALUES (169, 19, 8, '0', '2019-04-17', '科目二基础', '0');
INSERT INTO `detail` VALUES (170, 20, 8, '0', '2019-04-17', '科目二基础', '0');
INSERT INTO `detail` VALUES (171, 3, 8, '0', '2019-04-18', '科目三', '1');
INSERT INTO `detail` VALUES (172, 4, 8, '0', '2019-04-18', '科目三', '1');
INSERT INTO `detail` VALUES (173, 5, 8, '0', '2019-04-18', '科目三', '1');
INSERT INTO `detail` VALUES (174, 6, 8, '0', '2019-04-18', '科目三', '1');
INSERT INTO `detail` VALUES (175, 12, 8, '0', '2019-04-18', '科目三', '1');
INSERT INTO `detail` VALUES (176, 13, 8, '0', '2019-04-18', '科目三', '1');
INSERT INTO `detail` VALUES (177, 14, 8, '0', '2019-04-18', '科目三', '1');
INSERT INTO `detail` VALUES (178, 15, 8, '0', '2019-04-18', '科目二基础', '1');
INSERT INTO `detail` VALUES (179, 16, 8, '0', '2019-04-18', '科目二基础', '1');
INSERT INTO `detail` VALUES (180, 17, 8, '0', '2019-04-18', '科目二基础', '1');
INSERT INTO `detail` VALUES (181, 20, 8, '0', '2019-04-18', '科目二基础', '1');
INSERT INTO `detail` VALUES (182, 19, 8, '0', '2019-04-18', '科目二基础', '1');
INSERT INTO `detail` VALUES (183, 18, 8, '0', '2019-04-18', '科目二基础', '0');
INSERT INTO `detail` VALUES (184, 3, 8, '0', '2019-04-27', '科目二基础', '2');
INSERT INTO `detail` VALUES (185, 4, 8, '0', '2019-04-27', '科目二基础', '1');
INSERT INTO `detail` VALUES (186, 5, 8, '0', '2019-04-27', '科目二基础', '1');
INSERT INTO `detail` VALUES (187, 6, 8, '1', '2019-04-27', '科目二基础', '1');
INSERT INTO `detail` VALUES (188, 1, 8, '0', '2019-04-26', '科目二基础', '1');
INSERT INTO `detail` VALUES (189, 2, 8, '1', '2019-04-26', '科目二基础', '1');
INSERT INTO `detail` VALUES (190, 3, 8, '0', '2019-04-26', '科目二基础', '1');
INSERT INTO `detail` VALUES (191, 4, 8, '0', '2019-04-26', '科目二基础', '1');
INSERT INTO `detail` VALUES (192, 6, 8, '0', '2019-04-28', '科目二', '1');
INSERT INTO `detail` VALUES (193, 7, 8, '0', '2019-04-28', '科目二', '1');
INSERT INTO `detail` VALUES (194, 8, 8, '0', '2019-04-28', '科目二', '1');
INSERT INTO `detail` VALUES (195, 9, 8, '0', '2019-04-28', '科目二', '1');
INSERT INTO `detail` VALUES (196, 1, 8, '0', '2019-05-02', '科目二基础', '1');
INSERT INTO `detail` VALUES (197, 2, 8, '0', '2019-05-02', '科目二基础', '1');
INSERT INTO `detail` VALUES (198, 3, 8, '0', '2019-05-02', '科目二基础', '1');
INSERT INTO `detail` VALUES (199, 4, 8, '0', '2019-05-02', '科目二基础', '1');
INSERT INTO `detail` VALUES (200, 5, 8, '0', '2019-05-02', '科目二基础', '1');
INSERT INTO `detail` VALUES (201, 3, 10, '0', '2019-05-03', '科目二基础', '1');
INSERT INTO `detail` VALUES (202, 4, 10, '0', '2019-05-03', '科目二基础', '1');
INSERT INTO `detail` VALUES (203, 5, 10, '0', '2019-05-03', '科目二基础', '1');
INSERT INTO `detail` VALUES (204, 6, 10, '0', '2019-05-03', '科目二基础', '1');
INSERT INTO `detail` VALUES (205, 1, 10, '0', '2019-05-04', '科目三', '1');
INSERT INTO `detail` VALUES (206, 3, 10, '0', '2019-05-04', '科目三', '1');
INSERT INTO `detail` VALUES (207, 14, 10, '0', '2019-05-04', '科目三', '1');
INSERT INTO `detail` VALUES (208, 15, 10, '0', '2019-05-04', '科目三', '1');
INSERT INTO `detail` VALUES (209, 16, 10, '0', '2019-05-04', '科目三', '1');
INSERT INTO `detail` VALUES (210, 1, 10, '0', '2019-05-06', '科目二基础', '1');
INSERT INTO `detail` VALUES (211, 2, 10, '0', '2019-05-06', '科目二基础', '1');
INSERT INTO `detail` VALUES (212, 3, 10, '0', '2019-05-06', '科目二基础', '1');
INSERT INTO `detail` VALUES (213, 4, 10, '0', '2019-05-06', '科目二基础', '1');
INSERT INTO `detail` VALUES (214, 5, 10, '0', '2019-05-06', '科目二基础', '1');
INSERT INTO `detail` VALUES (215, 6, 10, '0', '2019-05-06', '科目二', '1');
INSERT INTO `detail` VALUES (216, 7, 10, '0', '2019-05-06', '科目二', '1');
INSERT INTO `detail` VALUES (217, 8, 10, '0', '2019-05-06', '科目二', '1');
INSERT INTO `detail` VALUES (218, 9, 10, '0', '2019-05-06', '科目二', '1');
INSERT INTO `detail` VALUES (219, 15, 11, '0', '2019-05-06', '科目二', '1');
INSERT INTO `detail` VALUES (220, 16, 11, '0', '2019-05-06', '科目二', '1');
INSERT INTO `detail` VALUES (221, 17, 11, '0', '2019-05-06', '科目二', '1');
INSERT INTO `detail` VALUES (222, 1, 11, '0', '2019-05-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (223, 2, 11, '0', '2019-05-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (224, 3, 11, '0', '2019-05-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (225, 4, 11, '0', '2019-05-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (226, 5, 11, '1', '2019-05-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (227, 1, 11, '0', '2019-05-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (228, 2, 11, '0', '2019-05-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (229, 3, 11, '0', '2019-05-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (230, 4, 11, '0', '2019-05-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (231, 5, 11, '0', '2019-05-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (232, 6, 11, '0', '2019-05-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (233, 7, 11, '0', '2019-05-14', '科目二基础', '1');
INSERT INTO `detail` VALUES (234, 1, 11, '1', '2019-05-15', '科目二', '1');
INSERT INTO `detail` VALUES (235, 2, 11, '0', '2019-05-15', '科目二', '1');
INSERT INTO `detail` VALUES (236, 4, 11, '0', '2019-05-15', '科目二', '1');
INSERT INTO `detail` VALUES (237, 5, 11, '0', '2019-05-15', '科目二', '1');
INSERT INTO `detail` VALUES (238, 6, 11, '0', '2019-05-15', '科目二', '1');
INSERT INTO `detail` VALUES (239, 5, 11, '0', '2019-05-16', '科目三', '1');
INSERT INTO `detail` VALUES (240, 6, 11, '0', '2019-05-16', '科目三', '1');
INSERT INTO `detail` VALUES (241, 7, 11, '0', '2019-05-16', '科目三', '1');
INSERT INTO `detail` VALUES (242, 10, 11, '0', '2019-05-16', '科目二', '1');
INSERT INTO `detail` VALUES (243, 11, 11, '0', '2019-05-16', '科目二', '1');
INSERT INTO `detail` VALUES (244, 12, 11, '0', '2019-05-16', '科目二', '1');
INSERT INTO `detail` VALUES (245, 1, 11, '0', '2019-05-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (246, 2, 11, '0', '2019-05-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (247, 3, 11, '0', '2019-05-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (248, 4, 11, '0', '2019-05-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (249, 6, 11, '0', '2019-05-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (250, 10, 11, '0', '2019-05-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (251, 11, 11, '0', '2019-05-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (252, 12, 11, '0', '2019-05-17', '科目二基础', '1');
INSERT INTO `detail` VALUES (253, 13, 11, '0', '2019-05-17', '科目三', '1');
INSERT INTO `detail` VALUES (254, 14, 11, '0', '2019-05-17', '科目三', '1');
INSERT INTO `detail` VALUES (255, 1, 11, '0', '2019-05-19', '科目二基础', '1');
INSERT INTO `detail` VALUES (256, 2, 11, '0', '2019-05-19', '科目二基础', '1');
INSERT INTO `detail` VALUES (257, 3, 11, '0', '2019-05-19', '科目二基础', '1');
INSERT INTO `detail` VALUES (258, 4, 11, '0', '2019-05-19', '科目二基础', '1');
INSERT INTO `detail` VALUES (259, 5, 11, '0', '2019-05-19', '科目二基础', '1');
INSERT INTO `detail` VALUES (260, 9, 11, '0', '2019-05-19', '科目二', '1');
INSERT INTO `detail` VALUES (261, 10, 11, '0', '2019-05-19', '科目二', '1');
INSERT INTO `detail` VALUES (262, 11, 11, '0', '2019-05-19', '科目二', '1');
INSERT INTO `detail` VALUES (263, 12, 11, '0', '2019-05-19', '科目二', '1');
INSERT INTO `detail` VALUES (264, 16, 11, '0', '2019-05-19', '科目三', '1');
INSERT INTO `detail` VALUES (265, 17, 11, '0', '2019-05-19', '科目三', '1');
INSERT INTO `detail` VALUES (266, 18, 11, '0', '2019-05-19', '科目三', '1');
INSERT INTO `detail` VALUES (267, 2, 15, '0', '2019-05-20', '科目二基础', '1');
INSERT INTO `detail` VALUES (268, 3, 15, '0', '2019-05-20', '科目二基础', '1');
INSERT INTO `detail` VALUES (269, 4, 15, '0', '2019-05-20', '科目二基础', '1');
INSERT INTO `detail` VALUES (270, 9, 15, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (271, 10, 15, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (272, 11, 15, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (273, 12, 15, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (274, 16, 15, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (275, 17, 15, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (276, 18, 15, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (277, 19, 15, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (278, 1, 15, '0', '2019-05-21', '科目二基础', '1');
INSERT INTO `detail` VALUES (279, 2, 15, '0', '2019-05-21', '科目二基础', '1');
INSERT INTO `detail` VALUES (280, 4, 15, '1', '2019-05-21', '科目二基础', '1');
INSERT INTO `detail` VALUES (281, 6, 15, '0', '2019-05-21', '科目二基础', '1');
INSERT INTO `detail` VALUES (282, 9, 15, '0', '2019-05-21', '科目二', '1');
INSERT INTO `detail` VALUES (283, 10, 15, '0', '2019-05-21', '科目二', '1');
INSERT INTO `detail` VALUES (284, 11, 15, '0', '2019-05-21', '科目二', '1');
INSERT INTO `detail` VALUES (285, 15, 15, '0', '2019-05-21', '科目三', '1');
INSERT INTO `detail` VALUES (286, 16, 15, '1', '2019-05-21', '科目三', '1');
INSERT INTO `detail` VALUES (287, 17, 15, '0', '2019-05-21', '科目三', '1');
INSERT INTO `detail` VALUES (288, 18, 15, '0', '2019-05-21', '科目三', '1');
INSERT INTO `detail` VALUES (289, 1, 17, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (290, 2, 17, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (291, 3, 17, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (292, 4, 17, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (293, 5, 17, '0', '2019-05-20', '科目二', '1');
INSERT INTO `detail` VALUES (294, 9, 17, '0', '2019-05-20', '科目二基础', '1');
INSERT INTO `detail` VALUES (295, 10, 17, '0', '2019-05-20', '科目二基础', '1');
INSERT INTO `detail` VALUES (296, 11, 17, '0', '2019-05-20', '科目二基础', '1');
INSERT INTO `detail` VALUES (297, 12, 17, '0', '2019-05-20', '科目二基础', '1');
INSERT INTO `detail` VALUES (298, 13, 17, '0', '2019-05-20', '科目二基础', '1');
INSERT INTO `detail` VALUES (299, 14, 17, '0', '2019-05-20', '科目三', '1');
INSERT INTO `detail` VALUES (300, 15, 17, '0', '2019-05-20', '科目三', '1');
INSERT INTO `detail` VALUES (301, 16, 17, '0', '2019-05-20', '科目三', '1');
INSERT INTO `detail` VALUES (302, 1, 17, '0', '2019-05-21', '科目二基础', '1');
INSERT INTO `detail` VALUES (303, 2, 17, '0', '2019-05-21', '科目二基础', '1');
INSERT INTO `detail` VALUES (304, 3, 17, '0', '2019-05-21', '科目二基础', '1');
INSERT INTO `detail` VALUES (305, 4, 17, '0', '2019-05-21', '科目二基础', '1');
INSERT INTO `detail` VALUES (306, 5, 17, '0', '2019-05-21', '科目二基础', '2');
INSERT INTO `detail` VALUES (307, 10, 17, '0', '2019-05-21', '科目二基础', '2');
INSERT INTO `detail` VALUES (308, 11, 17, '0', '2019-05-21', '科目二基础', '2');
INSERT INTO `detail` VALUES (309, 12, 17, '0', '2019-05-21', '科目二基础', '2');
INSERT INTO `detail` VALUES (310, 13, 17, '0', '2019-05-21', '科目二基础', '1');
INSERT INTO `detail` VALUES (311, 11, 17, '0', '2019-05-21', '科目三', '1');
INSERT INTO `detail` VALUES (312, 12, 17, '0', '2019-05-21', '科目三', '1');
INSERT INTO `detail` VALUES (313, 14, 17, '0', '2019-05-21', '科目三', '1');
INSERT INTO `detail` VALUES (314, 15, 17, '0', '2019-05-21', '科目三', '1');
INSERT INTO `detail` VALUES (315, 2, 17, '0', '2019-05-22', '科目二基础', '1');
INSERT INTO `detail` VALUES (316, 3, 17, '0', '2019-05-22', '科目二基础', '1');
INSERT INTO `detail` VALUES (317, 4, 17, '1', '2019-05-22', '科目二基础', '1');
INSERT INTO `detail` VALUES (318, 10, 17, '1', '2019-05-22', '科目二', '1');
INSERT INTO `detail` VALUES (319, 11, 17, '0', '2019-05-22', '科目二', '1');
INSERT INTO `detail` VALUES (320, 12, 17, '0', '2019-05-22', '科目二', '1');
INSERT INTO `detail` VALUES (321, 13, 17, '0', '2019-05-22', '科目三', '1');
INSERT INTO `detail` VALUES (322, 14, 17, '0', '2019-05-22', '科目三', '1');
INSERT INTO `detail` VALUES (323, 15, 17, '0', '2019-05-22', '科目三', '1');
INSERT INTO `detail` VALUES (324, 16, 17, '0', '2019-05-22', '科目三', '1');
INSERT INTO `detail` VALUES (325, 2, 17, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (326, 3, 17, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (327, 4, 17, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (328, 5, 17, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (329, 11, 17, '0', '2019-05-23', '科目二', '1');
INSERT INTO `detail` VALUES (330, 12, 17, '0', '2019-05-23', '科目二', '1');
INSERT INTO `detail` VALUES (331, 13, 17, '0', '2019-05-23', '科目二', '1');
INSERT INTO `detail` VALUES (332, 15, 17, '0', '2019-05-23', '科目三', '1');
INSERT INTO `detail` VALUES (333, 16, 17, '0', '2019-05-23', '科目三', '1');
INSERT INTO `detail` VALUES (334, 17, 17, '0', '2019-05-23', '科目三', '1');
INSERT INTO `detail` VALUES (335, 2, 15, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (336, 3, 15, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (337, 4, 15, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (338, 5, 15, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (339, 13, 15, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (340, 14, 15, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (341, 15, 15, '0', '2019-05-23', '科目二基础', '1');
INSERT INTO `detail` VALUES (342, 10, 15, '0', '2019-05-23', '科目二', '1');
INSERT INTO `detail` VALUES (343, 16, 15, '0', '2019-05-23', '科目二', '1');
INSERT INTO `detail` VALUES (344, 17, 15, '0', '2019-05-23', '科目三', '1');
INSERT INTO `detail` VALUES (345, 18, 15, '0', '2019-05-23', '科目三', '1');
INSERT INTO `detail` VALUES (346, 19, 15, '0', '2019-05-23', '科目三', '1');
INSERT INTO `detail` VALUES (347, 3, 15, '0', '2022-03-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (348, 4, 15, '0', '2022-03-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (349, 5, 15, '0', '2022-03-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (350, 6, 15, '0', '2022-03-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (351, 11, 15, '0', '2022-03-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (352, 12, 15, '0', '2022-03-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (353, 13, 15, '0', '2022-03-07', '科目二基础', '1');
INSERT INTO `detail` VALUES (354, 2, 15, '1', '2022-03-08', '科目二基础', '1');
INSERT INTO `detail` VALUES (355, 15, 15, '1', '2022-03-08', '科目二基础', '1');
INSERT INTO `detail` VALUES (356, 16, 15, '0', '2022-03-08', '科目二基础', '1');
INSERT INTO `detail` VALUES (357, 17, 15, '0', '2022-03-08', '科目二基础', '1');
INSERT INTO `detail` VALUES (358, 15, 15, '0', '2022-03-09', '科目二基础', '1');
INSERT INTO `detail` VALUES (359, 16, 15, '0', '2022-03-09', '科目二基础', '1');
INSERT INTO `detail` VALUES (360, 7, 15, '1', '2022-03-10', '科目二基础', '1');
INSERT INTO `detail` VALUES (361, 8, 15, '0', '2022-03-10', '科目二基础', '1');
INSERT INTO `detail` VALUES (362, 9, 15, '0', '2022-03-10', '科目二基础', '1');
INSERT INTO `detail` VALUES (363, 10, 15, '0', '2022-03-10', '科目二基础', '1');
INSERT INTO `detail` VALUES (364, 11, 15, '0', '2022-03-10', '科目二基础', '1');
INSERT INTO `detail` VALUES (365, 12, 15, '0', '2022-03-10', '科目二基础', '1');-- ----------------------------
-- Table structure for driver
-- ----------------------------
DROP TABLE IF EXISTS `driver`;
CREATE TABLE `driver`  (`driverId` int(11) NOT NULL AUTO_INCREMENT COMMENT '驾驶证类型主键',`driverDescription` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '驾驶证描述',`extend1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`driverId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '驾驶证类型表' ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of driver
-- ----------------------------
INSERT INTO `driver` VALUES (1, 'A1', ' 大型载客汽车');
INSERT INTO `driver` VALUES (2, 'A2', '重型、中型全挂、半挂汽车列车');
INSERT INTO `driver` VALUES (3, 'A3', '核载10人以上的城市公共汽车');
INSERT INTO `driver` VALUES (4, 'B1', '中型载客汽车');
INSERT INTO `driver` VALUES (5, 'B2', '重型、中型载货汽车等');
INSERT INTO `driver` VALUES (6, 'C1', '小型 、微型载客汽车等');
INSERT INTO `driver` VALUES (7, 'C2', ' 小型 、微型自动挡载客汽车等');
INSERT INTO `driver` VALUES (8, 'C3', ' 低速载货汽车(原四轮农用运输车)');-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message`  (`messageId` int(11) NOT NULL COMMENT '消息Id',`sendId` int(11) NOT NULL COMMENT '发送人id 系统0',`receiveId` int(11) NOT NULL COMMENT '接收人Id',`message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息内容',`sendDate` datetime NULL DEFAULT NULL,`messageSta` int(11) NULL DEFAULT NULL COMMENT '消息状态 0未读  1已读',PRIMARY KEY (`messageId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息表' ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of message
-- ------------------------------ ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (`ordId` int(11) NOT NULL AUTO_INCREMENT COMMENT '预约课程主键',`detailId` int(11) NOT NULL COMMENT '课程详情Id 外键',`stuId` int(11) NOT NULL COMMENT '学院 Id 外键',`logDate` datetime NULL DEFAULT NULL COMMENT '日志日期',`states` int(8) NOT NULL COMMENT '状态 0预约 1 取消',`grade` int(11) NULL DEFAULT NULL COMMENT '评分 1到5',`log` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志内容',`extend1` datetime NULL DEFAULT NULL COMMENT '预约时间',PRIMARY KEY (`ordId`) USING BTREE,INDEX `order_id`(`detailId`) USING BTREE,INDEX `stu_id`(`stuId`) USING BTREE,CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`detailId`) REFERENCES `detail` (`detailId`) ON DELETE RESTRICT ON UPDATE RESTRICT,CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`stuId`) REFERENCES `student` (`stuId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ԤԼ��' ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (16, 110, 10000, NULL, 0, 2, 'hhh', '2019-04-17 11:42:19');
INSERT INTO `orders` VALUES (17, 118, 10000, '2019-04-17 17:37:57', 0, 1, 'rizhi', '2019-04-13 12:15:30');
INSERT INTO `orders` VALUES (18, 107, 10000, '2019-04-17 17:41:08', 0, 5, 'dfsdfdsfsdfdsfdsdf', '2019-04-13 12:15:36');
INSERT INTO `orders` VALUES (19, 119, 10000, NULL, 0, NULL, NULL, '2019-04-13 12:48:11');
INSERT INTO `orders` VALUES (20, 132, 10000, NULL, 0, 4, 'sdsadsadasdsadsadasdasdasdssssssssssssssssssssssssssssssssssssssssssssssssssssssxzxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', '2019-04-17 11:42:37');
INSERT INTO `orders` VALUES (21, 136, 10000, NULL, 0, NULL, NULL, '2019-04-13 12:48:17');
INSERT INTO `orders` VALUES (22, 125, 10000, NULL, 0, NULL, NULL, '2019-04-13 12:51:23');
INSERT INTO `orders` VALUES (23, 150, 10000, NULL, 0, NULL, NULL, '2019-04-17 23:40:40');
INSERT INTO `orders` VALUES (24, 187, 10002, '2019-04-28 17:03:30', 0, 3, 'kkk', '2019-04-28 17:03:09');
INSERT INTO `orders` VALUES (25, 189, 10002, '2019-04-28 17:03:50', 0, 5, 'klllll', '2019-04-28 17:03:18');
INSERT INTO `orders` VALUES (26, 226, 10000, NULL, 0, NULL, NULL, '2019-05-06 09:33:32');
INSERT INTO `orders` VALUES (27, 234, 10000, '2019-05-19 14:21:13', 0, 3, 'hello撒大声地打算打底阿斯顿', '2019-05-14 23:42:45');
INSERT INTO `orders` VALUES (28, 239, 10000, '2019-05-19 18:14:58', 1, 3, '', '2019-05-14 23:48:19');
INSERT INTO `orders` VALUES (29, 286, 10000, NULL, 0, NULL, NULL, '2019-05-20 21:11:03');
INSERT INTO `orders` VALUES (30, 318, 10000, NULL, 0, NULL, NULL, '2019-05-21 00:40:32');
INSERT INTO `orders` VALUES (31, 280, 10004, NULL, 0, NULL, NULL, '2019-05-21 00:46:18');
INSERT INTO `orders` VALUES (32, 317, 10004, NULL, 0, NULL, NULL, '2019-05-21 00:46:31');
INSERT INTO `orders` VALUES (33, 337, 10000, NULL, 1, NULL, NULL, '2019-05-21 17:14:33');
INSERT INTO `orders` VALUES (34, 354, 10000, NULL, 0, NULL, NULL, '2022-03-07 19:21:14');
INSERT INTO `orders` VALUES (35, 355, 10006, '2022-03-07 19:51:20', 0, 5, '很好', '2022-03-07 19:24:32');
INSERT INTO `orders` VALUES (36, 360, 10000, '2022-03-10 11:49:29', 0, 5, '我是日志', '2022-03-10 11:48:52');-- ----------------------------
-- Table structure for relationship
-- ----------------------------
DROP TABLE IF EXISTS `relationship`;
CREATE TABLE `relationship`  (`relationshipId` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`teacherId` int(11) NOT NULL COMMENT '教练Id 外键',`cartId` int(11) NOT NULL COMMENT '车辆id 外键',`startTime` datetime NULL DEFAULT NULL,`endTime` datetime NULL DEFAULT NULL,PRIMARY KEY (`relationshipId`) USING BTREE,INDEX `teacherId`(`teacherId`) USING BTREE,INDEX `cartId`(`cartId`) USING BTREE,CONSTRAINT `relationship_ibfk_1` FOREIGN KEY (`teacherId`) REFERENCES `teacher` (`teaId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of relationship
-- ----------------------------
INSERT INTO `relationship` VALUES (1, 1000, 1, '2019-04-10 18:18:12', '2019-05-02 22:36:54');
INSERT INTO `relationship` VALUES (2, 1000, 1, '2019-03-04 18:18:32', '2019-04-09 18:19:12');
INSERT INTO `relationship` VALUES (3, 1001, 4, '2019-04-04 00:42:58', '2019-04-05 01:04:13');
INSERT INTO `relationship` VALUES (4, 1004, 7, '2019-04-07 01:02:10', NULL);
INSERT INTO `relationship` VALUES (5, 1000, 5, '2019-05-02 22:36:54', '2019-05-02 22:55:21');
INSERT INTO `relationship` VALUES (6, 1000, 4, '2019-05-02 22:55:21', '2019-05-02 23:03:05');
INSERT INTO `relationship` VALUES (7, 1000, 5, '2019-05-02 23:03:05', '2019-05-02 23:06:04');
INSERT INTO `relationship` VALUES (8, 1000, 3, '2019-05-02 23:06:04', '2019-05-02 23:08:08');
INSERT INTO `relationship` VALUES (9, 1000, 4, '2019-05-02 23:08:08', '2019-05-02 23:10:21');
INSERT INTO `relationship` VALUES (10, 1000, 5, '2019-05-02 23:10:21', '2019-05-06 09:32:00');
INSERT INTO `relationship` VALUES (11, 1000, 3, '2019-05-06 09:32:00', '2019-05-19 14:25:02');
INSERT INTO `relationship` VALUES (12, 1000, 5, '2019-05-19 14:25:02', '2019-05-19 14:25:03');
INSERT INTO `relationship` VALUES (13, 1000, 5, '2019-05-19 14:25:03', '2019-05-19 14:25:09');
INSERT INTO `relationship` VALUES (14, 1000, 5, '2019-05-19 14:25:09', '2019-05-19 14:28:25');
INSERT INTO `relationship` VALUES (15, 1000, 4, '2019-05-19 14:28:25', '2022-03-10 15:37:13');
INSERT INTO `relationship` VALUES (16, 1003, 1, '2019-05-19 16:17:21', NULL);
INSERT INTO `relationship` VALUES (17, 1002, 2, '2019-05-19 16:17:30', NULL);
INSERT INTO `relationship` VALUES (18, 1001, 8, '2019-05-21 17:11:53', NULL);
INSERT INTO `relationship` VALUES (19, 1000, 12, '2022-03-10 15:37:13', '2022-03-10 15:38:16');
INSERT INTO `relationship` VALUES (20, 1000, 12, '2022-03-10 15:38:16', '2022-03-10 15:42:50');
INSERT INTO `relationship` VALUES (21, 1000, 12, '2022-03-10 15:42:50', NULL);-- ----------------------------
-- Table structure for repair
-- ----------------------------
DROP TABLE IF EXISTS `repair`;
CREATE TABLE `repair`  (`repairId` int(11) NOT NULL AUTO_INCREMENT COMMENT '维修表id 主键',`cartId` int(11) NULL DEFAULT NULL COMMENT '外键 维修车辆Id',`repairTime` datetime NULL DEFAULT NULL COMMENT '维修时间',`comebackTime` datetime NULL DEFAULT NULL COMMENT '修复时间',`teacherId` int(11) NULL DEFAULT NULL COMMENT '保修人',`cause` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修原因',`extend1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单状态 待处理  维修中 已完成',`extend2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`repairId`) USING BTREE,INDEX `cart_id`(`cartId`) USING BTREE,INDEX `teacher_id`(`teacherId`) USING BTREE,CONSTRAINT `repair_ibfk_2` FOREIGN KEY (`teacherId`) REFERENCES `teacher` (`teaId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '维修表' ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of repair
-- ----------------------------
INSERT INTO `repair` VALUES (1, 3, '2022-03-07 23:08:08', '2022-03-08 13:43:32', 1000, '轮胎坏了', '已完成', NULL);
INSERT INTO `repair` VALUES (2, 4, '2022-03-01 23:10:21', '2022-03-02 13:46:09', 1000, '车窗无反应', '已完成', NULL);
INSERT INTO `repair` VALUES (3, 5, '2022-02-28 09:32:00', '2022-03-01 16:58:48', 1000, '空调坏了', '已完成', NULL);
INSERT INTO `repair` VALUES (4, 5, '2022-03-04 14:28:25', '2022-03-04 16:25:41', 1000, '后视镜坏了', '已完成', NULL);
INSERT INTO `repair` VALUES (5, 12, '2022-03-10 15:42:50', NULL, 1000, '车坏了', '维修中', NULL);-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (`stuId` int(11) NOT NULL AUTO_INCREMENT,`stuName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学员姓名',`stuPhone` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学员电话',`stuPwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',`stuStust` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学员学习状态 科目二基础 科目二 科目三',`stuSta` int(10) NULL DEFAULT NULL COMMENT '驾驶证类型',`stuStartDate` date NULL DEFAULT NULL COMMENT '报名时间',`stuEndDate` date NULL DEFAULT NULL COMMENT '通过时间',`teaId` int(11) NULL DEFAULT NULL COMMENT '教练Id',`stuBirth` date NULL DEFAULT NULL COMMENT '出生日期',`stuSex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别 0 男 1 女',`stuImg` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片',`extend1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`extend2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`stuId`) USING BTREE,INDEX `tea_id`(`teaId`) USING BTREE,INDEX `stuSta`(`stuSta`) USING BTREE,CONSTRAINT `student_ibfk_1` FOREIGN KEY (`stuSta`) REFERENCES `driver` (`driverId`) ON DELETE RESTRICT ON UPDATE RESTRICT,CONSTRAINT `student_ibfk_2` FOREIGN KEY (`teaId`) REFERENCES `teacher` (`teaId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 10009 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '学员表' ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (10000, '提莫', '18888888888', 'e10adc3949ba59abbe56e057f20f883e', '科目二基础', 6, '2022-03-02', NULL, 1000, '1996-08-06', '0', '3e4038d0f2404949bbb89b3e2ba22b96.jpg', NULL, NULL);
INSERT INTO `student` VALUES (10001, '安妮', '18892891100', 'e10adc3949ba59abbe56e057f20f883e', '科目二基础', 1, '2019-03-26', NULL, 1006, '1999-04-12', '2', '30f9d0792c7d4997a2c09b63f2981812.jpg', NULL, NULL);
INSERT INTO `student` VALUES (10002, '崔丝塔娜', '18892891101', 'e10adc3949ba59abbe56e057f20f883e', '科目三', 3, '2019-04-01', '2019-04-28', 1000, '1999-04-16', '2', '4a3e32cb8b264062994c3d8045cd281f.jpg', NULL, NULL);
INSERT INTO `student` VALUES (10003, '阿木木', '18892891102', 'e10adc3949ba59abbe56e057f20f883e', '科目二基础', 1, '2019-04-08', NULL, 1000, '2000-06-14', '0', '835041fa12b041438704ff2c75e3a77a.jpg', NULL, NULL);
INSERT INTO `student` VALUES (10004, '维迦', '18892891350', 'e10adc3949ba59abbe56e057f20f883e', '科目二基础', 2, '2019-05-22', NULL, 1002, '2003-02-12', '0', '14436c995db84d41a03af7747eec41ba.jpg', NULL, NULL);
INSERT INTO `student` VALUES (10005, '凯南', '18892890422', 'e10adc3949ba59abbe56e057f20f883e', '科目二基础', 6, '2019-05-15', NULL, 1006, '1999-07-16', '0', 'a7da17befa5c4b0aa39736b69324686f.jpg', NULL, NULL);
INSERT INTO `student` VALUES (10006, '亚索', '15712365498', 'e10adc3949ba59abbe56e057f20f883e', '科目二基础', 6, '2022-03-07', NULL, 1006, '1999-02-16', '0', 'c1b4ebd5c285455b8c744333eeae737a.jpg', NULL, NULL);
INSERT INTO `student` VALUES (10007, '纳尔', '15711111111', 'e10adc3949ba59abbe56e057f20f883e', '科目二基础', 1, '2022-03-10', NULL, 1000, '2022-03-10', '0', NULL, NULL, NULL);
INSERT INTO `student` VALUES (10008, '哈哈哈哈', '13323498765', 'e10adc3949ba59abbe56e057f20f883e', '科目二基础', 1, '2022-04-06', NULL, 1000, '1990-06-20', '0', '1b9f56b2ace44441bedda7d33c3936a8.jpg', NULL, NULL);-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher`  (`teaId` int(11) NOT NULL AUTO_INCREMENT COMMENT '教练Id 主键',`teaName` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教练姓名',`teaPhone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教练电话',`teaPwd` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码',`teaSex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教练性别 ',`teaSta` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教练状态 0 正常 1 离职',`teaRole` int(11) NULL DEFAULT NULL COMMENT '区分教练和管理员 0教练 1 管理员',`teaDriver` int(11) NULL DEFAULT NULL COMMENT '驾驶证类型多项实用逗号隔开 ,',`teaStartDate` date NULL DEFAULT NULL COMMENT '入职时间',`teaEndDate` date NULL DEFAULT NULL COMMENT '离职时间',`teaBirth` date NULL DEFAULT NULL COMMENT '出生日期',`teaDescript` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职业描述 等',`teaImg` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片',`extend1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段',`exten2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段',PRIMARY KEY (`teaId`) USING BTREE,INDEX `tea_driverid`(`teaDriver`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1015 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '����Ա\r\n' ROW_FORMAT = DYNAMIC;-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES (1000, '艾瑞莉娅', '15712345678', 'e10adc3949ba59abbe56e057f20f883e', '1', '0', 0, 1, '2018-02-14', NULL, '1990-03-09', '主要负责A1', 'fd5a614c8efe4db99cfa72b20b4afc66.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1001, '管理员', '18811111111', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 1, 1, '2020-03-20', NULL, '1990-06-20', NULL, 'mmexport1508332669479.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1002, '赏金猎人', '18892890002', 'e10adc3949ba59abbe56e057f20f883e', '1', '0', 0, 2, '2019-03-12', NULL, '1993-03-23', '问我去', 'fd5a614c8efe4db99cfa72b20b4afc65.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1003, '污渍', '18892890003', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 0, 1, '2022-03-19', NULL, '1990-03-19', '23232', 'adbffff79ac44ca287b14f9b87df4245.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1004, '赵信', '18892890004', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 0, 4, '2020-12-16', NULL, '2019-03-19', '23232', 'fd5a614c8efe4db99cfa72b20b4afc65.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1005, '德玛', '18892890005', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 0, 5, '2019-03-19', NULL, '2019-03-19', '23232', '0ac3281ad0634648bfd6e87d64b6439c.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1006, '皎月', '18892890006', 'e10adc3949ba59abbe56e057f20f883e', '1', '0', 0, 6, '2019-03-18', NULL, '2019-03-25', '', 'fd5a614c8efe4db99cfa72b20b4afc65.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1007, '布里茨', '18892890007', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 0, 1, '2019-11-29', '2022-02-24', '2019-03-28', '4545', 'fd5a614c8efe4db99cfa72b20b4afc65.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1008, '格雷福斯', '18892890008', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 0, 7, '2019-03-27', NULL, '2019-03-11', '515', 'fd5a614c8efe4db99cfa72b20b4afc65.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1009, '薇恩', '18892890009', 'e10adc3949ba59abbe56e057f20f883e', '1', '0', 0, 8, '2019-03-27', '2019-05-19', '2019-03-26', '2323', 'fd5a614c8efe4db99cfa72b20b4afc65.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1010, '维鲁斯', '18892890010', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 0, 1, '2019-03-27', '2019-05-19', '2019-03-12', '阿斯达', '211a6ef301a64f9c9cb7eb3cdacf633e.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1011, '卡萨丁', '18892890011', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 0, 1, '2019-03-26', '2019-05-19', '2019-03-27', '阿萨德', '177f4f81e9144de2bc8d3752ece1def5.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1012, '腕豪', '18892893333', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 0, 2, '2015-05-06', NULL, '2019-05-01', '', '371a75e8a7714f6e98fed6f6496aecfa.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1013, '瑟提', '18323412345', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', 0, 6, '2022-04-06', NULL, '1990-06-19', '我是C1教练', '25a43314e9c04a37b83e2a890b9b4b3e.jpg', NULL, NULL);
INSERT INTO `teacher` VALUES (1014, '皮城女警', '19932145678', 'e10adc3949ba59abbe56e057f20f883e', '1', '0', 0, 6, '2022-04-06', NULL, '1992-06-20', '我是C1女警', '757939826860497894fb18f0a54adb36.jpg', NULL, NULL);-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',`username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户登录名称',`user_type` tinyint(1) NULL DEFAULT NULL COMMENT '用户类型 1.学生;2.教练员;3.管理员',`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户密码',`status` tinyint(1) NULL DEFAULT NULL COMMENT '用户是否有效 1.有效 2.无效',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '15712345678', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (2, '18888888888', 1, '25f9e794323b453885f5181f1b624d0b', 1);
INSERT INTO `user` VALUES (3, '18811111111', 3, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (4, '18892890002', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (5, '18892890003', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (6, '18892890004', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (7, '18892890005', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (8, '18892890006', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (9, '18892890007', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (10, '18892890008', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (11, '18892890009', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (12, '18892890010', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (13, '18892890011', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (14, '18892893333', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (15, '18892891100', 1, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (16, '18892891101', 1, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (17, '18892891102', 1, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (18, '18892891350', 1, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (19, '18892890422', 1, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (20, '15712365498', 1, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (21, '15711111111', 1, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (22, '13323498765', 1, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (23, '18323412345', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (24, '19932145678', 2, 'e10adc3949ba59abbe56e057f20f883e', 1);SET FOREIGN_KEY_CHECKS = 1;

6 、功能视频演示

基于springboot的驾校预约管理系统

7 、 获取方式

👇 大家点赞、收藏、关注、评论啦 👇🏻获取联系方式，后台回复关键词：驾校👇🏻

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：http://www.xdnf.cn/news/143928.html

如若内容造成侵权/违法违规/事实不符，请联系一条长河网进行投诉反馈，一经查实，立即删除！

相关文章

阿里通义千问开源Qwen2.5系列模型：Qwen2-VL-72B媲美GPT-4

阿里通义千问开源Qwen2.5系列模型：Qwen2-VL-72B媲美GPT-4

通义千问团队近日重磅宣布，继其Qwen2模型发布仅三个月后，再次推出Qwen家族的全新成员——Qwen2.5系列语言模型，并已全面开源。这次开源行动堪称史上规模之最，涵盖了通用型Qwen2.5，以及专为编程和数学领域打造的Qwen2.5…
阅读更多...
消息队列-Kafka（概念篇）

消息队列-Kafka（概念篇）

1 为什么需要消息队列？ 消息队列是一种基于消息的异步通信机制，用于在分布式系统中不同组件或服务之间传递数据和通知。实际上可以将消息队列看作为存放消息的容器，参与消息传递的分别称为生产者（发送消息）和消费者&am…
阅读更多...
【网络】高级IO——epoll版本TCP服务器初阶

【网络】高级IO——epoll版本TCP服务器初阶

目录 前言 一，epoll的三个系统调用接口 1.1.epoll_create函数 1.1.1.epoll_create函数干了什么 1.2. epoll_ctl函数 1.2.1.epoll_ctl函数函数干了什么 1.3.epoll_wait函数 1.3.1.epoll_wait到底干了什么 1.4.epoll的工作过程中内核在干什么 二，…
阅读更多...
北斗盒子TD20——水域巡检的安全卫士，落水报警保平安

北斗盒子TD20——水域巡检的安全卫士，落水报警保平安

随着我国水域经济的快速发展，水域巡检工作在保障水上安全、维护水域秩序方面发挥着越来越重要的作用。水域巡检是一项复杂且充满挑战的任务，无论是河流湖泊的日常巡逻，还是海洋环境的监测与保护，都需要高度的警惕和专业的技术支持…
阅读更多...
目前最好的数据可视化项目！一个拖拽编辑的图表工具，上手快，酷炫十足，好用得尖叫！（带私活）

目前最好的数据可视化项目！一个拖拽编辑的图表工具，上手快，酷炫十足，好用得尖叫！（带私活）

数据可视化在当下的工作当中被我们频繁提到或者是利用到，也是因为视觉仍然是目前人们从外界获取信息的主要来源途径。通过图表的处理，我们能够更快速的获取数据要传达的信息。 今天给大家推荐一款目前我见过最好的数据可视化项目-- AJ-Report。 AJ-Rep…
阅读更多...
数据结构之二叉树遍历

数据结构之二叉树遍历

二叉树的遍历 先序遍历 先输入父节点，再遍历左子树和右子树：A、B、D、E、C、F、G 中序遍历 先遍历左子树，再输出父节点，再遍历右子树：D、B、E、A、F、C、G 后序遍历 先遍历左子树，再遍历右子树，…
阅读更多...
攻防世界---＞debug

攻防世界---＞debug

前言： 我的下载。 ILSpy：（静调） ILSpy下载 ILSpy反编译软件 v9.0.0.7618 中文绿色免费版 下载-脚本之家 (jb51.net)https://www.jb51.net/softs/137337.html dnSpy：（动调） dnspy v6.5.1 (2…
阅读更多...
【JSrpc破解前端加密问题】

【JSrpc破解前端加密问题】

目录 一、背景 二、项目介绍 三、JSrpc 处理前端加密步骤 一、背景 解决日常渗透测试、红蓝对抗中的前端密码加密问题，让你的爆破更加丝滑；降低js逆向加密的难度，降低前端加密逻辑分析工作量和难度。 二、项目介绍 运行服务器程序和js脚本…
阅读更多...
TC8：SOMEIP_ETS_009-019

TC8：SOMEIP_ETS_009-019

SOMEIP_ETS_009: echoENUM 目的 检查枚举类型的参数及其顺序能够被顺利地发送和接收 测试步骤 1、Tester：创建SOME/IP消息 2、Tester：使用method echoENUM发送SOME/IP消息 3、DUT：返回method响应消息，其数据（值和顺序）与请求中的相同 期望结果 3、DUT：返回method响应消…
阅读更多...
为什么说开放式比入耳式耳机更受欢迎？精选开放式耳机推荐

为什么说开放式比入耳式耳机更受欢迎？精选开放式耳机推荐

在音频设备不断推陈出新的今天，开放式耳机以其别样的魅力走进人们的视野。与传统入耳式耳机不同，开放式耳机在多个方面独具优势。它能带来清晰自然的音质，让音乐的每一个细节都生动呈现。佩戴上，它给予耳朵充分的自由空间&#xf…
阅读更多...
ABAP-Logger ABAP 日志记录与任何其他语言一样轻松

ABAP-Logger ABAP 日志记录与任何其他语言一样轻松

ABAP-Logger ABAP 日志记录与任何其他语言一样轻松 ABAP Logger SAP Logging as painless as any other language. ABAP Version: 702 or higher See the mission statement Features Record message in Application Log(BC-SRV-BAL)Display message Installation Insta…
阅读更多...
ECCV 2024 | 扩散模型diffusion如何改进？方向论文大汇总

ECCV 2024 | 扩散模型diffusion如何改进？方向论文大汇总

1、∞-Brush : Controllable Large Image Synthesis with Diffusion Models in Infinite Dimensions 从错综复杂的领域特定信息中合成高分辨率图像仍是生成建模中的一个重大挑战，尤其适用于大图像域（如数字组织病理学和遥感）中的应用。现有方…
阅读更多...
android开发 模拟api接口数据

android开发 模拟api接口数据

Android开发者如何模拟接口获得自己想要的数据进行测试? - 简书 (jianshu.com)https://www.jianshu.com/p/05523321e692
阅读更多...
腾讯百度阿里华为常见算法面试题TOP100(6)：回溯、二分查找、二叉树

腾讯百度阿里华为常见算法面试题TOP100(6)：回溯、二分查找、二叉树

之前总结过字节跳动TOP50算法面试题&#xff1a; 字节跳动常见算法面试题top50整理_沉迷单车的追风少年-CSDN博客_字节算法面试题 回溯 46.全排列 class Solution { private:vector<vector<int> > ans;void dfs(vector<int>& nums, vector<int>&a…
阅读更多...
数据库函数

数据库函数

1.字符串函数 例子&#xff1a; 2.数值函数 例子&#xff1a; 3.日期函数 例子&#xff1a; 4.流程函数 例子&#xff1a; 参考视频&#xff1a;27. 基础-函数-字符串函数_哔哩哔哩_bilibili
阅读更多...
高级大数据开发学习路线指南

高级大数据开发学习路线指南

掌握大数据技术是一项系统性工程&#xff0c;涉及到广泛的技能和专业知识。为了帮助初学者构建坚实的基础&#xff0c;并逐步成长为大数据领域的专家&#xff0c;下面详细阐述了一条全面而深入的学习路线&#xff1a; 1. Java 编程基础 - 打造坚实的底层技能 关键知识点&…
阅读更多...
Skyeye 云智能制造 v3.14.5 发布，ERP 商城

Skyeye 云智能制造 v3.14.5 发布，ERP 商城

Skyeye 云智能制造&#xff0c;采用 Springboot winUI 的低代码平台、移动端采用 UNI-APP。包含 30 多个应用模块、50 多种电子流程&#xff0c;CRM、PM、ERP、MES、ADM、EHR、笔记、知识库、项目、门店、商城、财务、多班次考勤、薪资、招聘、云售后、论坛、公告、问卷、报表…
阅读更多...
进程的通信

进程的通信

进程的通信方式 进程的通信方式有很多种&#xff0c;今天我就为大家介绍各种通讯方式&#xff0c;例如:管道&#xff0c;信号&#xff0c;消息队列&#xff0c;共享内存&#xff0c;信号量 1.管道 1.1 管道的简介: 管道分为无名管道与有名管道 无名管道:无名管道用于父子进…
阅读更多...
基于SpringBoot+Vue的企业会议室预定管理系统

基于SpringBoot+Vue的企业会议室预定管理系统

作者&#xff1a;计算机学姐 开发技术&#xff1a;SpringBoot、SSM、Vue、MySQL、JSP、ElementUI、Python、小程序等&#xff0c;“文末源码”。 专栏推荐&#xff1a;前后端分离项目源码、SpringBoot项目源码、SSM项目源码 系统展示 【2025最新】基于JavaSpringBootVueMySQL的…
阅读更多...
Mac 搭建仓颉语言开发环境（Cangjie SDK）

Mac 搭建仓颉语言开发环境（Cangjie SDK）

文章目录 仓颉编程语言通用版本SDK Beta试用报名仓颉语言文档注册 GitCode登录 GitCode 下载 Cangjie SDK配置环境变量VSCode 插件VSCode 创建项目 仓颉编程语言通用版本SDK Beta试用报名 https://wj.qq.com/s2/14870499/c76f/ 仓颉语言文档 https://developer.huawei.com/c…
阅读更多...
最新文章

Copyright @ 2022~2023