81,091
社区成员
发帖
与我相关
我的任务
分享求教sql语句相关问题 分页
我的分页语句是这样的
String sql="select t2.* from(select t1.*,rownum rn from(select u.id,u.username,u.password,u.status,u.createtime"+
"from tb_user u order by u.id desc)t1 where rownum<=?)t2 where rn>?";
Object [] params={pageSize*pageNo,(pageNo-1)*pageSize};
其中参数是下面的两个，为什么查不出来呀，提示未找到未符合要求的，哪位给我解答一下
String sql="select t2.* from(select t1.*,rownum rn from(select u.id,u.username,u.password,u.status,u.createtime"+
"from tb_user u order by u.id desc)t1 where rownum<=?)t2 where rn>?";
Object [] params={pageSize*pageNo,(pageNo-1)*pageSize};
其中参数是下面的两个，为什么查不出来呀，提示未找到未符合要求的，哪位给我解答一下
...全文
请发表友善的回复…
发表回复
fengjixuchui886 2016-07-10
- 打赏
- 举报
WHERE T2.RN > (#{pageNo} - 1) * #{pageSize} AND T2.RN <=
#{pageNo}*#{pageSize}
</select>
<select id="queryAllCount" parameterType="SellWrap" resultType="int">
SELECT COUNT(0) FROM
(
SELECT T1.*,ROWNUM AS RN FROM
(
SELECT
S.SNO,S.SNAME,S.SPRICE,S.SNUM,S.SSALES,S.SDES,S.SCREATETIME,T.TNAME,U.UNAME FROM T_SELL S
INNER JOIN T_TYPE T ON S.TNO = T.TNO
INNER JOIN T_USER U ON S.UNO = U.UNO
${condition}
ORDER BY SSALES DESC) T1
)T2
</select>
<select id="queryById" parameterType="Sell" resultMap="Sell">
SELECT S.SNO,S.SNAME,S.SPRICE,S.SNUM,S.SSALES,S.SDES,S.SCREATETIME,T.TNAME,U.UNAME
FROM T_SELL S
INNER JOIN T_TYPE T ON
S.TNO = T.TNO
INNER
JOIN T_USER U ON S.UNO = U.UNO
ORDER BY SSALES DESC
WHERE SNO=#{no}
</select>
</mapper>
fengshuo850420 2016-07-09
- 打赏
- 举报
分页的语句请参考：
SELECT *
FROM (SELECT ROWNUM AS rowno, t.*
FROM tb_user u
WHERE hire_date BETWEEN TO_DATE ('20060501', 'yyyymmdd')
AND TO_DATE ('20060731', 'yyyymmdd')
AND ROWNUM <= 20) table_alias
WHERE table_alias.rowno >= 10;
