/** * @Title: insertNewLog @Description: insert new log to database * * @param callLog MyCallLog instance * @param recordFlagState is record exists * @param recordState record storage state * @return boolean operation result * @throws */ public boolean insertNewLog( MyCallLog callLog, RecordFlagState recordFlagState, RecordState recordState) { SQLiteDatabase db = dbOpenHelper.getWritableDatabase(); String sql = "INSERT INTO logs (name, number, duration, date, type, uid, record_flag, log_state_flag, record_state_flag) VALUES(?, ?, ?, ?, ?, ?, ?, 0, ?)"; try { db.execSQL( sql, new Object[] { callLog.getName(), callLog.getNumber(), callLog.getDuration(), callLog.getDate(), callLog.getCallType().ordinal(), Check.getCRC32(callLog), recordFlagState.ordinal(), recordState.ordinal() }); } catch (SQLException e) { e.printStackTrace(); return false; } finally { if (db != null && db.isOpen()) { db.close(); } } return true; }
/** * @Title: updateRecordState @Description: update record state * * @param uid the unique id of the record * @param state the state to set * @return boolean operation result * @throws */ public boolean updateRecordState(String uid, RecordState state) { SQLiteDatabase db = dbOpenHelper.getWritableDatabase(); String sql = "UPDATE logs SET record_state_flag = " + state.ordinal() + " WHERE uid = \"" + uid + "\""; try { db.execSQL(sql); } catch (SQLException e) { e.printStackTrace(); return false; } finally { if (db != null && db.isOpen()) { db.close(); } } return true; }