CmsPreparedStatement

Overview

Package

Class

Use

Deprecated

Index

Home >> All >> com >> opencms >> [ dbpool overview ]

PREV CLASS NEXT CLASS

SUMMARY:

JAVADOC |

Sourc code of com.opencms.dbpool.CmsPreparedStatement

SOURCE |

Download com.opencms.dbpool.CmsPreparedStatement

DOWNLOAD | NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.opencms.dbpool
Class CmsPreparedStatement

java.lang.Object
  com.opencms.dbpool.CmsStatement
      com.opencms.dbpool.CmsPreparedStatement

All Implemented Interfaces:: java.sql.PreparedStatement, java.sql.Statement

Direct Known Subclasses:: CmsCallableStatement

public class CmsPreparedStatement
extends CmsStatement
implements java.sql.PreparedStatement

An object that represents a precompiled SQL statement.

Field Summary

Fields inherited from class com.opencms.dbpool.CmsStatement

m_con, m_originalStatement

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

Constructor Summary

(package private) CmsPreparedStatement()
          The default-constructor to create a new statement

(package private) CmsPreparedStatement(java.sql.PreparedStatement originalStatement, CmsConnection con)
          The constructor to create a new statement

Method Summary

void addBatch()
          This method adds a set of parameters to the batch for JDBC 2.0.

void clearParameters()
          This method clears all of the input parameter that have been set on this statement.

boolean execute()
          This method executes a prepared SQL query.

java.sql.ResultSet executeQuery()
          This method executes a prepared SQL query and returns its ResultSet.

int executeUpdate()
          This method executes an SQL INSERT, UPDATE or DELETE statement.

java.sql.ResultSetMetaData getMetaData()
          This method returns meta data for the result set from this statement.

java.sql.ParameterMetaData getParameterMetaData()
          Returns information about the parameters set on this PreparedStatement (see java.sql.ParameterMetaData for a detailed description of the provided information).

void setArray(int i, java.sql.Array x)
          This method sets the specified parameter from the given Java Array value.

void setAsciiStream(int parameterIndex, java.io.InputStream x, int length)
          This method sets the specified parameter from the given Java ASCII InputStream value.

void setBigDecimal(int parameterIndex, java.math.BigDecimal x)
          This method sets the specified parameter from the given Java java.math.BigDecimal value.

void setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
          This method sets the specified parameter from the given Java binary InputStream value.

void setBlob(int i, java.sql.Blob x)
          This method sets the specified parameter from the given Java Blob value.

void setBoolean(int parameterIndex, boolean x)
          This method sets the specified parameter from the given Java boolean value.

void setByte(int parameterIndex, byte x)
          This method sets the specified parameter from the given Java byte value.

void setBytes(int parameterIndex, byte[] x)
          This method sets the specified parameter from the given Java byte array value.

void setCharacterStream(int parameterIndex, java.io.Reader reader, int length)
          This method sets the specified parameter from the given Java character Reader value.

void setClob(int i, java.sql.Clob x)
          This method sets the specified parameter from the given Java Clob value.

void setDate(int parameterIndex, java.sql.Date x)
          This method sets the specified parameter from the given Java java.sql.Date value.

void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal)
          This method sets the specified parameter from the given Java java.sql.Date value.

void setDouble(int parameterIndex, double x)
          This method sets the specified parameter from the given Java double value.

void setFloat(int parameterIndex, float x)
          This method sets the specified parameter from the given Java float value.

void setInt(int parameterIndex, int x)
          This method sets the specified parameter from the given Java int value.

void setLong(int parameterIndex, long x)
          This method sets the specified parameter from the given Java long value.

void setNull(int parameterIndex, int sqlType)
          This method populates the specified parameter with a SQL NULL value for the specified type.

void setNull(int paramIndex, int sqlType, java.lang.String typeName)
          This method populates the specified parameter with a SQL NULL value for the specified type.

void setObject(int parameterIndex, java.lang.Object x)
          This method sets the specified parameter from the given Java Object value.

void setObject(int parameterIndex, java.lang.Object x, int targetSqlType)
          This method sets the specified parameter from the given Java Object value.

void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale)
          This method sets the specified parameter from the given Java Object value.

void setRef(int i, java.sql.Ref x)
          This method sets the specified parameter from the given Java Ref value.

void setShort(int parameterIndex, short x)
          This method sets the specified parameter from the given Java short value.

void setString(int parameterIndex, java.lang.String x)
          This method sets the specified parameter from the given Java String value.

void setTime(int parameterIndex, java.sql.Time x)
          This method sets the specified parameter from the given Java java.sql.Time value.

void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)
          This method sets the specified parameter from the given Java java.sql.Time value.

void setTimestamp(int parameterIndex, java.sql.Timestamp x)
          This method sets the specified parameter from the given Java java.sql.Timestamp value.

void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)
          This method sets the specified parameter from the given Java java.sql.Timestamp value.

void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)
          This method sets the specified parameter from the given Java Unicode UTF-8 InputStream value.

void setURL(int param, java.net.URL uRL)
          This method sets the specified parameter from the given Java java.net.URL value.

Methods inherited from class com.opencms.dbpool.CmsStatement

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

Methods inherited from class java.lang.Object

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

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

Constructor Detail

CmsPreparedStatement

CmsPreparedStatement()

The default-constructor to create a new statement

CmsPreparedStatement

CmsPreparedStatement(java.sql.PreparedStatement originalStatement,
                     CmsConnection con)

The constructor to create a new statement

Method Detail