<select id="getReportsByPage" parameterType="com.supermap.supervise.entity.Report" resultType="com.supermap.supervise.entity.Report"> select * from (select rownum r,t.* from (select * from JB_REPORT <where> <if test="rpname!='' and rpname!=null"> and rpname like '%'||upper(#{rpname})||'%' </if> </where> order by rpid) t where rownum <= #{page}*#{pageSize}) where r>(#{page}-1)*#{pageSize} </select>