Examples of DBReader

org.apache.empire.db.DBReader

This class is used to perform database queries from a DBCommand object and access the results.
In oder to perform a query call the open() function or - for single row queries - call getRecordData();
You can iterate through the rows using moveNext() or an iterator.

However take care: A reader must always be explicitly closed using the close() method!
Otherwise you may lock the JDBC connection and run out of resources.
Use

try { ... } finally { reader.close(); }

to make sure the reader is closed.

To access and work with the query result you can do one of the following:

access field values directly by using one of the get... functions (see {@link DBRecordData})
get the rows as a list of Java Beans using by using {@link DBReader#getBeanList(Class,int)}
get the rows as an XML-Document using {@link DBReader#getXmlDocument()}
initialize a DBRecord with the current row data using {@link DBReader#initRecord(DBRowSet,DBRecord)}
This will allow you to modify and update the data.

    }


    // SupplierReader
    public boolean initBeanList(DBCommand cmd)
    {
        DBReader reader = new DBReader();
        try {
            // Open Suppier Reader
            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);
            }
            // Read List
            list = reader.getBeanList(beanClass, getPageSize());
            if (list==null)
            {   return error(reader);
            }
            // done
            return true;
            
        } finally {
            reader.close();
        }
    }

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.

Examples of DBReader

Examples of org.apache.empire.db.DBReader