Mybatis-Plus

几种配置文件

1.新建springboot项目-pom文件

 引入依赖

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

        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!--lombok用来简化实体类-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>

2.application.properties

1.mysql 8下

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

2.mysql 5下

#mysql数据库连接
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus
spring.datasource.username=root
spring.datasource.password=00000

3.简单测试一下

3.1 pojo

package com.atguigu.mpdemo1010.pojo;

import lombok.Data;
@Data
public class User {
    private Long id;
    private String name;
    private Integer age;
    private String email;
}

3.2 mapper

@Repository
public interface UserMapper extends BaseMapper<User> {
}

3.3 测试类

package com.atguigu.mpdemo1010;

import com.atguigu.mpdemo1010.mapper.UserMapper;
import com.atguigu.mpdemo1010.pojo.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest
class Mpdemo1010ApplicationTests {

@Autowired
private UserMapper userMapper;
    @Test
    void contextLoads() {
        List<User> users = userMapper.selectList(null);
        System.out.println(users);
    }

}

注意：若是启动报错找不到bean，需要在启动类上添加mapperScan注解，或者mapper接口添加@mapper

4.在调用mapper时发现好多方法

这说明基本的单表的增删改查Mybatis-Plus已经帮我们做好了，但是复杂的业务还需要我们手动写xml

我们还可以配置sql日志

#mybatis日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

控制台效果