sqlist存储

 MyDevicesHandAgainstBrightScreenHelper dbHelper = new MyDevicesHandAgainstBrightScreenHelper(DeviceRaisedHandBrightScreenActivity.this,
                "BookStore2.db", null, 1);
        SQLiteDatabase db = dbHelper.getWritableDatabase();
        Cursor cursor = db.query("Bookk",null,null,null,null,null,null);//查询
        if (cursor.moveToFirst()) {
            do {
                pages = cursor.getString(cursor.getColumnIndex("isRraisHandbrightScreenSwitchOpen"));
                Log.d("TAGa","name"+pages);
            }while(cursor.moveToNext());
        }
        cursor.close();
        //插入
        ContentValues values  =new ContentValues();
                    values.put("isRraisHandbrightScreenSwitchOpen",false);
                    db.insert("Bookk",null,values);
                      deleteDatabase("CREATE_BOOKK.db");//删除数据库

MyDevicesHandAgainstBrightScreenHelper .java

package com.skinod.clocfit.bean;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;

public class MyDevicesHandAgainstBrightScreenHelper extends SQLiteOpenHelper {
    public static final String CREATE_BOOKK = "create table Bookk("
            + "id integer primary key autoincrement,"
//            + "height int,"
//            + "weight int,"
//            + "offScreenTime int,"
//            + "stepTask int,"
            + "isRraisHandbrightScreenSwitchOpen boolean)";
//            + "isHighestRateOpen boolean,"
//            + "highestRate int,"
//            + "isMale boolean,"
//            + "age int,"
//            + "bandLostOpen boolean,"
//            + "isLowestRateOpen boolean,"
//            + "lowestRate int,"
//            + "celsiusFahrenheitValue int,"
//            + "isChinese boolean
            //)";

    private Context mContext;
    public MyDevicesHandAgainstBrightScreenHelper(Context context, String name,
                            SQLiteDatabase.CursorFactory factory, int version) {
        super(context,name,factory,version);
        mContext = context;
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_BOOKK);
        Toast.makeText(mContext,"create database",Toast.LENGTH_SHORT).show();
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("drop table if exists Bookk");
        onCreate(db);

    }
}