package com.utils;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class City {
private static final int version = 1;// 版本号
private String dbName = "DBCity.db";// sqlite数据库名称
private static String tbName = "tCity";// 保存城市信息的表名
private String createTable = "create table tCity(_id integer primary key autoincrement"
+ ",cityName text not null" + ",province text" + ",english text)";// 创建表的语句
private Context context;// 上下文
private DBHelper helper;// 自定义SQLiteOpenHelper类
private static SQLiteDatabase db;// SQLiteDatabasec对象
public City(Context context) {
this.context = context;
this.helper = new DBHelper(this.context, dbName, null, version);
}
public void open() {
db = this.helper.getWritableDatabase();// 获取可读写的SQLiteDatabase对象
}
public void close() {
db.close();
helper.close();
}
// 添加城市信息
public boolean addCity(String cityName, String province, String english) {
ContentValues values = new ContentValues();
values.put("cityName", cityName);// 添加城市名称
values.put("province", province);// 添加省份名称
values.put("english", english);// 添加拼音
return db.insert(tbName, null, values) > 0;
}
// 更新城市信息
public boolean updateCity(String cityName, String province, String english) {
ContentValues values = new ContentValues();
values.put("province", province);
values.put("english", english);
String whereClause = "cityName=" + cityName;
return db.update(tbName, values, whereClause, null) > 0;
}
// 移除城市信息
public void removeCity(String cityName) {
String whereClause = "cityName=" + cityName;
db.delete(tbName, whereClause, null);
}
// 查询城市信息
public Cursor selectCity(String key) {
return db.query(true, tbName, new String[] { "_id", "cityName" },
"cityName like ? or province like ? or english like ?",
new String[] { "%" + key + "%", "%" + key + "%",
"%" + key + "%" }, null, null, "cityName asc", null);
}
private class DBHelper extends SQLiteOpenHelper {
public DBHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
public void onCreate(SQLiteDatabase db) {
db.execSQL(createTable);
// 直辖市
ContentValues values = new ContentValues();
values.put("cityName", "北京");
values.put("province", "直辖市");
values.put("english", "beijing");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "上海");
values.put("province", "直辖市");
values.put("english", "shanghai");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "天津");
values.put("province", "直辖市");
values.put("english", "tianjin");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "重庆");
values.put("province", "直辖市");
values.put("english", "chongqing");
db.insert(tbName, null, values);
// 特别行政区
values = new ContentValues();
values.put("cityName", "香港");
values.put("province", "特别行政区");
values.put("english", "xianggang");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "澳门");
values.put("province", "特别行政区");
values.put("english", "aomen");
db.insert(tbName, null, values);
// 黑龙江
values = new ContentValues();
values.put("cityName", "哈尔滨");
values.put("province", "黑龙江");
values.put("english", "haerbin");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "齐齐哈尔");
values.put("province", "黑龙江");
values.put("english", "qiqihaer");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "牡丹江");
values.put("province", "黑龙江");
values.put("english", "mudanjiang");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "大庆");
values.put("province", "黑龙江");
values.put("english", "daqing");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "伊春");
values.put("province", "黑龙江");
values.put("english", "yichun");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "双鸭山");
values.put("province", "黑龙江");
values.put("english", "shuangyashan");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "鹤岗");
values.put("province", "黑龙江");
values.put("english", "hegang");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "鸡西");
values.put("province", "黑龙江");
values.put("english", "jixi");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "佳木斯 ");
values.put("province", "黑龙江");
values.put("english", "jiamusi");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "七台河");
values.put("province", "黑龙江");
values.put("english", "qitaihe");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "黑河");
values.put("province", "黑龙江");
values.put("english", "heihe");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "绥化");
values.put("province", "黑龙江");
values.put("english", "suihua");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "大兴安岭");
values.put("province", "黑龙江");
values.put("english", "daxinganlin");
db.insert(tbName, null, values);
// 吉林
values = new ContentValues();
values.put("cityName", "长春 ");
values.put("province", "吉林");
values.put("english", "changchun");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "吉林 ");
values.put("province", "吉林");
values.put("english", "jilin");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "白山 ");
values.put("province", "吉林");
values.put("english", "baishan");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "白城 ");
values.put("province", "吉林");
values.put("english", "baicheng");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "四平 ");
values.put("province", "吉林");
values.put("english", "sipin");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "松原 ");
values.put("province", "吉林");
values.put("english", "songyuan");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "辽源 ");
values.put("province", "吉林");
values.put("english", "liaoyuan");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "大安 ");
values.put("province", "吉林");
values.put("english", "daan");
db.insert(tbName, null, values);
values = new ContentValues();
values.put("cityName", "通化 ");
values.put("province", "吉林");
values.put("english", "tonghua");
db.insert(tbName, null, values);
// 辽宁
values = new ContentValues();
values.put("cityName", "沈阳 ");
values.put("province", "辽宁");
values.put("english", "shenyang
android外出小助手
需积分: 10 126 浏览量
2013-04-08
17:25:02
上传
评论
收藏 13.25MB ZIP 举报
android外出小助手 （193个子文件） 
all-wcprops 170B resources.ap_ 4.45MB TrainStation.apk 4.55MB proguard.cfg 1KB City$DBHelper.class 18KB Weather_Forecast_Activity.class 12KB TrainsHelper.class 5KB XFireProxyFactory.class 5KB SelectData.class 5KB R$id.class 4KB Station_ItemActivity.class 4KB Flay_ItemActivity.class 4KB NumberInFoActivity.class 3KB City.class 3KB TranSearchActivity.class 3KB Mapping_Search_Data_Activity.class 3KB Weather_Forecast_Activity$MyShouShi.class 3KB Search_Start_lst$2$1.class 3KB R$drawable.class 3KB SearchFlayActivity$2$1.class 2KB TrainNumber_ItemActivity.class 2KB Search_Train_Number$2$1.class 2KB Weather_Forecast_Activity$CitysAdapter.class 2KB TrainNumber_ItemActivity$SearchMapping.class 2KB Station_ItemActivity$exactquery.class 2KB Weather_Forecast_Activity$2.class 2KB Weather_Forecast_Activity$3.class 2KB DBHelper.class 2KB SearchFlayActivity.class 2KB Weather_Forecast_Activity$TablesTask.class 2KB Weather_Forecast_Activity$AutocomTouchListener.class 2KB StartActivity.class 2KB Search_Start_lst.class 2KB Station_ItemActivity$1.class 2KB Flay_ItemActivity$1.class 2KB Weather_Activity.class 2KB Search_Train_Number.class 2KB TranSearchActivity$SearchItem.class 2KB Weather_Activity$1.class 2KB Mapping_Search_Split.class 2KB StartActivity$SearchWeather.class 1KB Search_Train_Number$2.class 1KB SearchFlayActivity$2.class 1KB Search_Start_lst$2.class 1KB Animations.class 1KB R$layout.class 1KB Weather_Forecast_Activity$Fisih.class 1KB Search_Train_Number$Close2.class 1KB SearchFlayActivity$Close1.class 1KB Search_Start_lst$Close1.class 1KB StartActivity$SearchTrain.class 1KB StartActivity$SearchFlay.class 1KB Weather_Forecast_Activity$4.class 1KB Weather_Forecast_Activity$1.class 1KB SearchFlayActivity$1.class 975B Search_Start_lst$1.class 963B Search_Train_Number$1.class 904B R$string.class 670B SearchWaiChuActivity.class 472B R.class 461B R$attr.class 310B .classpath 532B classes.dex 216KB entries 403B format 2B
xiayu.gif 1.57MB log2.gif 69KB niao.gif 33KB weather.gif 643B
log.html 346B gongju.ico 97KB fous.ico 97KB play.ico 97KB count.ico 97KB close.ico 97KB two.ico 97KB sex.ico 97KB one.ico 97KB pouse.ico 97KB media.ico 97KB flay.ico 90KB City.java 38KB Weather_Forecast_Activity.java 17KB R.java 12KB TrainsHelper.java 7KB SelectData.java 5KB StartActivity.java 4KB Station_ItemActivity.java 4KB SearchFlayActivity.java 3KB NumberInFoActivity.java 3KB Flay_ItemActivity.java 3KB Search_Start_lst.java 3KB TranSearchActivity.java 3KB Search_Train_Number.java 2KB TrainNumber_ItemActivity.java 2KB Animations.java 2KB Mapping_Search_Data_Activity.java 2KB DBHelper.java 2KB Weather_Activity.java 1KB Mapping_Search_Split.java 1021B共 193 条
- 1
- 2
资源评论
