Package org.spincast.plugins.jdbc.statements

Interface UpdateStatement

All Superinterfaces:

Statement

All Known Implementing Classes:

UpdateStatementDefault

public interface UpdateStatement
extends Statement

Method Summary

Modifier and Type	Method	Description
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 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

Method Details

update

int update()

Execute the update and return the number of affected rows.

update

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

Execute the update and return a result set.

This can be used with a RETURNING clause.

setCase

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

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