做一款自己的安卓天气闹钟(6)——使用sqlite保存设置选项

知识点

  1. sqlite
    无需多介绍,能看到这儿的肯定都知道
  2. SQLiteOpenHelper
    抽象类,我们通过继承该类,然后重写数据库创建以及更新的方法, 我们还可以通过该类的对象获得数据库实例,或者关闭数据库!
  3. SQLiteDatabase数据库访问类
    我们可以通过该类的对象来对数据库做一些增删改查的操作
  4. Cursor游标
    有点类似于JDBC里的resultset,结果集!可以简单理解为指向数据库中某 一个记录的指针!

编写代码

  1. 创建自己的sqlite管理类
package love.xzjs.t_android;

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

/**
 * Created by Administrator on 2017/12/18.
 */

public class MyDBOpenHelper extends SQLiteOpenHelper {
    public MyDBOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    /**
     * 数据库第一次创建
     */
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        sqLiteDatabase.execSQL("CREATE TABLE config(" +
                "id INTEGER PRIMARY KEY AUTOINCREMENT," +
                "time INTEGER(1)," +
                "date INTEGER(1)," +
                "week INTEGER(1)," +
                "location VARCHAR(20)," +
                "firstDay INTEGER(1)," +
                "secondDay INTEGER(1)," +
                "thirdDay INTEGER(1)," +
                "num INTEGER(1))");

        ContentValues values=new ContentValues();
        values.put("time",1);
        values.put("date",1);
        values.put("week",1);
        values.put("firstDay",1);
        values.put("secondDay",1);
        values.put("thirdDay",1);
        values.put("num",3);
        values.put("location","");
        sqLiteDatabase.insert("config",null,values);
    }

    @Override
    /**
     * 数据库更新
     */
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }
}

  1. 创建配置实体类Config.java
package love.xzjs.t_android;

/**
 * Created by Administrator on 2017/12/18.
 */

public class Config {
    private int id,time,date,week,firstDay,secondDay,thirdDay,num;
    private String location;

    public Config(int id, int time, int date, int week, int firstDay, int secondDay, int thirdDay, int num, String location) {
        this.id = id;
        this.time = time;
        this.date = date;
        this.week = week;
        this.firstDay = firstDay;
        this.secondDay = secondDay;
        this.thirdDay = thirdDay;
        this.num = num;
        this.location = location;
    }

    public Config(){
        this.id = 0;
        this.time = 0;
        this.date = 0;
        this.week = 0;
        this.firstDay = 0;
        this.secondDay = 0;
        this.thirdDay = 0;
        this.num = 3;
        this.location = "";

    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getTime() {
        return time;
    }

    public void setTime(int time) {
        this.time = time;
    }

    public int getDate() {
        return date;
    }

    public void setDate(int date) {
        this.date = date;
    }

    public int getWeek() {
        return week;
    }

    public void setWeek(int week) {
        this.week = week;
    }

    public int getFirstDay() {
        return firstDay;
    }

    public void setFirstDay(int firstDay) {
        this.firstDay = firstDay;
    }

    public int getSecondDay() {
        return secondDay;
    }

    public void setSecondDay(int secondDay) {
        this.secondDay = secondDay;
    }

    public int getThirdDay() {
        return thirdDay;
    }

    public void setThirdDay(int thirdDay) {
        this.thirdDay = thirdDay;
    }

    public int getNum() {
        return num;
    }

    public void setNum(int num) {
        this.num = num;
    }

    public String getLocation() {
        return location;
    }

    public void setLocation(String location) {
        this.location = location;
    }
}

  1. 在Show.java中使用sqlite管理类
 package love.xzjs.t_android;

import android.Manifest;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.content.pm.PackageManager;
import android.content.res.Resources;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Build;
import android.os.Bundle;
import android.support.annotation.RequiresApi;
import android.support.v4.app.ActivityCompat;
import android.support.v4.app.Fragment;
import android.util.DisplayMetrics;
import android.util.Log;
import android.util.TypedValue;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.CompoundButton;
import android.widget.LinearLayout;
import android.widget.Spinner;
import android.widget.Switch;
import android.widget.TextView;

import com.baidu.location.BDLocation;
import com.baidu.location.BDLocationListener;
import com.baidu.location.LocationClient;
import com.baidu.location.LocationClientOption;

import java.util.HashMap;

public class Show extends Fragment implements CompoundButton.OnCheckedChangeListener, BDLocationListener, AdapterView.OnItemSelectedListener {
    private TextView textViewTime, textViewDate, textViewWeek, _locationTextView;
    private Switch switchTime, switchDate, switchWeek, switchWeather1, switchWeather2, switchWeather3;
    private LinearLayout linearLayout1, linearLayout2, linearLayout3;
    private Spinner spinner;

