key<>改用JSON_CONTAINS实现

TommyLemon · TommyLemon · commit 9ad7cf7d5eba · 2018-05-05T12:59:28.000+08:00
diff --git a/APIJSON-Java-Server/APIJSONLibrary/src/main/java/zuo/biao/apijson/server/AbstractSQLConfig.java b/APIJSON-Java-Server/APIJSONLibrary/src/main/java/zuo/biao/apijson/server/AbstractSQLConfig.java
@@ -836,20 +836,11 @@ public static String getContainString(String key, Object[] childs, int type) thr
 						childs[i] = "\"" + childs[i] + "\"";
 					}
 					condition += (i <= 0 ? "" : (Logic.isAnd(type) ? AND : OR))
-							+ "(" + getSearchString(
-									key
-									, new String[]{
-											"[" + childs[i] + "]", //全等
-											"[" + childs[i] + ", %", //开始
-											"%, " + childs[i] + ", %", //中间
-											"%, " + childs[i] + "]" //末尾
-									}
-									, Logic.TYPE_OR
-									) + ")";
+							+ "JSON_CONTAINS(" + key + ", '" + childs[i] + "')";
 				}
 			}
 			if (condition.isEmpty()) {
-				condition = (SQL.isEmpty(key, true) + OR + getLikeString(key, "[]"));
+				condition = (SQL.isEmpty(key, true) + OR + (key + "='[]'"));
 			}
 		}
 		if (condition.isEmpty()) {

Original file line number	Diff line number	Diff line change
`@@ -836,20 +836,11 @@ public static String getContainString(String key, Object[] childs, int type) thr`
`836`	`836`	`childs[i] = "\"" + childs[i] + "\"";`
`837`	`837`	`}`
`838`	`838`	`condition += (i <= 0 ? "" : (Logic.isAnd(type) ? AND : OR))`
`839`		`- + "(" + getSearchString(`
`840`		`- key`
`841`		`- , new String[]{`
`842`		`- "[" + childs[i] + "]", //全等`
`843`		`- "[" + childs[i] + ", %", //开始`
`844`		`- "%, " + childs[i] + ", %", //中间`
`845`		`- "%, " + childs[i] + "]" //末尾`
`846`		`- }`
`847`		`- , Logic.TYPE_OR`
`848`		`- ) + ")";`
	`839`	`+ + "JSON_CONTAINS(" + key + ", '" + childs[i] + "')";`
`849`	`840`	`}`
`850`	`841`	`}`
`851`	`842`	`if (condition.isEmpty()) {`
`852`		`- condition = (SQL.isEmpty(key, true) + OR + getLikeString(key, "[]"));`
	`843`	`+ condition = (SQL.isEmpty(key, true) + OR + (key + "='[]'"));`
`853`	`844`	`}`
`854`	`845`	`}`
`855`	`846`	`if (condition.isEmpty()) {`