Android天气开源项目之添加城市

其实前面的Android 读取assets目录下的db文件，Android之高德地图定位，Android之应用市场评分这三篇文章都是天气预报之中的功能，这篇文章主要写读取db_weather.db中的hotCity和搜索城市，以及添加城市到my_city.db中。

package com.lzh.weatherforecast.Util;

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

import com.lzh.weatherforecast.Bean.CityInfo;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;


public class DBUtil {
    private String DB_NAME = "db_weather.db";
    private Context mContext;

    public DBUtil(Context mContext) {
        this.mContext = mContext;
    }

    //把assets目录下的db文件复制到dbpath下
    public void initDBManager(String packName) {
        String dbPath = "/data/data/" + packName
                + "/" + DB_NAME;
        if (!new File(dbPath).exists()) {
            try {
                FileOutputStream out = new FileOutputStream(dbPath);
                InputStream in = mContext.getAssets().open("db_weather.db");
                byte[] buffer = new byte[1024];
                int readBytes = 0;
                while ((readBytes = in.read(buffer)) != -1)
                    out.write(buffer, 0, readBytes);
                in.close();
                out.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

    public SQLiteDatabase getSqLiteDatabase(String packName) {
        String dbPath = "/data/data/" + packName
                + "/" + DB_NAME;
        return SQLiteDatabase.openOrCreateDatabase(dbPath, null);
    }

    //查询普通city集合
    public CityInfo queryCommonCity(SQLiteDatabase sqliteDB, String[] columns, String selection, String[] selectionArgs) {
        CityInfo city = null;
        try {
            String table = "citys";
            Cursor cursor = sqliteDB.query(table, columns, selection, selectionArgs, null, null, null);
            if (cursor.moveToFirst()) {
                String name = cursor.getString(cursor
                        .getColumnIndex("name"));
                String cityID = cursor.getString(cursor.getColumnIndex("city_num"));
                city = new CityInfo(name, cityID);
                cursor.moveToNext();
                cursor.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return city;
    }

    //查询普通city
    public List<CityInfo> queryCommonCityList(SQLiteDatabase sqliteDB, String[] columns, String selection, String[] selectionArgs) {
        List<CityInfo> cityInfoList = new ArrayList<CityInfo>();
        CityInfo cityInfo = null;
        try {
            String table = "citys";
            Cursor cursor = sqliteDB.query(table, columns, selection, selectionArgs, null, null, null);
            for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
                String name = cursor.getString(cursor
                        .getColumnIndex("name"));
                String cityID = cursor.getString(cursor.getColumnIndex("city_num"));
                cityInfo = new CityInfo(name, cityID);
                cityInfoList.add(cityInfo);
            }
            cursor.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return cityInfoList;
    }

    //查询hotcity
    public List<CityInfo> queryHotCity(SQLiteDatabase sqliteDB) {
        List<CityInfo> cityInfoList = new ArrayList<CityInfo>();
        try {
            String table = "hotcity";
            Cursor cursor = sqliteDB.query(table, null, null, null, null, null, null);
            for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
                String name = cursor.getString(cursor
                        .getColumnIndex("name"));
                String cityID = cursor.getString(cursor.getColumnIndex("posID"));
                CityInfo cityInfo = new CityInfo(name, cityID);
                cityInfoList.add(cityInfo);
            }
            cursor.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return cityInfoList;
    }
}

把添加的城市的相关信息在my_city表中保存

package com.lzh.weatherforecast.DB;

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


public class DBHelper extends SQLiteOpenHelper {
    private static final String DB_NAME = "my_city.db";
    private static final int version = 2;
    private String createTable = "create table my_city (" + "_id integer primary key autoincrement,name vachar,city_id vacher )";
    private Context mContext;

    public DBHelper(Context context) {
        super(context, DB_NAME, null, version);
        this.mContext = context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        //创建数据库
        db.execSQL(createTable);
    }


    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    }
}

package com.lzh.weatherforecast.DB;

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

import com.lzh.weatherforecast.Bean.CityInfo;

import java.util.ArrayList;
import java.util.List;


public class DBManger {
    private DBHelper dbHelper;
    private SQLiteDatabase sqLiteDatabase;
    private List<CityInfo> list;
    private String tableName = "my_city";

    public DBManger(Context context) {
        dbHelper = new DBHelper(context);
        sqLiteDatabase = dbHelper.getWritableDatabase();
    }
    //添加城市到表中
    public long insert(String nullColumnHack, ContentValues values) {
        return sqLiteDatabase.insert(tableName, nullColumnHack, values);
    }
    //删除已经添加的城市
    public void delete(String whereClause, String[] whereArgs) {
        sqLiteDatabase.delete(tableName, whereClause, whereArgs);
    }
        //查询my_city表中的城市信息，在显示添加城市的天气中用到
    public List<CityInfo> query(String[] columns, String selection, String[] selectionArgs) {
        List<CityInfo> cityInfoList = new ArrayList<CityInfo>();
        CityInfo cityInfo = null;
        Cursor cursor = sqLiteDatabase.query(tableName, columns, selection, selectionArgs, null, null, "_id desc");
        if (cursor != null) {
            for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
                String name = cursor.getString(cursor.getColumnIndex("name"));
                String cityID = cursor.getString(cursor.getColumnIndex("city_id"));
                cityInfo = new CityInfo(name, cityID);
                cityInfoList.add(cityInfo);
            }
        }
        cursor.close();
        return cityInfoList;
    }
    //查询my_city表中单个城市，用来判断城市是否已经被添加
    public CityInfo querySingle(String[] columns, String selection, String[] selectionArgs) {
        CityInfo cityInfo = null;
        Cursor cursor = sqLiteDatabase.query(tableName, columns, selection, selectionArgs, null, null, null);
        cursor.getCount();
        if (cursor != null && cursor.moveToFirst()) {
            String name = cursor.getString(cursor.getColumnIndex("name"));
            String cityID = cursor.getString(cursor.getColumnIndex("city_id"));
            cityInfo = new CityInfo(name, cityID);
        }
        cursor.close();
        return cityInfo;
    }
}

这里用到了Android自定义标题栏，但是有所修改，在这里还是把相应的代码贴出来

package com.lzh.weatherforecast.Widget;

import android.content.Context;
import android.graphics.drawable.Drawable;
import android.util.AttributeSet;
import android.view.LayoutInflater;
import android.view.View;
import android.widget.ImageView;
import android.widget.RelativeLayout;
import android.widget.TextView;

import com.lzh.weatherforecast.R;


public class TitleLayout extends RelativeLayout {
    private Context context;
    private RelativeLayout relativeLayout;
    private ImageView leftImageView, rightImageView;
    private TextView titleTextView, rightTextView;
    private TitleOnClickListener titleOnClickListener;

    public TitleLayout(Context context) {
        super(context);
        this.context = context;
        initView();
    }

    public TitleLayout(Context context, AttributeSet attrs) {
        super(context, attrs);
        this.context = context;
        initView();
    }

    public TitleLayout(Context context, AttributeSet attrs, int defStyleAttr) {
        super(context, attrs, defStyleAttr);
        this.context = context;
        initView();
    }

    //初始化view
    private void initView() {
        View view = LayoutInflater.from(context).inflate(R.layout.common_title_layout, null);
        leftImageView = (ImageView) view.findViewById(R.id.left_imageview);
        rightTextView = (TextView) view.findViewById(R.id.right_textview);
        titleTextView = (TextView) view.findViewById(R.id.title);
        relativeLayout = (RelativeLayout) view.findViewById(R.id.titlelayout);
        rightImageView = (ImageView) view.findViewById(R.id.right_image);
        this.addView(view);
    }

    //给右边的imageView设置bg
    public void setRightImageViewBg(int resid) {
        rightImageView.setBackgroundResource(resid);
    }

    //设置右边的imageView是否可见
    public void setRightImageViewVisibility(int visibility) {
        rightImageView.setVisibility(visibility);
    }

    // 右边图片点击事件
    public void setRightImageViewListener(final TitleOnClickListener titleOnClickListener) {
        rightImageView.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                titleOnClickListener.OnClick();
            }
        });
    }

