Refine search
- Common ways to obtain SQLiteDatabase
private void myMethod () {SQLiteDatabase s =
SQLiteOpenHelper dbHelper;dbHelper.getWritableDatabase()
WeatherDbHelper dbHelper;dbHelper.getWritableDatabase()
SQLiteOpenHelper dbHelper;dbHelper.getReadableDatabase()
- Smart code suggestions by Codota
}
@Override public void onCreate(SQLiteDatabase db) { db.beginTransaction(); try { db.execSQL(SQL_CREATE_TABLE); db.execSQL(SQL_CREATE_UNIQUE_INDEX); db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
@Override public void onCreate(SQLiteDatabase db) { db.beginTransaction(); try { db.execSQL(SQL_CREATE_TABLE); db.execSQL(SQL_CREATE_UNIQUE_INDEX); db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
@Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { if (newVersion != oldVersion) { db.beginTransaction(); try { db.execSQL(SQL_DELETE_TABLE); db.execSQL(SQL_CREATE_TABLE); db.execSQL(SQL_CREATE_UNIQUE_INDEX); db.setTransactionSuccessful(); } finally { db.endTransaction(); } } }
@Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { if (newVersion != oldVersion) { db.beginTransaction(); try { db.execSQL(SQL_DELETE_TABLE); db.execSQL(SQL_CREATE_TABLE); db.execSQL(SQL_CREATE_UNIQUE_INDEX); db.setTransactionSuccessful(); } finally { db.endTransaction(); } } }
public synchronized void Delete(long id) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { database.delete(PlaybackQueueColumns.NAME, PlaybackQueueColumns.TRACK_ID + " = " + id, null); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
public void delete(String fileName) { SQLiteDatabase sqLiteDatabase = getWritableDatabase(); sqLiteDatabase.beginTransaction(); try { sqLiteDatabase.delete(TABLE_NAME, "FileName=?", new String[]{fileName}); sqLiteDatabase.setTransactionSuccessful(); } finally { sqLiteDatabase.endTransaction(); } }
public synchronized void update(long playlistid, long id, int order) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { ContentValues values = new ContentValues(1); values.put(PlaylistsColumns.TRACK_ORDER, order); database.update(PlaylistsColumns.NAME, values, PlaylistsColumns.PLAYLIST_ID + " = ?" + " AND " + PlaylistsColumns.TRACK_ID + " = ?", new String[]{playlistid + "", id + ""}); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
public synchronized void Insert(MusicTrack track) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { ContentValues values = new ContentValues(2); values.put(PlaybackQueueColumns.TRACK_ID, track.mId); values.put(PlaybackQueueColumns.SOURCE_POSITION, track.mSourcePosition); database.insert(PlaybackQueueColumns.NAME, null, values); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
public synchronized void update(long playlistid, int count) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { ContentValues values = new ContentValues(2); values.put(PlaylistInfoColumns.PLAYLIST_ID, playlistid); //values.put(PlaylistInfoColumns.PLAYLIST_NAME, name); values.put(PlaylistInfoColumns.SONG_COUNT, count); database.update(PlaylistInfoColumns.NAME, values, PlaylistInfoColumns.PLAYLIST_ID + " = " + playlistid, null); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
public synchronized void update(long playlistid, int count, String album) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { ContentValues values = new ContentValues(3); values.put(PlaylistInfoColumns.PLAYLIST_ID, playlistid); values.put(PlaylistInfoColumns.SONG_COUNT, count); values.put(PlaylistInfoColumns.ALBUM_ART, album); database.update(PlaylistInfoColumns.NAME, values, PlaylistInfoColumns.PLAYLIST_ID + " = " + playlistid, null); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
public synchronized void update(long playlistid, long[] ids, int[] order) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { for (int i = 0; i < order.length; i++) { ContentValues values = new ContentValues(1); values.put(PlaylistsColumns.TRACK_ORDER, order[i]); database.update(PlaylistsColumns.NAME, values, PlaylistsColumns.PLAYLIST_ID + " = ?" + " AND " + PlaylistsColumns.TRACK_ID + " = ?", new String[]{playlistid + "", ids[i] + ""}); } database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
/** 用于给外界提供事物开启的模板 */ public void startTransaction(Action action) { lock.lock(); try { database.beginTransaction(); action.call(database); database.setTransactionSuccessful(); } catch (Exception e) { OkLogger.printStackTrace(e); } finally { database.endTransaction(); lock.unlock(); } }
public synchronized void addPlaylist(long playlistid, String name, int count, String albumart, String author) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { ContentValues values = new ContentValues(5); values.put(PlaylistInfoColumns.PLAYLIST_ID, playlistid); values.put(PlaylistInfoColumns.PLAYLIST_NAME, name); values.put(PlaylistInfoColumns.SONG_COUNT, count); values.put(PlaylistInfoColumns.ALBUM_ART, albumart); values.put(PlaylistInfoColumns.AUTHOR, author); database.insert(PlaylistInfoColumns.NAME, null, values); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
private void insert(CacheFileInfo cacheFileInfo) { SQLiteDatabase sqLiteDatabase = getWritableDatabase(); sqLiteDatabase.beginTransaction(); try { ContentValues cv = packData(cacheFileInfo); sqLiteDatabase.insert(TABLE_NAME, null, cv); sqLiteDatabase.setTransactionSuccessful(); } finally { sqLiteDatabase.endTransaction(); } }
public synchronized void addPlaylist(ArrayList<Playlist> playlists) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { for (int i = 0; i < playlists.size(); i++) { ContentValues values = new ContentValues(5); values.put(PlaylistInfoColumns.PLAYLIST_ID, playlists.get(i).id); values.put(PlaylistInfoColumns.PLAYLIST_NAME, playlists.get(i).name); values.put(PlaylistInfoColumns.SONG_COUNT, playlists.get(i).songCount); values.put(PlaylistInfoColumns.ALBUM_ART, playlists.get(i).albumArt); values.put(PlaylistInfoColumns.AUTHOR, playlists.get(i).author); database.insert(PlaylistInfoColumns.NAME, null, values); } database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
@Override public void substitute(@NonNull JobHolder newJob, @NonNull JobHolder oldJob) { db.beginTransaction(); try { remove(oldJob); insert(newJob); db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
/** 更新一条记录 */ public boolean update(ContentValues contentValues, String whereClause, String[] whereArgs) { long start = System.currentTimeMillis(); lock.lock(); try { database.beginTransaction(); database.update(getTableName(), contentValues, whereClause, whereArgs); database.setTransactionSuccessful(); return true; } catch (Exception e) { OkLogger.printStackTrace(e); } finally { database.endTransaction(); lock.unlock(); OkLogger.v(TAG, System.currentTimeMillis() - start + " updateContentValues"); } return false; }
/** 根据条件删除数据库中的数据 */ public boolean delete(String whereClause, String[] whereArgs) { long start = System.currentTimeMillis(); lock.lock(); try { database.beginTransaction(); database.delete(getTableName(), whereClause, whereArgs); database.setTransactionSuccessful(); return true; } catch (Exception e) { OkLogger.printStackTrace(e); } finally { database.endTransaction(); lock.unlock(); OkLogger.v(TAG, System.currentTimeMillis() - start + " delete"); } return false; }
public boolean deleteList(List<Pair<String, String[]>> where) { long start = System.currentTimeMillis(); lock.lock(); try { database.beginTransaction(); for (Pair<String, String[]> pair : where) { database.delete(getTableName(), pair.first, pair.second); } database.setTransactionSuccessful(); return true; } catch (Exception e) { OkLogger.printStackTrace(e); } finally { database.endTransaction(); lock.unlock(); OkLogger.v(TAG, System.currentTimeMillis() - start + " deleteList"); } return false; }
@Override public void syncCacheToDB(List<Integer> idList) throws IOException { final SQLiteDatabase database = sqLiteHelper.getWritableDatabase(); database.beginTransaction(); try { for (Integer id : idList) { syncCacheToDB(id); } database.setTransactionSuccessful(); } finally { database.endTransaction(); } }