springmvc mybatis 分页 控制层及sql语句 oracle mysql easyui

/**
* 分页条件查询用户
* @param page
* @param rows
* @param s_user
* @param response
* @return
* @throws Exception   page  rows total是easyui分页属性 easyui 自带 不需要定义
*/ 
@RequestMapping(value="/list")
public String list(@RequestParam(value="page",required=false)String page,
                 @RequestParam(value="rows",required=false)String rows,
               User s_user,HttpServletResponse response)throws Exception{
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Map<String,Object> map=new HashMap<String,Object>();
map.put("userName", s_user.getUserName());
/*map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize()); 对应是mysql*/
map.put("start", pageBean.getStartRow()); //对应是oracle
map.put("size", pageBean.getEndRow());
List<User> userList=userService.find(map);
int total=userService.getTotal(map);
JSONObject result=new JSONObject();
JSONArray jsonArray=JSONArray.fromObject(userList);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
return null;

}

mapper.xml

<!--分页返回类型list 可以使用map User对应的是resultMap size每页的大小 oracle-->
<select id="find" resultMap="User" parameterType="Map">
select t2.* from 
( select t1.*,rownum rn from t_user t1 
    <where> 
    <if test ="userName !=null and userName !='' ">
t1.userName like  '%'||#{userName,jdbcType=VARCHAR}||'%'
</if>
    </where>
) t2
   <where>
    <if test ="start !=null and start !=''">
       <![CDATA[and t2.rn >=#{start}]]>
       </if>
     
       <if test ="size !=null and size !=''">
    and  <![CDATA[t2.rn <#{size}]]>
    </if>