Java SQLiteDatabase.insertWithOnConflict方法代码示例

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
void logBookAccess(int bookId) {
    SQLiteDatabase db = getWritableDatabase();
    ContentValues contentValue = new ContentValues();
    contentValue.put(UserDataDBContract.AccessInformationEntry.COLUMN_NAME_BOOK_ID, bookId);
    db.insertWithOnConflict(UserDataDBContract.AccessInformationEntry.Table_NAME,
            null,
            contentValue,
            SQLiteDatabase.CONFLICT_IGNORE);

    db.execSQL(" UPDATE " +
                    UserDataDBContract.AccessInformationEntry.Table_NAME +
                    " SET " + UserDataDBContract.AccessInformationEntry.COLUMN_ACCESS_COUNT + "=" +
                    UserDataDBContract.AccessInformationEntry.COLUMN_ACCESS_COUNT + "+1" +
                    SQL.WHERE + UserDataDBContract.AccessInformationEntry.COLUMN_NAME_BOOK_ID + "=?",
            new String[]{String.valueOf(bookId)});
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
/**
 * Inclusão em bloco dos logs de utilização de energia.
 */
private int bulkInsertEnergyUseLogs(@NonNull Uri uri, @NonNull ContentValues[] values, SQLiteDatabase sqLiteDatabase) {
    sqLiteDatabase.beginTransaction();
    //Armazenar as datas dos novos logs para atualizar o cache de  utilização de energia.
    Set<Long> setDateUpdated = new TreeSet<>();
    try {
        for (int row = 0; row < values.length; row++) {
            ContentValues value = values[row];
            long insertedResult = sqLiteDatabase.insertWithOnConflict(
                    EnergyUseLogEntry.TABLE_NAME,
                    null,
                    value,
                    SQLiteDatabase.CONFLICT_REPLACE);
            if (insertedResult == -1) {
                throw new SQLException(String.format("The EnergyUseLog content on the row %s It is not valid.", row));
            }
            setDateUpdated.add(value.getAsLong(EnergyUseLogEntry._ID));
        }
        sqLiteDatabase.setTransactionSuccessful();
    } finally {
        sqLiteDatabase.endTransaction();
    }
    //Atualizar o cache de  utilização de energia.
    updateEnergyUseTotalOnCache(setDateUpdated);
    //Notificar a atualização para as Uri relacionadas a tabela EnergyUseLog
    notifyUpdatedEntities(uri);
    return values.length;
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
@Override
public int bulkInsert(@NonNull Uri uri, ContentValues[] values) {

    SQLiteDatabase db = mDbHelper.getWritableDatabase();
    final int match = mUriMatcher.match(uri);
    int returnCount = 0;
    switch (match) {
        case FARMACIAS:
            db.beginTransaction();

            try {
                for (ContentValues value : values) {
                    long _id = db.insertWithOnConflict(DbContract.FarmaciasEntity.TABLE_NAME, null, value, SQLiteDatabase.CONFLICT_REPLACE);
                    if (_id != -1) {
                        returnCount++;
                    }
                }
                db.setTransactionSuccessful();
            } finally {
                db.endTransaction();
            }
            getContext().getContentResolver().notifyChange(uri, null);
            return returnCount;

        default:
            return super.bulkInsert(uri, values);
    }


}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
public boolean insertTimetablePeriod(int id, String startTime, String endTime, String timetableID) {
    SQLiteDatabase db = getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(COL_PERIOD_ID, id);
    contentValues.put(COL_START_TIME, startTime);
    contentValues.put(COL_END_TIME, endTime);
    contentValues.put(COL_TIMETABLE_ID, timetableID);
    long result = db.insertWithOnConflict(TABLE_PERIODS, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE);
    return result != -1;
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
/**
 * Sets the value for the key given, returns true if successful, false otherwise.
 */
/* package */ static boolean setItemImpl(SQLiteDatabase db, String key, String value) {
  ContentValues contentValues = new ContentValues();
  contentValues.put(KEY_COLUMN, key);
  contentValues.put(VALUE_COLUMN, value);

  long inserted = db.insertWithOnConflict(
      TABLE_CATALYST,
      null,
      contentValues,
      SQLiteDatabase.CONFLICT_REPLACE);

  return (-1 != inserted);
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
@Override
public int bulkInsert(@NonNull Uri uri, @NonNull ContentValues[] values) {
    switch (sUriMatcher.match(uri)) {
        case VIDEO: {
            final SQLiteDatabase db = mOpenHelper.getWritableDatabase();
            int returnCount = 0;

            db.beginTransaction();
            try {
                for (ContentValues value : values) {
                    long _id = db.insertWithOnConflict(VideoContract.VideoEntry.TABLE_NAME,
                            null, value, SQLiteDatabase.CONFLICT_REPLACE);
                    if (_id != -1) {
                        returnCount++;
                    }
                }
                db.setTransactionSuccessful();
            } finally {
                db.endTransaction();
            }

            mContentResolver.notifyChange(uri, null);
            return returnCount;
        }
        default: {
            return super.bulkInsert(uri, values);
        }
    }
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
public boolean insertTimetableTeacher(int id, String name, String shortname, int colour, String timetableID) {
    SQLiteDatabase db = getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(COL_TEACHER_ID, id);
    contentValues.put(COL_NAME, name);
    contentValues.put(COL_SHORT_NAME, shortname);
    contentValues.put(COL_COLOUR, colour);
    contentValues.put(COL_TIMETABLE_ID, timetableID);
    long result = db.insertWithOnConflict(TABLE_TEACHERS, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE);
    return result != -1;
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
private void addArtistMetaData(SQLiteDatabase sqLiteDatabase, Artist artist) {
    ContentValues values = new ContentValues();
    values.put(ArtistId, artist.getId());
    values.put(ArtistTitle, artist.getName());
    values.put(ArtistAlbumCount, artist.getAlbumCount());
    values.put(ArtistTrackCount, artist.getTrackCount());
    sqLiteDatabase.insertWithOnConflict(tableName, null, values, SQLiteDatabase.CONFLICT_IGNORE);
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
/**
 * 插入数据，此为同步方法
 */
private void insertSync(List<String> idList, List<String> valueList) {
  SQLiteDatabase db = getWritableDatabase();
  db.beginTransaction();
  for (int i = 0; i < valueList.size(); i++) {
    ContentValues values = new ContentValues();
    values.put(TABLE_KEY_ID, idList.get(i));
    values.put(TABLE_KEY_CONTENT, valueList.get(0));
    db.insertWithOnConflict(tableName, null, values, SQLiteDatabase.CONFLICT_REPLACE);
  }
  db.setTransactionSuccessful();
  db.endTransaction();
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
private void addSongMetaData(SQLiteDatabase sqLiteDatabase, Song song) {
    ContentValues values = new ContentValues();
    values.put(SongId, song.getId());
    values.put(SongTitle, song.getTitle());
    values.put(SongAlbum, song.getAlbum());
    values.put(SongArtist, song.getArtist());
    values.put(SongNumber, song.getTrackNumber());
    values.put(SongPath, song.getmSongPath());
    values.put(SongAlbumId, song.getAlbumId());
    sqLiteDatabase.insertWithOnConflict(tableName, null, values, SQLiteDatabase.CONFLICT_IGNORE);
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
public static void insertUser(int userid, String userName, SqliteTestDbOpenHelper helper) {
    SQLiteDatabase db = helper.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put("userid", userid);
    values.put("username", userName);

    db.insertWithOnConflict("users", null, values,
            SQLiteDatabase.CONFLICT_REPLACE);

    db.close();
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
@Override
public void insertOrUpdateUser(User user) {
    SQLiteDatabase db = mDbHelper.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(COLUMN_NAME_ENTRY_ID, user.getId());
    values.put(COLUMN_NAME_USERNAME, user.getUserName());

    db.insertWithOnConflict(TABLE_NAME, null, values,
            SQLiteDatabase.CONFLICT_REPLACE);

    db.close();
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
public boolean insertTimetableMeta(String timetable_id, long modified) {
    SQLiteDatabase db = getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(COL_TIMETABLE_ID, timetable_id);
    contentValues.put(COL_MODIFIED_MILLIS, modified);
    long result = db.insertWithOnConflict(TABLE_META, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE);
    return result != -1;
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
public boolean insertTimetableForm(int id, String name, String shortname, int teacherid, String timetableID) {
    SQLiteDatabase db = getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(COL_FORM_ID, id);
    contentValues.put(COL_NAME, name);
    contentValues.put(COL_SHORT_NAME, shortname);
    contentValues.put(COL_TEACHER_ID, teacherid);
    contentValues.put(COL_TIMETABLE_ID, timetableID);
    long result = db.insertWithOnConflict(TABLE_FORMS, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE);
    return result != -1;
}
 

import android.database.sqlite.SQLiteDatabase; //导入方法依赖的package包/类
@Nullable
@Override
public Uri insert(@NonNull Uri uri, @Nullable ContentValues values) {
    if(values==null) {
        throw new IllegalArgumentException("Values are null");
    }
    final SQLiteDatabase db=database.getWritableDatabase();
    final MusicMatchEnum matchEnum=matcher.match(uri);
    if(matchEnum.table!=null){
        db.insertWithOnConflict(matchEnum.table,null,values,SQLiteDatabase.CONFLICT_REPLACE);
        notifyChange(uri);
    }
    return null;
}