2010-09-30 19:10:35 |
Timo Westkämper |
description |
Provides by Luis Fernando Planella Gonzalez :
QPerson p = QPerson.person;
QDepartment d = QDepartment.department;
SQLQuery query =DB.from(p).innerJoin(p.departmentIdFk, d).orderBy(d.name.asc(), p.name.asc());
List<Beans> rows = query.list(new QBeans(p, d));
for (Beans beans : rows) {
Person person = beans.get(p);
Department department = beans.get(d);
System.out.println(department.getName() + ", " + person.getName());
} |
Provided by Luis Fernando Planella Gonzalez :
QPerson p = QPerson.person;
QDepartment d = QDepartment.department;
SQLQuery query =DB.from(p).innerJoin(p.departmentIdFk, d).orderBy(d.name.asc(), p.name.asc());
List<Beans> rows = query.list(new QBeans(p, d));
for (Beans beans : rows) {
Person person = beans.get(p);
Department department = beans.get(d);
System.out.println(department.getName() + ", " + person.getName());
}
|
|