SpringBoot- xml方式整合Mybatis

拼搏现实的明天。 2022-10-05 14:54 214阅读 0赞

# SpringBoot整合Mybatis #

# 一.xml方式整合mybatis #

> xml方式在编写复杂SQL时，更适合。

## 1.导入依赖 ##

<dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>
    
    
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>1.1.10</version>
    </dependency>
    
    
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.3.2</version>
    </dependency>

## 2.编写配置文件 ##

//准备实体类
    @Data
    @NoArgsConstructor
    @AllArgsConstructor
    public class Air {
    
      private Integer id;
      private Integer districtId;
      private java.sql.Date monitorTime;
      private Integer pm10;
      private Integer pm25;
      private String monitoringStation;
      private java.sql.Date lastModifyTime;
    
      @Override
      public String toString() {
        return "Air{" +
                "id=" + id +
                ", districtId=" + districtId +
                ", monitorTime=" + monitorTime +
                ", pm10=" + pm10 +
                ", pm25=" + pm25 +
                ", monitoringStation='" + monitoringStation + '\'' +
                ", lastModifyTime=" + lastModifyTime +
                '}';
      }
    }

## 3.准备Mybatis ##

### 3.1接口 ###

@ComponentScan
    public interface AirMapper {
    
        List<Air> selectAll();
    }

### 3.2在启动类中，添加直接扫描Mapper接口所在的包 ###

@SpringBootApplication
    @MapperScan(basePackages = "boot.mapper")
    public class Springboot02Application {
    
        public static void main(String[] args) {
            SpringApplication.run(Springboot02Application.class, args);
        }
    
    }

### 3.3准备映射文件 ###

<?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="boot.mapper.AirMapper">
    
        <select id="selectAll" resultType="boot.entity.Air">
            select * from air
        </select>
    </mapper>

### 3.4  yml文件 ###

# mybatis配置
    mybatis:
      # 扫描映射文件
      mapper-locations: classpath:mapper/*.xml
      # 配置别名扫描的包
      type-aliases-package: com.qf.firstspringboot.entity
      configuration:
        # 开启驼峰映射配置
        map-underscore-to-camel-case: true
    # 连接数据库的信息
    spring:
      datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql:///air?serverTimezone=UTC
        username: root
        password: 123
        type: com.alibaba.druid.pool.DruidDataSource

## 4.测试 ##

@SpringBootTest
    class AirMapperTest {
    
        @Autowired
        private AirMapper airMapper;
    
        @Test
        void selectAll() {
            List<Air> airs = airMapper.selectAll();
            for (Air air : airs) {
                System.out.println(air);
            }
        }
    }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70]: /images/20221005/05aa55fb0d81437b9750665d22dcd393.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 1]: /images/20221005/9171adb1df9642a1ac0bbc9c09bc3340.png