ParkingManagementSystem25-12

Commit Graph

Author	SHA1	Message	Date
daitianmu	d4fa58a9d9	修改	7 days ago
daitianmu	1ee41807b6	用户信息查询	2 weeks ago
Lenovo	4ce8706ed2	停车区域管理系统查询	2 weeks ago
daitianmu	34e15c5cab	用户信息查询	2 weeks ago
daitianmu	038f235c2c	Merge remote-tracking branch 'origin/main'	2 weeks ago
daitianmu	f4872e163d	整体修改	2 weeks ago
阿卜	1aa9212b7f	-- 车位信息管理系统数据库表 SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for parking_space -- ---------------------------- DROP TABLE IF EXISTS `parking_space`; CREATE TABLE `parking_space` ( `id` int(11) NOT NULL AUTO_INCREMENT, `area_id` int(11) NOT NULL COMMENT '所属区域ID', `area_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域编码', `space_number` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车位编号（如A-001）', `space_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '普通' COMMENT '车位类型：普通、充电、VIP、残疾人', `status` int(11) NULL DEFAULT 1 COMMENT '状态：0-占用，1-空闲，2-维修中，3-预留', `license_plate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前停放车辆车牌号（如果占用）', `hourly_rate` decimal(10, 2) NULL DEFAULT 5.00 COMMENT '每小时费率', `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车位描述', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_space_number`(`space_number`) USING BTREE, INDEX `idx_area_id`(`area_id`) USING BTREE, INDEX `idx_status`(`status`) USING BTREE, INDEX `idx_space_type`(`space_type`) USING BTREE, INDEX `idx_license_plate`(`license_plate`) USING BTREE, CONSTRAINT `fk_space_area` FOREIGN KEY (`area_id`) REFERENCES `parking_area` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '车位信息表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of parking_space -- ---------------------------- -- A区-地面停车场车位（10个示例） INSERT INTO `parking_space` VALUES (1, 1, 'A', 'A-001', '普通', 1, NULL, 5.00, '靠近入口的普通车位', '2025-05-21 10:00:00', '2025-05-21 10:00:00'); INSERT INTO `parking_space` VALUES (2, 1, 'A', 'A-002', '普通', 0, '京A12345', 5.00, '中间位置', '2025-05-21 10:00:00', '2025-05-21 14:00:00'); INSERT INTO `parking_space` VALUES (3, 1, 'A', 'A-003', '普通', 1, NULL, 5.00, '普通车位', '2025-05-21 10:00:00', '2025-05-21 10:00:00'); INSERT INTO `parking_space` VALUES (4, 1, 'A', 'A-004', '充电', 1, NULL, 8.00, '带充电桩车位', '2025-05-21 10:00:00', '2025-05-21 10:00:00'); INSERT INTO `parking_space` VALUES (5, 1, 'A', 'A-005', '普通', 2, NULL, 5.00, '维修中，暂不可用', '2025-05-21 10:00:00', '2025-05-21 12:00:00'); -- B区-地下停车场车位（10个示例） INSERT INTO `parking_space` VALUES (6, 2, 'B', 'B-001', '充电', 0, '京B67890', 10.00, '地下带充电桩车位', '2025-05-21 10:05:00', '2025-05-21 18:00:00'); INSERT INTO `parking_space` VALUES (7, 2, 'B', 'B-002', '充电', 1, NULL, 10.00, '地下带充电桩车位', '2025-05-21 10:05:00', '2025-05-21 10:05:00'); INSERT INTO `parking_space` VALUES (8, 2, 'B', 'B-003', '普通', 1, NULL, 8.00, '地下普通车位', '2025-05-21 10:05:00', '2025-05-21 10:05:00'); INSERT INTO `parking_space` VALUES (9, 2, 'B', 'B-004', '普通', 1, NULL, 8.00, '地下普通车位', '2025-05-21 10:05:00', '2025-05-21 10:05:00'); INSERT INTO `parking_space` VALUES (10, 2, 'B', 'B-005', '充电', 3, NULL, 10.00, '已预留的充电车位', '2025-05-21 10:05:00', '2025-05-21 15:00:00'); -- C区-VIP停车场车位（5个示例） INSERT INTO `parking_space` VALUES (11, 3, 'C', 'C-001', 'VIP', 0, '京C11111', 20.00, 'VIP专属车位，靠近电梯', '2025-05-21 10:10:00', '2025-05-21 09:30:00'); INSERT INTO `parking_space` VALUES (12, 3, 'C', 'C-002', 'VIP', 1, NULL, 20.00, 'VIP专属车位', '2025-05-21 10:10:00', '2025-05-21 10:10:00'); INSERT INTO `parking_space` VALUES (13, 3, 'C', 'C-003', 'VIP', 1, NULL, 20.00, 'VIP专属车位', '2025-05-21 10:10:00', '2025-05-21 10:10:00'); INSERT INTO `parking_space` VALUES (14, 3, 'C', 'C-004', 'VIP', 1, NULL, 20.00, 'VIP专属车位', '2025-05-21 10:10:00', '2025-05-21 10:10:00'); INSERT INTO `parking_space` VALUES (15, 3, 'C', 'C-005', 'VIP', 1, NULL, 20.00, 'VIP专属车位', '2025-05-21 10:10:00', '2025-05-21 10:10:00'); -- D区-临时停车场车位（5个示例） INSERT INTO `parking_space` VALUES (16, 4, 'D', 'D-001', '普通', 1, NULL, 6.00, '临时停车区域', '2025-05-21 10:15:00', '2025-05-21 10:15:00'); INSERT INTO `parking_space` VALUES (17, 4, 'D', 'D-002', '普通', 1, NULL, 6.00, '临时停车区域', '2025-05-21 10:15:00', '2025-05-21 10:15:00'); INSERT INTO `parking_space` VALUES (18, 4, 'D', 'D-003', '普通', 1, NULL, 6.00, '临时停车区域', '2025-05-21 10:15:00', '2025-05-21 10:15:00'); INSERT INTO `parking_space` VALUES (19, 4, 'D', 'D-004', '普通', 1, NULL, 6.00, '临时停车区域', '2025-05-21 10:15:00', '2025-05-21 10:15:00'); INSERT INTO `parking_space` VALUES (20, 4, 'D', 'D-005', '普通', 1, NULL, 6.00, '临时停车区域', '2025-05-21 10:15:00', '2025-05-21 10:15:00'); -- E区-残疾人专用车位（3个示例） INSERT INTO `parking_space` VALUES (21, 5, 'E', 'E-001', '残疾人', 1, NULL, 3.00, '残疾人专用车位，靠近电梯口', '2025-05-21 10:20:00', '2025-05-21 10:20:00'); INSERT INTO `parking_space` VALUES (22, 5, 'E', 'E-002', '残疾人', 1, NULL, 3.00, '残疾人专用车位，靠近电梯口', '2025-05-21 10:20:00', '2025-05-21 10:20:00'); INSERT INTO `parking_space` VALUES (23, 5, 'E', 'E-003', '残疾人', 1, NULL, 3.00, '残疾人专用车位，靠近电梯口', '2025-05-21 10:20:00', '2025-05-21 10:20:00'); SET FOREIGN_KEY_CHECKS = 1;	2 weeks ago
Lenovo	b4ebff8d2a	-- 停车区域管理系统数据库表 SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for parking_area -- ---------------------------- DROP TABLE IF EXISTS `parking_area`; CREATE TABLE `parking_area` ( `id` int(11) NOT NULL AUTO_INCREMENT, `area_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域编码（如A区、B区）', `area_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域名称', `total_spaces` int(11) NOT NULL DEFAULT 0 COMMENT '总车位数', `used_spaces` int(11) NULL DEFAULT 0 COMMENT '已用车位数', `available_spaces` int(11) NULL DEFAULT 0 COMMENT '可用车位数', `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域描述', `status` int(11) NULL DEFAULT 1 COMMENT '状态：0-停用，1-启用', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_area_code`(`area_code`) USING BTREE, INDEX `idx_area_name`(`area_name`) USING BTREE, INDEX `idx_status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '停车区域信息表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of parking_area -- ---------------------------- INSERT INTO `parking_area` VALUES (1, 'A', 'A区-地面停车场', 100, 30, 70, '地面普通停车位，靠近商场入口', 1, '2025-05-21 10:00:00', '2025-05-21 10:00:00'); INSERT INTO `parking_area` VALUES (2, 'B', 'B区-地下停车场', 150, 80, 70, '地下带充电桩车位，配备监控系统', 1, '2025-05-21 10:05:00', '2025-05-21 10:05:00'); INSERT INTO `parking_area` VALUES (3, 'C', 'C区-VIP停车场', 50, 10, 40, 'VIP专属停车位，提供代客泊车服务', 1, '2025-05-21 10:10:00', '2025-05-21 10:10:00'); INSERT INTO `parking_area` VALUES (4, 'D', 'D区-临时停车场', 80, 60, 20, '临时停车区域，按小时计费', 1, '2025-05-21 10:15:00', '2025-05-21 10:15:00'); INSERT INTO `parking_area` VALUES (5, 'E', 'E区-残疾人专用', 20, 5, 15, '残疾人专用停车位，靠近电梯口', 1, '2025-05-21 10:20:00', '2025-05-21 10:20:00'); SET FOREIGN_KEY_CHECKS = 1;	2 weeks ago
lyslyslys666	0fcd5855a3	-- 车位预约管理系统数据库表 SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for parking_reservation -- ---------------------------- DROP TABLE IF EXISTS `parking_reservation`; CREATE TABLE `parking_reservation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名', `area_id` int(11) NOT NULL COMMENT '区域ID', `area_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域编码', `area_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域名称', `reservation_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '预约时间', `expected_arrival` datetime(0) NOT NULL COMMENT '预计到达时间', `expected_departure` datetime(0) NOT NULL COMMENT '预计离开时间', `license_plate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车牌号', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话', `status` int(11) NULL DEFAULT 1 COMMENT '状态：0-已取消，1-待使用，2-使用中，3-已完成，4-已过期', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_user_id`(`user_id`) USING BTREE, INDEX `idx_area_id`(`area_id`) USING BTREE, INDEX `idx_license_plate`(`license_plate`) USING BTREE, INDEX `idx_status`(`status`) USING BTREE, INDEX `idx_expected_arrival`(`expected_arrival`) USING BTREE, CONSTRAINT `fk_reservation_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_reservation_area` FOREIGN KEY (`area_id`) REFERENCES `parking_area` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '车位预约信息表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of parking_reservation -- ---------------------------- INSERT INTO `parking_reservation` VALUES (1, 2, 'zhangsan', 1, 'A', 'A区-地面停车场', '2025-05-21 10:30:00', '2025-05-21 14:00:00', '2025-05-21 16:00:00', '京A12345', '13800138001', 1, '下午购物停车', '2025-05-21 10:30:00', '2025-05-21 10:30:00'); INSERT INTO `parking_reservation` VALUES (2, 3, 'lisi', 2, 'B', 'B区-地下停车场', '2025-05-21 11:00:00', '2025-05-21 18:00:00', '2025-05-21 20:00:00', '京B67890', '13800138002', 1, '晚上看电影', '2025-05-21 11:00:00', '2025-05-21 11:00:00'); INSERT INTO `parking_reservation` VALUES (3, 4, 'wangwu', 3, 'C', 'C区-VIP停车场', '2025-05-21 09:00:00', '2025-05-21 09:30:00', '2025-05-21 11:30:00', '京C11111', '13800138003', 2, '商务会议', '2025-05-21 09:00:00', '2025-05-21 09:30:00'); INSERT INTO `parking_reservation` VALUES (4, 2, 'zhangsan', 1, 'A', 'A区-地面停车场', '2025-05-20 15:00:00', '2025-05-20 16:00:00', '2025-05-20 18:00:00', '京A12345', '13800138001', 3, '昨天已完成', '2025-05-20 15:00:00', '2025-05-20 18:05:00'); INSERT INTO `parking_reservation` VALUES (5, 5, 'zhaoliu', 4, 'D', 'D区-临时停车场', '2025-05-21 12:00:00', '2025-05-21 13:00:00', '2025-05-21 14:00:00', '京D22222', '13800138004', 0, '临时有事取消', '2025-05-21 12:00:00', '2025-05-21 12:30:00'); SET FOREIGN_KEY_CHECKS = 1;	2 weeks ago
daitianmu	06ada0d671	-- 用户信息管理系统数据库表 SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) 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 NOT NULL COMMENT '密码', `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号', `real_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '真实姓名', `status` int(11) NULL DEFAULT 1 COMMENT '状态：0-禁用，1-启用', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_username`(`username`) USING BTREE, INDEX `idx_email`(`email`) USING BTREE, INDEX `idx_phone`(`phone`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin@parking.com', '13800138000', '系统管理员', 1, '2025-05-21 10:00:00', '2025-05-21 10:00:00'); INSERT INTO `user` VALUES (2, 'zhangsan', 'e10adc3949ba59abbe56e057f20f883e', 'zhangsan@example.com', '13800138001', '张三', 1, '2025-05-21 10:05:00', '2025-05-21 10:05:00'); INSERT INTO `user` VALUES (3, 'lisi', 'e10adc3949ba59abbe56e057f20f883e', 'lisi@example.com', '13800138002', '李四', 1, '2025-05-21 10:10:00', '2025-05-21 10:10:00'); INSERT INTO `user` VALUES (4, 'wangwu', 'e10adc3949ba59abbe56e057f20f883e', 'wangwu@example.com', '13800138003', '王五', 1, '2025-05-21 10:15:00', '2025-05-21 10:15:00'); INSERT INTO `user` VALUES (5, 'zhaoliu', 'e10adc3949ba59abbe56e057f20f883e', 'zhaoliu@example.com', '13800138004', '赵六', 0, '2025-05-21 10:20:00', '2025-05-21 10:20:00'); SET FOREIGN_KEY_CHECKS = 1;	2 weeks ago
daitianmu	6e124e809c	整体修改	2 weeks ago
阿卜	e6ef6f7e07	修改	1 month ago
阿卜	4c9e9291e1	showFirst	1 month ago
Lenovo	99cafd9c57	xml	1 month ago
lyslyslys666	eb82bdfe50	FirstController	1 month ago
daitianmu	b5f42ae871	web	1 month ago
Lenovo	bd6c442cbb	TestXML和bean文件	1 month ago
lyslyslys666	167085c8e8	Log	1 month ago
daitianmu	f29d19ccdc	检查	1 month ago
daitianmu	5a51bca624	bean	1 month ago
阿卜	23d4eb0193	gds	1 month ago
daitianmu	f90fdea64f	Category	1 month ago
阿卜	01f6e5b6c3	bean	1 month ago
Lenovo	31bee4559a	TestAnnotation	1 month ago
lyslyslys666	193df3b911	Product	1 month ago
daitianmu	7761dfa1e3	Category	1 month ago
lyslyslys666	c28ab3f240	course类	2 months ago
daitianmu	657cfb4881	teacher类	2 months ago
Lenovo	08f8691369	收费管理	2 months ago
daitianmu	c899bc8ee1	车位预约管理	2 months ago
daitianmu	0334355b11	车位预约管理	2 months ago
lyslyslys666	e143b94a38	修正内容	2 months ago
Lenovo	aa38256ade	bean包完事	2 months ago
阿卜	e4c260828e	停车场用户建立	2 months ago
lyslyslys666	78b766c087	创建用户类	2 months ago
daitianmu	2bd0f1005c	loc的包建立	2 months ago
阿卜	b1abd4ad43	提交Hello Spring语句	2 months ago
Lenovo	83a4e01109	Hello Spring!	2 months ago
daitianmu	a0988531df	导入包	2 months ago
lyslyslys666	d9100628bf	初始化Spring容器	2 months ago
weiruyu	f0ee553d69	initial project	2 months ago
ph3fvx2sj	77dd74983e	Initial commit	2 months ago

42 Commits (main) All Branches Search

42 Commits (main)

All Branches