Java Handle.select方法代碼示例

本文整理匯總了Java中org.skife.jdbi.v2.Handle.select方法的典型用法代碼示例。如果您正苦於以下問題：Java Handle.select方法的具體用法？Java Handle.select怎麽用？Java Handle.select使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類org.skife.jdbi.v2.Handle的用法示例。

在下文中一共展示了Handle.select方法的9個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: doReadStandard

import org.skife.jdbi.v2.Handle; //導入方法依賴的package包/類
private InputStream doReadStandard(Handle h, String id) {
    List<Map<String, Object>> res = h.select("SELECT data FROM icon_filestore WHERE id=?", id);

    Optional<Blob> blob = res.stream()
        .map(row -> row.get("data"))
        .map(Blob.class::cast)
        .findFirst();

    if (blob.isPresent()) {
        try {
            return blob.get().getBinaryStream();
        } catch (SQLException ex) {
            throw new IconDataAccessException("Unable to read from BLOB", ex);
        }
    }

    return null;
}

開發者ID:syndesisio，項目名稱:syndesis，代碼行數:19，代碼來源:SqlIconFileStore.java

示例2: doReadStandard

import org.skife.jdbi.v2.Handle; //導入方法依賴的package包/類
private InputStream doReadStandard(Handle h, String path) {
    List<Map<String, Object>> res = h.select("SELECT data FROM filestore WHERE path=?", path);

    Optional<Blob> blob = res.stream()
        .map(row -> row.get("data"))
        .map(Blob.class::cast)
        .findFirst();

    if (blob.isPresent()) {
        try {
            return blob.get().getBinaryStream();
        } catch (SQLException ex) {
            throw new ExtensionDataAccessException("Unable to read from BLOB", ex);
        }
    }

    return null;
}

開發者ID:syndesisio，項目名稱:syndesis，代碼行數:19，代碼來源:SqlExtensionFileStore.java

示例3: doReadStandard

import org.skife.jdbi.v2.Handle; //導入方法依賴的package包/類
private InputStream doReadStandard(Handle h, String path) {
    List<Map<String, Object>> res = h.select("SELECT data FROM filestore WHERE path=?", path);

    Optional<Blob> blob = res.stream()
        .map(row -> row.get("data"))
        .map(Blob.class::cast)
        .findFirst();

    if (blob.isPresent()) {
        try {
            return blob.get().getBinaryStream();
        } catch (SQLException ex) {
            throw new FileStoreException("Unable to read from BLOB", ex);
        }
    }

    return null;
}

開發者ID:syndesisio，項目名稱:syndesis-rest，代碼行數:19，代碼來源:SqlFileStore.java

示例4: doReadDerby

import org.skife.jdbi.v2.Handle; //導入方法依賴的package包/類
/**
 * Derby does not allow to read from the blob after the connection has been closed.
 * It also requires an outcome of commit/rollback.
 */
@SuppressWarnings("PMD.EmptyCatchBlock")
private InputStream doReadDerby(String id) {
    Handle h = dbi.open();
    try {
        h.getConnection().setAutoCommit(false);

        List<Map<String, Object>> res = h.select("SELECT data FROM icon_filestore WHERE id=?", id);

        Optional<Blob> blob = res.stream()
            .map(row -> row.get("data"))
            .map(Blob.class::cast)
            .findFirst();

        if (blob.isPresent()) {
            return new HandleCloserInputStream(h, blob.get().getBinaryStream());
        } else {
            h.commit();
            h.close();
            return null;
        }

    } catch (@SuppressWarnings("PMD.AvoidCatchingGenericException") Exception e) {
        // Do cleanup
        try {
            h.rollback();
        } catch (@SuppressWarnings("PMD.AvoidCatchingGenericException") Exception ex) {
            // ignore
        }
        IOUtils.closeQuietly(h);

        throw IconDataAccessException.launderThrowable(e);
    }
}

開發者ID:syndesisio，項目名稱:syndesis，代碼行數:38，代碼來源:SqlIconFileStore.java

示例5: doReadPostgres

import org.skife.jdbi.v2.Handle; //導入方法依賴的package包/類
/**
 * Postgres does not allow to read from the large object after the connection has been closed.
 */
private InputStream doReadPostgres(String id) {
    Handle h = dbi.open();
    try {
        h.getConnection().setAutoCommit(false);

        List<Map<String, Object>> res = h.select("SELECT data FROM icon_filestore WHERE id=?", id);

        Optional<Long> oid = res.stream()
            .map(row -> row.get("data"))
            .map(Long.class::cast)
            .findFirst();

        if (oid.isPresent()) {
            LargeObjectManager lobj = getPostgresConnection(h.getConnection()).getLargeObjectAPI();
            LargeObject obj = lobj.open(oid.get(), LargeObjectManager.READ);
            return new HandleCloserInputStream(h, obj.getInputStream());
        } else {
            h.close();
            return null;
        }

    } catch (SQLException e) {
        IOUtils.closeQuietly(h);
        throw IconDataAccessException.launderThrowable(e);
    }
}

開發者ID:syndesisio，項目名稱:syndesis，代碼行數:30，代碼來源:SqlIconFileStore.java

