private void insertContentValues(ContentValues cv, FormIndex index) { synchronized(mScrollActions) { try { while ( !mScrollActions.isEmpty() ) { ContentValues scv = mScrollActions.removeFirst(); mDb.insert(DATABASE_TABLE, null, scv); } if ( cv != null ) { String idx = ""; if ( index != null ) { idx = getXPath(index); } cv.put(QUESTION,idx); mDb.insert(DATABASE_TABLE, null, cv); } } catch (SQLiteConstraintException e) { System.err.println("Error: " + e.getMessage()); } } }
public boolean update(AppRule appRule) { ContentValues contentValues = new ContentValues(); contentValues.put(natDBHelper.COLUMN_APPNAME, appRule.getPkgName()); contentValues.put(natDBHelper.COLUMN_APPUID, String.valueOf(appRule.getAppUID())); contentValues.put(natDBHelper.COLUMN_ONIONTYPE, appRule.getOnionType()); contentValues.put(natDBHelper.COLUMN_LOCALHOST, appRule.getLocalHost()?1:0); contentValues.put(natDBHelper.COLUMN_LOCALNETWORK, appRule.getLocalNetwork()?1:0); String filter = natDBHelper.COLUMN_APPUID + "=?"; String[] filterArgs = {String.valueOf(appRule.getAppUID())}; SQLiteDatabase db = this.dbHelper.getWritableDatabase(); int nb_row = 0; try { nb_row = db.update(natDBHelper.NAT_TABLE_NAME, contentValues, filter, filterArgs); } catch (SQLiteConstraintException e) { Log.e(TAG, "Constraint exception"); Log.e(TAG, e.getMessage()); } db.close(); return (nb_row == 1); }
public TripRecord startTrip() { final String tag = TAG + ".createRecord()"; try { TripRecord record = new TripRecord(); long rowID = db.insertOrThrow(RECORDS_TABLE, null, getContentValues(record)); record.setID((int) rowID); return record; } catch (SQLiteConstraintException e) { Log.e(tag, "SQLiteConstraintException: " + e.getMessage()); } catch (SQLException e) { Log.e(tag, "SQLException: " + e.getMessage()); } return null; }
/** * DESCRIPTION: * Updates a trip record in the log. * * @param record - the TripRecord to update. * @return boolean flag indicating success/failure (true=success) */ public boolean updateRecord(TripRecord record) { final String tag = TAG + ".updateRecord()"; ASSERT((record.getID() != null), tag, "record id cannot be null"); boolean success = false; try { ContentValues values = getContentValues(record); values.remove(RECORD_ID); String whereClause = RECORD_ID + "=" + record.getID(); int count = db.update(RECORDS_TABLE, values, whereClause, null); success = (count > 0); } catch (SQLiteConstraintException e) { Log.e(tag, "SQLiteConstraintException: " + e.getMessage()); } catch (SQLException e) { Log.e(tag, "SQLException: " + e.getMessage()); } return success; }
Log.i(TAG, "friend_request:insert:EE1:" + e.getMessage());