springboot40-整合MybatisPlus

1、导入项目依赖

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

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.6</version>
        </dependency>

2、设置mapper扫描注解

3、配置application.yml

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mp
    username: root
    password: "2000820."
    
    
#mybatis:
#  mapper-locations:   这是用来指定我们所写mapper文件的位置，因为mp已经帮我们写好了基本的crud方法，如果够用，我们就不用编写mapper文件里，就不用指定了

注意：springboot.datasource.type是用来指定我们需要的数据源，SpringBoot默认的数据源是org.apache.tomcat.jdbc.pool.DataSource

4、创建product表

5、创建Product实体类

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Product {
    private int category;
    private int count;
    private String description;
    private int userId;
}

6、编写ProductMapper接口

public interface ProductMapper extends BaseMapper<Product> {
}

7、编写测试类查询所有

@SpringBootTest
class Springboot07MybatisplusApplicationTests {

    @Autowired
    private ProductMapper productMapper;

    @Test
    void contextLoads() {
        List<Product> products = productMapper.selectList(null);
        for (Product product : products) {
            System.out.println(product);
        }
    }

}