BaseLoggableStatement (Jodd API Documentation)

java.lang.Object
- jodd.db.debug.BaseLoggableStatement<S>

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.Statement, java.sql.Wrapper

Direct Known Subclasses:

LoggablePreparedStatement
```
public abstract class BaseLoggableStatement<S extends java.sql.Statement>
extends java.lang.Object
implements java.sql.Statement
```

Field Summary

Fields
Modifier and Type Field and Description

protected java.util.ArrayList<java.lang.String> parameterValues

protected java.lang.String sqlTemplate

protected S wrappedStatement
- 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

Fields
Modifier and Type	Field and Description
`protected java.util.ArrayList<java.lang.String>`	`parameterValues`
`protected java.lang.String`	`sqlTemplate`
`protected S`	`wrappedStatement`

Constructor Summary

Constructors
Constructor and Description

BaseLoggableStatement(S wrappedStatement, java.lang.String sqlTemplate)

Constructors
Constructor and Description
`BaseLoggableStatement(S wrappedStatement, java.lang.String sqlTemplate)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addBatch(java.lang.String sql)`
`void`	`cancel()`
`void`	`clearBatch()`
`void`	`clearWarnings()`
`void`	`close()`
`void`	`closeOnCompletion()`
`boolean`	`execute(java.lang.String sql)`
`boolean`	`execute(java.lang.String sql, int autoGeneratedKeys)`
`boolean`	`execute(java.lang.String sql, int[] columnIndexes)`
`boolean`	`execute(java.lang.String sql, java.lang.String[] columnNames)`
`int[]`	`executeBatch()`
`java.sql.ResultSet`	`executeQuery(java.lang.String sql)`
`int`	`executeUpdate(java.lang.String sql)`
`int`	`executeUpdate(java.lang.String sql, int autoGeneratedKeys)`
`int`	`executeUpdate(java.lang.String sql, int[] columnIndexes)`
`int`	`executeUpdate(java.lang.String sql, java.lang.String[] columnNames)`
`java.sql.Connection`	`getConnection()`
`int`	`getFetchDirection()`
`int`	`getFetchSize()`
`java.sql.ResultSet`	`getGeneratedKeys()`
`int`	`getMaxFieldSize()`
`int`	`getMaxRows()`
`boolean`	`getMoreResults()`
`boolean`	`getMoreResults(int current)`
`java.lang.String`	`getQueryString()` Returns the query string.
`int`	`getQueryTimeout()`
`java.sql.ResultSet`	`getResultSet()`
`int`	`getResultSetConcurrency()`
`int`	`getResultSetHoldability()`
`int`	`getResultSetType()`
`int`	`getUpdateCount()`
`java.sql.SQLWarning`	`getWarnings()`
`boolean`	`isClosed()`
`boolean`	`isCloseOnCompletion()`
`boolean`	`isPoolable()`
`boolean`	`isWrapperFor(java.lang.Class<?> iface)`
`protected void`	`saveQueryParamValue(int position, java.lang.Object obj)` Saves the parameter value `obj` for the specified `position` for use in logging output.
`void`	`setCursorName(java.lang.String name)`
`void`	`setEscapeProcessing(boolean enable)`
`void`	`setFetchDirection(int direction)`
`void`	`setFetchSize(int rows)`
`void`	`setMaxFieldSize(int max)`
`void`	`setMaxRows(int max)`
`void`	`setPoolable(boolean poolable)`
`void`	`setQueryTimeout(int seconds)`
`<T> T`	`unwrap(java.lang.Class<T> iface)`

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

Methods inherited from interface java.sql.Statement
executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, setLargeMaxRows

Field Detail

wrappedStatement

protected final S extends java.sql.Statement wrappedStatement

sqlTemplate

protected final java.lang.String sqlTemplate

parameterValues

protected java.util.ArrayList<java.lang.String> parameterValues

Constructor Detail

BaseLoggableStatement

public BaseLoggableStatement(S wrappedStatement,
                             java.lang.String sqlTemplate)

Method Detail
- getQueryString
```
public java.lang.String getQueryString()
```
  Returns the query string.
