Class JdbcQuery

Method Details

• getConnection

  public JdbcConnection getConnection()

  Returns the connection this query was added to, or null.

• setConnection

  protected JdbcQuery setConnection(JdbcConnection connection)

  Sets the connection this query belongs to; called by JdbcConnection.addQuery(JdbcQuery).

• getName

  public String getName()

  Specified by:

  getName in interface JdbcSource

• setName

  public JdbcQuery setName(String name)

• getQuery

  public String getQuery()

  Description copied from interface: JdbcSource

  Returns the SQL that selects this source's rows.

  Specified by:

  getQuery in interface JdbcSource

• setQuery

  public JdbcQuery setQuery(String query)

• getParameters

  public List<JdbcQueryParameter> getParameters()

  Returns the parameters, in the order of the query's ? placeholders.

• setParameters

  public JdbcQuery setParameters(Collection<JdbcQueryParameter> parameters)

  Replaces the parameters, given in the order of the query's ? placeholders; null clears them.

• addParameter

  public JdbcQuery addParameter(JdbcQueryParameter parameter)

  Adds a parameter for the next ? placeholder in the query.

• addParameter

  public JdbcQuery addParameter(String name, Class<?> javaType, Integer sqlType, String exampleValueExpression)

  Adds a parameter for the next ? placeholder; sqlType is a java.sql.Types code or null.

• addParameter

  public JdbcQuery addParameter(String name, Class<?> javaType, String exampleValueExpression)

  Adds a parameter for the next ? placeholder with no SQL type, letting the driver infer it.

• getColumns

  public List<JdbcQueryColumn> getColumns()

  Returns the result columns, as filled by JdbcConnection.loadQueries().

• setColumns

  public JdbcQuery setColumns(Collection<JdbcQueryColumn> columns)

  Replaces the result columns; null clears them.

• addColumn

  public JdbcQuery addColumn(JdbcQueryColumn column)

• getCardinality

  public JdbcQuery.Cardinality getCardinality()

  Returns whether the query returns many rows or one (default is JdbcQuery.Cardinality.MANY).

• setCardinality

  public JdbcQuery setCardinality(JdbcQuery.Cardinality cardinality)

  Sets whether the query returns many rows or one; null means JdbcQuery.Cardinality.MANY.

• getSourceType

  public JdbcSourceType getSourceType()

  Specified by:

  getSourceType in interface JdbcSource

• sortColumns

  public JdbcQuery sortColumns()

  Sorts the result columns by name, ignoring case.

• toRecord

  public Record toRecord()

  Description copied from interface: RecordSerializable

  Converts this object's state to a record that RecordSerializable.fromRecord(Record) can load.

  Specified by:

  toRecord in interface RecordSerializable

  Overrides:

  toRecord in class Bean

• fromRecord

  public JdbcQuery fromRecord(Record source)

  Description copied from interface: RecordSerializable

  Loads this instance's state from a record and returns this (for fluid API call chaining). For fluid API call chaining, the overridden method should change the declared return type to its class.

  Specified by:

  fromRecord in interface RecordSerializable

  Overrides:

  fromRecord in class Bean

  Parameters:

  source -

  Returns:

  this instance.