oracle分页查询sql语句xml版
<select id = "listQueryDpcInfoDO"  resultMap ="getListDpcInfoDO" >
select * from
(
SELECT A.*, ROWNUM RN
# from后为具体查询表语句
FROM ( select *
from DPCINFO
<where>
<if test="centerInputParam.province !=null">
province = #{centerInputParam.province }
</if>
<if test="centerInputParam.city !=null">
and  city = #{centerInputParam.city}
param name</if>
<if test="centerInputParam.area !=null">
and county = #{centerInputParam.area}
</if>
<if test="centerInputParam.begindate !=null ddate !=null">
and to_char(time,'yyyy-mm-dd') between #{centerInputParam.begindate} and #{ddate}            </if>
<if test="centerInputParam.cardNoOrName !=null">
and  addr = #{centerInputParam.cardNoOrName}
</if>
</where>) A
<where>
<if test="pageSize !=null and pageIndex !=null" >
ROWNUM <= #{pageSize}*#{pageIndex}
</if>
</where>
)
<where>
<if test= "pageIndex >1">
RN >=(#{pageIndex}-1)*#{pageSize}
</if>
</where>
</select>
<resultMap id="getListDpcInfoDO" type="com.keyou.domain.basicQuery.DpcInfoDO">
<id property="dpcinfoguid" column="DPCINFOGUID"/>
<result  property="dpcid" column="DPCID"/>
<result  property="addr" column="ADDR"/>
<result  property="time" column="TIME"/>
<result  property="province" column="PROVINCE"/>
<result  property="city" column="CITY"/>
<result  property="county" column="COUNTY"/>
<result  property="ip" column="IP"/>
</resultMap>

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。