/*
* 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
*
* https://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.core;
import java.sql.ResultSet;
import org.springframework.lang.Nullable;
Subclass of SqlParameter
to represent an output parameter. No additional properties: instanceof will be used to check for such types. Output parameters - like all stored procedure parameters - must have names.
Author: Rod Johnson, Thomas Risberg, Juergen Hoeller See Also:
/**
* Subclass of {@link SqlParameter} to represent an output parameter.
* No additional properties: instanceof will be used to check for such types.
*
* <p>Output parameters - like all stored procedure parameters - must have names.
*
* @author Rod Johnson
* @author Thomas Risberg
* @author Juergen Hoeller
* @see SqlReturnResultSet
* @see SqlInOutParameter
*/
public class SqlOutParameter extends ResultSetSupportingSqlParameter {
@Nullable
private SqlReturnType sqlReturnType;
Create a new SqlOutParameter.
Params: - name – the name of the parameter, as used in input and output maps
- sqlType – the parameter SQL type according to
java.sql.Types
/**
* Create a new SqlOutParameter.
* @param name the name of the parameter, as used in input and output maps
* @param sqlType the parameter SQL type according to {@code java.sql.Types}
*/
public SqlOutParameter(String name, int sqlType) {
super(name, sqlType);
}
Create a new SqlOutParameter.
Params: - name – the name of the parameter, as used in input and output maps
- sqlType – the parameter SQL type according to
java.sql.Types
- scale – the number of digits after the decimal point
(for DECIMAL and NUMERIC types)
/**
* Create a new SqlOutParameter.
* @param name the name of the parameter, as used in input and output maps
* @param sqlType the parameter SQL type according to {@code java.sql.Types}
* @param scale the number of digits after the decimal point
* (for DECIMAL and NUMERIC types)
*/
public SqlOutParameter(String name, int sqlType, int scale) {
super(name, sqlType, scale);
}
Create a new SqlOutParameter.
Params: - name – the name of the parameter, as used in input and output maps
- sqlType – the parameter SQL type according to
java.sql.Types
- typeName – the type name of the parameter (optional)
/**
* Create a new SqlOutParameter.
* @param name the name of the parameter, as used in input and output maps
* @param sqlType the parameter SQL type according to {@code java.sql.Types}
* @param typeName the type name of the parameter (optional)
*/
public SqlOutParameter(String name, int sqlType, @Nullable String typeName) {
super(name, sqlType, typeName);
}
Create a new SqlOutParameter.
Params: - name – the name of the parameter, as used in input and output maps
- sqlType – the parameter SQL type according to
java.sql.Types
- typeName – the type name of the parameter (optional)
- sqlReturnType – custom value handler for complex type (optional)
/**
* Create a new SqlOutParameter.
* @param name the name of the parameter, as used in input and output maps
* @param sqlType the parameter SQL type according to {@code java.sql.Types}
* @param typeName the type name of the parameter (optional)
* @param sqlReturnType custom value handler for complex type (optional)
*/
public SqlOutParameter(String name, int sqlType, @Nullable String typeName, @Nullable SqlReturnType sqlReturnType) {
super(name, sqlType, typeName);
this.sqlReturnType = sqlReturnType;
}
Create a new SqlOutParameter.
Params: - name – the name of the parameter, as used in input and output maps
- sqlType – the parameter SQL type according to
java.sql.Types
- rse – the
ResultSetExtractor
to use for parsing the ResultSet
/**
* Create a new SqlOutParameter.
* @param name the name of the parameter, as used in input and output maps
* @param sqlType the parameter SQL type according to {@code java.sql.Types}
* @param rse the {@link ResultSetExtractor} to use for parsing the {@link ResultSet}
*/
public SqlOutParameter(String name, int sqlType, ResultSetExtractor<?> rse) {
super(name, sqlType, rse);
}
Create a new SqlOutParameter.
Params: - name – the name of the parameter, as used in input and output maps
- sqlType – the parameter SQL type according to
java.sql.Types
- rch – the
RowCallbackHandler
to use for parsing the ResultSet
/**
* Create a new SqlOutParameter.
* @param name the name of the parameter, as used in input and output maps
* @param sqlType the parameter SQL type according to {@code java.sql.Types}
* @param rch the {@link RowCallbackHandler} to use for parsing the {@link ResultSet}
*/
public SqlOutParameter(String name, int sqlType, RowCallbackHandler rch) {
super(name, sqlType, rch);
}
Create a new SqlOutParameter.
Params:
/**
* Create a new SqlOutParameter.
* @param name the name of the parameter, as used in input and output maps
* @param sqlType the parameter SQL type according to {@code java.sql.Types}
* @param rm the {@link RowMapper} to use for parsing the {@link ResultSet}
*/
public SqlOutParameter(String name, int sqlType, RowMapper<?> rm) {
super(name, sqlType, rm);
}
Return the custom return type, if any.
/**
* Return the custom return type, if any.
*/
@Nullable
public SqlReturnType getSqlReturnType() {
return this.sqlReturnType;
}
Return whether this parameter holds a custom return type.
/**
* Return whether this parameter holds a custom return type.
*/
public boolean isReturnTypeSupported() {
return (this.sqlReturnType != null);
}
}