Spring-Boot框架使用Mybatis-Plus实现分页查询和查询条件式查询------Spring-Boot框架

╰+哭是因爲堅強的太久メ 2024-02-27 05:48 32阅读 0赞

>     package com.powernode.springbootvue.config;
>     
>     import com.baomidou.mybatisplus.annotation.DbType;
>     import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
>     import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
>     import org.springframework.context.annotation.Configuration;
>     
>     @Configuration
>     public class MyBatisPlusConfig
>     {
>         public MybatisPlusInterceptor paginationInterceptor()
>         {
>             MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
>             PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor(DbType.MYSQL);
>             interceptor.addInnerInterceptor(paginationInnerInterceptor);
>             return interceptor;
>         }
>     }
> 
>     package com.powernode.springbootvue.config;
>     
>     import com.baomidou.mybatisplus.annotation.DbType;
>     import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
>     import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
>     import org.springframework.context.annotation.Configuration;
>     
>     @Configuration
>     public class MyBatisPlusConfig
>     {
>         public MybatisPlusInterceptor paginationInterceptor()
>         {
>             MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
>             PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor(DbType.MYSQL);
>             interceptor.addInnerInterceptor(paginationInnerInterceptor);
>             return interceptor;
>         }
>     }

>     package com.powernode.springbootvue.controller;
>     
>     import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
>     import com.baomidou.mybatisplus.core.metadata.IPage;
>     import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
>     import com.powernode.springbootvue.Mapper.StuMapper;
>     import com.powernode.springbootvue.entity.Stu;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.web.bind.annotation.GetMapping;
>     import org.springframework.web.bind.annotation.RestController;
>     
>     import java.util.List;
>     
>     @RestController
>     public class StuController
>     {
>         @Autowired
>         private StuMapper stuMapper;
>         @GetMapping("/TestQueryWrapper")
>         public List<Stu> findByCond()
>         {
>             //Mybatis-Plus不能实现多表查询
>             //查询条件封装
>             QueryWrapper<Stu> queryWrapper = new QueryWrapper<>();
>             queryWrapper.eq("cid",1000);
>             return stuMapper.selectList(queryWrapper);
>         }
>         @GetMapping("/findByPage")
>         public IPage findByPage()
>         {
>             Page<Stu> page = new Page<>(0,2);
>             //封装的分页对象
>             IPage iPage = stuMapper.selectPage(page,null);
>             return iPage;
>         }
>     
>         @GetMapping("/StuAll")
>         public List<Stu> getStu()
>         {
>             return stuMapper.selectAllStu();
>         }
>     }
> 
>     package com.powernode.springbootvue.controller;
>     
>     import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
>     import com.baomidou.mybatisplus.core.metadata.IPage;
>     import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
>     import com.powernode.springbootvue.Mapper.StuMapper;
>     import com.powernode.springbootvue.entity.Stu;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.web.bind.annotation.GetMapping;
>     import org.springframework.web.bind.annotation.RestController;
>     
>     import java.util.List;
>     
>     @RestController
>     public class StuController
>     {
>         @Autowired
>         private StuMapper stuMapper;
>         @GetMapping("/TestQueryWrapper")
>         public List<Stu> findByCond()
>         {
>             //Mybatis-Plus不能实现多表查询
>             //查询条件封装
>             QueryWrapper<Stu> queryWrapper = new QueryWrapper<>();
>             queryWrapper.eq("cid",1000);
>             return stuMapper.selectList(queryWrapper);
>         }
>         @GetMapping("/findByPage")
>         public IPage findByPage()
>         {
>             Page<Stu> page = new Page<>(0,2);
>             //封装的分页对象
>             IPage iPage = stuMapper.selectPage(page,null);
>             return iPage;
>         }
>     
>         @GetMapping("/StuAll")
>         public List<Stu> getStu()
>         {
>             return stuMapper.selectAllStu();
>         }
>     }