java - 如何从 Spinner 获取客户 ID

Question

这是我从数据库中为微调器调用客户名称的函数。当我选择客户名称时，我还可以获得客户 ID。怎么做？

 public List<String> getAllUsers(String userID) {
    List<String> userlist = new ArrayList<>();
    String status= "Active";
    SQLiteDatabase db = this.getReadableDatabase();
    String query = "select " + COLUMN_Customer_NAME + " from customer where " + COLUMN_Customer_USERID + "='" + userID + "'"+" AND " + COLUMN_Customer_STATUS + "='" + status + "'";
    Cursor cursor = db.rawQuery(query, null);
    if (cursor.moveToFirst()) {
        do {
            userlist.add(cursor.getString(0));
        } while (cursor.moveToNext());
    }
    cursor.close();
    db.close();
    return userlist;

}

Answer 1

spinner_province.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
        @Override
        public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
            String item = parent.getItemAtPosition(position).toString();
            province_id = position;
        }

        @Override
        public void onNothingSelected(AdapterView<?> parent) {

        }
    });

通过使用它，您可以从微调器中获取选定的项目。