数据库框架Litepal极简教程

一：初始化

①在gradle脚本中添加依赖

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

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

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

//添加javabean

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

③在清单文件中配置:

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

④新建javabean

public class Book extends DataSupport {

private int id ;

private int age ;

private String name ;

public Book( int id, int age, String name) {

this . id = id;

this . age = age;

this . name = name;

}

public Book() {

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

二：增删改查如下

/**

* 增添数据

* @param view

*/

public void add(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();

}

/**

* 删除数据

*

* @param v

*/

public void delete(View v) {

//删除指定ID的数据

DataSupport.delete( Book. class , 1 );

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

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

}

/**

* 更新数据

*

* @param v

*/

public void update(View v) {

Book book = new Book();

book.setAge( 20 );

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

}

/**

* 查询数据

*/

public void query(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 );

}