android - 主动android选择查询

Question

new Select("id")
.From(customer)
.where("lastName=?","John")
.execute();

Error

 E/CursorWindow: Failed to read row 0, column -1 from a CursorWindow which has 1 rows, 1 columns.

Main query (select id from customer where lastName="John";)

Answer 1

尝试

List<Customer> results = new Select().from(Customer.class).where("lastName=?","John").execute();

if(results.size() > 0) {
    long id = results.get(0).getId(); 
}