ra.db

Interface StatementExecutor

All Known Implementing Classes:

JdbcExecutor

public interface StatementExecutor

SQL statement (CRUD) executor.

Author:

Ray Li

Method Summary

Modifier and Type	Method and Description
RecordCursor	executeQuery(java.lang.String sql) Executes the given SQL statement, which returns a single RecordCursor object.
void	executeTransaction(TransactionExecutor executor) Execute SQL statements.
int	executeUpdate(java.lang.String sql) 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.
LastInsertId	insert(java.lang.String sql) Return the last id after executing SQL statement.
boolean	isLive() Returns database state whether available.
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.
int	tryExecuteUpdate(java.lang.String sql) Attempts to execute 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.

Method Detail

isLive

boolean isLive()

Returns database state whether available.

Returns:

database state

executeUpdate

int executeUpdate(java.lang.String sql)
           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:

sql - SQL statement

Returns:

affected rows

Throws:

RaConnectException

RaSqlException

tryExecuteUpdate

int tryExecuteUpdate(java.lang.String sql)
              throws RaConnectException,
                     RaSqlException

Attempts to execute 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:

sql - SQL statement

Returns:

affected rows

Throws:

RaConnectException

RaSqlException

executeTransaction

void executeTransaction(TransactionExecutor executor)
                 throws RaConnectException,
                        RaSqlException

Execute SQL statements.

Parameters:

executor - executor

Throws:

RaConnectException - RaConnectException

RaSqlException - RaSqlException

insert

LastInsertId insert(java.lang.String sql)
             throws RaConnectException,
                    RaSqlException

Return the last id after executing SQL statement.

Parameters:

sql - SQL statement

Returns:

last id

Throws:

RaConnectException

RaSqlException

executeQuery

RecordCursor executeQuery(java.lang.String sql)
                   throws RaConnectException,
                          RaSqlException

Executes the given SQL statement, which returns a single RecordCursor object.

Parameters:

sql - SQL statement

Returns:

RecordCursor

Throws:

RaConnectException

RaSqlException

prepareExecuteUpdate

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

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