webflux+r2dbc基本配置与操作

星猩索魂

已于 2024-04-05 14:50:56 修改

阅读量229

点赞数 4

文章标签： java

于 2024-04-05 14:46:59 首次发布

本文链接：https://blog.csdn.net/xingxingsuohun/article/details/137400561

版权

本文介绍了如何在SpringBoot项目中使用R2DBC进行数据库操作，包括Maven依赖管理、application.yml配置、R2dbcConfig类的创建以及Repository和Controller的使用实例。

摘要由CSDN通过智能技术生成

代码架构图

在这里插入图片描述

引入依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.2.RELEASE</version> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.swust</groupId>
    <artifactId>r2dbc-demo</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-webflux</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-r2dbc</artifactId>
        </dependency>
        <dependency>
            <groupId>io.r2dbc</groupId>
            <artifactId>r2dbc-pool</artifactId>
        </dependency>
        <dependency>
            <groupId>dev.miku</groupId>
            <artifactId>r2dbc-mysql</artifactId>
        </dependency>


        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.32</version>
            <scope>provided</scope>
        </dependency>

    </dependencies>

</project>

application.yml配置

server:
  port: 8081

spring:
  r2dbc:
    name: r2dbc
    url: r2dbc:mysql://localhost:3306/r2dbc
    username: root
    password: root
    pool:
      enabled: true
      validation-query: SELECT 1

logging:
  level:
    org.springframework.r2dbc: debug

创建r2dbc客户端

@EnableR2dbcRepositories
@Configuration
public class R2dbcConfig {
    @Bean
    public R2dbcEntityTemplate r2dbcEntityTemplate(DatabaseClient databaseClient) {
        return new R2dbcEntityTemplate(databaseClient);
    }
}

操作数据库

@Repository
public interface UserInfoDao extends ReactiveCrudRepository<UserInfo, Long> {

    @Query("SELECT * FROM t_user_info WHERE id = :id and name = :name limit 1")
    Mono<UserInfo> findDateByIdAndName(Long id, String name);
}

使用

@RestController
public class UserInfoController {
    @Autowired
    UserInfoDao userInfoDao;

    @GetMapping("/getUserInfo")
    public Mono<UserInfo> getUserInfo() {
        return userInfoDao.findById(1L);
    }
}