- saveQueryParamValue
```
protected void saveQueryParamValue(int position,
                                   java.lang.Object obj)
```
  Saves the parameter value obj for the specified position for use in logging output.
  
  Parameters:
  
  position - position (starting at 1) of the parameter to save
  
  obj - java.lang.Object the parameter value to save
- executeQuery
```
public java.sql.ResultSet executeQuery(java.lang.String sql)
                                throws java.sql.SQLException
```
  Specified by:
  
  executeQuery in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- executeUpdate
```
public int executeUpdate(java.lang.String sql)
                  throws java.sql.SQLException
```
  Specified by:
  
  executeUpdate in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- close
```
public void close()
           throws java.sql.SQLException
```
  Specified by:
  
  close in interface java.lang.AutoCloseable
  
  Specified by:
  
  close in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getMaxFieldSize
```
public int getMaxFieldSize()
                    throws java.sql.SQLException
```
  Specified by:
  
  getMaxFieldSize in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- setMaxFieldSize
```
public void setMaxFieldSize(int max)
                     throws java.sql.SQLException
```
  Specified by:
  
  setMaxFieldSize in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getMaxRows
```
public int getMaxRows()
               throws java.sql.SQLException
```
  Specified by:
  
  getMaxRows in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- setMaxRows
```
public void setMaxRows(int max)
                throws java.sql.SQLException
```
  Specified by:
  
  setMaxRows in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- setEscapeProcessing
```
public void setEscapeProcessing(boolean enable)
                         throws java.sql.SQLException
```
  Specified by:
  
  setEscapeProcessing in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getQueryTimeout
```
public int getQueryTimeout()
                    throws java.sql.SQLException
```
  Specified by:
  
  getQueryTimeout in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- setQueryTimeout
```
public void setQueryTimeout(int seconds)
                     throws java.sql.SQLException
```
  Specified by:
  
  setQueryTimeout in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- cancel
```
public void cancel()
            throws java.sql.SQLException
```
  Specified by:
  
  cancel in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getWarnings
```
public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
```
  Specified by:
  
  getWarnings in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- clearWarnings
```
public void clearWarnings()
                   throws java.sql.SQLException
```
  Specified by:
  
  clearWarnings in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- setCursorName
```
public void setCursorName(java.lang.String name)
                   throws java.sql.SQLException
```
  Specified by:
  
  setCursorName in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- execute
```
public boolean execute(java.lang.String sql)
                throws java.sql.SQLException
```
  Specified by:
  
  execute in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getResultSet
```
public java.sql.ResultSet getResultSet()
                                throws java.sql.SQLException
```
  Specified by:
  
  getResultSet in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getUpdateCount
```
public int getUpdateCount()
                   throws java.sql.SQLException
```
  Specified by:
  
  getUpdateCount in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getMoreResults
```
public boolean getMoreResults()
                       throws java.sql.SQLException
```
  Specified by:
  
  getMoreResults in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- setFetchDirection
```
public void setFetchDirection(int direction)
                       throws java.sql.SQLException
```
  Specified by:
  
  setFetchDirection in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getFetchDirection
```
public int getFetchDirection()
                      throws java.sql.SQLException
```
  Specified by:
  
  getFetchDirection in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- setFetchSize
```
public void setFetchSize(int rows)
                  throws java.sql.SQLException
```
  Specified by:
  
  setFetchSize in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getFetchSize
```
public int getFetchSize()
                 throws java.sql.SQLException
```
  Specified by:
  
  getFetchSize in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getResultSetConcurrency
```
public int getResultSetConcurrency()
                            throws java.sql.SQLException
```
  Specified by:
  
  getResultSetConcurrency in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getResultSetType
```
public int getResultSetType()
                     throws java.sql.SQLException
```
  Specified by:
  
  getResultSetType in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- addBatch
```
public void addBatch(java.lang.String sql)
              throws java.sql.SQLException
```
  Specified by:
  
  addBatch in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- clearBatch
```
public void clearBatch()
                throws java.sql.SQLException
```
  Specified by:
  
  clearBatch in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- executeBatch
```
public int[] executeBatch()
                   throws java.sql.SQLException
```
  Specified by:
  
  executeBatch in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getConnection
