org.hibernate.sql

Class Select

java.lang.Object

org.hibernate.sql.Select

public class Select
extends Object

A simple SQL SELECT statement

Author:

Gavin King

Field Summary

Fields

Modifier and Type	Field and Description
Dialect	dialect

Constructor Summary

Constructors

Constructor and Description
Select(Dialect dialect)

Method Summary

Modifier and Type	Method and 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(SelectFragment selectFragment)
Select	setSelectClause(String selectClause) Sets the selectClause.
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

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