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
SQLQuery	fullJoin(SubQuery<?> o, Path<?> alias) 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	innerJoin(SubQuery<?> o, Path<?> alias) Adds an inner join to the given target
SQLQuery	join(PEntity<?> o) Adds a join to the given target
SQLQuery	join(SubQuery<?> o, Path<?> alias) Adds a join to the given target
SQLQuery	leftJoin(PEntity<?> o) Adds a left join to the given target
SQLQuery	leftJoin(SubQuery<?> o, Path<?> alias) Adds a left join to the given target
SQLQuery	on(EBoolean... conditions) Defines a filter to the last added join
SQLQuery	rightJoin(PEntity<?> o) Adds a right join to the given target
SQLQuery	rightJoin(SubQuery<?> o, Path<?> alias) Adds a right join to the given target
<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, set, 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:

rightJoin

SQLQuery rightJoin(PEntity<?> o)

Adds a right join to the given target

Parameters:

o -

Returns:

fullJoin

SQLQuery fullJoin(SubQuery<?> o,
                  Path<?> alias)

Adds a full join to the given target

Parameters:

o -

Returns:

innerJoin

SQLQuery innerJoin(SubQuery<?> o,
                   Path<?> alias)

Adds an inner join to the given target

Parameters:

o -

Returns:

join

SQLQuery join(SubQuery<?> o,
              Path<?> alias)

Adds a join to the given target

Parameters:

o -

Returns:

leftJoin

SQLQuery leftJoin(SubQuery<?> o,
                  Path<?> alias)

Adds a left join to the given target

Parameters:

o -

Returns:

rightJoin

SQLQuery rightJoin(SubQuery<?> o,
                   Path<?> alias)

Adds a right 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: