学步园

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mapper">

    <sql id="pageHeader">
    select  * from(select a.*,rownum rn from(
    </sql>
    <sql id="pageRoot">
      ) a where rownum &lt;= #{endRow}) where rn &gt;#{startRow}
    </sql>
   
</mapper>

    <!-- 查询试卷模板信息 -->
    <select id="listPaperTemplateByCondition"
        resultMap="paperTemplateResultMap" parameterType="Map">
        <include refid="pageHeader"/>
        select  paperTemplateId,templateName,depId,operNo,createDate,isSystem,totalMark,subject.subjectCode,subject.subjectName,stage.stageCode,stage.stageName
        from d_papertemplate papertemplate
        <include refid="pageRoot"/>
    </select>

<!-- 查询试卷模板数量 -->
    <select id="listPaperTemplateByConditionCount"
        resultType="int" parameterType="Map">
        select  count(1) from d_papertemplate
    </select>