org.greenrobot.greendao.database.Database类的使用及代码示例

x33g5p2x  于2022-01-18 转载在 其他  
字(6.9k)|赞(0)|评价(0)|浏览(189)

本文整理了Java中org.greenrobot.greendao.database.Database类的一些代码示例，展示了Database类的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Database类的具体详情如下：
包路径：org.greenrobot.greendao.database.Database
类名称：Database

Database介绍

[英]Database abstraction used internally by greenDAO.
[中]greenDAO内部使用的数据库抽象。

代码示例

代码示例来源：origin: greenrobot/greenDAO

  1. /** Drops the underlying database table. */
  2. public static void dropTable(Database db, boolean ifExists) {
  3.   String sql = "DROP TABLE " + (ifExists ? "IF EXISTS " : "") + "\"ORDER TRANSACTION GROUP BY\"";
  4.   db.execSQL(sql);
  5. }

代码示例来源：origin: greenrobot/greenDAO

  1. /**
  2.  * Run the given Runnable inside a database transaction. If you except a result, consider callInTx.
  3.  */
  4. public void runInTx(Runnable runnable) {
  5.   db.beginTransaction();
  6.   try {
  7.     runnable.run();
  8.     db.setTransactionSuccessful();
  9.   } finally {
  10.     db.endTransaction();
  11.   }
  12. }

代码示例来源：origin: greenrobot/greenDAO

  1. private long executeInsert(T entity, DatabaseStatement stmt, boolean setKeyAndAttach) {
  2.   long rowId;
  3.   if (db.isDbLockedByCurrentThread()) {
  4.     rowId = insertInsideTx(entity, stmt);
  5.   } else {
  6.     // Do TX to acquire a connection before locking the stmt to avoid deadlocks
  7.     db.beginTransaction();
  8.     try {
  9.       rowId = insertInsideTx(entity, stmt);
  10.       db.setTransactionSuccessful();
  11.     } finally {
  12.       db.endTransaction();
  13.     }
  14.   }
  15.   if (setKeyAndAttach) {
  16.     updateKeyAfterInsertAndAttach(entity, rowId, true);
  17.   }
  18.   return rowId;
  19. }

代码示例来源：origin: greenrobot/greenDAO

  1. public T loadByRowId(long rowId) {
  2.   String[] idArray = new String[]{Long.toString(rowId)};
  3.   Cursor cursor = db.rawQuery(statements.getSelectByRowId(), idArray);
  4.   return loadUniqueAndCloseCursor(cursor);
  5. }

代码示例来源：origin: greenrobot/greenDAO

  1. public DatabaseStatement getCountStatement() {
  2.   if (countStatement == null) {
  3.     String sql = SqlUtils.createSqlCount(tablename);
  4.     countStatement = db.compileStatement(sql);
  5.   }
  6.   return countStatement;
  7. }

代码示例来源：origin: greenrobot/greenDAO

  1. /**
  2.  * Deletes all matching entities without detaching them from the identity scope (aka session/cache). Note that this
  3.  * method may lead to stale entity objects in the session cache. Stale entities may be returned when loaded by
  4.  * their
  5.  * primary key, but not using queries.
  6.  */
  7. public void executeDeleteWithoutDetachingEntities() {
  8.   checkThread();
  9.   Database db = dao.getDatabase();
  10.   if (db.isDbLockedByCurrentThread()) {
  11.     dao.getDatabase().execSQL(sql, parameters);
  12.   } else {
  13.     // Do TX to acquire a connection before locking this to avoid deadlocks
  14.     // Locking order as described in AbstractDao
  15.     db.beginTransaction();
  16.     try {
  17.       dao.getDatabase().execSQL(sql, parameters);
  18.       db.setTransactionSuccessful();
  19.     } finally {
  20.       db.endTransaction();
  21.     }
  22.   }
  23. }

代码示例来源：origin: greenrobot/greenDAO

  1. /** A raw-style query where you can pass any WHERE clause and arguments. */
  2. public List<RelationSource2> queryDeep(String where, String... selectionArg) {
  3.   Cursor cursor = db.rawQuery(getSelectDeep() + where, selectionArg);
  4.   return loadDeepAllAndCloseCursor(cursor);
  5. }

代码示例来源：origin: greenrobot/greenDAO

  1. @Override
  2.   protected DatabaseStatement initialValue() {
  3.     return db.compileStatement("SELECT 42");
  4.   }
  5. };

代码示例来源：origin: greenrobot/greenDAO

  1. /** Creates the underlying database table. */
  2. public static void createTable(Database db, boolean ifNotExists) {
  3.   String constraint = ifNotExists? "IF NOT EXISTS ": "";
  4.   db.execSQL("CREATE TABLE " + constraint + "\"TREE_ENTITY\" (" + //
  5.       "\"_id\" INTEGER PRIMARY KEY ," + // 0: id
  6.       "\"PARENT_ID\" INTEGER);"); // 1: parentId
  7. }

代码示例来源：origin: greenrobot/greenDAO

  1. /** Deletes an entity with the given PK from the database. Currently, only single value PK entities are supported. */
  2. public void deleteByKey(K key) {
  3.   assertSinglePk();
  4.   DatabaseStatement stmt = statements.getDeleteStatement();
  5.   if (db.isDbLockedByCurrentThread()) {
  6.     synchronized (stmt) {
  7.       deleteByKeyInsideSynchronized(key, stmt);
  8.     }
  9.   } else {
  10.     // Do TX to acquire a connection before locking the stmt to avoid deadlocks
  11.     db.beginTransaction();
  12.     try {
  13.       synchronized (stmt) {
  14.         deleteByKeyInsideSynchronized(key, stmt);
  15.       }
  16.       db.setTransactionSuccessful();
  17.     } finally {
  18.       db.endTransaction();
  19.     }
  20.   }
  21.   if (identityScope != null) {
  22.     identityScope.remove(key);
  23.   }
  24. }

