1.什么是ORM Lite
orm Lite(Object Relationanl Mapping Lite)是一种用于持久化保存java对象的框架，相对于标准的ORM包来说。
2. Demo
●声明实体类
只有加了@DatabaseField的属性才会被认为是表的一个字段
@DatabaseTable(tableName = "accounts")
public class Account{
@DatabaseField(id = true)
private String name; @DatabaseField(canBeNull = false)
private String password;
Account() {
// all persisted classes must define a no-arg constructor with at least package visibility
} public Account(String name, String password) {
this.name = name;
this.password = password;
} public String getPassword() {
return password;
}
}
●操作数据库类
第一次创建数据库时，会调用onCreate()方法然后创建表
public class DBOpenHelper extends OrmLiteSqliteOpenHelper {
public DBOpenHelper(Context context) {
super(context, "pjq.db", null, 2);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase, ConnectionSource connectionSource) {
try {
TableUtils.createTable(connectionSource,Account.class);
} catch (SQLException e) {
e.printStackTrace();
}
}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, ConnectionSource connectionSource, int i, int i2) {
}
}
●添加对象
Account account = new Account("pjq3","333");
mAccountDao.create(account);
●读取对象
mAccountDao.queryForId("pjq");
●修改对象
mAccountDao.update(account);