MyBatis是否支持映射到枚举类？如何实现？

public enum UserStatus {
    ACTIVE("active"),
    INACTIVE("inactive");

    private String value;

    UserStatus(String value) {
        this.value = value;
    }

    public String getValue() {
        return value;
    }

    public static UserStatus fromValue(String value) {
        for (UserStatus status : UserStatus.values()) {
            if (status.getValue().equals(value)) {
                return status;
            }
        }
        return null; // 或者抛出异常，视具体需求而定
    }
}

public class User {
    private Integer id;
    private String username;
    private UserStatus status; // 枚举类型

    // getter 和 setter
}

<resultMap id="userResultMap" type="User">
    <result property="id" column="id"/>
    <result property="username" column="username"/>
    <result property="status" column="status"/>
</resultMap>

<select id="findUserById" resultMap="userResultMap">
    SELECT id, username, status FROM user WHERE id = #{id}
</select>

@MappedTypes(UserStatus.class)  // 标明该 TypeHandler 处理的枚举类型
public class UserStatusTypeHandler extends BaseTypeHandler<UserStatus> {

    @Override
    public void setNonNullParameter(PreparedStatement ps, int i, UserStatus parameter, JdbcType jdbcType) throws SQLException {
        ps.setInt(i, parameter.ordinal()); // 将枚举的索引值存储到数据库中
    }

    @Override
    public UserStatus getNullableResult(ResultSet rs, String columnName) throws SQLException {
        int status = rs.getInt(columnName);
        return UserStatus.values()[status]; // 将数据库中的整数值转换为枚举
    }

    @Override
    public UserStatus getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
        int status = rs.getInt(columnIndex);
        return UserStatus.values()[status]; // 将数据库中的整数值转换为枚举
    }

    @Override
    public UserStatus getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
        int status = cs.getInt(columnIndex);
        return UserStatus.values()[status]; // 将数据库中的整数值转换为枚举
    }
}

<typeHandlers>
    <typeHandler handler="com.example.UserStatusTypeHandler"/>
</typeHandlers>

<resultMap id="userResultMap" type="User">
    <result property="id" column="id"/>
    <result property="username" column="username"/>
    <result property="status" column="status" typeHandler="com.example.UserStatusTypeHandler"/>
</resultMap>

public enum UserStatus {
    ACTIVE("active"),
    INACTIVE("inactive");

    @EnumValue
    private String value;

    UserStatus(String value) {
        this.value = value;
    }

    public String getValue() {
        return value;
    }
}

@Mapper
public interface UserMapper {
    @Select("SELECT id, username, status FROM user WHERE id = #{id}")
    User findUserById(@Param("id") int id);
}