mybatis 传List类型参数以及返回List类型参数
dao:
public List<SysMenu> getMenusByRoleIdList(List<String> roleIdList){
return sysMenuMapper.getMenusByRoleIdList(roleIdList);
}
mappering.xml:
<resultMap id="BaseResultMap" type="cn.net.cnp.framework.pojo.SysMenu">
<!-- WARNING - .generated -->
<id column="SYS_MENU_ID" jdbcType="VARCHAR" property="sysMenuId"/>
<result column="MENU_NAME" jdbcType="VARCHAR" property="menuName"/>
<result column="LEVEL" jdbcType="INTEGER" property="level"/>
<result column="PID" jdbcType="VARCHAR" property="pid"/>
<result column="URL" jdbcType="VARCHAR" property="url"/>
<result column="IS_LEAF" jdbcType="INTEGER" property="isLeaf"/>
<result column="SORT_ORDER" jdbcType="INTEGER" property="sortOrder"/>
<result column="STATE" jdbcType="VARCHAR" property="state"/>
<result column="STAFF_ID" jdbcType="VARCHAR" property="staffId"/>
<result column="OP_DATE" jdbcType="TIMESTAMP" property="opDate"/>
<result column="REMARK" jdbcType="VARCHAR" property="remark"/>
<result column="LEFT_VALUE" jdbcType="VARCHAR" property="leftValue"/>
<result column="RIGHT_VALUE" jdbcType="VARCHAR" property="rightValue"/>
</resultMap>
<select id="getMenusByRoleIdList" resultMap="BaseResultMap">
SELECT * FROM SYS_MENU WHERE SYS_MENU_ID IN (
SELECT SYS_MENU_ID FROM SYS_ROLE_MENU WHERE SYS_ROLE_ID IN
<foreach item="item" collection="list" separator="," open="(" close=")" index="">
#{item}
</foreach>
)
</select>
上面传入的参数不管是什么名字只要类型是list且只有一个参数时,一概都是这么写:不写传参类型,collection固定写 '' list ''