mybatis分页查询

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>