mybatis分页查询

r囧r小猫 2023-07-18 09:11 29阅读 0赞

## mybatis分页查询 ##

*  1.通过PageHelper实现分页查询
 *  分页controller

@RequestMapping("/getRealtimeByCondition")
        public ResultCode getRealtimeByCondition(Map<String,Object> filters, @RequestParam  Integer pageNumber, @RequestParam Integer pageSize){ 
    
            PageHelper.startPage(pageNumber,pageSize);
            try { 
    
                return ResultCode.success(new PageInfo(appService.getRealtime()));
            }catch (Exception e){ 
                return ResultCode.error(e.getMessage());
            }
        }

*  2.通过limit offset关键字查询
 *  controller.java

@RequestMapping("/findFloodByPage")
        public ResultCode findFloodByPage(@RequestParam  Integer pageNumber, @RequestParam Integer pageSize) { 
    
            if ("".equals(pageNumber) || pageNumber == null  ||  "".equals(pageSize) || pageSize == null ) { 
                return ResultCode.errorParam("参数不能为空！");
            }
            List<FloodEntity> list = new ArrayList<FloodEntity>();
            try { 
    
                list = floodService.findFloodByPage(pageNumber,pageSize);
    
            } catch (Exception e) { 
                e.printStackTrace();
                return ResultCode.error("信息获取失败");
            }
            return ResultCode.success(list);
        }

*  service.java

public List<FloodEntity> findFloodByPageOrKey(String key, Integer pageNumber, Integer pageSize) { 
    
            return floodMapper.findFloodByPageOrKey(key,(pageNumber-1)*pageSize,pageSize);
    
        }

*  dao.java

//分页或关键字查询防洪点
        List<FloodEntity> findFloodByPageOrKey(@Param("key_word")String key_word,@Param("pageNumber") Integer pageNumber, @Param("pageSize")Integer pageSize);

*  dao.xml

<select id="findFloodByPageOrKey" resultMap="BaseResultMap">
            SELECT *  FROM  server_fhd
            <where>
                <if test="key_word != null and key_word.length()>0">
                    <bind name="bindname" value="'%' + key_word + '%'" />
                    name like #{ bindname}
                </if>
            </where>
                limit #{ pageSize}  offset #{ pageNumber}
        </select>