ajax传Long数组到springMVC再到Mybitys删除过程

最新推荐文章于 2022-06-22 13:24:12 发布

weixin_34232363

最新推荐文章于 2022-06-22 13:24:12 发布

阅读量162

点赞数

文章标签： java json python

原文链接：https://my.oschina.net/u/3234821/blog/2246876

版权

2019独角兽企业重金招聘Python工程师标准>>>

ajax部分


//删除
function del(idsArray) {
    if (!idsArray) {
        var idsArray = new Array();//创建一个数组
        var selected = $('#table1').bootstrapTable('getSelections');
        if(selected.length>0){
            for (i = 0; i < selected.length; i++) {
                //arrayObj=ids+selected[i].userId+',';
                idsArray.push(selected[i].userId)//将获得的id循环进数组
            }
        }
    }
    confirmDelete(idsArray)
}
function confirmDelete(idsArray){
        console.info(idsArray);

    $.ajax({
        url: "/ssmUser/delUser",
        type: "POST",
        contentType: "application/json",//注意
        data: JSON.stringify(idsArray),//注意
        success : function(result) {
            $('#delModel').modal('hide');
            refreshTable();
        }
    })
}

springmvc部分


    @ResponseBody
    @RequestMapping(value = "/delUser")
    public Object delUser(@RequestBody Long[] idsArray)
    {
        try{

            sysUserService.delUser(idsArray);
            return new Json(true,"成功",null);
        }
        catch (Exception e)
        {
            return new Json(true,"失败",null);
        }


    }


}

mybitys映射的xml

<delete id="deleteUser" parameterType="Long[]" >
    DELETE FROM sys_user WHERE user_id
    in
    <foreach collection="array" item="idsArray" open="(" close=")" separator=",">
    #{idsArray}
    </foreach>
</delete>

转载于:https://my.oschina.net/u/3234821/blog/2246876