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

@Override
public void insert(HostBean hostBean) throws Exception {
    SetClause setClause = hostBean.genSetClause();
    String clause = String.format(INSERT_HOST_TEMPLATE, setClause.getClause(), HostBean.UPDATE_CLAUSE);
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

@Override
public List<GroupBean> getGroupInfoByAppName(String appName) throws Exception {
    ResultSetHandler<List<GroupBean>> h = new BeanListHandler<GroupBean>(GroupBean.class);
    return new QueryRunner(dataSource).query(GET_GROUP_INFO_BY_APP_NAME, h, appName);
}

From source file:io.dockstore.common.BasicPostgreSQL.java

protected boolean runUpdateStatement(String query, Object... params) {
    try {//from  w ww . java 2  s . co m
        QueryRunner run = new QueryRunner(dataSource);
        run.update(query, params);
        return true;
    } catch (Exception e) {
        e.printStackTrace();
        throw new RuntimeException(e);
    }
}

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

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

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

@Override
public void update(String deployId, DeployBean deployBean) throws Exception {
    SetClause setClause = deployBean.genSetClause();
    String clause = String.format(UPDATE_DEPLOYMENT_TEMPLATE, setClause.getClause());
    setClause.addValue(deployId);//from   w w w.  j  av a 2 s . c o  m
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

@Override
public List<String> getRecentHealthCheckStatus(String groupName, int pageSize) throws Exception {
    return new QueryRunner(dataSource).query(GET_RECENT_HEALTH_CHECK_STATUS,
            SingleResultSetHandlerFactory.<String>newListObjectHandler(), groupName,
            HealthCheckState.COMPLETED.toString(), pageSize);
}

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

@Override
public List<String> getBuildNames(String nameFilter, int pageIndex, int pageSize) throws Exception {
    QueryRunner run = new QueryRunner(this.dataSource);
    if (StringUtils.isNotEmpty(nameFilter)) {
        return run.query(GET_BUILD_NAMES, SingleResultSetHandlerFactory.<String>newListObjectHandler(),
                String.format("%%%s%%", nameFilter), (pageIndex - 1) * pageSize, pageSize);
    } else {//from   w  ww. jav  a2 s.c  om
        return run.query(GET_BUILD_NAMES2, SingleResultSetHandlerFactory.<String>newListObjectHandler(),
                (pageIndex - 1) * pageSize, pageSize);
    }
}

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

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

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

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

From source file:esg.node.core.ESGDAO.java

public final void setDataSource(DataSource dataSource) {
    this.dataSource = dataSource;
    this.queryRunner = new QueryRunner(dataSource);
}