com.ninja_squad.dbsetup.bind
Class Binders

java.lang.Object
  com.ninja_squad.dbsetup.bind.Binders

public final class Binders
extends java.lang.Object

Utility class allowing to get various kinds of binders. The DefaultBinderConfiguration uses binders returned by this class, based on the type of the parameter.

defaultBinder

public static Binder defaultBinder()

Returns the default binder. This binder is normally used for columns of a type that is not handled by the other binders. It is also used when the metadata are not used and the Insert thus doesn't know the type of the column. It simply uses stmt.setObject() to bind the parameter, except if the value being bound is of some some well-known type not handled by JDBC:

• enum: the name of the enum is bound
• java.util.Date: the date is transformed to a java.sql.Timestamp
• java.util.Calendar: the date is transformed to a java.sql.Timestamp

stringBinder

public static Binder stringBinder()

Returns a binder suitable for columns of type CHAR and VARCHAR. The returned binder supports values of type

• String
• enum: the name of the enum is used as bound value
• Object: the toString() of the object is used as bound value

dateBinder

public static Binder dateBinder()

Returns a binder suitable for columns of type DATE. The returned binder supports values of type

• java.sql.Date
• java.util.Date: the milliseconds of the date are used to construct a java.sql.Date
• java.util.Calendar: the milliseconds of the calendar are used to construct a java.sql.Date
• String: the string is transformed to a java.sql.Date using the Date.valueOf() method

If the value is none of these types, stmt.setObject() is used to bind the value.

timestampBinder

public static Binder timestampBinder()

Returns a binder suitable for columns of type TIMESTAMP. The returned binder supports values of type

• java.sql.Timestamp
• java.util.Date: the milliseconds of the date are used to construct a java.sql.Timestamp
• java.util.Calendar: the milliseconds of the calendar are used to construct a java.sql.Timestamp
• String: the string is transformed to a java.sql.Timestamp using the Timestamp.valueOf() method, or using the java.sql.Date.valueOf() method if the string has less than 19 characters

If the value is none of these types, stmt.setObject() is used to bind the value.

timeBinder

public static Binder timeBinder()

Returns a binder suitable for columns of type TIME. The returned binder supports values of type

• java.sql.Time
• java.util.Date: the milliseconds of the date are used to construct a java.sql.Time
• java.util.Calendar: the milliseconds of the calendar are used to construct a java.sql.Time
• String: the string is transformed to a java.sql.Time using the Time.valueOf() method

If the value is none of these types, stmt.setObject() is used to bind the value.

decimalBinder

public static Binder decimalBinder()

Returns a binder suitable for numeric, decimal columns. The returned binder supports values of type

• String: the string is transformed to a java.math.BigDecimal using its constructor

If the value is none of these types, stmt.setObject() is used to bind the value.

integerBinder

public static Binder integerBinder()

Returns a binder suitable for numeric, integer columns. The returned binder supports values of type

• BigInteger: the object is transformed to a String and bound using stmt.setObject(), with BIGINT as target type.
• enum: the enum is transformed into an integer by taking its ordinal
• String: the string is bound using stmt.setObject(), with BIGINT as target type.

If the value is none of these types, stmt.setObject() is used to bind the value.