SQLite数据库存储

Update data

Delete data

Query data

MainActivity.class

package com.superxingyun.mydatabasehelper;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {
   
    private MyDatabaseHelper dbHelper;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        dbHelper = new MyDatabaseHelper(this, "Book_Store.db", null, 2);

        Button create_database = (Button) findViewById(R.id.create_database);
        Button add_data = (Button) findViewById(R.id.add_data);
        Button update_data = (Button) findViewById(R.id.update_data);
        Button delete_data = (Button) findViewById(R.id.delete_data);
        Button query_data = (Button) findViewById(R.id.query_data);

        //Create db
        create_database.setOnClickListener(new View.OnClickListener() {