框架学习系列二（数据库选型）

来源：互联网发布：大阪酒店推荐知乎编辑：程序博客网时间：2024/06/07 20:28

数据库选型框架

整理常用的数据库框架对比

Ormlite
GreenDao
Sugar
Realm
Sqlbrite

1.接入数据库：ormlite

gradle配置

compile 'com.j256.ormlite:ormlite-android:5.0'

工具类

public class DatabaseHelper extends OrmLiteSqliteOpenHelper {    private static final String TAG = DatabaseHelper.class.getSimpleName();    public static final String DB_NAME = "autotest.db";    private static final int DB_VERSION = 2;    private static DatabaseHelper instance;    public static synchronized DatabaseHelper getHelper() {        if (instance == null) {            synchronized (DatabaseHelper.class) {                if (instance == null) {                    instance = new DatabaseHelper(MyApplication.application);                }            }        }        return instance;    }    private DatabaseHelper(Context context) {//        super(context, DB_NAME, context.getPackageName(), null, DB_VERSION, R.raw.ormlite_config);        super(context, DB_NAME,  null, DB_VERSION);    }    @Override    public void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {        try {            TableUtils.createTable(connectionSource, Repo.class);        } catch (Exception e) {            Log.e(TAG, "onCreate.. exception: "+e);        }    }    @Override    public void onUpgrade(SQLiteDatabase database, ConnectionSource connectionSource, int oldVersion, int newVersion) {        try {            TableUtils.dropTable(connectionSource, Repo.class, true);            onCreate(database, connectionSource);        } catch (SQLException e) {            Log.e(TAG, "onCreate.. exception: "+e);        }    }    /**     * 释放资源     */    @Override    public void close() {        super.close();    }}

实体类需要注解：

@DatabaseTable(tableName = "tb_repo")public class Repo implements Serializable {    @DatabaseField(generatedId = true)    public long keyid;    @DatabaseField(columnName = "id")    public long id;    @DatabaseField(columnName = "name")    public String name;    public Repo(){}    public long getId() {        return id;    }    public String getName() {        return name;    }}

代码调用：

 //删除所有数据TableUtils.clearTable(DatabaseHelper.getHelper().getConnectionSource(), Repo.class);long currtime=System.currentTimeMillis();final Dao<Repo, String> simpleDao= DatabaseHelper.getHelper().getDao(Repo.class);//插入100000条数据simpleDao.callBatchTasks(new Callable<Void>() {public Void call() throws Exception {for (Repo t : list) {simpleDao.create(t);} return null; }});long endtime=System.currentTimeMillis();//查询100000条数据List<Repo> list= simpleDao.queryForAll();long endtime1=System.currentTimeMillis();Log.d(TAG,"db:ormlite=,time="+(endtime-currtime)+",转化list="+(endtime1-endtime)+",ps:size="+list.size());}catch (Exception e){           Log.d(TAG,"db:ormlite="+e.getMessage());}

2.接入数据库：greenDAO

Add the following Gradle configuration to your Android project:

// In your root build.gradle file:buildscript {    repositories {        jcenter()        mavenCentral() // add repository    }    dependencies {        classpath 'com.android.tools.build:gradle:2.3.1'        classpath 'org.greenrobot:greendao-gradle-plugin:3.2.2' // add plugin    }}// In your app projects build.gradle file:apply plugin: 'com.android.application'apply plugin: 'org.greenrobot.greendao' // apply plugindependencies {    compile 'org.greenrobot:greendao:3.2.2' // add library}

实体类：RepoGreen

@Entity(indexes = {        @Index(value = "id,name DESC" , unique = true)})public class RepoGreen  {    @Id    public long keyid;    @NotNull    public long id;    @NotNull    public String name;    public RepoGreen(){}    @Generated(hash = 1374277050)    public RepoGreen(long keyid, long id, @NotNull String name) {        this.keyid = keyid;        this.id = id;        this.name = name;    }    public long getId() {        return id;    }    public String getName() {        return name;    }    public long getKeyid() {        return this.keyid;    }    public void setKeyid(long keyid) {        this.keyid = keyid;    }    public void setId(long id) {        this.id = id;    }    public void setName(String name) {        this.name = name;    }}

调用数据库

DaoMaster.DevOpenHelper helper = new DaoMaster.DevOpenHelper(DbActivity.this, "notes-db");Database db = helper.getWritableDb();DaoSession daoSession = new DaoMaster(db).newSession();RepoGreenDao noteDao = daoSession.getRepoGreenDao();

增删查

//删除所有数据   noteDao.deleteAll();//插入数据 noteDao.insertInTx(Addlist);//查询条数据List<RepoGreen>  list=queryList.list();

3. 接入数据库：sugar

gradle配置：

