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, Object... params) throws SQLException 

Source Link

Document

Executes the given SELECT SQL query and returns a result object.

Usage

From source file:azkaban.trigger.JdbcTriggerLoaderTest.java

public void setupDB() {
    DataSource dataSource = DataSourceUtils.getMySQLDataSource(host, port, database, user, password,
            numConnections);/*from   w w w .j a  v a 2  s . c  o  m*/
    testDBExists = true;

    Connection connection = null;
    try {
        connection = dataSource.getConnection();
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

    CountHandler countHandler = new CountHandler();
    QueryRunner runner = new QueryRunner();
    try {
        runner.query(connection, "SELECT COUNT(1) FROM triggers", countHandler);
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

    DbUtils.closeQuietly(connection);

    clearDB();
}

---

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

/**
 * Asserts the row count of the given query.
 * @param count//from   ww w  .j a v  a 2 s.  c o m
 * @param query
 * @param params
 * @throws SQLException 
 */
private void assertRowCount(int count, String query, Object... params) throws SQLException {
    QueryRunner run = new QueryRunner(ds);
    int actualCount = run.query(query, COUNT_HANDLER, params);
    Assert.assertEquals(count, actualCount);
}

---

From source file:com.gs.obevo.dbmetadata.impl.dialects.MsSqlMetadataDialect.java

@Override
public ImmutableCollection<DaUserType> searchUserTypes(final DaSchema schema, Connection conn)
        throws SQLException {
    QueryRunner query = new QueryRunner();

    ImmutableList<Map<String, Object>> maps = ListAdapter
            .adapt(query.query(conn,
                    "SELECT DOMAIN_NAME as USER_TYPE_NAME " + "FROM INFORMATION_SCHEMA.DOMAINS "
                            + "WHERE DOMAIN_CATALOG = '" + schema.getName() + "'",
                    new MapListHandler()))
            .toImmutable();/*www  .j a v  a  2  s.co  m*/

    return maps.collect(new Function<Map<String, Object>, DaUserType>() {
        @Override
        public DaUserType valueOf(Map<String, Object> map) {
            return new DaUserTypeImpl((String) map.get("USER_TYPE_NAME"), schema);
        }
    });
}

---

From source file:com.odap.server.scheduler.JobManager.java

public synchronized List<Map<String, String>> refreshJobs() {

    logger.info("Entering refreshJobs()");

    try {/* www.  jav  a2s  . c  o  m*/
        QueryRunner qRunner = new QueryRunner();

        List<Map<String, Object>> mapList = (List<Map<String, Object>>) qRunner.query(conn,
                "SELECT jobs.*, servers.account_id,servers.server_name FROM jobs,servers where servers.id = jobs.server_id",
                new MapListHandler());

        processJobs(mapList);

    } catch (Exception e) {
        System.err.println("Cannot connect to database server");
        e.printStackTrace();
    }

    logger.info("Exiting refreshJobs()");
    return null;
}

---

From source file:com.geaviation.controller.LoginController.java

protected ModelAndView handleRequestInternal(HttpServletRequest request, HttpServletResponse response)
        throws Exception {
    ModelAndView mv = new ModelAndView();

    DataSource ds = (DataSource) this.getApplicationContext().getBean("myDataSource");

    try {/* w ww  .  j  a v  a  2  s  .com*/

        String username = request.getParameter("username");
        String password = request.getParameter("password");
        //String status = "FAILURE";

        QueryRunner run = new QueryRunner(ds);
        ResultSetHandler<UsersBean> user = new BeanHandler<UsersBean>(UsersBean.class);
        Object[] params = new Object[2];
        params[0] = username;
        params[1] = password;
        UsersBean ub = run.query("select * from user_account where UNAME =? and UPASSWORD =?", user, params);
        if (ub != null) {

            mv.addObject("username", username);
            mv.setViewName("home");
        } else {
            mv.addObject("error", "true");
            mv.setViewName("index");

        }

    } catch (Exception e) {

        e.printStackTrace();
    }

    return mv;
}

---

From source file:com.gs.obevo.dbmetadata.impl.dialects.Db2MetadataDialect.java

@Override
public ImmutableCollection<DaSequence> searchSequences(final DaSchema schema, Connection conn)
        throws SQLException {
    QueryRunner query = new QueryRunner();

    // SEQTYPE <> 'I' is for identity columns; we don't want that when pulling user defined sequences
    ImmutableList<Map<String, Object>> maps = ListAdapter
            .adapt(query
                    .query(conn,//from   w ww .java  2 s  .  com
                            "select SEQNAME SEQUENCE_NAME from syscat.SEQUENCES\n" + "where SEQSCHEMA = '"
                                    + schema.getName() + "' AND SEQTYPE <> 'I'\n",
                            new MapListHandler()))
            .toImmutable();

    return maps.collect(new Function<Map<String, Object>, DaSequence>() {
        @Override
        public DaSequence valueOf(Map<String, Object> map) {
            return new DaSequenceImpl((String) map.get("SEQUENCE_NAME"), schema);
        }
    });
}

---

From source file:com.softberries.klerk.dao.AddressDao.java

public List<Address> findAll(QueryRunner run, Connection conn) throws SQLException {
    List<Address> companies = new ArrayList<Address>();
    ResultSetHandler<List<Address>> h = new BeanListHandler<Address>(Address.class);
    companies = run.query(conn, SQL_FIND_ADDRESS_ALL, h);
    return companies;
}

---

From source file:jp.gr.java_conf.ka_ka_xyz.processor.AnnotationProcessorFieldAccessTest.java

@Test
public void testBindPersonAccessByFieldAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new AnnotationProcessor(Person.class));
    ResultSetHandler<List<Person>> prsh = new BeanListHandler<Person>(Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());/*from   ww w .  ja  v  a2s. c  o  m*/
    assertEquals(new Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Person(3, "Robert", "Bloch"), persons.get(2));

}

---

From source file:jp.gr.java_conf.ka_ka_xyz.processor.AnnotationProcessorPropertyAccessTest.java

@Test
public void testBindPersonByPropertyAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new AnnotationProcessor(Person.class));
    ResultSetHandler<List<Person>> prsh = new BeanListHandler<Person>(Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());// www .ja va 2  s  .c  o m
    assertEquals(new Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Person(3, "Robert", "Bloch"), persons.get(2));

}

---

From source file:info.pancancer.arch3.persistence.PostgreSQL.java

private <T> T runSelectStatement(String query, ResultSetHandler<T> handler, Object... params) {
    try {//  w  ww  . j  av a 2  s  .c om
        QueryRunner run = new QueryRunner(dataSource);
        return run.query(query, handler, params);
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• »