java 使用where in 传参ids

@Select("<script>SELECT id,name,a,b,c FROM a_xx WHERE id in " +
            "<foreach collection='ids' index='index' item='id' open= '(' separator=',' close=')'>" +
            "#{id}" +
            "</foreach>" +
            " and disabled = 0 GROUP BY id " +
            "</script>")
    List<XxDto> selTotalByIds(@Param("ids") ArrayList<Object> ids);

 

posted @ 2020-08-18 09:59  ToDarcy  阅读(782)  评论(0编辑  收藏  举报