net.hasor.db.jdbc

Class SqlParameterUtils

java.lang.Object

net.hasor.db.jdbc.SqlParameterUtils

All Implemented Interfaces:

SqlParameter

public class SqlParameterUtils
extends Object
implements SqlParameter

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 JDBCType.

Author:

赵永春 (zyc@hasor.net)

See Also:

JDBCType

Nested Class Summary

Nested classes/interfaces inherited from interface net.hasor.db.jdbc.SqlParameter

SqlParameter.InSqlParameter, SqlParameter.OutSqlParameter, SqlParameter.ReturnSqlParameter, SqlParameter.ValueSqlParameter

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	SqlParameterUtils(String name)

Method Summary

Modifier and Type	Method and Description
String	getName() Return the name of the parameter, or null if anonymous.
static SqlParameter	withInOut(Object value, JDBCType jdbcType)
static SqlParameter	withInOut(Object value, JDBCType jdbcType, Integer scale)
static SqlParameter	withInOut(Object value, JDBCType jdbcType, Integer scale, TypeHandler<?> typeHandler)
static SqlParameter	withInOut(Object value, JDBCType jdbcType, String typeName)
static SqlParameter	withInOut(Object value, JDBCType jdbcType, String typeName, TypeHandler<?> typeHandler)
static SqlParameter	withInOut(Object value, JDBCType jdbcType, TypeHandler<?> typeHandler)
static SqlParameter	withInOut(String paramName, Object value, JDBCType jdbcType)
static SqlParameter	withInOut(String paramName, Object value, JDBCType jdbcType, Integer scale)
static SqlParameter	withInOut(String paramName, Object value, JDBCType jdbcType, Integer scale, TypeHandler<?> typeHandler)
static SqlParameter	withInOut(String paramName, Object value, JDBCType jdbcType, String typeName)
static SqlParameter	withInOut(String paramName, Object value, JDBCType jdbcType, String typeName, TypeHandler<?> typeHandler)
static SqlParameter	withInOut(String paramName, Object value, JDBCType jdbcType, TypeHandler<?> typeHandler)
static SqlParameter.InSqlParameter	withInput(Object value)
static SqlParameter.InSqlParameter	withInput(Object value, JDBCType jdbcType)
static SqlParameter.InSqlParameter	withInput(Object value, JDBCType jdbcType, TypeHandler<?> typeHandler)
static SqlParameter.InSqlParameter	withInput(Object value, TypeHandler<?> typeHandler)
static SqlParameter.OutSqlParameter	withOutput(JDBCType jdbcType)
static SqlParameter.OutSqlParameter	withOutput(JDBCType jdbcType, Integer scale)
static SqlParameter.OutSqlParameter	withOutput(JDBCType jdbcType, Integer scale, TypeHandler<?> typeHandler)
static SqlParameter.OutSqlParameter	withOutput(JDBCType jdbcType, String typeName)
static SqlParameter.OutSqlParameter	withOutput(JDBCType jdbcType, String typeName, TypeHandler<?> typeHandler)
static SqlParameter.OutSqlParameter	withOutput(JDBCType jdbcType, TypeHandler<?> typeHandler)
static SqlParameter.OutSqlParameter	withOutput(String paramName, JDBCType jdbcType)
static SqlParameter.OutSqlParameter	withOutput(String paramName, JDBCType jdbcType, Integer scale)
static SqlParameter.OutSqlParameter	withOutput(String paramName, JDBCType jdbcType, Integer scale, TypeHandler<?> typeHandler)
static SqlParameter.OutSqlParameter	withOutput(String paramName, JDBCType jdbcType, String typeName)
static SqlParameter.OutSqlParameter	withOutput(String paramName, JDBCType jdbcType, String typeName, TypeHandler<?> typeHandler)
static SqlParameter.OutSqlParameter	withOutput(String paramName, JDBCType jdbcType, TypeHandler<?> typeHandler)
static SqlParameter.ReturnSqlParameter	withReturnResult(String paramName, ResultSetExtractor<?> resultSetExtractor)
static SqlParameter.ReturnSqlParameter	withReturnResult(String paramName, RowCallbackHandler rowCallbackHandler)
static SqlParameter.ReturnSqlParameter	withReturnResult(String paramName, RowMapper<?> rowMapper)
static SqlParameter.ReturnSqlParameter	withReturnValue(String paramName)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SqlParameterUtils

protected SqlParameterUtils(String name)

Method Detail

getName

public String getName()

Return the name of the parameter, or null if anonymous.

Specified by:

getName in interface SqlParameter

withOutput