    private LocationClient _locationClient;
    private static final int BAIDU_READ_PHONE_STATE = 100;

    private MyDBOpenHelper myDBOpenHelper;
    private Config config;
    private int id;
    private ContentValues values;
    private HashMap<String, TextView> textViewHashMap;
    private HashMap<String, Switch> switchHashMap;
    private HashMap<String, LinearLayout> linearLayoutHashMap;

    //判断是否为刚进去时触发onItemSelected的标志
    private boolean spinnerSelected = false;

    @RequiresApi(api = Build.VERSION_CODES.M)
    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
        View view = inflater.inflate(R.layout.config_show, container, false);

        textViewTime = (TextView) view.findViewById(R.id.time_label);
        textViewDate = (TextView) view.findViewById(R.id.date);
        textViewWeek = (TextView) view.findViewById(R.id.week);
        linearLayout1 = (LinearLayout) view.findViewById(R.id.weather_today);
        linearLayout2 = (LinearLayout) view.findViewById(R.id.weather_tomorrow);
        linearLayout3 = (LinearLayout) view.findViewById(R.id.weather_after_tomorrow);
        _locationTextView = view.findViewById(R.id.locationTextView);
        spinner = view.findViewById(R.id.spinner1);
        values = new ContentValues();

        //根据屏幕宽度确定字体的大小
        Resources resources = this.getResources();
        DisplayMetrics dm = resources.getDisplayMetrics();
        int width = dm.widthPixels;
        textViewTime.setTextSize(TypedValue.COMPLEX_UNIT_SP, 150 * width / 1794);

        //绑定switch事件
        switchTime = (Switch) view.findViewById(R.id.switch_time);
        switchDate = (Switch) view.findViewById(R.id.switch_date);
        switchWeek = (Switch) view.findViewById(R.id.switch_week);
        switchWeather1 = (Switch) view.findViewById(R.id.switch_weather1);
        switchWeather2 = (Switch) view.findViewById(R.id.switch_weather2);
        switchWeather3 = (Switch) view.findViewById(R.id.switch_weather3);
        switchTime.setOnCheckedChangeListener(this);
        switchDate.setOnCheckedChangeListener(this);
        switchWeek.setOnCheckedChangeListener(this);
        switchWeather1.setOnCheckedChangeListener(this);
        switchWeather2.setOnCheckedChangeListener(this);
        switchWeather3.setOnCheckedChangeListener(this);

        _locationClient = new LocationClient(getContext());
        _locationClient.registerLocationListener(this);
        LocationClientOption option = new LocationClientOption();
        option.setIsNeedAddress(true);
        option.setLocationMode(LocationClientOption.LocationMode.Hight_Accuracy);//设置高精度定位定位模式
        option.setOpenGps(true); // 打开gps
        option.setCoorType("bd09ll"); // 设置坐标类型
        option.setScanSpan(1000);
        _locationClient.setLocOption(option);

        if (ActivityCompat.checkSelfPermission(getActivity(), Manifest.permission.READ_PHONE_STATE) != PackageManager.PERMISSION_GRANTED) {
            // 申请一个(或多个)权限,并提供用于回调返回的获取码(用户定义)
            requestPermissions(new String[]{Manifest.permission.READ_PHONE_STATE}, BAIDU_READ_PHONE_STATE);
        } else {
            _locationClient.start();
        }

        textViewHashMap=new HashMap<>();
        textViewHashMap.put("time", textViewTime);
        textViewHashMap.put("date", textViewDate);
        textViewHashMap.put("week", textViewWeek);
        linearLayoutHashMap=new HashMap<>();
        linearLayoutHashMap.put("firstDay", linearLayout1);
        linearLayoutHashMap.put("secondDay", linearLayout2);
        linearLayoutHashMap.put("thirdDay", linearLayout3);
        switchHashMap=new HashMap<>();
        switchHashMap.put("time", switchTime);
        switchHashMap.put("date", switchDate);
        switchHashMap.put("week", switchWeek);
        switchHashMap.put("firstDay", switchWeather1);
        switchHashMap.put("secondDay", switchWeather2);
        switchHashMap.put("thirdDay", switchWeather3);

