jodd.db.orm
Class DbOrmQuery

java.lang.Object
  jodd.db.DbQuery
      jodd.db.orm.DbOrmQuery

public class DbOrmQuery
extends DbQuery

A simple ORM extension for DbQuery.

ORM extension may map results to objects in two ways:

• auto mode - when result set is mapped to provided types, and
• mapped mode - requires explicit mapping definitions.

By default, after invocation of listXxx() methods, query are not closed.

Field Summary

protected DbOrm	orm
protected DbSqlGenerator	sqlgen

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

DbOrmQuery(java.sql.Connection conn, DbSqlGenerator sqlgen)

DbOrmQuery(java.sql.Connection conn, DbSqlGenerator sqlgen, DbQueryMode mode)

DbOrmQuery(java.sql.Connection conn, java.lang.String sqlString)

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

DbOrmQuery(DbSession session, DbSqlGenerator sqlgen)

DbOrmQuery(DbSession session, DbSqlGenerator sqlgen, DbQueryMode mode)

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

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

DbOrmQuery(DbSqlGenerator sqlgen)

DbOrmQuery(DbSqlGenerator sqlgen, DbQueryMode mode)

DbOrmQuery(java.lang.String sqlString)

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

Method Summary

ResultSetMapper	buildResultSetMapper() Builds new ResultSet mapper.
protected void	close(ResultSetMapper rsm, boolean closeQuery) Closes results set or whole query.
java.lang.Object[]	find(java.lang.Class... types)
protected java.lang.Object[]	find(java.lang.Class[] types, boolean close)
java.lang.Object[]	find(DbOrmJoin rel)
java.lang.Object[]	findAndClose(java.lang.Class... types)
<T> T	findOne(java.lang.Class<T> type)
protected <T> T	findOne(java.lang.Class<T> type, boolean close)
<T> T	findOne(DbOrmJoin rel)
<T> T	findOneAndClose(java.lang.Class<T> type)
protected void	init(java.sql.Connection conn, java.lang.String sqlString, DbQueryMode mode) Initializes query.
protected void	initDbSqlGen() Initializes class when DbSqlGenerator is used.
java.util.Iterator<java.lang.Object[]>	iterate(java.lang.Class... types)
protected java.util.Iterator<java.lang.Object[]>	iterate(java.lang.Class[] types, boolean close)
java.util.Iterator<java.lang.Object[]>	iterateAndClose(java.lang.Class... types)
<T> java.util.Iterator<T>	iterateOne(java.lang.Class<T> type)
protected <T> java.util.Iterator<T>	iterateOne(java.lang.Class<T> type, boolean close)
<T> java.util.Iterator<T>	iterateOneAndClose(java.lang.Class<T> type)
java.util.List<java.lang.Object[]>	list(java.lang.Class... types)
protected java.util.List<java.lang.Object[]>	list(java.lang.Class[] types, boolean close)
java.util.List<java.lang.Object[]>	list(DbOrmJoin rel)
java.util.List<java.lang.Object[]>	listAndClose(java.lang.Class... types)
<T> java.util.List<T>	listOne(java.lang.Class<T> type)
protected <T> java.util.List<T>	listOne(java.lang.Class<T> type, boolean close)
<T> java.util.List<T>	listOne(DbOrmJoin rel)
<T> java.util.List<T>	listOneAndClose(java.lang.Class<T> type)
java.util.Set<java.lang.Object[]>	listSet(java.lang.Class... types)
protected java.util.Set<java.lang.Object[]>	listSet(java.lang.Class[] types, boolean close)
java.util.Set<java.lang.Object[]>	listSet(DbOrmJoin rel)
java.util.Set<java.lang.Object[]>	listSetAndClose(java.lang.Class... types)
<T> java.util.Set<T>	listSetOne(java.lang.Class<T> type)
protected <T> java.util.Set<T>	listSetOne(java.lang.Class<T> type, boolean close)
<T> java.util.Set<T>	listSetOne(DbOrmJoin rel)
<T> java.util.Set<T>	listSetOneAndClose(java.lang.Class<T> type)
void	reset() Resets an used query, using the same connection, sql query string and query mode, Closes current statement and creates a new one.

Methods inherited from class jodd.db.DbQuery

checkActive, close, close, closeQuery, execute, executeCount, executeCount, executeCountAndClose, executeUpdate, executeUpdate, executeUpdateAndClose, getOpenResultSetCount, getQueryString, getSession, getTotalOpenResultSetCount, init, isActive, isClosed, 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

Field Detail

orm

protected DbOrm orm

sqlgen

protected DbSqlGenerator sqlgen

Constructor Detail

DbOrmQuery

