Package com.github.ddth.dao.jdbc

Interface IJdbcHelper

    • Field Summary

      Fields 
      Modifier and Type Field Description
      static java.lang.String DEFAULT_DATASOURCE
      Name of the "default" data source.

    • Method Summary

      All Methods Instance Methods Abstract Methods Default Methods 
      Modifier and Type Method Description
      boolean commitTransaction​(java.sql.Connection conn)
      Commit a transaction.
      int execute​(java.lang.String sql, java.lang.Object... bindValues)
      Execute a non-SELECT statement.
      int execute​(java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a non-SELECT statement.
      int execute​(java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)
      Execute a non-SELECT statement.
      int execute​(java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a non-SELECT statement.
      <T> java.util.List<T> executeSelect​(IRowMapper<T> rowMapper, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement.
      <T> java.util.List<T> executeSelect​(IRowMapper<T> rowMapper, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement.
      <T> java.util.List<T> executeSelect​(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement.
      <T> java.util.List<T> executeSelect​(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement.
      default java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> executeSelect​(java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement.
      default java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> executeSelect​(java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement.
      default java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> executeSelect​(java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement.
      default java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> executeSelect​(java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(int fetchSize, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return result as a Stream.
      <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.sql.Connection conn, boolean autoCloseConnection, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return result as a Stream.
      <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.sql.Connection conn, boolean autoCloseConnection, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.sql.Connection conn, boolean autoCloseConnection, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.sql.Connection conn, boolean autoCloseConnection, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.sql.Connection conn, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.sql.Connection conn, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return result as a Stream.
      default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn, boolean autoCloseConnection, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn, boolean autoCloseConnection, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn, boolean autoCloseConnection, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn, boolean autoCloseConnection, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn, int fetchSize, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn, int fetchSize, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and return the result as a Stream.
      default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and return the result as a Stream.
      <T> T executeSelectOne​(IRowMapper<T> rowMapper, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and fetch one row.
      <T> T executeSelectOne​(IRowMapper<T> rowMapper, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and fetch one row.
      default <T> T executeSelectOne​(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and fetch one row.
      default <T> T executeSelectOne​(IRowMapper<T> rowMapper, java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and fetch one row.
      default java.util.Map<java.lang.String,​java.lang.Object> executeSelectOne​(java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and fetch one row.
      default java.util.Map<java.lang.String,​java.lang.Object> executeSelectOne​(java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and fetch one row.
      default java.util.Map<java.lang.String,​java.lang.Object> executeSelectOne​(java.sql.Connection conn, java.lang.String sql, java.lang.Object... bindValues)
      Execute a SELECT statement and fetch one row.
      default java.util.Map<java.lang.String,​java.lang.Object> executeSelectOne​(java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Execute a SELECT statement and fetch one row.
      default java.sql.Connection getConnection()
      Obtain a Connection instance from the "default" data source, without transaction (autoCommit=false).
      default java.sql.Connection getConnection​(boolean startTransaction)
      Obtain a Connection instance from the "default" data source, starts a transaction if specified.
      default java.sql.Connection getConnection​(java.lang.String dsName)
      Obtain a Connection instance from the specified data source, without transaction (autoCommit=false).
      java.sql.Connection getConnection​(java.lang.String dsName, boolean startTransaction)
      Obtain a Connection instance from the specified data source, starts a transaction if specified.
      void returnConnection​(java.sql.Connection conn)
      Return a previously obtained Connection via getConnection() or getConnection(boolean).
      boolean rollbackTransaction​(java.sql.Connection conn)
      Rollback a transaction.
      boolean startTransaction​(java.sql.Connection conn)
      Start a transaction.

    • Field Detail

      • DEFAULT_DATASOURCE

        static final java.lang.String DEFAULT_DATASOURCE
        Name of the "default" data source.
        See Also:
        Constant Field Values

    • Method Detail

      • getConnection

        default java.sql.Connection getConnection()
                                   throws DaoException
        Obtain a Connection instance from the "default" data source, without transaction (autoCommit=false).
        Returns:
        Throws:
        DaoException

      • getConnection

        default java.sql.Connection getConnection​(java.lang.String dsName)
                                   throws DaoException
        Obtain a Connection instance from the specified data source, without transaction (autoCommit=false).
        Parameters:
        dsName -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.1

      • getConnection

        default java.sql.Connection getConnection​(boolean startTransaction)
                                   throws DaoException
        Obtain a Connection instance from the "default" data source, starts a transaction if specified.
        Parameters:
        startTransaction -
        Returns:
        Throws:
        DaoException

      • getConnection

        java.sql.Connection getConnection​(java.lang.String dsName,
                                  boolean startTransaction)
                           throws DaoException
        Obtain a Connection instance from the specified data source, starts a transaction if specified.
        Parameters:
        dsName -
        startTransaction -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.1

      • startTransaction

        boolean startTransaction​(java.sql.Connection conn)
                  throws DaoException
        Start a transaction. Has no effect if already in a transaction.
        Parameters:
        conn -
        Returns:
        Throws:
        DaoException

      • commitTransaction

        boolean commitTransaction​(java.sql.Connection conn)
                   throws DaoException
        Commit a transaction. Has no effect if not in a transaction.

        Note: autoCommit is set to true after calling this method.

        Parameters:
        conn -
        Returns:
        Throws:
        DaoException

      • rollbackTransaction

        boolean rollbackTransaction​(java.sql.Connection conn)
                     throws DaoException
        Rollback a transaction. Has no effect if not in a transaction.

        Note: autoCommit is set to true after calling this method.

        Parameters:
        conn -
        Returns:
        Throws:
        DaoException

      • execute

        int execute​(java.lang.String sql,
            java.lang.Object... bindValues)
     throws DaoException
        Execute a non-SELECT statement.
        Parameters:
        sql -
        bindValues - index-based bind values
        Returns:
        DaoException
        Throws:
        DaoException

      • execute

        int execute​(java.lang.String sql,
            java.util.Map<java.lang.String,​?> bindValues)
     throws DaoException
        Execute a non-SELECT statement.
        Parameters:
        sql -
        bindValues - name-based bind values
        Returns:
        DaoException
        Throws:
        DaoException
        Since:
        0.8.0

      • execute

        int execute​(java.sql.Connection conn,
            java.lang.String sql,
            java.lang.Object... bindValues)
     throws DaoException
        Execute a non-SELECT statement.
        Parameters:
        conn -
        sql -
        bindValues - index-based bind values
        Returns:
        number of affected rows
        Throws:
        DaoException

      • execute

        int execute​(java.sql.Connection conn,
            java.lang.String sql,
            java.util.Map<java.lang.String,​?> bindValues)
     throws DaoException
        Execute a non-SELECT statement.
        Parameters:
        conn -
        sql -
        bindValues - name-based bind values
        Returns:
        Throws:
        DaoException

      • executeSelect

        <T> java.util.List<T> executeSelect​(IRowMapper<T> rowMapper,
                                    java.lang.String sql,
                                    java.lang.Object... bindValues)
                             throws DaoException
        Execute a SELECT statement.
        Parameters:
        rowMapper - to map the ResultSet to object
        sql -
        bindValues - index-based bind values
        Returns:
        Throws:
        DaoException

      • executeSelect

        <T> java.util.List<T> executeSelect​(IRowMapper<T> rowMapper,
                                    java.lang.String sql,
                                    java.util.Map<java.lang.String,​?> bindValues)
                             throws DaoException
        Execute a SELECT statement.
        Parameters:
        rowMapper - to map the ResultSet to object
        sql -
        bindValues - name-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelect

        <T> java.util.List<T> executeSelect​(IRowMapper<T> rowMapper,
                                    java.sql.Connection conn,
                                    java.lang.String sql,
                                    java.lang.Object... bindValues)
                             throws DaoException
        Execute a SELECT statement.
        Parameters:
        rowMapper - to map the ResultSet to object
        conn -
        sql -
        bindValues - index-based bind values
        Returns:
        Throws:
        DaoException

      • executeSelect

        <T> java.util.List<T> executeSelect​(IRowMapper<T> rowMapper,
                                    java.sql.Connection conn,
                                    java.lang.String sql,
                                    java.util.Map<java.lang.String,​?> bindValues)
                             throws DaoException
        Execute a SELECT statement.
        Parameters:
        rowMapper - to map the ResultSet to object
        conn -
        sql -
        bindValues - name-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             java.lang.String sql,
                                                             java.lang.Object... bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             int fetchSize,
                                                             java.lang.String sql,
                                                             java.lang.Object... bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             java.sql.Connection conn,
                                                             java.lang.String sql,
                                                             java.lang.Object... bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        conn -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             java.sql.Connection conn,
                                                             boolean autoCloseConnection,
                                                             java.lang.String sql,
                                                             java.lang.Object... bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        conn -
        autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.5.1

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             java.sql.Connection conn,
                                                             int fetchSize,
                                                             java.lang.String sql,
                                                             java.lang.Object... bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        conn -
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                     java.sql.Connection conn,
                                                     boolean autoCloseConnection,
                                                     int fetchSize,
                                                     java.lang.String sql,
                                                     java.lang.Object... bindValues)
                                              throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        conn -
        autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.5.1

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             java.lang.String sql,
                                                             java.util.Map<java.lang.String,​?> bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             int fetchSize,
                                                             java.lang.String sql,
                                                             java.util.Map<java.lang.String,​?> bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             java.sql.Connection conn,
                                                             java.lang.String sql,
                                                             java.util.Map<java.lang.String,​?> bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        conn -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             java.sql.Connection conn,
                                                             boolean autoCloseConnection,
                                                             java.lang.String sql,
                                                             java.util.Map<java.lang.String,​?> bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        conn -
        autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.5.1

      • executeSelectAsStream

        default <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                             java.sql.Connection conn,
                                                             int fetchSize,
                                                             java.lang.String sql,
                                                             java.util.Map<java.lang.String,​?> bindValues)
                                                      throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        conn -
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        <T> java.util.stream.Stream<T> executeSelectAsStream​(IRowMapper<T> rowMapper,
                                                     java.sql.Connection conn,
                                                     boolean autoCloseConnection,
                                                     int fetchSize,
                                                     java.lang.String sql,
                                                     java.util.Map<java.lang.String,​?> bindValues)
                                              throws DaoException
        Execute a SELECT statement and return result as a Stream.
        Parameters:
        rowMapper -
        conn -
        autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.5.1

      • executeSelect

        default java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> executeSelect​(java.lang.String sql,
                                                                                             java.lang.Object... bindValues)
                                                                                      throws DaoException
        Execute a SELECT statement.
        Parameters:
        sql -
        bindValues - index-based bind values
        Returns:
        Throws:
        DaoException

      • executeSelect

        default java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> executeSelect​(java.lang.String sql,
                                                                                             java.util.Map<java.lang.String,​?> bindValues)
                                                                                      throws DaoException
        Execute a SELECT statement.
        Parameters:
        sql -
        bindValues - name-based bind value
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelect

        default java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> executeSelect​(java.sql.Connection conn,
                                                                                             java.lang.String sql,
                                                                                             java.lang.Object... bindValues)
                                                                                      throws DaoException
        Execute a SELECT statement.
        Parameters:
        conn -
        sql -
        bindValues - index-based bind values
        Returns:
        Throws:
        DaoException

      • executeSelect

        default java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> executeSelect​(java.sql.Connection conn,
                                                                                             java.lang.String sql,
                                                                                             java.util.Map<java.lang.String,​?> bindValues)
                                                                                      throws DaoException
        Execute a SELECT statement.
        Parameters:
        conn -
        sql -
        bindValues - name-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.lang.String sql,
                                                                                                              java.lang.Object... bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(int fetchSize,
                                                                                                              java.lang.String sql,
                                                                                                              java.lang.Object... bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn,
                                                                                                              java.lang.String sql,
                                                                                                              java.lang.Object... bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        conn -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn,
                                                                                                              boolean autoCloseConnection,
                                                                                                              java.lang.String sql,
                                                                                                              java.lang.Object... bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        conn -
        autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.5.1

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn,
                                                                                                              int fetchSize,
                                                                                                              java.lang.String sql,
                                                                                                              java.lang.Object... bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        conn -
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn,
                                                                                                              boolean autoCloseConnection,
                                                                                                              int fetchSize,
                                                                                                              java.lang.String sql,
                                                                                                              java.lang.Object... bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        conn -
        autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.5.1

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.lang.String sql,
                                                                                                              java.util.Map<java.lang.String,​?> bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(int fetchSize,
                                                                                                              java.lang.String sql,
                                                                                                              java.util.Map<java.lang.String,​?> bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn,
                                                                                                              java.lang.String sql,
                                                                                                              java.util.Map<java.lang.String,​?> bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        conn -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn,
                                                                                                              boolean autoCloseConnection,
                                                                                                              java.lang.String sql,
                                                                                                              java.util.Map<java.lang.String,​?> bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        conn -
        autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.5.1

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn,
                                                                                                              int fetchSize,
                                                                                                              java.lang.String sql,
                                                                                                              java.util.Map<java.lang.String,​?> bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        conn -
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.3

      • executeSelectAsStream

        default java.util.stream.Stream<java.util.Map<java.lang.String,​java.lang.Object>> executeSelectAsStream​(java.sql.Connection conn,
                                                                                                              boolean autoCloseConnection,
                                                                                                              int fetchSize,
                                                                                                              java.lang.String sql,
                                                                                                              java.util.Map<java.lang.String,​?> bindValues)
                                                                                                       throws DaoException
        Execute a SELECT statement and return the result as a Stream.
        Parameters:
        conn -
        autoCloseConnection - if true the supplied Connection will be automatically closed when the returned Stream closes.
        fetchSize -
        sql -
        bindValues -
        Returns:
        Throws:
        DaoException
        Since:
        0.8.5.1

      • executeSelectOne

        <T> T executeSelectOne​(IRowMapper<T> rowMapper,
                       java.lang.String sql,
                       java.lang.Object... bindValues)
                throws DaoException
        Execute a SELECT statement and fetch one row.
        Parameters:
        rowMapper - to map the ResultSet to object
        sql -
        bindValues - index-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelectOne

        <T> T executeSelectOne​(IRowMapper<T> rowMapper,
                       java.lang.String sql,
                       java.util.Map<java.lang.String,​?> bindValues)
                throws DaoException
        Execute a SELECT statement and fetch one row.
        Parameters:
        rowMapper - to map the ResultSet to object
        sql -
        bindValues - name-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelectOne

        default <T> T executeSelectOne​(IRowMapper<T> rowMapper,
                               java.sql.Connection conn,
                               java.lang.String sql,
                               java.lang.Object... bindValues)
                        throws DaoException
        Execute a SELECT statement and fetch one row.
        Parameters:
        rowMapper - to map the ResultSet to object
        conn -
        sql -
        bindValues - index-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelectOne

        default <T> T executeSelectOne​(IRowMapper<T> rowMapper,
                               java.sql.Connection conn,
                               java.lang.String sql,
                               java.util.Map<java.lang.String,​?> bindValues)
                        throws DaoException
        Execute a SELECT statement and fetch one row.
        Parameters:
        rowMapper - to map the ResultSet to object
        conn -
        sql -
        bindValues - name-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelectOne

        default java.util.Map<java.lang.String,​java.lang.Object> executeSelectOne​(java.lang.String sql,
                                                                                java.lang.Object... bindValues)
                                                                         throws DaoException
        Execute a SELECT statement and fetch one row.
        Parameters:
        sql -
        bindValues - index-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelectOne

        default java.util.Map<java.lang.String,​java.lang.Object> executeSelectOne​(java.lang.String sql,
                                                                                java.util.Map<java.lang.String,​?> bindValues)
                                                                         throws DaoException
        Execute a SELECT statement and fetch one row.
        Parameters:
        sql -
        bindValues - name-based bind value
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelectOne

        default java.util.Map<java.lang.String,​java.lang.Object> executeSelectOne​(java.sql.Connection conn,
                                                                                java.lang.String sql,
                                                                                java.lang.Object... bindValues)
                                                                         throws DaoException
        Execute a SELECT statement and fetch one row.
        Parameters:
        conn -
        sql -
        bindValues - index-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0

      • executeSelectOne

        default java.util.Map<java.lang.String,​java.lang.Object> executeSelectOne​(java.sql.Connection conn,
                                                                                java.lang.String sql,
                                                                                java.util.Map<java.lang.String,​?> bindValues)
                                                                         throws DaoException
        Execute a SELECT statement and fetch one row.
        Parameters:
        conn -
        sql -
        bindValues - name-based bind values
        Returns:
        Throws:
        DaoException
        Since:
        0.8.0