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);

 

 

 

  源码下载地址：