Jooq：如何将记录映射到具有相同列名的Pojo类中？

Question

我有两个表：TABLE_A和TABLE_B，它们有一些同名的列。

TABLE_A (ID, NAME, ADDRESS)<br>
TABLE_B (ID, NAME)

我想从这两个表中检索所有列，并使用Jooq将查询结果转换为Pojo类，如下所示：

List<MyPojo> result = query.select()
                         .from(TABLE_A)
                         .join(TABLE_B)
                         .on(TABLE_A.ID.equal(TABLE_B.ID))
                         .fetchInto(MyPojo.class);

我想使用@Column注释来指定哪个列来自哪个表，但Jooq似乎不支持这个特性。我如何实现这一点？

import javax.persistence.Column;

public class MyPojo {

    @Column(table = "TABLE_A", name = "ID")
    private String idA;

    @Column(table = "TABLE_A", name = "NAME")
    private String nameA;

    @Column(table = "TABLE_A", name = "ADDRESS")
    private String addressA;

    @Column(table = "TABLE_B", name = "ID")
    private String idB;

    @Column(table = "TABLE_B", name = "NAME")
    private String nameB;

}

或者这个，

import javax.persistence.Column;

public class MyPojo {

    @Column(name = "TABLE_A.ID")
    private String idA;

    @Column(name = "TABLE_A.NAME")
    private String nameA;

    @Column(name = "TABLE_A.ADDRESS")
    private String addressA;

    @Column(name = "TABLE_B.ID")
    private String idB;

    @Column(name = "TABLE_B.NAME")
    private String nameB;

}

Answer 1

你可以用这样的别名

query.select(
   concat(TABLE_A.NAME).as("Aname")
   ...)
  .from(TABLE_A)
  .join(TABLE_B).on(TABLE_A.ID.equal(TABLE_B.ID))
  .fetchInto(MyPojo.class);

并将Pojo与注释一起使用，如

 @Column(name = "Aname")
    private String table_A_name;