Android 数据库问题出现问题,求助大佬们!

我的数据是从另一个activity intent过来的。

Intent intent = getIntent();
String inputName = intent.getStringExtra("content");
String inputScore = intent.getStringExtra("timeSpent");

SQLiteDatabase db = myOpenHelper.getWritableDatabase();

ContentValues values = new ContentValues();
//Retrieve the intent

values.put("name", inputName);
int intScore = Integer.parseInt(inputScore);
values.put("score", intScore);

db.insert(CustomOpenHelper.TABLE_NAME, null, values);

displayDataInTable();

——————————————————————————————
List<String> queryTable(){
List<String> player = new ArrayList<String>();

SQLiteDatabase sqLiteDatabase = myOpenHelper.getReadableDatabase();
Cursor cursor = sqLiteDatabase.query(CustomOpenHelper.TABLE_NAME,null,null,null,null,null,null);

while (cursor.moveToNext()){
String name = cursor.getString(cursor.getColumnIndex("name"));
int score = cursor.getInt(cursor.getColumnIndex("score"));
player.add(" --> the player " + name + " has got a score of " +score);
}
return player;
}

天涯尽头无女友
浏览 191回答 1
1回答

holdtom

Debug 看下这一行执行后,cursor 的值Cursor cursor = sqLiteDatabase.query(CustomOpenHelper.TABLE_NAME,null,null,null,null,null,null);
打开App,查看更多内容
随时随地看视频慕课网APP