示例6: doReadDerby

import org.skife.jdbi.v2.Handle; //導入方法依賴的package包/類
/**
 * Derby does not allow to read from the blob after the connection has been closed.
 * It also requires an outcome of commit/rollback.
 */
@SuppressWarnings("PMD.EmptyCatchBlock")
private InputStream doReadDerby(String path) {
    Handle h = dbi.open();
    try {
        h.getConnection().setAutoCommit(false);

        List<Map<String, Object>> res = h.select("SELECT data FROM filestore WHERE path=?", path);

        Optional<Blob> blob = res.stream()
            .map(row -> row.get("data"))
            .map(Blob.class::cast)
            .findFirst();

        if (blob.isPresent()) {
            return new HandleCloserInputStream(h, blob.get().getBinaryStream());
        } else {
            h.commit();
            h.close();
            return null;
        }

    } catch (@SuppressWarnings("PMD.AvoidCatchingGenericException") Exception e) {
        // Do cleanup
        try {
            h.rollback();
        } catch (@SuppressWarnings("PMD.AvoidCatchingGenericException") Exception ex) {
            // ignore
        }
        IOUtils.closeQuietly(h);

        throw ExtensionDataAccessException.launderThrowable(e);
    }
}

開發者ID:syndesisio，項目名稱:syndesis，代碼行數:38，代碼來源:SqlExtensionFileStore.java

示例7: doReadPostgres

import org.skife.jdbi.v2.Handle; //導入方法依賴的package包/類
/**
 * Postgres does not allow to read from the large object after the connection has been closed.
 */
private InputStream doReadPostgres(String path) {
    Handle h = dbi.open();
    try {
        h.getConnection().setAutoCommit(false);

        List<Map<String, Object>> res = h.select("SELECT data FROM filestore WHERE path=?", path);

        Optional<Long> oid = res.stream()
            .map(row -> row.get("data"))
            .map(Long.class::cast)
            .findFirst();

        if (oid.isPresent()) {
            LargeObjectManager lobj = getPostgresConnection(h.getConnection()).getLargeObjectAPI();
            LargeObject obj = lobj.open(oid.get(), LargeObjectManager.READ);
            return new HandleCloserInputStream(h, obj.getInputStream());
        } else {
            h.close();
            return null;
        }

    } catch (SQLException e) {
        IOUtils.closeQuietly(h);
        throw ExtensionDataAccessException.launderThrowable(e);
    }
}

開發者ID:syndesisio，項目名稱:syndesis，代碼行數:30，代碼來源:SqlExtensionFileStore.java

示例8: doReadDerby

import org.skife.jdbi.v2.Handle; //導入方法依賴的package包/類
/**
 * Derby does not allow to read from the blob after the connection has been closed.
 * It also requires an outcome of commit/rollback.
 */
@SuppressWarnings("PMD.EmptyCatchBlock")
private InputStream doReadDerby(String path) {
    Handle h = dbi.open();
    try {
        h.getConnection().setAutoCommit(false);

        List<Map<String, Object>> res = h.select("SELECT data FROM filestore WHERE path=?", path);

        Optional<Blob> blob = res.stream()
            .map(row -> row.get("data"))
            .map(Blob.class::cast)
            .findFirst();

        if (blob.isPresent()) {
            return new HandleCloserInputStream(h, blob.get().getBinaryStream());
        } else {
            h.commit();
            h.close();
            return null;
        }

    } catch (@SuppressWarnings("PMD.AvoidCatchingGenericException") Exception e) {
        // Do cleanup
        try {
            h.rollback();
        } catch (@SuppressWarnings("PMD.AvoidCatchingGenericException") Exception ex) {
            // ignore
        }
        IOUtils.closeQuietly(h);

        throw FileStoreException.launderThrowable(e);
    }
}

開發者ID:syndesisio，項目名稱:syndesis-rest，代碼行數:38，代碼來源:SqlFileStore.java

示例9: doReadPostgres

import org.skife.jdbi.v2.Handle; //導入方法依賴的package包/類
/**
 * Postgres does not allow to read from the large object after the connection has been closed.
 */
private InputStream doReadPostgres(String path) {
    Handle h = dbi.open();
    try {
        h.getConnection().setAutoCommit(false);

        List<Map<String, Object>> res = h.select("SELECT data FROM filestore WHERE path=?", path);

        Optional<Long> oid = res.stream()
            .map(row -> row.get("data"))
            .map(Long.class::cast)
            .findFirst();

        if (oid.isPresent()) {
            LargeObjectManager lobj = getPostgresConnection(h.getConnection()).getLargeObjectAPI();
            LargeObject obj = lobj.open(oid.get(), LargeObjectManager.READ);
            return new HandleCloserInputStream(h, obj.getInputStream());
        } else {
            h.close();
            return null;
        }

    } catch (SQLException e) {
        IOUtils.closeQuietly(h);
        throw FileStoreException.launderThrowable(e);
    }
}

開發者ID:syndesisio，項目名稱:syndesis-rest，代碼行數:30，代碼來源:SqlFileStore.java

注：本文中的org.skife.jdbi.v2.Handle.select方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。