数据库框架Litepal极简教程

一：初始化

①在gradle脚本中添加依赖

dependencies { compile 'org.litepal.android:core:1.4.1'}

②：在main-->assets中新建litepal.xml文件

<?xml version="1.0" encoding="utf-8"?><litepal> <dbnamevalue="demo" /> <versionvalue="1" /> <list>

//添加javabean

<mapping class="com.test.model.Reader" /> </list></litepal>

③在清单文件中配置:

<manifest> <applicationandroid:name="org.litepal.LitePalApplication" ... > ... </application></manifest>

④新建javabean

public classBook extendsDataSupport {

private intid;

private intage;

privateString name;

publicBook(intid, intage, String name) {

this.id= id;

this.age= age;

this.name= name;

}

publicBook() {

}............

二：增删改查如下

/**

* 增添数据

*@paramview

*/

public voidadd(View view) {

Book book =new Book(1,23,"hmc");

Book book1 =new Book(2,24,"hm");

Book book2 =new Book(3,25,"h");

book.save();

book1.save();

book2.save();

}

/**

* 删除数据

*

*@paramv

*/

public voiddelete(View v) {

//删除指定ID的数据

DataSupport.delete(Book.class,1);

//删除满足特定条件的数据

DataSupport.deleteAll(Book.class,"id=?","4");

}

/**

* 更新数据

*

*@paramv

*/

public voidupdate(View v) {

Book book =new Book();

book.setAge(20);

book.updateAll("id=?","1");

}

/**

* 查询数据

*/

public voidquery(View v) {

//查询所有数据

List<Book> books = DataSupport.findAll(Book.class);

//查询第一条

DataSupport.findFirst(Book.class);

//查询最后一条

DataSupport.findLast(Book.class);

//查询满足特定的列,id和age

DataSupport.select("id","age").find(Book.class);

//查询特定条件的数据

List<Book> books1 = DataSupport.where("id=?","1").find(Book.class);

}