List of skipRows() Examples

Examples of skipRows()

org.apache.empire.db.DBCommand.skipRows()
sets the offset of the first row to return when executing a query command. A negative value will remove the offset. @return true if the database supports an offset or false otherwise
org.apache.empire.db.DBReader.skipRows()
Moves the cursor down the given number of rows. @param count the number of rows to skip @return true if the reader is on a valid record or false otherwise

Examples of org.apache.empire.db.DBCommand.skipRows()

                DBDatabaseDriver driver = queryCmd.getDatabase().getDriver(); 
                if (driver.isSupported(DBDriverFeature.QUERY_LIMIT_ROWS))
                {   // let the database limit the rows
                    if (skipRows>0 && driver.isSupported(DBDriverFeature.QUERY_SKIP_ROWS))
                    {   // let the database skip the rows
                        queryCmd.skipRows(skipRows);
                        skipRows = 0;
                    }
                    queryCmd.limitRows(skipRows+maxItems);
                }
            }

View Full Code Here

Examples of org.apache.empire.db.DBCommand.skipRows()

                DBDatabaseDriver driver = queryCmd.getDatabase().getDriver(); 
                if (driver.isSupported(DBDriverFeature.QUERY_LIMIT_ROWS))
                {   // let the database limit the rows
                    if (driver.isSupported(DBDriverFeature.QUERY_SKIP_ROWS))
                    {   // let the database skip the rows
                        queryCmd.skipRows(skipRows);
                        skipRows = 0;
                    }
                    queryCmd.limitRows(skipRows+maxItems);
                }
            }

View Full Code Here

Examples of org.apache.empire.db.DBReader.skipRows()

        try {
            // Open Suppier Reader
            reader.open(cmd, action.getConnection());
            // Move to desired Position
            int first = this.getFirstItemIndex();
            if (first>0 && !reader.skipRows(first))
            {   // Page is not valid. Try again from beginning
                reader.close();
                setFirstItem(0);
                initBeanList(cmd);
            }

View Full Code Here

Examples of org.apache.empire.db.DBReader.skipRows()

            r.open(queryCmd, getConnection(queryCmd));


            // get position from the session
            if (skipRows>0)
            {   // we are not at position 0, "skipping" entries
                r.skipRows(skipRows);
            }


            // Read all Items
            items = r.getBeanList(beanClass, maxItems);
            if (items == null)

View Full Code Here

Examples of org.apache.empire.db.DBReader.skipRows()

            r.open(queryCmd, getConnection(queryCmd));


            // get position from the session
            if (skipRows>0)
            {   // we are not at position 0, "skipping" entries
                r.skipRows(skipRows);
            }


            // Read all Items
            items = r.getBeanList(beanClass, maxItems);
            if (items == null)

View Full Code Here

Examples of org.apache.empire.db.DBReader.skipRows()

                { // position > count of entries is not possible, set to max
                    position = lti.getItemCount() - lti.getPageSize();
                }
                if (position > 0)
                { // we are not at position 0, "skipping" entries
                    r.skipRows(position);
                }
                else
                    position = 0;
                // maxItems
                maxItems = lti.getPageSize();

View Full Code Here

Examples of org.apache.empire.db.DBReader.skipRows()

            if (!reader.open(cmd, action.getConnection() ))
            {   return error(reader);
            }
            // Move to desired Position
            int first = this.getFirstItemIndex();
            if (first>0 && !reader.skipRows(first))
            {   // Page is not valid. Try again from beginning
                reader.close();
                setFirstItem(0);
                return initBeanList(cmd);
            }

View Full Code Here

Examples of org.apache.empire.db.DBReader.skipRows()

                { // position > count of entries is not possible, set to max
                    position = lti.getItemCount() - lti.getPageSize();
                }
                if (position > 0)
                { // we are not at position 0, "skipping" entries
                    r.skipRows(position);
                }
                else
                    position = 0;
                // maxItems
                maxItems = lti.getPageSize();

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.