@DatabaseTable(tableName = "users") public class User { @DatabaseField(columnName = "id", generatedId = true) private int id; @DatabaseField(columnName = "name") private String name; @DatabaseField(columnName = "age") private int age; } Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class); QueryBuilder<User, Integer> queryBuilder = userDao.queryBuilder(); queryBuilder.where().eq("name", "John").and().gt("age", 18); List<User> users = userDao.query(queryBuilder.prepare());