SpringBoot整合Mybatis-Plus(完整版)

源码下载：https://download.csdn.net/download/kk12927/12446733

一：引入依赖

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

二：配置环境

1.application

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name= com.mysql.cj.jdbc.Driver
spring.datasource.url= jdbc:mysql://localhost:3306/mybatis-plus?serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=123456

logging.level.root=info
loggong.level.com.ck.springboot.dao=debug

2.准备entity，在entity下创建了User类（对应数据里User表）

package com.ck.springboot.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;
import lombok.experimental.Accessors;

import java.util.Date;

@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
@Accessors(chain = true)
@TableName(value = "User")//默认将类名作为表名
public class User {

    /**
     * 参数一:对应数据库中主键的名称
     * 参数二：id自增
     */
    @TableId(value = "id",type = IdType.AUTO)
    private String id;

	//如果数据库里的名字不叫name，叫username,则使用这个标签
    @TableField(value = "username")
    private String name;
    private Integer age;
    private Date bir;

    /**
     * 不映射数据库表中任何字段
     */
    @TableField(exist = false)
    private String aaa;
}

3.创建DAO继承mybatis-plus增强接口

package com.ck.springboot.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ck.springboot.entity.User;

//使用mybatis-plus增强接口
public interface UserDao extends BaseMapper<User> {

}

4.主程序入口加入DAO文件路径

@SpringBootApplication
@MapperScan("com.ck.springboot.dao")
public class SpringBootMybatisPush01Application {

    public static void main(String[] args) {
        SpringApplication.run(SpringBootMybatisPush01Application.class, args);
    }

}

5.分页配置插件，在conf里创建配置文件
注意：分页现在只支持单表查询

package com.ck.springboot.conf;

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@EnableTransactionManagement
@Configuration
@MapperScan("com.ck.springboot.dao")
public class fy {

    //分页拦截器对象
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        // 设置请求的页面大于最大页后操作， true调回到首页，false 继续请求  默认false
        // paginationInterceptor.setOverflow(false);
        // 设置最大单页限制数量，默认 500 条，-1 不受限制
        // paginationInterceptor.setLimit(500);
        // 开启 count 的 join 优化,只针对部分 left join
       // paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
        return paginationInterceptor;
    }
}

三：执行代码测试

    @Autowired
    private UserDao userDao;

    //查询所有
    @Test
    public void test(){
        List<User> users = userDao.selectList(null);
        users.forEach(user -> System.out.println("user = " + user));
        //结果：
        //user = User(id=1, name=ck, age=22, bir=Tue May 19 20:09:47 CST 2020, aaa=null)
		//user = User(id=2, name=kk, age=20, bir=Wed May 13 20:43:16 CST 2020, aaa=null)
    }


   //根据主键查询一个
    @Test
    public void testFinByID(){
        User user = userDao.selectById("2");
        System.out.println("user = " + user);
    }


    //条件查询
    @Test
    public void testFind(){
        QueryWrapper<User> objectQueryWrapper = new QueryWrapper<>();

        //objectQueryWrapper.eq("age",22);//设置等值查询
//        objectQueryWrapper.lt("age",21);//设置小于查询
        objectQueryWrapper.le("age",22);//小于等于查询     gt是大于查询   ge是大于等于操作
        List<User> users = userDao.selectList(objectQueryWrapper);
        users.forEach(user-> System.out.println(user));
    }


    //模糊查询
    @Test
    public void testFindLike(){
        QueryWrapper<User> objectQueryWrapper = new QueryWrapper<>();
        //like  %?%
//        objectQueryWrapper.like("name","k");

        //like %?   以k结尾的
//        objectQueryWrapper.likeLeft("name","k");

        //like ?%   以c开头的
        objectQueryWrapper.likeRight("name","c");
        List<User> users = userDao.selectList(objectQueryWrapper);
        users.forEach(user-> System.out.println(user));
    }


    //保存方法
    @Test
    public void testSave(){
        User user = new User();
        user.setName("xxx").setBir(new Date()).setAge(23);
        userDao.insert(user);
    }
    

    //修改根据id
    @Test
    public  void updateT(){
        User user = userDao.selectById("2");
        user.setName("updatee_k");
        userDao.updateById(user);
    }


    //批量修改
    @Test
    public void testUpdate(){
        User user = userDao.selectById("3");
        user.setName("up_3");
        QueryWrapper<User> updateWapper = new QueryWrapper<>();
        updateWapper.eq("age",23);
        userDao.update(user,updateWapper);
    }


    //基于id删除
    @Test
    public void testD(){
        userDao.deleteById("3");
    }


    //基于条件删除
    @Test
    public void testDD(){
        QueryWrapper<User> objectQueryWrapper = new QueryWrapper<>();
        objectQueryWrapper.gt("age",21);
        userDao.delete(objectQueryWrapper);
    }


   //分页查询
    @Test
    public void testFindPage(){
        QueryWrapper<User> objectQueryWrapper = new QueryWrapper<>();
        objectQueryWrapper.eq("age",23);
        //参数1：当前页 默认值 1  参数2：每页显示记录数 默认值10
        IPage<User> page = new Page<>(1,2);
        IPage<User> userIPage = userDao.selectPage(page,objectQueryWrapper);
        long total = userIPage.getTotal();
        System.out.println("总记录数：" + total);
        userIPage.getRecords().forEach(user-> System.out.println("user = " + user));

    }