import
android.database.Cursor;
import
android.database.sqlite.SQLiteDatabase;
import
android.os.Bundle;
import
android.widget.CursorAdapter;
import
android.widget.ListView;
import
android.widget.SimpleCursorAdapter;
import
androidx.appcompat.app.AppCompatActivity;
public
class
Main2Activity
extends
AppCompatActivity {
ListView listView;
@Override
protected
void
onCreate(Bundle savedInstanceState) {
super
.onCreate(savedInstanceState);
setContentView(R.layout.activity_main2);
listView =findViewById(R.id.listview);
DBHelper helper =
new
DBHelper(
this
);
SQLiteDatabase db = helper.getReadableDatabase();
Cursor cursor = db.rawQuery(
"SELECT tId, title, content FROM testTBL"
,
null
);
CursorAdapter adapter =
new
SimpleCursorAdapter(
this
,
android.R.layout.simple_list_item_2,
cursor,
new
String[] {
"tId"
,
"title"
},
new
int
[] {android.R.id.text1, android.R.id.text2},
CursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER);
listView.setAdapter(adapter);
}
}