Server: @Explain 返回的 sql 去掉多余的 EXPLAIN 关键词

TommyLemon · TommyLemon · commit 595c38d870a3 · 2019-05-03T19:31:59.000+08:00
diff --git a/APIJSON-Java-Server/APIJSONORM/src/main/java/zuo/biao/apijson/server/AbstractSQLExecutor.java b/APIJSON-Java-Server/APIJSONORM/src/main/java/zuo/biao/apijson/server/AbstractSQLExecutor.java
@@ -305,7 +305,11 @@ else if (config.getSQLTable().equalsIgnoreCase(rsmd.getTableName(i)) == false) {
 				if (result == null) {
 					result = new JSONObject(true);
 				}
-				result.put("sql", sql);
+				boolean explain = config.isExplain();
+				config.setExplain(false);
+				result.put("sql", config.getSQL(false));
+				config.setExplain(explain);
+				config.setPrepared(prepared);
 			}
 			result.put("list", resultList);
 			return result;

Original file line number	Diff line number	Diff line change
`@@ -305,7 +305,11 @@ else if (config.getSQLTable().equalsIgnoreCase(rsmd.getTableName(i)) == false) {`
`305`	`305`	`if (result == null) {`
`306`	`306`	`result = new JSONObject(true);`
`307`	`307`	`}`
`308`		`- result.put("sql", sql);`
	`308`	`+ boolean explain = config.isExplain();`
	`309`	`+ config.setExplain(false);`
	`310`	`+ result.put("sql", config.getSQL(false));`
	`311`	`+ config.setExplain(explain);`
	`312`	`+ config.setPrepared(prepared);`
`309`	`313`	`}`
`310`	`314`	`result.put("list", resultList);`
`311`	`315`	`return result;`