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.clusterservice.db.DBBaseImageDAOImpl.java

@Override
public Collection<BaseImageBean> getAll(int pageIndex, int pageSize) throws Exception {
    long start = (pageIndex - 1) * pageSize;
    ResultSetHandler<List<BaseImageBean>> h = new BeanListHandler<BaseImageBean>(BaseImageBean.class);
    return new QueryRunner(this.dataSource).query(GET_ALL, h, start, pageSize);
}

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

public void delete(String id) throws Exception {
    new QueryRunner(basicDataSource).update(DELETE_TAG_TEMPLATE, id);
}

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

@Override
public void deleteNewInstanceReport(String hostId, String envId) throws Exception {
    new QueryRunner(dataSource).update(DELETE_INSTANCE_REPORT_TMPL, hostId, envId);
}

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

@Override
public void deleteAsgLifeCycleEventByHookId(String hookId) throws Exception {
    new QueryRunner(dataSource).update(DELETE_ASG_LIFE_CYCLE_EVENT_BY_HOOKID, hookId);
}

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

@Override
public void update(String hotfix_id, HotfixBean bean) throws Exception {
    SetClause setClause = bean.genSetClause();
    String clause = String.format(UPDATE_HOTFIX_BY_ID_TEMPLATE, setClause.getClause());
    setClause.addValue(hotfix_id);//from   ww  w. j av  a2 s. c  om
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

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

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

@Override
public void delete(String groupName, String resourceId, Resource.Type resourceType) throws Exception {
    new QueryRunner(dataSource).update(DELETE_TEMPLATE, groupName, resourceId, resourceType.toString());
}

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

@Override
public void update(String id, DataBean bean) throws Exception {
    SetClause setClause = bean.genSetClause();
    String clause = String.format(UPDATE_DATA_TEMPLATE, setClause.getClause());
    setClause.addValue(id);//from  w ww.  ja v  a2s  . co m
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

@Override
public void update(String hostName, String envId, AgentErrorBean agentErrorBean) throws Exception {
    SetClause setClause = agentErrorBean.genSetClause();
    String clause = String.format(UPDATE_ERROR_TEMPLATE, setClause.getClause());
    setClause.addValue(hostName);//w w w  .  j a  v  a2  s  .  c  o  m
    setClause.addValue(envId);
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

@Override
public void updateGroupMapping(String asgGroupName, GroupMappingBean groupMappingsBean) throws Exception {
    SetClause setClause = groupMappingsBean.genSetClause();
    String clause = String.format(UPDATE_GROUP_MAPPING, setClause.getClause());
    setClause.addValue(asgGroupName);//from   ww  w .  j  a v  a 2s. c  om
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}