Example usage for org.apache.commons.dbutils BasicRowProcessor BasicRowProcessor

Introduction

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

Prototype

public BasicRowProcessor() 

Source Link

Document

BasicRowProcessor constructor.

Usage

From source file:gr.osmosis.rcpsamples.contact.db.derby.DerbyContactsDAO.java

public Contact[] selectContacts(int id) {
    // Create Query
    // and where statement
    String whereStatement = "";
    if (id > -1) {
        whereStatement = " WHERE ID = " + id;
    }//  ww w.  j  a v  a 2s.c  om

    StringBuffer sbSelect = new StringBuffer();
    sbSelect.append("SELECT * ");
    sbSelect.append(" FROM ");
    sbSelect.append(ContactsConstants.CONTACTS_TABLE_NAME);
    sbSelect.append(whereStatement);

    // Create a QueryRunner that will use connections from
    // the given DataSource
    DataSource d = DerbyDAOFactory.getDataSource();
    QueryRunner run = new QueryRunner(d);

    ResultSetHandler h = new ResultSetHandler() {
        public Object handle(ResultSet rs) throws SQLException {

            BasicRowProcessor p = new BasicRowProcessor();

            List l = p.toBeanList(rs, Contact.class);

            return l;
        }
    };
    Object result;
    ArrayList list;
    Contact[] c = null;
    try {
        result = run.query(sbSelect.toString(), h);

        list = (ArrayList) result;

        c = new Contact[list.toArray().length];
        list.toArray(c);

        System.out.print(result.toString());

    } catch (SQLException sex) {
        sex.printStackTrace();
    } catch (Exception ex) {
        ex.printStackTrace();
    }

    return c;
}

---

From source file:com.splicemachine.homeless.TestUtils.java

public static List<Map> resultSetToMaps(ResultSet rs) throws SQLException {

    List<Map> results = new ArrayList<>();
    BasicRowProcessor brp = new BasicRowProcessor();

    while (rs.next()) {
        results.add(brp.toMap(rs));//  www .jav  a2  s .c om
    }

    return results;
}

---

From source file:com.splicemachine.homeless.TestUtils.java

public static List<Object[]> resultSetToArrays(ResultSet rs) throws SQLException {
    List<Object[]> results = new ArrayList<>();
    BasicRowProcessor brp = new BasicRowProcessor();

    while (rs.next()) {
        results.add(brp.toArray(rs));/*from w  w w  . ja v  a2  s. c om*/
    }

    return results;
}

---

From source file:com.versatus.jwebshield.securitylock.SecurityLockService.java

private SecurityLock checkSecurityLock(int userId, String ip) throws SQLException {

    logger.debug("checkAccountLock: userid=" + userId);
    logger.debug("checkAccountLock: ip=" + ip);

    SecurityLock res;// w  w w  .  ja  v a2  s .  co  m
    Object[] params = new Object[] { userId, ip };

    QueryRunner run = new QueryRunner();
    Connection conn = dbHelper.getConnection();
    BeanHandler<SecurityLock> rsh = new BeanHandler(SecurityLock.class) {

        @Override
        public SecurityLock handle(ResultSet rs) throws SQLException {
            SecurityLock brp = null;
            if (rs.first()) {
                brp = new BasicRowProcessor().toBean(rs, SecurityLock.class);
            }
            return brp;
        }
    };

    try {

        res = run.query(conn, lockCheckSql, rsh, params);

        logger.debug("checkAccountLock: response=" + res);

        if (res != null) {
            if (res.isLock()) {
                logger.debug("checkAccountLock: Calendar.getInstance()=" + Calendar.getInstance().getTime());
                logger.debug("checkAccountLock: TimeWhenUnlock()=" + res.getTimeWhenUnlock());
                logger.debug("checkAccountLock: is time to ulock="
                        + Calendar.getInstance().getTime().after(res.getTimeWhenUnlock()));
                if (Calendar.getInstance().getTime().after(res.getTimeWhenUnlock())) {
                    logger.info("unlocking IP " + res.getIp());
                    int r = run.update(conn, resetLockSql, new Object[] { ip });

                    logger.debug("checkAccountLock: reset response=" + r);

                    res = run.query(conn, lockCheckSql, rsh, params);

                    logger.debug("checkAccountLock: after reset response=" + res);
                }
            }

        } else {
            res = new SecurityLock();
            res.setLock(false);
        }

    } finally {

        try {
            DbUtils.close(conn);
        } catch (SQLException e) {
            // ignore
        }
    }

    return res;
}

---

From source file:com.mirth.connect.connectors.jdbc.DatabaseReceiver.java

/**
 * For each record in the given ResultSet, convert it to XML and dispatch it as a raw message to
 * the channel. Then run the post-process if applicable.
 *///  ww w.  ja v a2 s  .  c om
@SuppressWarnings("unchecked")
private void processResultSet(ResultSet resultSet)
        throws SQLException, InterruptedException, DatabaseReceiverException {
    BasicRowProcessor basicRowProcessor = new BasicRowProcessor();

    // loop through the ResultSet rows and convert them into hash maps for processing
    while (resultSet.next()) {
        if (isTerminated()) {
            return;
        }

        processRecord((Map<String, Object>) basicRowProcessor.toMap(resultSet));
    }
}

---

From source file:wzw.sql.ResultSetConverter.java

/**
 * Zconvert a ResultSet to Array./* w w  w  .  ja  v a  2  s  . c om*/
 * @param rs
 * @return
 * @throws java.sql.SQLException
 */
public static java.lang.Object[] toArray(java.sql.ResultSet rs) throws java.sql.SQLException {
    BasicRowProcessor brp = new BasicRowProcessor();
    return brp.toArray(rs);

}

---