core.tut.pori.dao

Class SQLUpdateBuilder

java.lang.Object

core.tut.pori.dao.SQLUpdateBuilder

public class SQLUpdateBuilder
extends java.lang.Object

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

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
void	addUpdateClause(UpdateClause clause) null clause will be silently ignored
void	addWhereClause(WhereClause clause)
void	clearUpdateClauses() clear the list of update clauses if any
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
int	getUpdateClauseCount()
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

SQLUpdateBuilder

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

getUpdateClauseCount

public int getUpdateClauseCount()

Returns:

number of added update clauses

addUpdateClause

public void addUpdateClause(UpdateClause clause)

null clause will be silently ignored

Parameters:

clause -

clearUpdateClauses

public void clearUpdateClauses()

clear the list of update clauses if any

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 a 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