public List<City> loadCites(int provinceId) { List<City> list = new ArrayList<>(); Cursor cursor = db.query( "City", null, "province_id = ?", new String[] {String.valueOf(provinceId)}, null, null, null); if (cursor.moveToFirst()) { do { City city = new City(); city.setId(cursor.getInt(cursor.getColumnIndex("id"))); city.setCityName(cursor.getString(cursor.getColumnIndex("city_name"))); city.setCityCode(cursor.getString(cursor.getColumnIndex("city_code"))); city.setProvinceId(cursor.getInt(cursor.getColumnIndex("province_id"))); list.add(city); } while (cursor.moveToNext()); } return list; }