<select id="selectByPage" resultType="com.mybatis.Test"> SELECT testid,testcontent FROM haodf_doctorInfo ORDER BY doctorinfoid LIMIT #{offset},#{limit} <!--这里修改了--> </select>有个 mysql 的
mybaits 的拦截器分页 是怎样做的啊
sql codeselect * from ( select row_number()over(order by tempcolumn)temprownumber,* from (select top 开始位置+10 tempcolumn=0,* from table1)t )tt网上搜的- -
SELECT testid,testcontent
FROM haodf_doctorInfo ORDER BY doctorinfoid LIMIT #{offset},#{limit} <!--这里修改了-->
</select>有个 mysql 的
from (
select row_number()over(order by tempcolumn)temprownumber,*
from (select top 开始位置+10 tempcolumn=0,* from table1)t
)tt网上搜的- -