Package org.hibernate.sql

Class SimpleSelect

java.lang.Object

org.hibernate.sql.SimpleSelect

All Implemented Interfaces:

RestrictionRenderingContext

@Internal
public class SimpleSelect
extends Object
implements RestrictionRenderingContext

A SQL SELECT statement with no table joins.

Field Summary

Fields

Modifier and Type	Field	Description
protected Map<String,String>	aliases
protected List<String>	columns
protected String	comment
protected LockOptions	lockOptions
protected String	orderBy
protected List<Restriction>	restrictions
protected String	tableName

Constructor Summary

Constructors

Constructor	Description
SimpleSelect(Dialect dialect)
SimpleSelect(Dialect dialect, ParameterMarkerStrategy parameterMarkerStrategy)
SimpleSelect(SessionFactoryImplementor factory)

Method Summary

Modifier and Type	Method	Description
SimpleSelect	addColumn(String columnName)	Adds a selection
SimpleSelect	addColumn(String columnName, String alias)	Adds a selection, with an alias
SimpleSelect	addColumns(String[] columnNames)	Adds selections
SimpleSelect	addRestriction(String columnName)	Appends a restriction comparing the columnName for equality with a parameter
SimpleSelect	addRestriction(String... columnNames)	Appends a restriction comparing each name in columnNames for equality with a parameter
SimpleSelect	addRestriction(String lhs, ComparisonRestriction.Operator op, String rhs)	Appends a restriction based on the comparison between lhs and rhs.
SimpleSelect	addWhereToken(String condition)	Appends a complete where condition.
String	makeParameterMarker()
SimpleSelect	setComment(String comment)
SimpleSelect	setLockMode(LockMode lockMode)
SimpleSelect	setLockOptions(LockOptions lockOptions)
SimpleSelect	setOrderBy(String orderBy)
SimpleSelect	setTableName(String tableName)	Sets the name of the table we are selecting from
String	toStatementString()

Methods inherited from class java.lang.Object

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

Field Details

tableName

protected String tableName

orderBy

protected String orderBy

comment

protected String comment

columns

protected List<String> columns

aliases

protected Map<String,String> aliases

restrictions

protected List<Restriction> restrictions

lockOptions

protected LockOptions lockOptions

Constructor Details

SimpleSelect

public SimpleSelect(SessionFactoryImplementor factory)

SimpleSelect

public SimpleSelect(Dialect dialect)

SimpleSelect

public SimpleSelect(Dialect dialect,
 ParameterMarkerStrategy parameterMarkerStrategy)

Method Details

makeParameterMarker

public String makeParameterMarker()

Specified by:

makeParameterMarker in interface RestrictionRenderingContext

setTableName

public SimpleSelect setTableName(String tableName)

Sets the name of the table we are selecting from

addColumns

public SimpleSelect addColumns(String[] columnNames)

Adds selections

addColumn

public SimpleSelect addColumn(String columnName)

Adds a selection

addColumn

public SimpleSelect addColumn(String columnName,
 String alias)

Adds a selection, with an alias

addWhereToken

public SimpleSelect addWhereToken(String condition)

Appends a complete where condition. The condition is added as-is.

addRestriction

public SimpleSelect addRestriction(String columnName)

Appends a restriction comparing the columnName for equality with a parameter

See Also:

• addRestriction(String, ComparisonRestriction.Operator, String)

addRestriction

public SimpleSelect addRestriction(String lhs,
 ComparisonRestriction.Operator op,
 String rhs)

Appends a restriction based on the comparison between lhs and rhs.

The rhs is checked for parameter marker and processed via ParameterMarkerStrategy if needed.

addRestriction

public SimpleSelect addRestriction(String... columnNames)

Appends a restriction comparing each name in columnNames for equality with a parameter

See Also:

• addRestriction(String)

setLockOptions

public SimpleSelect setLockOptions(LockOptions lockOptions)

setLockMode

public SimpleSelect setLockMode(LockMode lockMode)

setOrderBy

public SimpleSelect setOrderBy(String orderBy)

setComment

public SimpleSelect setComment(String comment)

toStatementString

public String toStatementString()