因为limit中不支持动态运算符,故在写分页的时候mapper.xml中以下这种写法是错误的:
//错误写法
<select id="queryPageData" parameterType="entity.Page" resultType="entity.Board">
select * from board limit (#{pageNow}-1)*pageSize,#{pageSize}
</select>
建议解决方案:使用<bind></bind>标签
<select id="queryPageData" parameterType="entity.Page" resultType="entity.Board">
<bind name="pageNow" value="(pageNow-1)*pageSize"></bind>
select * from board limit #{pageNow},#{pageSize}
</select>
该方法中sql语句中的pagenow=(pageNow-1)*pageSize