com.mysema.query.sql
Interface SQLQuery

All Superinterfaces:

FilteredClause<SQLQuery>, Projectable, Query<SQLQuery>, SimpleQuery<SQLQuery>, SQLCommonQuery<SQLQuery>

All Known Implementing Classes:

SQLQueryImpl

public interface SQLQuery
extends SQLCommonQuery<SQLQuery>, Projectable

Query interface for SQL queries

Author:

tiwe

Method Summary

SQLQuery	clone(Connection conn) Clone the state of the Query for the given Connection
SQLQuery	forUpdate() If you use forUpdate() with a backend that uses page or row locks, rows examined by the query are write-locked until the end of the current transaction.
ResultSet	getResults(Expression<?>... args) Get the results as an JDBC result set
<RT> Union<RT>	union(ListSubQuery<RT>... sq) Creates an union expression for the given subqueries
<RT> SQLQuery	union(Path<?> alias, ListSubQuery<RT>... sq) Creates an union expression for the given subqueries
<RT> SQLQuery	union(Path<?> alias, SubQueryExpression<RT>... sq) Creates an union expression for the given subqueries
<RT> Union<RT>	union(SubQueryExpression<RT>... sq) Creates an union expression for the given subqueries
<RT> Union<RT>	unionAll(ListSubQuery<RT>... sq) Creates an union expression for the given subqueries
<RT> SQLQuery	unionAll(Path<?> alias, ListSubQuery<RT>... sq) Creates an union expression for the given subqueries
<RT> SQLQuery	unionAll(Path<?> alias, SubQueryExpression<RT>... sq) Creates an union expression for the given subqueries
<RT> Union<RT>	unionAll(SubQueryExpression<RT>... sq) Creates an union expression for the given subqueries

Methods inherited from interface com.mysema.query.sql.SQLCommonQuery

addFlag, addFlag, addFlag, addJoinFlag, addJoinFlag, from, from, fullJoin, fullJoin, fullJoin, fullJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, join, join, leftJoin, leftJoin, leftJoin, leftJoin, on, rightJoin, rightJoin, rightJoin, rightJoin

Methods inherited from interface com.mysema.query.Query

groupBy, having

Methods inherited from interface com.mysema.query.SimpleQuery

distinct, limit, offset, orderBy, restrict, set

Methods inherited from interface com.mysema.query.FilteredClause

where

Methods inherited from interface com.mysema.query.Projectable

count, countDistinct, exists, iterate, iterate, iterate, iterateDistinct, iterateDistinct, iterateDistinct, list, list, list, listDistinct, listDistinct, listDistinct, listDistinctResults, listResults, map, notExists, singleResult, singleResult, singleResult, transform, uniqueResult, uniqueResult, uniqueResult

Method Detail

forUpdate

SQLQuery forUpdate()

If you use forUpdate() with a backend that uses page or row locks, rows examined by the query are write-locked until the end of the current transaction. Not supported for SQLite and CUBRID

Returns:

union

<RT> Union<RT> union(ListSubQuery<RT>... sq)

Creates an union expression for the given subqueries

Type Parameters:

RT -

Parameters:

sq -

Returns:

union

<RT> SQLQuery union(Path<?> alias,
                    ListSubQuery<RT>... sq)

Creates an union expression for the given subqueries

Type Parameters:

RT -

Parameters:

sq -

Returns:

union

<RT> Union<RT> union(SubQueryExpression<RT>... sq)

Creates an union expression for the given subqueries

Type Parameters:

RT -

Parameters:

sq -

Returns:

union

<RT> SQLQuery union(Path<?> alias,
                    SubQueryExpression<RT>... sq)

Creates an union expression for the given subqueries

Type Parameters:

RT -

Parameters:

sq -

Returns:

unionAll

<RT> Union<RT> unionAll(ListSubQuery<RT>... sq)

Creates an union expression for the given subqueries

Type Parameters:

RT -

Parameters:

sq -

Returns:

unionAll

<RT> SQLQuery unionAll(Path<?> alias,
                       ListSubQuery<RT>... sq)

Creates an union expression for the given subqueries

Type Parameters:

RT -

Parameters:

sq -

Returns:

unionAll

<RT> Union<RT> unionAll(SubQueryExpression<RT>... sq)

Creates an union expression for the given subqueries

Type Parameters:

RT -

Parameters:

sq -

Returns:

unionAll

<RT> SQLQuery unionAll(Path<?> alias,
                       SubQueryExpression<RT>... sq)

Creates an union expression for the given subqueries

Type Parameters:

RT -

Parameters:

sq -

Returns:

clone

SQLQuery clone(Connection conn)

Clone the state of the Query for the given Connection

Parameters:

conn -

Returns:

getResults

ResultSet getResults(Expression<?>... args)

Get the results as an JDBC result set

Parameters:

args -

Returns: