Android数据库管理-ActiveAndroid

ActiveAndroid是一个轻量级的ORM框架，可以以类的方式简单快捷地进行数据库的管理，而无需编写一个单独的SQL语句。
ActiveAndroid git地址

配置

1、AndroidManifeset中添加如下配置：

        <application
        ...
        android:name="com.activeandroid.app.Application"
        >

        <meta-data
            android:name="AA_DB_NAME"
            android:value="xxx.db" />
        <meta-data
            android:name="AA_DB_VERSION"
            android:value="7" />

        <meta-data
            android:name="AA_MODELS"
            android:value="com.syd.oden.odendemo.entity.sqltab.LocationTab, com.syd.oden.odendemo.entity.sqltab.MusicFavorTab" />

AA_MODELS为数据库中表的实体类

2、Application继承com.activeandroid.app.Application

public class MyApplication extends com.activeandroid.app.Application {}

或者

public class MyApplication extends SomeLibraryApplication {
    @Override
    public void onCreate() {
        super.onCreate();
        ActiveAndroid.initialize(this);
    }
        @Override
    public void onTerminate() {
        super.onTerminate();
        ActiveAndroid.dispose();
    }
}

3、创建表

@Table(name = "PictureTabs")
public class PictureTab extends Model {
    private static MyLog myLog = new MyLog("[PictureTab] ");

    @Column(name = "dirName")
    String dirName;

    @Column(name = "fileName")
    String fileName;

    @Column(name = "describe")
    String describe;

    @Column(name = "longitude")
    double longitude;

    @Column(name = "latitude")
    double latitude;

    public PictureTab() {
        super();
    }

    public PictureTab(String dirName, String fileName, double longitude, double latitude) {
        super();
        this.dirName = dirName;
        this.fileName = fileName;
        this.longitude = longitude;
        this.latitude = latitude;
    }
}

增删改查

增

       for (int i=0; i<5; i++) {
            DbBlesGroup dbBleGroup = new DbBlesGroup();
            dbBleGroup.groupIndex = i;
            dbBleGroup.groupName = "groupName" + i;
            dbBleGroup.addr = "addr" + i;
            dbBleGroup.name = "name" + i;
            dbBleGroup.save();
        }

查

查出所有

List<DbBlesGroup> dbBleGroupList = new ArrayList<>();
        dbBleGroupList = new Select()
                .from(DbBlesGroup.class)
                .orderBy("groupName ASC")
                .execute();

        for (int i=0; i<dbBleGroupList.size(); i++)
        {
            L.d("dbBleGroupList :" + dbBleGroupList.get(i).groupName);
        }

指定条件查找

List<DbBlesGroup> dbBleGroupList = new ArrayList<>();
        dbBleGroupList = new Select()
                .from(DbBlesGroup.class)
                .where("groupName = ?", "groupName3")
                .orderBy("groupName ASC")
                .execute();

多条件查找

newSelect().from(UserViewTab.class).where("viewId=? and bleAddr=?",viewId,addr).executeSingle();

使用事务(transaction)

ActiveAndroid.beginTransaction();
try {
        for (int i = 0; i < 100; i++) {
            Item item = new Item();
            item.name = "Example " + i;
            item.save();
        }
        ActiveAndroid.setTransactionSuccessful();
}
finally {
        ActiveAndroid.endTransaction();
}

.orderBy(“id DESC”)降序
.orderBy(“id ASC”)升序

删除

new Delete().from(DbBlesGroup.class).where("groupName = ?", "groupName2").execute();

改

new Update(DbBlesGroup.class).set("addr = ?", "123").where("groupName = ?", "groupName2").execute();

也可直接用save修改

注意事项

1、构造方法中记得加入super();

2、在sudio2.2运行报错解决：

erro： 'java.lang.String com.activeandroid.TableInfo.getTableName()' on a null object reference.

关掉Instant Run

3、表中包含另一个表，则保存的时候要先保存另一个表；
发现一个bug，表中包含另一个表，查另一个表里的数据可能有误

 recipeAlarmList.add(RecipeAlarmTab.getById(recipeTab.getRecipeAlarmTab1().getId())); //activeAndroid貌似有bug，故通过ID重新查询一次