Java框架搭建(mybatis plus)

mybatis plus

1. 添加依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.2</version>
</dependency>

2.删掉application.yml中的mybatis，加上mybatis plus

# mybatis-plus配置
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  typeAliasesPackage: com.qcby.demo.entity
  mapperLocations: classpath:mapper/*.xml
#  全局配置id自增
  global-config:
    db-config:
      id-type: auto

3.在demo下建立config并建立MybatisPlusConfig类

package com.qcby.demo.config;

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;
//启动的移过来
@MapperScan("com.qcby.demo.mapper")
@Configuration
public class MybatisPlusConfig {
    // 最新版
    @Bean  // <bean id=""/>
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
}

4.测试跟分页

package com.qcby.demo.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.qcby.demo.entity.User;
import com.qcby.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@RequestMapping("user")
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping("listAll")
    public List<User> listAll(){
        return userService.listAll();
    }

    @RequestMapping("listAll1")
    public  List<User> listAll1(){
        return userService.list();
    }
    @RequestMapping("listPage")
    public IPage listPage(int pageNo,int pageSize,User user){
        Page<User> page = new Page<>(pageNo,pageSize);


        QueryWrapper<User> queryWrapper = new QueryWrapper<>();

        if(!StringUtils.isEmpty(user.getUsername())){
                queryWrapper.like("username",user.getUsername());
        }
        IPage<User> pageInfo = userService.page(page);
        return pageInfo;
    }


}