coolweather (二)

//*
* 从数据库中读取所有的省份信息
//
public List loadProvinces() {
List list = new ArrayList();
Cursor cursor = db.query(“表明”, null, null, null, null, null, null);
if (cursor.moveToFirst()) {
do {
list.add(new Province(cursor.getInt(cursor.getColumnIndex(“id”)), cursor.getString(cursor.getColumnIndex(“name”)), null));
} while (cursor.moveToNext());
}
if (cursor != null) {
cursor.close();//一定要注意能回收关闭的资源一定要关闭，不然会造成内存泄漏
}
return list;
}

//从数据库中读取某城市下所有县的信息
Cursor cursor = db.query("table_name", null, "city_id = ?", new String[]{String.valueOf(cityId)}):

//遍历全国省市县的数据
        //网络请求在子线程中进行防止阻塞ui线程
        public static void sendHttpRequest(final String address, final HttpCallBackListener listener){
            new Thread(new Runnable){}
            public void run(){
            HttpURLConnection connection = null;
            try{
                URL url = new URL(address):
                connection = (HttpURLConnection)url.openConnection();
                connection.setRequestMethod("GET");
                connection.setReadTimeout(8000);
                connection.setConnectTimeout(8000);
                InputStream in = connection.getInputSteam();
                BufferReader bufferReader = new BufferReader(new InputStreamReader(in));
                String line;
                StringBuilder response = new StringBuilder();
                while((line = bufferReader.readLine()) != null){
                    response.append(line);
                }
                if(listener != null){
                //回调onFinish()方法
                    listener.onFinish();
                }

            }catch (Exception e){
                listener.onError(e);
            }
            }finally{
                if(connection != null){
                connection.disconnect();
                }
            }
        }.start();