From 3210fce113223dbcbc397dd0d892540fd591a222 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期五, 11 三月 2022 18:55:04 +0800
Subject: [PATCH] update 删除 自定义 find_in_set 函数 在代码层面适配
---
ruoyi-common/src/main/java/com/ruoyi/common/helper/DataBaseHelper.java | 13 +++++++++++--
1 files changed, 11 insertions(+), 2 deletions(-)
diff --git a/ruoyi-common/src/main/java/com/ruoyi/common/helper/DataBaseHelper.java b/ruoyi-common/src/main/java/com/ruoyi/common/helper/DataBaseHelper.java
index 3d98def..55a3a41 100644
--- a/ruoyi-common/src/main/java/com/ruoyi/common/helper/DataBaseHelper.java
+++ b/ruoyi-common/src/main/java/com/ruoyi/common/helper/DataBaseHelper.java
@@ -53,9 +53,18 @@
public static String findInSet(Object var1, String var2) {
DataBaseType dataBasyType = getDataBasyType();
+ String var = Convert.toStr(var1);
if (dataBasyType == DataBaseType.SQL_SERVER) {
- return "charindex(" + Convert.toStr(var1) + ", " + var2 + ") <> 0";
+ // charindex(',100,' , ',0,100,101,') <> 0
+ return "charindex('," + var + ",' , ','+" + var2 + "+',') <> 0";
+ } else if (dataBasyType == DataBaseType.POSTGRE_SQL) {
+ // (select position(',100,' in ',0,100,101,')) <> 0
+ return "(select position('," + var + ",' in ','||" + var2 + "||',')) <> 0";
+ } else if (dataBasyType == DataBaseType.ORACLE) {
+ // instr(',0,100,101,' , ',100,') <> 0
+ return "instr(','||" + var2 + "||',' , '," + var + ",') <> 0";
}
- return "find_in_set(" + Convert.toStr(var1) + ", " + var2 + ") <> 0";
+ // find_in_set(100 , '0,100,101')
+ return "find_in_set(" + var + " , " + var2 + ") <> 0";
}
}
--
Gitblit v1.9.3