Java Doc for JdbcEsqlQuery.java in  » Content-Management-System » apache-lenya-2.0 » org » apache » cocoon » components » language » markup » xsp » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Content Management System » apache lenya 2.0 » org.apache.cocoon.components.language.markup.xsp   Source Cross Reference   Class Diagram   Java Document (Java Doc)   org.apache.cocoon.components.language.markup.xsp.AbstractEsqlQuery    org.apache.cocoon.components.language.markup.xsp.JdbcEsqlQuery JdbcEsqlQuery final public class JdbcEsqlQuery extends AbstractEsqlQuery (Code) This EsqlQuery only uses the standard JDBC API approaches. Please note that whether this is good, ok or bad depends on the driver implementation of your database vendor. It should work with all JDBC compliant databases. Unfortunately it seems NOT to work with mssql author:    Torsten Curdt version:    CVS $Id: JdbcEsqlQuery.java 433543 2006-08-22 06:22:54Z crossley $ Constructor Summary public   JdbcEsqlQuery(Connection connection, String query)      Method Summary public  void getResultRows()      public  int getRowCount()      AFAIK this is the proposed JDBC API way to get the number of results. public  AbstractEsqlQuery newInstance(ResultSet resultSet)      public  CallableStatement prepareCall()      public  PreparedStatement prepareStatement()      Constructor Detail JdbcEsqlQuery public JdbcEsqlQuery(Connection connection, String query)(Code) Method Detail getResultRows public void getResultRows() throws SQLException(Code) getRowCount public int getRowCount() throws SQLException(Code) AFAIK this is the proposed JDBC API way to get the number of results. Unfortunately -at least some- driver implementation are transfering the complete resultset when moving to the end. Which is totally stupid for limit/paging purposes. So we probably better stick with an additional count query from the AbstractEsqlQuery newInstance public AbstractEsqlQuery newInstance(ResultSet resultSet)(Code) Create a EsqlQuery of the same type Parameters:   resultSet - prepareCall public CallableStatement prepareCall() throws SQLException(Code) prepareStatement public PreparedStatement prepareStatement() throws SQLException(Code) Methods inherited from org.apache.cocoon.components.language.markup.xsp.AbstractEsqlQuery public void cleanUp()(Code)(Java Doc) final public void decGroupLevel()(Code)(Java Doc) final public boolean execute(int resultSetFromObject) throws SQLException(Code)(Java Doc) final public boolean execute() throws SQLException(Code)(Java Doc) final public boolean executeQuery() throws SQLException(Code)(Java Doc) final public CallableStatement getCallableStatement()(Code)(Java Doc) final public Connection getConnection()(Code)(Java Doc) final public int getCurrentRow()(Code)(Java Doc) final public int getMaxRows()(Code)(Java Doc) final public boolean getMoreResults() throws SQLException(Code)(Java Doc) final public PreparedStatement getPreparedStatement()(Code)(Java Doc) final public int getQueryResultsCount()(Code)(Java Doc) public String getQueryString() throws SQLException(Code)(Java Doc) public void getResultRows() throws SQLException(Code)(Java Doc) final public ResultSet getResultSet()(Code)(Java Doc) final public ResultSetMetaData getResultSetMetaData()(Code)(Java Doc) public int getRowCount() throws SQLException(Code)(Java Doc) final public int getSkipRows()(Code)(Java Doc) final public int getUpdateCount()(Code)(Java Doc) final public int getUpdateResultsCount()(Code)(Java Doc) final public boolean groupLevelExists()(Code)(Java Doc) final public boolean hasGroupingVarChanged() throws SQLException(Code)(Java Doc) final public boolean hasResultSet()(Code)(Java Doc) final public void incGroupLevel()(Code)(Java Doc) final public boolean keepGoing()(Code)(Java Doc) abstract public AbstractEsqlQuery newInstance(ResultSet resultSet)(Code)(Java Doc) final public boolean nextRow() throws SQLException(Code)(Java Doc) public CallableStatement prepareCall() throws SQLException(Code)(Java Doc) public PreparedStatement prepareStatement() throws SQLException(Code)(Java Doc) final public void setGroupingVar(String key) throws SQLException(Code)(Java Doc) final public void setKeepGoing(boolean still)(Code)(Java Doc) final public void setMaxRows(int i)(Code)(Java Doc) final protected void setPosition(int p)(Code)(Java Doc) final protected PreparedStatement setPreparedStatement(PreparedStatement ps)(Code)(Java Doc) final public void setSkipRows(int i)(Code)(Java Doc)