org.hibernate.loader.plan.exec.query.internal

Class SelectStatementBuilder

java.lang.Object

org.hibernate.loader.plan.exec.query.internal.SelectStatementBuilder

public class SelectStatementBuilder
extends Object

Largely a copy of the Select class, but changed up slightly to better meet needs of building a SQL SELECT statement from a LoadPlan

Author:

Steve Ebersole, Gavin King

Field Summary

Fields

Modifier and Type	Field and Description
Dialect	dialect

Constructor Summary

Constructors

Constructor and Description
SelectStatementBuilder(Dialect dialect) Constructs a select statement builder object.

Method Summary

Modifier and Type	Method and Description
void	appendFromClauseFragment(String fragment) Appends the from clause fragment.
void	appendFromClauseFragment(String tableName, String alias) Appends the specified table name and alias as a from clause fragment.
void	appendOrderByFragment(String ordering) Appends the "order by" fragment, prefixed by a comma if the "order by" fragment already exists.
void	appendRestrictions(String restrictions) Appends the specified restrictions after "cleaning" the specified value (by trimming and removing 'and ' from beginning and ' and' from the end).
void	appendSelectClauseFragment(String selection) Appends a select clause fragment
void	setComment(String comment) Sets the comment for the select statement.
void	setLockMode(LockMode lockMode) Sets the lock mode for the select statement.
void	setLockOptions(LockOptions lockOptions) Sets the lock options for the select statement.
void	setOuterJoins(String outerJoinsAfterFrom, String outerJoinsAfterWhere) Sets the outer join fragments to be added to the "from" and "where" clauses.
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

SelectStatementBuilder

public SelectStatementBuilder(Dialect dialect)

Constructs a select statement builder object.

Parameters:

dialect - The dialect.

Method Detail

appendSelectClauseFragment

public void appendSelectClauseFragment(String selection)

Appends a select clause fragment

Parameters:

selection - The selection fragment

appendFromClauseFragment

public void appendFromClauseFragment(String fragment)

Appends the from clause fragment.

Parameters:

fragment - The from cause fragment.

appendFromClauseFragment

public void appendFromClauseFragment(String tableName,
                                     String alias)

Appends the specified table name and alias as a from clause fragment.

Parameters:

tableName - The table name.

alias - The table alias.

appendRestrictions

public void appendRestrictions(String restrictions)

Appends the specified restrictions after "cleaning" the specified value (by trimming and removing 'and ' from beginning and ' and' from the end). If the where clause already exists, this method ensure that ' and ' prefixes the cleaned restrictions.

Parameters:

restrictions - The restrictions.

setOuterJoins

public void setOuterJoins(String outerJoinsAfterFrom,
                          String outerJoinsAfterWhere)

Sets the outer join fragments to be added to the "from" and "where" clauses.

Parameters:

outerJoinsAfterFrom - The outer join fragment to be appended to the "from" clause.

outerJoinsAfterWhere - The outer join fragment to be appended to the "where" clause.

appendOrderByFragment

public void appendOrderByFragment(String ordering)

Appends the "order by" fragment, prefixed by a comma if the "order by" fragment already exists.

Parameters:

ordering - The "order by" fragment to append.

setComment

public void setComment(String comment)

Sets the comment for the select statement.

Parameters:

comment - The comment.

setLockMode

public void setLockMode(LockMode lockMode)

Sets the lock mode for the select statement.

Parameters:

lockMode - The lock mode.

setLockOptions

public void setLockOptions(LockOptions lockOptions)

Sets the lock options for the select statement.

Parameters:

lockOptions - The lock options.

toStatementString

public String toStatementString()

Construct an SQL SELECT statement from the given clauses.

Returns:

the SQL SELECT statement.