// set up
Database database = new Database(getConnection());
Table<Inventory> inventoryTable = database.getTable(Inventory.class);

// execute
List<Inventory> results = inventoryTable.selectAllCustom(
        "where quantity between ? and ?", 1, 42);

// show results
for (Inventory inventory: results)
{
    System.out.println(inventory.getPartNumber() + 
    	" quantity=" + inventory.getQuantity());
}