Java DatabaseUtils類代碼示例

import android.database.DatabaseUtils; //導入依賴的package包/類
public static void logTableDump(SQLiteDatabase db, String tablename) {
    Cursor cursor = db.query(tablename, null, null, null, null, null, null);
    try {
        String dump = DatabaseUtils.dumpCursorToString(cursor);
        DaoLog.d(dump);
    } finally {
        cursor.close();
    }
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
/**
 * Get the value of the data column for this Uri. This is useful for
 * MediaStore Uris, and other file-based ContentProviders.
 *
 * @param context The context.
 * @param uri The Uri to query.
 * @param selection (Optional) Filter used in the query.
 * @param selectionArgs (Optional) Selection arguments used in the query.
 * @return The value of the _data column, which is typically a file path.
 * @author paulburke
 */
public static String getDataColumn(Context context, Uri uri, String selection,
								   String[] selectionArgs) {

	Cursor cursor = null;
	final String column = "_data";
	final String[] projection = {
			column
	};

	try {
		cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs,
				null);
		if (cursor != null && cursor.moveToFirst()) {
			if (DEBUG)
				DatabaseUtils.dumpCursor(cursor);

			final int column_index = cursor.getColumnIndexOrThrow(column);
			return cursor.getString(column_index);
		}
	} finally {
		if (cursor != null)
			cursor.close();
	}
	return null;
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
/**
 * Get the value of the data column for this Uri. This is useful for
 * MediaStore Uris, and other file-based ContentProviders.
 *
 * @param context       The context.
 * @param uri           The Uri to query.
 * @param selection     (Optional) Filter used in the query.
 * @param selectionArgs (Optional) Selection arguments used in the query.
 * @return The value of the _data column, which is typically a file path.
 * @author paulburke
 */
public static String getDataColumn(Context context, Uri uri, String selection,
                                   String[] selectionArgs) {

    Cursor cursor = null;
    final String column = "_data";
    final String[] projection = {
            column
    };

    try {
        cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs,
                null);
        if (cursor != null && cursor.moveToFirst()) {
            if (DEBUG)
                DatabaseUtils.dumpCursor(cursor);

            final int column_index = cursor.getColumnIndexOrThrow(column);
            return cursor.getString(column_index);
        }
    } finally {
        if (cursor != null)
            cursor.close();
    }
    return null;
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
private void runSql(String sql) {

        hideSoftwareInput(this, clearEditText);
        response_content_layout.setVisibility(View.VISIBLE);

        //查詢語句跳轉界麵,其他直接顯示結果
        int sqlType = DatabaseUtils.getSqlStatementType(sql);

        if (sqlType == DatabaseUtils.STATEMENT_SELECT) {

            startTableDataActivity(sql);

        } else {

            try {
                int result = SQLManager.getSQLHelper(SqlCommondActivity.this).execSQLStr(sql);
                response_content.setText(result + "");
            } catch (Exception e) {
                e.printStackTrace();
                response_content.setText(e.getMessage());
            }
        }
    }
 

import android.database.DatabaseUtils; //導入依賴的package包/類
/**
 * Used to check if a goal with matching title exists.
 *
 * @param goalTitle the desired title to search for
 * @return true if a goal with matching title is found in table
 */
public boolean doesGoalExist(String goalTitle) {
  // Sanitize goalTitle string before sql query
  goalTitle = DatabaseUtils.sqlEscapeString(goalTitle);

  // Query database for existence of a matching goal title
  Cursor cursor = db.rawQuery(queryGoalTitle + goalTitle + "\"", null);

  // return true if at least one instance of the goal title exists
  if (cursor.getCount() > 0) {
    // Close cursor
    cursor.close();

    // Return true because goal title exists
    return true;
  }

  // Close the cursor
  cursor.close();

  // Return false because goal does not exist
  return false;
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
/**
 * Use of this method is discouraged as it will only update the first existence of any goal that
 * matches the requested goal title.
 * Used to update an existing goal's title in goal table
 *
 * @param goalTitle    original goal title
 * @param newGoalTitle new goal title
 * @return primary key of updated goal, returns -1 if goal does not exist
 */
public long updateGoal(String goalTitle, String newGoalTitle) {
  GoalReader goalReader = new GoalReader(sqlLiteHelper);

  // Use ContentValues to sanitize user defined goalTitle string
  values = new ContentValues();

  // Add new goal title to goal_title field in goal table
  values.put(GoalsEntry.COLUMN_NAME_GOAL_TITLE, newGoalTitle);

  // Check if goal with original title exists in goal table
  // Update goal title in goal table where goal title matches requested title
  if (goalReader.doesGoalExist(goalTitle)) {
    return db.update(GoalsEntry.TABLE_NAME, values, GoalsEntry.COLUMN_NAME_GOAL_TITLE
        + "=\""
        + DatabaseUtils.sqlEscapeString(goalTitle)
        + "\"", null);
  }

  // Return -1 if no goal exists in goal table matching original goal title
  return -1;
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
public static String getDataColumn(Context context, Uri uri, String selection,
									   String[] selectionArgs) {

		Cursor cursor = null;
		final String column = "_data";
		final String[] projection = {
				column
		};

		try {
			cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs,
					null);
			if (cursor != null && cursor.moveToFirst()) {
//				if (DEBUG)
					DatabaseUtils.dumpCursor(cursor);

				final int column_index = cursor.getColumnIndexOrThrow(column);
				return cursor.getString(column_index);
			}
		} finally {
			if (cursor != null)
				cursor.close();
		}
		return null;
	}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
private void ce() {
    SQLiteDatabase openOrCreateDatabase;
    try {
        openOrCreateDatabase = SQLiteDatabase.openOrCreateDatabase(this.iB, null);
    } catch (Exception e) {
        openOrCreateDatabase = null;
    }
    if (openOrCreateDatabase != null) {
        long queryNumEntries = DatabaseUtils.queryNumEntries(openOrCreateDatabase, "wof");
        long queryNumEntries2 = DatabaseUtils.queryNumEntries(openOrCreateDatabase, "bdcltb09");
        boolean z = queryNumEntries > 10000;
        boolean z2 = queryNumEntries2 > 10000;
        if (z || z2) {
            new a().execute(new Boolean[]{Boolean.valueOf(z), Boolean.valueOf(z2)});
        }
        openOrCreateDatabase.close();
    }
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
/**
 * Get the value of the data column for this Uri. This is useful for
 * MediaStore Uris, and other file-based ContentProviders.
 *
 * @param context The context.
 * @param uri The Uri to query.
 * @param selection (Optional) Filter used in the query.
 * @param selectionArgs (Optional) Selection arguments used in the query.
 * @return The value of the _data column, which is typically a file path.
 * @author paulburke
 */
public static String getDataColumn(Context context, Uri uri, String selection,
                                   String[] selectionArgs) {
    Cursor cursor = null;
    final String column = "_data";
    final String[] projection = {
            column
    };
    try {
        cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs,
                null);
        if (cursor != null && cursor.moveToFirst()) {
            if (DEBUG)
                DatabaseUtils.dumpCursor(cursor);
            final int column_index = cursor.getColumnIndexOrThrow(column);
            return cursor.getString(column_index);
        }
    } finally {
        if (cursor != null)
            cursor.close();
    }
    return null;
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
public void update(Ruuvitag ruuvitag) {
    String time = new SimpleDateFormat("dd-MM-yyyy, hh:mm:ss").format(new Date());

    if(Exists(ruuvitag.getId())) {
        ContentValues values = new ContentValues();
        values.put(DBContract.RuuvitagDB.COLUMN_ID, ruuvitag.getId());
        values.put(DBContract.RuuvitagDB.COLUMN_URL, ruuvitag.getUrl());
        values.put(DBContract.RuuvitagDB.COLUMN_RSSI, ruuvitag.getRssi());
        values.put(DBContract.RuuvitagDB.COLUMN_TEMP, ruuvitag.getTemperature());
        values.put(DBContract.RuuvitagDB.COLUMN_HUMI, ruuvitag.getHumidity());
        values.put(DBContract.RuuvitagDB.COLUMN_PRES, ruuvitag.getPressure());
        values.put(DBContract.RuuvitagDB.COLUMN_LAST, time);

        db.update(DBContract.RuuvitagDB.TABLE_NAME, values, "id="+ DatabaseUtils.sqlEscapeString(ruuvitag.getId()), null);
    }
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
public long numTrustedKeys(Account account, String name) {
	SQLiteDatabase db = getReadableDatabase();
	String[] args = {
			account.getUuid(),
			name,
			FingerprintStatus.Trust.TRUSTED.toString(),
			FingerprintStatus.Trust.VERIFIED.toString(),
			FingerprintStatus.Trust.VERIFIED_X509.toString()
	};
	return DatabaseUtils.queryNumEntries(db, SQLiteAxolotlStore.IDENTITIES_TABLENAME,
			SQLiteAxolotlStore.ACCOUNT + " = ?"
					+ " AND " + SQLiteAxolotlStore.NAME + " = ?"
					+ " AND (" + SQLiteAxolotlStore.TRUST + " = ? OR " + SQLiteAxolotlStore.TRUST + " = ? OR " +SQLiteAxolotlStore.TRUST +" = ?)"
					+ " AND " +SQLiteAxolotlStore.ACTIVE + " > 0",
			args
	);
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
/** return the amount of items in the database.
 *
 * @param countDeleted if set to true count will include items marked as deleted
 * @return number of items in the database.
 */
public long getMessageCount(boolean countDeleted, boolean countReplies){
    SQLiteDatabase db = getWritableDatabase();
    if (db != null){
        String query = "";
        if(!countDeleted) {
            query += COL_DELETED + "=" + FALSE;
            if(!countReplies)
                query += " AND ";
        }
        if(!countReplies)
        {
            query += "(" + COL_BIGPARENT + " IS NULL OR " + COL_BIGPARENT + " NOT IN (SELECT " + COL_MESSAGE_ID + " FROM " + TABLE + " WHERE " + COL_DELETED + "=" + FALSE + ") AND " + COL_PARENT + " NOT IN (SELECT " + COL_MESSAGE_ID + " FROM " + TABLE + " WHERE " + COL_DELETED + "=" + FALSE + "))";
        }
        return DatabaseUtils.queryNumEntries(db, TABLE, query);
    }
    return 0;
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
private int executeSql(String sql, Object[] bindArgs) throws SQLException {
    acquireReference();
    try {
        if (DatabaseUtils.getSqlStatementType(sql) == DatabaseUtils.STATEMENT_ATTACH) {
            boolean disableWal = false;
            synchronized (mLock) {
                if (!mHasAttachedDbsLocked) {
                    mHasAttachedDbsLocked = true;
                    disableWal = true;
                }
            }
            if (disableWal) {
                disableWriteAheadLogging();
            }
        }

        SQLiteStatement statement = new SQLiteStatement(this, sql, bindArgs);
        try {
            return statement.executeUpdateDelete();
        } finally {
            statement.close();
        }
    } finally {
        releaseReference();
    }
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
/**
 * Performs special reinterpretation of certain SQL statements such as "BEGIN",
 * "COMMIT" and "ROLLBACK" to ensure that transaction state invariants are
 * maintained.
 *
 * This function is mainly used to support legacy apps that perform their
 * own transactions by executing raw SQL rather than calling {@link #beginTransaction}
 * and the like.
 *
 * @param sql The SQL statement to execute.
 * @param bindArgs The arguments to bind, or null if none.
 * @param connectionFlags The connection flags to use if a connection must be
 * acquired by this operation.  Refer to {@link SQLiteConnectionPool}.
 * @param cancellationSignal A signal to cancel the operation in progress, or null if none.
 * @return True if the statement was of a special form that was handled here,
 * false otherwise.
 *
 * @throws SQLiteException if an error occurs, such as a syntax error
 * or invalid number of bind arguments.
 * @throws OperationCanceledException if the operation was canceled.
 */
private boolean executeSpecial(String sql, Object[] bindArgs, int connectionFlags,
        CancellationSignal cancellationSignal) {
    if (cancellationSignal != null) {
        cancellationSignal.throwIfCanceled();
    }

    final int type = DatabaseUtils.getSqlStatementType(sql);
    switch (type) {
        case DatabaseUtils.STATEMENT_BEGIN:
            beginTransaction(TRANSACTION_MODE_EXCLUSIVE, null, connectionFlags,
                    cancellationSignal);
            return true;

        case DatabaseUtils.STATEMENT_COMMIT:
            setTransactionSuccessful();
            endTransaction(cancellationSignal);
            return true;

        case DatabaseUtils.STATEMENT_ABORT:
            endTransaction(cancellationSignal);
            return true;
    }
    return false;
}
 

import android.database.DatabaseUtils; //導入依賴的package包/類
/**
 * Get the value of the data column for this Uri. This is useful for
 * MediaStore Uris, and other file-based ContentProviders.
 *
 * @param context The context.
 * @param uri The Uri to query.
 * @param selection (Optional) Filter used in the query.
 * @param selectionArgs (Optional) Selection arguments used in the query.
 * @return The value of the _data column, which is typically a file path.
 * @author paulburke
 */
public static String getDataColumn(Context context, Uri uri, String selection,
                                   String[] selectionArgs) {

    Cursor cursor = null;
    final String column = "_data";
    final String[] projection = {
            column
    };

    try {
        cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs,
                null);
        if (cursor != null && cursor.moveToFirst()) {
            if (DEBUG)
                DatabaseUtils.dumpCursor(cursor);

            final int column_index = cursor.getColumnIndexOrThrow(column);
            return cursor.getString(column_index);
        }
    } finally {
        if (cursor != null)
            cursor.close();
    }
    return null;
}