    //设置标题栏背景颜色
    public void setTitleBackgroundColor(int color) {
        relativeLayout.setBackgroundColor(color);
    }

    //设置标题
    public void setTitleMessage(String title) {
        titleTextView.setText(title);
    }

    //标题文字大小
    public void setTitleSize(float size) {
        titleTextView.setTextSize(size);
    }

    //设置左边图片
    public void setLeftImage(Drawable drawable) {
        leftImageView.setImageDrawable(drawable);
    }

    //设置右边文字
    public void setRightTextMessage(String message) {
        rightTextView.setText(message);
    }

    //左边图片是否隐藏
    public void setLeftVisibility(int visibility) {
        leftImageView.setVisibility(visibility);
    }

    //右边图片是否隐藏
    public void setRightVisibility(int visibility) {
        rightTextView.setVisibility(visibility);
    }

    //标题文字是否隐藏
    public void setTitleVisibility(int visibility) {
        titleTextView.setVisibility(visibility);
    }

    //设置标题文字颜色
    public void setTitleColor(int color) {
        titleTextView.setTextColor(color);
    }

    //左边点击事件
    public void setLeftListener(final TitleOnClickListener titleOnClickListener) {
        leftImageView.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                titleOnClickListener.OnClick();
            }
        });
    }

    public void setRightListener(final TitleOnClickListener titleOnClickListener) {
        rightTextView.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                titleOnClickListener.OnClick();
            }
        });
    }

    public interface TitleOnClickListener {
        void OnClick();

    }
}

