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

@Override
public List<EnvironBean> getByName(String envName) throws Exception {
    ResultSetHandler<List<EnvironBean>> h = new BeanListHandler<EnvironBean>(EnvironBean.class);
    return new QueryRunner(dataSource).query(GET_ENV_BY_NAME, h, envName);
}

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

@Override
public void insertOrUpdate(String hostName, String ip, String hostId, String state, Set<String> groupNames)
        throws Exception {
    long now = System.currentTimeMillis();
    //TODO need to refactoring this to be more generic to all columns, e.g. use genStringGroupClause() like the other DAOs
    StringBuilder names = new StringBuilder("(host_id,group_name,create_date,last_update,state");
    if (hostName != null) {
        names.append(",host_name");
    }//from   w ww  . ja  va  2  s .co  m
    if (ip != null) {
        names.append(",ip");
    }
    names.append(")");

    StringBuilder sb = new StringBuilder();
    for (String groupName : groupNames) {
        sb.append("('");
        sb.append(hostId);
        sb.append("','");
        sb.append(groupName);
        sb.append("',");
        sb.append(now);
        sb.append(",");
        sb.append(now);
        sb.append(",'");
        sb.append(state);

        if (hostName != null) {
            sb.append("','");
            sb.append(hostName);
        }

        if (ip != null) {
            sb.append("','");
            sb.append(ip);
        }

        sb.append("'),");
    }
    sb.setLength(sb.length() - 1);
    new QueryRunner(dataSource).update(String.format(INSERT_UPDATE_TEMPLATE, names, sb.toString()), ip, now,
            state, hostName, hostName, ip);
}

From source file:azkaban.migration.scheduler.JdbcScheduleLoader.java

@Override
public void removeSchedule(Schedule s) throws ScheduleManagerException {
    logger.info("Removing schedule " + s.getScheduleName() + " from db.");

    QueryRunner runner = new QueryRunner(dataSource);

    try {/*  w w w .  j a  v  a2  s.co m*/
        int removes = runner.update(REMOVE_SCHEDULE_BY_KEY, s.getProjectId(), s.getFlowName());
        if (removes == 0) {
            throw new ScheduleManagerException("No schedule has been removed.");
        }
    } catch (SQLException e) {
        logger.error(REMOVE_SCHEDULE_BY_KEY + " failed.");
        throw new ScheduleManagerException("Remove schedule " + s.getScheduleName() + " from db failed. ", e);
    }
}

From source file:gr.osmosis.rcpsamples.contact.db.derby.DerbyContactsDAO.java

public boolean createContact(Contact contact) {
    if (contact == null) {
        throw new NullPointerException("contact parameter");
    }//from w  ww  .  java  2  s  .  com

    int rows = 0;

    try {
        StringBuffer sbInsert = new StringBuffer();

        sbInsert.append("INSERT INTO ");
        sbInsert.append(ContactsConstants.CONTACTS_TABLE_NAME);
        sbInsert.append("(");
        sbInsert.append(ContactsConstants.CONTACTS_COL_FNAME + ", ");
        sbInsert.append(ContactsConstants.CONTACTS_COL_LNAME + ", ");
        sbInsert.append(ContactsConstants.CONTACTS_COL_PHONE + ", ");
        sbInsert.append(ContactsConstants.CONTACTS_COL_ADDRESS + ", ");
        sbInsert.append(ContactsConstants.CONTACTS_COL_CITY + ", ");
        sbInsert.append(ContactsConstants.CONTACTS_COL_ZIP);
        sbInsert.append(")");
        sbInsert.append(" VALUES (");
        sbInsert.append(" '" + contact.getFname() + "' , ");
        sbInsert.append(" '" + contact.getLname() + "' , ");
        sbInsert.append(" '" + contact.getPhone() + "' , ");
        sbInsert.append(" '" + contact.getAddress() + "' , ");
        sbInsert.append(" '" + contact.getCity() + "' , ");
        sbInsert.append(" '" + contact.getZip() + "'  ");
        sbInsert.append(")");

        DataSource d = DerbyDAOFactory.getDataSource();
        QueryRunner run = new QueryRunner(d);

        rows = run.update(sbInsert.toString());

        if (rows != 1) {
            throw new SQLException("executeUpdate return value: " + rows);
        }

    } catch (SQLException ex) {
        ex.printStackTrace();
        return false;
    }

    return true;

}

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

@Override
public List<DeployBean> getAcceptedDeploys(String envId, long after, int size) throws Exception {
    ResultSetHandler<List<DeployBean>> h = new BeanListHandler<>(DeployBean.class);
    String typesClause = QueryUtils.genEnumGroupClause(StateMachines.AUTO_PROMOTABLE_DEPLOY_TYPE);
    return new QueryRunner(dataSource)
            .query(String.format(GET_ACCEPTED_DEPLOYS_TEMPLATE, envId, typesClause, after, size), h);
}

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

/**
 * @see io.apiman.manager.api.core.IMetricsAccessor#getResponseStats(java.lang.String, java.lang.String, java.lang.String, io.apiman.manager.api.beans.metrics.HistogramIntervalType, org.joda.time.DateTime, org.joda.time.DateTime)
 *//*from   ww  w. j  av  a  2s  .  c om*/
@Override
public ResponseStatsHistogramBean getResponseStats(String organizationId, String apiId, String version,
        HistogramIntervalType interval, DateTime from, DateTime to) {
    ResponseStatsHistogramBean rval = new ResponseStatsHistogramBean();
    Map<Long, ResponseStatsDataPoint> index = generateHistogramSkeleton(rval, from, to, interval,
            ResponseStatsDataPoint.class, Long.class);

    try {
        QueryRunner run = new QueryRunner(ds);
        String gbColumn = groupByColumn(interval);
        String sql = "SELECT " + gbColumn //$NON-NLS-1$
                + ", resp_type, count(*) FROM gw_requests WHERE api_org_id = ? AND api_id = ? AND api_version = ? AND rstart >= ? AND rstart < ? GROUP BY resp_type," //$NON-NLS-1$
                + gbColumn;
        ResultSetHandler<ResponseStatsHistogramBean> handler = new ResponseStatsHistogramHandler(rval, index);
        run.query(sql, handler, organizationId, apiId, version, from.getMillis(), to.getMillis());
    } catch (SQLException e) {
        e.printStackTrace();
    }

    return rval;
}

From source file:esg.node.filters.UrlResolvingDAO.java

public void setDataSource(DataSource dataSource) {
    this.dataSource = dataSource;
    this.queryRunner = new QueryRunner(dataSource);
    this.resolutionResultSetHandler = new ResultSetHandler<String>() {
        public String handle(ResultSet rs) throws SQLException {
            if (!rs.next()) {
                return null;
            }/* w w w .ja  v  a2s  .co m*/
            return rs.getString(1);
        }
    };

}

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

@Override
public void deleteById(String id) throws Exception {
    new QueryRunner(dataSource).update(DELETE_HOST_BY_ID, id);
}

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

@Override
public EnvironBean getByStage(String envName, String envStage) throws Exception {
    ResultSetHandler<EnvironBean> h = new BeanHandler<EnvironBean>(EnvironBean.class);
    return new QueryRunner(dataSource).query(GET_ENV_BY_STAGE, h, envName, envStage);
}

From source file:esg.node.components.metrics.MetricsDAO.java

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