Package org.hibernate.sql

Class Select

java.lang.Object

org.hibernate.sql.Select

public class Select
extends Object

A simple SQL SELECT statement

Field Summary

Fields

Modifier and Type	Field	Description
protected String	comment
Dialect	dialect
protected String	fromClause
protected String	groupByClause
protected LockOptions	lockOptions
protected String	orderByClause
protected String	outerJoinsAfterFrom
protected String	outerJoinsAfterWhere
protected String	selectClause
protected String	whereClause

Constructor Summary

Constructors

Constructor	Description
Select(Dialect dialect)

Method Summary

Modifier and Type	Method	Description
LockMode	getLockMode()	Deprecated. Instead use getLockOptions
LockOptions	getLockOptions()	Get the current lock options
Select	setComment(String comment)
Select	setFromClause(String fromClause)	Sets the fromClause.
Select	setFromClause(String tableName, String alias)
Select	setGroupByClause(String groupByClause)
Select	setLockMode(LockMode lockMode)	Deprecated. Instead use setLockOptions
Select	setLockOptions(LockOptions lockOptions)	Set the lock options
Select	setOrderByClause(String orderByClause)
Select	setOuterJoins(String outerJoinsAfterFrom, String outerJoinsAfterWhere)
Select	setSelectClause(String selectClause)	Sets the selectClause.
Select	setSelectClause(SelectFragment selectFragment)
Select	setWhereClause(String whereClause)	Sets the whereClause.
String	toStatementString()	Construct an SQL SELECT statement from the given clauses

Methods inherited from class java.lang.Object

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

Field Detail

selectClause

protected String selectClause

fromClause

protected String fromClause

outerJoinsAfterFrom

protected String outerJoinsAfterFrom

whereClause

protected String whereClause

outerJoinsAfterWhere

protected String outerJoinsAfterWhere

orderByClause

protected String orderByClause

groupByClause

protected String groupByClause

comment

protected String comment

lockOptions

protected LockOptions lockOptions

dialect

public final Dialect dialect

Constructor Detail

Select

public Select(Dialect dialect)

Method Detail

toStatementString

public String toStatementString()

Construct an SQL SELECT statement from the given clauses

setFromClause

public Select setFromClause(String fromClause)

Sets the fromClause.

Parameters:

fromClause - The fromClause to set

setFromClause

public Select setFromClause(String tableName,
                            String alias)

setOrderByClause

public Select setOrderByClause(String orderByClause)

setGroupByClause

public Select setGroupByClause(String groupByClause)

setOuterJoins

public Select setOuterJoins(String outerJoinsAfterFrom,
                            String outerJoinsAfterWhere)

setSelectClause

public Select setSelectClause(String selectClause)

Sets the selectClause.

Parameters:

selectClause - The selectClause to set

setSelectClause

public Select setSelectClause(SelectFragment selectFragment)

setWhereClause

public Select setWhereClause(String whereClause)

Sets the whereClause.

Parameters:

whereClause - The whereClause to set

setComment

public Select setComment(String comment)

getLockMode

@Deprecated
public LockMode getLockMode()

Deprecated.

Instead use getLockOptions

Get the current lock mode

Returns:

LockMode

setLockMode

@Deprecated
public Select setLockMode(LockMode lockMode)

Deprecated.

Instead use setLockOptions

Set the lock mode

Parameters:

lockMode -

Returns:

this object

getLockOptions

public LockOptions getLockOptions()

Get the current lock options

Returns:

LockOptions

setLockOptions

public Select setLockOptions(LockOptions lockOptions)

Set the lock options

Parameters:

lockOptions -

Returns:

this object