Spring Boot整合MyBatis：持久层操作示例-蒲公英云

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

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

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

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

<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>

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

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

创建MyBatis的映射文件，例如UserMapper.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">
<mapper namespace="com.example.demo.mapper.UserMapper">
    <!-- 插入用户 -->
    <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>

创建实体类User，例如：

package com.example.demo.entity;
import java.io.Serializable;
public class User implements Serializable {
    private String name;
    private String email;
    // getters and setters
}

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

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;
    }
}