基本使用步骤
1、导入jar包
2、新建Application,初始化ActiveAndroid
public class MyApplication extends Application {
@Override
public void onCreate() {
super.onCreate();
//ActiveAndroid初始化
ActiveAndroid.initialize(this);
}
}
3、在配置文件application中配置
<meta-data
android:name="AA_DB_NAME"
android:value="activeDatabase.db" />
<meta-data
android:name="AA_DB_VERSION"
android:value="1" />
<meta-data android:name="AA_MODELL"
android:value=".entity.Active_Student"/>
android:name=".MyApplication"
4、创建实体类(Column列中不能出现id,id是自己生成的自增长的)
@Table(name = "student")
public class Active_Student extends Model {
@Column(name = "MyId")
public Integer myid;
@Column(name = "Name")
public String name;
public Active_Student() {
super();
}
public Active_Student(Integer myid, String name) {
super();
this.myid = myid;
this.name = name;
}
public String toString(){
return "Active_Student{" +
"name='" + name + '\'' +
", myid=" + myid +
'}';
}
}
5、增删改查使用
增
Active_Student stu = new Active_Student();
stu.name="stu"+1;
stu.myid=1;
stu.save();
删
stu.delete();
改
stu.name="修改";
stu.save();
查(sql语句的having,orderby,limit等都能实现)
new Select().from(table).where(where,whereArg).execute();
数据库版本更新
1、修改配置文件中数据库版本号
<meta-data
android:name="AA_DB_VERSION"
android:value="2" />
2、放版本号.sql的脚本文件(2.sql)
ALTER TABLE student ADD COLUMN Age INTEGER;
eclipse放在assets\migrations\2.sql
Android Studio 放在app\src\main\assets\migrations\2.sql
3、修改实体类
@Table(name = "student")
public class Active_Student extends Model {
@Column(name = "MyId")
public Integer myid;
@Column(name = "Name")
public String name;
@Column(name = "Age")
public Integer age;
public Active_Student() {
super();
}
public Active_Student(Integer myid, String name,Integer age) {
super();
this.myid = myid;
this.name = name;
this.age=age;
}
@Override
public String toString() {
return "Active_Student{" +
"name='" + name + '\'' +
", myid=" + myid +
'}';
}
}