前台传递数组后台解析处理

约定不等于承诺〃 2021-11-05 07:18 356阅读 0赞

根据前台传递的数组ID查询出对应的数据

1.前台传递数组

>     ...
>     if(result != ""&&result != null&&result.length>0){
>         var appListId = [];//需要传递的数组
>         for(var i = 0;i<result.length&&i<5;i++){
>             appListId.push(result[i].app_id);//塞值
>         }
>         getAppInfoById(appListId);//调用
>     }else {
>         //空数据显示
>         ...
>     }

>     //根据ID获取数据
>     function getAppInfoById(appListId) {
>         require(["ajaxutil"], function (ajaxutil) {
>             ajaxutil.postJson("__context__/rest/appCount/getByListAppId", function (data) {
>                 ...
>             },{
>                 appListId:JSON.stringify(appListId)
>             })
>         })
>     }

2.后台接收

>     @RequestMapping(value = "/getByListAppId", method = RequestMethod.POST, produces = "text/json;charset=UTF-8")
>     @ResponseBody
>     public String selectByListAppId(HttpServletRequest request) {
>         RetInfo retInfo = RetInfoUtils.getRetInfoBySuccess();
>         try {
>             JSONObject getParam = RequestUtils.getJSONObject(request);
>             String appListId = getParam.get("appListId").toString()==null?"":getParam.get("appListId").toString();
>             List<Tb_open_app_info> appInfos = null;
>             logger.info("根据appid查询应用Start:入参--->" + appListId);
>             if(!"".equals(appListId)){
>                 //对前台接收的数组进行解析处理
>                 JSONArray jsonArray = JSON.parseArray(appListId);
>                 List list = JSONObject.parseArray(jsonArray.toJSONString());
>                 appInfos = tbOpenAppInfoDao.selectByListAppId(list);
>             }
>             retInfo.setObject(appInfos);
>         } catch (Exception e) {
>             retInfo = RetInfoUtils.getRetInfoByError(CommonConstant.IS_UNLOGIN, "查询失败");
>             e.printStackTrace();
>         }
>         return net.sf.json.JSONObject.fromObject(retInfo).toString();
>     }

3.xml处理

>     <select id="selectByListAppId" parameterType="java.util.List" resultType="com.sitech.admin.entity .Tb_open_app_info">
>     
>         select * from tb_open_app_info where app_id in
>         <foreach item="item" index="index" collection="appIdList" open="(" close=")" separator=",">
>             #{item,jdbcType=NUMERIC}
>         </foreach>
>     
>     </select>