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.fluke.database.dataservice.IntraDayDao.java

public void insert(IntradayDetails data) {
    QueryRunner runner = new QueryRunner(DatabaseProperty.getDataSource());
    try {/*from  ww w .  java  2  s  .c om*/
        List<Series> values = data.getSeries();
        String id = data.getMeta().getId().toUpperCase();
        addValues(runner, values, id);
    } catch (SQLException ex) {
        throw new RuntimeException(ex);
    }
}

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

@Override
public ConfigHistoryBean getByChangeId(String changeId) throws Exception {
    ResultSetHandler<ConfigHistoryBean> h = new BeanHandler<>(ConfigHistoryBean.class);
    return new QueryRunner(dataSource).query(GET_BY_CHANGE_ID, h, changeId);
}

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

@Override
public void deleteGroupMapping(String asgGroupName) throws Exception {
    new QueryRunner(dataSource).update(DELTE_GROUP_MAPPING, asgGroupName);
}

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

@Override
public ClusterBean getByClusterName(String clusterName) throws Exception {
    ResultSetHandler<ClusterBean> h = new BeanHandler<ClusterBean>(ClusterBean.class);
    return new QueryRunner(dataSource).query(GET_CLUSTER_CONFIG, h, clusterName);
}

From source file:com.rhino.data.db.TickerDao.java

public int deleteTicker(String equity) throws SQLException {
    String sql = "delete from ticker where equity=?";
    QueryRunner run = new QueryRunner(DataSourceFactory.getDataSource());
    return run.update(sql, equity);
}

From source file:com.dianping.puma.parser.meta.DefaultTableMetaInfoFetcher.java

protected TableMetaInfo _refreshTableMeta(final String database, final String table) throws SQLException {
    initDsIfNeeded();// www.j a v a  2  s.  c  om

    QueryRunner runner = new QueryRunner(metaDs);

    Transaction t = Cat.newTransaction("SQL.meta", getKey(database, table));
    try {
        TableMetaInfo tableMetaInfo = runner.query(genTableMetaSql(database, table),
                new ResultSetHandler<TableMetaInfo>() {
                    @Override
                    public TableMetaInfo handle(ResultSet rs) throws SQLException {
                        TableMetaInfo result = new TableMetaInfo();
                        result.setDatabase(database);
                        result.setTable(table);
                        result.setColumns(new HashMap<Integer, String>());
                        result.setKeys(new ArrayList<String>());
                        result.setTypes(new HashMap<String, String>());
                        result.setSignedInfos(new HashMap<Integer, Boolean>());

                        while (rs.next()) {
                            int i = rs.getRow();
                            String column = rs.getString("Field");

                            result.getColumns().put(i, column);

                            if (rs.getString("Type").contains("unsigned")) {
                                result.getSignedInfos().put(i, false);
                            } else {
                                result.getSignedInfos().put(i, true);
                            }

                            if (rs.getString("Key").equalsIgnoreCase("pri")) {
                                result.getKeys().add(column);
                            }
                        }

                        return result;
                    }
                });

        t.setStatus("0");
        return tableMetaInfo;
    } catch (SQLException e) {
        t.setStatus("1");
        throw e;
    } finally {
        t.complete();
    }
}

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

@Override
public Collection<HostTypeBean> getByProviderAndBasic(String provider, boolean basic) throws Exception {
    ResultSetHandler<List<HostTypeBean>> h = new BeanListHandler<HostTypeBean>(HostTypeBean.class);
    return new QueryRunner(dataSource).query(GET_BY_PROVIDER_AND_BASIC, h, provider, basic);
}

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

@Override
public Collection<BaseImageBean> getByProviderAndBasic(String provider, boolean basic) throws Exception {
    ResultSetHandler<List<BaseImageBean>> h = new BeanListHandler<BaseImageBean>(BaseImageBean.class);
    return new QueryRunner(dataSource).query(GET_BY_PROVIDER_AND_BASIC, h, provider, basic);
}

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

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

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

@Override
public Collection<PlacementBean> getByProviderAndBasic(String provider, boolean basic) throws Exception {
    ResultSetHandler<List<PlacementBean>> h = new BeanListHandler<PlacementBean>(PlacementBean.class);
    return new QueryRunner(dataSource).query(GET_BY_PROVIDER_AND_BASIC, h, provider, basic);
}