询_查_页_分

    <!-- 分页查询  -->
    <select id="queryPage" resultClass="User">
        select * from ($sql$) order by usId
    </select>
    public static void pageQuery() throws SQLException
    {
        int page = 5;//当前第1页
        int size = 2;//每页显示2条
        String hql = "select * from (select * from UserInfo where rownum <= "
                + size
                * page
                + " order by usId) order by usId desc) where rownum <= ((select count(*) from UserInfo where rownum <= "
                + size * page + ")-" + (page - 1) * size;
        List queryForList = sqlMap.queryForList("queryPage", hql);
    }
---------------
page:当前页
size:页大小

Oracle分页：
select * from (select a.*,rownum as rid from userinfo a) b where b.rid >(page-1)*size and b.rid <= page*size;

MySql分页：
select * from userinfo LIMIT (page-1)*size, size;