数据库sql:其中offSet是偏移值,pageCount当前页码,pageSize是本页的数量
BasePageSearch:
public int getOffSet() {
if (pageCount == 0 || pageSize == 0) {
return 0;
}
return (pageCount - 1) * pageSize;
}
<select id="selectAllVotes" resultMap="Vote">
SELECT
<include refid="voteBaseSelect"/>
from `vote` v
WHERE is_delete = 0
LIMIT #{offSet}, #{pageSize}
</select>