android spinner第三方库,从sqlite数据库android填充spinner

这是一个古老的问题,但我在解决这个问题时发现的第一个问题。这里有一个详细的解释,充分的来源,可能会削减一些腿部工作。

答案确实是使用simpleCursorAdapter,它处理字符串列表,但也对选中行时返回的匹配ID字段进行特殊处理。使这项工作得以开展的关键是了解以下两个模糊信息:

1)创建光标时,确保查询返回一个名为“_id”的字段。此字段不需要显示在任何地方,但当选择列表项时,它的值将被传递回。

2)创建SimpleCursorAdapter时,需要提供将放置行文本的文本视图布局ID。如果使用Android提供的布局android.r.layout.simple_spinner_项,则需要使用的文本ID是android.r.id.text1。

MIN

android:orientation="vertical"

android:layout_width="fill_parent"

android:layout_height="fill_parent"

>

android:id="@+id/spinner1"

android:layout_width="fill_parent"

android:layout_height="wrap_content"

android:layout_alignParentTop="true"

>

活动代码:

public class TesterActivity extends Activity {

public Context mContext;

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

// just for this example:

// create database table with an id field and a text field and add some data

class MyDBHelper extends SQLiteOpenHelper {

public MyDBHelper(Context context) {

super(context, "someDB", null, 2);

}

@Override

public void onCreate(SQLiteDatabase db) {

db.execSQL("CREATE TABLE someTable (someIDF INTEGER, someTextF TEXT)");

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

db.execSQL("DROP TABLE IF EXISTS someTable");

onCreate(db);

db.execSQL("INSERT INTO someTable (someIDF, someTextF) VALUES (54, 'Some text')");

db.execSQL("INSERT INTO someTable (someIDF, someTextF) VALUES (99, 'Some more text')");

db.execSQL("INSERT INTO someTable (someIDF, someTextF) VALUES (173, 'Even more text')");

}

}

SQLiteDatabase db = new MyDBHelper(this).getWritableDatabase();

// get a cursor from the database with an "_id" field

Cursor c = db.rawQuery("SELECT someIDF AS _id, someTextF FROM someTable", null);

// make an adapter from the cursor

String[] from = new String[] {"someTextF"};

int[] to = new int[] {android.R.id.text1};

SimpleCursorAdapter sca = new SimpleCursorAdapter(this, android.R.layout.simple_spinner_item, c, from, to);

// set layout for activated adapter

sca.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

// get xml file spinner and set adapter

Spinner spin = (Spinner) this.findViewById(R.id.spinner1);

spin.setAdapter(sca);

// set spinner listener to display the selected item id

mContext = this;

spin.setOnItemSelectedListener(new OnItemSelectedListener() {

public void onItemSelected(AdapterView> parent, View view, int position, long id){

Toast.makeText(mContext, "Selected ID=" + id, Toast.LENGTH_LONG).show();

}

public void onNothingSelected(AdapterView> parent) {}

});

}

}