Java ParameterSpecification.bind方法代码示例

import org.hibernate.param.ParameterSpecification; //导入方法依赖的package包/类
/**
 * We specifically override this method here, because in general we know much more
 * about the parameters and their appropriate bind positions here then we do in
 * our super because we track them explicitly here through the ParameterSpecification
 * interface.
 *
 * @param queryParameters The encapsulation of the parameter values to be bound.
 * @param startIndex The position from which to start binding parameter values.
 * @param session The originating session.
 * @return The number of JDBC bind positions actually bound during this method execution.
 * @throws SQLException Indicates problems performing the binding.
 */
@Override
protected int bindParameterValues(
		final PreparedStatement statement,
		final QueryParameters queryParameters,
		final int startIndex,
		final SessionImplementor session) throws SQLException {
	int position = startIndex;
	List<ParameterSpecification> parameterSpecs = queryTranslator.getCollectedParameterSpecifications();
	for ( ParameterSpecification spec : parameterSpecs ) {
		position += spec.bind( statement, queryParameters, session, position );
	}
	return position - startIndex;
}
 

import org.hibernate.param.ParameterSpecification; //导入方法依赖的package包/类
@Override
public int bind(PreparedStatement statement, QueryParameters qp, SessionImplementor session, int position)
		throws SQLException {
	int bindCount = 0;
	for ( ParameterSpecification paramSpec : paramSpecs ) {
		bindCount += paramSpec.bind( statement, qp, session, position + bindCount );
	}
	return bindCount;
}
 

import org.hibernate.param.ParameterSpecification; //导入方法依赖的package包/类
protected int doExecute(QueryParameters parameters, SessionImplementor session, String sql,
		List parameterSpecifications) throws HibernateException {
	BulkOperationCleanupAction action = new BulkOperationCleanupAction( session, persister );
	if ( session.isEventSource() ) {
		( (EventSource) session ).getActionQueue().addAction( action );
	}
	else {
		action.getAfterTransactionCompletionProcess().doAfterTransactionCompletion( true, session );
	}

	PreparedStatement st = null;
	RowSelection selection = parameters.getRowSelection();

	try {
		try {
			st = session.getTransactionCoordinator().getJdbcCoordinator().getStatementPreparer().prepareStatement( sql, false );
			Iterator paramSpecItr = parameterSpecifications.iterator();
			int pos = 1;
			while ( paramSpecItr.hasNext() ) {
				final ParameterSpecification paramSpec = (ParameterSpecification) paramSpecItr.next();
				pos += paramSpec.bind( st, parameters, session, pos );
			}
			if ( selection != null ) {
				if ( selection.getTimeout() != null ) {
					st.setQueryTimeout( selection.getTimeout() );
				}
			}

			return session.getTransactionCoordinator().getJdbcCoordinator().getResultSetReturn().executeUpdate( st );
		}
		finally {
			if ( st != null ) {
				session.getTransactionCoordinator().getJdbcCoordinator().release( st );
			}
		}
	}
	catch( SQLException sqle ) {
		throw factory.getSQLExceptionHelper().convert( sqle, "could not execute update query", sql );
	}
}
 

import org.hibernate.param.ParameterSpecification; //导入方法依赖的package包/类
/**
 * We specifically override this method here, because in general we know much more
 * about the parameters and their appropriate bind positions here then we do in
 * our super because we track them explciitly here through the ParameterSpecification
 * interface.
 *
 * @param queryParameters The encapsulation of the parameter values to be bound.
 * @param startIndex The position from which to start binding parameter values.
 * @param session The originating session.
 * @return The number of JDBC bind positions actually bound during this method execution.
 * @throws SQLException Indicates problems performing the binding.
 */
protected int bindParameterValues(
		final PreparedStatement statement,
		final QueryParameters queryParameters,
		final int startIndex,
		final SessionImplementor session) throws SQLException {
	int position = bindFilterParameterValues( statement, queryParameters, startIndex, session );
	List parameterSpecs = queryTranslator.getSqlAST().getWalker().getParameters();
	Iterator itr = parameterSpecs.iterator();
	while ( itr.hasNext() ) {
		ParameterSpecification spec = ( ParameterSpecification ) itr.next();
		position += spec.bind( statement, queryParameters, session, position );
	}
	return position - startIndex;
}
 

