在事务中提交批量sql

   CommandCollection iCommands = new CommandCollection();
            if(resultJson!=null){
                JSONArray array = resultJson.getJSONArray("data");
                List<JSONObject> list = JSONObject.parseArray(array.toJSONString(), JSONObject.class);
                for (JSONObject json: list) {
                    String ywTodoId=json.getString("todoid");
                    String foreignUserId=json.getString("userid");
                    User myUser = ApiPublicUtils.getUserInfoByForeignId(foreignUserId, "");
                    if(myUser!=null){
                        Sql sql = new Sql("update g_inbox set  WF_ID= ? where USER_ID = ? and INFO_ID = ? ");
                        sql.addParameter("WF_ID",ywTodoId);
                        sql.addParameter("USER_ID",ywTodoId);
                        sql.addParameter("INFO_ID",infoId);
                        iCommands.add(sql);
                    }
                }
                //批量执行更新操作
                DBManager.execute(iCommands);