Mybatis Plus 初始化

pom.xml

<!-- mybatis-plus -->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.0.5</version>
</dependency>
<!-- 数据库驱动 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

applicationContext.properties

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus? useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=123456
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

• mysql 5 驱动com.mysql.jdbc.Driver
• mysql 8 驱动com.mysql.cj.jdbc.Driver
• 需要增加时区的配置 serverTimezone=GMT%2B8

实体类

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

Mapper

• 在对应的Mapper上面继承基本的类 BaseMapper

@Repository
public interface UserMapper extends BaseMapper<User> {

}

Application.class

• 在主启动类上去扫描mapper包下的所有接口。

@MapperScan("com.exaple.mapper")
@SpringBootApplication
public class Application {

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

}

测试

• 查询全部用户。

public class MybatisPlusApplicationTests {

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

}