How to use arrayadapter?

Question

I'm making an application that can search a table 'employee' and return results. How may I use an array adapter to do this? I'm new to android.

public class SimpleSearch extends Activity {
    /** Called when the activity is first created. */
    protected SQLiteDatabase db;
    Intent intent = getIntent();
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);

        // Get the intent, verify the action and get the query
        Intent intent = getIntent();
        if (Intent.ACTION_SEARCH.equals(intent.getAction())) {
          String query = intent.getStringExtra(SearchManager.QUERY);
          doMySearch(query);
        }
    }
    public List<String> doMySearch(String query) {
        List<String> result = new ArrayList<String>();

        Cursor c = db.query(
                "employee", 
                new String[] { "_id" }, // The column you want as a result of the Query
                "firstName like '%?%' OR lastName like '%?%' OR officePhone like '%?%'", // The where-Clause of the statement with placeholders (?)
                new String[] { query, query, query }, // One String for every Placeholder-? in the where-Clause
                );
        while (c.moveToNext()) {
            result.add(c.getString(0));
        }
        c.close();
        return result;
    }


}

You should use SimpleCursorAdapter instead! please check this:thinkandroid.wordpress.com/2010/01/09/… and groups.google.com/group/android-developers/browse_thread/thread/… — Hiral Vadodaria
– Hiral Vadodaria, Commented Nov 29, 2011 at 9:57

Malcolm · Accepted Answer · 2011-11-29 09:54:58Z

1

You don't have to use array adapter, use SimpleCursorAdapter instead. If you need an example on using it, you can have a look at the Notepad tutorial.

answered Nov 29, 2011 at 9:54

Malcolm

41.5k11 gold badges71 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rajdeep Dua · Accepted Answer · 2011-11-29 09:56:16Z

0

You should use the ListActivity or a ListFragment and Populate them using an CursorAdapter.(SimpleCursorAdapter) is an implementation class

CursorAdapter can be populated from the List returned by your doMySearchMethod.

answered Nov 29, 2011 at 9:56

Rajdeep Dua

11.2k2 gold badges34 silver badges22 bronze badges

1 Comment

Binoy Babu Over a year ago

something like this? public void doMySearch(String query) { cursor = db.rawQuery("SELECT _id, firstName, lastName, title FROM employee WHERE firstName || ' ' || lastName LIKE ?", new String[]{"%" + query.getText().toString() + "%"}); adapter = new SimpleCursorAdapter( this, R.layout.emp_list_item, cursor, new String[] {"firstName", "lastName", "title"}, new int[] {R.id.firstName, R.id.lastName, R.id.title}); setListAdapter(adapter); } }

Collectives™ on Stack Overflow

How to use arrayadapter?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related