数据库的基本操作

package com.example.openhelper;

import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;

public class FirstActivity extends Activity{
    private Button BuliDatabase;
    private Button upData;
    private Button Add;
    private Button Delete;
    private Button Query;
    private MyDbOpenHelp helper;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.first);
        helper = new MyDbOpenHelp(this, "Book.db", null, 1);
        BuliDatabase = (Button) findViewById(R.id.button1);
        BuliDatabase.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                helper.getWritableDatabase();
            }
        });

        Add=(Button) findViewById(R.id.add);
        Add.setOnClickListener(new OnClickListener() {
            @Override
            //添加数据
            public void onClick(View v) {
                SQLiteDatabase db = helper.getWritableDatabase();
                ContentValues values = new ContentValues();
                values.put("name", "计算机导论");
                values.put("author", "张三");
                db.insert("book", null, values);
            }
        });

        upData =(Button) findViewById(R.id.upData);
        upData.setOnClickListener(new OnClickListener() {
            @Override
            //更新数据
            public void onClick(View v) {
                SQLiteDatabase db = helper.getWritableDatabase();
                ContentValues values= new ContentValues();
                values.put("author", "李四");
                db.update("book", values, "name = ?", new String[] {"计算机导论"});
                //update（）方法接收四个参数，第一表名，第二数据，第三对应SQL语句的where部分
                //用？表示一个占字符，第四个是第三个参数中占字符所对应的内容，
                //本条更新语句表示将计算机导论的这本书作者改为李四
            }
        });

        Delete =(Button) findViewById(R.id.Delete);
        Delete.setOnClickListener(new OnClickListener() {
            //删除数据
            @Override
            public void onClick(View v) {
                SQLiteDatabase db = helper.getWritableDatabase();
                db.delete("book", "name =?", new String[]{"计算机导论"});
                //delete（）方法三个参数，第一个表名，第二个删除条件，第三个条件中
                //占位符所指的数据
                //该删除语句意思是删除书名为计算机导论的这条记录
            }
        });

        Query = (Button) findViewById(R.id.Query);
        Query.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                SQLiteDatabase db =helper.getWritableDatabase();
                Cursor cursor = db.query("book", null, null, null, null, null, null);
                if(cursor.moveToFirst()){
                    do{
                        String name = cursor.getString(cursor.getColumnIndex("name"));
                        String author = cursor.getString(cursor.getColumnIndex("author"));

                    }while(cursor.moveToNext());
                }
                cursor.close();
            }
        });

    }

}