如何在 MyBatis 中使用带有 @Many 注释的 UUID 类型处理程序?

问题描述

我使用的是 2.1.0 版本的 mybatis-spring-boot-starter.我需要处理 UUID 类型以获取嵌套集合.

I`m using mybatis-spring-boot-starter with 2.1.0 version. And I need to process UUID type to get a nested collection.

 @Select("SELECT id, name FROM t_service s")
    @Results(value = {
            @Result(column = "id", property = "id", jdbcType = JdbcType.OTHER, typeHandler = UuidTypeHandler.class),
            @Result(column = "name", property = "name"),
            @Result(property = "rates", column = "id", javaType = List.class, many = @Many(select = "getAllRates"))
    })
    List<Service> findAll();

 @Select("SELECT date_from, date_to, currency FROM t_rate where t_rate.service_id = #{serviceId, javaType=java.util.UUID, jdbcType=OTHER, typeHandler=my.package.UuidTypeHandler}")
    @Results(value = {
            @Result(property = "dateFrom", column = "date_from"),
            @Result(property = "dateTo", column = "date_to"),
            @Result(property = "currency", column = "currency")
 })
    List<Rate> getAllRates(@Param("serviceId") UUID serviceId);

UuidTypeHandler:

UuidTypeHandler:

@MappedJdbcTypes(JdbcType.OTHER)
@MappedTypes(UUID.class)
public class UuidTypeHandler extends BaseTypeHandler<UUID> {
    @Override
    public void setNonNullParameter(PreparedStatement ps, int i, UUID parameter, JdbcType jdbcType) throws SQLException {
        ps.setObject(i, parameter, jdbcType.TYPE_CODE);
    }

    @Override
    public UUID getNullableResult(ResultSet rs, String columnName) throws SQLException {
        return rs.getObject(columnName, UUID.class);
    }

    @Override
    public UUID getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
        return rs.getObject(columnIndex, UUID.class);
    }

    @Override
    public UUID getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
        return cs.getObject(columnIndex, UUID.class);
    }
}

但我得到以下异常:

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'serviceId' in 'class java.util.UUID'

在其他情况下(直接调用方法时)UuidTypeHandler 工作正常，我没有任何问题

In other situations (when call methods directly) UuidTypeHandler works correctly and I don`t have any problems

PostgreSQL 的解决方法:

 @Select("SELECT date_from, date_to, currency FROM t_rate where t_rate.service_id = #{serviceId}::uuid")
    @Results(value = {
            @Result(property = "dateFrom", column = "date_from"),
            @Result(property = "dateTo", column = "date_to"),
            @Result(property = "currency", column = "currency")
 })
    List<Rate> getAllRates(@Param("serviceId") String serviceId);

推荐答案

要使其工作，您需要在配置中全局注册类型处理程序(这是一种限制).
在您的情况下，将 mybatis.type-handlers-package=my.package 添加到 application.properties 就足够了.

To make it work, you need to register the type handler globally in the config (it's a kind of limitation).
In your case, adding mybatis.type-handlers-package=my.package to application.properties would be sufficient.

在全局注册类型处理程序后，大多数情况下您可以在映射器中省略 typeHandler.

Once the type handler is registered globally, you can omit typeHandler in your mappers in most cases.

@Select("SELECT id, name FROM t_service s")
@Results(value = {
  @Result(column = "id", property = "id"),
  @Result(column = "name", property = "name"),
  @Result(property = "rates", column = "id",
    javaType = List.class, many = @Many(select = "getAllRates"))
})
List<Service> findAll();

@Select("SELECT date_from, date_to, currency FROM t_rate where t_rate.service_id = #{serviceId}")
@Results(value = {
  @Result(property = "dateFrom", column = "date_from"),
  @Result(property = "dateTo", column = "date_to"),
  @Result(property = "currency", column = "currency")
})
List<Rate> getAllRates(@Param("serviceId") UUID serviceId);

类型处理程序也可以更简单一些.

The type handler also can be a little bit simpler.

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.UUID;

import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.MappedTypes;

// no @MappedJdbcTypes
@MappedTypes(UUID.class)
public class UuidTypeHandler extends BaseTypeHandler<UUID> {
  @Override
  public void setNonNullParameter(PreparedStatement ps, int i, UUID parameter, JdbcType jdbcType) throws SQLException {
    ps.setObject(i, parameter); // no 3rd arg
  }

  @Override
  public UUID getNullableResult(ResultSet rs, String columnName) throws SQLException {
    return rs.getObject(columnName, UUID.class);
  }

  @Override
  public UUID getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
    return rs.getObject(columnIndex, UUID.class);
  }

  @Override
  public UUID getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
    return cs.getObject(columnIndex, UUID.class);
  }
}

这篇关于如何在 MyBatis 中使用带有 @Many 注释的 UUID 类型处理程序?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！