Inserting and updating rows in a SQLite database
suggest changeFirst, you need to open your SQLite database, which can be done as follows:
SQLiteDatabase myDataBase;
String mPath = dbhelper.DATABASE_PATH + dbhelper.DATABASE_NAME;
myDataBase = SQLiteDatabase.openDatabase(mPath, null, SQLiteDatabase.OPEN_READWRITE);
After opening the database, you can easily insert or update rows by using the ContentValues class. The following examples assume that a first name is given by str_edtfname and a last name by str_edtlname. You also need to replace table_name with the name of your table that you want to modify. dbhelper, str_edtfname, str_edtlname, and id are not declared in this snippet.
Inserting data
ContentValues values = new ContentValues();
values.put("First_Name", str_edtfname);
values.put("Last_Name", str_edtlname);
myDataBase.insert("table_name", null, values);
Updating data
ContentValues values = new ContentValues();
values.put("First_Name", str_edtfname);
values.put("Last_Name", str_edtlname);
myDataBase.update("table_name", values, "id" + " = ?", new String[] {id});
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents