欢迎使用CSDN-markdown编辑器

insert()方法

    SQLiteDatabase db = databaseHelper.getReadableDatabase();
    ContentValues values = new ContentValues();
    values.put("news_title", "title1");
    values.put("news_content", "content1");
    db.insert("news_inf", null, values);

update()方法

    SQLiteDatabase db = databaseHelper.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(“name”, “溜溜”);//key为字段名，value为值
    db.update("person", values, "personid=?", new String[]{"1"});
    db.close();

query()方法

    SQLiteDatabase db = databaseHelper.getWritableDatabase();
    Cursor cursor = db.query("person", new String[]{"personid,name,age"}, "name like ?", new String[]{"溜溜"}, null, null, "personid desc", "1,2");
    while (cursor.moveToNext()) {
        int id = cursor.getColumnIndex("id");// 或者使用下面的方法
        int personid = cursor.getInt(0); //获取第一列的值,第一列的索引从0开始
        String name = cursor.getString(1);//获取第二列的值
        int age = cursor.getInt(2);//获取第三列的值
    }
    cursor.close();
    db.close();

delete()方法

SQLiteDatabase db = databaseHelper.getWritableDatabase();
db.delete("person", "name=?", new String[]{"溜溜"});
db.close();