Android Litepal数据库操作

1.android studio需引入：

compile 'org.litepal.android:core:1.3.2

2 AndroidMainfest.xml  application name属性需定义如下：

android:name="org.litepal.LitePalApplication"

3.新建assert目录，在目录下创建litepal.xml文件 

<?xml version="1.0" encoding="utf-8"?>

<litepal>
    <dbname value="BookStore"></dbname>
    <version value="1"></version>
    <list>
        <mapping class="com.xl.test.Book"></mapping>
    </list>
</litepal>

4.新建模型类Book，必须继承DataSupport

import org.litepal.crud.DataSupport;
public class Book  extends DataSupport{
private  int id;
private  String author;
private double price;
private int pages;
private String name;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getAuthor() {
        return author;
    }

    public void setAuthor(String author) {
        this.author = author;
    }

    public double getPrice() {
        return price;
    }

    public void setPrice(double price) {
        this.price = price;
    }

    public int getPages() {
        return pages;
    }

    public void setPages(int pages) {
        this.pages = pages;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}

5.调用方法

package com.xl.test;

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

import org.litepal.crud.DataSupport;
import org.litepal.tablemanager.Connector;

import java.util.List;

public class MainActivity extends AppCompatActivity {
    public static final String TAG = "MainActivity";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        findViewById(R.id.createtable).setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Connector.getDatabase();
            }
        });

        findViewById(R.id.add).setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Book book = new Book();
                book.setAuthor("王八");
                book.setId(1);
                book.setName("金瓶梅");
                book.setPages(1000);
                book.setPrice(10.00);
                book.save();
            }
        });
        findViewById(R.id.updata).setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Book book = new Book();
                book.setPrice(10.8);
                book.updateAll("name=?and author=?", "金瓶梅", "王八蛋");

            }
        });
        findViewById(R.id.delete).setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                DataSupport.deleteAll(Book.class, "price<?", "15");
            }
        });
        findViewById(R.id.query).setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                List<Book> books = DataSupport.findAll(Book.class);
                for (Book book : books) {
                    Log.d(TAG, book.getAuthor());
                    Log.d(TAG, book.getName());
                    Log.d(TAG, book.getId() + "");
                    Log.d(TAG, book.getPages() + "");
                    Log.d(TAG, book.getPrice() + "");

                }


            }
        });
    }
}

6.select（）方法用于查询那几列的数据，比如只查name和author这两类数据：

List<Book> books = DataSupport.select("name", "author").find(Book.class);

Where()方法用于指定查询的约束条件，例如只查页数大于400的数据：

List<Book> books = DataSupport.where("pages>?","400").find(Book.class);

order（）方法用于指定结果的排序方式，比如查询结果按照书价从高到低排序：

List<Book> books = DataSupport.order("price desc").find(Book.class);

limit() 方法用于指定查询结果的数量，比如只查询表的前三条数量：

List<Book> books = DataSupport.limit(3).find(Book.class);

offset（）方法用于指定查询结果的偏移量，比如查询表的2,3,4，数据：

List<Book> books = DataSupport.limit(3).offset(1).find(Book.class);

Litepal支持原生SQL查询

Cursor cursor = DataSupport.findBySQL("select * from Book where pages>?and " +
        "price>?", "400", "20");