package com.example.lenovo.studyittwo;


import android.content.IntentFilter;
import android.content.SharedPreferences;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.content.*;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
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);
        // 构建MyDatabaseHelper对象，指定数据库名为"BookStore.db、版本号为1,版本号改为2之后则会直接
        dbHelper = new MyDatabaseHelper(this, "BookStore.db", null, 2);
        Button btn_create_database = (Button) findViewById(R.id.creat);
        btn_create_database.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                // 创建或打开一个现有的数据库（已存在则打开，否则创建一个新的）
                dbHelper.getWritableDatabase();
            }
        });
        Button addData= (Button)findViewById(R.id.add);
        addData.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
               SQLiteDatabase db=dbHelper.getWritableDatabase();
               ContentValues values=new ContentValues();
               values.put("name","the fuck code");
               values.put("autuor","fuckers");
               db.insert("Book",null,values);
               values.clear();
               values.put("name","the fuck code");
               values.put("autuor","fuckers");
               db.insert("Category",null,values);
               values.clear();

            }
        });
        Button updataData= (Button)findViewById(R.id.updata);
        updataData.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
               SQLiteDatabase db=dbHelper.getWritableDatabase(