<selectid="selectPageCount"parameterType="com.test.java.front.test.mysql.deep.page.param.biz.PlayerQueryParam"resultType="java.lang.Long"> select count(*) from player <includerefid="conditions" /> select>
<selectid="selectPager1"parameterType="com.test.java.front.test.mysql.deep.page.param.biz.PlayerQueryParam"resultMap="BaseResultMap"> select <includerefid="Base_Column_List" /> from player <includerefid="conditions" /> <includerefid="pager" /> select>
<selectid="selectPager2"parameterType=
"com.test.java.front.test.mysql.deep.page.param.biz.PlayerQueryParam"resultMap="BaseResultMap"> select <includerefid="Base_Column_List" /> from player a, ( select id as tmpId from player <includerefid="conditions" /> <includerefid="pager" /> ) b where a.id = b.tmpId select>
<selectid="selectPager3"parameterType="com.test.java.front.test.mysql.deep.page.param.biz.PlayerQueryIdParam"resultMap="BaseResultMap"> select <includerefid="Base_Column_List" /> <includerefid="conditions" /> from player where id > #{startId} limit #{pageSize} select> mapper>