Mapper中的接口:
PermissionEntity selectPermission(Integer roleid, Integer menuid);
那么对应的映射文件:
<select id="selectPermission" resultType="com.msxf.media.db.entity.PermissionEntity">
SELECT p.* from menu m,permission p WHERE m.Menuid=p.Menuid AND p.Roleid = #{0} AND p.Menuid = #{1}
</select>
PermissionEntity selectPermission(Integer roleid, Integer menuid);
那么对应的映射文件:
<select id="selectPermission" resultType="com.msxf.media.db.entity.PermissionEntity">
SELECT p.* from menu m,permission p WHERE m.Menuid=p.Menuid AND p.Roleid = #{0} AND p.Menuid = #{1}
</select>
当sql语句中需要传递多个参数时,可以根据Mapper接口的传参顺序在sql语句中给值。例如Mapper接口的入参第一个是roleid,那么在sql语句中p.roleid = # {0}