litepal开源库的使用

package com.itheima74.litepaltest;

import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.View;

import org.litepal.LitePal;
import org.litepal.crud.DataSupport;

import java.util.List;

/**
 * litepal开源库的使用步骤:
 * 0.github主页:https://github.com/LitePalFramework/LitePal
 * 1.在build.gradle文件中添加依赖:compile 'org.litepal.android:core:1.5.0'
 * 2.创建assets目录,在assets目录下创建litepal.xml
 * 3.Application节点下配置name="org.litepal.LitePalApplication"
 * 4.创建一个javabean
 * 5.在litepal.xml文件list节点下添加<mapping class="com.itheima74.litepaltest.Book" />
 * 6.调用LitePal.getDatabase()创建数据库
 * 7.CRUD操作需要Book extends DataSupport
 */
public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
    }

    // 点击按钮,创建一个数据库
    public void createDatabase(View view) {
        LitePal.getDatabase();
    }

    // 点击按钮,插入数据
    public void insert(View view) {
        Book book = new Book();
        book.name = "The Da Vince Code";
        book.author = "Dan Brown";
        book.pages = 454;
        book.price = 16.96;
        book.press = "UnKnow";
        book.save();
    }

    // 点击按钮,删除数据
    public void delete(View view) {
        DataSupport.deleteAll(Book.class, "price < ?", "15");
    }

    // 点击按钮,更新数据
    public void update(View view) {
        Book book = new Book();
        book.price = 14.95;
        book.press = "Author";
        book.updateAll("name = ? and author = ?", "The Da Vince Code", "Dan Brown");
    }

    // 点击按钮,查询数据
    public void query(View view) {
        List<Book> bookList = DataSupport.findAll(Book.class);
        for (Book book : bookList) {
            System.out.println(book);
        }
    }
}

package com.itheima74.litepaltest;

import org.litepal.crud.DataSupport;

import static android.R.attr.id;

/**
 * Created by My on 2017/3/10.
 */
class Book extends DataSupport {
    int _id;
    String author;
    double price;
    int pages;
    String name;
    String press;//出版社

    @Override
    public String toString() {
        return "Book{" +
                "id=" + id +
                ", author='" + author + '\'' +
                ", price=" + price +
                ", pages=" + pages +
                ", name='" + name + '\'' +
                ", press='" + press + '\'' +
                '}';
    }
}

<?xml version="1.0" encoding="utf-8"?>
<litepal>
    <dbname value="BookStore" />
    <version value="2" />
    <list>
        <mapping class="com.itheima74.litepaltest.Book" />
        <mapping class="com.itheima74.litepaltest.Category" />
    </list>
</litepal>