Android Spinner 所选项目

Question

我正在从数据库中填充这样的微调器

    // Populating the City Spinner
    Cursor cities = db.cityList();
    startManagingCursor(cities);

    // create an array to specify which fields we want to display
    String[] from = new String[] { DBAdapter.KEY_NAME };
    // create an array of the display item we want to bind our data to
    int[] to = new int[] { android.R.id.text1 };

    Spinner cityList = (Spinner) this.findViewById(R.id.citySpiner);
    SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, android.R.layout.simple_spinner_item, cities, from, to);
    adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
    cityList.setAdapter(adapter);

当我尝试从这样的微调器的选定项目中获取内容时，

// Get the City
                Spinner getCity = (Spinner) findViewById(R.id.citySpiner);
                String cityName = getCity.getSelectedItem().toString();

我得到以下内容。 有没有办法可以从数据库中获取城市名称或城市 ID。

Answer 1

我认为，当您使用自定义适配器并在适配器中给出三个列表时...

您无法仅通过调用 getSelectedItem() 来获取所选文本...

使用这个：

Spinner mySpinner = (Spinner)findViewbyId(R.id.spinner);
int position = mySpinner.getSelectedItemPosition();
String Text = yourCityList[position].toString(); // dont know which list is holding the city list... 
// i didn't use any db in any of my app so cant tell you how can you get list... 
// leaving it to you... :)

希望它有帮助...

Answer 2

只需从微调器中获取适配器并从光标中获取字符串

Cursor cursor = (Cursor) myAdapter.getItem(position);
String cityName = cursor.getString(cursor.getColumnIndex(DBAdapter.KEY_NAME));

Answer 3

    List<String> list = new ArrayList<String>();
    s = (Spinner)findViewById(R.id.spinner1);
    SQLiteDatabase sqldb = db.openDataBase();
    Cursor cr = sqldb.rawQuery("select Name from employee",null);
    if (cr.moveToFirst()) {
        do {
        list.add(cr.getString(0).toString());
        Toast.makeText(this,cr.getString(0).toString(),Toast.LENGTH_LONG).show();
        ArrayAdapter <String> a= new ArrayAdapter(this, android.R.layout.simple_spinner_item,list);
         a.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
          s.setAdapter(a);
        } while (cr.moveToNext());

      }//urvesh patel

Answer 4

我实现它的方式是这样的：

您必须将 getItem() 方法转换为游标，因为它本质上只是返回游标而不是游标中的单个行，这很烦人。

final Cursor cursor = (Cursor) yourSpinner.getAdapter().getItem( position );

将光标移动到第一行

cursor.moveToFirst();

现在，您可以使用与设置旋转器适配器时最初查询的表相匹配的列名从光标获取字符串，该适配器是使用 getAdapter() 在上面抓取的，

final String selectedPartUUID = cursor.getString( cursor.getColumnIndex( TABLE_COLUMN_NAME ) );

希望这有帮助，并感谢任何反馈:)

Answer 5

希望这有帮助！

Toast.makeText(getApplicationContext(), "getSelectedItem=" + spinnerString, Toast.LENGTH_SHORT).show();
            Toast.makeText(getApplicationContext(), "getSelectedItemPosition=" + nPos, Toast.LENGTH_SHORT).show();

Answer 6

 public List<String> GetTexts() {
            ArrayList<String> texts = new ArrayList<String>();
            for (int i = 0; i < mSpinnerList.size(); i ++) {
                int position = mSpinnerList.get(i).getSelectedItemPosition();
                Log.d("DATA_TO_BE_SEND:", tennisModelArrayList.get(position).getStatus());
                texts.add(mSpinnerList.get(i).getItemAtPosition(i).toString());
            }

            return texts;
        }