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.che.software.testato.domain.dao.jdbc.impl.ActionDAO.java

/**
 * Action search from a bean of criterions.
 * /*from w ww.  ja  v  a2s .  c o 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 ActionSearchDAOException if an error occurs during the search.
 */
@Override
public List<Action> searchAction(ActionSearch searchBean) throws ActionSearchDAOException {
    LOGGER.debug("searchAction().");
    Connection connection = null;
    try {
        connection = getDataSource().getConnection();
        List<Object> params = new ArrayList<Object>();
        return getQueryRunner().query(connection, getActionSearchQueryFromCriterion(searchBean, params),
                new BeanListHandler<Action>(Action.class), params.toArray());
    } catch (SQLException e) {
        throw new ActionSearchDAOException(e);
    } finally {
        if (null != connection) {
            DbUtils.closeQuietly(connection);
        }
    }
}

---

From source file:com.eryansky.core.db.DbUtilsDao.java

/**
 * ??Bean?Bean?List//from   w  ww .  j av a  2 s  .  c  om
 * 
 * @param entityClass
 *            ??
 * @param sql
 *            sql?
 * @param params
 *            ?
 * @param page
 *            ?
 * @param pageSize
 *            ??
 * @return 
 */
@SuppressWarnings({ "unchecked", "rawtypes" })
public <T> List<T> find(Class<T> entityClass, String sql, Object[] params, int page, int pageSize)
        throws DaoException {
    queryRunner = new QueryRunner(dataSource);
    List<T> list = new ArrayList<T>();
    // int startFlag = (((page < 1 ? 1 : page) - 1) * pageSize);
    String pageSql = PageSqlUtils.createPageSql(sql, page, pageSize);
    try {
        if (params == null) {
            list = (List<T>) queryRunner.query(pageSql, new BeanListHandler(entityClass));
        } else {
            list = (List<T>) queryRunner.query(pageSql, new BeanListHandler(entityClass), params);
        }
    } catch (SQLException e) {
        logger.error("Error occured while attempting to query data", e);
        throw new DaoException(e);
    }
    return list;
}

---

From source file:dbutils.DbUtilsTemplate.java

/**
 * ??Bean?Bean?List/*from ww  w  .  j a va2  s.  co  m*/
 *
 * @param entityClass ??
 * @param sql         sql?
 * @param params      ?
 * @return 
 */
@SuppressWarnings("unchecked")
public <T> List<T> find(Class<T> entityClass, String sql, Object[] params) {
    queryRunner = new QueryRunner();
    Connection conn = null;
    List<T> list = new ArrayList<T>();
    try {
        conn = dataSource.getConnection();
        if (params == null) {
            list = (List<T>) queryRunner.query(conn, sql, new BeanListHandler(entityClass));
        } else {
            list = (List<T>) queryRunner.query(conn, sql, new BeanListHandler(entityClass), params);
        }
    } catch (SQLException e) {
        LOG.error("Error occured while attempting to query data", e);
    } finally {
        if (conn != null) {
            DbUtils.closeQuietly(conn);
        }
    }
    return list;
}

---

From source file:com.eryansky.core.db.DbUtilsDao.java

/**
 * ??Bean?Bean?List,?List??PageResult/* www  . j a  v  a 2  s  . c om*/
 * 
 * @param entityClass
 *            ??
 * @param sql
 *            sql? : "select * T_BASE_MENU where name = ?"
 * @param params
 *            ?
 * @param page
 *            ?
 * @param pageSize
 *            ??
 * @return PageResult
 */
@SuppressWarnings({ "unchecked", "rawtypes" })
public <T> Page<T> findPage(Class<T> entityClass, String sql, Object[] params, int page, int pageSize)
        throws DaoException {
    queryRunner = new QueryRunner(dataSource);
    List<T> list = new ArrayList<T>();
    int startPage = page < 1 ? 1 : page;
    // int startFlag = ((startPage - 1) * pageSize);
    String pageSql = PageSqlUtils.createPageSql(sql, startPage, pageSize);
    try {
        if (params == null) {
            list = (List<T>) queryRunner.query(pageSql, new BeanListHandler(entityClass));
        } else {
            list = (List<T>) queryRunner.query(pageSql, new BeanListHandler(entityClass), params);
        }
    } catch (SQLException e) {
        logger.error("Error occured while attempting to query data", e);
        throw new DaoException(e);
    }
    // 
    long count = getCount(sql, params);
    int newCurrentPage = getBeginPage(startPage, pageSize, count);
    Page<T> p = new Page<T>(pageSize);
    p.setPageNo(newCurrentPage);
    p.setResult(list);
    p.setTotalCount(count);
    return p;
}

---

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

/**
 * Iteration search from a bean of criterions.
 * /*w w  w  .ja v  a 2  s  . com*/
 * @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 IterationSearchDAOException if an error occurs during the search.
 */
