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> getAll(int pageIndex, int pageSize) throws Exception {
    long start = (pageIndex - 1) * pageSize;
    ResultSetHandler<List<HostTypeBean>> h = new BeanListHandler<HostTypeBean>(HostTypeBean.class);
    return new QueryRunner(this.dataSource).query(GET_ALL, h, start, pageSize);
}

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

@Override
public Collection<BaseImageBean> getAll(int pageIndex, int pageSize) throws Exception {
    long start = (pageIndex - 1) * pageSize;
    ResultSetHandler<List<BaseImageBean>> h = new BeanListHandler<BaseImageBean>(BaseImageBean.class);
    return new QueryRunner(this.dataSource).query(GET_ALL, h, start, pageSize);
}

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

@Override
public Collection<PlacementBean> getAll(int pageIndex, int pageSize) throws Exception {
    QueryRunner run = new QueryRunner(this.dataSource);
    long start = (pageIndex - 1) * pageSize;
    ResultSetHandler<List<PlacementBean>> h = new BeanListHandler<PlacementBean>(PlacementBean.class);
    return run.query(GET_ALL, h, start, pageSize);
}

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

@Override
public List<SpotAutoScalingBean> getAutoScalingGroupsByCluster(String clusterName) throws Exception {
    ResultSetHandler<List<SpotAutoScalingBean>> h = new BeanListHandler<>(SpotAutoScalingBean.class);
    return new QueryRunner(dataSource).query(GET_ASG_BY_CLUSTER, h, clusterName);
}

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

@Override
public List<AsgAlarmBean> getAlarmInfosByGroup(String groupName) throws Exception {
    ResultSetHandler<List<AsgAlarmBean>> h = new BeanListHandler<AsgAlarmBean>(AsgAlarmBean.class);
    return new QueryRunner(dataSource).query(GET_ALARM_BY_GROUP, h, groupName);
}

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

@Override
public Collection<SecurityZoneBean> getAll(int pageIndex, int pageSize) throws Exception {
    QueryRunner run = new QueryRunner(this.dataSource);
    long start = (pageIndex - 1) * pageSize;
    ResultSetHandler<List<SecurityZoneBean>> h = new BeanListHandler<SecurityZoneBean>(SecurityZoneBean.class);
    return run.query(GET_ALL, h, start, pageSize);
}

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

public List<DocumentItem> findAll(QueryRunner run, Connection conn) throws SQLException {
    List<DocumentItem> items = new ArrayList<DocumentItem>();
    ResultSetHandler<List<DocumentItem>> h = new BeanListHandler<DocumentItem>(DocumentItem.class);
    items = run.query(conn, SQL_FIND_DOCUMENTITEM_ALL, h);
    ProductDao pdao = new ProductDao(path);
    for (DocumentItem di : items) {
        di.setProduct(pdao.find(di.getProduct_id(), run, conn));
    }// w  w  w .  j a  v a  2 s .  c om
    return items;
}

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

@Override
public List<RatingBean> getRatingsByAuthor(String author) throws Exception {
    ResultSetHandler<List<RatingBean>> h = new BeanListHandler<RatingBean>(RatingBean.class);
    QueryRunner run = new QueryRunner(this.dataSource);
    return run.query(GET_USER_RATINGS, h, author);
}

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

public List<Address> findAllByCompanyId(Long companyId, QueryRunner run, Connection conn) throws SQLException {
    List<Address> addresses = new ArrayList<Address>();
    ResultSetHandler<List<Address>> h = new BeanListHandler<Address>(Address.class);
    addresses = run.query(conn, SQL_FIND_ADDRESS_ALL_BY_COMPANY_ID, h, companyId);
    return addresses;
}

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

@Override
public List<ImageBean> getImages(String appName, int pageIndex, int pageSize) throws Exception {
    QueryRunner run = new QueryRunner(dataSource);
    ResultSetHandler<List<ImageBean>> h = new BeanListHandler<>(ImageBean.class);
    if (StringUtils.isNotEmpty(appName)) {
        return run.query(GET_AMI_BY_APPNAME, h, appName, (pageIndex - 1) * pageSize, pageSize);
    } else {//  w  w w .  j  a  va2  s.  c  o  m
        return run.query(GET_ALL_AMI, h, (pageIndex - 1) * pageSize, pageSize);
    }
}