Android 拷贝raw文件夹下面的sqlite数据库文件到SDCard中 然后读取数据库并绑定

 添加权限：<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

 1 package com.tcrj.customer.basesqllite;

import android.app.Activity;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.os.Environment;

import com.tcrj.customer.activity.R;

import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;


/**
 * SqlLite数据库
 * Created by leict on 2016/1/25.
 */
public class SqliteDBHelper {
    private static Context context = null;
    private static SQLiteDatabase mSQLiteDatabase = null;

    public SqliteDBHelper(Context context) {
        this.context = context;
    }

    public static void getSqLiteData() {
        try {
            String DATABASE_PATH = Environment.getExternalStorageDirectory().getAbsolutePath() + "/sqlitedb";
            String DATABASE_FILENAME = "provincialcitydb.db";
            String databaseFilename = DATABASE_PATH + "/" + DATABASE_FILENAME;
            File dir = new File(DATABASE_PATH);
            if (!dir.exists()) {
                dir.mkdir();
                if (!(new File(databaseFilename)).exists()) {
                    InputStream is = context.getResources().openRawResource(R.raw.provincialcitydb);
                    OutputStream fos = new FileOutputStream(databaseFilename);
                    byte[] buffer = new byte[1024];
                    int count = 0;
                    //开始复制ProvincialCityDB.db文件
                    while ((count = is.read(buffer)) > 0) {
                        fos.write(buffer, 0, count);
                    }
                    fos.close();
                    is.close();
                }
                //mSQLiteDatabase = context.openOrCreateDatabase(databaseFilename, Activity.MODE_PRIVATE, null);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        // return mSQLiteDatabase;
    }

    public static String sqlitePath() {
        String DATABASE_PATH = Environment.getExternalStorageDirectory().getAbsolutePath() + "/sqlitedb";
        String DATABASE_FILENAME = "provincialcitydb.db";
        String databaseFilename = DATABASE_PATH + "/" + DATABASE_FILENAME;
        return databaseFilename;
    }
}

Select DataBase

 /**
     * 省
     */
    public void setProvinceData() {
        List<SpinnerEntity> dataList = new ArrayList<>();
        SqliteDBHelper helper = new SqliteDBHelper(context);
        SQLiteDatabase sqldata = SQLiteDatabase.openDatabase(helper.sqlitePath(), null, SQLiteDatabase.OPEN_READWRITE | SQLiteDatabase.CREATE_IF_NECESSARY);
        Cursor cur = sqldata.rawQuery("select * from Province", null);
        if (cur != null) {
            if (cur.moveToFirst()) {
                do {
                    SpinnerEntity entity = new SpinnerEntity();
                    int idValue = cur.getInt(cur.getColumnIndex("id"));
                    String codeValue = cur.getString(cur.getColumnIndex("code"));
                    String nameValue = cur.getString(cur.getColumnIndex("name"));
                    entity.setId(idValue);
                    entity.setCode(codeValue);
                    entity.setSpinnerName(nameValue);
                    dataList.add(entity);
                }
                while (cur.moveToNext());
                cur.close();
            }
        }
        sqldata.close();
        pAdapter = new SpinnerAdapter(context);
        pAdapter.setData(dataList);
        spinnerprovince.setAdapter(pAdapter);
        spinnerprovince.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
            @Override
            public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
                SpinnerEntity entity = (SpinnerEntity) pAdapter.getItem(position);
                setCityData(entity.getCode());
            }

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

            }
        });
    }

    /**
     * 市
     */
    public void setCityData(String code) {
        List<SpinnerEntity> dataList = new ArrayList<>();
        SqliteDBHelper helper = new SqliteDBHelper(context);
        SQLiteDatabase sqldata = SQLiteDatabase.openDatabase(helper.sqlitePath(), null, SQLiteDatabase.OPEN_READWRITE | SQLiteDatabase.CREATE_IF_NECESSARY);
        Cursor cur = sqldata.rawQuery("select * from City", null);
        if (cur != null) {
            if (cur.moveToFirst()) {
                do {
                    SpinnerEntity entity = new SpinnerEntity();
                    int idValue = cur.getInt(cur.getColumnIndex("id"));
                    String codeValue = cur.getString(cur.getColumnIndex("code"));
                    String nameValue = cur.getString(cur.getColumnIndex("name"));
                    String parentId = cur.getString(cur.getColumnIndex("provinceId"));
                    if (code.equals(parentId)) {
                        entity.setId(idValue);
                        entity.setCode(codeValue);
                        entity.setParentId(parentId);
                        entity.setSpinnerName(nameValue);
                        dataList.add(entity);
                    }
                }
                while (cur.moveToNext());
                cur.close();
            }
        }
        sqldata.close();
        cAdapter = new SpinnerAdapter(context);
        cAdapter.setData(dataList);
        spinnercity.setAdapter(cAdapter);
        spinnercity.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
            @Override
            public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
                SpinnerEntity entity = (SpinnerEntity) cAdapter.getItem(position);
                setAreaData(entity.getCode());
            }

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

            }
        });
    }

    /**
     * 区
     */
    public void setAreaData(String code) {
        List<SpinnerEntity> dataList = new ArrayList<>();
        SqliteDBHelper helper = new SqliteDBHelper(context);
        SQLiteDatabase sqldata = SQLiteDatabase.openDatabase(helper.sqlitePath(), null, SQLiteDatabase.OPEN_READWRITE | SQLiteDatabase.CREATE_IF_NECESSARY);
        Cursor cur = sqldata.rawQuery("select * from Area", null);
        if (cur != null) {
            if (cur.moveToFirst()) {
                do {
                    SpinnerEntity entity = new SpinnerEntity();
                    int idValue = cur.getInt(cur.getColumnIndex("id"));
                    String codeValue = cur.getString(cur.getColumnIndex("code"));
                    String nameValue = cur.getString(cur.getColumnIndex("name"));
                    String cityId = cur.getString(cur.getColumnIndex("cityId"));
                    if (code.equals(cityId)) {
                        entity.setId(idValue);
                        entity.setCode(codeValue);
                        entity.setSpinnerName(nameValue);
                        entity.setCityId(cityId);
                        dataList.add(entity);
                    }
                }
                while (cur.moveToNext());
                cur.close();
            }
        }
        sqldata.close();
        aAdapter = new SpinnerAdapter(context);
        aAdapter.setData(dataList);
        spinnerarea.setAdapter(aAdapter);
        spinnerarea.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
            @Override
            public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {

            }

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

            }
        });
    }