Example usage for org.apache.commons.dbutils QueryRunner QueryRunner

Introduction

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

Prototype

public QueryRunner(DataSource ds)

Source Link

Document

Constructor for QueryRunner that takes a DataSource to use.

Usage

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

@Override
public Long countNonRegularDeploys(String envId, long after) throws Exception {
    Long count = new QueryRunner(dataSource).query(COUNT_OF_NONREGULAR_DEPLOYS,
            SingleResultSetHandlerFactory.<Long>newObjectHandler(), envId, after);
    return count;
}

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

@Override
public List<HostBean> getStaleEnvHosts(long after) throws Exception {
    ResultSetHandler<List<HostBean>> h = new BeanListHandler<>(HostBean.class);
    return new QueryRunner(dataSource).query(GET_STALE_ENV_HOST, h, after);
}

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

@Override
public long countTotalCapacity(String envId, String envName, String envStage) throws Exception {
    long total = new QueryRunner(dataSource).query(COUNT_HOSTS_BY_CAPACITY,
            SingleResultSetHandlerFactory.<Long>newObjectHandler(), envId, envId);
    List<String> overrideHosts = getOverrideHosts(envId, envName, envStage);
    return total - overrideHosts.size();
}

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

@Override
public List<BuildBean> getAcceptedBuilds(String buildName, String branch, long after, int size)
        throws Exception {
    ResultSetHandler<List<BuildBean>> h = new BeanListHandler<>(BuildBean.class);
    if (StringUtils.isNotEmpty(branch)) {
        return new QueryRunner(dataSource)
                .query(String.format(GET_ACCEPTED_BUILDS_TEMPLATE2, buildName, branch, after, size), h);
    } else {/*w  w  w . j  a va2 s . c om*/
        return new QueryRunner(dataSource)
                .query(String.format(GET_ACCEPTED_BUILDS_TEMPLATE, buildName, after, size), h);
    }
}

From source file:io.apiman.gateway.engine.jdbc.JdbcRegistry.java

/**
 * @see io.apiman.gateway.engine.IRegistry#retireApi(io.apiman.gateway.engine.beans.Api, io.apiman.gateway.engine.async.IAsyncResultHandler)
 *///  w  ww. j  a  v a2 s .  c o m
@Override
public void retireApi(Api api, IAsyncResultHandler<Void> handler) {
    QueryRunner run = new QueryRunner(ds);
    try {
        run.update("DELETE FROM gw_apis WHERE org_id = ? AND id = ? AND version = ?", //$NON-NLS-1$
                api.getOrganizationId(), api.getApiId(), api.getVersion());
        handler.handle(AsyncResultImpl.create((Void) null, Void.class));
    } catch (SQLException e) {
        handler.handle(AsyncResultImpl.create(e));
    }
}

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

@Override
public long countStuckAgent(String envId, String deployId) throws Exception {
    Long n = new QueryRunner(dataSource).query(GET_STUCK_TOTAL,
            SingleResultSetHandlerFactory.<Long>newObjectHandler(), envId, deployId);
    return n == null ? 0 : n;
}

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

@Override
public List<HostBean> getHostsByGroup(String groupName, long pageIndex, int pageSize) throws Exception {
    ResultSetHandler<List<HostBean>> h = new BeanListHandler<>(HostBean.class);
    return new QueryRunner(dataSource).query(GET_HOSTS_BY_GROUP, h, groupName, (pageIndex - 1) * pageSize,
            pageSize);/*from   w w w .  j a v a 2 s.  com*/
}

From source file:gr.osmosis.rcpsamples.contact.db.derby.DerbyContactsDAO.java

public int getMaxId() {

    StringBuffer sbSelect = new StringBuffer();
    sbSelect.append("SELECT MAX(ID) AS MAX_ID ");
    sbSelect.append(" FROM ");
    sbSelect.append(ContactsConstants.CONTACTS_TABLE_NAME);

    // Create a QueryRunner that will use connections from
    // the given DataSource
    DataSource d = DerbyDAOFactory.getDataSource();
    QueryRunner run = new QueryRunner(d);

    ResultSetHandler h = new ResultSetHandler() {
        public Object handle(ResultSet rs) throws SQLException {

            if (!rs.next()) {
                return null;
            }//ww w  . j  av a2  s  .  c  o m

            int max;

            max = rs.getInt("MAX_ID");

            Integer value = new Integer(max);

            return value;
        }
    };

    Object result = null;

    try {
        result = run.query(sbSelect.toString(), h);

    } catch (SQLException sex) {
        sex.printStackTrace();
    } catch (Exception ex) {
        ex.printStackTrace();
    }

    int max;

    if (result != null) {
        max = ((Integer) result).intValue();
    } else {
        max = 0;
    }

    return max;
}

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

/**
 * ??Bean?Bean?List/*  ww  w. j ava  2 s .c o  m*/
 * 
 * @param entityClass
 *            ??
 * @param sql
 *            sql?
 * @param params
 *            ?
 * @return 
 */
@SuppressWarnings({ "unchecked", "rawtypes" })
public <T> List<T> find(Class<T> entityClass, String sql, Object[] params) throws DaoException {
    queryRunner = new QueryRunner(dataSource);
    List<T> list = new ArrayList<T>();
    try {
        if (params == null) {
            list = (List<T>) queryRunner.query(sql, new BeanListHandler(entityClass));
        } else {
            list = (List<T>) queryRunner.query(sql, 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:io.apiman.manager.api.jdbc.JdbcMetricsAccessor.java

/**
 * @see io.apiman.manager.api.core.IMetricsAccessor#getResponseStatsSummary(java.lang.String, java.lang.String, java.lang.String, org.joda.time.DateTime, org.joda.time.DateTime)
 *///from  w ww .j  a v  a2  s.c  o  m
@Override
public ResponseStatsSummaryBean getResponseStatsSummary(String organizationId, String apiId, String version,
        DateTime from, DateTime to) {
    try {
        QueryRunner run = new QueryRunner(ds);
        String sql = "SELECT resp_type, count(*) FROM gw_requests WHERE api_org_id = ? AND api_id = ? AND api_version = ? AND rstart >= ? AND rstart < ? GROUP BY resp_type"; //$NON-NLS-1$
        ResultSetHandler<ResponseStatsSummaryBean> handler = new ResponseStatsSummaryHandler();
        return run.query(sql, handler, organizationId, apiId, version, from.getMillis(), to.getMillis());
    } catch (SQLException e) {
        e.printStackTrace();
        return new ResponseStatsSummaryBean();
    }
}