mybatis中sql server分页,就是这些代码以前用mysql时可用LIMIT# {page.startRowNum}, #{page.pageSize};
<sql id="searchSummaryModelWhere">
<where>
SummaryID>374172
AND CountItem = 17
<if test="search.syear!=null and search.syear!=''">
<![CDATA[AND Year >= #{search.syear}]]>
</if>
<if test="search.eyear!=null and search.eyear!=''">
<![CDATA[AND Year <= #{search.eyear}]]>
</if>
</where>
</sql>
<select id="countApplicationModel" resultType="int" parameterType="com.sky9.stat.Application.model.SlickGrid">
select count(1) from REP_Summary
<include refid="searchSummaryModelWhere"/>
</select>
<select id="searchApplicationModel" resultMap="ApplicationModel" parameterType="com.sky9.stat.Application.model.SlickGrid">
select * from REP_Summary
<include refid="searchSummaryModelWhere"/>
</select>
求高手指点
追问:不是,以前的项目都是用的mysql,这次用这框架改sql server了,然后limit也不能用了。嗯我用过这个了
select * from (SELECT ROW_NUMBER() OVER (ORDER BY SummaryID) AS RowNumber, REP_Summary.*
FROM REP_Summary
where year=2011 and month=11 and day=0) as tb where tb.RowNumber>=5 and tb.RowNumber<=10
这样分页也有错误我把5和10换成#{page.startRowNum}和#{page.pageSize}。然后只分了两页,第二页只显示了第一页的最后一条数据#{page.pageSize}是页面实现的数量,#{page.startRowNum}是翻页,每翻一页加10.比如说第一页是0,第二页就是10.我看控制台打印的是正确的但是数据确实出不来。。。。。啊啊啊 ,我个悲剧,我把原来的那条语句赋值付错了,看到你写的我才反应过来,那再指点下怎么把#{page.pageSize}加进来,就是怎么规定一页显示多少呃,我用的是java。我写成where tb.RowNumber>=页码 and tb.RowNumber<=显示数据数。。。2吧。我都感觉太2了。那我现在怎么规定一页显示多少数据啊