Example usage for org.apache.commons.dbutils.handlers BeanListHandler BeanListHandler

Introduction

In this page you can find the example usage for org.apache.commons.dbutils.handlers BeanListHandler BeanListHandler.

Prototype

public BeanListHandler(Class<T> type)

Source Link

Document

Creates a new instance of BeanListHandler.

Usage

From source file:com.pinterest.clusterservice.db.DBHostTypeDAOImpl.java

@Override
public Collection<HostTypeBean> getByProviderAndBasic(String provider, boolean basic) throws Exception {
    ResultSetHandler<List<HostTypeBean>> h = new BeanListHandler<HostTypeBean>(HostTypeBean.class);
    return new QueryRunner(dataSource).query(GET_BY_PROVIDER_AND_BASIC, h, provider, basic);
}

From source file:com.softberries.klerk.dao.DocumentDao.java

@Override
public List<Document> findAll() throws SQLException {
    List<Document> documents = new ArrayList<Document>();
    try {//from   w ww  .java2  s.  c om
        init();
        ResultSetHandler<List<Document>> h = new BeanListHandler<Document>(Document.class);
        documents = run.query(conn, SQL_FIND_DOCUMENT_ALL, h);
        //find items
        DocumentItemDao idao = new DocumentItemDao(this.filePath);
        CompanyDao cdao = new CompanyDao(this.filePath);
        PeopleDao pdao = new PeopleDao(this.filePath);

        for (Document d : documents) {
            d.setItems(idao.findAllByDocumentId(d.getId(), run, conn));
            if (d.getDocumentType() == IDocumentType.INVOICE_PURCHASE) {
                d.setSeller(cdao.find(d.getSeller_id(), run, conn, st, generatedKeys));
            } else {
                d.setBuyer(cdao.find(d.getBuyer_id(), run, conn, st, generatedKeys));
            }
            d.setCreator(pdao.find(d.getCreator_id(), run, conn, st, generatedKeys));
        }
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } finally {
        close(conn, st, generatedKeys);
    }
    return documents;
}

From source file:com.pinterest.clusterservice.db.DBBaseImageDAOImpl.java

@Override
public Collection<BaseImageBean> getByProviderAndBasic(String provider, boolean basic) throws Exception {
    ResultSetHandler<List<BaseImageBean>> h = new BeanListHandler<BaseImageBean>(BaseImageBean.class);
    return new QueryRunner(dataSource).query(GET_BY_PROVIDER_AND_BASIC, h, provider, basic);
}

From source file:com.pinterest.arcee.db.DBAsgLifecycleEventDAOImpl.java

@Override
public List<AsgLifecycleEventBean> getAsgLifecycleEventByHook(String hookId) throws Exception {
    ResultSetHandler<List<AsgLifecycleEventBean>> h = new BeanListHandler<AsgLifecycleEventBean>(
            AsgLifecycleEventBean.class);
    return new QueryRunner(dataSource).query(GET_ASG_LIFE_CYCLE_EVENT_BY_HOOK, h, hookId);
}

From source file:com.pinterest.clusterservice.db.DBPlacementDAOImpl.java

@Override
public Collection<PlacementBean> getByProviderAndBasic(String provider, boolean basic) throws Exception {
    ResultSetHandler<List<PlacementBean>> h = new BeanListHandler<PlacementBean>(PlacementBean.class);
    return new QueryRunner(dataSource).query(GET_BY_PROVIDER_AND_BASIC, h, provider, basic);
}

From source file:com.pinterest.clusterservice.db.DBSecurityZoneDAOImpl.java

@Override
public Collection<SecurityZoneBean> getByProviderAndBasic(String provider, boolean basic) throws Exception {
    ResultSetHandler<List<SecurityZoneBean>> h = new BeanListHandler<SecurityZoneBean>(SecurityZoneBean.class);
    return new QueryRunner(dataSource).query(GET_BY_PROVIDER_AND_BASIC, h, provider, basic);
}

From source file:com.pinterest.deployservice.db.DBTagDAOImpl.java

@Override
public List<TagBean> getByTargetId(String target_id) throws Exception {
    ResultSetHandler<List<TagBean>> h = new BeanListHandler<TagBean>(TagBean.class);
    return new QueryRunner(basicDataSource).query(GET_TAG_BY_TARGET_ID_TEMPLATE, h, target_id);
}

From source file:com.che.software.testato.domain.dao.jdbc.impl.IntentionDAO.java

/**
 * Intention search from a bean of criterions.
 * //  w  ww  .  j a v a 2 s  .  co m
 * @author Clement HELIOU (clement.heliou@che-software.com).
 * @param searchBean the criterions to use for the search.
 * @return the resulting object list.
 * @since July, 2011.
 * @throws IntentionSearchDAOException if an error occurs during the search.
 */
@Override
public List<Intention> searchIntention(IntentionSearch searchBean) throws IntentionSearchDAOException {
    LOGGER.debug("searchIntention().");
    Connection connection = null;
    try {
        connection = getDataSource().getConnection();
        List<Object> params = new ArrayList<Object>();
        return getQueryRunner().query(connection, getIntentionSearchQueryFromCriterion(searchBean, params),
                new BeanListHandler<Intention>(Intention.class), params.toArray());
    } catch (SQLException e) {
        throw new IntentionSearchDAOException(e);
    } finally {
        if (null != connection) {
            DbUtils.closeQuietly(connection);
        }
    }
}

From source file:dbutils.ExampleJDBC.java

/**
 * BeanListHandler ResultSet??ListList//from   www  .jav a 2s  .c o m
 */
public static void getBeanListData() {
    Connection conn = getConnection();
    QueryRunner qr = new QueryRunner();
    try {
        ResultSetHandler<Student> rsh = new BeanHandler(Student.class);
        Student usr = qr.query(conn,
                "SELECT id, name, gender, age, team_id as teamId FROM test_student WHERE id=1", rsh);
        System.out.println(StringUtils.center("findById", 50, '*'));
        System.out.println("id=" + usr.getId() + " name=" + usr.getName() + " gender=" + usr.getGender());

        List<Student> results = (List<Student>) qr.query(conn,
                "SELECT id, name, gender, age, team_id as teamId FROM test_student LIMIT 10",
                new BeanListHandler(Student.class));
        System.out.println(StringUtils.center("findAll", 50, '*'));
        for (Student result : results) {
            System.out.println(
                    "id=" + result.getId() + "  name=" + result.getName() + "  gender=" + result.getGender());
        }
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        DbUtils.closeQuietly(conn);
    }
}

From source file:com.pinterest.deployservice.db.DBConfigHistoryDAOImpl.java

@Override
public List<ConfigHistoryBean> getLatestChangesByType(String configId, String type) throws Exception {
    ResultSetHandler<List<ConfigHistoryBean>> h = new BeanListHandler<ConfigHistoryBean>(
            ConfigHistoryBean.class);
    return new QueryRunner(this.dataSource).query(GET_LATEST_CHANGES_BY_TYPE, h, configId, type);
}