将数据库复制到scard

视乎在android4.4以后没有root的手机不能查看data/data目录，所以有时候创建了数据库但是不能很清晰的查看里面的信息。为了更清晰的查看数据库信息可以选择模拟器，或者将数据库复制到sdcard然后导出到电脑使用sqlitespy查看

下面来个demo

.

1.DBHelper.java

/**
 * Created by tiankonglanlande on 2017/3/8.
 */

public class DBHelper extends SQLiteOpenHelper {
    private static final String TAG = "DBHelper";


    public static final String DB_NAME ="copy.db" ;
    public static final String TB_USER ="user_tb" ;
    private String TB_USER_USERNAME="username";
    private String TB_USER_AGE="age";

    public DBHelper(Context context) {
        super(context,DB_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        Log.e(TAG, "onCreate: ");
        String sql="create table "+TB_USER+"( _id Integer primary key autoincrement," +
                TB_USER_USERNAME+" text," +
                TB_USER_AGE+" Integer" +
                ")";
        db.execSQL(sql);

        // 插入测试数据
        insertData(db);
    }

    private void insertData(SQLiteDatabase db) {
        for (int i=0;i<50;i++){
            ContentValues values=new ContentValues();
            values.put("username","用户"+i);
            values.put("age",10+i);
            long count=db.insert(TB_USER,null,values);
            if (count>0){
                Log.e(TAG, "insertData: 插入第"+i+"条数据");
            }
        }
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        String sql="drop table if exists "+TB_USER;
        db.execSQL(sql);
        onCreate(db);
    }
}
2.CopyDBBiz.java
/**
 * Created by tiankonglanlande on 2017/3/8.
 * 将本应用的数据库复制到sdcard
 */
public class CopyDBBiz {
    private final Context context;
    public static String DataBaseName= DBHelper.DB_NAME;//需要复制到sdcard的数据库名称


    public CopyDBBiz(Context context){
        this.context=context;
        File oldFile=context.getDatabasePath(DataBaseName);
        String oldPath=oldFile.getPath();
        if(Environment.getExternalStorageState().equals(Environment.MEDIA_MOUNTED)){
            String newPath= Environment.getExternalStorageDirectory().getPath()+File.separator+DataBaseName;
            copy(oldPath,newPath);
        }else{
            try {
                throw new Exception("please make sure permision and SdCard exist !");
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

    /**
     * 复制操作
     * @param oldPath
     * @param newPath
     */
    private void copy(String oldPath, String newPath) {
        InputStream in=null;
        OutputStream os=null;
        try {
            //判断文件是否存在
            File oldfile=new File(oldPath);
            File newfile=new File(newPath);
            if (!newfile.exists()){
                newfile.createNewFile();
            }
            if (oldfile!=null){
                in=new FileInputStream(oldPath);
                byte buffer[]=new byte[1024];
                int read=-1;
                os=new FileOutputStream(newPath);
                while((read=in.read(buffer))!=-1){
                    os.write(buffer,0,read);
                }
            }
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            try {
                if (in!=null) in.close();
                if (os!=null) os.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}
3.MainActivity.java
public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        DBHelper helper=new DBHelper(this);
        helper.getWritableDatabase();

        CopyDBBiz copyDBBiz=new CopyDBBiz(this);
    }
}
MainActivity.java创建helper以及调用getWritableDatabase方法是为了促使数据库创建。因为SqliteOpenHelper的onCreate是在
getWritableDatabase，或getReadableDatabase的情况下去调用的

4.添加权限

    <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>
    <uses-permission android:name="android.permission.MOUNT_UNMOUNT_FILESYSTEMS"/>

5.导出到电脑使用sqliteSpy查看效果图：