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.executor.JdbcExecutorLoaderTest.java

@BeforeClass
public static void setupDB() {
    DataSource dataSource = DataSourceUtils.getMySQLDataSource(host, port, database, user, password,
            numConnections);/*w  w  w .  j a  v  a  2 s.  c om*/
    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 active_executing_flows", countHandler);
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

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

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

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

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

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

    DbUtils.closeQuietly(connection);
}

From source file:com.example.data.StoreData.java

public Map<String, Object> findOrderById(long orderId) throws SQLException {
    QueryRunner run = new QueryRunner(H2DB.getDataSource());

    return run
            .query("select * from order where id=?",
                    H2DB.mkResultSetHandler("id", "petId", "quantity", "shipDate", "status"), orderId)
            .stream().findFirst().orElse(null);
}

From source file:com.example.data.UserData.java

public Map<String, Object> findUserByName(String username) throws SQLException {
    QueryRunner run = new QueryRunner(H2DB.getDataSource());

    return run.query(
            "select id, user_name, first_name, last_name, email, phone, status from user where user_name=?",
            H2DB.mkResultSetHandler("id", "username", "firstName", "lastName", "email", "phone", "status"),
            username).stream().findFirst().orElse(null);
}

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

@Override
public List<RatingBean> getRatingsByAuthor(String author) throws Exception {
    ResultSetHandler<List<RatingBean>> h = new BeanListHandler<RatingBean>(RatingBean.class);
    QueryRunner run = new QueryRunner(this.dataSource);
    return run.query(GET_USER_RATINGS, h, author);
}

From source file:iudex.da.ContentReader.java

public List<UniMap> select(String query, Object... params) throws SQLException {
    QueryRunner runner = new QueryRunner(_dsource);

    return runner.query(query, new MapHandler(), params);
}

From source file:cn.itcast.bbs.dao.AdminDao.java

public Admin findAdminByType(String title) throws SQLException {
    QueryRunner runner = new QueryRunner(JdbcUtil.getDataSource());
    String sql = "select *from admin where title = ?";
    Admin admin = runner.query(sql, new BeanHandler(Admin.class), title);
    return admin;
}

From source file:jp.co.golorp.emarf.model.Models.java

/**
 * IO/*from  w w w  .  j a va2  s .  c om*/
 *
 * @param <T>
 *            ??
 * @param sql
 *            sql
 * @param rsh
 *            ResultSetHandler
 * @param params
 *            
 * @return ????
 */
@SuppressWarnings("unchecked")
private static <T> T query(final String sql, final ResultSetHandler<?> rsh, final Object... params) {

    String rawSql = getRawSql(sql, params);

    T result = (T) ModelsCache.get(rawSql);
    if (result != null) {
        return result;
    }

    statementLog(rawSql);

    QueryRunner runner = new QueryRunner();

    Connection cn = Connections.get();

    try {

        if (params == null || params.length == 0) {
            result = (T) runner.query(cn, sql, rsh);
        } else {
            result = (T) runner.query(cn, sql, rsh, params);
        }

        ModelsCache.set(rawSql, result);

        return result;

    } catch (Exception e) {
        throw new SystemError(e);
    }

}

From source file:com.gs.obevo.dbmetadata.impl.dialects.HsqlMetadataDialect.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 dom.DOMAIN_NAME AS USER_TYPE_NAME\n" + "from INFORMATION_SCHEMA.DOMAINS dom\n"
                    + "WHERE dom.DOMAIN_SCHEMA = ucase('" + schema.getName() + "')\n",
            new MapListHandler())).toImmutable();

    return maps.collect(new Function<Map<String, Object>, DaUserType>() {
        @Override//from  w  w w .j  av a2  s. co  m
        public DaUserType valueOf(Map<String, Object> map) {
            return new DaUserTypeImpl((String) map.get("USER_TYPE_NAME"), schema);
        }
    });
}

From source file:com.example.data.PetData.java

public Map<String, Object> getPetById(long petId) throws SQLException {
    QueryRunner run = new QueryRunner(H2DB.getDataSource());

    return run
            .query("select * from pet where id=?",
                    H2DB.mkResultSetHandler("id", "name", "categoryId", "photoUrls", "tags", "status"), petId)
            .stream().map(m -> {/*from  ww  w .  ja  va  2  s. com*/
                m.put("photoUrls", H2DB.strToList((String) m.get("photoUrls")));
                m.put("tags", H2DB.strToList((String) m.get("tags")));
                m.put("category", getCategory(run, (Long) m.get("categoryId")));
                m.remove("categoryId");
                return m;
            }).findFirst().orElse(null);
}

From source file:cn.itcast.bbs.dao.FlowDao.java

public Flow showFlow(Date date) throws SQLException {
    QueryRunner runner = new QueryRunner(JdbcUtil.getDataSource());
    String sql = "select *from flow where historydate = ?";
    Flow flow = runner.query(sql, new BeanHandler(Flow.class), new java.sql.Date(date.getTime()));
    return flow;/*from   w ww.  j  a v  a2 s  .  com*/
}