Method Detail

• public Query bind(java.lang.Object bean)

  Parameters:

  bean - A Java Bean containing values for named parameters

  Returns:

  This instance

• public int executeUpdate()

  Returns:

  The amount of rows affected

• public java.util.Map<java.lang.String, java.lang.Object> findRow()

  Returns:

  A row from the database

• <T> public T findRow(java.lang.Class<T> type)

  Parameters:

  type - A Java Bean class

  Returns:

  An instance of T from the database query

  Type Parameters:

  T - A generic type

• public java.util.List<java.util.Map<java.lang.String, java.lang.Object>> findRows()

  Returns:

  A list of rows from the database

• <T> public java.util.List<T> findRows(java.lang.Class<T> type)

  Parameters:

  type - A Java Bean class

  Returns:

  A List of T

  Type Parameters:

  T - A generic type

• <T> public T insertAndReturnKey()

  Returns:

  The primary key generated from the insert statement

  Type Parameters:

  T - A generic type

• public Query params(java.util.Map<java.lang.String, java.lang.Object> params)

  Parameters:

  params - A java.util.Map<String, Object> or any Java Bean from which the query can source its parameter values

  Returns:

  This instance

• public Query setParameter(java.lang.String name, java.lang.Object value)

  Set the value of a named parameter

  Parameters:

  name - The named parameter

  value - The value to set

  Returns:

  This instance

• public Query setParameter(int position, java.lang.Object value)

  Set a positional parameter. The first parameter has position 1

  Parameters:

  position - 1-based index of the parameter

  value - The parameter value

  Returns:

  This instance

• <T> public T value()

  Returns:

  A single column of type T

  Type Parameters:

  T - A generic type

• <T> public java.util.List<T> values()

  Returns:

  A List of T

  Type Parameters:

  T - A generic type