Java Database类代码示例

import com.facebook.stetho.inspector.protocol.module.Database; //导入依赖的package包/类
public Database.ExecuteSQLResponse executeSQL(String databaseName, String query, ExecuteResultHandler<Database.ExecuteSQLResponse> handler)
        throws SQLiteException {
    Util.throwIfNull(query);
    Util.throwIfNull(handler);
    SQLiteDatabase database = openDatabase(databaseName);
    try {
        String firstWordUpperCase = getFirstWord(query).toUpperCase();
        switch (firstWordUpperCase) {
            case "UPDATE":
            case "DELETE":
                return executeUpdateDelete(database, query, handler);
            case "INSERT":
                return executeInsert(database, query, handler);
            case "SELECT":
            case "PRAGMA":
            case "EXPLAIN":
                return executeSelect(database, query, handler);
            default:
                return executeRawQuery(database, query, handler);
        }
    } finally {
        database.close();
    }
}
 

import com.facebook.stetho.inspector.protocol.module.Database; //导入依赖的package包/类
public Database.ExecuteSQLResponse executeSQL(
    SqliteDatabaseDescriptor databaseDesc,
    String query,
    ExecuteResultHandler<Database.ExecuteSQLResponse> handler)
        throws SQLiteException {
  Util.throwIfNull(query);
  Util.throwIfNull(handler);
  SQLiteDatabase database = openDatabase(databaseDesc);
  try {
    String firstWordUpperCase = getFirstWord(query).toUpperCase();
    switch (firstWordUpperCase) {
      case "UPDATE":
      case "DELETE":
        return executeUpdateDelete(database, query, handler);
      case "INSERT":
        return executeInsert(database, query, handler);
      case "SELECT":
      case "PRAGMA":
      case "EXPLAIN":
        return executeSelect(database, query, handler);
      default:
        return executeRawQuery(database, query, handler);
    }
  } finally {
    database.close();
  }
}
 

import com.facebook.stetho.inspector.protocol.module.Database; //导入依赖的package包/类
@Override
public Database.ExecuteSQLResponse executeSQL(
    ContentProviderDatabaseDescriptor databaseDesc,
    String query,
    ExecuteResultHandler<Database.ExecuteSQLResponse> handler) throws SQLiteException {

  // resolve table name from query
  String tableName = fetchTableName(query);

  // find the right ContentProviderSchema
  int index = mTableNames.indexOf(tableName);
  ContentProviderSchema contentProviderSchema = mContentProviderSchemas[index];

  // execute the query
  ContentResolver contentResolver = mContext.getContentResolver();
  Cursor cursor = contentResolver.query(
      contentProviderSchema.getUri(),
      contentProviderSchema.getProjection(),
      null,
      null,
      null);
  try {
    return handler.handleSelect(cursor);
  } finally {
    cursor.close();
  }
}
 

import com.facebook.stetho.inspector.protocol.module.Database; //导入依赖的package包/类
@SuppressWarnings("unchecked")
public Database.ExecuteSQLResponse executeSQL(
    StringDatabaseDescriptor database,
    String query,
    ExecuteResultHandler handler) throws SQLiteException {
  return mLegacy.executeSQL(database.name, query, handler);
}
 

import com.facebook.stetho.inspector.protocol.module.Database; //导入依赖的package包/类
/**
 * @deprecated Convert your custom database driver to {@link DatabaseDriver2}.
 */
@Deprecated
public DefaultInspectorModulesBuilder provideDatabaseDriver(Database.DatabaseDriver databaseDriver) {
  provideDatabaseDriver(new DatabaseDriver2Adapter(databaseDriver));
  return this;
}
 

import com.facebook.stetho.inspector.protocol.module.Database; //导入依赖的package包/类
public Iterable<ChromeDevtoolsDomain> finish() {
  provideIfDesired(new Console());
  provideIfDesired(new Debugger());
  DocumentProviderFactory documentModel = resolveDocumentProvider();
  if (documentModel != null) {
    Document document = new Document(documentModel);
    provideIfDesired(new DOM(document));
    provideIfDesired(new CSS(document));
  }
  provideIfDesired(new DOMStorage(mContext));
  provideIfDesired(new HeapProfiler());
  provideIfDesired(new Inspector());
  provideIfDesired(new Network(mContext));
  provideIfDesired(new Page(mContext));
  provideIfDesired(new Profiler());
  provideIfDesired(
      new Runtime(
          mRuntimeRepl != null ?
          mRuntimeRepl :
          new RhinoDetectingRuntimeReplFactory(mContext)));
  provideIfDesired(new Worker());
  if (Build.VERSION.SDK_INT >= DatabaseConstants.MIN_API_LEVEL) {
    Database database = new Database();
    boolean hasSqliteDatabaseDriver = false;
    if (mDatabaseDrivers != null) {
      for (DatabaseDriver2 databaseDriver : mDatabaseDrivers) {
        database.add(databaseDriver);
        if (databaseDriver instanceof SqliteDatabaseDriver) {
          hasSqliteDatabaseDriver = true;
        }
      }
    }
    if (!hasSqliteDatabaseDriver && !mExcludeSqliteDatabaseDriver) {
      database.add(
          new SqliteDatabaseDriver(mContext,
              mDatabaseFilesProvider != null ?
                  mDatabaseFilesProvider :
                  new DefaultDatabaseFilesProvider(mContext),
              new DefaultDatabaseConnectionProvider()));
    }
    provideIfDesired(database);
  }
  return mDelegate.finish();
}
 

import com.facebook.stetho.inspector.protocol.module.Database; //导入依赖的package包/类
public DatabaseDriver2Adapter(Database.DatabaseDriver legacy) {
  super(legacy.getContext());
  mLegacy = legacy;
}