ra.db

Class JdbcExecutor.Transaction

java.lang.Object

ra.db.JdbcExecutor.Transaction

Enclosing class:

JdbcExecutor

public class JdbcExecutor.Transaction
extends java.lang.Object

Transaction.

Author:

Ray Li

Constructor Summary

Constructors

Constructor and Description
Transaction(StatementFactory factory)

Method Summary

Modifier and Type	Method and Description
RecordCursor	executeQuery(java.lang.String sql) Execute a query SQL using a batch.
int	executeUpdate(java.lang.String sql) Execute a SQL using a batch.
LastInsertId	insert(java.lang.String sql) The auto-generated keys generated by this Statement object should be available for use in SQL statements that are INSERT statements.
RecordCursor	prepareExecuteQuery(Prepared prepared) A SQL statement is precompiled and stored in a Prepared object.
int	prepareExecuteUpdate(Prepared prepared) Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

Methods inherited from class java.lang.Object

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

Constructor Detail

Transaction

public Transaction(StatementFactory factory)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

executeUpdate

public int executeUpdate(java.lang.String sql)
                  throws RaSqlException

Execute a SQL using a batch.

Parameters:

sql - sql

Returns:

execute count

Throws:

RaSqlException - RaSqlException

insert

public LastInsertId insert(java.lang.String sql)
                    throws RaSqlException

The auto-generated keys generated by this Statement object should be available for use in SQL statements that are INSERT statements.

Parameters:

sql - sql

Returns:

last id

Throws:

RaSqlException - RaSqlException

executeQuery

public RecordCursor executeQuery(java.lang.String sql)
                          throws RaSqlException

Execute a query SQL using a batch.

Parameters:

sql - sql

Returns:

RecordCursor

Throws:

RaSqlException - RaSqlException

prepareExecuteUpdate

public int prepareExecuteUpdate(Prepared prepared)
                         throws RaConnectException,
                                RaSqlException

Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

Parameters:

prepared - prepared

Returns:

RecordCursor

Throws:

RaConnectException - RaConnectException

RaSqlException - RaSqlException

prepareExecuteQuery

public RecordCursor prepareExecuteQuery(Prepared prepared)
                                 throws RaConnectException,
                                        RaSqlException

A SQL statement is precompiled and stored in a Prepared object. This object can then be used to efficiently execute this statement multiple times.

Parameters:

prepared - prepared

Returns:

RecordCursor

Throws:

RaConnectException - RaConnectException

RaSqlException - RaSqlException