ra.db

Class JdbcExecutor

java.lang.Object

ra.db.JdbcExecutor

All Implemented Interfaces:

StatementExecutor

public class JdbcExecutor
extends java.lang.Object
implements StatementExecutor

SQL statement (CRUD) executor.

Author:

Ray Li

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	JdbcExecutor.Transaction Transaction.

Constructor Summary

Constructors

Constructor and Description
JdbcExecutor(DatabaseConnection db) Initialize.

Method Summary

Modifier and Type	Method and Description
Record	buildRecord() Returns instance of inheriting Record.
RecordCursor	executeQuery(java.lang.String sql) Execute query, ex : SELECT * FROM table.
void	executeTransaction(TransactionExecutor executor) Transaction.
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 SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a 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.

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcExecutor

public JdbcExecutor(DatabaseConnection db)

Initialize.

Parameters:

db - database connection.

Method Detail

isLive

public boolean isLive()

Description copied from interface: StatementExecutor

Returns database state whether available.

Specified by:

isLive in interface StatementExecutor

Returns:

database state

executeUpdate

public 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.

Specified by:

executeUpdate in interface StatementExecutor

Parameters:

sql - SQL statement

Returns:

affected rows

Throws:

RaConnectException

RaSqlException

tryExecuteUpdate

public 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.

Specified by:

tryExecuteUpdate in interface StatementExecutor

Parameters:

sql - SQL statement

Returns:

affected rows

Throws:

RaConnectException

RaSqlException

prepareExecuteUpdate

public int prepareExecuteUpdate(Prepared prepared)
                         throws RaConnectException,
                                RaSqlException

Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.

Specified by:

prepareExecuteUpdate in interface StatementExecutor

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.

Specified by:

prepareExecuteQuery in interface StatementExecutor

Parameters:

prepared - prepared

Returns:

RecordCursor

Throws:

RaConnectException - RaConnectException

RaSqlException - RaSqlException

executeTransaction

public void executeTransaction(TransactionExecutor executor)
                        throws RaConnectException,
                               RaSqlException

Transaction.

Specified by:

executeTransaction in interface StatementExecutor

Parameters:

executor - executor

Throws:

RaSqlException - RaSqlException

RaConnectException - RaConnectException

insert

public LastInsertId insert(java.lang.String sql)

Return the last id after executing SQL statement.

Specified by:

insert in interface StatementExecutor

Parameters:

sql - SQL statement

Returns:

last id

executeQuery

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

Execute query, ex : SELECT * FROM table.

Specified by:

executeQuery in interface StatementExecutor

Parameters:

sql - SQL statement

Returns:

RecordCursor

Throws:

RaConnectException

RaSqlException

buildRecord

public Record buildRecord()

Returns instance of inheriting Record.

Returns:

Record