public static SqlParameter.OutSqlParameter withOutput(JDBCType jdbcType)

withOutput

public static SqlParameter.OutSqlParameter withOutput(JDBCType jdbcType,
                                                      Integer scale)

withOutput

public static SqlParameter.OutSqlParameter withOutput(JDBCType jdbcType,
                                                      String typeName)

withOutput

public static SqlParameter.OutSqlParameter withOutput(JDBCType jdbcType,
                                                      TypeHandler<?> typeHandler)

withOutput

public static SqlParameter.OutSqlParameter withOutput(JDBCType jdbcType,
                                                      Integer scale,
                                                      TypeHandler<?> typeHandler)

withOutput

public static SqlParameter.OutSqlParameter withOutput(JDBCType jdbcType,
                                                      String typeName,
                                                      TypeHandler<?> typeHandler)

withOutput

public static SqlParameter.OutSqlParameter withOutput(String paramName,
                                                      JDBCType jdbcType)

withOutput

public static SqlParameter.OutSqlParameter withOutput(String paramName,
                                                      JDBCType jdbcType,
                                                      Integer scale)

withOutput

public static SqlParameter.OutSqlParameter withOutput(String paramName,
                                                      JDBCType jdbcType,
                                                      String typeName)

withOutput

public static SqlParameter.OutSqlParameter withOutput(String paramName,
                                                      JDBCType jdbcType,
                                                      TypeHandler<?> typeHandler)

withOutput

public static SqlParameter.OutSqlParameter withOutput(String paramName,
                                                      JDBCType jdbcType,
                                                      Integer scale,
                                                      TypeHandler<?> typeHandler)

withOutput

public static SqlParameter.OutSqlParameter withOutput(String paramName,
                                                      JDBCType jdbcType,
                                                      String typeName,
                                                      TypeHandler<?> typeHandler)

withInput

public static SqlParameter.InSqlParameter withInput(Object value)

withInput

public static SqlParameter.InSqlParameter withInput(Object value,
                                                    JDBCType jdbcType)

withInput

public static SqlParameter.InSqlParameter withInput(Object value,
                                                    TypeHandler<?> typeHandler)

withInput

public static SqlParameter.InSqlParameter withInput(Object value,
                                                    JDBCType jdbcType,
                                                    TypeHandler<?> typeHandler)

withInOut

public static SqlParameter withInOut(Object value,
                                     JDBCType jdbcType)

withInOut

public static SqlParameter withInOut(Object value,
                                     JDBCType jdbcType,
                                     Integer scale)

withInOut

public static SqlParameter withInOut(Object value,
                                     JDBCType jdbcType,
                                     String typeName)

withInOut

public static SqlParameter withInOut(Object value,
                                     JDBCType jdbcType,
                                     TypeHandler<?> typeHandler)

withInOut

public static SqlParameter withInOut(Object value,
                                     JDBCType jdbcType,
                                     Integer scale,
                                     TypeHandler<?> typeHandler)

withInOut

public static SqlParameter withInOut(Object value,
                                     JDBCType jdbcType,
                                     String typeName,
                                     TypeHandler<?> typeHandler)

withInOut

public static SqlParameter withInOut(String paramName,
                                     Object value,
                                     JDBCType jdbcType)

withInOut

public static SqlParameter withInOut(String paramName,
                                     Object value,
                                     JDBCType jdbcType,
                                     Integer scale)

withInOut

public static SqlParameter withInOut(String paramName,
                                     Object value,
                                     JDBCType jdbcType,
                                     String typeName)

withInOut

public static SqlParameter withInOut(String paramName,
                                     Object value,
                                     JDBCType jdbcType,
                                     TypeHandler<?> typeHandler)

withInOut

public static SqlParameter withInOut(String paramName,
                                     Object value,
                                     JDBCType jdbcType,
                                     Integer scale,
                                     TypeHandler<?> typeHandler)

withInOut

public static SqlParameter withInOut(String paramName,
                                     Object value,
                                     JDBCType jdbcType,
                                     String typeName,
                                     TypeHandler<?> typeHandler)

withReturnValue

public static SqlParameter.ReturnSqlParameter withReturnValue(String paramName)

withReturnResult

public static SqlParameter.ReturnSqlParameter withReturnResult(String paramName,
                                                               ResultSetExtractor<?> resultSetExtractor)

withReturnResult

public static SqlParameter.ReturnSqlParameter withReturnResult(String paramName,
                                                               RowCallbackHandler rowCallbackHandler)

withReturnResult

public static SqlParameter.ReturnSqlParameter withReturnResult(String paramName,
                                                               RowMapper<?> rowMapper)