public DbOrmQuery(java.sql.Connection conn,
                  java.lang.String sqlString)

DbOrmQuery

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

DbOrmQuery

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

DbOrmQuery

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

DbOrmQuery

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

DbOrmQuery

public DbOrmQuery(java.lang.String sqlString)

DbOrmQuery

public DbOrmQuery(java.sql.Connection conn,
                  DbSqlGenerator sqlgen)

DbOrmQuery

public DbOrmQuery(java.sql.Connection conn,
                  DbSqlGenerator sqlgen,
                  DbQueryMode mode)

DbOrmQuery

public DbOrmQuery(DbSession session,
                  DbSqlGenerator sqlgen,
                  DbQueryMode mode)

DbOrmQuery

public DbOrmQuery(DbSession session,
                  DbSqlGenerator sqlgen)

DbOrmQuery

public DbOrmQuery(DbSqlGenerator sqlgen,
                  DbQueryMode mode)

DbOrmQuery

public DbOrmQuery(DbSqlGenerator sqlgen)

Method Detail

init

protected void init(java.sql.Connection conn,
                    java.lang.String sqlString,
                    DbQueryMode mode)

Description copied from class: DbQuery

Initializes query. Must be called from ctors.

Overrides:

init in class DbQuery

initDbSqlGen

protected void initDbSqlGen()

Initializes class when DbSqlGenerator is used.

reset

public void reset()

Description copied from class: DbQuery

Resets an used query, using the same connection, sql query string and query mode, Closes current statement and creates a new one.

Overrides:

reset in class DbQuery

buildResultSetMapper

public ResultSetMapper buildResultSetMapper()

Builds new ResultSet mapper. This method acts as a factory.

iterateOne

public <T> java.util.Iterator<T> iterateOne(java.lang.Class<T> type)

iterateOneAndClose

public <T> java.util.Iterator<T> iterateOneAndClose(java.lang.Class<T> type)

iterateOne

protected <T> java.util.Iterator<T> iterateOne(java.lang.Class<T> type,
                                               boolean close)

iterate

public java.util.Iterator<java.lang.Object[]> iterate(java.lang.Class... types)

iterateAndClose

public java.util.Iterator<java.lang.Object[]> iterateAndClose(java.lang.Class... types)

iterate

protected java.util.Iterator<java.lang.Object[]> iterate(java.lang.Class[] types,
                                                         boolean close)

listOne

public <T> java.util.List<T> listOne(java.lang.Class<T> type)

listOneAndClose

public <T> java.util.List<T> listOneAndClose(java.lang.Class<T> type)

listOne

protected <T> java.util.List<T> listOne(java.lang.Class<T> type,
                                        boolean close)

listOne

public <T> java.util.List<T> listOne(DbOrmJoin rel)

list

public java.util.List<java.lang.Object[]> list(java.lang.Class... types)

listAndClose

public java.util.List<java.lang.Object[]> listAndClose(java.lang.Class... types)

list

protected java.util.List<java.lang.Object[]> list(java.lang.Class[] types,
                                                  boolean close)

list

public java.util.List<java.lang.Object[]> list(DbOrmJoin rel)

listSetOne

public <T> java.util.Set<T> listSetOne(java.lang.Class<T> type)

listSetOneAndClose

public <T> java.util.Set<T> listSetOneAndClose(java.lang.Class<T> type)

listSetOne

protected <T> java.util.Set<T> listSetOne(java.lang.Class<T> type,
                                          boolean close)

listSetOne

public <T> java.util.Set<T> listSetOne(DbOrmJoin rel)

listSet

public java.util.Set<java.lang.Object[]> listSet(java.lang.Class... types)

listSetAndClose

public java.util.Set<java.lang.Object[]> listSetAndClose(java.lang.Class... types)

listSet

protected java.util.Set<java.lang.Object[]> listSet(java.lang.Class[] types,
                                                    boolean close)

listSet

public java.util.Set<java.lang.Object[]> listSet(DbOrmJoin rel)

findOne

public <T> T findOne(java.lang.Class<T> type)

findOneAndClose

public <T> T findOneAndClose(java.lang.Class<T> type)

findOne

protected <T> T findOne(java.lang.Class<T> type,
                        boolean close)

findOne

public <T> T findOne(DbOrmJoin rel)

find

public java.lang.Object[] find(java.lang.Class... types)

findAndClose

public java.lang.Object[] findAndClose(java.lang.Class... types)

find

protected java.lang.Object[] find(java.lang.Class[] types,
                                  boolean close)

find

public java.lang.Object[] find(DbOrmJoin rel)

close

protected void close(ResultSetMapper rsm,
                     boolean closeQuery)

Closes results set or whole query.