Package net.sf.basedb.core.hibernate

Class ExecuteUpdateWork

java.lang.Object

net.sf.basedb.core.hibernate.ExecuteUpdateWork

All Implemented Interfaces:

ReturningWork<Integer>

public class ExecuteUpdateWork
extends Object
implements ReturningWork<Integer>

A JDBC work implementation that executes an update/insert/delete query and returns the number of rows that was affected by the query. By subclassing this class and overridding the setParameters(PreparedStatement) method it is possible to set parameters on the prepared statement before the SQL is executed.

Version:

2.9

Author:

nicklas

See Also:

• PreparedStatement.executeUpdate()

Last modified

$Date: 2014-06-10 13:27:02 +0200 (ti, 10 jun 2014) $

Field Summary

Fields

Modifier and Type	Field	Description
private SessionControl	sc
private String	sql

Constructor Summary

Constructors

Constructor	Description
ExecuteUpdateWork(SessionControl sc, String sql)	Create a new work item.

Method Summary

Modifier and Type	Method	Description
Integer	execute(Connection connection)	From the Work interface -----------------------
protected void	setParameters(PreparedStatement ps)	This method should be overridden by subclasses that needs to set parameters on the statement that is going to be executed.

Methods inherited from class java.lang.Object

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

Field Details

sc

private SessionControl sc

sql

private String sql

Constructor Details

ExecuteUpdateWork

public ExecuteUpdateWork(SessionControl sc,
 String sql)

Create a new work item.

Parameters:

sc - The session control to keep alive during the execution of the sql, or null

sql - The sql to execute

Method Details

execute

public Integer execute(Connection connection)
                throws SQLException

From the Work interface -----------------------

Specified by:

execute in interface ReturningWork<Integer>

Throws:

SQLException

setParameters

protected void setParameters(PreparedStatement ps)
                      throws SQLException

This method should be overridden by subclasses that needs to set parameters on the statement that is going to be executed. The default implementation does nothing. This method is called after the statement has been prepared with Connection.prepareStatement(String) and before it is executed with PreparedStatement.executeUpdate().

Parameters:

ps - The prepared statement

Throws:

SQLException