com.querydsl.sql

Class SQLQueryFactory

java.lang.Object

com.querydsl.sql.AbstractSQLQueryFactory<SQLQuery<?>>

com.querydsl.sql.SQLQueryFactory

All Implemented Interfaces:

QueryFactory<SQLQuery<?>>, SQLCommonQueryFactory<SQLQuery<?>,SQLDeleteClause,SQLUpdateClause,SQLInsertClause,SQLMergeClause>

public class SQLQueryFactory
extends AbstractSQLQueryFactory<SQLQuery<?>>

Factory class for query and DML clause creation

Author:

tiwe

Field Summary

Fields inherited from class com.querydsl.sql.AbstractSQLQueryFactory

configuration, connection

Constructor Summary

Constructors

Constructor and Description
SQLQueryFactory(Configuration configuration, javax.sql.DataSource dataSource)
SQLQueryFactory(Configuration configuration, javax.sql.DataSource dataSource, boolean release)
SQLQueryFactory(Configuration configuration, java.util.function.Supplier<java.sql.Connection> connProvider)
SQLQueryFactory(SQLTemplates templates, java.util.function.Supplier<java.sql.Connection> connection)

Method Summary

Modifier and Type	Method and Description
SQLQuery<?>	query() Create a new Query
SQLQuery<Tuple>	select(Expression<?>... exprs) Create a new SQL query with the given projection
<T> SQLQuery<T>	select(Expression<T> expr) Create a new SQL query with the given projection
SQLQuery<Tuple>	selectDistinct(Expression<?>... exprs) Create a new SQL query with the given projection
<T> SQLQuery<T>	selectDistinct(Expression<T> expr) Create a new SQL query with the given projection
<T> SQLQuery<T>	selectFrom(RelationalPath<T> expr) Create a new SQL query with the given projection and source
SQLQuery<java.lang.Integer>	selectOne() Create a new SQL query with one as the projection
SQLQuery<java.lang.Integer>	selectZero() Create a new SQL query with zero as the projection

Methods inherited from class com.querydsl.sql.AbstractSQLQueryFactory

delete, from, from, from, getConfiguration, getConnection, insert, merge, update

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLQueryFactory

public SQLQueryFactory(SQLTemplates templates,
                       java.util.function.Supplier<java.sql.Connection> connection)

SQLQueryFactory

public SQLQueryFactory(Configuration configuration,
                       java.util.function.Supplier<java.sql.Connection> connProvider)

SQLQueryFactory

public SQLQueryFactory(Configuration configuration,
                       javax.sql.DataSource dataSource)

SQLQueryFactory

public SQLQueryFactory(Configuration configuration,
                       javax.sql.DataSource dataSource,
                       boolean release)

Method Detail

query

public SQLQuery<?> query()

Description copied from interface: QueryFactory

Create a new Query

Returns:

new query

select

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

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

select in class AbstractSQLQueryFactory<SQLQuery<?>>

Type Parameters:

T - type of the projection

Parameters:

expr - projection

Returns:

select(expr)

select

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

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

select in class AbstractSQLQueryFactory<SQLQuery<?>>

Parameters:

exprs - projection

Returns:

select(exprs)

selectDistinct

public <T> SQLQuery<T> selectDistinct(Expression<T> expr)

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

selectDistinct in class AbstractSQLQueryFactory<SQLQuery<?>>

Type Parameters:

T - type of the projection

Parameters:

expr - distinct projection

Returns:

select(distinct expr)

selectDistinct

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

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

selectDistinct in class AbstractSQLQueryFactory<SQLQuery<?>>

Parameters:

exprs - distinct projection

Returns:

select(distinct exprs)

selectZero

public SQLQuery<java.lang.Integer> selectZero()

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with zero as the projection

Specified by:

selectZero in class AbstractSQLQueryFactory<SQLQuery<?>>

Returns:

select(0)

selectOne

public SQLQuery<java.lang.Integer> selectOne()

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with one as the projection

Specified by:

selectOne in class AbstractSQLQueryFactory<SQLQuery<?>>

Returns:

select(1)

selectFrom

public <T> SQLQuery<T> selectFrom(RelationalPath<T> expr)

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection and source

Specified by:

selectFrom in class AbstractSQLQueryFactory<SQLQuery<?>>

Type Parameters:

T - type of the projection

Parameters:

expr - query source and projection

Returns:

select(expr).from(expr)