MyBatisPlus01_SpringBoot与MybatisPlus整合

• 创建SpringBoot项目，选择以下工具包：

Lombok
Spring Web
Thymeleaf
MySQL Driver

• 添加MybatisPlus的依赖：

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

• 完整的pom文件如下：

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.3.1.RELEASE</version>
		<relativePath /> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.blu</groupId>
	<artifactId>mybatisplus01</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>mybatisplus01</name>
	<description>Demo project for Spring Boot</description>

	<properties>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-thymeleaf</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-boot-starter</artifactId>
			<version>3.3.1.tmp</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
			<exclusions>
				<exclusion>
					<groupId>org.junit.vintage</groupId>
					<artifactId>junit-vintage-engine</artifactId>
				</exclusion>
			</exclusions>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

• application.yml配置文件：

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mbdemo?useUnicode=true&characterEncoding=UTF-8
    username: root
    password: 123456

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

• User实体类：

package com.blu.entity;
import lombok.Data;

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

• UserMapper接口：

package com.blu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.blu.entity.User;

public interface UserMapper extends BaseMapper<User> {
	
}

• 启动类

package com.blu;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.blu.mapper")
public class Mybatisplus01Application {

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

	}

}

• 测试类

package com.blu.test;

import java.util.List;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import com.blu.entity.User;
import com.blu.mapper.UserMapper;

@SpringBootTest
public class UserMapperTest {
	
	@Autowired
	private UserMapper mapper;

	@Test
	public void test() {
		List<User> list = mapper.selectList(null);
		for (User user : list) {
			System.out.println(user);
		}
		
	}

}

• 数据库
  
• 测试结果：

==>  Preparing: SELECT id,`name`,age FROM user 
==> Parameters: 
<==    Columns: id, name, age
<==        Row: 1, BLU, 22
<==        Row: 2, zhangsan, 21
<==        Row: 3, lisi, 23
<==      Total: 3
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3d0cac1f]
User(id=1, name=BLU, age=22)
User(id=2, name=zhangsan, age=21)
User(id=3, name=lisi, age=23)