到这里所有的准备工作都已经做好了，现在开始在Activity中显示hotCity和搜索city已经添加city

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:background="@color/background"
    android:fitsSystemWindows="true"
    android:orientation="vertical">

    <com.lzh.weatherforecast.Widget.TitleLayout
        android:id="@+id/title_layout"
        android:layout_width="fill_parent"
        android:layout_height="@dimen/size_132px"></com.lzh.weatherforecast.Widget.TitleLayout>

    <EditText
        android:id="@+id/key"
        android:layout_width="match_parent"
        android:layout_height="@dimen/size_96px"
        android:layout_marginLeft="@dimen/size_57px"
        android:layout_marginRight="@dimen/size_57px"
        android:layout_marginTop="@dimen/size_57px"
        android:background="@drawable/bg_floating"
        android:drawableRight="@drawable/btn_del"
        android:hint="@string/search_tips"
        android:paddingLeft="@dimen/size_21px"
        android:paddingRight="@dimen/size_21px" />

    <TextView
        android:id="@+id/title_tips"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginBottom="@dimen/size_21px"
        android:layout_marginLeft="@dimen/size_57px"
        android:layout_marginTop="@dimen/size_57px"
        android:text="@string/choose_hotcity"
        android:textColor="@color/black"
        android:textSize="@dimen/size_48px" />

    <TextView
        android:layout_width="match_parent"
        android:layout_height="@dimen/size_1px"
        android:background="@color/line_background" />

    <GridView
        android:id="@+id/gridview"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginLeft="@dimen/size_57px"
        android:layout_marginRight="@dimen/size_57px"
        android:layout_marginTop="@dimen/size_21px"
        android:listSelector="@color/transparent"
        android:numColumns="3"
        android:scrollbars="none" />


    <ListView
        android:id="@+id/listview"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:visibility="gone"></ListView>

    <TextView
        android:id="@+id/search_result"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginLeft="@dimen/size_57px"
        android:layout_marginTop="@dimen/size_57px"
        android:textColor="@color/black"
        android:textSize="@dimen/size_48px"
        android:visibility="gone" />
</LinearLayout>

hotcity显示在gridView中，用户搜索出来的结果显示在ListView中，Activity处理的相关代码如下：

package com.lzh.weatherforecast.Activity;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.drawable.Drawable;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.text.Editable;
import android.text.TextWatcher;
import android.view.MotionEvent;
import android.view.View;
import android.view.inputmethod.InputMethodManager;
import android.widget.AdapterView;
import android.widget.EditText;
import android.widget.GridView;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;

