本系统实现了完整的用户车辆绑定与解绑功能，支持用户绑定车辆、强制重新绑定、查看当前绑定车辆以及解绑车辆。
CREATE TABLE IF NOT EXISTS sys_user_vehicle (
id BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
user_id BIGINT(20) NOT NULL COMMENT '用户ID',
vehicle_id BIGINT(20) NOT NULL COMMENT '车辆ID',
bind_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '绑定时间',
bind_by VARCHAR(64) DEFAULT '' COMMENT '绑定操作人',
status CHAR(1) DEFAULT '0' COMMENT '绑定状态（0正常 1解绑）',
remark VARCHAR(500) DEFAULT NULL COMMENT '备注',
create_by VARCHAR(64) DEFAULT '' COMMENT '创建者',
create_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_by VARCHAR(64) DEFAULT '' COMMENT '更新者',
update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (id),
UNIQUE KEY idx_user_vehicle (user_id, vehicle_id) COMMENT '用户车辆唯一索引',
KEY idx_user_id (user_id) COMMENT '用户ID索引',
KEY idx_vehicle_id (vehicle_id) COMMENT '车辆ID索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户车辆绑定表';
字段说明：
- status: 0=正常绑定，1=已解绑
- bind_time: 绑定操作时间
- update_time: 解绑操作时间
基础路径： /system/vehicle
@PostMapping("/bind")
public AjaxResult bindVehicle(@RequestBody Map<String, Object> params)
请求参数：json { "userId": 1, "vehicleId": 100 }
响应示例：json { "code": 200, "msg": "车辆绑定成功" }
@PostMapping("/unbind")
public AjaxResult unbindVehicle(@RequestBody Map<String, Object> params)
请求参数：json { "userId": 1, "vehicleId": 100 }
响应示例：json { "code": 200, "msg": "车辆解绑成功" }
@GetMapping("/user/bound/{userId}")
public AjaxResult getUserBoundVehicle(@PathVariable("userId") Long userId)
响应示例：json { "code": 200, "data": { "vehicleId": 100, "vehicleNumber": "粤A12345", "vehicleType": "救护车", "vehicleBrand": "福特", "vehicleModel": "全顺" } }
@Transactional
public int bindVehicleToUser(Long userId, Long vehicleId) {
// 先解绑用户的所有车辆（确保一个用户只能绑定一辆车）
vehicleInfoMapper.unbindAllVehiclesFromUser(userId);
// 绑定新车辆
return vehicleInfoMapper.bindVehicleToUser(userId, vehicleId, bindBy);
}
事务特性：
- 使用 @Transactional 保证原子性
- 先解绑再绑定，失败自动回滚
public int unbindVehicleFromUser(Long userId, Long vehicleId) {
return vehicleInfoMapper.unbindVehicleFromUser(userId, vehicleId);
}
绑定车辆：xml <insert id="bindVehicleToUser"> INSERT INTO sys_user_vehicle (user_id, vehicle_id, bind_time, bind_by, status, create_by, create_time) VALUES (#{userId}, #{vehicleId}, NOW(), #{bindBy}, '0', #{bindBy}, NOW()) </insert>
解绑车辆：xml <update id="unbindVehicleFromUser"> UPDATE sys_user_vehicle SET status = '1', update_time = NOW() WHERE user_id = #{userId} AND vehicle_id = #{vehicleId} AND status = '0' </update>
解绑所有车辆：xml <update id="unbindAllVehiclesFromUser"> UPDATE sys_user_vehicle SET status = '1', update_time = NOW() WHERE user_id = #{userId} AND status = '0' </update>
获取绑定车辆：xml <select id="getUserBoundVehicle" resultMap="VehicleInfoResult"> SELECT v.* FROM tb_vehicle_info v INNER JOIN sys_user_vehicle uv ON v.vehicle_id = uv.vehicle_id WHERE uv.user_id = #{userId} AND uv.status = '0' ORDER BY uv.bind_time DESC LIMIT 1 </select>
// 绑定车辆
export function bindVehicleToUser(userId, vehicleId) {
return request({
url: '/system/vehicle/bind',
method: 'post',
data: { userId, vehicleId }
})
}
// 解绑车辆
export function unbindVehicleFromUser(userId, vehicleId) {
return request({
url: '/system/vehicle/unbind',
method: 'post',
data: { userId, vehicleId }
})
}
// 获取用户绑定的车辆
export function getUserBoundVehicle(userId) {
return request({
url: '/system/vehicle/user/bound/' + userId,
method: 'get'
})
}
页面路径： /pages/bind-vehicle
主要功能：
加载当前绑定车辆javascript loadCurrentBoundVehicle() { const userId = this.currentUser.userId getUserBoundVehicle(userId).then(response => { if (response.code === 200 && response.data) { this.currentBoundVehicle = response.data } }) }
绑定车辆逻辑
```javascript
bindVehicle() {
// 检查是否选择的是当前已绑定的车辆
if (this.currentBoundVehicle &&
this.currentBoundVehicle.vehicleId === this.selectedVehicleId) {
this.$modal.showToast('当前已绑定此车辆，无需重复绑定')
return
}
// 如果已经绑定了其他车辆，提示是否强制绑定
if (this.currentBoundVehicle) {
const confirmMsg = 您当前已绑定车辆：${currentVehicleNo}\n\n确认要解绑旧车辆并绑定新车辆：${this.selectedVehiclePlate} 吗？
this.$modal.confirm(confirmMsg).then(() => {
this.performBind()
})
} else {
// 没有绑定车辆，直接绑定
this.$modal.confirm('确认绑定车辆 ' + this.selectedVehiclePlate + ' 吗？')
.then(() => {
this.performBind()
})
}
}
```
javascript performBind() { const userId = this.currentUser.userId bindVehicleToUser(userId, this.selectedVehicleId).then(response => { if (response.code === 200) { this.$modal.showToast('车辆绑定成功') this.$store.dispatch('GetInfo') // 刷新用户信息 setTimeout(() => { this.$tab.navigateBack() }, 1500) } }) } 页面路径： /pages/mine/index
主要功能：
显示绑定车辆信息vue <view class="info-item"> <view class="info-label">绑定车辆：</view> <view class="info-value">{{ boundVehicle || '未绑定' }}</view> </view>
解绑/绑定按钮
```vue
<button class="unbind-btn" @click="unbindVehicle">取消绑定车辆
<button class="bind-btn" @click="goToBindVehicle">绑定车辆
```
// 获取用户绑定的车辆信息
if (userId) {
getUserBoundVehicle(userId).then(response => {
if (response.code === 200 && response.data) {
const vehicle = response.data
this.boundVehicle = vehicle.vehicleNumber || '未知车牌'
this.boundVehicleId = vehicle.vehicleId
} else {
this.boundVehicle = '未绑定'
this.boundVehicleId = null
}
})
}
}
```
this.$modal.confirm(确认取消绑定车辆 ${this.boundVehicle} 吗？).then(() => {
unbindVehicleFromUser(userId, vehicleId).then(response => {
if (response.code === 200) {
this.boundVehicle = '未绑定'
this.boundVehicleId = null
this.$modal.showToast('取消绑定成功')
this.$store.dispatch('GetInfo') // 刷新用户信息
}
})
})
}
```
graph TD
A[用户选择车辆] --> B{已绑定车辆?}
B -->|否| C[直接绑定]
B -->|是| D{选择相同车辆?}
D -->|是| E[提示无需重复绑定]
D -->|否| F[提示强制绑定确认]
F --> G{用户确认?}
G -->|是| H[解绑旧车辆]
G -->|否| I[取消操作]
H --> J[绑定新车辆]
C --> J
J --> K[刷新用户信息]
K --> L[返回上一页]
graph TD
A[用户点击解绑] --> B{已绑定车辆?}
B -->|否| C[提示未绑定]
B -->|是| D[显示确认对话框]
D --> E{用户确认?}
E -->|是| F[调用解绑API]
E -->|否| G[取消操作]
F --> H{解绑成功?}
H -->|是| I[更新绑定状态]
H -->|否| J[显示错误信息]
I --> K[刷新用户信息]
K --> L[显示成功提示]
您当前已绑定车辆：粤A12345，确认要解绑旧车辆并绑定新车辆：粤B67890 吗？确认取消绑定车辆 粤A12345 吗？@Transactional 注解确保绑定/解绑操作的原子性@Anonymous 注解，允许匿名访问sql/user_vehicle_bind.sql - 数据库表结构ruoyi-system/mapper/VehicleInfoMapper.java - Mapper接口ruoyi-system/mapper/VehicleInfoMapper.xml - SQL映射ruoyi-system/service/IVehicleInfoService.java - Service接口ruoyi-system/service/impl/VehicleInfoServiceImpl.java - Service实现ruoyi-admin/controller/VehicleInfoController.java - Controllerapp/api/vehicle.js - 车辆API封装app/pages/bind-vehicle.vue - 绑定车辆页面app/pages/mine/index.vue - 个人中心页面| 版本 | 日期 | 修改内容 | 修改人 |
|---|
| 1.0 | 2025-10-15 | 初始版本，实现基础绑定解绑功能 | - |
| 1.1 | 2025-10-15 | 修复API路径错误，完善解绑功能 | - |
| 1.2 | 2025-10-15 | 完善个人中心解绑功能实现 | - |