com.jcabi.jdbc

Class SingleOutcome<T>

java.lang.Object

com.jcabi.jdbc.SingleOutcome<T>

All Implemented Interfaces:

Outcome<T>

@Immutable
public final class SingleOutcome<T>
extends Object
implements Outcome<T>

Outcome that returns first column in the first row.

Use it when you need the first column in the first row:

 Long id = new JdbcSession(source)
   .sql("SELECT id FROM user WHERE name = ?")
   .set("Jeff Lebowski")
   .select(new SingleOutcome<Long>(Long.class));

Supported types are: String, Long, Boolean, Byte, Date, and Utc.

By default, the outcome throws SQLException if no records are found in the ResultSet. You can change this behavior by using a two-arguments constructor (null will be returned if ResultSet is empty):

 String name = new JdbcSession(source)
   .sql("SELECT name FROM user WHERE id = ?")
   .set(555)
   .select(new SingleOutcome<Long>(Long.class), true);
 if (name == null) {
   // such a record wasn't found in the database
 }

Since:

0.1.8

Version:

$Id$

Author:

Yegor Bugayenko (yegor@tpc2.com)

Field Summary

Fields inherited from interface com.jcabi.jdbc.Outcome

NOT_EMPTY, UPDATE_COUNT, VOID

Constructor Summary

Constructors

Constructor and Description
SingleOutcome(Class<T> tpe) Public ctor.
SingleOutcome(Class<T> tpe, boolean slnt) Public ctor.

Method Summary

Methods

Modifier and Type	Method and Description
T	handle(ResultSet rset, Statement stmt) Process the result set and return some value.

Methods inherited from class java.lang.Object

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

Constructor Detail

SingleOutcome

public SingleOutcome(@NotNull(message="type of result can\'t be NULL")
             Class<T> tpe)

Public ctor.

Parameters:

tpe - The type to convert to

SingleOutcome

public SingleOutcome(@NotNull(message="type can\'t be NULL")
             Class<T> tpe,
             boolean slnt)

Public ctor.

Parameters:

tpe - The type to convert to

slnt - Silently return NULL if there is no row

Method Detail

handle

@Loggable(value=1)
public T handle(ResultSet rset,
                     Statement stmt)
         throws SQLException

Description copied from interface: Outcome

Process the result set and return some value.

Specified by:

handle in interface Outcome<T>

Parameters:

rset - The result set to process

stmt - The statement used in the run

Returns:

The result

Throws:

SQLException - If something goes wrong inside