org.hydrateframework.sql
Interface NamedParameterStatement

All Superinterfaces:

java.sql.PreparedStatement, java.sql.Statement

All Known Subinterfaces:

MappedStatement

All Known Implementing Classes:

AbstractParameterStatement, ParsedQuery, QueryMap, SimpleParameterStatement

public interface NamedParameterStatement
extends java.sql.PreparedStatement

Version:

@(#)$Revision: 1.2 $

Author:

David Chamberlin

Field Summary

static int	STMT_DELETE
static int	STMT_INSERT
static int	STMT_NONE
static int	STMT_SELECT
static int	STMT_UPDATE
static int	STRATEGY_BATCH
static int	STRATEGY_NOPREPARE

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Method Summary

java.sql.ResultSet	executeForDelete()
java.sql.ResultSet	executeForInsert()
java.sql.ResultSet	executeForUpdate()
int	getParameterCount()
java.lang.String	getParameterName(int idx)
java.lang.String[]	getParameterNames()
java.lang.String	getParameterType(java.lang.String name)
int	getUpdateStrategy()
void	setBoolean(java.lang.String name, boolean x)
void	setDate(java.lang.String name, java.util.Date date)
void	setDouble(java.lang.String name, double x)
void	setInt(java.lang.String name, int x)
void	setLong(java.lang.String name, long x)
void	setNull(java.lang.String name, int sqlType)
void	setObject(java.lang.String name, java.lang.Object x)
void	setStatementUsage(int statementType)
void	setString(java.lang.String name, java.lang.String x)
void	setUpdateStrategy(int strategy, int batchSize)

Methods inherited from interface java.sql.PreparedStatement

addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout

Field Detail

STMT_NONE

static final int STMT_NONE

See Also:

Constant Field Values

STMT_SELECT

static final int STMT_SELECT

See Also:

Constant Field Values

STMT_INSERT

static final int STMT_INSERT

See Also:

Constant Field Values

STMT_UPDATE

static final int STMT_UPDATE

See Also:

Constant Field Values

STMT_DELETE

static final int STMT_DELETE

See Also:

Constant Field Values

STRATEGY_NOPREPARE

static final int STRATEGY_NOPREPARE

See Also:

Constant Field Values

STRATEGY_BATCH

static final int STRATEGY_BATCH

See Also:

Constant Field Values

Method Detail

setBoolean

void setBoolean(java.lang.String name,
                boolean x)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

setString

void setString(java.lang.String name,
               java.lang.String x)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setObject

void setObject(java.lang.String name,
               java.lang.Object x)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setInt

void setInt(java.lang.String name,
            int x)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

setLong

void setLong(java.lang.String name,
             long x)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setDouble

void setDouble(java.lang.String name,
               double x)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setNull

void setNull(java.lang.String name,
             int sqlType)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setDate

void setDate(java.lang.String name,
             java.util.Date date)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

getParameterNames

java.lang.String[] getParameterNames()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getParameterName

java.lang.String getParameterName(int idx)
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getParameterCount

int getParameterCount()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getParameterType

java.lang.String getParameterType(java.lang.String name)
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

executeForInsert

java.sql.ResultSet executeForInsert()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

executeForUpdate

java.sql.ResultSet executeForUpdate()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

executeForDelete

java.sql.ResultSet executeForDelete()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

setStatementUsage

void setStatementUsage(int statementType)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getUpdateStrategy

int getUpdateStrategy()

setUpdateStrategy

void setUpdateStrategy(int strategy,
                       int batchSize)