Spring Data R2DBC中接口投影DTO无法正常工作的问题

方法1：改用JPQL查询（推荐） #

将原生SQL查询改为基于实体类的JPQL语句，确保查询字段的别名与DTO接口的getter方法严格对应（别名规则：去掉get前缀并将首字母小写，比如getStudentName()对应studentName）。

假设你的实体类分别为Student、StudentTutor、Tutor，调整后的Repository代码如下：

@Query("""
        select
          s.name as studentName,
          t.name as tutorName,
          st.status as status,
          st.priority as priority
        from Student s
        join s.studentTutors st
        join st.tutor t
        where s.id = :idStudent
        """
)
Mono<StudentTutorDto> get(Long idStudent);

Spring Data会自动识别返回类型为接口投影，根据别名映射生成代理实例返回。

方法2：使用原生SQL并指定投影规则 #

若必须使用原生SQL，需按以下步骤调整：

1. 在@Query注解中添加nativeQuery = true标记
2. 确保查询的列别名与DTO接口的getter严格匹配
3. 若框架无法自动映射，可创建DTO接口的实现类，配合@SqlResultSetMapping完成映射

具体步骤示例： #

首先创建DTO接口的实现类：

public class StudentTutorDtoImpl implements StudentTutorDto {
    private final String studentName;
    private final String tutorName;
    private final String status;
    private final String priority;

    public StudentTutorDtoImpl(String studentName, String tutorName, String status, String priority) {
        this.studentName = studentName;
        this.tutorName = tutorName;
        this.status = status;
        this.priority = priority;
    }

    @Override
    public String getStudentName() { return studentName; }
    @Override
    public String getTutorName() { return tutorName; }
    @Override
    public String getStatus() { return status; }
    @Override
    public String getPriority() { return priority; }
}

然后在任意实体类（比如Student）上添加结果集映射配置：

@Entity
@SqlResultSetMapping(
    name = "StudentTutorDtoMapping",
    classes = @ConstructorResult(
        targetClass = StudentTutorDtoImpl.class,
        columns = {
            @ColumnResult(name = "studentName"),
            @ColumnResult(name = "tutorName"),
            @ColumnResult(name = "status"),
            @ColumnResult(name = "priority")
        }
    )
)
public class Student {
    // 实体类原有内容
}

最后修改Repository的查询注解，指定结果集映射：

@Query(
    value = """
            select
              s.name as studentName,
              t.name as tutorName,
              st.status as status,
              st.priority as priority
            from student s
            join student_tutor st on st.student_id = s.id
            join tutor t on t.id = st.tutor_id
            where s.id = :idStudent
            """,
    nativeQuery = true,
    resultSetMapping = "StudentTutorDtoMapping"
)
Mono<StudentTutorDto> get(Long idStudent);

方法3：检查仓库泛型与返回类型 #

确保StudentRepository继承的是ReactiveCrudRepository<StudentEntity, Long>（或对应Reactive仓库接口），同时方法返回类型明确为Mono<StudentTutorDto>，避免框架默认返回泛型指定的StudentEntity。

内容的提问来源于stack exchange，提问作者Andrii Torzhkov