代码示例来源：origin: greenrobot/greenDAO

  1. /** Loads all available entities from the database. */
  2. public List<T> loadAll() {
  3.   Cursor cursor = db.rawQuery(statements.getSelectAll(), null);
  4.   return loadAllAndCloseCursor(cursor);
  5. }

代码示例来源：origin: greenrobot/greenDAO

  1. /**
  2.  * Calls the given Callable inside a database transaction and returns the result of the Callable. If you don't
  3.  * except a result, consider runInTx.
  4.  */
  5. public <V> V callInTx(Callable<V> callable) throws Exception {
  6.   db.beginTransaction();
  7.   try {
  8.     V result = callable.call();
  9.     db.setTransactionSuccessful();
  10.     return result;
  11.   } finally {
  12.     db.endTransaction();
  13.   }
  14. }

代码示例来源：origin: greenrobot/greenDAO

  1. public DatabaseStatement getDeleteStatement() {
  2.   if (deleteStatement == null) {
  3.     String sql = SqlUtils.createSqlDelete(tablename, pkColumns);
  4.     DatabaseStatement newDeleteStatement = db.compileStatement(sql);
  5.     synchronized (this) {
  6.       if (deleteStatement == null) {
  7.         deleteStatement = newDeleteStatement;
  8.       }
  9.     }
  10.     if (deleteStatement != newDeleteStatement) {
  11.       newDeleteStatement.close();
  12.     }
  13.   }
  14.   return deleteStatement;
  15. }

代码示例来源：origin: greenrobot/greenDAO

  1. /** Drops the underlying database table. */
  2. public static void dropTable(Database db, boolean ifExists) {
  3.   String sql = "DROP TABLE " + (ifExists ? "IF EXISTS " : "") + "\"AUTOINCREMENT_ENTITY\"";
  4.   db.execSQL(sql);
  5. }

代码示例来源：origin: greenrobot/greenDAO

  1. public void update(T entity) {
  2.   assertSinglePk();
  3.   DatabaseStatement stmt = statements.getUpdateStatement();
  4.   if (db.isDbLockedByCurrentThread()) {
  5.     synchronized (stmt) {
  6.       if (isStandardSQLite) {
  7.         updateInsideSynchronized(entity, (SQLiteStatement) stmt.getRawStatement(), true);
  8.       } else {
  9.         updateInsideSynchronized(entity, stmt, true);
  10.       }
  11.     }
  12.   } else {
  13.     // Do TX to acquire a connection before locking the stmt to avoid deadlocks
  14.     db.beginTransaction();
  15.     try {
  16.       synchronized (stmt) {
  17.         updateInsideSynchronized(entity, stmt, true);
  18.       }
  19.       db.setTransactionSuccessful();
  20.     } finally {
  21.       db.endTransaction();
  22.     }
  23.   }
  24. }

代码示例来源：origin: greenrobot/greenDAO

  1. /** A raw-style query where you can pass any WHERE clause and arguments. */
  2. public List<TreeEntity> queryDeep(String where, String... selectionArg) {
  3.   Cursor cursor = db.rawQuery(getSelectDeep() + where, selectionArg);
  4.   return loadDeepAllAndCloseCursor(cursor);
  5. }

代码示例来源：origin: greenrobot/greenDAO

  1. public static int executeSqlStatementsInTx(Database db, String[] statements) {
  2.   db.beginTransaction();
  3.   try {
  4.     int count = executeSqlStatements(db, statements);
  5.     db.setTransactionSuccessful();
  6.     return count;
  7.   } finally {
  8.     db.endTransaction();
  9.   }
  10. }

代码示例来源：origin: greenrobot/greenDAO

  1. public DatabaseStatement getUpdateStatement() {
  2.   if (updateStatement == null) {
  3.     String sql = SqlUtils.createSqlUpdate(tablename, allColumns, pkColumns);
  4.     DatabaseStatement newUpdateStatement = db.compileStatement(sql);
  5.     synchronized (this) {
  6.       if (updateStatement == null) {
  7.         updateStatement = newUpdateStatement;
  8.       }
  9.     }
  10.     if (updateStatement != newUpdateStatement) {
  11.       newUpdateStatement.close();
  12.     }
  13.   }
  14.   return updateStatement;
  15. }

代码示例来源：origin: greenrobot/greenDAO

  1. /** Drops the underlying database table. */
  2. public static void dropTable(Database db, boolean ifExists) {
  3.   String sql = "DROP TABLE " + (ifExists ? "IF EXISTS " : "") + "\"ABCDEF_ENTITY\"";
  4.   db.execSQL(sql);
  5. }

代码示例来源：origin: greenrobot/greenDAO

  1. /** Executes the query and returns a raw android.database.Cursor. Don't forget to close it. */
  2. public Cursor query() {
  3.   checkThread();
  4.   return dao.getDatabase().rawQuery(sql, parameters);
  5. }

内容来源于网络，如有侵权，请联系作者删除！

Database

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com