SQL中遍历

无限进步

于 2020-11-27 17:19:20 发布

阅读量1.9k

点赞数

分类专栏：随便写着玩

本文链接：https://blog.youkuaiyun.com/tian895623/article/details/110237921

版权

随便写着玩专栏收录该内容

59 篇文章

订阅专栏

 @Select("<script> " +
            "select id,key_,name,icourl,comment,type,handle,handletype,jgbm from pt_desktop_toplevel " +
            "where jgbm = #{zxbm} and key_ in " +
            "<foreach item='userDesktopAuth' index='index' collection='userDesktopAuths' open='(' separator=',' close=')'>" +
            "#{userDesktopAuth}" +
            " </foreach> " +
            "</script>")
    List<DeskopTopLevelBean> getDeskopTopLevelBeans(@Param("userDesktopAuths") List<String> userDesktopAuths,@Param("zxbm") String zxbm);