mybatis分页操作
<select id="find" resultType="User" parameterType="map" >
select * from stu
<if test="name!=null">where (name like #{name})</if>
order by ${id} ${sort} limit #{pageOffset},#{pageSize}
</select>
mybatis分页操作
<select id="find" resultType="User" parameterType="map" >
select * from stu
<if test="name!=null">where (name like #{name})</if>
order by ${id} ${sort} limit #{pageOffset},#{pageSize}
</select>