Android 数据库与MapView总结

核心提示：(tables[0], f, "", null, null, null, null);lstRestaurant = new ArrayList();allRestaurantID = new ArrayList();allRestaurantName = new ArrayList();allRe

(

tables[0], f, "", null, null, null, null

);

lstRestaurant = new ArrayList();

allRestaurantID = new ArrayList();

allRestaurantName = new ArrayList();

allRestaurantAddress = new ArrayList();

allRestaurantCal = new ArrayList();

while (c.moveToNext())

{

lstRestaurant.add

(

c.getString(1)+"("+c.getString(3)+

getResources().getText(R.string.str_cal)+")"

);

allRestaurantID.add(c.getString(0));

allRestaurantName.add(c.getString(1));

allRestaurantAddress.add(c.getString(2));

allRestaurantCal.add(c.getString(3));

}

if(lstRestaurant.size()>0)

{

ArrayAdapter adapter = new ArrayAdapter

(

EX10_06_03.this,

R.layout.simple_list_item_single_choice, lstRestaurant

);

mListView01.setItemsCanFocus(true);

mListView01.setChoiceMode(ListView.CHOICE_MODE_SINGLE);

mListView01.setAdapter(adapter);

}

else

{

/* 数据库无记录，将flag设置为-1 */

intItemSelected = -1;

ArrayAdapter adapter = new ArrayAdapter

(

EX10_06_03.this, R.layout.simple_list_item_single_choice,

lstRestaurant

);

mListView01.setItemsCanFocus(true);

mListView01.setChoiceMode(ListView.CHOICE_MODE_SINGLE);

mListView01.setAdapter(adapter);

}

}

@Override

public boolean onCreateOptionsMenu(Menu menu)

{

// TODO Auto-generated method stub

/* menu群组ID */

int idGroup1 = 0;

/* The order position of the item */

int orderItem1 = Menu.NONE;

int orderItem3 = Menu.NONE+2;

menu.add(idGroup1, MENU_ADD, orderItem1, R.string.str_manu1).