@Override
public List<Iteration> searchIteration(IterationSearch searchBean) throws IterationSearchDAOException {
    LOGGER.debug("searchIteration().");
    Connection connection = null;
    try {
        connection = getDataSource().getConnection();
        List<Object> params = new ArrayList<Object>();
        return getQueryRunner().query(connection, getIterationSearchQueryFromCriterion(searchBean, params),
                new BeanListHandler<Iteration>(Iteration.class), params.toArray());
    } catch (SQLException e) {
        throw new IterationSearchDAOException(e);
    } finally {
        if (null != connection) {
            DbUtils.closeQuietly(connection);
        }
    }
}

---

From source file:dbutils.DbUtilsTemplate.java

/**
 * ??Bean?Bean?List//from  w ww . j  a v  a2 s.  c  om
 *
 * @param entityClass ??
 * @param sql         sql?
 * @param params      ?
 * @param page        ?
 * @param pageSize    ??
 * @return 
 */
@SuppressWarnings("unchecked")
public <T> List<T> find(Class<T> entityClass, String sql, Object[] params, int page, int pageSize) {
    queryRunner = new QueryRunner();
    Connection conn = null;
    List<T> list = new ArrayList<T>();
    int startFlag = (((page < 1 ? 1 : page) - 1) * pageSize);
    String pageSql = " limit " + startFlag + " , " + startFlag + pageSize;
    try {
        conn = dataSource.getConnection();
        if (params == null) {
            list = (List<T>) queryRunner.query(conn, sql + pageSql, new BeanListHandler(entityClass));
        } else {
            list = (List<T>) queryRunner.query(conn, sql + pageSql, new BeanListHandler(entityClass), params);
        }
    } catch (SQLException e) {
        LOG.error("Error occured while attempting to query data", e);
    } finally {
        if (conn != null) {
            DbUtils.closeQuietly(conn);
        }
    }
    return list;
}

---

From source file:dbutils.DbUtilsTemplate.java

/**
 * ??Bean?Bean?List,?List??PageResult//w ww  . j  a  v  a  2s . co  m
 *
 * @param entityClass ??
 * @param sql         sql?
 * @param params      ?
 * @param page        ?
 * @param pageSize    ??
 * @return PageResult
 */
@SuppressWarnings("unchecked")
public <T> PageResult findPageResult(Class<T> entityClass, String sql, Object[] params, int page,
        int pageSize) {
    queryRunner = new QueryRunner();
    Connection conn = null;
    List<T> list = new ArrayList<T>();
    int startPage = page < 1 ? 1 : page;
    int startFlag = ((startPage - 1) * pageSize);
    String pageSql = " limit " + startFlag + " , " + startFlag + pageSize;
    try {
        conn = dataSource.getConnection();
        if (params == null) {
            list = (List<T>) queryRunner.query(conn, sql + pageSql, new BeanListHandler(entityClass));
        } else {
            list = (List<T>) queryRunner.query(conn, sql + pageSql, new BeanListHandler(entityClass), params);
        }
    } catch (SQLException e) {
        LOG.error("Error occured while attempting to query data", e);
    } finally {
        if (conn != null) {
            DbUtils.closeQuietly(conn);
        }
    }
    // 
    int count = getCount(sql, params);
    // ??
    int currentPage = getBeginPage(startPage, pageSize, count);

    return new PageResult(currentPage, pageSize, list, count);
}

---

From source file:nl.opengeogroep.safetymaps.server.admin.stripes.LayerActionBean.java

@Before
private void loadInfo() throws NamingException, SQLException {
    layers = qr().query("select * from " + TABLE + " where layertype = 'WMS' order by gid",
            new BeanListHandler<>(ConfiguredLayer.class));

    vrhObjectsEnabled = qr().query("select 1 from organisation.modules where name='vrh_objects' and enabled",
            new ScalarHandler<>()) != null;
}

---

From source file:org.gaixie.jibu.security.dao.impl.AuthorityDAODerby.java

/**
 * {@inheritDoc}//from  w ww  .ja  v a 2s  .c o  m
 * <p>
 *  name ?
 */
public List<Authority> getAll(Connection conn) throws SQLException {
    ResultSetHandler<List<Authority>> h = new BeanListHandler(Authority.class);
    return run.query(conn, "SELECT id,name,value FROM authorities order by name ", h);
}

---

From source file:org.gaixie.jibu.security.dao.impl.AuthorityDAODerby.java

public List<Authority> findByName(Connection conn, String name) throws SQLException {
    ResultSetHandler<List<Authority>> h = new BeanListHandler(Authority.class);
    return run.query(conn, "SELECT id,name,value FROM authorities WHERE name like ? order by name ", h,
            name + "%");
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• »