core.tut.pori.dao

Class SQLDeleteBuilder

java.lang.Object

core.tut.pori.dao.SQLDeleteBuilder

public class SQLDeleteBuilder
extends java.lang.Object

Helper class, which can be used to build an SQL DELETE clause. Note that the class has no implementations of its own of the SQLClause, but uses the same clauses as defined by SQLSelectBuilder (SQL WHERE).

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
void	addWhereClause(WhereClause clause)
void	clearWhereClauses() clear the currently set list of where clauses
int	execute(org.springframework.jdbc.core.JdbcTemplate template) execute the statement on the given template
int	execute(org.springframework.jdbc.core.JdbcTemplate template, java.lang.String type) execute the statement on the given template
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

SQLDeleteBuilder

public SQLDeleteBuilder(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

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

addWhereClause

public void addWhereClause(WhereClause clause)

Parameters:

clause -

execute

public int execute(org.springframework.jdbc.core.JdbcTemplate template)

execute the statement on the given template

Parameters:

template -

Returns:

number of rows affected

execute

public int execute(org.springframework.jdbc.core.JdbcTemplate template,
                   java.lang.String type)

execute the statement on the given template

Parameters:

template -

type -

Returns:

number of rows affected

getValues

public java.lang.Object[] getValues()

Returns:

array of parameter values

getValueTypes

public int[] getValueTypes()

Returns:

array of parameter types

toSQLString

public java.lang.String toSQLString()

Returns:

the query as an SQL string

toSQLString

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

Parameters:

type -

Returns:

the query as an SQL string using the given type of typed parameters (e.g. Limits). See Limits