Direct Known Subclasses:
ResultSetSupportingSqlParameter
,
SqlParameterValue
,
SqlReturnUpdateCount
public class
SqlParameter
extends
Object
Object to represent an SQL parameter definition.
Parameters may be anonymous, in which case "name" is
null
.
However, all parameters must define an SQL type according to
Types
.
Author:
Rod Johnson, Thomas Risberg, Juergen Hoeller
See Also:
Types
Create a new SqlParameter, supplying name and SQL type.
Copy constructor.
Return whether this parameter holds input values that should be set
before execution even if they are
null
.
boolean
Return whether this parameter is an implicit return parameter used during the
results processing of
CallableStatement.getMoreResults/getUpdateCount
.
Convert a list of JDBC types, as defined in
java.sql.Types
,
to a List of SqlParameter objects as used in this package.
SqlParameter
public
SqlParameter
(int sqlType)
Create a new anonymous SqlParameter, supplying the SQL type.
Parameters:
sqlType
- the SQL type of the parameter according to
java.sql.Types
public
SqlParameter
(int sqlType,
int scale)
Create a new anonymous SqlParameter, supplying the SQL type.
Parameters:
sqlType
- the SQL type of the parameter according to
java.sql.Types
scale
- the number of digits after the decimal point
(for DECIMAL and NUMERIC types)
public
SqlParameter
(
String
name,
int sqlType)
Create a new SqlParameter, supplying name and SQL type.
Parameters:
name
- the name of the parameter, as used in input and output maps
sqlType
- the SQL type of the parameter according to
java.sql.Types
Parameters:
name
- the name of the parameter, as used in input and output maps
sqlType
- the SQL type of the parameter according to
java.sql.Types
typeName
- the type name of the parameter (optional)
Parameters:
name
- the name of the parameter, as used in input and output maps
sqlType
- the SQL type of the parameter according to
java.sql.Types
scale
- the number of digits after the decimal point
(for DECIMAL and NUMERIC types)
isInputValueProvided
public
boolean
isInputValueProvided
()
Return whether this parameter holds input values that should be set
before execution even if they are
null
.
This implementation always returns
true
.
isResultsParameter
public
boolean
isResultsParameter
()
Return whether this parameter is an implicit return parameter used during the
results processing of
CallableStatement.getMoreResults/getUpdateCount
.
This implementation always returns
false
.
sqlTypesToAnonymousParameterList
Convert a list of JDBC types, as defined in
java.sql.Types
,
to a List of SqlParameter objects as used in this package.