基于SpringBoot足球场在线预约系统的设计与实现

????博主介绍????:✌在职Java研发工程师、专注于程序设计、源码分享、技术交流、专注于Java技术领域和毕业设计
温馨提示:文末有 **** 平台官方提供的老师 Wechat / QQ 名片 :)

Java精品实战案例《700套》

2025最新毕业设计选题推荐:最热的500个选题o( ̄▽ ̄)d

介绍

系统功能设计旨在满足用户需求并实现系统的核心功能。基于SpringBoot框架和微信小程序技术,系统功能设计包括统计分析、用户管理、场地管理、订单管理、广告管理、项目管理、场馆管理和管理员管理等模块。通过统计分析功能,管理员可以了解系统运行情况并做出有效决策。用户管理模块确保用户信息的准确性和完整性。场地管理模块使管理员能够方便地维护智能球馆信息。订单管理模块保证预约流程顺利进行。广告管理模块提高系统商业价值。项目管理模块满足用户不同需求。场馆管理模块确保场馆运营正常进行。管理员管理模块保证系统后台安全稳定运行。综上所述,系统功能设计全面覆盖用户和管理员需求,提供高效便捷的足球场地预约服务。

系统功能

系统截图

功能代码

/*{\"gymId\":58,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":59,\"gymName\":\"外场3\",\"price\":15.00,\"timeList\":[{\"gymId\":59,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":20,\"price\":15.00}]}]');
INSERT INTO `g_gym_appoint` VALUES (667, NULL, 6, '[{\"gymId\":52,\"gymName\":\"外场1-1\",\"price\":15.00,\"timeList\":[{\"gymId\":52,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":53,\"gymName\":\"外场1-2\",\"price\":15.00,\"timeList\":[{\"gymId\":53,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":57,\"gymName\":\"外场2-1\",\"price\":15.00,\"timeList\":[{\"gymId\":57,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":58,\"gymName\":\"外场2-2\",\"price\":15.00,\"timeList\":[{\"gymId\":58,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":59,\"gymName\":\"外场3\",\"price\":15.00,\"timeList\":[{\"gymId\":59,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":20,\"price\":15.00}]}]');
INSERT INTO `g_gym_appoint` VALUES (668, NULL, 6, '[{\"gymId\":52,\"gymName\":\"外场1-1\",\"price\":15.00,\"timeList\":[{\"gymId\":52,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":53,\"gymName\":\"外场1-2\",\"price\":15.00,\"timeList\":[{\"gymId\":53,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":57,\"gymName\":\"外场2-1\",\"price\":15.00,\"timeList\":[{\"gymId\":57,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":58,\"gymName\":\"外场2-2\",\"price\":15.00,\"timeList\":[{\"gymId\":58,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":59,\"gymName\":\"外场3\",\"price\":15.00,\"timeList\":[{\"gymId\":59,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":20,\"price\":15.00}]}]');
INSERT INTO `g_gym_appoint` VALUES (669, NULL, 6, '[{\"gymId\":52,\"gymName\":\"外场1-1\",\"price\":15.00,\"timeList\":[{\"gymId\":52,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":52,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":53,\"gymName\":\"外场1-2\",\"price\":15.00,\"timeList\":[{\"gymId\":53,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":53,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":57,\"gymName\":\"外场2-1\",\"price\":15.00,\"timeList\":[{\"gymId\":57,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":57,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":58,\"gymName\":\"外场2-2\",\"price\":15.00,\"timeList\":[{\"gymId\":58,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":58,\"status\":0,\"time\":20,\"price\":15.00}]},{\"gymId\":59,\"gymName\":\"外场3\",\"price\":15.00,\"timeList\":[{\"gymId\":59,\"status\":0,\"time\":9,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":10,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":11,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":12,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":13,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":14,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":15,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":16,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":17,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":18,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":19,\"price\":15.00},{\"gymId\":59,\"status\":0,\"time\":20,\"price\":15.00}]}]');
INSERT INTO `g_gym_appoint` VALUES (670, NULL, 4, '[{\"gymId\":36,\"gymName\":\"内场1-1\",\"price\":80.00,\"timeList\":[{\"gymId\":36,\"status\":0,\"time\":9,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":10,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":11,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":12,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":13,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":14,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":15,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":16,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":17,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":18,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":19,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":20,\"price\":80.00}]},{\"gymId\":37,\"gymName\":\"内场1-2\",\"price\":80.00,\"timeList\":[{\"gymId\":37,\"status\":1,\"time\":9,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":10,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":11,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":12,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":13,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":14,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":15,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":16,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":17,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":18,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":19,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":20,\"price\":80.00}]}]');
INSERT INTO `g_gym_appoint` VALUES (671, '2024-03-19 00:00:00', 3, '[{\"gymId\":35,\"gymName\":\"三人制\",\"price\":80.00,\"timeList\":[{\"gymId\":35,\"status\":1,\"time\":9,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":10,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":11,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":12,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":13,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":14,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":15,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":16,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":17,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":18,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":19,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":20,\"price\":80.00}]},{\"gymId\":34,\"gymName\":\"五人制\",\"price\":90.00,\"timeList\":[{\"gymId\":34,\"status\":1,\"time\":9,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":10,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":11,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":12,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":13,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":14,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":15,\"price\":90.00},{\"gymId\":34,\"status\":2,\"time\":16,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":17,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":18,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":19,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":20,\"price\":90.00}]}]');
INSERT INTO `g_gym_appoint` VALUES (672, '2024-03-19 00:00:00', 4, '[{\"gymId\":36,\"gymName\":\"内场1-1\",\"price\":80.00,\"timeList\":[{\"gymId\":36,\"status\":0,\"time\":9,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":10,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":11,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":12,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":13,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":14,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":15,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":16,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":17,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":18,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":19,\"price\":80.00},{\"gymId\":36,\"status\":0,\"time\":20,\"price\":80.00}]},{\"gymId\":37,\"gymName\":\"内场1-2\",\"price\":80.00,\"timeList\":[{\"gymId\":37,\"status\":1,\"time\":9,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":10,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":11,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":12,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":13,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":14,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":15,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":16,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":17,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":18,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":19,\"price\":80.00},{\"gymId\":37,\"status\":1,\"time\":20,\"price\":80.00}]}]');
INSERT INTO `g_gym_appoint` VALUES (673, '2024-04-22 00:00:00', 3, '[{\"gymId\":35,\"gymName\":\"三人制\",\"price\":80.00,\"timeList\":[{\"gymId\":35,\"status\":1,\"time\":9,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":10,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":11,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":12,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":13,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":14,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":15,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":16,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":17,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":18,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":19,\"price\":80.00},{\"gymId\":35,\"status\":1,\"time\":20,\"price\":80.00}]},{\"gymId\":34,\"gymName\":\"五人制\",\"price\":90.00,\"timeList\":[{\"gymId\":34,\"status\":1,\"time\":9,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":10,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":11,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":12,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":13,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":14,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":15,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":16,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":17,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":18,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":19,\"price\":90.00},{\"gymId\":34,\"status\":1,\"time\":20,\"price\":90.00}]}]');

-- ----------------------------
-- Table structure for g_gym_pic
-- ----------------------------
DROP TABLE IF EXISTS `g_gym_pic`;
CREATE TABLE `g_gym_pic`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gym_id` int(11) NULL DEFAULT NULL,
  `pic_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '场地图片' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of g_gym_pic
-- ----------------------------

-- ----------------------------
-- Table structure for g_member_order
-- ----------------------------
DROP TABLE IF EXISTS `g_member_order`;
CREATE TABLE `g_member_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NULL DEFAULT NULL,
  `order_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of g_member_order
-- ----------------------------

-- ----------------------------
-- Table structure for g_order
-- ----------------------------
DROP TABLE IF EXISTS `g_order`;
CREATE TABLE `g_order`  (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `order_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单编号',
  `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '金额',
  `order_status` tinyint(2) NULL DEFAULT NULL COMMENT '状态',
  `order_type` tinyint(2) NULL DEFAULT NULL,
  `appoint_date` date NULL DEFAULT NULL COMMENT '预约日期',
  `qr_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pay_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付类型',
  `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
  `form_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `store_id` bigint(32) NULL DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1433 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of g_order
-- ----------------------------
INSERT INTO `g_order` VALUES (1425, 72, '20210814619867', 60.00, 2, 1, '2024-01-13', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-01-14 07:23:59');
INSERT INTO `g_order` VALUES (1426, 72, '20210814483941', 60.00, 2, 1, '2024-01-13', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-01-14 07:24:27');
INSERT INTO `g_order` VALUES (1427, 72, '20211128174258', 160.00, 2, 1, '2024-01-28', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-01-28 15:52:01');
INSERT INTO `g_order` VALUES (1428, 76, '20221214729815', 60.00, 3, 1, '2024-01-14', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-01-14 15:55:12');
INSERT INTO `g_order` VALUES (1429, 76, '20221220101441', 90.00, 2, 1, '2024-01-21', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-01-20 22:36:44');
INSERT INTO `g_order` VALUES (1430, 76, '20230324835162', 80.00, 2, 1, '2024-03-24', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-03-24 16:28:34');
INSERT INTO `g_order` VALUES (1431, 76, '20240302087014', 80.00, 2, 1, '2024-03-02', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-03-02 14:02:23');
INSERT INTO `g_order` VALUES (1432, 76, '20240319081917', 90.00, 2, 1, '2024-03-19', NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-03-19 11:41:03');

-- ----------------------------
-- Table structure for g_order_category
-- ----------------------------
DROP TABLE IF EXISTS `g_order_category`;
CREATE TABLE `g_order_category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NULL DEFAULT NULL COMMENT '订单id',
  `category_id` int(11) NULL DEFAULT NULL COMMENT '项目id',
  `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '项目名称',
  `pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '图片',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 133 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单项目' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of g_order_category
-- ----------------------------
INSERT INTO `g_order_category` VALUES (125, 1425, 1, '羽毛球A', 'http://localhost:10001/img/icon-1.png', NULL);
INSERT INTO `g_order_category` VALUES (126, 1426, 1, '羽毛球A', 'http://localhost:10001/img/icon-1.png', NULL);
INSERT INTO `g_order_category` VALUES (127, 1427, 3, '足球', 'http://localhost:10001/img/icon-3.png', NULL);
INSERT INTO `g_order_category` VALUES (128, 1428, 1, '羽毛球A', 'http://localhost:10001/img/icon-1.png', NULL);
INSERT INTO `g_order_category` VALUES (129, 1429, 3, '足球', 'http://localhost:10001/img/icon-3.png', NULL);
INSERT INTO `g_order_category` VALUES (130, 1430, 4, '篮球(内)', 'http://localhost:10001/img/icon-3.png', NULL);
INSERT INTO `g_order_category` VALUES (131, 1431, 4, '篮球(内)', 'http://localhost:10001/img/icon-3.png', NULL);
INSERT INTO `g_order_category` VALUES (132, 1432, 3, '足球', 'http://localhost:10001/fileupload/20240319/bd66b0e4-39a9-4017-abaf-3fbead3f79e0.jpg', NULL);

-- ----------------------------
-- Table structure for g_order_evaluation
-- ----------------------------
DROP TABLE IF EXISTS `g_order_evaluation`;
CREATE TABLE `g_order_evaluation`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '订单id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `category_id` int(11) NULL DEFAULT NULL COMMENT '项目id',
  `star` int(11) NULL DEFAULT NULL COMMENT '评分',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评价内容',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单评价' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of g_order_evaluation
-- ----------------------------
INSERT INTO `g_order_evaluation` VALUES (1, 1431, 76, 4, 4, '444', '2024-03-02 15:04:08');
INSERT INTO `g_order_evaluation` VALUES (2, 1431, 76, 4, 3, '5555', '2024-03-02 15:05:11');
INSERT INTO `g_order_evaluation` VALUES (3, 1431, 76, 4, 5, '555', '2024-03-02 15:06:47');
INSERT INTO `g_order_evaluation` VALUES (4, 1431, 76, 4, 5, '444', '2024-03-02 15:10:50');
INSERT INTO `g_order_evaluation` VALUES (5, 1431, 76, 4, 4, '666', '2024-03-02 15:11:16');

-- ----------------------------
-- Table structure for g_order_gym
-- ----------------------------
DROP TABLE IF EXISTS `g_order_gym`;
CREATE TABLE `g_order_gym`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NULL DEFAULT NULL COMMENT '订单id',
  `gym_id` int(11) NULL DEFAULT NULL COMMENT '场地id',
  `gym_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场地名称',
  `buy_num` int(11) NULL DEFAULT NULL,
  `pic_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',
  `appoint_hour` int(11) NULL DEFAULT NULL COMMENT '预约时间',
  `appoint_date` date NULL DEFAULT NULL COMMENT '预约日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 218 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单场地' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of g_order_gym
-- ----------------------------
INSERT INTO `g_order_gym` VALUES (206, 1425, 23, '内场A1', NULL, NULL, 30.00, 15, '2024-01-13');
INSERT INTO `g_order_gym` VALUES (207, 1425, 23, '内场A1', NULL, NULL, 30.00, 16, '2024-01-13');
INSERT INTO `g_order_gym` VALUES (208, 1426, 23, '内场A1', NULL, NULL, 30.00, 15, '2024-01-13');
INSERT INTO `g_order_gym` VALUES (209, 1426, 23, '内场A1', NULL, NULL, 30.00, 16, '2024-01-13');
INSERT INTO `g_order_gym` VALUES (210, 1427, 35, '三人制', NULL, NULL, 80.00, 9, '2024-01-28');
INSERT INTO `g_order_gym` VALUES (211, 1427, 35, '三人制', NULL, NULL, 80.00, 10, '2024-01-28');
INSERT INTO `g_order_gym` VALUES (212, 1428, 21, '内场A3', NULL, NULL, 30.00, 18, '2024-01-14');
INSERT INTO `g_order_gym` VALUES (213, 1428, 21, '内场A3', NULL, NULL, 30.00, 17, '2024-01-14');
INSERT INTO `g_order_gym` VALUES (214, 1429, 34, '五人制', NULL, NULL, 90.00, 13, '2024-01-21');
INSERT INTO `g_order_gym` VALUES (215, 1430, 37, '内场1-2', NULL, NULL, 80.00, 17, '2024-03-24');
INSERT INTO `g_order_gym` VALUES (216, 1431, 37, '内场1-2', NULL, NULL, 80.00, 17, '2024-03-02');
INSERT INTO `g_order_gym` VALUES (217, 1432, 34, '五人制', NULL, NULL, 90.00, 16, '2024-03-19');

-- ----------------------------
-- Table structure for sys_store
-- ----------------------------
DROP TABLE IF EXISTS `sys_store`;
CREATE TABLE `sys_store`  (
  `id` bigint(32) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
  `user_id` bigint(20) NOT NULL,
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'logo',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `profile` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `business_hours` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `latitude` double NULL DEFAULT NULL,
  `longitude` double NULL DEFAULT NULL,
  `notice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `sys_store_id_uindex`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '场馆' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_store
-- ----------------------------
INSERT INTO `sys_store` VALUES (1, '足球场', 1, '18112907714', 'http://localhost:10001/img/store.jpg', '济南', '', '9:00-21:00', 31.977554, 118.804093, NULL, 'WIFI;停车;热水沐浴;器材租赁;休息区;简餐;体育用品', '2018-03-24 22:28:21');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态  0:禁用   1:正常',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '2803180149@qq.com', '18021418906', 1, '2024-01-14 11:11:11');
INSERT INTO `sys_user` VALUES (3, 'test', 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 1, '2024-01-04 16:33:07');

SET FOREIGN_KEY_CHECKS = 1;

文章下方名片联系我即可~
大家点赞、收藏、关注、评论啦 、查看????????获取联系方式????????

上一篇:【JavaEE初阶】网络原理(1)