数据存储——LitePal增删改查

先设置数据库

public class Book extends DataSupport{
    private int id;
    private String author;
    private double price;
    private int pages;
    private String name;
    private String press;
    public String getPress() {
        return press;
    }
    public void setPress(String press) {
        this.press = press;
    }
    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;
    }
}

将Book类添加到映射模型列表中，修改litepal.xml代码

 <list>
       <mapping class="com.wangkangli.litepallearn.Book"></mapping> </list>

增加数据库内容

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        Button createDatabase = findViewById(R.id.create_database);
        createDatabase.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Connector.getDatabase();
            }
        });
        Button addData = findViewById(R.id.add_data);
        addData.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Book book = new Book();
                book.setName("JAVA");
                book.setAuthor("Cay");
                book.setPages(700);
                book.setPress("Unknow");
                book.setPrice(119);
                book.save();
            }
        });
    }
}

更新数据

 Button updataData = findViewById(R.id.update_data);
        updataData.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                 Book book = new Book();
                 book.setPrice(20);
                 book.setPress("Anchor");
                 book.updateAll("name=? and author = ?","JAVA","Cay");

            }
        });

删除数据

Button deleteButton = findViewById(R.id.delete_data);
        deleteButton.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Book.deleteAll(Book.class,"price>?","10");
            }
        });

查询数据

queryButton.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Book firstBook = DataSupport.findFirst(Book.class);
                Book lastBook = DataSupport.findLast(Book.class);
                List<Book> books1 = DataSupport.select("name","author").find(Book.class);
                List<Book> books2 = DataSupport.where("pages>?","400").find(Book.class);
                List<Book> books3 = DataSupport.order("price desc").find(Book.class);//desc代表降序 asc或者不写代表升序
                List<Book> books4 = DataSupport.limit(3).find(Book.class);
                List<Book> books5 = DataSupport.limit(3).offset(1).find(Book.class);
                //也可以将这几个组合起来
                List<Book> books = DataSupport.select("name","author")
                        .where("pages>?","400")
                        .order("price desc")
                        .find(Book.class);

            }
        });