类 SqlParameter
- java.lang.Object
- org.springframework.jdbc.core.SqlParameter
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 toTypes
.- 作者:
- Rod Johnson, Thomas Risberg, Juergen Hoeller
- 另请参阅:
Types
构造器概要
构造器 构造器 说明 SqlParameter(int sqlType)
Create a new anonymous SqlParameter, supplying the SQL type.SqlParameter(int sqlType, int scale)
Create a new anonymous SqlParameter, supplying the SQL type.SqlParameter(int sqlType, String typeName)
Create a new anonymous SqlParameter, supplying the SQL type.SqlParameter(String name, int sqlType)
Create a new SqlParameter, supplying name and SQL type.SqlParameter(String name, int sqlType, int scale)
Create a new SqlParameter, supplying name and SQL type.SqlParameter(String name, int sqlType, String typeName)
Create a new SqlParameter, supplying name and SQL type.SqlParameter(SqlParameter otherParam)
Copy constructor.
方法概要
所有方法 静态方法 实例方法 具体方法 修饰符和类型 方法 说明 String
getName()
Return the name of the parameter, ornull
if anonymous.Integer
getScale()
Return the scale of the parameter, if any.int
getSqlType()
Return the SQL type of the parameter.String
getTypeName()
Return the type name of the parameter, if any.boolean
isInputValueProvided()
Return whether this parameter holds input values that should be set before execution even if they arenull
.boolean
isResultsParameter()
Return whether this parameter is an implicit return parameter used during the results processing ofCallableStatement.getMoreResults/getUpdateCount
.static List<SqlParameter>
sqlTypesToAnonymousParameterList(int... types)
Convert a list of JDBC types, as defined injava.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.- 参数:
sqlType
- the SQL type of the parameter according tojava.sql.Types
SqlParameter
public SqlParameter(int sqlType, @Nullable String typeName)
Create a new anonymous SqlParameter, supplying the SQL type.- 参数:
sqlType
- the SQL type of the parameter according tojava.sql.Types
typeName
- the type name of the parameter (optional)
SqlParameter
public SqlParameter(int sqlType, int scale)
Create a new anonymous SqlParameter, supplying the SQL type.- 参数:
sqlType
- the SQL type of the parameter according tojava.sql.Types
scale
- the number of digits after the decimal point (for DECIMAL and NUMERIC types)
SqlParameter
public SqlParameter(String name, int sqlType)
Create a new SqlParameter, supplying name and SQL type.- 参数:
name
- the name of the parameter, as used in input and output mapssqlType
- the SQL type of the parameter according tojava.sql.Types
SqlParameter
public SqlParameter(String name, int sqlType, @Nullable String typeName)
Create a new SqlParameter, supplying name and SQL type.- 参数:
name
- the name of the parameter, as used in input and output mapssqlType
- the SQL type of the parameter according tojava.sql.Types
typeName
- the type name of the parameter (optional)
SqlParameter
public SqlParameter(String name, int sqlType, int scale)
Create a new SqlParameter, supplying name and SQL type.- 参数:
name
- the name of the parameter, as used in input and output mapssqlType
- the SQL type of the parameter according tojava.sql.Types
scale
- the number of digits after the decimal point (for DECIMAL and NUMERIC types)
SqlParameter
public SqlParameter(SqlParameter otherParam)
Copy constructor.- 参数:
otherParam
- the SqlParameter object to copy from
方法详细资料
getSqlType
public int getSqlType()
Return the SQL type of the parameter.
getTypeName
@Nullable public String getTypeName()
Return the type name of the parameter, if any.
isInputValueProvided
public boolean isInputValueProvided()
Return whether this parameter holds input values that should be set before execution even if they arenull
.This implementation always returns
true
.
isResultsParameter
public boolean isResultsParameter()
Return whether this parameter is an implicit return parameter used during the results processing ofCallableStatement.getMoreResults/getUpdateCount
.This implementation always returns
false
.
sqlTypesToAnonymousParameterList
public static List<SqlParameter> sqlTypesToAnonymousParameterList(@Nullable int... types)
Convert a list of JDBC types, as defined injava.sql.Types
, to a List of SqlParameter objects as used in this package.