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 List<String> getHostNamesByGroup(String groupName) throws Exception {
    return new QueryRunner(dataSource).query(GET_HOST_NAMES_BY_GROUP,
            SingleResultSetHandlerFactory.<String>newListObjectHandler(), groupName);
}

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

@Override
public void deleteAllByEnvId(String envId, String tagName) throws Exception {
    new QueryRunner(dataSource).update(DELETE_HOST_TAG_BY_ENV_ID_AND_TAG_NAME, envId, tagName);
}

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

@Override
public BuildBean getById(String buildId) throws Exception {
    ResultSetHandler<BuildBean> h = new BeanHandler<>(BuildBean.class);
    return new QueryRunner(dataSource).query(GET_BUILD_BY_ID, h, buildId);
}

From source file:com.example.data.PetData.java

public void addPet(BindObject bindObj) throws SQLException {
    QueryRunner run = new QueryRunner(H2DB.getDataSource());
    run.update("insert into pet(id, category_id, name, photo_urls, tags, status) " + "values(?, ?, ?, ?, ?, ?)",
            bindObj.get("id"), bindObj.obj("category").get("id"), bindObj.get("name"), bindObj.get("photoUrls"),
            bindObj.get("tags"), bindObj.get("status"));
}

From source file:com.eryansky.core.db.DbUtilsDao.java

/**
 * ?sql?,?????//from   w w  w . j a  va2s. c o  m
 * <br>?.
 * @param sql
 *            sql?
 * @param params
 *            ?
 * @return ??
 * @deprecated
 */
public int[] batchUpdate(String sql, Object[][] params) throws DaoException {
    queryRunner = new QueryRunner(dataSource);
    int[] affectedRows = new int[0];
    try {
        affectedRows = queryRunner.batch(sql, params);
    } catch (SQLException e) {
        logger.error("Error occured while attempting to batch update data", e);
        throw new DaoException(e);
    }
    return affectedRows;
}

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

@Override
public List<String> getExistingGroups(long pageIndex, int pageSize) throws Exception {
    return new QueryRunner(dataSource).query(GET_GROUP_NAMES,
            SingleResultSetHandlerFactory.<String>newListObjectHandler(), (pageIndex - 1) * pageSize, pageSize);
}

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

@Override
public void deleteByHostId(String hostId) throws Exception {
    new QueryRunner(dataSource).update(DELETE_BY_HOST_ID, hostId);
}

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

@Override
public void insertOrUpdate(AgentBean updateBean) throws Exception {
    SetClause setClause = updateBean.genSetClause();
    String clause = String.format(INSERT_OR_UPDATE_AGENT_TEMPLATE, setClause.getClause(),
            AgentBean.UPDATE_CLAUSE);/*from w ww .  java 2s .c  o  m*/
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

From source file:io.apiman.manager.api.jpa.JpaStorageInitializer.java

/**
 * Called to initialize the database.//  w w w .j a  v a  2s.co m
 */
@SuppressWarnings("nls")
public void initialize() {
    QueryRunner run = new QueryRunner(ds);
    Boolean isInitialized;

    try {
        isInitialized = run.query("SELECT * FROM apis", new ResultSetHandler<Boolean>() {
            @Override
            public Boolean handle(ResultSet rs) throws SQLException {
                return true;
            }
        });
    } catch (SQLException e) {
        isInitialized = false;
    }

    if (isInitialized) {
        System.out.println("============================================");
        System.out.println("Apiman Manager database already initialized.");
        System.out.println("============================================");
        return;
    }

    ClassLoader cl = JpaStorageInitializer.class.getClassLoader();
    URL resource = cl.getResource("ddls/apiman_" + dbType + ".ddl");
    try (InputStream is = resource.openStream()) {
        System.out.println("=======================================");
        System.out.println("Initializing apiman Manager database.");
        DdlParser ddlParser = new DdlParser();
        List<String> statements = ddlParser.parse(is);
        for (String sql : statements) {
            System.out.println(sql);
            run.update(sql);
        }
        System.out.println("=======================================");
    } catch (Exception e) {
        throw new RuntimeException(e);
    }
}

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

@Override
public void update(String envId, EnvironBean bean) throws Exception {
    SetClause setClause = bean.genSetClause();
    String clause = String.format(UPDATE_ENV_BY_ID_TEMPLATE, setClause.getClause());
    setClause.addValue(envId);//w ww.  j  a v  a  2 s.c  om
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}