java oracle的模糊查询加分页

java oracle的模糊查询加分页

 select * from (select t.*,rownum rn from 
 (select * from user
        <if test="name neq '' and name neq null">
            where name like '%'||#{name}||'%'
        </if>
        ) t)
        where  pageSize*page >= rn and (page-1)*pageSize< rn