xUtils 关联对象查询

xUtils 关联对象查询

---

对象的创建

@Table(name = "tb_child")
public class Child {

    @Id
    private int id;

    @Column(column = "name")
    private String name;

    @Column(column = "age")
    private int age;

    @Foreign(column = "parentId", foreign = "id")
    private Parent parent;

    /*
     * 省略了toString()和get()、set()方法
     */
}

@Table(name = "tb_parent")
public class Parent {

    @Id
    private int id;

    @Column(column = "name")
    private String name;

    @Column(column = "age")
    private int age;

    @Finder(valueColumn = "id", targetColumn = "parentId")
    public FinderLazyLoader<Child> children;
    //@Finder(valueColumn = "id",targetColumn = "parentId")
    //public Child children;
    //@Finder(valueColumn = "id", targetColumn = "parentId")
    //private List<Child> children;

    /*
     * 省略了toString()和get()、set()方法
     */
}

关联对象的查询

DbUtils dbUtils = DbUtils.create(this);
Parent parent = dbUtils.findFirst(Selector.from(Parent.class).orderBy("id", true));

List<Child> children = parent.getChildren().getAllFromDb();