mybatis逆向生成的xml 内增加 分页
<select id="selectByPage" parameterType="map" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from(
(select rownum rn,uo.* from
(select * from mytable
<if test="_parameter != null">
<include refid="Update_By_Example_Where_Clause" />
</if>
order by ${example.orderByClause}
) uo
where rownum <=#{limit})) ua
where ua.rn>#{start}
</select>
Update_By_Example_Where_Clause
接口增加
List<tableObject> selectByPage(@Param("start") int start,@Param("limit") int limit,@Param("example") tableObjectExample example);
service为