ActiveAndroid是一个轻量级的ORM框架，可以以类的方式简单快捷地进行数据库的管理，而无需编写一个单独的SQL语句。
ActiveAndroid git地址
CSDN同步发布
配置
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重新查询一次
