<where>
<if test="startmonth!=null and startmonth!=''">
<![CDATA[ and ym >= #{startmonth} ]]>
</if>
<if test="endmonth!=null and endmonth!=''">
<![CDATA[ and ym <= #{endmonth} ]]>
</if>
<if test="cityname!=null and cityname!=''">
and cityname=#{cityname}
</if>
</where>
limit #{pageSize} offset #{pageSize}*(#{pageNum}-1);
pgsql分页代码
最新推荐文章于 2024-02-01 16:40:10 发布