springboot整合mybatis以及mybatis-plus 开发_springboot集成mybatis 和 mybatisplus

一、springboot整合mybatis

1.注解版

1.1 导入坐标

<dependencies>
        <!--mybatis坐标-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.29</version>
        </dependency>
 
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
 
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

1.2 编写配置文件application.yml

 
#数据源
spring:
  datasource:
    username: root
    password: 123456
    url:  jdbc:mysql://localhost:3307/testdb?serverTimezone=GMT
    driver-class-name: com.mysql.cj.jdbc.Driver
 

1.3 准备实体类Account ,省略了有参无参 setter getter toString方法

public class Account {
    private int aid;
    private String aname;
    private int amoney;
}

1.4 编写mapper映射器接口

@Mapper//注册注入一个mapper

@MapperScan(basePackages ="com.ztt.mybatis_springboot.mapper")//注册注入多个mapper(以包为单位) )

注意：两者只能写一个

//@Mapper//注册注入一个mapper
public interface AccountMapper {
    @Select("select * from account")
    public List<Account> findAll();
}

1.5 编写测试类

@SpringBootTest
class MybatisSpringbootApplicationTests {
 
    @Autowired(required = false)
    AccountMapper accountMapper;
 
    @Test
    void contextLoads() {
        List<Account> all=accountMapper.findAll();
        for (int i = 0; i <all.size() ; i++) {
            Account account=all.get(i);
            System.out.println(account);
 
        }
    }
 
}

1.6 输出结果

2.xml版

2.1 在接口中定义一个方法

public List<Account> find();

2.2 编写xml文件，在resources目录下新建一个mapper包，在mapper包里面新建一个AccountMapper.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 
 
<mapper namespace="com.ztt.mybatis_springboot.mapper.AccountMapper">
    <select id="find" resultType="com.ztt.mybatis_springboot.pojo.Account">
        select * from account;
    </select>
</mapper>

2.3 在主配置文件中添加mybatis的配置

mybatis:
  mapper-locations: mappers/*.xml

2.4 编写测试类

@Test
    void contextLoads1() {
        List<Account> all=accountMapper.find();
        for (int i = 0; i <all.size() ; i++) {
            Account account=all.get(i);
            System.out.println(account);
 
        }
    }

2.5 输出结果

二、MyBatis-Plus

1.MyBatis-Plus介绍

        MyBatis最佳搭档，只做增强不做改变，为简化开发、提高效率而生。

        详细信息请看官方文档https://www.wpsshop.cn/w/酷酷是懒虫/article/detail/991925