- 配置LitePal编辑app/build.gradle文件,在dependencies添加
implementation 'org.litepal.android:java:3.0.0'
- 在app/src/main目录下新建assets目录并在此目录下新建litepal.xml文件
<?xml version="1.0" encoding="UTF-8" ?>
<lite>
<dbname value = "BookStore.db"></dbname>
<version value="2"></version>
<list>
<mapping class = "com.example.litepaltest.Book"></mapping>
<mapping class = "com.example.litepaltest.Category"></mapping>
</list>
</lite>
- MainActivity.java
package com.example.litepaltest;
import androidx.appcompat.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import org.litepal.LitePal;
import org.litepal.crud.LitePalSupport;
import java.util.List;
public class MainActivity extends AppCompatActivity {
//private static String name ="格林童话";
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Button creareDatabase = (Button) findViewById(R.id.create_database);
creareDatabase.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
LitePal.getDatabase();
}
});
Button addData = (Button) findViewById(R.id.add_data);
addData.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
Book book = new Book();
book.setName(name);
book.setAuthor("xiaomig");
book.setPages(500);
book.setPrice(200.00);
book.setPress("null");
book.save();
}
});
Button updateData = (Button) findViewById(R.id.update_data);
updateData.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
// Book book = new Book();
// book.setName("lllll");
// book.setAuthor("xiaomig");
// book.setPages(500);
// book.setPrice(200.00);
// book.setPress("null");
// book.save();
// book.setName("十万个大小联系啊");
// book.save();
Book book = new Book();
book.setPrice(14.95);
book.setPress("dadadada");
book.updateAll("name =? and author = ?","格林童话","xiaomig");
}
});
Button deleteData = (Button) findViewById(R.id.delete_data);
deleteData.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
LitePal.deleteAll(Book.class,"price < ?","15");
}
});
Button queryData = (Button) findViewById(R.id.query_data);
queryData.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
List<Book> books = LitePal.findAll(Book.class);
for(Book book:books){
Log.d("MainActivity", "书名:" + book.getName());
Log.d("MainActivity", "作者:" + book.getAuthor());
Log.d("MainActivity", "页数:" + book.getPages());
Log.d("MainActivity", "价格:" + book.getPrice());
Log.d("MainActivity", "出版社:" + book.getPress());
}
}
});
}
}
- Activity_main.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_width="match_parent"
android:layout_height="match_parent"
>
<Button
android:id="@+id/create_database"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="create database"/>
<Button
android:id="@+id/add_data"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="add data"/>
<Button
android:id="@+id/update_data"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="update"/>
<Button
android:id="@+id/delete_data"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="delete data"/>
<Button
android:id="@+id/query_data"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="query data"/>
</LinearLayout>
- Book.java
package com.example.litepaltest; import org.litepal.crud.LitePalSupport; //注意此处继承是LitePalSupport public class Book extends LitePalSupport { 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; } }
-
Category.java
package com.example.litepaltest;
public class Category {
private int id;
private String catagoryName;
private int catagoryCode;
public void setId(int id) {
this.id = id;
}
public void setCatagoryName(String catagoryName) {
this.catagoryName = catagoryName;
}
public void setCatagoryCode(int catagoryCode) {
this.catagoryCode = catagoryCode;
}
}
- AndroidManifest.xml
<?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.example.litepaltest"> <application android:name="org.litepal.LitePalApplication" android:allowBackup="true" android:icon="@mipmap/ic_launcher" android:label="@string/app_name" android:roundIcon="@mipmap/ic_launcher_round" android:supportsRtl="true" android:theme="@style/AppTheme"> <activity android:name=".MainActivity"> <intent-filter> <action android:name="android.intent.action.MAIN" /> <category android:name="android.intent.category.LAUNCHER" /> </intent-filter> </activity> </application> </manifest>
主要参考第一行代码第二版,其中主要修改相关导入和修改过期继承。