Spring Boot整合MyBatis：持久层操作示例

原创亦凉 2024-12-06 18:21 13阅读 0赞

Spring Boot整合MyBatis，可以方便地进行持久层操作。下面是一个简单的示例：

1. 首先在pom.xml文件中添加MyBatis和Spring Boot的依赖：

```xml
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.0</version>
</dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.25</version>
</dependency>
```

2. 创建MyBatis的配置文件application.yml：

```yaml
mybatis:
  database: mysql
  configuration: mybatis-config.xml
```

3. 创建MyBatis的映射文件，例如UserMapper.xml：

```xml
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//MYBATIS/ORGANIZATION//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<insert id="insertUser">
        INSERT INTO user(name, email) VALUES(#{name}, #{email}))
    </insert>

<select id="selectAllUsers" resultType="com.example.demo.entity.User">
        SELECT * FROM user
    </select>

</mapper>
```

4. 创建实体类User，例如：

```java
package com.example.demo.entity;

import java.io.Serializable;

public class User implements Serializable {

private String name;
    private String email;

// getters and setters

}
```

5. 最后在Spring Boot的主类中配置MyBatis的全局环境：

```java
import org.mybatis.spring.mapper.MapperScannerConfigurer;

@Configuration
public class MybatisConfig {

@Bean
    public MapperScannerConfigurer mapperScannerConfigurer() {
        MapperScannerConfigurer configurer = new MapperScannerConfigurer();
        configurer.setBasePackage("com.example.demo.mapper");
        return configurer;
    }

}
```

现在你已经成功地在Spring Boot中整合了MyBatis，可以进行各种持久层操作了。