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

Introduction

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

Prototype

public ResultSetDynaClass(ResultSet resultSet) throws SQLException 

Source Link

Document

Construct a new ResultSetDynaClass for the specified ResultSet.

Usage

From source file:DynaBeansExampleV2.java

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

    Connection conn = getConnection();
    PreparedStatement ps = conn//  w ww . ja v  a 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 w  w. jav a  2 s .c o m
        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;
}

---