1. query
Query multiple records matching the condition and map them to a list of entities.
// Single condition
public <E> List<E> query(String table, Class<E> cls, Condition condition)
public <E> List<E> query(String table, Class<E> cls, Condition condition, List<? extends OrderField> orderBy)
// Multiple conditions
public <E> List<E> query(String table, Class<E> cls, List<Condition> conditions)
public <E> List<E> query(String table, Class<E> cls, List<Condition> conditions, List<? extends OrderField> orderBy)
// Using RecordMapper
public <R,E> List<E> query(String table, RecordMapper<R,E> mapper, Condition condition)
public <R,E> List<E> query(String table, RecordMapper<R,E> mapper, List<Condition> conditions)
Returns: List — list of entities, never null.
Example:
// Single condition
List<User> list = jt.query("user_table", User.class,
F("name").contains("John"));
// Multiple conditions + order
List<User> list = jt.query("user_table", User.class,
jt.conditions("name%", name, "birthday>=", beginDate),
Arrays.asList(F("birthday").desc(), F("name").asc()));
// Using RecordMapper
List<User> list = jt.query("user_table", new MyMapper(),
F("id").gt(0));
2. queryRecord
public Result<Record> queryRecord(String table, Condition condition)
public Result<Record> queryRecord(String table, List<Condition> conditions, List<? extends OrderField> orderBy)
public Result<Record> queryRecordv(String table, Object... conditions)
Example:
Result<Record> rs = jt.queryRecordv("user_table", "name%", "Jo");
for(Record r : rs) {
System.out.println(r.get("name"));
}
3. queryLowerCaseRecord
public List<LowerCaseRecord> queryLowerCaseRecord(String table, Condition condition)
public List<LowerCaseRecord> queryLowerCaseRecordv(String table, Object... conditions)
4. queryv (varargs conditions)
Query a list using varargs conditions. Combine conditions and ordering in a single line.
public <E> List<E> queryv(String table, Class<E> cls, Object... conditions)
public <E> List<E> queryv(TableLike table, Class<E> cls, Object... conditions)
Example:
// Fuzzy + range query
List<User> list = jt.queryv("user_table", User.class,
"name%", name, "birthday>=", beginDate, "birthday<=", endDate);
// Mixed ordering
List<User> list = jt.queryv("user_table", User.class,
"birthday:asc", F("name").asc().nullsLast());