Server: 完成 @Explain 查执行计划

TommyLemon · TommyLemon · commit 96526c8eaf57 · 2019-10-07T20:13:21.000+08:00
diff --git a/APIJSON-Java-Server/APIJSONBoot/src/main/java/apijson/demo/server/DemoSQLConfig.java b/APIJSON-Java-Server/APIJSONBoot/src/main/java/apijson/demo/server/DemoSQLConfig.java
@@ -39,7 +39,7 @@ public class DemoSQLConfig extends AbstractSQLConfig {
 
 	static {
 		DEFAULT_DATABASE = DATABASE_MYSQL;  //TODO 默认数据库类型，改成你自己的
-		DEFAULT_SCHEMA = "sys";  //TODO 默认模式名，改成你自己的
+		DEFAULT_SCHEMA = "sys";  //TODO 默认模式名，改成你自己的，默认情况是 MySQL: sys, PostgreSQL: public, SQL Server: dbo, Oracle: 
 
 		//  由 DemoVerifier.init 方法读取数据库 Access 表来替代手动输入配置
 		//		//表名映射，隐藏真实表名，对安全要求很高的表可以这么做
diff --git a/APIJSON-Java-Server/APIJSONORM/src/main/java/zuo/biao/apijson/server/AbstractSQLConfig.java b/APIJSON-Java-Server/APIJSONORM/src/main/java/zuo/biao/apijson/server/AbstractSQLConfig.java
@@ -2104,7 +2104,7 @@ public static String getSQL(AbstractSQLConfig config) throws Exception {
 		default:
 			config.setPreparedValueList(new ArrayList<Object>());
 			String column = config.getColumnString();
-			return (config.isExplain() ? "EXPLAIN " : "") + "SELECT " + (config.getCache() == JSONRequest.CACHE_RAM ? "SQL_NO_CACHE " : "") + column + " FROM " + getConditionString(column, tablePath, config);
+			return (config.isExplain() ? (config.isSQLServer() || config.isOracle() ? "SET STATISTICS PROFILE ON;\n" : "EXPLAIN ") : "") + "SELECT " + (config.getCache() == JSONRequest.CACHE_RAM ? "SQL_NO_CACHE " : "") + column + " FROM " + getConditionString(column, tablePath, config);
 		}
 	}
 

Original file line number	Diff line number	Diff line change
`@@ -2104,7 +2104,7 @@ public static String getSQL(AbstractSQLConfig config) throws Exception {`
`2104`	`2104`	`default:`
`2105`	`2105`	`config.setPreparedValueList(new ArrayList<Object>());`
`2106`	`2106`	`String column = config.getColumnString();`
`2107`		`- return (config.isExplain() ? "EXPLAIN " : "") + "SELECT " + (config.getCache() == JSONRequest.CACHE_RAM ? "SQL_NO_CACHE " : "") + column + " FROM " + getConditionString(column, tablePath, config);`
	`2107`	`+ return (config.isExplain() ? (config.isSQLServer() \|\| config.isOracle() ? "SET STATISTICS PROFILE ON;\n" : "EXPLAIN ") : "") + "SELECT " + (config.getCache() == JSONRequest.CACHE_RAM ? "SQL_NO_CACHE " : "") + column + " FROM " + getConditionString(column, tablePath, config);`
`2108`	`2108`	`}`
`2109`	`2109`	`}`
`2110`	`2110`