dimanche 19 avril 2015

Implementing WHERE in an SQLite INSERT command - Android Studio

I'm familiar with Oracle SQL/PL, but not with SQLite, I have managed to construct my database, with an addition operation. I was however wondering how I could implement a WHERE condition for adding data later on to a specific row. Here is my addition code:

public void putInformation(DatabaseOperations dop, String name, String pass, String email){
SQLiteDatabase SQ = dop.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(TableData.TableInfo.USER_NAME, name);
cv.put(TableData.TableInfo.USER_PASS, pass);
cv.put(TableData.TableInfo.USER_EMAIL, email);
long k = SQ.insert(TableData.TableInfo.TABLE_NAME,null, cv);
Log.d("Database Operations", "One Raw Inserted");

Aucun commentaire:

Enregistrer un commentaire