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.arcee.db.DBGroupInfoDAOImpl.java

@Override
public List<String> getGroupNamesByHostIdAndASGStatus(String hostId, String asgStatus) throws Exception {
    return new QueryRunner(dataSource).query(GET_GROUPNAMES_BY_HOSTID_AND_ASGSTATUS,
            SingleResultSetHandlerFactory.<String>newListObjectHandler(), hostId, asgStatus);
}

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

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

From source file:info.pancancer.arch3.persistence.PostgreSQL.java

private <T> T runSelectStatement(String query, ResultSetHandler<T> handler, Object... params) {
    try {//from   w w w  .  jav  a2s  .c om
        QueryRunner run = new QueryRunner(dataSource);
        return run.query(query, handler, params);
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

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

@Override
public List<AgentBean> getAllByEnv(String envId) throws Exception {
    ResultSetHandler<List<AgentBean>> h = new BeanListHandler<>(AgentBean.class);
    return new QueryRunner(dataSource).query(GET_ALL_AGENT_BY_ENV, h, envId);
}

From source file:azkaban.database.DataSourceUtils.java

public static void testConnection(DataSource ds) throws SQLException {
    QueryRunner runner = new QueryRunner(ds);
    runner.update("SHOW TABLES");
}

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

@Override
public List<HostTagInfo> getHostsByEnvId(String envId) throws Exception {
    ResultSetHandler<List<HostTagInfo>> h = new BeanListHandler<>(HostTagInfo.class, ROW_PROCESSOR);
    return new QueryRunner(dataSource).query(GET_HOSTS_BY_ENV_ID, h, envId);
}

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

@Override
public List<String> getAllEnvNames(String nameFilter, long pageIndex, int pageSize) throws Exception {
    if (StringUtils.isNotEmpty(nameFilter)) {
        String filter = String.format("%%%s%%", nameFilter);
        return new QueryRunner(dataSource).query(GET_ALL_ENV,
                SingleResultSetHandlerFactory.<String>newListObjectHandler(), filter,
                (pageIndex - 1) * pageSize, pageSize);
    } else {// w  w w  . j a  v a2  s .  c  o  m
        return new QueryRunner(dataSource).query(GET_ALL_ENV2,
                SingleResultSetHandlerFactory.<String>newListObjectHandler(), (pageIndex - 1) * pageSize,
                pageSize);
    }
}

From source file:esg.node.components.registry.RegistrationGleanerHelperDAO.java

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

From source file:com.fluke.database.dataservice.IntraDayDao.java

public List<IntradayTicker> getIntraday(String name, String date) {
    try {/*  w w  w  .  j a v a2  s .  c o m*/
        QueryRunner run = new QueryRunner(DatabaseProperty.getDataSource());
        String select = "select * from intraday  where equity = ? and  date=?  order by time asc";
        Object[] params = new Object[] { name, date };
        ResultSetHandler rsh = new BeanListHandler(IntradayTicker.class);
        return (List<IntradayTicker>) run.query(select, rsh, params);
    } catch (SQLException ex) {
        throw new RuntimeException(ex);
    }
}

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

@Override
public List<HealthCheckBean> getHealthChecksByUnterminatedHosts() throws Exception {
    ResultSetHandler<List<HealthCheckBean>> h = new BeanListHandler<HealthCheckBean>(HealthCheckBean.class);
    return new QueryRunner(dataSource).query(GET_HEALTH_CHECK_BY_UNTERMINATED_HOSTS, h,
            HealthCheckState.COMPLETED.toString());
}