com.querydsl.sql

Class SQLQuery<T>

java.lang.Object

com.querydsl.core.support.QueryBase<Q>

com.querydsl.core.support.FetchableQueryBase<T,Q>

com.querydsl.core.support.FetchableSubQueryBase<T,Q>

com.querydsl.sql.ProjectableSQLQuery<T,Q>

com.querydsl.sql.AbstractSQLQuery<T,SQLQuery<T>>

com.querydsl.sql.SQLQuery<T>

Type Parameters:

T -

All Implemented Interfaces:

Fetchable<T>, FetchableQuery<T,SQLQuery<T>>, FilteredClause<SQLQuery<T>>, Query<SQLQuery<T>>, SimpleQuery<SQLQuery<T>>, ExtendedSubQuery<T>, Expression<T>, SubQueryExpression<T>, SQLCommonQuery<SQLQuery<T>>, Serializable

public class SQLQuery<T>
extends AbstractSQLQuery<T,SQLQuery<T>>

SQLQuery is a JDBC based implementation of the SQLCommonQuery interface

Author:

tiwe

See Also:

Serialized Form

Field Summary

Fields inherited from class com.querydsl.sql.AbstractSQLQuery

listeners, PARENT_CONTEXT, useLiterals

Fields inherited from class com.querydsl.sql.ProjectableSQLQuery

configuration, firstUnionSubQuery, union, unionAll

Fields inherited from class com.querydsl.core.support.QueryBase

MDC_PARAMETERS, MDC_QUERY, queryMixin

Constructor Summary

Constructors

Constructor and Description
SQLQuery() Create a detached SQLQuery instance The query can be attached via the clone method
SQLQuery(Configuration configuration) Create a new SQLQuery instance
SQLQuery(Connection conn, Configuration configuration) Create a new SQLQuery instance
SQLQuery(Connection conn, Configuration configuration, QueryMetadata metadata) Create a new SQLQuery instance
SQLQuery(Connection conn, SQLTemplates templates) Create a new SQLQuery instance
SQLQuery(Connection conn, SQLTemplates templates, QueryMetadata metadata) Create a new SQLQuery instance
SQLQuery(javax.inject.Provider<Connection> connProvider, Configuration configuration) Create a new SQLQuery instance
SQLQuery(javax.inject.Provider<Connection> connProvider, Configuration configuration, QueryMetadata metadata) Create a new SQLQuery instance
SQLQuery(SQLTemplates templates) Create a detached SQLQuery instance The query can be attached via the clone method

Method Summary

Modifier and Type	Method and Description
SQLQuery<T>	clone(Connection conn)
SQLQuery<Tuple>	select(Expression<?>... exprs) Change the projection of this query
<U> SQLQuery<U>	select(Expression<U> expr) Change the projection of this query

Methods inherited from class com.querydsl.sql.AbstractSQLQuery

addListener, as, as, cleanupMDC, clone, clone, createSerializer, endContext, fetch, fetchCount, fetchResults, forShare, forShare, forUpdate, getConfiguration, getResults, getResults, iterate, logQuery, onException, setParameters, setStatementOptions, setUseLiterals, startContext

Methods inherited from class com.querydsl.sql.ProjectableSQLQuery

accept, addFlag, addFlag, addFlag, addFlag, addJoinFlag, addJoinFlag, fetchOne, from, from, from, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, getSQL, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, join, join, join, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, on, on, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, serialize, toString, union, union, union, unionAll, unionAll, unionAll, with, with, with, withRecursive, withRecursive, withRecursive

Methods inherited from class com.querydsl.core.support.FetchableSubQueryBase

contains, contains, eq, eq, exists, getMetadata, getType, goe, goe, gt, gt, hashCode, in, in, isNotNull, isNull, loe, loe, lt, lt, ne, ne, notExists

Methods inherited from class com.querydsl.core.support.FetchableQueryBase

equals, fetchFirst, transform, uniqueResult

Methods inherited from class com.querydsl.core.support.QueryBase

distinct, groupBy, groupBy, having, having, limit, offset, orderBy, orderBy, restrict, set, where, where

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.querydsl.core.Query

groupBy, having

Methods inherited from interface com.querydsl.core.SimpleQuery

distinct, limit, offset, orderBy, restrict, set

Methods inherited from interface com.querydsl.core.FilteredClause

where

Methods inherited from interface com.querydsl.core.FetchableQuery

transform

Methods inherited from interface com.querydsl.core.Fetchable

fetchFirst

Constructor Detail

SQLQuery

public SQLQuery()

Create a detached SQLQuery instance The query can be attached via the clone method

SQLQuery

public SQLQuery(SQLTemplates templates)

Create a detached SQLQuery instance The query can be attached via the clone method

Parameters:

templates - SQLTemplates to use

SQLQuery

public SQLQuery(Connection conn,
                SQLTemplates templates)

Create a new SQLQuery instance

Parameters:

conn - Connection to use

templates - SQLTemplates to use

SQLQuery

public SQLQuery(Connection conn,
                SQLTemplates templates,
                QueryMetadata metadata)

Create a new SQLQuery instance

Parameters:

conn - Connection to use

templates - SQLTemplates to use

metadata - metadata

SQLQuery

public SQLQuery(Configuration configuration)

Create a new SQLQuery instance

Parameters:

configuration - configuration

SQLQuery

public SQLQuery(Connection conn,
                Configuration configuration)

Create a new SQLQuery instance

Parameters:

conn - Connection to use

configuration - configuration

SQLQuery

public SQLQuery(Connection conn,
                Configuration configuration,
                QueryMetadata metadata)

Create a new SQLQuery instance

Parameters:

conn - Connection to use

configuration - configuration

metadata - metadata

SQLQuery

public SQLQuery(javax.inject.Provider<Connection> connProvider,
                Configuration configuration)

Create a new SQLQuery instance

Parameters:

connProvider - Connection to use

configuration - configuration

SQLQuery

public SQLQuery(javax.inject.Provider<Connection> connProvider,
                Configuration configuration,
                QueryMetadata metadata)

Create a new SQLQuery instance

Parameters:

connProvider - Connection to use

configuration - configuration

metadata - metadata

Method Detail

clone

public SQLQuery<T> clone(Connection conn)

Specified by:

clone in class AbstractSQLQuery<T,SQLQuery<T>>

select

public <U> SQLQuery<U> select(Expression<U> expr)

Description copied from interface: FetchableQuery

Change the projection of this query

Parameters:

expr - new projection

Returns:

the current object

select

public SQLQuery<Tuple> select(Expression<?>... exprs)

Description copied from interface: FetchableQuery

Change the projection of this query

Parameters:

exprs - new projection

Returns:

the current object