文章标题

<!-- 定义综合查询前缀，后缀sql -->    <sql id="prefixSql">    <dynamic>    <isEqual property="doCount" compareValue="true">        select count(*) as $COUNT_ALL_NAME$ from (    </isEqual>    <isEqual property="doCount" compareValue="false">        <isEqual property="queryAll" compareValue="false">            SELECT * FROM (select row_.*, rownum start_rownum_ from (           </isEqual>    </isEqual>    </dynamic>    </sql>     <sql id="suffixSql">    <dynamic>    <isEqual property="doCount" compareValue="true">        )    </isEqual>    <isEqual property="doCount" compareValue="false">        <isEqual property="queryAll" compareValue="false">            <![CDATA[            ) row_ WHERE rownum <= #lastCursorPosition#  )  WHERE start_rownum_ >= #firstCursorPosition#                ]]>        </isEqual>    </isEqual>    </dynamic>    </sql>