JFinal学习----分页并去重

下边是踩了好几个坑完善出来的代码。

public Page<House> listExpireSoonIzz(int pageNumber, int pageSize,Integer buildingId,Integer accountId){
		StringBuilder builder = new StringBuilder("select a.image,a.leaseType,a.area,a.money,a.roomNum,a.hallNum,a.numberPlate,b.checkOutTime,c.regionName,c.address,c.communityName,c.buildNo,count(distinct a.id)");
		builder.append(" from fwzl_house a inner join fwzl_house_sign b on a.id = b.houseId left join fwzl_building c on c.id=a.buildingId");
		builder.append(" where a.delFlag = 0 and a.buildingId = ? and b.status = ? and c.landlordAccountId = ? and date_format(b.checkOutTime,'%Y-%m-%d')<=date_add(curdate(),interval 30 day) GROUP BY a.id order by a.floorNum asc,a.chamberNum asc,b.checkOutTime asc");
		return getDao().paginate(pageNumber, pageSize,"select *","from("+builder.toString()+") as temp", buildingId, FwzlConstant.HOUSE_SIGN_STATUS_ING,accountId);

	}

注意：

count(distinct a.id)

GROUP BY a.id

"from("+builder.toString()+") as temp"