android studio 对内置数据库sqlite操作

• 配置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>

  主要参考第一行代码第二版，其中主要修改相关导入和修改过期继承。