From 2418543dfc6c61fa5091e242042a7d7635f6c7c5 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Thu, 02 Apr 2026 14:27:16 +0800
Subject: [PATCH] opt: sql改造其他模块改造9
---
drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/RegionServiceImpl.java | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/RegionServiceImpl.java b/drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/RegionServiceImpl.java
index 80a9189..812467b 100644
--- a/drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/RegionServiceImpl.java
+++ b/drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/RegionServiceImpl.java
@@ -54,9 +54,11 @@
public Region getById(Serializable id) {
return Optional.ofNullable(id)
.map(val -> baseMapper.selectOne(new LambdaQueryWrapper<Region>()
- .eq(Region::getId, val)
+ // 1. 处理 id = ? 部分，强制转为 bigint
+ .apply("id = {0}::bigint", val)
.or()
- .eq(Region::getCode, val)))
+ // 2. 处理 code = ? 部分，强制转为 varchar
+ .apply("code = {0}::varchar", val)))
.orElse(null);
}
--
Gitblit v1.9.3