1、添加依赖 implementation ‘org.litepal.android:java:3.0.0’
2、创建你的Model类并继承LitepalSupport,并定义一个默认的构造方法(否则在调用updateAll的时候有可能报错),如下所示:
public class Time extends LitePalSupport {
private String title;
private String time;
public Time(String title, String time) {
this.title = title;
this.time = time;
}
//定义默认的构造方法,否则更新数据时会报错
public Time(){
}
public String getTitle() {
return title;
}
public String getTime() {
return time;
}
public void setTitle(String title) {
this.title = title;
}
public void setTime(String time) {
this.time = time;
}
}
3、创建资源文件夹assets,创建文件litepal.xml,如下:
<?xml version="1.0" encoding="utf-8" ?>
<litepal>
<dbname value="Time"></dbname>
<version value="1"></version>
<list>
<mapping class="package com.bing.remoteview.Time"></mapping>
</list>
</litepal>
4、在manifest文件中配置
<manifest>
<application
android:name="org.litepal.LitePalApplication"
...
>
...
</application>
</manifest>
5、初始化Litepal,示例代码在MainActivity的onCreate方法里面进行初始化
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
//初始化Litepal
LitePal.initialize(this);
//创建litepal数据库
LitePal.getDatabase();
6、CRUD操作
(1)插入数据
Album album = new Album();
album.setName("album");
album.setPrice(10.99f);
album.setCover(getCoverImageBytes());
album.save();
(2)更新数据
Album albumToUpdate = LitePal.find(Album.class, 1);
albumToUpdate.setPrice(20.99f); // raise the price
albumToUpdate.save();
Album albumToUpdate = new Album();
albumToUpdate.setPrice(20.99f); // raise the price
albumToUpdate.update(id);
(3)删除数据
LitePal.delete(Song.class, id);
LitePal.deleteAll(Song.class, "duration > ?" , "350");
(4)查询数据
Song song = LitePal.find(Song.class, id);
List<Song> allSongs = LitePal.findAll(Song.class);