jodd.db
Class DbProfiledQuery

java.lang.Object
  jodd.db.DbQuery
      jodd.db.DbProfiledQuery

public class DbProfiledQuery
extends DbQuery

Profiled DbQuery measures query execution time. May be used for debugging purposes.

Field Summary

Fields inherited from class jodd.db.DbQuery

connection, DEFAULT_QUERY_MODE, fetchSize, FORCE_PREPARED_STATEMENTS, mode, preparedStatement, query, resultSets, session, SESSION_PROVIDER, sqlString, statement, totalOpenResultSetCount

Constructor Summary

DbProfiledQuery(java.sql.Connection conn, java.lang.String sql)

DbProfiledQuery(java.sql.Connection conn, java.lang.String sqlString, DbQueryMode mode)

DbProfiledQuery(DbSession session, java.lang.String sqlString)

DbProfiledQuery(DbSession session, java.lang.String sqlString, DbQueryMode mode)

DbProfiledQuery(java.lang.String sqlString)

DbProfiledQuery(java.lang.String sqlString, DbQueryMode mode)

Method Summary

java.sql.ResultSet	execute() Executes query.
int	executeUpdate() Executes UPDATE, INSERT or DELETE queries.
long	getExecutionElapsedTime() Returns query execution elapsed time in ms.
java.lang.String	getQueryString() Returns query sql string.

Methods inherited from class jodd.db.DbQuery

checkActive, close, close, closeQuery, executeCount, executeCount, executeCountAndClose, executeUpdate, executeUpdateAndClose, getOpenResultSetCount, getSession, getTotalOpenResultSetCount, init, init, isActive, isClosed, reset, setArray, setArray, setBean, setBean, setBigDecimal, setBigDecimal, setBigInteger, setBigInteger, setBlob, setBlob, setBoolean, setBoolean, setBoolean, setBoolean, setByte, setByte, setByte, setByte, setBytes, setBytes, setClob, setClob, setDate, setDate, setDouble, setDouble, setDouble, setDouble, setFetchSize, setFloat, setFloat, setFloat, setFloat, setInteger, setInteger, setInteger, setInteger, setLong, setLong, setLong, setLong, setMaxRows, setNull, setNull, setObject, setObject, setParameters, setRef, setRef, setShort, setShort, setShort, setShort, setString, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, setURL, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

DbProfiledQuery

public DbProfiledQuery(java.sql.Connection conn,
                       java.lang.String sql)

DbProfiledQuery

public DbProfiledQuery(java.sql.Connection conn,
                       java.lang.String sqlString,
                       DbQueryMode mode)

DbProfiledQuery

public DbProfiledQuery(DbSession session,
                       java.lang.String sqlString,
                       DbQueryMode mode)

DbProfiledQuery

public DbProfiledQuery(DbSession session,
                       java.lang.String sqlString)

DbProfiledQuery

public DbProfiledQuery(java.lang.String sqlString,
                       DbQueryMode mode)

DbProfiledQuery

public DbProfiledQuery(java.lang.String sqlString)

Method Detail

executeUpdate

public int executeUpdate()

Description copied from class: DbQuery

Executes UPDATE, INSERT or DELETE queries.

Overrides:

executeUpdate in class DbQuery

See Also:

Statement.executeUpdate(String)

execute

public java.sql.ResultSet execute()

Description copied from class: DbQuery

Executes query. If this method is invoked at least once, the query or all created resultsets must be explicitly closed at the end of query usage. This can be done explicitly by calling DbQuery.close(java.sql.ResultSet) оr implicitly, during DbQuery.close(). The fetch size is set before execution.

Overrides:

execute in class DbQuery

See Also:

Statement.execute(String)

getExecutionElapsedTime

public long getExecutionElapsedTime()

Returns query execution elapsed time in ms. Returns -1 if query is still not executed.

getQueryString

public java.lang.String getQueryString()

Description copied from class: DbQuery

Returns query sql string. For prepared statements, returns sql string with quick-and-dirty replaced values.

Overrides:

getQueryString in class DbQuery