oracle.lite.resource

Class SqlUpdate

java.lang.Object

oracle.lite.resource.SqlUpdate

Direct Known Subclasses:

Query

public class SqlUpdate
extends java.lang.Object

Helper class to prepare, bind and execute SQL statements.

Constructor Summary

Constructors

Constructor and Description
SqlUpdate(java.lang.String sql, java.lang.Object[] par) Construct a SqlUpdate object

Method Summary

Methods

Modifier and Type	Method and Description
void	bind(int idx, java.lang.Object val) Bind a parameter at an index.
void	close(boolean commit) Close the SqlUpdate object and commit if required
int	executeUpdate() Execute the previously prepared statement.
int	executeUpdate(int idx, java.lang.Object[] par) Execute the previously prepared statement after binding parameters.
static void	executeUpdate(java.lang.String sql, java.lang.String lst) Execute a 'update' SQL statement.

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlUpdate

public SqlUpdate(java.lang.String sql,
         java.lang.Object[] par)
          throws java.sql.SQLException

Construct a SqlUpdate object

Parameters:

sql - SQL statement to be executed

par - SQL statement bind parameters

Throws:

lava.sql.SQLException

java.sql.SQLException

Method Detail

bind

public void bind(int idx,
        java.lang.Object val)
          throws java.sql.SQLException

Bind a parameter at an index.

Parameters:

idx - Parameter index

val - Bind parameter

Throws:

lava.sql.SQLException

java.sql.SQLException

close

public void close(boolean commit)

Close the SqlUpdate object and commit if required

Parameters:

commit - If true commit transactions

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Execute the previously prepared statement.

Throws:

lava.sql.SQLException

java.sql.SQLException

executeUpdate

public int executeUpdate(int idx,
                java.lang.Object[] par)
                  throws java.sql.SQLException

Execute the previously prepared statement after binding parameters.

Parameters:

idx - Start index of the parameter.

par - Array of bind parameters

Throws:

lava.sql.SQLException

java.sql.SQLException

executeUpdate

public static void executeUpdate(java.lang.String sql,
                 java.lang.String lst)

Execute a 'update' SQL statement. ResourceManager's initialize method must be called prior to the invocation of this method.

Parameters:

sql - SQL statement

lst - List comma separated of parameter values