安卓SQLite数据库

首先创建一个类继承SQLiteOpenHelper扩展类：

public class MySqliteOpenHelper extends SQLiteOpenHelper {


    public MySqliteOpenHelper(Context context) {
        /*
         * database
         * context上下文
         * name 你创建的数据库的名字
         * factory是一个游标工厂cursor工厂，现在先不用
         * version 是数据库的版本号，最低要求是从1开始，
         */
        super(context, "buba.db", null, 1);
        // TODO Auto-generated constructor stub
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        //创建数据库中的表
        db.execSQL("create table person" +
                "(id integer primary key autoincrement," +
                "name varchar[20]," +
                "number varchar[20]," +
                "gender varchar[10])");
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub

    }

}

在MainActivity中对数据库进行操作：

public class MainActivity extends Activity  implements OnClickListener{
    private Button bt_add;
    private Button bt_delete;
    private Button bt_update;
    private Button bt_query;
    private SQLiteDatabase db;
    private MySqliteOpenHelper myHelper;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        initView();
        initEvent();
    }
    private void initEvent() {
        //给按键添加点击事件
        bt_add.setOnClickListener(this);
        bt_delete.setOnClickListener(this);
        bt_update.setOnClickListener(this);
        bt_query.setOnClickListener(this);
    }
    private void initView() {
    bt_add = (Button) findViewById(R.id.bt_add);
    bt_delete = (Button) findViewById(R.id.bt_delete);
    bt_update = (Button) findViewById(R.id.bt_update);
    bt_query = (Button) findViewById(R.id.bt_query);
    }
    public void createdb(View v){
        myHelper = new MySqliteOpenHelper(MainActivity.this);
        //得到数据库getWritableDatabase
        db = myHelper.getWritableDatabase();
    }
    @Override
    public void onClick(View v) {
        //假如相当进入
        switch (v.getId()) {
        case R.id.bt_add:
            //往数据库里添加数据添加数据
            /*第一个参数：表的名字
             * 第二个参数：直接给null
             * 第三个参数：是一个内容集合set map
             */
            ContentValues values=new ContentValues();
            values.put("name", "小灰灰");
            values.put("number", "13911011011");
            values.put("gender", "男");

            //执行插入的操作
            long insert = db.insert("person", null, values);
            Toast.makeText(MainActivity.this, insert+"", 1).show();
            break;
        case R.id.bt_delete:
            //执行删除的操作
            int delete = db.delete("person", "name=?", new String[]{"小灰灰"});
            Toast.makeText(MainActivity.this, delete+"", 1).show();
            break;
            //执行更改操作
        case R.id.bt_update:
            ContentValues values1=new ContentValues();
            values1.put("name", "小灰灰");
            values1.put("number", "13911011011");
            values1.put("gender", "男");
            int update = db.update("person", values1, "name=?", new String[]{"小灰灰"});
            Toast.makeText(MainActivity.this, update+"", 1).show();
            break;
            //执行查询的操作
        case R.id.bt_query:
            Cursor query = db.query("person", new String[]{"name"}, null, null, null, null, null);
            while (query.moveToNext()) {
                int namedex = query.getColumnIndex("name");
                String string = query.getString(namedex);
                Toast.makeText(MainActivity.this,string , 1).show();
            }
            break;
        }
    }

}
}