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);
  }
  @Override
  protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    // 对广告信息初始化
    AdManager.init(getApplicationContext(), "120511ceb41405ad", "7f2e4c0300e37e06", 30, true);
    setContentView(R.layout.need_show_wethinfo_city_listview);
    // 导入已有的数据库
    dbManager = new DatabaseManager(getApplicationContext());
    db = dbManager.importDatabase();
    dbManager.closeDB(db);

    dcity = this;

    addCity = (Button) findViewById(R.id.addcity);
    finishCity = (Button) findViewById(R.id.finishcity);

    listView = (ListView) findViewById(R.id.storecitylist);

    showCityList();
    addCity.setOnClickListener(new AddCityButtonClickListener());
    finishCity.setOnClickListener(new FinishCityButtonClickListener());
  }