Example usage for org.apache.commons.beanutils ResultSetDynaClass iterator

Introduction

In this page you can find the example usage for org.apache.commons.beanutils ResultSetDynaClass iterator.

Prototype

public Iterator iterator() 

Source Link

Document

Return an Iterator of DynaBean instances for each row of the wrapped ResultSet, in "forward" order.

Usage

From source file:DynaBeansExampleV2.java

public static void main(String args[]) throws Exception {

    Connection conn = getConnection();
    PreparedStatement ps = conn//  w w w .java 2 s .  c o m
            .prepareStatement("SELECT * from movie, person " + "WHERE movie.director = person.Id");
    ResultSet rs = ps.executeQuery();

    ResultSetDynaClass rsdc = new ResultSetDynaClass(rs);

    Iterator itr = rsdc.iterator();
    while (itr.hasNext()) {
        DynaBean bean = (DynaBean) itr.next();
        System.err.println(bean.get("title"));
    }

    conn.close();
}

---

From source file:shell.framework.dao.support.ListExtractor4Bean.java

@SuppressWarnings("all")
public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
    List resultList = new ArrayList();
    try {/*from w ww.j a  v a 2s.c  om*/
        Object bean = null;
        ResultSetDynaClass rsdc = new ResultSetDynaClass(rs);
        Iterator rows = rsdc.iterator();
        while (rows.hasNext()) {
            bean = beanClazz.newInstance();
            DynaBean rowBean = (DynaBean) rows.next();
            BeanUtils.copyProperties(rowBean, bean);
            resultList.add(bean);
        }

    } catch (InstantiationException e) {
        logger.error(e.getMessage() + "| bean instance failure!");
        throw new DaoException(e);
    } catch (IllegalAccessException e) {
        logger.error(e.getMessage() + "| bean instance failure!");
        throw new DaoException(e);
    } catch (InvocationTargetException e) {
        logger.error(e.getMessage() + "| bean instance failure!");
        throw new DaoException(e);
    }

    return resultList;
}

---