From 5126f7598544ee5aa94bbecb4d04ebd1b2445c54 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Tue, 07 Apr 2026 19:22:02 +0800
Subject: [PATCH] opt: 人大金仓数据库改造
---
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