core.tut.pori.dao

Class SQLSelectBuilder

java.lang.Object

core.tut.pori.dao.SQLSelectBuilder

public class SQLSelectBuilder
extends java.lang.Object

Helper class, which can be used to build an SQL SELECT clause.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLSelectBuilder.OrderDirection The direction of an sort order in SQL order by clause.

Constructor Summary

Constructors

Constructor and Description
SQLSelectBuilder(java.lang.String table)

Method Summary

Modifier and Type	Method and Description
void	addGroupBy(java.lang.String column)
void	addJoin(JoinClause clause)
void	addOrderBy(java.lang.String column, SQLSelectBuilder.OrderDirection direction)
void	addSelectColumn(java.lang.String column)
void	addSelectColumns(java.lang.String[] columns)
void	addWhereClause(WhereClause clause)
void	clearWhereClauses() clear the currently set list of where clauses
long	getRecordCount(org.springframework.jdbc.core.JdbcTemplate template)
long	getRecordCount(org.springframework.jdbc.core.JdbcTemplate template, java.lang.String type)
java.lang.Object[]	getValues()
int[]	getValueTypes()
int	getWhereClauseCount()
void	setLimits(Limits limits)
void	setMaxItems(int maxItems)
void	setStartItem(int startItem)
java.lang.String	toSQLString()
java.lang.String	toSQLString(java.lang.String type)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLSelectBuilder

public SQLSelectBuilder(java.lang.String table)

Parameters:

table -

Method Detail

clearWhereClauses

public void clearWhereClauses()

clear the currently set list of where clauses

getWhereClauseCount

public int getWhereClauseCount()

Returns:

number of added where clauses

addJoin

public void addJoin(JoinClause clause)

Parameters:

clause -

addGroupBy

public void addGroupBy(java.lang.String column)

Parameters:

column -

setStartItem

public void setStartItem(int startItem)

Parameters:

startItem - the startItem to set, negative value disables limit

setMaxItems

public void setMaxItems(int maxItems)

Parameters:

maxItems - the maxItems to set, negative value disables limit

setLimits

public void setLimits(Limits limits)

Parameters:

limits - if null, this is a no-op

getRecordCount

public long getRecordCount(org.springframework.jdbc.core.JdbcTemplate template)

Parameters:

template - to use for retrieval

Returns:

record count for the given sql query or < 0 on error

getRecordCount

public long getRecordCount(org.springframework.jdbc.core.JdbcTemplate template,
                           java.lang.String type)

Parameters:

template -

type -

Returns:

record count (SQL COUNT(*)) for the given select query parameters

getValueTypes

public int[] getValueTypes()

Returns:

value types or null if none

getValues

public java.lang.Object[] getValues()

Returns:

values in an array or null if none

toSQLString

public java.lang.String toSQLString()

Returns:

the query as a SQL string

toSQLString

public java.lang.String toSQLString(java.lang.String type)

Parameters:

type -

Returns:

the query as a SQL string using type information for parameters (e.g. Limits). See Limits

addOrderBy

public void addOrderBy(java.lang.String column,
                       SQLSelectBuilder.OrderDirection direction)

Parameters:

column - null column name is accepted, though it equals to random sort order

direction -

addWhereClause

public void addWhereClause(WhereClause clause)

Parameters:

clause -

addSelectColumn

public void addSelectColumn(java.lang.String column)

Parameters:

column -

addSelectColumns

public void addSelectColumns(java.lang.String[] columns)

Parameters:

columns -