SpringBoot整合MyBatis工程

1.创建maven工程

 

 2.添加相关依赖

 <packaging>jar</packaging>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>

        <version>2.5.2</version>
    </parent>

    <dependencies>
        <!-- springBoot起步依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- springboot工程热部署配置-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
        </dependency>
<!--       mybatis起步依赖 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.0</version>
        </dependency>
<!--        数据库驱动依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.25</version>
            <scope>runtime</scope>
        </dependency>
<!-- 日志配置依赖-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <scope>test</scope>
        </dependency>
<!--        Data配置依赖 set和get的注解依赖-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>

3.在resource中创建application.yml文件，进行配置相关信息

spring:
#  数据源的配置
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/briger?serverTimezone=Asia/Shanghai&useSSL=false
    username: root
    password: 123456
#配置mybatis
mybatis:
#  mapper xml文件的位置
  mapper-locations: classpath:mapper/*.xml
#别名包的位置
  type-aliases-package: com.xie.domain
# 配置日志级别
#logging:
  #level: trace
server:
  port: 8089
  servlet:
    context-path: /text

4.编写实体类

@Data
public class Account {
    private Integer id;
    private String name;
    private  double money;
}

5.编写Mapper

@Mapper
public interface AccountMapper {

    List<Account> findAll();
}

6.配置Mapper映射文件

在src\main\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.xie.mapper.AccountMapper">
    <select id="findAll" resultType="Account">
        select * from account
    </select>
</mapper>

7.编写controller类

@RestController
public class AccountController {
    @Autowired
    IAccountService iAccountService;

    @RequestMapping("/account")
    public String getList(){
        return iAccountService.findAll().toString();
    }

}