  //sugar数据库  compile 'com.github.satyan:sugar:1.5'

出现问题：

E:\AndroidDeveloper\AndroidProject\git\Call\Automatic\AutoFramework\src\main\AndroidManifest.xml:13:9-36 Error:    Attribute application@allowBackup value=(false) from AndroidManifest.xml:13:9-36    is also present at [com.github.satyan:sugar:1.3] AndroidManifest.xml:12:9-35 value=(true).    Suggestion: add 'tools:replace="android:allowBackup"' to <application> element at AndroidManifest.xml:11:5-36:19 to override.E:\AndroidDeveloper\AndroidProject\git\Call\Automatic\AutoFramework\src\main\AndroidManifest.xml:14:9-43 Error:    Attribute application@icon value=(@mipmap/ic_launcher) from AndroidManifest.xml:14:9-43    is also present at [com.github.satyan:sugar:1.3] AndroidManifest.xml:13:9-45 value=(@drawable/ic_launcher).    Suggestion: add 'tools:replace="android:icon"' to <application> element at AndroidManifest.xml:11:5-36:19 to override.

解决问题：

AndroidManifest配置修改：

xmlns:tools="http://schemas.android.com/tools"    这个必须添加<manifest xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:tools="http://schemas.android.com/tools"    package="com.doublechina.autoimageload"> tools:replace="android:allowBackup,android:icon"   这个必须添加<application        android:name=".MyApplication"        android:allowBackup="false"        android:icon="@mipmap/ic_launcher"        android:label="@string/app_name"        android:roundIcon="@mipmap/ic_launcher_round"        tools:replace="android:allowBackup,android:icon"        android:supportsRtl="true"        android:theme="@style/AppTheme">        <activity android:name=".ImageActivity">

Application子节点添加：

<meta-data android:name="DATABASE" android:value="sugar_example.db" /><meta-data android:name="VERSION" android:value="2" /><meta-data android:name="QUERY_LOG" android:value="true" /><meta-data android:name="DOMAIN_PACKAGE_NAME" android:value="com.doublechina.autoimageload.entity" />

实体类：

public class RepoSugar extends SugarRecord{    public long keyid;    public long id;    public String name;    public RepoSugar(long keyid, long id,  String name) {        this.keyid = keyid;        this.id = id;        this.name = name;    }}

问题2：

no such table: REPO_SUGAR

解决方案：

2.1以上需要禁用Instant Run

#### 4.数据库：realm 接入使用

Step 1: Add the class path dependency to the project level build.gradle file.

buildscript {    repositories {        jcenter()    }    dependencies {        classpath "io.realm:realm-gradle-plugin:3.1.3"    }}

Step 2: Apply the realm-android plugin to the top of the application level build.gradle file.

apply plugin: 'realm-android'

Step 3:Entity

public class RepoRealm extends RealmObject {    @Ignore    public long keyid;    public long id;    public String name;    public RepoRealm(){}    public RepoRealm(long keyid, long id, String name) {        this.keyid = keyid;        this.id = id;        this.name = name;    }}

Step 4:代码调用

 //初始化 RealmRealm.init(DbActivity.this);Realm realm = Realm.getDefaultInstance();//删除所有数据realm.beginTransaction();realm.deleteAll();realm.commitTransaction();List<RepoRealm> addList=getRealmData();long currtime=System.currentTimeMillis();//插入十万条数据realm.beginTransaction();realm.insertOrUpdate(addList);realm.commitTransaction();long endtime=System.currentTimeMillis();//查询十万条数据RealmQuery<RepoRealm> query = realm.where(RepoRealm.class);List<RepoRealm> list= query.findAll();long endtime1=System.currentTimeMillis();String value="db:Realm=,time="+(endtime-currtime)+",转化list="+(endtime1-endtime)+",ps:size="+list.size();

更多请参考官方api:realm

5.数据库：sqlbrite 接入使用

sqlbrite响应式数据库，执行原生的数据库操作
gradle配置

dependencies {    //sqlbrite    compile 'com.squareup.sqlbrite:sqlbrite:1.1.1'}

工具类

public class DBHelper extends SQLiteOpenHelper {    private static final String DBNAME = "sqlbrite.db";    private static final int CURRENTVERSION = 1;    public static final String USERTABLE = "repoSqlbriteTable";    public DBHelper(Context context) {        super(context, DBNAME, null, CURRENTVERSION);    }    @Override    public void onCreate(SQLiteDatabase db) {        db.execSQL("create table if not exists " + USERTABLE + " ( _id integer primary key, idtest,name);");    }    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {    }}

代码调用

//初始化 Realm SqlBrite sqlBrite = new SqlBrite.Builder().build();DBHelper openHelper = new DBHelper(DbActivity.this); BriteDatabase db = sqlBrite.wrapDatabaseHelper(openHelper, Schedulers.io());//删除所有数据  db.delete(DBHelper.USERTABLE,null);   final long currtime=System.currentTimeMillis();//插入十万条数据 for (int i=0;i<totalLength;i++){                        ContentValues values = new ContentValues();                        values.put("IDTest", i);                        values.put("NAME", "doublechina");                        db.insert(DBHelper.USERTABLE, values);                    }                    final   long endtime=System.currentTimeMillis();                    //查询十万条数据QueryObservable query = db.createQuery(DBHelper.USERTABLE, "SELECT * FROM " + DBHelper.USERTABLE,null);                    query.subscribe(new Action1<SqlBrite.Query>() {                        @Override                        public void call(SqlBrite.Query query) {                            Cursor cursor = query.run();                            List<Repo> list = new ArrayList<Repo>();                            while (cursor.moveToNext()) {                                Repo repo=new Repo();   String username = cursor.getString(cursor.getColumnIndex("name"));   int kid = cursor.getInt(cursor.getColumnIndex("_id")); int idtest = cursor.getInt(cursor.getColumnIndex("idtest"));    repo.setId(idtest);         repo.setName(username);         repo.setKeyid(kid);          list.add(repo);                            }                            cursor.close();                            long endtime1=System.currentTimeMillis();       String value="db:Sqlbrite=,time="+(endtime-currtime)+",转化list="+(endtime1-endtime)+",ps:size="+list.size();                            Log.d(TAG,value);                            Message message=new Message();                            message.what=5;                            message.obj=value;                            handler.sendMessage(message);                        }                    });

数据库性能对比数据

这里写图片描述