org.apache.tapestry.contrib.jdbc
Class SimpleStatement

java.lang.Object
  org.apache.tapestry.contrib.jdbc.SimpleStatement

All Implemented Interfaces:

IStatement

public class SimpleStatement
extends java.lang.Object
implements IStatement

A wrapper around Statement.

Author:

Howard Lewis Ship

Constructor Summary

SimpleStatement(java.lang.String SQL, java.sql.Connection connection)

SimpleStatement(java.lang.String SQL, java.sql.Connection connection, int resultSetType, int resultSetConcurrency)

Method Summary

void	close() Closes the underlying statement, and nulls the reference to it.
java.sql.ResultSet	executeQuery() Executes the statement as a query, returning a ResultSet.
int	executeUpdate() Executes the statement as an update, returning the number of rows affected.
java.lang.String	getSQL() Returns the SQL associated with this statement.
java.sql.Statement	getStatement() Returns the underlying Statement.
java.lang.String	toString()

Methods inherited from class java.lang.Object

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

Constructor Detail

SimpleStatement

public SimpleStatement(java.lang.String SQL,
                       java.sql.Connection connection)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

SimpleStatement

public SimpleStatement(java.lang.String SQL,
                       java.sql.Connection connection,
                       int resultSetType,
                       int resultSetConcurrency)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

getSQL

public java.lang.String getSQL()

Returns the SQL associated with this statement.

Specified by:

getSQL in interface IStatement

getStatement

public java.sql.Statement getStatement()

Returns the underlying Statement.

Specified by:

getStatement in interface IStatement

close

public void close()
           throws java.sql.SQLException

Closes the underlying statement, and nulls the reference to it.

Specified by:

close in interface IStatement

Throws:

java.sql.SQLException

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException

Executes the statement as a query, returning a ResultSet.

Specified by:

executeQuery in interface IStatement

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Executes the statement as an update, returning the number of rows affected.

Specified by:

executeUpdate in interface IStatement

Throws:

java.sql.SQLException

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object