Android Open Source - Weather D B Helper

• Back to Weather/application  ↑

From Project

Back to project page Weather.

License

The source code is released under:

GNU General Public License

Java Source Code

package com.imlongluo.weather.db;
//from w ww  . ja v a  2s.  c o m
import java.util.ArrayList;
import java.util.List;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * 
 * @author longluo 
 * ?????????????????
 */
public class DBHelper extends SQLiteOpenHelper {

  /**
   * ??????????????
   * @param context ????????????
   * @param dataname ????????
   */
  public DBHelper(Context context, String dataname){
    super(context, dataname, null, 2);
  }
  
  @Override
  public void onCreate(SQLiteDatabase db) {
    
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    
  }
  
  /**
   * ????????????????????String????
   * @return ?????????????
   */
  public String[] getAllProvinces() {
    String[] columns={"name"};
    
    SQLiteDatabase db = getReadableDatabase();
    //??????
    Cursor cursor = db.query("provinces", columns, null, null, null, null, null);
    columns = null;
    int count= cursor.getCount();
    String[] provinces = new String[count];
    count=0;
    while(!cursor.isLast()) {
      cursor.moveToNext();
      provinces[count] = cursor.getString(0);
      count=count+1;
    }
    cursor.close();
    db.close();
    return provinces;
  }
  
  /**
   * ?????????????????????????????????????
   * @param provinces ?????
   * @return ??0?????????????????1?????????????
   */
  public List<String[][]> getAllCityAndCode(String[] provinces) {
    int length= provinces.length;
    String[][] city = new String[length][];
    String[][] code = new String[length][];
    int count = 0;
    SQLiteDatabase db = getReadableDatabase();
    for(int i=0; i<length; i++) {
      Cursor cursor = db.query("citys", new String[]{"name", "city_num"},
          "province_id = ? ", new String[]{String.valueOf(i)}, null, null, null);
      count = cursor.getCount();
      city[i] = new String[count];
      code[i] = new String[count];
      count = 0;
      while(!cursor.isLast()) {
        cursor.moveToNext();
        city[i][count] = cursor.getString(0);
        code[i][count] = cursor.getString(1);
        count = count + 1;
      }
        cursor.close();
    }
    db.close();
    List<String[][]> result = new ArrayList<String[][]>();
    result.add(city);
    result.add(code);
    return result;
  }
  
  /**
   * ??????????????????????
   * @param cityName ?????
   * @return ????
   */
  public String getCityCodeByName(String cityName) {
    SQLiteDatabase db = getReadableDatabase();
    Cursor cursor = db.query("citys", new String[]{"city_num"},
        "name = ? ", new String[]{cityName}, null, null, null);
    String cityCode = null;
    if(!cursor.isLast()){
      cursor.moveToNext();
      cityCode = cursor.getString(0);
    }
    cursor.close();
    db.close();
    return cityCode;
  }
}

Java Source Code List

• Back to Weather/application  ↑