import org.hibernate.param.ParameterSpecification; //导入方法依赖的package包/类
public int execute(QueryParameters parameters, SessionImplementor session) throws HibernateException {

		coordinateSharedCacheCleanup( session );

		PreparedStatement st = null;
		RowSelection selection = parameters.getRowSelection();

		try {
			try {
				st = session.getBatcher().prepareStatement( sql );
				Iterator paramSpecifications = getWalker().getParameters().iterator();
				int pos = 1;
				while ( paramSpecifications.hasNext() ) {
					final ParameterSpecification paramSpec = ( ParameterSpecification ) paramSpecifications.next();
					pos += paramSpec.bind( st, parameters, session, pos );
				}
				if ( selection != null ) {
					if ( selection.getTimeout() != null ) {
						st.setQueryTimeout( selection.getTimeout().intValue() );
					}
				}

				return st.executeUpdate();
			}
			finally {
				if ( st != null ) {
					session.getBatcher().closeStatement( st );
				}
			}
		}
		catch( SQLException sqle ) {
			throw JDBCExceptionHelper.convert(
					getFactory().getSQLExceptionConverter(),
			        sqle,
			        "could not execute update query",
			        sql
				);
		}
	}
 

import org.hibernate.param.ParameterSpecification; //导入方法依赖的package包/类
private CTEValues prepareCteStatement(SessionImplementor session,
		QueryParameters queryParameters) {
	CTEValues values = new CTEValues();

	PreparedStatement ps = null;

	try {
		try {
			ps = session.getJdbcCoordinator()
					.getStatementPreparer()
					.prepareStatement(idSelect, false);
			int sum = 1;
			sum += handlePrependedParametersOnIdSelection(ps, session, sum);
			for (ParameterSpecification parameterSpecification : idSelectParameterSpecifications) {
				sum += parameterSpecification.bind(ps, queryParameters,
						session, sum);
			}
			ResultSet rs = session
					.getJdbcCoordinator().getResultSetReturn().extract(ps);
			while (rs.next()) {
				Object[] result = new Object[targetedPersister
						.getIdentifierColumnNames().length];
				for (String columnName : targetedPersister
						.getIdentifierColumnNames()) {
					Object column = rs.getObject( columnName);
					result[rs.findColumn(columnName) - 1] = column;
				}
				values.getSelectResult().add(result);
			}

			if (values.getSelectResult().isEmpty()) {
				return values;
			}

			String idCteSelect = generateIdCteSelect( targetedPersister,
													  determineIdTableName(targetedPersister),
													  values.getSelectResult());
			values.setIdCteSelect(idCteSelect);

			log.tracev(
					"Generated ID-CTE-SELECT SQL (multi-table update) : {0}",
					idCteSelect);

			return values;
		} finally {
			if (ps != null) {
				ps.close();
			}
		}
	} catch (SQLException e) {
		throw convert(e, "could not insert/select ids for bulk update",
				idSelect);
	}
}
 

import org.hibernate.param.ParameterSpecification; //导入方法依赖的package包/类
private CTEValues prepareCteStatement(SessionImplementor session,
		QueryParameters queryParameters) {
	CTEValues values = new CTEValues();

	PreparedStatement ps = null;

	try {
		try {
			ps = session.getJdbcCoordinator()
					.getStatementPreparer()
					.prepareStatement(idSelect, false);
			int sum = 1;
			sum += handlePrependedParametersOnIdSelection(ps, session, sum);
			for (ParameterSpecification parameterSpecification : idSelectParameterSpecifications) {
				sum += parameterSpecification.bind(ps, queryParameters,
						session, sum);
			}
			ResultSet rs = session
					.getJdbcCoordinator().getResultSetReturn().extract(ps);
			while (rs.next()) {
				Object[] result = new Object[targetedPersister
						.getIdentifierColumnNames().length];
				for (String columnName : targetedPersister
						.getIdentifierColumnNames()) {
					Object column = rs.getObject( columnName);
					result[rs.findColumn(columnName) - 1] = column;
				}
				values.getSelectResult().add(result);
			}

			if (values.getSelectResult().isEmpty()) {
				return values;
			}

			String idCteSelect = generateIdCteSelect( targetedPersister,
													  determineIdTableName(targetedPersister),
													  values.getSelectResult());
			values.setIdCteSelect(idCteSelect);

			log.tracev(
					"Generated ID-CTE-SELECT SQL (multi-table delete) : {0}",
					idCteSelect);

			return values;
		} finally {
			if (ps != null) {
				ps.close();
			}
		}
	} catch (SQLException e) {
		throw convert(e, "could not insert/select ids for bulk delete",
				idSelect);
	}
}
 

import org.hibernate.param.ParameterSpecification; //导入方法依赖的package包/类
private CTEValues prepareCteStatement(SessionImplementor session,
		QueryParameters queryParameters) {
	CTEValues values = new CTEValues();

	PreparedStatement ps = null;

	try {
		try {
			ps = session.getTransactionCoordinator().getJdbcCoordinator()
					.getStatementPreparer()
					.prepareStatement(idSelect, false);
			int sum = 1;
			sum += handlePrependedParametersOnIdSelection(ps, session, sum);
			for (ParameterSpecification parameterSpecification : idSelectParameterSpecifications) {
				sum += parameterSpecification.bind(ps, queryParameters,
						session, sum);
			}
			ResultSet rs = session.getTransactionCoordinator()
					.getJdbcCoordinator().getResultSetReturn().extract(ps);
			while (rs.next()) {
				Object[] result = new Object[targetedPersister
						.getIdentifierColumnNames().length];
				for (String columnName : targetedPersister
						.getIdentifierColumnNames()) {
					Object column = rs.getObject(columnName);
					result[rs.findColumn(columnName) - 1] = column;
				}
				values.getSelectResult().add(result);
			}

			if (values.getSelectResult().isEmpty()) {
				return values;
			}

			String idCteSelect = generateIdCteSelect(targetedPersister,
					determineIdTableName(targetedPersister),
					values.getSelectResult());
			values.setIdCteSelect(idCteSelect);

			log.tracev(
					"Generated ID-CTE-SELECT SQL (multi-table update) : {0}",
					idCteSelect);

			return values;
		} finally {
			if (ps != null) {
				session.getTransactionCoordinator().getJdbcCoordinator()
						.release(ps);
			}
		}
	} catch (SQLException e) {
		throw convert(e, "could not insert/select ids for bulk update",
				idSelect);
	}
}
 

import org.hibernate.param.ParameterSpecification; //导入方法依赖的package包/类
private CTEValues prepareCteStatement(SessionImplementor session,
		QueryParameters queryParameters) {
	CTEValues values = new CTEValues();

	PreparedStatement ps = null;

	try {
		try {
			ps = session.getTransactionCoordinator().getJdbcCoordinator()
					.getStatementPreparer()
					.prepareStatement(idSelect, false);
			int sum = 1;
			sum += handlePrependedParametersOnIdSelection(ps, session, sum);
			for (ParameterSpecification parameterSpecification : idSelectParameterSpecifications) {
				sum += parameterSpecification.bind(ps, queryParameters,
						session, sum);
			}
			ResultSet rs = session.getTransactionCoordinator()
					.getJdbcCoordinator().getResultSetReturn().extract(ps);
			while (rs.next()) {
				Object[] result = new Object[targetedPersister
						.getIdentifierColumnNames().length];
				for (String columnName : targetedPersister
						.getIdentifierColumnNames()) {
					Object column = rs.getObject(columnName);
					result[rs.findColumn(columnName) - 1] = column;
				}
				values.getSelectResult().add(result);
			}

			if (values.getSelectResult().isEmpty()) {
				return values;
			}

			String idCteSelect = generateIdCteSelect(targetedPersister,
					determineIdTableName(targetedPersister),
					values.getSelectResult());
			values.setIdCteSelect(idCteSelect);

			log.tracev(
					"Generated ID-CTE-SELECT SQL (multi-table delete) : {0}",
					idCteSelect);

			return values;
		} finally {
			if (ps != null) {
				session.getTransactionCoordinator().getJdbcCoordinator()
						.release(ps);
			}
		}
	} catch (SQLException e) {
		throw convert(e, "could not insert/select ids for bulk delete",
				idSelect);
	}
}