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:io.apiman.gateway.engine.jdbc.JdbcRegistry.java

/**
 * @see io.apiman.gateway.engine.IRegistry#unregisterClient(io.apiman.gateway.engine.beans.Client, io.apiman.gateway.engine.async.IAsyncResultHandler)
 *///from w w w.  ja v  a2  s  . c  om
@Override
public void unregisterClient(Client client, IAsyncResultHandler<Void> handler) {
    try {
        QueryRunner run = new QueryRunner(ds);
        run.update("DELETE FROM gw_clients WHERE org_id = ? AND id = ? AND version = ?", //$NON-NLS-1$
                client.getOrganizationId(), client.getClientId(), client.getVersion());
        handler.handle(AsyncResultImpl.create((Void) null));
    } catch (SQLException e) {
        handler.handle(AsyncResultImpl.create(
                new PublishingException(Messages.i18n.format("JdbcRegistry.ErrorUnregisteringApp"), e), //$NON-NLS-1$
                Void.class));
    }
}

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

@Override
public List<HostBean> getHostsByHostId(String hostId) throws Exception {
    ResultSetHandler<List<HostBean>> h = new BeanListHandler<>(HostBean.class);
    return new QueryRunner(dataSource).query(GET_HOST_BY_HOSTID, h, hostId);
}

From source file:esg.node.components.monitoring.MonitorDAO.java

public void setDataSource(DataSource dataSource) {
    log.trace("Setting Up Monitor DAO's Pooled Data Source");
    this.dataSource = dataSource;
    this.queryRunner = new QueryRunner(dataSource);
}

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

@Override
public void deleteUnusedDeploys(String envId, long timeThreshold, long numOfDeploys) throws Exception {
    new QueryRunner(dataSource).update(DELETE_UNUSED_DEPLOYS, envId, timeThreshold, numOfDeploys);
}

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

@Override
public List<EnvironBean> getEnvsByHost(String host) throws Exception {
    ResultSetHandler<List<EnvironBean>> h = new BeanListHandler<EnvironBean>(EnvironBean.class);
    return new QueryRunner(dataSource).query(String.format(GET_ENVS_BY_HOST_TMPL, host), h);
}

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

@Override
public void deleteUnusedBuilds(String buildName, long timeThreshold, long numOfBuilds) throws Exception {
    new QueryRunner(dataSource).update(DELETE_UNUSED_BUILDS, buildName, timeThreshold, numOfBuilds);
}

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

@Override
public List<HostBean> getTerminatingHosts() throws Exception {
    ResultSetHandler<List<HostBean>> h = new BeanListHandler<>(HostBean.class);
    return new QueryRunner(dataSource).query(GET_HOSTS_BY_STATES, h, HostState.PENDING_TERMINATE.toString(),
            HostState.TERMINATING.toString());
}

From source file:com.xeiam.yank.Yank.java

/**
 * Return just one Bean given an SQL statement. If more than one row match the query, only the first row is returned.
 *
 * @param sql The SQL statement/* w ww . j av a  2s.  c  om*/
 * @param params The replacement parameters
 * @param beanType The Class of the desired return Object matching the table
 * @return The Object
 */
public static <T> T queryBean(String sql, Class<T> beanType, Object[] params) {

    T returnObject = null;

    try {

        BeanHandler<T> resultSetHandler = new BeanHandler<T>(beanType,
                new BasicRowProcessor(new YankBeanProcessor<T>(beanType)));

        returnObject = new QueryRunner(YANK_POOL_MANAGER.getDataSource()).query(sql, resultSetHandler, params);

    } catch (SQLException e) {
        handleSQLException(e);
    }

    return returnObject;
}

From source file:io.apiman.manager.api.jdbc.JdbcMetricsAccessor.java

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

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

@Override
public List<EnvironBean> getEnvsByGroups(Collection<String> groups) throws Exception {
    ResultSetHandler<List<EnvironBean>> h = new BeanListHandler<>(EnvironBean.class);
    String groupStr = QueryUtils.genStringGroupClause(groups);
    return new QueryRunner(dataSource).query(String.format(GET_ENVS_BY_GROUPS_TMPL, groupStr), h);
}