struts2分页问题
在文本框中输入用户ID 460,为什么把数据库中的数据460,467,469全都分页显示出来了。。。。。
String sql = "select user_id,username,type,amount,reason,create_time from(SELECT user_id,username,type,amount,reason,Create_time,ROW_NUMBER() OVER (ORDER BY [id]) AS RowNumber FROM return_fee WHERE (1=1) "+conditions+") t WHERE t.RowNumber BETWEEN
"+p.getPageSize()*(p.getPageNow()-1)+ " AND " + p.getPageSize()*p.getPageNow();
[解决办法]
<a href="${ctx}/admin/getReturnFeeSet.do?pageNow=${Page.pageNow + 1}">下一页</a>