springBoot 整合MyBatis-2-MyBatis-plus

官方文档-https://www.baomidou.com/

基本介绍

1. MyBatis-PIus(简称MP)是一个MyBatis的增强工具，在MyBatis的基础上只做增强不做改变，为简化开发、提高效率而生。

2. 强大的CRUD操作：内置通用Mapper、通用Service,通过少量配置即可实现单表大部分CRUD操作，更有强大的条件构造器，满足各类使用需求

---

使用步骤

1. 创建maven项目，引入pom.xml

    <!--导入父工程，常规写法-->
    <parent>
        <artifactId>spring-boot-starter-parent</artifactId>
        <groupId>org.springframework.boot</groupId>
        <version>2.5.3</version>
    </parent>

    <dependencies>
        <!--引入starter-web-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!--引入mysql的驱动,版本由版本仲裁决定-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--引入配置处理器,application.yml可以提示-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
        </dependency>
        <!--引入lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!--引入test starter-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>
        <!--引入druid文件-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.17</version>
        </dependency>
        <!--mybatis-plus的引入-->
        <!-- https://mvnrepository.com/artifact/com.baomidou/mybatis-plus-boot-starter -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3</version>
        </dependency>

    </dependencies>

2. 配置Application.yml

server:
  port: 8080
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&charactorEncoding=UTF-8

3. 数据源配置类

@Configuration
public class DruidDataSourceConfig {
    @Bean
    @ConfigurationProperties("spring.datasource")
    public DataSource dataSource() throws SQLException {
        DruidDataSource druidDataSource = new DruidDataSource();
        return druidDataSource;
    }
}

4. 创建Application.java

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

5. 创建表属性Bean

public class Monster {
    private Integer id;
    private Integer age;
    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    private Date birthday;
    private String email;
    private String name;
    private String gender;
    private Double salary;
}

---

DAO层-Mapper

只需要Mapper接口extends BaseMapper，可不需要再写mapper.xml实现

• 疑惑的是，明明只是继承了BaseMapper这个接口，它是在哪儿实现的？？

@Mapper
public interface MonsterMapper extends BaseMapper<Monster> {
}

编写测试类，查看数据库连接返回数据

@SpringBootTest
public class MapperTest {
    @Resource
    private MonsterMapper monsterMapper;
    @Test
    public void getMonsterById(){
        Monster monster = monsterMapper.selectById(3);
        System.out.println(monster);
    }
}

• 如果不使用@Mapper注解，可以在Application.java上使用@MapperScan来扫描包，通常用于有多个Mapper的情况

@MapperScan(basePackages = {"com.stein.springboot.mybatisplus.mapper"})

---

Service层

• 创建接口 ，extends IService<>注意这儿的泛型，之前没写，导致实现类报错了

public interface MonsterService extends IService<Monster> {
}

• 实现接口

• 实现原有接口 implements MonsterService

• 通过extends ServiceImpl来实现IService的接口。同样注意泛型

@Service
public class MonsterServiceImpl
        extends ServiceImpl<MonsterMapper, Monster>
        implements MonsterService {
}

• 测试

    @Test
    public void getMonsterById(){
        Monster monster = monsterService.getMonsterById(3);
        System.out.println(monster);
    }

---

Controller层

MyBatis-Plus在这一层没有变化

@Controller
public class MonsterController {
    @Resource
    private MonsterService monsterService;

    @ResponseBody
    @GetMapping("/monster")
    public Monster getMonsterById(){
        return monsterService.getById(3);
    }
    @ResponseBody
    @GetMapping("/list")
    public List<Monster> list(){
        return monsterService.list();
    }
}

创建映射并调用就可以了

---

MyBatisX插件 -- 文档 https://baomidou.com/pages/ba5b24/

---

注意事项

select * from` TableName`

sql表名默认是按照Bean类的名称小写来读取。如果不一致，需要使用注解@TableName("")来设置。