import android.content.Context;

import net.sqlcipher.database.SQLiteDatabase;

import net.sqlcipher.database.SQLiteOpenHelper;

public class MyDatabaseHelper extends SQLiteOpenHelper {

    public static final String CREATE_TABLE = "create table Book(name text,pages integer)";

    public MyDatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory

            factory, int version) {

        super(context, name, factory, version);

    }

    @Override

    public void onCreate(SQLiteDatabase sqLiteDatabase) {

        sqLiteDatabase.execSQL(CREATE_TABLE);

    }

    @Override

    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }

}

import android.content.ContentValues;

import android.os.Bundle;

import android.support.v4.app.FragmentActivity;

import android.view.View;

import android.widget.Button;

import android.widget.TextView;

import com.sqlcipher.R;

import net.sqlcipher.Cursor;

import net.sqlcipher.database.SQLiteDatabase;

public class Use1Activity extends FragmentActivity implements View.OnClickListener {

    private SQLiteDatabase db;

    private MyDatabaseHelper dbHelper;

    private Button mBtnAdd;

    private Button mBtnQuery;

    private TextView mTvShow;

    private String result;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_use1);

        initView();

    }

    private void initView() {

        SQLiteDatabase.loadLibs(this);

        dbHelper = new MyDatabaseHelper(this, "demo.db", null, 1);

        db = dbHelper.getWritableDatabase("secret_key");

        mBtnAdd = (Button) findViewById(R.id.add_data);

        mBtnQuery = (Button) findViewById(R.id.query_data);

        mTvShow = (TextView) findViewById(R.id.tv_show);

        mBtnAdd.setOnClickListener(this);

        mBtnQuery.setOnClickListener(this);

    }

    @Override

    public void onClick(View v) {

        if (v == mBtnAdd) {

            ContentValues values = new ContentValues();

            values.put("name", "密码");

            values.put("pages", 566);

            db.insert("Book", null, values);

        } else if (v == mBtnQuery) {

            Cursor cursor = db.query("Book", null, null, null, null, null, null);

            if (cursor != null) {

                while (cursor.moveToNext()) {

                    String name = cursor.getString(cursor.getColumnIndex("name"));

                    int pages = cursor.getInt(cursor.getColumnIndex("pages"));

                    result += "book name is " + name + "\n";

                    result += "book pages is " + pages + "\n";

                }

            }

            cursor.close();

            mTvShow.setText(result);

            result = "";

        }

    }

}