Java ResultSet.getStatement方法代碼示例

import java.sql.ResultSet; //導入方法依賴的package包/類
/**
    * Extract the Large Object Input Stream from PostgreSQL
    * 
    * @param resultSet
    *            the Result Set to extract the blob from
    * @param columnIndex
    *            the index of column
    * @return the Large Object Input Stream from PostgreSQL
    * @throws SQLException
    */
   public static InputStream getPostgreSqlnputStream(ResultSet resultSet,
    int columnIndex) throws SQLException {
InputStream in;
Statement statement = resultSet.getStatement();
Connection conn = statement.getConnection();

// Get the Large Object Manager to perform operations with
LargeObjectManager lobj = ((org.postgresql.PGConnection) conn)
	.getLargeObjectAPI();
long oid = resultSet.getLong(columnIndex);

if (oid < 1) {
    return null;
}

LargeObject obj = lobj.open(oid, LargeObjectManager.READ);

in = obj.getInputStream();
return in;
   }
 

import java.sql.ResultSet; //導入方法依賴的package包/類
@Override
public void register(ResultSet resultSet, Statement statement) {
	if ( statement == null ) {
		try {
			statement = resultSet.getStatement();
		}
		catch ( SQLException e ) {
			throw exceptionHelper.convert( e, "unable to access statement from resultset" );
		}
	}
	if ( statement != null ) {
		LOG.tracev( "Registering result set [{0}]", resultSet );
		Set<ResultSet> resultSets = xref.get( statement );
		if ( resultSets == null ) {
			LOG.unregisteredStatement();
		}
		if ( resultSets == null || resultSets == EMPTY_RESULTSET ) {
			resultSets = new HashSet<ResultSet>();
			xref.put( statement, resultSets );
		}
		resultSets.add( resultSet );
	}
	else {
		unassociatedResultSets.add( resultSet );
	}
}
 

import java.sql.ResultSet; //導入方法依賴的package包/類
/**
 * Close connection
 *
 * @param rs
 */
public static void close(ResultSet rs) {
    Statement st = null;
    Connection con = null;
    try {
        try {
            if (rs != null) {
                st = rs.getStatement();
                rs.close();
            }
        } finally {
            try {
                if (st != null) {
                    con = st.getConnection();
                    st.close();
                }
            } finally {
                if (con != null) {
                    con.close();
                }
            }
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
 

import java.sql.ResultSet; //導入方法依賴的package包/類
public static Statement getStatement(ResultSet resultSet) {
	try {
		return resultSet.getStatement();
	} catch (SQLException e) {
		throw new RuntimeException("Error getting statement from result set", e);
	}
}
 

import java.sql.ResultSet; //導入方法依賴的package包/類
/**
    * Returns true if engine is terradata
    * 
    * @param resultSet
    *            the result set in use
    * @returns true if engine is terradata
    * @throws SQLException
    */
   private String getDatabaseProductName(ResultSet resultSet)
    throws SQLException {

Statement statement = resultSet.getStatement();

// happens on Metadata requests, we don' care about the result:
if (statement == null) {
    return "unknown";
} else {
    Connection connection = statement.getConnection();
    return new SqlUtil(connection).getDatabaseProductName();
}
   }
 

import java.sql.ResultSet; //導入方法依賴的package包/類
@Override
public void release(ResultSet resultSet, Statement statement) {
	LOG.tracev( "Releasing result set [{0}]", resultSet );
	if ( statement == null ) {
		try {
			statement = resultSet.getStatement();
		}
		catch ( SQLException e ) {
			throw exceptionHelper.convert( e, "unable to access statement from resultset" );
		}
	}
	if ( statement != null ) {
		final Set<ResultSet> resultSets = xref.get( statement );
		if ( resultSets == null ) {
			LOG.unregisteredStatement();
		}
		else {
			resultSets.remove( resultSet );
			if ( resultSets.isEmpty() ) {
				xref.remove( statement );
			}
		}
	}
	else {
		final boolean removed = unassociatedResultSets.remove( resultSet );
		if ( !removed ) {
			LOG.unregisteredResultSetWithoutStatement();
		}
	}
	close( resultSet );
}
 

import java.sql.ResultSet; //導入方法依賴的package包/類
/**
  * Registers a StatementInfo for the given ResultSet, returning the id under
  * which it is registered. This should be used for metadata ResultSets, which
  * have an implicit statement created.
  */
private int registerMetaStatement(ResultSet rs) throws SQLException {
  final int id = statementIdGenerator.getAndIncrement();
  StatementInfo statementInfo = new StatementInfo(rs.getStatement());
  statementInfo.setResultSet(rs);
  statementCache.put(id, statementInfo);
  return id;
}