Package org.spincast.plugins.jdbc.statements

Class UpdateStatementDefault

java.lang.Object

org.spincast.plugins.jdbc.statements.StatementBase

org.spincast.plugins.jdbc.statements.UpdateStatementDefault

All Implemented Interfaces:

Statement, UpdateStatement

public class UpdateStatementDefault
extends StatementBase
implements UpdateStatement

Constructor Summary

Constructors

Constructor	Description
UpdateStatementDefault(Connection connection)

Method Summary

Modifier and Type	Method	Description
protected String	createUniqueParamName()
protected PreparedStatement	getStatementWithParamsAdded(Connection connection)
void	setCase(String paramName, String columnNameToCheck, Map<?,?> map)	Adds a CASE statement, using the key and values of the given map.
int	update()	Execute the update and return the number of affected rows.
<T> List<T>	update(ResultSetHandler<T> resultSetHandler)	Execute the update and return a result set.

Methods inherited from class org.spincast.plugins.jdbc.statements.StatementBase

addCurrentParamsToStatement, addParam, addParamsToStatement, clearParams, clearSql, clearSql, close, close, copyParamsAndStaticTokensTo, getConnection, getIndexMap, getOriginalQuery, getParams, getParsedQuery, getQueryBuilder, getSql, getSqlFormmatter, getStaticTokens, parse, setBoolean, setDate, setDouble, setFloat, setInInteger, setInLong, setInstant, setInString, setInStringFromEnumNames, setInStringFromEnumNames, setInteger, setLong, setLongList, setParams, setStaticTokens, setString, sql, toString

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.spincast.plugins.jdbc.statements.Statement

clearSql, clearSql, getSql, setBoolean, setDate, setDouble, setFloat, setInInteger, setInLong, setInstant, setInString, setInStringFromEnumNames, setInStringFromEnumNames, setInteger, setLong, setLongList, setString, sql

Constructor Details

UpdateStatementDefault

public UpdateStatementDefault(Connection connection)

Method Details

getStatementWithParamsAdded

protected PreparedStatement getStatementWithParamsAdded(Connection connection)

update

public int update()

Description copied from interface: UpdateStatement

Execute the update and return the number of affected rows.

Specified by:

update in interface UpdateStatement

update

public <T> List<T> update(ResultSetHandler<T> resultSetHandler)

Description copied from interface: UpdateStatement

Execute the update and return a result set.

This can be used with a RETURNING clause.

Specified by:

update in interface UpdateStatement

setCase

public void setCase(String paramName,
 String columnNameToCheck,
 Map<?,?> map)

Description copied from interface: UpdateStatement

Adds a CASE statement, using the key and values of the given map. For example : CASE WHEN mapKey1 = 1 then mapVal1 WHEN mapKey2 = 2 then mapVal2 END

Specified by:

setCase in interface UpdateStatement

createUniqueParamName

protected String createUniqueParamName()