分页sql

数据库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>