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:azkaban.database.AzkabanDatabaseUpdaterTest.java

private static void clearMySQLTestDb() throws SQLException {
    Props props = new Props();

    props.put("database.type", "mysql");
    props.put("mysql.host", "localhost");
    props.put("mysql.port", "3306");
    props.put("mysql.database", "");
    props.put("mysql.user", "root");
    props.put("mysql.password", "");
    props.put("mysql.numconnections", 10);

    DataSource datasource = DataSourceUtils.getDataSource(props);
    QueryRunner runner = new QueryRunner(datasource);
    try {//w ww.  jav  a2 s  .co  m
        runner.update("drop database azkabanunittest");
    } catch (SQLException e) {
    }
    runner.update("create database azkabanunittest");
}

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

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

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

public int insertTicker(String equity, Ticker ticker, String grade, String exchange) throws SQLException {
    String sql = "insert into ticker (equity,openPrice,closePrice,highPrice,lowPrice,adjustedClose,volume,date,grade,exchange) values(?,?,?,?,?,?,?,?,?,?)";
    String date = Util.getDate(ticker.getDate());
    Object[] params = new Object[] { equity, ticker.getOpenPrice(), ticker.getClosePrice(),
            ticker.getHighPrice(), ticker.getLowPrice(), ticker.getAdjustedClose(), ticker.getVolume(), date,
            grade, exchange };/*from   w w  w.ja  va 2s  .c  o m*/
    QueryRunner run = new QueryRunner(DataSourceFactory.getDataSource());
    int updates = run.update(sql, params);
    run.update("delete from ticker where volume=0");
    return updates;
}

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

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

From source file:de.iritgo.aktario.jdbc.Select.java

/**
 * Perform the command.//from www .j  ava2s .  co  m
 */
public void perform() {
    if (properties.get("handler") == null) {
        Log.logError("persist", "Select", "Missing result set handler");

        return;
    }

    ResultSetHandler resultSetHandler = (ResultSetHandler) properties.get("handler");

    if (properties.get("select") == null) {
        Log.logError("persist", "Select", "Missing select statement");

        return;
    }

    String select = (String) properties.getProperty("select");

    Object[] params = (Object[]) properties.get("params");

    JDBCManager jdbcManager = (JDBCManager) Engine.instance().getManager("persist.JDBCManager");
    DataSource dataSource = jdbcManager.getDefaultDataSource();

    try {
        QueryRunner query = new QueryRunner(dataSource);

        Object res;

        if (params != null) {
            res = query.query(select, params, resultSetHandler);
        } else {
            res = query.query(select, resultSetHandler);
        }

        Log.logVerbose("persist", "Select", "SELECT |" + select + "|");
    } catch (Exception x) {
        Log.logError("persist", "Select", "Error while executing sql |" + select + "|: " + x);
    }
}

From source file:example.unittest.ExampleDbUnitTest.java

@Test
public void exampleTest() throws Exception {
    // load your data
    loadData(ds);/* w w  w .j  a v  a  2s . co  m*/

    // Now run your test once the setup is done
    QueryRunner jdbc = new QueryRunner(ds);

    List<Map<String, Object>> tableCResults = jdbc.query("select * from DYN_TABLE_C ORDER BY C_ID",
            new MapListHandler());
    System.out.println("Print DYN_TABLE_C for debug");
    for (Map<String, Object> result : tableCResults) {
        System.out.println("DYN_TABLE_C ROW: " + result);
    }
    assertEquals(5, tableCResults.size());
    assertTableCRow(tableCResults, 0, 1, 1, "row1", null);
    assertTableCRow(tableCResults, 1, 2, 2, "row  2", Timestamp.valueOf("2013-01-02 12:34:56"));
    assertTableCRow(tableCResults, 2, 3, 2, "", Timestamp.valueOf("2013-01-02 12:34:56.1"));
    assertTableCRow(tableCResults, 3, 4, 2, "  row  4  ", Timestamp.valueOf("2013-01-02 12:34:56.234"));
    assertTableCRow(tableCResults, 4, 5, 2, null, Timestamp.valueOf("2013-01-02 12:34:56.567891"));

    List<Map<String, Object>> tableDResults = jdbc.query("select * from DYN_TABLE_D ORDER BY D_ID",
            new MapListHandler());
    System.out.println("Print DYN_TABLE_D for debug");
    for (Map<String, Object> result : tableDResults) {
        System.out.println("DYN_TABLE_D ROW: " + result);
    }
    assertEquals(3, tableDResults.size());
    assertTableDRow(tableDResults, 0, 1);
    assertTableDRow(tableDResults, 1, 2);
    assertTableDRow(tableDResults, 2, 3);
}

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

@Override
public void update(ScheduleBean scheduleBean, String scheduleId) throws Exception {
    SetClause setClause = scheduleBean.genSetClause();
    String clause = String.format(UPDATE_SCHEDULE, setClause.getClause());
    setClause.addValue(scheduleId);//  www  .  java  2  s  .  c  o m
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

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

@Override
public void delete(String clusterName) throws Exception {
    new QueryRunner(dataSource).update(DELETE_CLUSTER_CONFIG, clusterName);
}

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

@Before
public void reset() throws SQLException {
    QueryRunner run = new QueryRunner(ds);
    run.update("DELETE FROM gw_requests");
}

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

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