mybatis实现分页前端怎么写

mybatis实现分页前端怎么写

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

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息