com.mysema.query.sql
Interface SQLQuery

All Superinterfaces:
Projectable, Query<SQLQuery>
All Known Implementing Classes:
SQLQueryImpl

public interface SQLQuery
extends Query<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 from(Expr<?>... o)
          Defines the sources of the query
 SQLQuery fullJoin(PEntity<?> o)
          Adds a full join to the given target
 ResultSet getResults(Expr<?>... args)
          Get the results as an JDBC result set
 SQLQuery innerJoin(PEntity<?> o)
          Adds an inner join to the given target
 SQLQuery join(PEntity<?> o)
          Adds a join to the given target
 SQLQuery leftJoin(PEntity<?> o)
          Adds a left join to the given target
 SQLQuery on(EBoolean... conditions)
          Defines a filter to the last added join
<RT> Union<RT>
union(ListSubQuery<RT>... sq)
          Creates an union expression for the given subqueries
<RT> Union<RT>
union(SubQuery<RT>... sq)
          Creates an union expression for the given subqueries
 
Methods inherited from interface com.mysema.query.Query
groupBy, having, limit, offset, orderBy, restrict, where
 
Methods inherited from interface com.mysema.query.Projectable
count, countDistinct, iterate, iterate, iterate, iterateDistinct, iterateDistinct, iterateDistinct, list, list, list, listDistinct, listDistinct, listDistinct, listDistinctResults, listResults, map, uniqueResult, uniqueResult, uniqueResult
 

Method Detail

from

SQLQuery from(Expr<?>... o)
Defines the sources of the query

Parameters:
o -
Returns:

fullJoin

SQLQuery fullJoin(PEntity<?> o)
Adds a full join to the given target

Parameters:
o -
Returns:

innerJoin

SQLQuery innerJoin(PEntity<?> o)
Adds an inner join to the given target

Parameters:
o -
Returns:

join

SQLQuery join(PEntity<?> o)
Adds a join to the given target

Parameters:
o -
Returns:

leftJoin

SQLQuery leftJoin(PEntity<?> o)
Adds a left join to the given target

Parameters:
o -
Returns:

on

SQLQuery on(EBoolean... conditions)
Defines a filter to the last added join

Parameters:
conditions -
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> Union<RT> union(SubQuery<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(Expr<?>... args)
Get the results as an JDBC result set

Parameters:
args -
Returns:


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