升级版本为 4.7.1；优化代码

TommyLemon · TommyLemon · commit 2fc8526863fe · 2021-07-31T02:55:00.000+08:00
diff --git a/APIJSONORM/pom.xml b/APIJSONORM/pom.xml
@@ -5,7 +5,7 @@
 
 	<groupId>apijson.orm</groupId>
 	<artifactId>apijson-orm</artifactId>
-	<version>4.6.7</version>
+	<version>4.7.1</version>
 	<packaging>jar</packaging>
 
 	<name>APIJSONORM</name>
diff --git a/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java b/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java
@@ -1525,7 +1525,7 @@ public static String getLimitString(int page, int count, boolean isTSQL, boolean
 		int offset = getOffset(page, count);
 
 		if (isTSQL) {  // OFFSET FECTH 中所有关键词都不可省略, 另外 Oracle 数据库使用子查询加 where 分页
-			return isOracle? " WHERE ROWNUM BETWEEN "+ offset +" AND "+ (offset + count): " OFFSET " + offset + " ROWS FETCH FIRST " + count + " ROWS ONLY";
+			return isOracle ? " WHERE ROWNUM BETWEEN "+ offset +" AND "+ (offset + count) : " OFFSET " + offset + " ROWS FETCH FIRST " + count + " ROWS ONLY";
 		}
 
 		return " LIMIT " + count + (offset <= 0 ? "" : " OFFSET " + offset);  // DELETE, UPDATE 不支持 OFFSET

Original file line number	Diff line number	Diff line change
`@@ -1525,7 +1525,7 @@ public static String getLimitString(int page, int count, boolean isTSQL, boolean`
`1525`	`1525`	`int offset = getOffset(page, count);`
`1526`	`1526`
`1527`	`1527`	`if (isTSQL) { // OFFSET FECTH 中所有关键词都不可省略, 另外 Oracle 数据库使用子查询加 where 分页`
`1528`		`- return isOracle? " WHERE ROWNUM BETWEEN "+ offset +" AND "+ (offset + count): " OFFSET " + offset + " ROWS FETCH FIRST " + count + " ROWS ONLY";`
	`1528`	`+ return isOracle ? " WHERE ROWNUM BETWEEN "+ offset +" AND "+ (offset + count) : " OFFSET " + offset + " ROWS FETCH FIRST " + count + " ROWS ONLY";`
`1529`	`1529`	`}`
`1530`	`1530`
`1531`	`1531`	`return " LIMIT " + count + (offset <= 0 ? "" : " OFFSET " + offset); // DELETE, UPDATE 不支持 OFFSET`