要从SQL数据库中显示当前值,你可以按照以下步骤进行操作:
Spinner spinner = findViewById(R.id.spinner);
ArrayAdapter adapter = new ArrayAdapter<>(this, android.R.layout.simple_spinner_dropdown_item);
spinner.setAdapter(adapter);
// 假设你已经有一个SQLiteOpenHelper对象 dbHelper 和一个 SQLiteDatabase 对象 db
String[] projection = {COLUMN_NAME};
Cursor cursor = db.query(TABLE_NAME, projection, null, null, null, null, null);
if (cursor.moveToFirst()) {
do {
String value = cursor.getString(cursor.getColumnIndexOrThrow(COLUMN_NAME));
adapter.add(value);
} while (cursor.moveToNext());
}
cursor.close();
// 假设你从数据库中获取了一个默认值 defaultSelection
int defaultIndex = adapter.getPosition(defaultSelection);
spinner.setSelection(defaultIndex);
这样,Spinner就会从SQL数据库中显示当前值了。