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.DBAlarmDAOImpl.java

@Override
public List<MetricBean> getMetrics() throws Exception {
    ResultSetHandler<List<MetricBean>> h = new BeanListHandler<MetricBean>(MetricBean.class);
    return new QueryRunner(dataSource).query(GET_ALL_METRICS, h);
}

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

@Override
public GroupBean getGroupInfo(String groupName) throws Exception {
    ResultSetHandler<GroupBean> h = new BeanHandler<GroupBean>(GroupBean.class);
    return new QueryRunner(dataSource).query(GET_GROUP_INFO_BY_NAME, h, groupName);
}

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

@Override
public HostTagBean get(String hostId, String tagName) throws Exception {
    ResultSetHandler<HostTagBean> h = new BeanHandler<HostTagBean>(HostTagBean.class);
    return new QueryRunner(dataSource).query(GET_HOST_TAG_BY_HOST_ID_AND_TAG_NAME, h, hostId, tagName);
}

From source file:de.iritgo.aktario.jdbc.JDBCIDGenerator.java

/**
 * Load the last generator state.//w  w w  .java  2s .  c o m
 */
public void load() {
    JDBCManager jdbcManager = (JDBCManager) Engine.instance().getManager("persist.JDBCManager");
    DataSource dataSource = jdbcManager.getDefaultDataSource();

    try {
        QueryRunner query = new QueryRunner(dataSource);
        Object[] res = (Object[]) query.query("select value from IritgoProperties where name=?",
                "persist.ids.nextvalue", new ArrayHandler());

        id = Long.parseLong((String) res[0]);

        free = 0;
        Log.logDebug("persist", "JDBCIDGenerator", "Successfully loaded the generator state (id=" + id + ")");
    } catch (Exception x) {
        Log.logError("persist", "JDBCIDGenerator", "Error while loading the generator state: " + x);
    }
}

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

@Override
public void delete(String buildId) throws Exception {
    new QueryRunner(dataSource).update(DELETE_BUILD, buildId);
}

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

@Override
public void updateAgentById(String hostId, AgentBean bean) throws Exception {
    SetClause setClause = bean.genSetClause();
    String clause = String.format(UPDATE_AGENT_BY_ID_TEMPLATE, setClause.getClause());
    setClause.addValue(hostId);// w  w w.j av a  2 s.c  o m
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

public int deleteEODTicker(String equity) throws SQLException {
    String sql = "delete from EOD where equity=?";
    QueryRunner run = new QueryRunner(DatabaseProperty.getDataSource());
    return run.update(sql, equity);
}

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

@Override
public void insert(EnvironBean bean) throws Exception {
    SetClause setClause = bean.genSetClause();
    String clause = String.format(INSERT_ENV_TEMPLATE, setClause.getClause());
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

@Override
public void removeGroup(String groupName) throws Exception {
    new QueryRunner(dataSource).update(DELETE_GROUP_BY_NAME, groupName);
}

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

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