Example usage for org.apache.commons.dbutils QueryRunner query

Introduction

In this page you can find the example usage for org.apache.commons.dbutils QueryRunner query.

Prototype

public <T> T query(String sql, ResultSetHandler<T> rsh) throws SQLException 

Source Link

Document

Executes the given SELECT SQL without any replacement parameters.

Usage

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

public List<String> getAllEquity(String grade) throws SQLException {
    String sql = "select distinct equity from EOD";
    QueryRunner run = new QueryRunner(DatabaseProperty.getDataSource());
    ResultSetHandler rsh = new ColumnListHandler();
    return (List<String>) run.query(sql, rsh);
}

---

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

public List<String> getAllEquity() throws SQLException {
    String sql = "select distinct equity from EOD";
    QueryRunner run = new QueryRunner(DataSourceFactory.getDataSource());
    ResultSetHandler rsh = new ColumnListHandler();
    return (List<String>) run.query(sql, rsh);
}

---

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

public List<String> getAllEquity(String grade) throws SQLException {
    String sql = "select distinct equity from EOD where grade='" + grade + "'";
    QueryRunner run = new QueryRunner(DataSourceFactory.getDataSource());
    ResultSetHandler rsh = new ColumnListHandler();
    return (List<String>) run.query(sql, rsh);
}

---

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

public Date getLastTickerDetails(String equity) throws SQLException {
    String sql = " select cast(max(date) as date) from EOD  where equity='" + equity + "'";
    QueryRunner run = new QueryRunner(DatabaseProperty.getDataSource());
    ResultSetHandler rsh = new ArrayHandler();
    Object[] query = (Object[]) run.query(sql, rsh);
    if (query == null || query.length == 0) {
        return null;
    }/*from ww w.j a va2s . co m*/
    return (Date) query[0];
}

---

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

public Date getLastTickerDetails(String equity) throws SQLException {
    String sql = " select cast(max(date) as date) from EOD  where equity='" + equity + "'";
    QueryRunner run = new QueryRunner(DataSourceFactory.getDataSource());
    ResultSetHandler rsh = new ArrayHandler();
    Object[] query = (Object[]) run.query(sql, rsh);
    if (query == null || query.length == 0) {
        return null;
    }/*from  ww  w .  ja  v a2  s  .c  o m*/
    return (Date) query[0];
}

---

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

@Override
public List<String> getAllBuildNames() throws Exception {
    QueryRunner run = new QueryRunner(this.dataSource);
    return run.query(GET_ALL_BUILD_NAMES, SingleResultSetHandlerFactory.<String>newListObjectHandler());
}

---

From source file:example.unittest.ExampleDbUnitTest.java

@Test
public void exampleTest() throws Exception {
    // load your data
    loadData(ds);//from   ww  w  .  j  a  v  a2s. c o 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:io.apiman.gateway.engine.jdbc.JdbcInitializer.java

/**
 * Do the initialization work./*from  ww w. ja  v  a  2 s .  co  m*/
 */
@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);
    }
}

---

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

public Date getNextTradingDay(String date) throws SQLException {
    String sql = "select cast(min(date) as date) from intraday where date > '" + date + "'";
    QueryRunner run = new QueryRunner(DatabaseProperty.getDataSource());
    ResultSetHandler rsh = new ArrayHandler();
    Object[] query = (Object[]) run.query(sql, rsh);
    if (query == null || query.length == 0) {
        return null;
    }/*from w ww.  j  ava  2  s  .  c  o m*/
    return (java.sql.Date) query[0];
}

---

From source file:com.fluke.data.processor.ReatimeDBReader.java

public List<String> getAllEquity() throws SQLException {
    String sql = "select distinct equity from realtime";
    QueryRunner run = new QueryRunner(DatabaseProperty.getDataSource());
    ResultSetHandler rsh = new ColumnListHandler();
    return (List<String>) run.query(sql, rsh);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• »