orm Lite的使用

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

 

 

 

  源码下载地址：http://download.csdn.net/detail/panjq882288/5802637