从本地数据库查询全国省市县信息

由于最近项目需要写了一次简单的从本地文件夹下获取数据库文件，通过将数据库文件保存到手机内存中查询数据库的方式来获得全国省市县信息，废话说完，直接代码和工具类。
1. 将本地数据库文件打开并读取到手机内存中。

/*** 将 assets 文件夹下的 数据文件写入 内存 方便获取* 文件夹下 有的话 就打开 没有的话 就创建打开* @author ymc**/
public class OpenSQLiteUtils {//数据库存储路径    String filePath = "data/data/com.zcsoft.zhichengsoft/districtsdatabase.db";    // 文件夹String pathStr = "data/data/com.zcsoft.zhichengsoft";    SQLiteDatabase database;    public  SQLiteDatabase openDatabase(Context context){    System.out.println("filePath:"+filePath);    File jhPath=new File(filePath);    //查看数据库文件是否存在    if(jhPath.exists()){    //存在则直接返回打开的数据库    return SQLiteDatabase.openOrCreateDatabase(jhPath, null);    }else{    //不存在先创建文件夹    File path=new File(pathStr);    try {    //得到资源    AssetManager am= context.getAssets();    //得到数据库的输入流    InputStream is=am.open("districtsdatabase.db");    //用输出流写到SDcard上面      FileOutputStream fos=new FileOutputStream(jhPath);    //创建byte数组  用于1KB写一次    byte[] buffer=new byte[1024];    int count = 0;    while((count = is.read(buffer))>0){    fos.write(buffer,0,count);    }    //最后关闭就可以了    fos.flush();    fos.close();    is.close();    } catch (IOException e) {    // TODO Auto-generated catch block    e.printStackTrace();    return null;  }    //如果没有这个数据库  我们已经把他写到SD卡上了，然后在执行一次这个方法 就可以返回数据库了    return openDatabase(context);    }    }    
}

以上代码 简单的将工程包下的数据库文件读取并保存。

2.主界面 （布局就不写了。就一个列表来呈现信息就可以）

/*** 选择 地区界面* @author ymc**/
public class AreaActivity extends BaseActivity implements OnItemClickListener{static String CLICK_CITY = "com.zcsoft.client.clickcity";static String CLICK_DISTRICTS = "com.zcsoft.client.clickdistricts";@ViewInject(R.id.listView)ListView lv;private List provinces = new ArrayList();  // 存放省份的集合private List citys = new ArrayList();  // 存放城市的集合private List districts = new ArrayList();  // 存放省份的集合private int lable = 0;   // 省  = 0  市 = 1   县  =2String name = null;private AreaBean bean = new AreaBean();   // 选中的 信息private OpenSQLiteUtils utils;private SQLiteDatabase db;private String sql;private Cursor cursor;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);initContentView(R.layout.activity_lv_detail);ViewUtils.inject(this);initView();initData();}private void initView() {rlTitle.setVisibility(View.VISIBLE);mTextViewTitle.setText("选择省份");mRadioGroup.setVisibility(View.GONE);lv.setOnItemClickListener(this);}private void initData() {utils = new OpenSQLiteUtils();db =utils.openDatabase(getApplicationContext());//查询数据库中testid=1的数据  sql = "select * from provinces order by province_id";  cursor = db.rawQuery(sql,null); if(cursor.moveToFirst()){do {String name=cursor.getString(cursor.getColumnIndex("province_name"));String code = cursor.getString(cursor.getColumnIndex("province_id"));AreaBean areaBean=  new AreaBean(); areaBean.setProvinceId(code);areaBean.setProvinceName(name);provinces.add(areaBean);} while (cursor.moveToNext());}lv.setAdapter(new AreaAdapter(provinces, 0, this));} @Overridepublic void onClick(View v) {switch (v.getId()) {case R.id.ib_baseactivity_back:finish();break;}}@Overridepublic void onItemClick(AdapterView parent, View view, int position,long id) {switch (lable) {case 0:   // 选择省份 查询 城市mTextViewTitle.setText("选择城市");lable = 1;String provinceName = provinces.get(position).getProvinceName();bean.setProvinceName(provinceName);sql = "select * from cities where province_id ='"+provinces.get(position).getProvinceId()+"'";  cursor = db.rawQuery(sql,null); if(cursor.moveToFirst()){do {String name=cursor.getString(cursor.getColumnIndex("city_name"));String code = cursor.getString(cursor.getColumnIndex("city_id"));AreaBean areaBean=  new AreaBean(); areaBean.setCityId(code);areaBean.setCityName(name);citys.add(areaBean);} while (cursor.moveToNext());lv.setAdapter(new AreaAdapter(citys, 1, this));}break;case 1:  // 选择城市  显示 县mTextViewTitle.setText("选择地区");lable = 2;String cityName = citys.get(position).getCityName();bean.setCityName(cityName);String sql = "select * from districts where city_id ='"+citys.get(position).getCityId()+"'";  Cursor cursor = db.rawQuery(sql,null); if(cursor.moveToFirst()){do {String name=cursor.getString(cursor.getColumnIndex("district_name"));String code = cursor.getString(cursor.getColumnIndex("district_id"));AreaBean areaBean=  new AreaBean();areaBean.setDistrictId(code);areaBean.setDistrictName(name);districts.add(areaBean);} while (cursor.moveToNext());lv.setAdapter(new AreaAdapter(districts, 2, this));}else{Intent intent = new Intent(CLICK_CITY);Bundle bundle = new Bundle();bundle.putSerializable("Address", bean);intent.putExtras(bundle);sendBroadcast(intent);finish();}break;case 2:  // 选择县城String  districtsName = districts.get(position).getDistrictName();bean.setDistrictName(districtsName);Intent intent = new Intent(CLICK_DISTRICTS);Bundle bundle = new Bundle();bundle.putSerializable("Address", bean);intent.putExtras(bundle);sendBroadcast(intent);finish();break;}}
}

就这么简单。（可以将BaseActivity 改为其他。 本人开发工具为 eclipse。菜鸡一个，互相学习。）

数据库文件地址 http://download.csdn.net/detail/qq_27948659/9658153

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！