1Java文件
List<RFMenu> getMenusByIds(@Param(value="ids")List<Integer> ids); |
2.对应的xml文件
<select id="getMenusByIds" parameterType="java.lang.Integer" resultType="com.ruifeng.tjtaxiwebqy.entity.RFMenu"> SELECT Lsh,Lb,MenuCaption,MenuBrief,MenuKey,ParentMenuKey,ICON,isShow,Ord from RFMenu WHERE isShow='1' <if test="ids != null"> AND Lsh in <foreach collection="ids" open="(" separator="," close=")" item="id"> #{id} </foreach> </if> ORDER BY Ord ,ParentMenuKey </select> |