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.arcee.db.DBNewInstanceReportDAOImpl.java

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

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

@Override
public List<RatingBean> getRatingsInfos(int pageIndex, int pageSize) throws Exception {
    ResultSetHandler<List<RatingBean>> h = new BeanListHandler<RatingBean>(RatingBean.class);
    QueryRunner run = new QueryRunner(this.dataSource);
    return run.query(GET_RATINGS, h, (pageIndex - 1) * pageSize, pageSize);
}

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

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

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

@Override
public void deleteAsgLifecycleEventById(String tokenId) throws Exception {
    new QueryRunner(dataSource).update(DELETE_ASG_LIFE_CYCLE_EVENT_BY_ID, tokenId);
}

From source file:com.fluke.database.dataservice.EODDao.java

public void deleteLastData() {
    try {//from w ww .  j a v a2 s .com
        String sql = "  delete from EOD where date =  (select maxD from (select max(date) as maxD from EOD as x) as y) ;";
        QueryRunner run = new QueryRunner(DatabaseProperty.getDataSource());
        run.update(sql);
    } catch (SQLException ex) {
        Logger.getLogger(EODDao.class.getName()).log(Level.SEVERE, null, ex);
    }

}

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

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

From source file:com.pinterest.clusterservice.db.DBPlacementDAOImpl.java

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

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

public void insert(TagBean tagInfo) throws Exception {
    SetClause setClause = tagInfo.genSetClause();
    String clause = String.format(INSERT_TAG_TEMPLATE, setClause.getClause());
    new QueryRunner(basicDataSource).update(clause, setClause.getValueArray());
}

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

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

From source file:io.apiman.gateway.engine.jdbc.JdbcInitializer.java

/**
 * Do the initialization work.// w w  w . java2s.  c om
 */
@SuppressWarnings("nls")
private void doInit() {
    QueryRunner run = new QueryRunner(ds);
    Boolean isInitialized;

    try {
        isInitialized = run.query("SELECT * FROM gw_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 Gateway database already initialized.");
        System.out.println("============================================");
        return;
    }

    ClassLoader cl = JdbcInitializer.class.getClassLoader();
    URL resource = cl.getResource("ddls/apiman-gateway_" + dbType + ".ddl");
    try (InputStream is = resource.openStream()) {
        System.out.println("=======================================");
        System.out.println("Initializing apiman Gateway 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);
    }
}