net.ontopia.persistence.query.sql
Class SQLStatement

java.lang.Object
  net.ontopia.persistence.query.sql.SQLStatement

All Implemented Interfaces:

SQLStatementIF

public class SQLStatement
extends java.lang.Object
implements SQLStatementIF

INTERNAL: The default SQL statement implementation.

Field Summary

protected int	fetchSize
protected ObjectAccessIF	oaccess
protected ParameterProcessorIF	param_processor
protected AccessRegistrarIF	registrar
protected FieldHandlerIF[]	select_fields
protected int[]	select_offsets
protected java.lang.String	sql
protected int	width

Constructor Summary

SQLStatement(java.lang.String sql, FieldHandlerIF[] select_fields, ParameterProcessorIF param_processor)

Method Summary

java.sql.ResultSet	executeQuery(java.sql.Connection conn) INTERNAL: Execute the statement without any parameters and return a JDBC result set.
java.sql.ResultSet	executeQuery(java.sql.Connection conn, java.util.Map params) INTERNAL: Execute the statement with parameters and return a JDBC result set.
java.sql.ResultSet	executeQuery(java.sql.Connection conn, java.lang.Object[] params) INTERNAL: Execute the statement with parameters and return a JDBC result set.
java.lang.String	getSQL()
TicketIF	getTicket()
int	getWidth() INTERNAL: Returns the number of fields that will be selected by the statement.
java.lang.Object	readValue(TicketIF ticket, java.sql.ResultSet rs, int index, boolean lookup_identity) INTERNAL: Read the field value of the specified index from the current row in the result set.
java.lang.Object[]	readValues(TicketIF ticket, java.sql.ResultSet rs, boolean lookup_identities) INTERNAL: Reads all the field values from the current row in the result set.
java.lang.Object[]	readValues(TicketIF ticket, java.sql.ResultSet rs, java.lang.Object[] values, boolean lookup_identities) INTERNAL: Reads all the field values from the current row into the specified value array.
void	setAccessRegistrar(AccessRegistrarIF registrar)
void	setFetchSize(int fetchSize)
void	setObjectAccess(ObjectAccessIF oaccess)
java.lang.String	toString()

Methods inherited from class java.lang.Object

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

Field Detail

oaccess

protected ObjectAccessIF oaccess

registrar

protected AccessRegistrarIF registrar

sql

protected java.lang.String sql

fetchSize

protected int fetchSize

width

protected int width

select_offsets

protected int[] select_offsets

select_fields

protected FieldHandlerIF[] select_fields

param_processor

protected ParameterProcessorIF param_processor

Constructor Detail

SQLStatement

public SQLStatement(java.lang.String sql,
                    FieldHandlerIF[] select_fields,
                    ParameterProcessorIF param_processor)

Method Detail

setObjectAccess

public void setObjectAccess(ObjectAccessIF oaccess)

Specified by:

setObjectAccess in interface SQLStatementIF

setAccessRegistrar

public void setAccessRegistrar(AccessRegistrarIF registrar)

Specified by:

setAccessRegistrar in interface SQLStatementIF

getTicket

public TicketIF getTicket()

Specified by:

getTicket in interface SQLStatementIF

setFetchSize

public void setFetchSize(int fetchSize)

getWidth

public int getWidth()

Description copied from interface: SQLStatementIF

INTERNAL: Returns the number of fields that will be selected by the statement.

Specified by:

getWidth in interface SQLStatementIF

getSQL

public java.lang.String getSQL()

executeQuery

public java.sql.ResultSet executeQuery(java.sql.Connection conn)
                                throws java.lang.Exception

Description copied from interface: SQLStatementIF

INTERNAL: Execute the statement without any parameters and return a JDBC result set.

Specified by:

executeQuery in interface SQLStatementIF

Throws:

java.lang.Exception

executeQuery

public java.sql.ResultSet executeQuery(java.sql.Connection conn,
                                       java.lang.Object[] params)
                                throws java.lang.Exception

Description copied from interface: SQLStatementIF

INTERNAL: Execute the statement with parameters and return a JDBC result set.

Specified by:

executeQuery in interface SQLStatementIF

Throws:

java.lang.Exception

executeQuery

public java.sql.ResultSet executeQuery(java.sql.Connection conn,
                                       java.util.Map params)
                                throws java.lang.Exception

Description copied from interface: SQLStatementIF

INTERNAL: Execute the statement with parameters and return a JDBC result set.

Specified by:

executeQuery in interface SQLStatementIF

Throws:

java.lang.Exception

readValue

public java.lang.Object readValue(TicketIF ticket,
                                  java.sql.ResultSet rs,
                                  int index,
                                  boolean lookup_identity)
                           throws java.lang.Exception

Description copied from interface: SQLStatementIF

INTERNAL: Read the field value of the specified index from the current row in the result set.

If the field is an identity field or a reference field, the object identity will be extracted and the identity will be used to look up the object in the transaction.

Specified by:

readValue in interface SQLStatementIF

Throws:

java.lang.Exception

readValues

public java.lang.Object[] readValues(TicketIF ticket,
                                     java.sql.ResultSet rs,
                                     java.lang.Object[] values,
                                     boolean lookup_identities)
                              throws java.lang.Exception

Description copied from interface: SQLStatementIF

INTERNAL: Reads all the field values from the current row into the specified value array. Note that this array must have a width that is equal or greater than the width of the result.

Specified by:

readValues in interface SQLStatementIF

Throws:

java.lang.Exception

readValues

public java.lang.Object[] readValues(TicketIF ticket,
                                     java.sql.ResultSet rs,
                                     boolean lookup_identities)
                              throws java.lang.Exception

Description copied from interface: SQLStatementIF

INTERNAL: Reads all the field values from the current row in the result set.

Specified by:

readValues in interface SQLStatementIF

Throws:

java.lang.Exception

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object