内部属性不会在JOOQ中自动转换

// 假设有一个包含嵌套对象的Java类
public class User {
    private String name;
    private Address address;

    // getters and setters
}

public class Address {
    private String city;
    private String street;

    // getters and setters
}

// 在JOOQ查询中手动处理嵌套属性
Result<Record> result = dsl.select()
                            .from(USERS)
                            .join(ADDRESSES).on(USERS.ADDRESS_ID.eq(ADDRESSES.ID))
                            .fetch();

List<User> users = result.map(record -> {
    User user = new User();
    user.setName(record.get(USERS.NAME));
    Address address = new Address();
    address.setCity(record.get(ADDRESSES.CITY));
    address.setStreet(record.get(ADDRESSES.STREET));
    user.setAddress(address);
    return user;
});

public class AddressConverter implements Converter<String, Address> {

    @Override
    public Address from(String databaseObject) {
        // 解析数据库中的字符串并转换为Address对象
        String[] parts = databaseObject.split(",");
        Address address = new Address();
        address.setCity(parts[0]);
        address.setStreet(parts[1]);
        return address;
    }

    @Override
    public String to(Address userObject) {
        // 将Address对象转换为数据库中的字符串
        return userObject.getCity() + "," + userObject.getStreet();
    }

    @Override
    public Class<Address> fromType() {
        return Address.class;
    }

    @Override
    public Class<String> toType() {
        return String.class;
    }
}

// 在生成的表类中使用自定义转换器
public final TableField<UserRecord, Address> ADDRESS = createField(DSL.name("address"), SQLDialect.DEFAULT, Address.class, new AddressConverter());