```
public java.sql.Connection getConnection()
                                  throws java.sql.SQLException
```
  Specified by:
  
  getConnection in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getMoreResults
```
public boolean getMoreResults(int current)
                       throws java.sql.SQLException
```
  Specified by:
  
  getMoreResults in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getGeneratedKeys
```
public java.sql.ResultSet getGeneratedKeys()
                                    throws java.sql.SQLException
```
  Specified by:
  
  getGeneratedKeys in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- executeUpdate
```
public int executeUpdate(java.lang.String sql,
                         int autoGeneratedKeys)
                  throws java.sql.SQLException
```
  Specified by:
  
  executeUpdate in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- executeUpdate
```
public int executeUpdate(java.lang.String sql,
                         int[] columnIndexes)
                  throws java.sql.SQLException
```
  Specified by:
  
  executeUpdate in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- executeUpdate
```
public int executeUpdate(java.lang.String sql,
                         java.lang.String[] columnNames)
                  throws java.sql.SQLException
```
  Specified by:
  
  executeUpdate in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- execute
```
public boolean execute(java.lang.String sql,
                       int autoGeneratedKeys)
                throws java.sql.SQLException
```
  Specified by:
  
  execute in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- execute
```
public boolean execute(java.lang.String sql,
                       int[] columnIndexes)
                throws java.sql.SQLException
```
  Specified by:
  
  execute in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- execute
```
public boolean execute(java.lang.String sql,
                       java.lang.String[] columnNames)
                throws java.sql.SQLException
```
  Specified by:
  
  execute in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- getResultSetHoldability
```
public int getResultSetHoldability()
                            throws java.sql.SQLException
```
  Specified by:
  
  getResultSetHoldability in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- isClosed
```
public boolean isClosed()
                 throws java.sql.SQLException
```
  Specified by:
  
  isClosed in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- setPoolable
```
public void setPoolable(boolean poolable)
                 throws java.sql.SQLException
```
  Specified by:
  
  setPoolable in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- isPoolable
```
public boolean isPoolable()
                   throws java.sql.SQLException
```
  Specified by:
  
  isPoolable in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- closeOnCompletion
```
public void closeOnCompletion()
                       throws java.sql.SQLException
```
  Specified by:
  
  closeOnCompletion in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- isCloseOnCompletion
```
public boolean isCloseOnCompletion()
                            throws java.sql.SQLException
```
  Specified by:
  
  isCloseOnCompletion in interface java.sql.Statement
  
  Throws:
  
  java.sql.SQLException
- unwrap
```
public <T> T unwrap(java.lang.Class<T> iface)
             throws java.sql.SQLException
```
  Specified by:
  
  unwrap in interface java.sql.Wrapper
  
  Throws:
  
  java.sql.SQLException
- isWrapperFor
```
public boolean isWrapperFor(java.lang.Class<?> iface)
                     throws java.sql.SQLException
```
  Specified by:
  
  isWrapperFor in interface java.sql.Wrapper
  
  Throws:
  
  java.sql.SQLException

Class BaseLoggableStatement<S extends java.sql.Statement>

Field Summary

Fields inherited from interface java.sql.Statement

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.Statement

Field Detail

wrappedStatement

sqlTemplate

parameterValues

Constructor Detail

BaseLoggableStatement

Method Detail

getQueryString

saveQueryParamValue

executeQuery

executeUpdate

close

getMaxFieldSize

setMaxFieldSize

getMaxRows

setMaxRows

setEscapeProcessing

getQueryTimeout

setQueryTimeout

cancel

getWarnings

clearWarnings

setCursorName

execute

getResultSet

getUpdateCount

getMoreResults

setFetchDirection

getFetchDirection

setFetchSize

getFetchSize

getResultSetConcurrency

getResultSetType

addBatch

clearBatch

executeBatch

getConnection

getMoreResults

getGeneratedKeys

executeUpdate

executeUpdate

executeUpdate

execute

execute

execute

getResultSetHoldability

isClosed

setPoolable

isPoolable

closeOnCompletion

isCloseOnCompletion

unwrap

isWrapperFor