用这个语句查询表中的记录:(title中的字段是加过单引号的)
result = mDb.query(TABLE_dict, new String[]{KEY_ROWID, KEY_TITLE, KEY_BODY, KEY_IFNEW}, KEY_TITLE + "=" + title, null, null, null, null, null);
然后
String body = result.getString(result.getColumnIndex(DbAdapter.KEY_BODY));
会报错:
android.database.CursorIndexOutOfBoundsException: Index -1 requested, with a size of 1
可以输出:cursor.getCount()结果为1,cursor.getColumnCount()结果为4
(查询的那条记录表中肯定存在)
求大牛帮忙解答!!
result = mDb.query(TABLE_dict, new String[]{KEY_ROWID, KEY_TITLE, KEY_BODY, KEY_IFNEW}, KEY_TITLE + "=" + title, null, null, null, null, null);
然后
String body = result.getString(result.getColumnIndex(DbAdapter.KEY_BODY));
会报错:
android.database.CursorIndexOutOfBoundsException: Index -1 requested, with a size of 1
可以输出:cursor.getCount()结果为1,cursor.getColumnCount()结果为4
(查询的那条记录表中肯定存在)
求大牛帮忙解答!!
if(result.getCount()>0)
{
result.moveToFirst();
String body = result.getString(result.getColumnIndex(DbAdapter.KEY_BODY));
}