        myDBOpenHelper = new MyDBOpenHelper(getActivity(), "clock.db", null, 1);
        SQLiteDatabase db = myDBOpenHelper.getWritableDatabase();
        Cursor cursor = db.query("config", null, null, null, null, null, null);
        if (cursor.moveToFirst()) {
            id = cursor.getInt(cursor.getColumnIndex("id"));
            values.put("time", cursor.getInt(cursor.getColumnIndex("time")));
            values.put("date", cursor.getInt(cursor.getColumnIndex("date")));
            values.put("week", cursor.getInt(cursor.getColumnIndex("week")));
            values.put("location", cursor.getInt(cursor.getColumnIndex("location")));
            values.put("firstDay", cursor.getInt(cursor.getColumnIndex("firstDay")));
            values.put("secondDay", cursor.getInt(cursor.getColumnIndex("secondDay")));
            values.put("thirdDay", cursor.getInt(cursor.getColumnIndex("thirdDay")));
            values.put("num", cursor.getInt(cursor.getColumnIndex("num")));
            setViewData();
        }

        return view;
    }

    /**
     * 绑定数据
     */
    private void setViewData() {
        for (String key : values.keySet()) {
            boolean status = (int) values.get(key) == 1;
            switch (key) {
                case "time":
                case "date":
                case "week":
                    textViewHashMap.get(key).setVisibility(status ? View.VISIBLE : View.GONE);
                    switchHashMap.get(key).setChecked(status);
                    break;
                case "firstDay":
                case "secondDay":
                case "thirdDay":
                    linearLayoutHashMap.get(key).setVisibility(status ? View.VISIBLE : View.GONE);
                    switchHashMap.get(key).setChecked(status);
                    break;
                case "num":
                    spinnerSelected = false;
                    int num = (int) values.get(key) - 1;
                    spinner.setSelection(num);
                    break;
                default:
                    break;
            }
        }
    }

    /**
     * Called when the Fragment is no longer started.  This is generally
     * tied to {@link Activity#onStop() Activity.onStop} of the containing
     * Activity's lifecycle.
     */
    @Override
    public void onStop() {
        super.onStop();

        SQLiteDatabase db = myDBOpenHelper.getWritableDatabase();
        db.update("config", values, "id=?", new String[]{String.valueOf(id)});
    }

    /**
     * 重写switch状态变更事件
     *
     * @param compoundButton
     * @param b
     */
    @Override
    public void onCheckedChanged(CompoundButton compoundButton, boolean b) {
        boolean isChecked = compoundButton.isChecked();
        switch (compoundButton.getId()) {
            case R.id.switch_time:
                textViewTime.setVisibility(isChecked ? View.VISIBLE : View.GONE);
                values.put("time", isChecked ? 1 : 0);
                break;
            case R.id.switch_date:
                textViewDate.setVisibility(isChecked ? View.VISIBLE : View.GONE);
                values.put("date", isChecked ? 1 : 0);
                break;
            case R.id.switch_week:
                textViewWeek.setVisibility(isChecked ? View.VISIBLE : View.GONE);
                values.put("week", isChecked ? 1 : 0);
                break;
            case R.id.switch_weather1:
                linearLayout1.setVisibility(isChecked ? View.VISIBLE : View.GONE);
                values.put("firstDay", isChecked ? 1 : 0);
                break;
            case R.id.switch_weather2:
                linearLayout2.setVisibility(isChecked ? View.VISIBLE : View.GONE);
                values.put("secondDay", isChecked ? 1 : 0);
                break;
            case R.id.switch_weather3:
                linearLayout3.setVisibility(isChecked ? View.VISIBLE : View.GONE);
                values.put("thirdDay", isChecked ? 1 : 0);
                break;
        }
    }

    @Override
    public void onReceiveLocation(BDLocation bdLocation) {
        String addr = bdLocation.getAddrStr();    //获取详细地址信息
        String country = bdLocation.getCountry();    //获取国家
        String province = bdLocation.getProvince();    //获取省份
        String city = bdLocation.getCity();    //获取城市
        String district = bdLocation.getDistrict();    //获取区县
        String street = bdLocation.getStreet();    //获取街道信息
        _locationTextView.setText(city + district);
        values.put("location", city + district);
        _locationClient.stop();
    }

