android textview adapter,Android Autocomplete textview and Cursoradapter

问题

Hi

i need to create an autocompletetextview in which suggestion should be a combination of Contact name and organization name ,am using 2.1 os. i can display the contact name ,but orgnization name not, how can i do this.

public class myactivity extends Activity {

/** Called when the activity is first created. */

public static EditText ed;

private String id;

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

AutoCompleteTextView act=(AutoCompleteTextView)findViewById(R.id.AutoCompleteTextView01);

ed=(EditText)findViewById(R.id.EditText01);

ContentResolver content = getContentResolver();

Cursor cursor = content.query(ContactsContract.Contacts.CONTENT_URI,PEOPLE_PROJECTION, null, null, null);

ContactListAdapter adapter = new ContactListAdapter(this, cursor);

act.setThreshold(0);

act.setAdapter(adapter);

}

public static final String[] PEOPLE_PROJECTION = new String[] {

ContactsContract.Contacts._ID,

Contacts.DISPLAY_NAME,

ContactsContract.Contacts.HAS_PHONE_NUMBER

};

}

class ContactListAdapter extends CursorAdapter implements Filterable {

private ContentResolver mCR;

public ContactListAdapter(Context context, Cursor c) {

super(context, c);

mCR = context.getContentResolver();

}

@Override

public void bindView(View view, Context context, Cursor cursor) {

((TextView) view).setText(cursor.getString(1));

}

@Override

public View newView(Context context, Cursor cursor, ViewGroup parent) {

final LayoutInflater inflater = LayoutInflater.from(context);

final TextView view = (TextView) inflater.inflate( android.R.layout.simple_dropdown_item_1line, parent, false);

view.setText(cursor.getString(1));

return view;

}

@Override

public String convertToString(Cursor cursor) {

return cursor.getString(1);

}

public Cursor runQueryOnBackgroundThread(CharSequence constraint) {

if (getFilterQueryProvider() != null) {

return getFilterQueryProvider().runQuery(constraint);

}

StringBuilder buffer = null;

String[] args = null;

if (constraint != null) {

buffer = new StringBuilder();

buffer.append("UPPER(");

buffer.append(Contacts.DISPLAY_NAME);

buffer.append(") GLOB ?");

args = new String[] { constraint.toString().toUpperCase() + "*" };

}

return mCR.query(ContactsContract.Contacts.CONTENT_URI,myactivity.PEOPLE_PROJECTION , buffer == null ? null : buffer.toString(), args,

Contacts.DISPLAY_NAME);

}

}

回答1:

To retrieve the Organization name you should search the Data table in the following way:

private static final String ORGANIZATION_PROJECTION = new String[] {

ContactsContract.CommonDataKinds.Organization.COMPANY

}

public String getOrganizationForContact ( int contact_id ) {

Cursor c;

String org = null;

c = getContentResolver().query ( ContactsContract.Data.CONTENT_URI,

ORGANIZATION_PROJECTION,

ContactsContract.Data.MIMETYPE + "=? AND " + ContactsContract.Data.CONTACT_ID + " =?",

new String[] { ContactsContract.CommonDataKinds.Organization.CONTENT_ITEM_TYPE, "" + contact_id },

null

);

if ( c != null && c.moveToFirst() ) {

org = c.getString ( 0 );

}

c.close();

return org;

}

PS: I haven't tried this code, but a very similar one. I hope this will work too, or at least that it helps

来源：https://stackoverflow.com/questions/4758107/android-autocomplete-textview-and-cursoradapter