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:


Copyright © 2007-2012 Mysema Ltd. All Rights Reserved.