/*
 * Copyright 2002-2018 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.springframework.jdbc.object;

import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.core.PreparedStatementCreatorFactory;
import org.springframework.jdbc.core.PreparedStatementSetter;
import org.springframework.jdbc.core.namedparam.NamedParameterUtils;
import org.springframework.jdbc.core.namedparam.ParsedSql;
import org.springframework.lang.Nullable;
import org.springframework.util.Assert;

Operation object representing a SQL-based operation such as a query or update, as opposed to a stored procedure.

Configures a PreparedStatementCreatorFactory based on the declared parameters.

Author:Rod Johnson, Juergen Hoeller
/** * Operation object representing a SQL-based operation such as a query or update, * as opposed to a stored procedure. * * <p>Configures a {@link org.springframework.jdbc.core.PreparedStatementCreatorFactory} * based on the declared parameters. * * @author Rod Johnson * @author Juergen Hoeller */
public abstract class SqlOperation extends RdbmsOperation {
Object enabling us to create PreparedStatementCreators efficiently, based on this class's declared parameters.
/** * Object enabling us to create PreparedStatementCreators efficiently, * based on this class's declared parameters. */
@Nullable private PreparedStatementCreatorFactory preparedStatementFactory;
Parsed representation of the SQL statement.
/** Parsed representation of the SQL statement. */
@Nullable private ParsedSql cachedSql;
Monitor for locking the cached representation of the parsed SQL statement.
/** Monitor for locking the cached representation of the parsed SQL statement. */
private final Object parsedSqlMonitor = new Object();
Overridden method to configure the PreparedStatementCreatorFactory based on our declared parameters.
/** * Overridden method to configure the PreparedStatementCreatorFactory * based on our declared parameters. */
@Override protected final void compileInternal() { this.preparedStatementFactory = new PreparedStatementCreatorFactory(resolveSql(), getDeclaredParameters()); this.preparedStatementFactory.setResultSetType(getResultSetType()); this.preparedStatementFactory.setUpdatableResults(isUpdatableResults()); this.preparedStatementFactory.setReturnGeneratedKeys(isReturnGeneratedKeys()); if (getGeneratedKeysColumnNames() != null) { this.preparedStatementFactory.setGeneratedKeysColumnNames(getGeneratedKeysColumnNames()); } onCompileInternal(); }
Hook method that subclasses may override to post-process compilation. This implementation does nothing.
See Also:
  • compileInternal
/** * Hook method that subclasses may override to post-process compilation. * This implementation does nothing. * @see #compileInternal */
protected void onCompileInternal() { }
Obtain a parsed representation of this operation's SQL statement.

Typically used for named parameter parsing.

/** * Obtain a parsed representation of this operation's SQL statement. * <p>Typically used for named parameter parsing. */
protected ParsedSql getParsedSql() { synchronized (this.parsedSqlMonitor) { if (this.cachedSql == null) { this.cachedSql = NamedParameterUtils.parseSqlStatement(resolveSql()); } return this.cachedSql; } }
Return a PreparedStatementSetter to perform an operation with the given parameters.
Params:
  • params – the parameter array (may be null)
/** * Return a PreparedStatementSetter to perform an operation * with the given parameters. * @param params the parameter array (may be {@code null}) */
protected final PreparedStatementSetter newPreparedStatementSetter(@Nullable Object[] params) { Assert.state(this.preparedStatementFactory != null, "No PreparedStatementFactory available"); return this.preparedStatementFactory.newPreparedStatementSetter(params); }
Return a PreparedStatementCreator to perform an operation with the given parameters.
Params:
  • params – the parameter array (may be null)
/** * Return a PreparedStatementCreator to perform an operation * with the given parameters. * @param params the parameter array (may be {@code null}) */
protected final PreparedStatementCreator newPreparedStatementCreator(@Nullable Object[] params) { Assert.state(this.preparedStatementFactory != null, "No PreparedStatementFactory available"); return this.preparedStatementFactory.newPreparedStatementCreator(params); }
Return a PreparedStatementCreator to perform an operation with the given parameters.
Params:
  • sqlToUse – the actual SQL statement to use (if different from the factory's, for example because of named parameter expanding)
  • params – the parameter array (may be null)
/** * Return a PreparedStatementCreator to perform an operation * with the given parameters. * @param sqlToUse the actual SQL statement to use (if different from * the factory's, for example because of named parameter expanding) * @param params the parameter array (may be {@code null}) */
protected final PreparedStatementCreator newPreparedStatementCreator(String sqlToUse, @Nullable Object[] params) { Assert.state(this.preparedStatementFactory != null, "No PreparedStatementFactory available"); return this.preparedStatementFactory.newPreparedStatementCreator(sqlToUse, params); } }