Java DaoManager類代碼示例

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
private void initDb() throws SQLException {
        // create a connection source to our database
        connectionSource = new JdbcConnectionSource(DATABASE_URL, "sa", "",
                new HsqldbDatabaseType());
        // instantiate the DAO 
        vaultDao = DaoManager.createDao(connectionSource, VaultEntry.class);
        if (!vaultDao.isTableExists()) {
            TableUtils.createTableIfNotExists(connectionSource, VaultEntry.class);
        } else {
            LOG.warning("Found existing DB for VaultEntries. Reusing it!!");
        }

        rawDao = DaoManager.createDao(connectionSource, RawEntry.class);
        if (!rawDao.isTableExists()) {
            TableUtils.createTableIfNotExists(connectionSource, RawEntry.class);
        }
//        TableUtils.createTableIfNotExists(connectionSource, SliceEntry.class);
    }
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
AnkiDatabase(File databaseFile) throws SQLException {
    try {
        //Loading the sqlite drivers
        Class.forName("org.sqlite.JDBC");
    } catch (ClassNotFoundException e) {
        //Should never happen
        throw new SQLException(e);
    }

    //Creating a connection to the database:
    connectionSource = new JdbcConnectionSource("jdbc:sqlite:" + databaseFile.getAbsolutePath());

    //Creating DAOs
    notesDAO  = DaoManager.createDao(connectionSource, DBNote.class);
    cardsDAO  = DaoManager.createDao(connectionSource, DBCard.class);
    configDAO = DaoManager.createDao(connectionSource, DBConfig.class);
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
public AbstractDaoService(Class clazz, SpringConfiguration configuration) {

        try {
            this.clazz = clazz;

            // TODO: let user create it's own database
            connection = DatabaseUtils.getH2OrmliteConnectionPool(configuration.getDatabasePath(),
                    // please do not laugh :)
                    SpringConfiguration.DB_LOGIN, SpringConfiguration.DB_PASSWORD);

            TableUtils.createTableIfNotExists(connection, clazz);

            // instantiate the dao
            dao = DaoManager.createDao(connection, clazz);

        } catch (SQLException e) {
            throw new IllegalStateException(e);
        }
    }
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
/**
     * Initializes the actual database as a {@link JdbcConnectionSource}.
     *
     * @throws SQLException Thrown if the database can not be successfully initialized.
     */
    private void initDb() throws SQLException {
        // create a connection source to our database
        connectionSource = new JdbcConnectionSource(DATABASE_URL, "sa", "",
                new HsqldbDatabaseType());
        // instantiate the DAO
        vaultDao = DaoManager.createDao(connectionSource, VaultEntry.class);
        if (!vaultDao.isTableExists()) {
            TableUtils.createTableIfNotExists(connectionSource, VaultEntry.class);
        } else {
            LOG.warning("Found existing DB for VaultEntries. Reusing it!!");
        }

        rawDao = DaoManager.createDao(connectionSource, RawEntry.class);
        if (!rawDao.isTableExists()) {
            TableUtils.createTableIfNotExists(connectionSource, RawEntry.class);
        }
//        TableUtils.createTableIfNotExists(connectionSource, SliceEntry.class);
    }
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
/**
 * Saves the user data to the database.
 *
 * @param data The user data to save.
 */
private static void save(UserData data) {
    data.setAvatarUrl(data.getAvatarUrl());
    data.setUsername(data.getUsername());

    ZLevels.async.submit(() -> {
        try {
            ConnectionSource source = Database.openConnection();
            if (source == null) return;

            Dao<UserData, String> db = DaoManager.createDao(source, UserData.class);
            db.createOrUpdate(data);
            Database.closeConnection();
        } catch (Exception e) {
            ZLogger.warn("Could not save UserData for " + data.getUserId() + "!");
            e.printStackTrace();
        }
    });
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
/**
 * Deletes this user data from the database and cache.
 */
public void delete() {
    UserData current = this;

    if (cache.containsKey(current.getUserId())) cache.remove(current.getUserId());

    ZLevels.async.submit(() -> {
        try {
            ConnectionSource source = Database.openConnection();
            if (source == null) return;

            Dao<UserData, String> db = DaoManager.createDao(source, UserData.class);

            db.delete(current);

            Database.closeConnection();
        } catch (Exception e) {
            ZLogger.warn("Colud not delete UserData for " + getUserId() + "!");
            e.printStackTrace();
        }
    });
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
/**
 * Gets the user data by userId from the cache and database.
 *
 * @param userId The user id.
 * @return The user data.
 */
public static UserData fromId(String userId) {
    if (cache.containsKey(userId)) {
        return cache.get(userId);
    }
    try {
        ConnectionSource source = Database.openConnection();
        if (source == null) return null;

        Dao<UserData, String> db = DaoManager.createDao(source, UserData.class);

        UserData data = db.queryForEq("userId", userId).get(0);

        Database.closeConnection();

        return data;
    } catch (Exception e) {
        if (e instanceof IndexOutOfBoundsException) {
            return null;
        }

        ZLogger.warn("Could not get UserData for " + userId + "!");
        e.printStackTrace();
        return null;
    }
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
@BeforeClass
public static void setUpTest() throws Exception {
    ServerEventService eventService = new ServerEventService();

    daoProvider = new DataSourceProvider();
    eventService.subscribe(DataSourceInitializedEvent.class, daoProvider);

    DataSourceEventSubscriber daoInitializer = new DataSourceEventSubscriber();
    eventService.subscribe(DeviceDaoCreatedEvent.class, daoInitializer);
    eventService.subscribe(AgentDaoCreatedEvent.class, daoInitializer);

    DataSourceManager dataSourceManager = new DataSourceManager(new DataSourceCallback());
    dataSourceManager.initialize();

    assertNotNull("Initialization of the database failed. ", agentDao);
    // initialize a test agent entry in the data source to attach the devices to
    agentDao.add(TEST_AGENT_ID);

    initializeTestDevices();

    // initialize an OrmLite device DAO to clear the device table after each test
    JdbcConnectionSource connectionSource = new JdbcConnectionSource(Property.DATABASE_URL);
    ormliteDeviceDao = DaoManager.createDao(connectionSource, Device.class);

}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
/**
 * This method obtains a DAO given its Class
 * <p/>
 * Source: https://goo.gl/6LIYy2
 *
 * @param clazz
 *         The DAO class
 * @param <D>
 *         DAO super class
 * @param <T>
 *         Requested DAO class
 *
 * @return The DAO instance
 *
 * @throws SQLException
 */
public <D extends Dao<T, ?>, T> D getDao(Class<T> clazz) throws SQLException {
  // lookup the dao, possibly invoking the cached database config
  Dao<T, ?> dao = DaoManager.lookupDao(connectionSource, clazz);
  if (dao == null) {
    // try to use our new reflection magic
    DatabaseTableConfig<T> tableConfig = DatabaseTableConfigUtil
            .fromClass(connectionSource, clazz);
    if (tableConfig == null) {
      /**
       * Note: We have to do this to get to see if they are using the deprecated
       * annotations like
       * {@link DatabaseFieldSimple}.
       */
      dao = (Dao<T, ?>) DaoManager.createDao(connectionSource, clazz);
    } else {
      dao = (Dao<T, ?>) DaoManager.createDao(connectionSource, tableConfig);
    }
  }

  @SuppressWarnings("unchecked")
  D castDao = (D) dao;
  return castDao;
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
protected DatabaseManager() {
    String databaseUrl = "jdbc:sqlite:halgnu.db";

    try {
        m_connectionSource = new JdbcConnectionSource(databaseUrl);
        
        // Create daos
        m_memberDao = DaoManager.createDao(m_connectionSource, MemberModel.class);
        m_activityDao = DaoManager.createDao(m_connectionSource, ActivityModel.class);

        TableUtils.createTableIfNotExists(m_connectionSource, MemberModel.class);
        TableUtils.createTableIfNotExists(m_connectionSource, ActivityModel.class);

        // Check if tables need to be created
        CheckIfAdminExists();

    } catch (SQLException e) {
        e.printStackTrace();
    }
    
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
@NonNull
public Dao<CachedWebResource, String> getCachedWebResourcesDao() {
    if (cachedWebResourcesDao == null) {
        synchronized (this) {
            if (cachedWebResourcesDao == null) {
                try {
                    cachedWebResourcesDao = DaoManager.createDao(getConnectionSource(), CachedWebResource.class);
                } catch (SQLException e) {
                    Log.e(TAG, "Cannot create DAO", e);
                    throw new RuntimeException(e);
                }
            }
        }
    }
    return cachedWebResourcesDao;
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
@NonNull
public Dao<CachedFeedItem, String> getCachedFeedItemDao() {
    if (cachedFeedItemDao == null) {
        synchronized (this) {
            if (cachedFeedItemDao == null) {
                try {
                    cachedFeedItemDao = DaoManager.createDao(getConnectionSource(), CachedFeedItem.class);
                } catch (SQLException e) {
                    Log.e(TAG, "Cannot create DAO", e);
                    throw new RuntimeException(e);
                }
            }
        }
    }
    return cachedFeedItemDao;
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
@NonNull
public Dao<CachedUser, Integer> getCachedUserDao() {
    if (cachedUserDao == null) {
        synchronized (this) {
            if (cachedUserDao == null) {
                try {
                    cachedUserDao = DaoManager.createDao(getConnectionSource(), CachedUser.class);
                } catch (SQLException e) {
                    Log.e(TAG, "Cannot create DAO", e);
                    throw new RuntimeException(e);
                }
            }
        }
    }
    return cachedUserDao;
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
@NonNull
public Dao<CachedGroup, Integer> getCachedGroupDao() {
    if (cachedGroupDao == null) {
        synchronized (this) {
            if (cachedGroupDao == null) {
                try {
                    cachedGroupDao = DaoManager.createDao(getConnectionSource(), CachedGroup.class);
                } catch (SQLException e) {
                    Log.e(TAG, "Cannot create DAO", e);
                    throw new RuntimeException(e);
                }
            }
        }
    }
    return cachedGroupDao;
}
 

import com.j256.ormlite.dao.DaoManager; //導入依賴的package包/類
@NonNull
public Dao<CachedWebPage, String> getCachedWebPageDao() {
    if (cachedWebPageDao == null) {
        synchronized (this) {
            if (cachedWebPageDao == null) {
                try {
                    cachedWebPageDao = DaoManager.createDao(getConnectionSource(), CachedWebPage.class);
                } catch (SQLException e) {
                    Log.e(TAG, "Cannot create DAO", e);
                    throw new RuntimeException(e);
                }
            }
        }
    }
    return cachedWebPageDao;
}