Android Open Source - MyWeather My Weather D B

• Back to Weather/application  ↑

From Project

Back to project page MyWeather.

License

The source code is released under:

Apache License

Java Source Code

package db;
// www  .  j a v a 2  s  .  co m
import java.util.ArrayList;
import java.util.List;

import model.City;
import model.County;
import model.Province;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class MyWeatherDB {
  /**
   *  Database Name
   */
  public static final String DB_NAME = "my_weather";
  
  /**
   *  Database Version
   */
  public static final int VERSION = 1;
  private static MyWeatherDB myWeatherDB;
  private SQLiteDatabase db;
  
  /**
   * Private Constructor
   * @param context
   */
  private MyWeatherDB(Context context){
    MyWeatherOpenHelper dbHelper = new MyWeatherOpenHelper(context, DB_NAME, null, VERSION);
    db = dbHelper.getWritableDatabase();
  }
  
  /**
   * Singleton
   * @param context
   * @return
   */
  public synchronized static MyWeatherDB getInstance(Context context){
    if(myWeatherDB == null){
      myWeatherDB = new MyWeatherDB(context);
    }
    return myWeatherDB;
  }
  
  /**
   * insert Province
   * @param province
   */
  public void saveProvince(Province province){
    if(province != null){
      ContentValues values = new ContentValues();
      values.put("province_name", province.getProvinceName());
      values.put("province_code", province.getProvinceCode());
      db.insert("Province", null, values);
    }
  }
  
  /**
   * query Province
   * @return
   */
  public List<Province> loadProvinces(){
    List<Province> list = new ArrayList<Province>();
    Cursor cursor = db.query("Province", null, null, null, null, null, null);
    if(cursor.moveToFirst()){
      do{
        Province province = new Province();
        province.setId(cursor.getInt(cursor.getColumnIndex("id")));
        province.setProvinceName(cursor.getString(cursor.getColumnIndex("province_name")));
        province.setProvinceCode(cursor.getString(cursor.getColumnIndex("province_code")));
        list.add(province);
      } while(cursor.moveToNext());
    }
    return list;
  }
  
  /**
   * insert City
   * @param city
   */
  public void saveCity(City city){
    if(city != null){
      ContentValues values = new ContentValues();
      values.put("city_name", city.getCityName());
      values.put("city_code", city.getCityCode());
      values.put("province_id", city.getProvinceId());
      db.insert("City", null, values);
    }
  }
  
  /**
   * query City
   * @param provinceId
   * @return
   */
  public List<City> loadCities(int provinceId){
    List<City> list = new ArrayList<City>();
    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(provinceId);
        list.add(city);
      } while(cursor.moveToNext());
    }
    return list;
  }
  
  /**
   * insert County
   * @param county
   */
  public void saveCounty(County county){
    if(county != null){
      ContentValues values = new ContentValues();
      values.put("county_name", county.getCountyName());
      values.put("county_code", county.getCountyCode());
      values.put("city_id", county.getCityId());
      db.insert("County", null, values);
    }
  }
  
  /**
   * query County
   * @param cityId
   * @return
   */
  public List<County> loadCounties(int cityId){
    List<County> list = new ArrayList<County>();
    Cursor cursor = db.query("County", null, "city_id = ?", new String[]{String.valueOf(cityId)}, null, null, null);
    if(cursor.moveToFirst()){
      do{
        County county = new County();
        county.setId(cursor.getInt(cursor.getColumnIndex("id")));
        county.setCountyName(cursor.getString(cursor.getColumnIndex("county_name")));
        county.setCountyCode(cursor.getString(cursor.getColumnIndex("county_code")));
        county.setCityId(cityId);
        list.add(county);
      } while(cursor.moveToNext());
    }
    return list;
  }
}

Java Source Code List

• Back to Weather/application  ↑