SpringBoot项目集成MYSQL+Mybatis-Plus步骤-526互联

1、引入maven

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.5.2</version>
</dependency>
<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <version>8.0.31</version>
</dependency>

2、配置application.yml

server:
  port: 8888
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/dubbo-demo
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
mybatis-plus:
  mapper-locations: classpath*:/mapper/**/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

3、启动类增加扫描文件

4、实体类新增注释

5、新增mapper.xml

新建resources/mapper/UserMapper.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.dyaqi.provider.mapper.UserMapper">
    <select id="findOrdersByUserId" resultType="com.dyaqi.provider.domain.Order">
        SELECT o.id, o.name, o.price, o.num
        FROM `tb_order` o
        WHERE o.userId = #{userId}
    </select>
</mapper>

6、修改impl和mapper文件

mybatis-plus springboot步骤mybatis

mybatis-plus springboot mybatis项目

mybatis-plus springboot mybatis mapper

mybatis-plus步骤mybatis plus

mybatis-plus springboot mybatis plus

excel mybatis-plus springboot easyexcel

mybatis-plus springboot mybatis问题

mybatis-plus springboot2 springboot插件

mybatis-plus springboot3 springboot mybatis

mybatis-plus springboot保姆mybatis