public.javadoc.org.spincast.plugins.jdbc.statements.UpdateStatement.html Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of spincast-website Show documentation

Source code for the https://www.spincast.org website.

There is a newer version: 2.2.0







UpdateStatement (org.spincast:spincast-framework 1.0.0 API)











Skip navigation links




Overview
Package
Class
Use
Tree
Deprecated
Index
Help

 Spincast Framework Javadoc



Prev Class
Next Class


Frames
No Frames


All Classes






Summary: 
Nested | 
Field | 
Constr | 
Method


Detail: 
Field | 
Constr | 
Method








org.spincast.plugins.jdbc.statements
Interface UpdateStatement






All Superinterfaces:
Statement


All Known Implementing Classes:
UpdateStatementDefault




public interface UpdateStatement
extends Statement











Method Summary

All Methods Instance Methods Abstract Methods 

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





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 
 













Skip navigation links




Overview
Package
Class
Use
Tree
Deprecated
Index
Help

 Spincast Framework Javadoc



Prev Class
Next Class


Frames
No Frames


All Classes






Summary: 
Nested | 
Field | 
Constr | 
Method


Detail: 
Field | 
Constr | 
Method






Copyright © 2019. All rights reserved.

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