欢迎使用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();