基于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.rhkb.cn/news/430203.html

如若内容造成侵权/违法违规/事实不符，请联系长河编程网进行投诉反馈email:809451989@qq.com，一经查实，立即删除！

相关文章

脱离枯燥的CRUD，灵活使用Mybatis，根据mybatis动态的xml片段和接口规范动态生成代理类，轻松应付简单业务场景。

脱离枯燥的CRUD，灵活使用Mybatis，根据mybatis动态的xml片段和接口规范动态生成代理类，轻松应付简单业务场景。

需求 需求是这样的，我们有一个数据服务平台的产品，用户先将数据源信息保存到平台上，一个数据源可以提供多个接口服务，而每个接口服务在数据库中存一个具有mybatis语法的sql片段。这样的话，对于一些简单的业务只需要编…
阅读更多...
电力施工作业安全行为检测图像数据集

电力施工作业安全行为检测图像数据集

电力施工作业安全行为检测图像数据集，图片总共 2300左右，标注为voc(xml)格式，包含高空抛物，未佩戴安全带，高处作业无人监护等。 电力施工作业安全行为检测图像数据集 数据集描述 这是一个专门用于电力施工作业安全行…
阅读更多...
Drive.js 的一些 Api 使用记录

Drive.js 的一些 Api 使用记录

文章目录 2024 年 drive.js 的基础使用想在下一步的时候处理些逻辑呢？(同步)Element 的各种选择器 2024 年 drive.js 的基础使用 安装就跳过了 npm install driver.js ，一行代码就可以搞定 官网的 Basic Usage 基础使用的截图如下： 想在下…
阅读更多...
SLAM实操入门（八）：使用Robosence-16转换数据格式，进行基于A-Loam的三维SLAM

SLAM实操入门（八）：使用Robosence-16转换数据格式，进行基于A-Loam的三维SLAM

文章目录 前言1 Robosence与Velodyne格式差异.2 格式转换2.1 rs_to_velodyne库2.2 目前支持： 3 拉取工程并编译2.1 安装robosence雷达驱动（类似第六章）：2.2 构建rs2vel工程： 3 运行robosence雷达，并转换格式…
阅读更多...
2012年408考研真题-数据结构

2012年408考研真题-数据结构

8.【2012统考真题】求整数n(n≥0)的阶乘的算法如下&#xff0c;其时间复杂度是(&#xff09;。 int fact(int n){ if(n<1) return 1; return n*fact (n-1); } A. O(log2n) B. O(n) C. O(nlog2n) D. O(n^2) 解析&#xff1a; 观察代码&#xff0c;我们不…
阅读更多...
Matlab Simulink 主时间步(major time step)、子时间步(minor time step)

Matlab Simulink 主时间步(major time step)、子时间步(minor time step)

高亮颜色说明&#xff1a;突出重点 个人觉得&#xff0c;&#xff1a;待核准个人观点是否有误 高亮颜色超链接 文章目录 对Simulink 时间步的理解Simulink 采样时间的类型Discrete Sample Times(离散采样时间)Controllable Sample Time(可控采样时间) Continuous Sample Times(…
阅读更多...
在MAC中Ollama开放其他电脑访问

在MAC中Ollama开放其他电脑访问

ollama安装完毕后默认只能在本地访问&#xff0c;之前我都是安装其他的软件之后可以结合开放其他端口访问&#xff0c;其实是可以新增或修改下电脑的系统配置&#xff0c;就可以打开端口允许除本机IP或localhost访问。 步骤如下&#xff1a; 1、查看端口&#xff08;默认是&…
阅读更多...
Shelly实测天工的音乐创作功能，写了一首歌，来听听效果

Shelly实测天工的音乐创作功能，写了一首歌，来听听效果

​ 大家好&#xff0c;我是Shelly&#xff0c;一个专注于输出AI工具和科技前沿内容的AI应用教练&#xff0c;体验过300款以上的AI应用工具。关注科技及大模型领域对社会的影响10年。关注我一起驾驭AI工具&#xff0c;拥抱AI时代的到来。 在数字时代的洪流中&#xff0c;我始终…
阅读更多...
杀软对抗 ---＞ Perfect Syscall??

杀软对抗 ---＞ Perfect Syscall??

好久没更了&#xff0c;今天想起来更新了&#x1f60b;&#x1f60b;&#x1f60b;&#x1f60b; 目录 1.AV && EDR 2.Perfect Syscall&#xff1f;&#xff1f; 3.Truly Perfect ??? 在开始之前先来展示一下这次的免杀效果 1.AV && EDR 360 天擎EDR …
阅读更多...
Python模块和包：自定义模块和包③

Python模块和包：自定义模块和包③

文章目录 一、模块1.1 什么是模块1.2 创建模块1.3 导入模块1.4 模块的命名空间 二、包2.1 什么是包2.2 创建包2.3 导入包2.4 包的命名空间 三、综合详细例子3.1 项目结构3.2 模块代码student.pycourse.pymanager.py 3.3 主程序代码main.py 3.4 运行结果 四、总结 Python模块和包…
阅读更多...
Apifox 「定时任务」操作指南，解锁自动化测试的新利器

