public void showCityList() {
if (!dbManager.isTableExists("storecity.db", "storecity")) {
dbManager.execSQL(
"storecity.db",
"create table storecity(_id integer primary key autoincrement,city varchar(20))");
}
// 获取城市列表，显示到listview中
Cursor cursor = dbManager.openQuery("storecity.db", "select _id,city from storecity");
List<HashMap<String, Object>> list = new ArrayList<HashMap<String, Object>>();
while (cursor.moveToNext()) {
HashMap<String, Object> hash = new HashMap<String, Object>();
String cityName = cursor.getString(cursor.getColumnIndex("city"));
hash.put("cityname", cityName);
hash.put("btn1", "");
hash.put("delbtn", "删除");
list.add(hash);
}
CityListItemSimpleAdapter listadapter =
new CityListItemSimpleAdapter(
NeedShowWethInfoCityListActivity.this,
list,
R.layout.need_show_wethinfo_city_listview_item,
new String[] {"cityname", "btn1", "delbtn"},
new int[] {R.id.storeListview, R.id.button1, R.id.delbutton, R.id.imageview1});
listView.setAdapter(listadapter);
}
