2 回答

TA貢獻1815條經驗 獲得超10個贊
設置你的Adapter外部while loop
//get the data to the list view
if(result.getCount() == 0 ){
Toast.makeText(StockSearchActivity.this,"Databse is empty",Toast.LENGTH_LONG).show();
}else{
while (result.moveToNext()){
theList.add(result.getString(0));
theList.add(result.getString(1));
theList.add(result.getString(2));
theList.add(result.getString(3));
theList.add(result.getString(4));
}
ListAdapter listAdapter = new ArrayAdapter<>(this,android.R.layout.simple_expandable_list_item_1,theList);
listView.setAdapter(listAdapter);
}

TA貢獻1876條經驗 獲得超5個贊
你的問題在下一行
SQLiteDatabase db = this.getWritableDatabase();
當您嘗試從數據庫中獲取數據時,它應該以可讀模式打開,如下所示。
SQLiteDatabase db = this.getReadableDatabase();
添加回答
舉報