springboot mybatis分页模糊查询

bug生产机器

已于 2022-02-28 17:03:52 修改

阅读量799

点赞数

CC 4.0 BY-SA版权

文章标签： spring boot elementui eureka

于 2022-02-28 17:00:31 首次发布

本文链接：https://blog.csdn.net/weixin_48472209/article/details/123186778

本文介绍如何在SpringBoot项目中结合Mybatis进行分页和模糊查询的实现，通过Controller调用UserMapper接口，利用ElementUI展示前端页面，同时结合Eureka进行服务发现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.controller

//接口路径：/user/page?pageNum=1&pageSize=10
    //分页接口
    //@RequestParam接受
    //limit第一个参数：pageNum = (pageNum -1) * pageSize;
@GetMapping("/page")
    public Map<String,Object> findPage(@RequestParam Integer pageNum,
                               @RequestParam Integer pageSize,
                                       @RequestParam
                                       String username){
        pageNum = (pageNum -1) * pageSize;
        username = "%"+username+"%";
        List<User> data = userMapper.selectPage(pageNum,pageSize,username);
          Integer total =  userMapper.selectTotal(username);
          Map<String,Object> res = new HashMap<>();
          res.put("data",data);
          res.put("total",total);
        return res;
    }

2.usermapper

 @Select("select * from user where username like #{username} limit #{pageNum},#{pageSize}")
    List<User> selectPage(Integer pageNum, Integer pageSize, String username);

    @Select("select count(*) from user where username like #{username}")
    Integer selectTotal(String username);

3.前台:

methods:{
    load(){
        //fetch api请求查询
        fetch("http://localhost:9090/user/page?pageNum="+this.pageNum+"&pageSize="+this.pageSize+"&username="+this.username).then(res => res.json()).then(res =>{
          console.log(res);
          this.userList=res.data;
          this.total = res.total;
        })
        }
}

4.直接调用load方法即可