public String workshopQtyReporter(@Param("pageNo") Integer pageNo, @Param("pageSize") Integer pageSize){
StringBuffer sql = new StringBuffer();
sql.append(" SELECT * FROM 表名 where 1=1 ");
if (workshopIdList != null && workshopIdList.size() > 0) {
sql.append(" and id in ");
sql.append(" ( ");
for (Integer id: IdList) {
sql.append(id+ ",");
}
sql.setLength(sql.length() - 1);
sql.append(" ) ");
}
sql.append(" limit ").append(((pageNo - 1) * pageSize)).append(" , #{pageSize}");
return sql.toString();
}
如何写分页SQL
最新推荐文章于 2022-09-15 14:02:59 发布