de.uplanet.lucy.server.util.db
Interface IDbPreparedStatement

All Superinterfaces:

ICloseable

All Known Implementing Classes:

DbPreparedStatement

public interface IDbPreparedStatement
extends ICloseable

Version:

$Revision: 86610 $

Method Summary

void	close() Close this statement.
void	execute()
java.lang.Object	executeAndGetScalarValue() Get the value of the first column in the first row of the result set.
java.lang.Object	executeAndGetScalarValue(java.lang.Object p_valueFallback) Get the value of the first column in the first row of the result set.
IValueHolder<?>	executeAndGetScalarValueHolder() Get the value of the first column in the first row of the result set.
DbResultSet	executeQuery()
int	executeUpdate()
void	setBigDecimal(int p_iIdx, java.lang.Object p_value)
void	setBoolean(int p_iIdx, java.lang.Object p_value)
void	setByte(int p_iIdx, java.lang.Object p_value)
void	setCharacterStream(int p_iIdx, java.lang.Object p_value)
void	setDate(int p_iIdx, java.lang.Object p_value)
void	setDate(int p_iIdx, java.lang.Object p_value, java.util.Calendar p_cal)
void	setDate(int p_iIdx, java.lang.Object p_value, java.util.TimeZone p_tz)
void	setDouble(int p_iIdx, java.lang.Object p_value)
void	setFloat(int p_iIdx, java.lang.Object p_value)
void	setInt(int p_iIdx, java.lang.Object p_value)
void	setLong(int p_iIdx, java.lang.Object p_value)
void	setShort(int p_iIdx, java.lang.Object p_value)
void	setString(int p_iIdx, java.lang.Object p_value)
void	setTime(int p_iIdx, java.lang.Object p_value)
void	setTime(int p_iIdx, java.lang.Object p_value, java.util.Calendar p_cal)
void	setTime(int p_iIdx, java.lang.Object p_value, java.util.TimeZone p_tz)
void	setTimestamp(int p_iIdx, java.lang.Object p_value)
void	setTimestamp(int p_iIdx, java.lang.Object p_value, java.util.Calendar p_cal)
void	setTimestamp(int p_iIdx, java.lang.Object p_value, java.util.TimeZone p_tz)

Method Detail

execute

void execute()
             throws java.sql.SQLException

Throws:

java.sql.SQLException

executeUpdate

int executeUpdate()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQuery

DbResultSet executeQuery()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

executeAndGetScalarValueHolder

IValueHolder<?> executeAndGetScalarValueHolder()
                                               throws java.sql.SQLException

Get the value of the first column in the first row of the result set.

If the result set is empty, null is returned.

Returns:

A value holder that contains the value of the first column in the first row of the result set, or null if the result set is empty.

Throws:

java.sql.SQLException

executeAndGetScalarValue

java.lang.Object executeAndGetScalarValue(java.lang.Object p_valueFallback)
                                          throws java.sql.SQLException

Get the value of the first column in the first row of the result set.

If the result set is empty, or the value is null, p_valueIfNull is returned.

Parameters:

p_valueFallback - The return value if the query returns an empty result set or null.

Returns:

The value of the first column in the first row of the result set, or p_valueIfNull if the result set is empty, or the value is null.

Throws:

java.sql.SQLException

executeAndGetScalarValue

java.lang.Object executeAndGetScalarValue()
                                          throws java.sql.SQLException

Get the value of the first column in the first row of the result set.

If the result set is empty, null is returned.

Returns:

The value of the first column in the first row of the result set, or null if the result set is empty.

Throws:

java.sql.SQLException

setBoolean

void setBoolean(int p_iIdx,
                java.lang.Object p_value)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

setInt

void setInt(int p_iIdx,
            java.lang.Object p_value)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

setLong

void setLong(int p_iIdx,
             java.lang.Object p_value)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setShort

void setShort(int p_iIdx,
              java.lang.Object p_value)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setByte

void setByte(int p_iIdx,
             java.lang.Object p_value)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setBigDecimal

void setBigDecimal(int p_iIdx,
                   java.lang.Object p_value)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

setFloat

void setFloat(int p_iIdx,
              java.lang.Object p_value)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setDouble

void setDouble(int p_iIdx,
               java.lang.Object p_value)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setTimestamp

void setTimestamp(int p_iIdx,
                  java.lang.Object p_value)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

setTimestamp

void setTimestamp(int p_iIdx,
                  java.lang.Object p_value,
                  java.util.TimeZone p_tz)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

setTimestamp

void setTimestamp(int p_iIdx,
                  java.lang.Object p_value,
                  java.util.Calendar p_cal)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

setTime

void setTime(int p_iIdx,
             java.lang.Object p_value)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setTime

void setTime(int p_iIdx,
             java.lang.Object p_value,
             java.util.TimeZone p_tz)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setTime

void setTime(int p_iIdx,
             java.lang.Object p_value,
             java.util.Calendar p_cal)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setDate

void setDate(int p_iIdx,
             java.lang.Object p_value)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setDate

void setDate(int p_iIdx,
             java.lang.Object p_value,
             java.util.TimeZone p_tz)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setDate

void setDate(int p_iIdx,
             java.lang.Object p_value,
             java.util.Calendar p_cal)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setString

void setString(int p_iIdx,
               java.lang.Object p_value)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setCharacterStream

void setCharacterStream(int p_iIdx,
                        java.lang.Object p_value)
                        throws java.sql.SQLException,
                               java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

close

void close()
           throws java.sql.SQLException

Close this statement.

Specified by:

close in interface ICloseable

Throws:

java.sql.SQLException - If a database error occurred.