import com.lzh.weatherforecast.Adapter.AddLocationAdapter;
import com.lzh.weatherforecast.Adapter.SearchCityAdapter;
import com.lzh.weatherforecast.Bean.CityInfo;
import com.lzh.weatherforecast.DB.DBManger;
import com.lzh.weatherforecast.R;
import com.lzh.weatherforecast.Util.DBUtil;
import com.lzh.weatherforecast.Util.TitleUtil;
import com.lzh.weatherforecast.Widget.CustomDialog;
import com.lzh.weatherforecast.Widget.TitleLayout;

import java.util.ArrayList;
import java.util.List;


public class AddLocationActivity extends Activity implements View.OnClickListener {
    private TitleLayout titleLayout;
    private EditText keyEditText;
    private GridView gridView;
    private DBUtil dbUtil;
    private List<CityInfo> cityInfoList;
    private CityInfo cityInfo;
    private SQLiteDatabase sqLiteDatabase;
    private AddLocationAdapter adapter;
    private TitleUtil titleUtil;
    private List<CityInfo> hotCityInfoList;
    private ListView listView;
    private SearchCityAdapter searchCityAdapter;
    private TextView searchResultTitlte, titleTips;
    private static final int ITEM_CLICK = 0x01;
    private CustomDialog dialog;
    private DBManger dbManger;
    private int choosePosition;
    private Handler mHandler = new Handler() {
        @Override
        public void handleMessage(Message msg) {
            switch (msg.what) {
                case ITEM_CLICK:
                    initSearchList(cityInfoList);
                    choosePosition = msg.arg1;
                    cityInfoList.get(msg.arg1).isCheck = true;
                    searchCityAdapter.notifyDataSetChanged();
                    showDiaolg(cityInfoList.get(msg.arg1).name, "common");
                    break;
            }
        }
    };

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_add_location);
        initView();
        setListener();
    }

    private void initView() {
        dialog = new CustomDialog(this);
        dbManger = new DBManger(this);
        titleUtil = new TitleUtil(this);
        titleUtil.initTitle();
        titleLayout = (TitleLayout) findViewById(R.id.title_layout);
        titleLayout.setTitleMessage(getResources().getString(R.string.add_address));
        keyEditText = (EditText) findViewById(R.id.key);
        titleLayout.setRightTextMessage(getString(R.string.search));
        gridView = (GridView) findViewById(R.id.gridview);
        listView = (ListView) findViewById(R.id.listview);
        titleTips = (TextView) findViewById(R.id.title_tips);
        searchResultTitlte = (TextView) findViewById(R.id.search_result);
        hotCityInfoList = new ArrayList<CityInfo>();
        dbUtil = new DBUtil(this);
        sqLiteDatabase = dbUtil.getSqLiteDatabase(getPackageName());
        hotCityInfoList = dbUtil.queryHotCity(sqLiteDatabase);
        adapter = new AddLocationAdapter(hotCityInfoList, this);
        gridView.setAdapter(adapter);
        titleLayout.setLeftListener(new TitleLayout.TitleOnClickListener() {
            @Override
            public void OnClick() {
                finish();
            }
        });
    }

    private void setListener() {
        titleLayout.setRightListener(new TitleLayout.TitleOnClickListener() {
            @Override
            public void OnClick() {
                hideKeyBoard(titleLayout);
                if (cityInfoList != null) {
                    cityInfoList.clear();
                }
                titleTips.setText(getResources().getString(R.string.choose_city));
                String key = keyEditText.getText().toString().trim();
                if (null != key && !key.equals("")) {
                    gridView.setVisibility(View.GONE);
                    listView.setVisibility(View.VISIBLE);
                    cityInfoList = searchCity(key);
                    updateListView(cityInfoList);
                } else {
                    showToast(getResources().getString(R.string.search_tips));
                }
            }
        });
        //点击右边的删除图标删除输入框文字信息
        keyEditText.setOnTouchListener(new View.OnTouchListener() {
            @Override
            public boolean onTouch(View v, MotionEvent event) {
                Drawable drawable = keyEditText.getCompoundDrawables()[2];
                if (drawable == null)
                    return false;

                if (event.getAction() != MotionEvent.ACTION_UP)
                    return false;

                if (event.getX() > keyEditText.getWidth() - keyEditText.getPaddingRight()
                        - drawable.getIntrinsicWidth()) {
                    keyEditText.setText("");
                }

                return false;
            }
        });
        keyEditText.addTextChangedListener(new TextWatcher() {
            @Override
            public void beforeTextChanged(CharSequence s, int start, int count, int after) {

            }

            @Override
            public void onTextChanged(CharSequence s, int start, int before, int count) {
                if (s.length() == 0 || s.equals(getResources().getString(R.string.search_tips))) {
                    listView.setVisibility(View.GONE);
                    gridView.setVisibility(View.VISIBLE);
                    titleTips.setText(getResources().getString(R.string.choose_hotcity));
                    searchResultTitlte.setVisibility(View.GONE);
                }
            }

            @Override
            public void afterTextChanged(Editable s) {

            }
        });
        gridView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
                choosePosition = position;
                showDiaolg(hotCityInfoList.get(position).name, "hotcity");
            }
        });
    }

    private void initSearchList(List<CityInfo> list) {
        for (CityInfo cityInfo : list) {
            cityInfo.isCheck = false;
        }
    }

    @Override
    public void onClick(View v) {

    }

    private void updateListView(List<CityInfo> list) {
        if (cityInfoList.size() == 0) {
            searchResultTitlte.setVisibility(View.VISIBLE);
            searchResultTitlte.setText(getResources().getString(R.string.not_find_about_city));
        } else {
            searchResultTitlte.setVisibility(View.GONE);
            searchCityAdapter = new SearchCityAdapter(list, AddLocationActivity.this, mHandler);
            listView.setAdapter(searchCityAdapter);
        }
    }

    //模糊查询city
    private List<CityInfo> searchCity(String key) {
        String[] columns = new String[]{"name", "city_num"};
        String selection = " name like ?";
        String[] selectionArgs = new String[]{"%" + key + "%"};
        return dbUtil.queryCommonCityList(sqLiteDatabase, columns, selection, selectionArgs);
    }

    //隐藏键盘
    private void hideKeyBoard(View view) {
        InputMethodManager imm = (InputMethodManager) view
                .getContext().getSystemService(
                        Context.INPUT_METHOD_SERVICE);
        if (imm.isActive()) {
            imm.hideSoftInputFromWindow(
                    view.getApplicationWindowToken(), 0);
        }
    }

    private void showDiaolg(String content, String type) {
        dialog.show();
        dialog.setTitleMessage(getResources().getString(R.string.notification));
        dialog.setContentText(content);
        if (type.equals("hotcity")) {
            cityInfo = hotCityInfoList.get(choosePosition);
        } else {
            cityInfo = cityInfoList.get(choosePosition);
        }
        dialog.setCancleBtnOnClickListener(new CustomDialog.OnClickListener() {
            @Override
            public void onClick() {
                dialog.dismiss();
            }
        });
        dialog.setOkBtnOnClickListener(new CustomDialog.OnClickListener() {
            @Override
            public void onClick() {
                if (searchAlreadyCity(cityInfo.cityID)) {
                    ContentValues contentValues = new ContentValues();
                    contentValues.put("name", cityInfo.name);
                    contentValues.put("city_id", cityInfo.cityID);
                    long id = dbManger.insert(null, contentValues);
                    if (id != -1) {
                        showToast(getResources().getString(R.string.add_location_success));
                    } else {
                        showToast(getResources().getString(R.string.add_location_failed));
                    }
                } else {
                    showToast(getResources().getString(R.string.already_exist));
                }
                dialog.dismiss();
            }
        });
    }

    //模糊查询city
    private boolean searchAlreadyCity(String cityID) {
        String[] columns = new String[]{"name", "city_id"};
        String selection = " city_id=?";
        String[] selectionArgs = new String[]{cityID};
        if (dbManger.querySingle(columns, selection, selectionArgs) != null) {
            return false;
        }
        return true;
    }

    private void showToast(String message) {
        Toast.makeText(AddLocationActivity.this, message, Toast.LENGTH_SHORT).show();
    }
}

现在显示这个功能就已经完成了，运行图如下：