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.


Last updated: 2011-08-11 10-04
Copyright © 2000-2011 United Planet. All Rights Reserved.