Method Detail

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

  Set the parameters of the query from the properties of the Bean.

  Parameters:

  bean - A regular Java Bean

  Returns:

  This instance

• public void executeUpdate()

  Execute an update query (insert, update, delete).

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

  Returns:

  A Map containing the data from the query.

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

  Execute a query and map it to a Java Bean. The bean must have a default no-args constructor.

  Parameters:

  type - The class of the Java bean

  Returns:

  An instance of T

  Type Parameters:

  T - The type of bean to return

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

  Returns:

  A List of Maps containing the data from the query.

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

  Execute a query and return a list of Beans of type T

  Parameters:

  type - The class of the Java bean

  Returns:

  An instance of T

  Type Parameters:

  T - The type of bean to return

• <T extends Serializable> public T findScalar(java.lang.Class<T> type)

  Execute a query that returns a single scalar value, such as a VARCHAR column or the result of a count()

  Parameters:

  type - The scalar type

  Returns:

  A scalar value of the specified type

  Type Parameters:

  T - A Serializable class such as String, Integer or Long

• <T extends Serializable> public java.util.List<T> findScalarList(java.lang.Class<T> type)

  Execute a query that returns a List of scalar values, such as a list of VARCHAR rows

  Parameters:

  type - The scalar type

  Returns:

  A list of scalar values of the specified type

  Type Parameters:

  T - A Serializable class such as String, Integer or Long

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

  Set the parameters of this query from a Map

  Parameters:

  namedParams - a Map of parameters

  Returns:

  This instance

• public SqlQuery params(java.lang.Object positionalParams)

  Set the parameters of this query using positional arguments

  Parameters:

  positionalParams - A list of parameters

  Returns:

  This instance

• public SqlQuery setFirstRow(int firstRow)

• public SqlQuery setMaxRows(int maxRows)