MyBatis R2DBC 使用教程

MyBatis R2DBC 使用教程

项目地址:https://gitcode.com/gh_mirrors/my/mybatis-r2dbc

项目介绍

MyBatis R2DBC 是一个旨在将 MyBatis 与 R2DBC（Reactive Relational Database Connectivity）结合的项目。R2DBC 提供了一种响应式的数据库连接方式，而 MyBatis 是一个流行的持久层框架。通过 MyBatis R2DBC，开发者可以在响应式应用中使用 MyBatis 进行数据库操作，从而提高数据库访问的效率和性能。

项目快速启动

环境准备

• JDK 11 或更高版本
• Maven 或 Gradle
• 支持 R2DBC 的数据库（如 MySQL）

添加依赖

在 pom.xml 中添加以下依赖：

<dependencies>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-r2dbc</artifactId>
        <version>1.0.0</version>
    </dependency>
    <dependency>
        <groupId>io.r2dbc</groupId>
        <artifactId>r2dbc-spi</artifactId>
        <version>1.0.0.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>io.r2dbc</groupId>
        <artifactId>r2dbc-mysql</artifactId>
        <version>0.8.1.RELEASE</version>
    </dependency>
</dependencies>

配置 MyBatis

创建 mybatis-config.xml 文件：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="io.r2dbc.spi.ConnectionFactory"/>
        <property name="url" value="r2dbc:mysql://localhost:3306/mydb"/>
        <property name="username" value="root"/>
        <property name="password" value="password"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="com/example/mapper/UserMapper.xml"/>
  </mappers>
</configuration>

编写 Mapper 接口和 XML

创建 UserMapper.java 接口：

package com.example.mapper;

import org.apache.ibatis.annotations.Select;
import reactor.core.publisher.Flux;
import com.example.model.User;

public interface UserMapper {
    @Select("SELECT * FROM users")
    Flux<User> findAll();
}

创建 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.example.mapper.UserMapper">
  <select id="findAll" resultType="com.example.model.User">
    SELECT * FROM users
  </select>
</mapper>

启动应用

编写启动类：

import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.ibatis.r2dbc.session.ReactiveSqlSessionFactory;
import org.apache.ibatis.r2dbc.session.DefaultReactiveSqlSessionFactory;
import com.example.mapper.UserMapper;

public class Main {
    public static void main(String[] args) {
        Configuration configuration = new SqlSessionFactoryBuilder().build(
            Main.class.getResourceAsStream("/mybatis-config.xml")
        );
        ReactiveSqlSessionFactory reactiveSqlSessionFactory = new DefaultReactiveSqlSessionFactory(configuration);
        UserMapper userMapper = reactiveSqlSessionFactory.openSession().getMapper

mybatis-r2dbc MyBatis R2DBC Adapter 项目地址: https://gitcode.com/gh_mirrors/my/mybatis-r2dbc