Apifox 「定时任务」操作指南，解锁自动化测试的新利器

定时任务是按照预设时间自动执行的任务&#xff0c;它可以有效解决一些常见问题&#xff0c;比如频繁执行的回归测试和大规模的接口测试&#xff0c;这些任务需要在固定时间点或间隔周期内自动运行&#xff0c;以确保软件的持续集成和持续交付过程中的稳定性和可靠性。通过使用…
阅读更多...
计算机网络34——Windows内存管理

计算机网络34——Windows内存管理

1、计算机体系结构 2、内存管理 分为连续分配管理和非连续分配管理 在块内存在的未使用空间叫内部碎片&#xff0c;在块外存在的未使用空间叫外部碎片 固定分区分配可能出现内部碎片&#xff0c;动态分区分配可能出现外部碎片 3、逻辑地址和实际地址的互相转换 4、缺页中断 …
阅读更多...
微信支付商户 - 如何开通商家转账到零钱

微信支付商户 - 如何开通商家转账到零钱

商家转账到零钱功能的快速开通&#xff0c;需要商家遵循一系列步骤并确保所有条件符合微信支付的要求。以下是一些关键步骤和注意事项&#xff0c;以确保商家可以最快开通该功能&#xff1a; 一、确认申请资格 1. 公司性质&#xff1a;确保申请主体为公司性质&#xff08;有限…
阅读更多...
【Docker】安装全流程与配置完整镜像源（可安装 nginx）

【Docker】安装全流程与配置完整镜像源（可安装 nginx）

目录 一、卸载历史版本&#xff08;选&#xff09;二、配置 yum 源三、安装 docker四、配置 docker 镜像源加速&#xff08;选、强烈建议&#xff09;4.1 配置阿里镜像加速4.2 配置其他镜像源 五、启动 docker参考文章与视频 本文基于 Linux - CentOS 7 操作系统。 一、卸载历史…
阅读更多...
Unity3D入门(二) :Unity3D实现视角的丝滑过渡切换

Unity3D入门(二) :Unity3D实现视角的丝滑过渡切换

1. 前言 上篇文章&#xff0c;我们已经初步了解了Unity3D&#xff0c;并新建并运行起来了一个项目&#xff0c;使相机视角自动围绕着立方体旋转。 这篇文章&#xff0c;我们来讲一下Unity3D怎么过渡地切换视角。 我们继续是我上篇文章中的项目&#xff0c;但是需要向把Camera…
阅读更多...
TFT-LCD显示屏（1.8寸 STM32）

TFT-LCD显示屏（1.8寸 STM32）

目录 一、介绍 二、传感器原理 1.原理图 2.引脚描述 3.工作原理&#xff1a;TFT-LCD色彩空间 三、程序设计 main.c文件 lcd.h文件 lcd.c文件 四、实验效果 五、资料获取 项目分享 一、介绍 TFT-LCD&#xff0c;全称Thin Film Transistor Liquid Crystal Display&a…
阅读更多...
Golang | Leetcode Golang题解之第409题最长回文串

Golang | Leetcode Golang题解之第409题最长回文串

题目&#xff1a; 题解&#xff1a; func longestPalindrome(s string) int {mp : map[byte]int{}for i : 0; i < len(s); i {mp[s[i]]}res : 0for _, v : range mp {if v&1 1 {res v - 1} else {res v}}if res<len(s) {res}return res }
阅读更多...
C++笔记21•C++11的新特性•

C++笔记21•C++11的新特性•

相比于 C98/03&#xff0c;C11则带来了数量可观的变化&#xff0c;其中包含了约140个新特性&#xff0c;以及对C03标准中约600个缺陷的修正&#xff0c;这使得C11更像是从C98/03中孕育出的一种新语言。相比较而言&#xff0c;C11能更好地用于系统开发和库开发、语法更加泛华和简…
阅读更多...
如何合并pdf文件，四款软件，三步搞定！

如何合并pdf文件，四款软件，三步搞定！

在数字化办公的浪潮中&#xff0c;PDF文档因其跨平台兼容性和安全性&#xff0c;成为了我们日常工作中不可或缺的一部分。然而&#xff0c;面对多个PDF文件需要整合成一个文件时&#xff0c;不少小伙伴可能会感到头疼。别担心&#xff0c;今天我们就来揭秘四款高效PDF合并软件&…
阅读更多...
演示：基于WPF的DrawingVisual开发的Chart图表和表格绘制

演示：基于WPF的DrawingVisual开发的Chart图表和表格绘制

一、目的&#xff1a;基于WPF的DrawingVisual开发的Chart图表和表格绘制 二、预览 钻井井轨迹表格数据演示示例&#xff08;应用Table布局&#xff0c;模拟井轨迹深度的绘制&#xff09; 饼图表格数据演示示例&#xff08;应用Table布局&#xff0c;模拟多个饼状图组合显示&am…
阅读更多...
最新文章
推荐文章

Copyright @ 2022~2023