org.apache.cocoon.components.language.markup.xsp
Class EsqlQuery

java.lang.Object
  |
  +--org.apache.cocoon.components.language.markup.xsp.EsqlQuery

public class EsqlQuery
extends java.lang.Object

This helper class takes care of contstructing queries and cursor positioning (paging) for all different kinds of databases

Author:
Torsten Curdt based on the orginal esql.xsl

Constructor Summary
EsqlQuery(EsqlConnection connection, java.lang.String query)
           
 
Method Summary
 java.sql.Statement createStatement()
           
 boolean execute()
           
 int getCurrentRow()
           
 java.lang.Object getGroupingVar(java.lang.String key)
           
 int getMaxRows()
           
 boolean getMoreResults()
           
 java.sql.PreparedStatement getPreparedStatement()
           
 java.lang.String getQueryString()
           
 void getResultRows()
           
 java.sql.ResultSet getResultSet()
           
 java.sql.ResultSetMetaData getResultSetMetaData()
           
 int getSkipRows()
           
 java.sql.Statement getStatement()
           
 boolean hasResultSet()
           
 boolean keepGoing()
           
 boolean nextRow()
           
 java.sql.PreparedStatement prepareStatement()
           
 int rowCount()
           
 java.lang.Object setGroupingVar(java.lang.String key, java.lang.Object value)
           
 void setKeepGoing(boolean still)
           
 void setMaxRows(int i)
           
 void setSkipRows(int i)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

EsqlQuery

public EsqlQuery(EsqlConnection connection,
                 java.lang.String query)
Method Detail

getSkipRows

public int getSkipRows()

setSkipRows

public void setSkipRows(int i)

getMaxRows

public int getMaxRows()

setMaxRows

public void setMaxRows(int i)

getCurrentRow

public int getCurrentRow()

getQueryString

public java.lang.String getQueryString()

prepareStatement

public java.sql.PreparedStatement prepareStatement()
                                            throws java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement()

getResultSet

public java.sql.ResultSet getResultSet()

nextRow

public boolean nextRow()
                throws java.sql.SQLException

keepGoing

public boolean keepGoing()

setKeepGoing

public void setKeepGoing(boolean still)

setGroupingVar

public java.lang.Object setGroupingVar(java.lang.String key,
                                       java.lang.Object value)

getGroupingVar

public java.lang.Object getGroupingVar(java.lang.String key)

getResultSetMetaData

public java.sql.ResultSetMetaData getResultSetMetaData()

createStatement

public java.sql.Statement createStatement()
                                   throws java.sql.SQLException

getStatement

public java.sql.Statement getStatement()

getMoreResults

public boolean getMoreResults()
                       throws java.sql.SQLException

execute

public boolean execute()
                throws java.sql.SQLException

hasResultSet

public boolean hasResultSet()

rowCount

public int rowCount()
             throws java.sql.SQLException

getResultRows

public void getResultRows()
                   throws java.sql.SQLException


Copyright © 1999-2002 Apache Software Foundation. All Rights Reserved.