int totalRows= "select count(id) from PersonInfo";
int start = 0;
int rows = pageSize;
int left = totalRows;
while (start < totalRows) {
if (rows > left) {
rows = left;
}
logger.info("start = " + start + ", rows = "+ rows + ", left = " + left);
List<PersonInfo> personInfoList=
"SELECT * FROM PersonInfo limit#{start}, #{rows}";
"SELECT * FROM PersonInfo whereid >= (SELECT id FROM PersonInfo ORDER BY id LIMIT #{start}, 1) limit #{rows}";(查询优化)
start += rows;
left -= rows;
}