oracle 配合mybatis example分页

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为