how to join two table?

[iobsessu]

now, i have a User object and a Role object , it look like this:

class User {
    private int id;
    private String username;
    private int roleId;
}
class Role {
    private int id;
    private String roleName;
}

i wanna know, how can i serialize it to

 {
    id: 10,
    name: "Jack",
    roleId: 20,
    roleName: "admin"
}

instead of

{
    id: 10,
    name: "Jack,
    role: {
        id: 20,
        roleName: "admin"
    }
}

[pengcao1]

• First, u should implement your raw sql code like below

• Second, u implement the multi-table join query with QueryBuilder

• First step

SELECT
	n.id ,
	n.title ,
	ti.tagName 
from
	TableN n
join TTableN twn on
	twn.note_id = n.id
join TTableI ti on
	ti.id = twn.tagInfo_id 
where ti.tagName ="customize1"  limit 1 offset 2;

• Second step

        QueryBuilder<TableN, Long> tableNQuery = DatabaseUtils.initialiseDaoWithLong(TableN.class).queryBuilder();
        QueryBuilder<TTableN , Long> ttableNQuery = DatabaseUtils.initialiseDaoWithLong(TTableN .class).queryBuilder();
        QueryBuilder<TTableI , Long> ttableIQuery = DatabaseUtils.initialiseDaoWithLong(TTableI .class).queryBuilder();
 
        ttableNQuery .join(ttableIQuery );

        tableNQuery .join(ttableNQuery );
        tableNQuery .distinct()
        .offset(Const.Note.PAGE_SIZE * (pageNo - 1)).limit(Const.Note.PAGE_SIZE)
        .orderBy("updateTime", false)
        .where().eq("inTrash", false)
        .and().eq("stuId", stuId)
        .query();

[j256]

The short answer is that you can't without a lot of customization. Unfortunately, ORMLite right now does not support composite objects like this.