    @Override
    public void onRequestPermissionsResult(int requestCode, String[] permissions, int[] grantResults) {
        super.onRequestPermissionsResult(requestCode, permissions, grantResults);
        switch (requestCode) {
            //requestCode即所声明的权限获取码,在checkSelfPermission时传入
            case 1:
                BAIDU_READ_PHONE_STATE:
                if (grantResults[0] == PackageManager.PERMISSION_GRANTED) {
                    _locationClient.start();
                } else {
                    Log.i("tag", "onRequestPermissionsResult: " + "没有获取到权限");
                }
                break;
            default:
                break;
        }
    }

    @Override
    public void onItemSelected(AdapterView<?> adapterView, View view, int i, long l) {
        if (spinnerSelected) {
            values.put("num", i + 1);
        } else {
            spinnerSelected = true;
        }
    }

    @Override
    public void onNothingSelected(AdapterView<?> adapterView) {

    }
}

效果图

demo.gif

代码地址

https://github.com/xzjs/t_android

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
  • 序言:七十年代末,一起剥皮案震惊了整个滨河市,随后出现的几起案子,更是在滨河造成了极大的恐慌,老刑警刘岩,带你破解...
    沈念sama阅读 218,204评论 6 506
  • 序言:滨河连续发生了三起死亡事件,死亡现场离奇诡异,居然都是意外死亡,警方通过查阅死者的电脑和手机,发现死者居然都...
    沈念sama阅读 93,091评论 3 395
  • 文/潘晓璐 我一进店门,熙熙楼的掌柜王于贵愁眉苦脸地迎上来,“玉大人,你说我怎么就摊上这事。” “怎么了?”我有些...
    开封第一讲书人阅读 164,548评论 0 354
  • 文/不坏的土叔 我叫张陵,是天一观的道长。 经常有香客问我,道长,这世上最难降的妖魔是什么? 我笑而不...
    开封第一讲书人阅读 58,657评论 1 293
  • 正文 为了忘掉前任,我火速办了婚礼,结果婚礼上,老公的妹妹穿的比我还像新娘。我一直安慰自己,他们只是感情好,可当我...
    茶点故事阅读 67,689评论 6 392
  • 文/花漫 我一把揭开白布。 她就那样静静地躺着,像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上,一...
    开封第一讲书人阅读 51,554评论 1 305
  • 那天,我揣着相机与录音,去河边找鬼。 笑死,一个胖子当着我的面吹牛,可吹牛的内容都是我干的。 我是一名探鬼主播,决...
    沈念sama阅读 40,302评论 3 418
  • 文/苍兰香墨 我猛地睁开眼,长吁一口气:“原来是场噩梦啊……” “哼!你这毒妇竟也来了?” 一声冷哼从身侧响起,我...
    开封第一讲书人阅读 39,216评论 0 276
  • 序言:老挝万荣一对情侣失踪,失踪者是张志新(化名)和其女友刘颖,没想到半个月后,有当地人在树林里发现了一具尸体,经...
    沈念sama阅读 45,661评论 1 314
  • 正文 独居荒郊野岭守林人离奇死亡,尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 37,851评论 3 336
  • 正文 我和宋清朗相恋三年,在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 39,977评论 1 348
  • 序言:一个原本活蹦乱跳的男人离奇死亡,死状恐怖,灵堂内的尸体忽然破棺而出,到底是诈尸还是另有隐情,我是刑警宁泽,带...
    沈念sama阅读 35,697评论 5 347
  • 正文 年R本政府宣布,位于F岛的核电站,受9级特大地震影响,放射性物质发生泄漏。R本人自食恶果不足惜,却给世界环境...
    茶点故事阅读 41,306评论 3 330
  • 文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹,春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 31,898评论 0 22
  • 文/苍兰香墨 我抬头看了看天上的太阳。三九已至,却和暖如春,着一层夹袄步出监牢的瞬间,已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 33,019评论 1 270
  • 我被黑心中介骗来泰国打工, 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留,地道东北人。 一个月前我还...
    沈念sama阅读 48,138评论 3 370
  • 正文 我出身青楼,却偏偏与公主长得像,于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子,可洞房花烛夜当晚...
    茶点故事阅读 44,927评论 2 355