翻了一下mybatis-plus文档发现无这段的详细代码了,给自己留个档:

1.mybatisplusconfig配置

package com.example.demo.common;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;


@Configuration
@MapperScan("com.example.demo.mapper")
public class MybatisPlusConfig {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor(){
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
}

2.controller部分(带了一个搜索框的姓名模糊查询)

 @GetMapping("/findPage")
    public IPage<User> findPage(@RequestParam Integer pageNum,
                                       @RequestParam Integer pageSize,
                                       @RequestParam String username,
                                       @RequestParam String email){
        IPage<User> page = new Page<>(pageNum,pageSize);
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("username",username);
        //queryWrapper.and(w ->w.like("email",email));箭头拼接或者直接写,Mybatis-plus统一拼接
        queryWrapper.like("email",email);
       return userService.page(page,queryWrapper);
    }

3.前端部分

<el-form :inline="true" :model="userVo" class="demo-form-inline">
    <el-form-item label="姓名" label-width="70px">
      <el-input v-model="username" placeholder="请输入姓名"></el-input>
    </el-form-item>
     <el-form-item label="邮箱" label-width="70px">
      <el-input v-model="email" placeholder="邮箱"></el-input>
    </el-form-item>
//搜索框
<el-form-item>
      <el-button type="primary" @click="load">查询</el-button>
 </el-form-item>

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

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