Question

mybatis实现分页前端怎么写

Answer 1

<select id="queryRoleByPage" resultMap="roleCustomeMap">
select
a.role_id,a.role_name,a.available ,
b.permission_id,
c.permission_name
from sys_role a, sys_role_permission b, sys_permission c
where a.role_id = b.role_id and b.permission_id = c.permission_id and a.role_id in (
select top ${rows} role_id from sys_role where role_id in(
select top ${pagebegin} role_id from sys_role order by role_id asc
)order by role_id desc
)order by a.role_id asc </select>