python_re

xml:
<select id="countSellRequestBybatchId" parameterClass="java.lang.Long" resultClass="java.lang.Long">
        select
        count(*) from BUS_FUND_SELL_REQUEST where batch_id=#batchId#
    </select>

<select id="countSellRequestBybatchId" parameterClass="java.lang.Long" resultClass="java.lang.Long">
        select * from table where rownum<40
    </select>
(<select id="countSellRequestBybatchId" parameterClass="java.lang.Long" resultClass="java.lang.Long">
        select * from table limit 40
    </select>
)

<select id="getSellRequestDTOsByBatchId" parameterClass="map" resultClass="com.lufax.wsqb.dto.FundSellRequestDTO">
        select
        from (select
        rownum as rn,t.* from BUS_FUND_SELL_REQUEST t where batch_id=#batchId# and rownum<40) where rownum>=21
        where rn>=21
</select>
(<select id="getSellRequestDTOsByBatchId" parameterClass="map" resultClass="com.lufax.wsqb.dto.FundSellRequestDTO">
        select * from BUS_FUND_SELL_REQUEST t where batch_id=#batchId# limit 21,40
</select>

python_re

原文：https://www.cnblogs.com/applejuice/p/12203026.html