Android development, Index-1 requested, with a size of XXX in sqlite

 

In android development, if we need to read data from a certain field in a table, we usually use a database cursor to traverse and read data from top to bottom, to ensure that the table is not empty, call the getCount method of cursor. If the value is not 0, the table is not empty, after determining whether the table is empty, developers can read data directly by field. An error similar to this will be reported during running:

Index-1 requested, with a size of XXX

The reason is that after the getCount method is called, The cursor will swim to the end of the table. You only need to call the moveToFirst method of cursor before the code for reading data by field, move the cursor to the first place of the table.