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

@Override
public List<TagBean> getByTargetId(String target_id) throws Exception {
    ResultSetHandler<List<TagBean>> h = new BeanListHandler<TagBean>(TagBean.class);
    return new QueryRunner(basicDataSource).query(GET_TAG_BY_TARGET_ID_TEMPLATE, h, target_id);
}

From source file:com.iana.boesc.dao.BOESCDaoImpl.java

@Override
public Map<String, Map<String, Object>> getAllRegisteredUserDetailsMapByTypeId(int userTypeId) {
    Map<String, Map<String, Object>> map = new HashMap<String, Map<String, Object>>();
    QueryRunner run = new QueryRunner(getDataSource());
    try {// www  .ja v  a 2 s .c o  m
        String query = "SELECT C.BOESC_USER_ID,U.SCAC,C.SEG_DELIM, C.ELE_DELIM,C.TRAN_TYPE FROM BOESC_CONFIG C, BOESC_USERS U WHERE  "
                + " C.BOESC_USER_ID = U.BOESC_USER_ID AND C.TRAN_TYPE IN ('" + GlobalVariables.BOESC + "','"
                + GlobalVariables.DVIR + "') AND U.BOESC_USER_TYPE_ID = ?  ";
        List<Map<String, Object>> listUsersDetails = run.query(query, new MapListHandler(), userTypeId);
        //logger.info("List size ::"+listUsersDetails.size());
        //logger.info("List  ::"+listUsersDetails);
        if (listUsersDetails == null || listUsersDetails.size() == 0)
            return map;
        else
            map = populateUserDetailsFromUserType(userTypeId, listUsersDetails);

    } catch (SQLException e) {
        e.printStackTrace();
        logger.error("SQLException occured :", e);
        logger.error("We are unable to load user information from DB due to SQL Exception.");
    } catch (Exception e) {
        e.printStackTrace();
        logger.error("Exception occured :", e);
        logger.error("We are unable to load user information from DB due to Exception.");
    }
    return map;
}

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

@Override
public void insertOrUpdate(String id, DataBean bean) throws Exception {
    SetClause setClause = bean.genSetClause();
    String clause = String.format(INSERT_OR_UPDATE_DATA_TEMPLATE, setClause.getClause());
    setClause.addValue(System.currentTimeMillis());
    setClause.addValue(bean.getData());/* w  ww  . ja  v  a 2s. com*/
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

@Override
public void update(UserRolesBean bean, String userName, String resourceId, Resource.Type resourceType)
        throws Exception {
    SetClause setClause = bean.genSetClause();
    String clause = String.format(UPDATE_TEMPLATE, setClause.getClause());
    setClause.addValue(userName);/*from w w w  . j  ava 2s.co m*/
    setClause.addValue(resourceId);
    setClause.addValue(resourceType.toString());
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

@Override
public GroupMappingBean getGroupMappingByAsgGroupName(String asgGroupName) throws Exception {
    ResultSetHandler<GroupMappingBean> h = new BeanHandler<>(GroupMappingBean.class);
    return new QueryRunner(dataSource).query(GET_GROUP_MAPPING_BY_ASG, h, asgGroupName);
}

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

@Override
public void insertAutoScalingGroupToCluster(String autoScalingGroup, SpotAutoScalingBean spotAutoScalingBean)
        throws Exception {
    SetClause setClause = spotAutoScalingBean.genSetClause();
    String clause = String.format(INSERT_UPDATE_ASG_MAPPING, setClause.getClause(),
            spotAutoScalingBean.UPDATE_CLAUSE);
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

@Override
public void addHostCapacity(String envId, String host) throws Exception {
    new QueryRunner(dataSource).update(INSERT_HOST, host, envId);
}

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

@Override
public List<String> getHookIdsFromAsgLifeCycleEvent() throws Exception {
    return new QueryRunner(dataSource).query(GET_HOOKID_FROM_ASG_LIFE_CYCLE_EVENT,
            SingleResultSetHandlerFactory.<String>newListObjectHandler());
}

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

@Override
public List<ConfigHistoryBean> getLatestChangesByType(String configId, String type) throws Exception {
    ResultSetHandler<List<ConfigHistoryBean>> h = new BeanListHandler<ConfigHistoryBean>(
            ConfigHistoryBean.class);
    return new QueryRunner(this.dataSource).query(GET_LATEST_CHANGES_BY_TYPE, h, configId, type);
}

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

@Override
public void update(GroupRolesBean bean, String groupName, String resourceId, Resource.Type resourceType)
        throws Exception {
    SetClause setClause = bean.genSetClause();
    String clause = String.format(UPDATE_TEMPLATE, setClause.getClause());
    setClause.addValue(groupName);/*w  w w.j a  v  a2s  .  c o  m*/
    setClause.addValue(resourceId);
    setClause.addValue(resourceType.toString());
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}