java.lang.Object

nablarch.core.db.statement.BasicSqlPStatement

nablarch.core.db.statement.BasicSqlCStatement

All Implemented Interfaces:: ParameterizedSqlPStatement, SqlCStatement, SqlPStatement, SqlStatement

public class BasicSqlCStatement extends BasicSqlPStatement implements SqlCStatement

CallableStatementのラッパークラス。

Author:

hisaaki sioiri

See Also:

CallableStatement

Field Summary

Fields inherited from class nablarch.core.db.statement.BasicSqlPStatement
paramHolder
Constructor Summary

Constructors

Constructor

Description

BasicSqlCStatement(String sql, CallableStatement statement)

コンストラクタ。
Method Summary

Modifier and Type

Method

Description

BigDecimal

getBigDecimal(int parameterIndex)

CallableStatement.getBigDecimal(int).

Blob

getBlob(int parameterIndex)

CallableStatement.getBlob(int).

Boolean

getBoolean(int parameterIndex)

CallableStatement.getBoolean(int).

byte[]

getBytes(int parameterIndex)

CallableStatement.getByte(int).

Clob

getClob(int parameterIndex)

CallableStatement.getClob(int).

Date

getDate(int parameterIndex)

CallableStatement.getDate(int).

Integer

getInteger(int parameterIndex)

CallableStatement.getInt(int).

Long

getLong(int parameterIndex)

CallableStatement.getInt(int).

Object

getObject(int parameterIndex)

CallableStatement.getObject(int).

Short

getShort(int parameterIndex)

CallableStatement.getShort(int).

String

getString(int parameterIndex)

CallableStatement.getString(int).

Time

getTime(int parameterIndex)

CallableStatement.getTime(int).

Timestamp

getTimestamp(int parameterIndex)

CallableStatement.getTimestamp(int) (int)}.

void

registerOutParameter(int parameterIndex, int sqlType)

CallableStatement.registerOutParameter(int, int).

void

registerOutParameter(int parameterIndex, int sqlType, int scale)

CallableStatement.registerOutParameter(int, int, int).

Methods inherited from class nablarch.core.db.statement.BasicSqlPStatement
addBatch, addBatchMap, addBatchObject, clearBatch, clearParameters, close, createBatchParamHolder, createParamHolder, createSqlResultSet, doRetrieve, execute, executeBatch, executeQuery, executeQueryByMap, executeQueryByObject, executeUpdate, executeUpdateByMap, executeUpdateByObject, getBatchSize, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxRows, getMetaData, getMoreResults, getMoreResults, getParameters, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, isClosed, isTraceLogEnabled, retrieve, retrieve, retrieve, retrieve, retrieve, retrieve, setAdditionalInfo, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setContext, setDate, setDate, setDouble, setFetchDirection, setFetchSize, setFloat, setInt, setJdbcTransactionTimeoutHandler, setLikeEscapeChar, setLikeEscapeTargetCharList, setLong, setMaxRows, setNull, setNull, setObject, setObject, setQueryTimeout, setRef, setSelectOption, setShort, setSqlStatementExceptionFactory, setString, setTime, setTime, setTimestamp, setTimestamp, setUpdatePreHookObjectHandlerList, setURL

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface nablarch.core.db.statement.SqlPStatement
addBatch, clearParameters, execute, executeQuery, executeUpdate, getFetchDirection, getGeneratedKeys, getMetaData, getMoreResults, getMoreResults, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, retrieve, retrieve, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFetchDirection, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setURL

Methods inherited from interface nablarch.core.db.statement.SqlStatement
clearBatch, close, executeBatch, getBatchSize, getConnection, getFetchSize, getMaxRows, getQueryTimeout, getUpdateCount, isClosed, setFetchSize, setJdbcTransactionTimeoutHandler, setMaxRows, setQueryTimeout

Constructor Details
- BasicSqlCStatement
  
  public BasicSqlCStatement(String sql, CallableStatement statement)
  
  コンストラクタ。
  
  Parameters:
  
  sql - SQL文
  
  statement - CallableStatement
Method Details
- registerOutParameter
  
  public void registerOutParameter(int parameterIndex, int sqlType)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.registerOutParameter(int, int).
  
  Specified by:
  
  registerOutParameter in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  sqlType - Types
- registerOutParameter
  
  public void registerOutParameter(int parameterIndex, int sqlType, int scale)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.registerOutParameter(int, int, int).
  
  Specified by:
  
  registerOutParameter in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  sqlType - Types
  
  scale - 小数点以下の桁数(0以上であること)
- getObject
  
  public Object getObject(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getObject(int).
  
  Specified by:
  
  getObject in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getString
  
  public String getString(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getString(int).
  
  Specified by:
  
  getString in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull)
- getInteger
  
  public Integer getInteger(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getInt(int).
  
  Specified by:
  
  getInteger in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getLong
  
  public Long getLong(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getInt(int).
  
  Specified by:
  
  getLong in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getShort
  
  public Short getShort(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getShort(int).
  
  Specified by:
  
  getShort in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getBigDecimal
  
  public BigDecimal getBigDecimal(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getBigDecimal(int).
  
  Specified by:
  
  getBigDecimal in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull)
- getDate
  
  public Date getDate(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getDate(int).
  
  Specified by:
  
  getDate in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getTime
  
  public Time getTime(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getTime(int).
  
  Specified by:
  
  getTime in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getTimestamp
  
  public Timestamp getTimestamp(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getTimestamp(int) (int)}.
  
  Specified by:
  
  getTimestamp in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getBoolean
  
  public Boolean getBoolean(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getBoolean(int).
  
  Specified by:
  
  getBoolean in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getBytes
  
  public byte[] getBytes(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getByte(int).
  
  Specified by:
  
  getBytes in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getBlob
  
  public Blob getBlob(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getBlob(int).
  
  Specified by:
  
  getBlob in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);
- getClob
  
  public Clob getClob(int parameterIndex)
  
  Description copied from interface: SqlCStatement
  
  CallableStatement.getClob(int).
  
  Specified by:
  
  getClob in interface SqlCStatement
  
  Parameters:
  
  parameterIndex - パラメータインデックス
  
  Returns:
  
  パラメータインデックスに対応する値(値がnullの場合はnull);

Class BasicSqlCStatement

Field Summary

Fields inherited from class nablarch.core.db.statement.BasicSqlPStatement

Constructor Summary

Method Summary

Methods inherited from class nablarch.core.db.statement.BasicSqlPStatement

Methods inherited from class java.lang.Object

Methods inherited from interface nablarch.core.db.statement.SqlPStatement

Methods inherited from interface nablarch.core.db.statement.SqlStatement

Constructor Details

BasicSqlCStatement

Method Details

registerOutParameter

registerOutParameter

getObject

getString

getInteger

getLong

getShort

getBigDecimal

getDate

getTime

getTimestamp

getBoolean

getBytes

getBlob

getClob