mybatis-plus分页插件
翻了一下mybatis-plus文档发现无这段的详细代码了,给自己留个档:1.mybatisplusconfig配置package com.example.demo.common;import com.baomidou.mybatisplus.annotation.DbType;import com.baomidou.mybatisplus.extension.plugins.MybatisPlu
·
翻了一下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;
})
}

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