com.querydsl.sql.mssql

Class SQLServerQueryFactory

java.lang.Object

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

com.querydsl.sql.mssql.SQLServerQueryFactory

All Implemented Interfaces:

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

public class SQLServerQueryFactory
extends AbstractSQLQueryFactory<SQLServerQuery<?>>

SQL Server specific implementation of SQLQueryFactory

Author:

tiwe

Field Summary

Fields inherited from class com.querydsl.sql.AbstractSQLQueryFactory

configuration, connection

Constructor Summary

Constructors

Constructor and Description
SQLServerQueryFactory(Configuration configuration, java.util.function.Supplier<java.sql.Connection> connection)
SQLServerQueryFactory(SQLTemplates templates, java.util.function.Supplier<java.sql.Connection> connection)
SQLServerQueryFactory(java.util.function.Supplier<java.sql.Connection> connection)

Method Summary

Modifier and Type	Method and Description
SQLServerQuery<?>	query()
SQLServerQuery<Tuple>	select(Expression<?>... exprs) Create a new SQL query with the given projection
<T> SQLServerQuery<T>	select(Expression<T> expr) Create a new SQL query with the given projection
SQLServerQuery<Tuple>	selectDistinct(Expression<?>... exprs) Create a new SQL query with the given projection
<T> SQLServerQuery<T>	selectDistinct(Expression<T> expr) Create a new SQL query with the given projection
<T> SQLServerQuery<T>	selectFrom(RelationalPath<T> expr) Create a new SQL query with the given projection and source
SQLServerQuery<java.lang.Integer>	selectOne() Create a new SQL query with one as the projection
SQLServerQuery<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

SQLServerQueryFactory

public SQLServerQueryFactory(Configuration configuration,
                             java.util.function.Supplier<java.sql.Connection> connection)

SQLServerQueryFactory

public SQLServerQueryFactory(java.util.function.Supplier<java.sql.Connection> connection)

SQLServerQueryFactory

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

Method Detail

query

public SQLServerQuery<?> query()

select

public <T> SQLServerQuery<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<SQLServerQuery<?>>

Type Parameters:

T - type of the projection

Parameters:

expr - projection

Returns:

select(expr)

select

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

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

select in class AbstractSQLQueryFactory<SQLServerQuery<?>>

Parameters:

exprs - projection

Returns:

select(exprs)

selectDistinct

public <T> SQLServerQuery<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<SQLServerQuery<?>>

Type Parameters:

T - type of the projection

Parameters:

expr - distinct projection

Returns:

select(distinct expr)

selectDistinct

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

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

selectDistinct in class AbstractSQLQueryFactory<SQLServerQuery<?>>

Parameters:

exprs - distinct projection

Returns:

select(distinct exprs)

selectZero

public SQLServerQuery<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<SQLServerQuery<?>>

Returns:

select(0)

selectOne

public SQLServerQuery<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<SQLServerQuery<?>>

Returns:

select(1)

selectFrom

public <T> SQLServerQuery<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<SQLServerQuery<?>>

Type Parameters:

T - type of the projection

Parameters:

expr - query source and projection

Returns:

select(expr).from(expr)