@@ -128,7 +128,13 @@ protected void onVerifyContent() throws Exception {
 
 	@Override
 	public JSONObject parseCorrectRequest(JSONObject target) throws Exception {
-		return Structure.parseRequest(requestMethod, "", target, requestObject, this);
+		return Structure.parseRequest(requestMethod, "", target, requestObject, getMaxUpdateCount(), this);
 	}
 
+	//	//可重写来设置最大查询数量
+	//	@Override
+	//	public int getMaxQueryCount() {
+	//		return 50;
+	//	}
+
 }
@@ -670,7 +670,8 @@ public JSONArray onArrayParse(JSONObject request, String parentPath, String name
 
 
 		//不用total限制数量了，只用中断机制，total只在query = 1,2的时候才获取
-		int size = count <= 0 || count > 100 ? 100 : count;//count为每页数量，size为第page页实际数量，max(size) = count
+		int max = getMaxQueryCount();
+		int size = count <= 0 || count > max ? max : count;//count为每页数量，size为第page页实际数量，max(size) = count
 		Log.d(TAG, "getArray  size = " + size + "; page = " + page);
 
 
@@ -907,6 +908,15 @@ private JSONObject getJoinObject(String table, JSONObject obj, String key) {
 		return requestObj;
 	}
 
+	@Override
+	public int getMaxQueryCount() {
+		return MAX_QUERY_COUNT;
+	}
+	@Override
+	public int getMaxUpdateCount() {
+		return MAX_UPDATE_COUNT;
+	}
+	
 
 	/**根据路径取值
 	 * @param parent
 
@@ -1872,6 +1872,7 @@ public static List<Join> parseJoin(RequestMethod method, List<Join> joinList, Ca
 		String name;
 		for (Join j : joinList) {
 			name = j.getName();
+			//JOIN子查询不能设置LIMIT，因为ON关系是在子查询后处理的，会导致结果会错误
 			SQLConfig joinConfig = newSQLConfig(method, name, j.getTable(), null, callback).setMain(false).setKeyPrefix(true);
 			SQLConfig cacheConfig = newSQLConfig(method, name, j.getTable(), null, callback).setCount(1);
 
 
@@ -24,6 +24,10 @@
  */
 public interface Parser {
 
+	int MAX_QUERY_COUNT = 100;
+	int MAX_UPDATE_COUNT = 10;
+	
+	
 	@NotNull
 	Visitor getVisitor();
 	Parser setVisitor(@NotNull Visitor visitor);
@@ -83,6 +87,9 @@ public interface Parser {
 
 	ObjectParser createObjectParser(JSONObject request, String parentPath, String name, SQLConfig arrayConfig) throws Exception;
 
+	int getMaxQueryCount();
+	int getMaxUpdateCount();
+	
 	void putQueryResult(String path, Object result);
 
 
@@ -91,5 +98,4 @@ public interface Parser {
 
 	JSONObject executeSQL(SQLConfig config) throws Exception;
 
-
 }
@@ -59,24 +59,34 @@
 public class Structure {
 	private static final String TAG = "Structure";
 
-
-
 	private Structure() {}
 
 
-
-
 	/**从request提取target指定的内容
 	 * @param method
 	 * @param name
 	 * @param target
 	 * @param request
-	 * @param creator 
+	 * @param creator
 	 * @return
 	 * @throws Exception
 	 */
 	public static JSONObject parseRequest(@NotNull final RequestMethod method, final String name
 			, final JSONObject target, final JSONObject request, final SQLCreator creator) throws Exception {
+		return parseRequest(method, name, target, request, Parser.MAX_UPDATE_COUNT, creator);
+	}
+	/**从request提取target指定的内容
+	 * @param method
+	 * @param name
+	 * @param target
+	 * @param request
+	 * @param maxUpdateCount
+	 * @param creator
+	 * @return
+	 * @throws Exception
+	 */
+	public static JSONObject parseRequest(@NotNull final RequestMethod method, final String name
+			, final JSONObject target, final JSONObject request, final int maxUpdateCount, final SQLCreator creator) throws Exception {
 		Log.i(TAG, "parseRequest  method = " + method  + "; name = " + name
 				+ "; target = \n" + JSON.toJSONString(target)
 				+ "\n request = \n" + JSON.toJSONString(request));
@@ -107,13 +117,13 @@ public JSONObject onParseJSONObject(String key, JSONObject tobj, JSONObject robj
 						}
 					} else {
 						if (RequestMethod.isQueryMethod(method) == false) {
-							verifyId(method.name(), name, key, robj, KEY_ID, true);
-							verifyId(method.name(), name, key, robj, KEY_USER_ID, false);
+							verifyId(method.name(), name, key, robj, KEY_ID, maxUpdateCount, true);
+							verifyId(method.name(), name, key, robj, KEY_USER_ID, maxUpdateCount, false);
 						}
 					}
 				} 
 
-				return parseRequest(method, key, tobj, robj, creator);
+				return parseRequest(method, key, tobj, robj, maxUpdateCount, creator);
 			}
 		});
 
@@ -128,7 +138,7 @@ public JSONObject onParseJSONObject(String key, JSONObject tobj, JSONObject robj
 	 * @param atLeastOne 至少有一个不为null
 	 */
 	private static void verifyId(@NotNull String method, @NotNull String name, @NotNull String key
-			, @NotNull JSONObject robj, @NotNull String idKey, boolean atLeastOne) {
+			, @NotNull JSONObject robj, @NotNull String idKey, final int maxUpdateCount, boolean atLeastOne) {
 		//单个修改或删除
 		Object id = null;
 		try {
@@ -154,9 +164,9 @@ private static void verifyId(@NotNull String method, @NotNull String name, @NotN
 						+ " 里面 " + idKey + " 和 " + idInKey + " 至少传其中一个！");
 			}
 		} else {
-			if (idIn.size() > 10) { //不允许一次操作10条以上记录
+			if (idIn.size() > maxUpdateCount) { //不允许一次操作 maxUpdateCount 条以上记录
 				throw new IllegalArgumentException(method + "请求，" + name + "/" + key
-						+ " 里面的 " + idInKey + ":[] 中[]的长度不能超过10！");
+						+ " 里面的 " + idInKey + ":[] 中[]的长度不能超过 " + maxUpdateCount + " ！");
 			}
 			//解决 id{}: ["1' OR 1='1'))--"] 绕过id{}限制
 			//new ArrayList<Long>(idIn) 不能检查类型，Java泛型擦除问题，居然能把 ["a"] 赋值进去还不报错
Original file line number	Diff line number	Diff line change
`@@ -128,7 +128,13 @@ protected void onVerifyContent() throws Exception {`
`128`	`128`
`129`	`129`	`@Override`
`130`	`130`	`public JSONObject parseCorrectRequest(JSONObject target) throws Exception {`
`131`		`- return Structure.parseRequest(requestMethod, "", target, requestObject, this);`
	`131`	`+ return Structure.parseRequest(requestMethod, "", target, requestObject, getMaxUpdateCount(), this);`
`132`	`132`	`}`
`133`	`133`
	`134`	`+ // //可重写来设置最大查询数量`
	`135`	`+ // @Override`
	`136`	`+ // public int getMaxQueryCount() {`
	`137`	`+ // return 50;`
	`138`	`+ // }`
	`139`	`+`
`134`	`140`	`}`