Example usage for org.apache.commons.dbutils.handlers MapHandler MapHandler

List of usage examples for org.apache.commons.dbutils.handlers MapHandler MapHandler

  1. HOME
  2. Java
  3. org.apache.commons
  4. org.apache.commons.dbutils.handlers.*
  5. MapHandler
  6. MapHandler

Introduction

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

Prototype

public MapHandler()

Source Link

Document

Creates a new instance of MapHandler using a BasicRowProcessor for conversion.

Usage

From source file:com.ruihu.easyshop.book.dao.BookDao.java

/**
 * Search by Bid//  w w w . j av a  2 s . c o  m
 * @param bid
 * @return
 * @throws SQLException 
 */
public Book findByBid(String bid) throws SQLException {
    String sql = "select * from t_book where bid=?";
    Map<String, Object> map = qr.query(sql, new MapHandler(), bid);
    Book book = CommonUtils.toBean(map, Book.class);
    Category category = CommonUtils.toBean(map, Category.class);
    book.setCategory(category);
    return book;
}

From source file:com.ruihu.easyshop.cart.dao.CartItemDao.java

public CartItem findByCartItemId(String cartItemId) throws SQLException {
    String sql = "select * from t_cartItem c, t_book b where c.bid=b.bid and c.cartItemId=?";
    Map<String, Object> map = qr.query(sql, new MapHandler(), cartItemId);
    return toCartItem(map);
}

From source file:com.ruihu.easyshop.cart.dao.CartItemDao.java

public CartItem findByUidAndBid(String uid, String bid) throws SQLException {
    String sql = "select * from t_cartitem where uid=? and bid=?";
    Map<String, Object> map = qr.query(sql, new MapHandler(), uid, bid);
    CartItem cartItem = toCartItem(map);
    return cartItem;

}

From source file:com.gs.obevo.db.impl.core.jdbc.JdbcHelper.java

public MutableMap<String, Object> queryForMap(Connection conn, String sql) {
    return MapAdapter.adapt(this.query(conn, sql, new MapHandler()));
}

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

public UMOMessage receive(UMOEndpointURI endpointUri, long timeout) throws Exception {
    if (logger.isDebugEnabled()) {
        logger.debug("Trying to receive a message with a timeout of " + timeout);
    }/* www.  jav  a  2 s  . c  om*/

    String[] stmts = this.connector.getReadAndAckStatements(endpointUri, null);
    String readStmt = stmts[0];
    String ackStmt = stmts[1];
    List<String> readParams = new ArrayList<String>();
    List<String> ackParams = new ArrayList<String>();
    readStmt = JdbcUtils.parseStatement(readStmt, readParams);
    ackStmt = JdbcUtils.parseStatement(ackStmt, ackParams);

    Connection connection = null;
    long t0 = System.currentTimeMillis();

    try {
        connection = connector.getConnection(null);

        if (timeout < 0) {
            timeout = Long.MAX_VALUE;
        }

        Object result = null;

        do {
            result = new QueryRunner().query(connection, readStmt, new MapHandler(),
                    JdbcUtils.getParams(endpointUri, readParams, null));

            if (result != null) {
                if (logger.isDebugEnabled()) {
                    logger.debug("Received: " + result);
                }

                break;
            }

            long sleep = Math.min(this.connector.getPollingFrequency(),
                    timeout - (System.currentTimeMillis() - t0));

            if (sleep > 0) {
                if (logger.isDebugEnabled()) {
                    logger.debug("No results, sleeping for " + sleep);
                }

                Thread.sleep(sleep);
            } else {
                logger.debug("Timeout");
                return null;
            }
        } while (true);

        if (result != null && ackStmt != null) {
            int numRows = new QueryRunner().update(connection, ackStmt,
                    JdbcUtils.getParams(endpointUri, ackParams, result));

            if (numRows != 1) {
                logger.warn("Row count for ack should be 1 and not " + numRows);
            }
        }

        UMOMessageAdapter msgAdapter = this.connector.getMessageAdapter(result);
        UMOMessage message = new MuleMessage(msgAdapter);
        JdbcUtils.commitAndClose(connection);
        return message;
    } catch (Exception e) {
        JdbcUtils.rollbackAndClose(connection);
        throw e;
    }
}

From source file:com.eryansky.core.db.DbUtilsDao.java

/**
 * ???Map/*from w w  w  . j  a  v  a  2s  .c o m*/
 * 
 * @param sql
 *            sql?
 * @param params
 *            ?
 * @return ?Map
 */
public Map<String, Object> findFirst(String sql, Object[] params) throws DaoException {
    queryRunner = new QueryRunner(dataSource);
    Map<String, Object> map = null;
    try {
        if (params == null) {
            map = (Map<String, Object>) queryRunner.query(sql, new MapHandler());
        } else {
            map = (Map<String, Object>) queryRunner.query(sql, new MapHandler(), params);
        }
    } catch (SQLException e) {
        logger.error("Error occured while attempting to query data", e);
        throw new DaoException(e);
    }
    return map;
}

From source file:io.stallion.dataAccess.db.DB.java

/**
 * Find one record via arbitrary SQL and return it as a hashmap
 *
 * @param sql//from  www.  j a  v a2 s  .co m
 * @param args
 * @return
 */
public Map<String, Object> findRecord(String sql, Object... args) {
    QueryRunner runner = new QueryRunner(dataSource);
    MapHandler handler = new MapHandler();
    try {
        return runner.query(sql, handler, args);
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

From source file:dbutils.DbUtilsTemplate.java

/**
 * ???Map/*from  w w w .  j  a  v a  2s  .  c om*/
 *
 * @param sql    sql?
 * @param params ?
 * @return ?Map
 */
@SuppressWarnings("unchecked")
public Map<String, Object> findFirst(String sql, Object[] params) {
    queryRunner = new QueryRunner();
    Connection conn = null;
    Map<String, Object> map = null;
    try {
        conn = dataSource.getConnection();
        if (params == null) {
            map = queryRunner.query(conn, sql, new MapHandler());
        } else {
            map = queryRunner.query(conn, sql, new MapHandler(), params);
        }
    } catch (SQLException e) {
        LOG.error("Error occured while attempting to query data", e);
    } finally {
        if (conn != null) {
            DbUtils.closeQuietly(conn);
        }
    }
    return map;
}

From source file:de.tu_berlin.dima.oligos.db.JdbcConnector.java

public Map<String, Object> mapQuery(final String query, final Object... parameters) throws SQLException {
    ResultSetHandler<Map<String, Object>> handler = new MapHandler();
    QueryRunner runner = new QueryRunner();
    return runner.query(connection, query, handler, parameters);
}

From source file:com.iana.boesc.dao.BOESCDaoImpl.java

@Override
public GIERInfoDetails getDVIRAdditionaldetails(String eqPrefix, String eqNumber) throws Exception {

    QueryRunner run = new QueryRunner(getGierDataSource());
    logger.info("In getDVIRAdditionaldetails(" + eqPrefix + " , " + eqNumber + " )...");
    GIERInfoDetails gierInfo = new GIERInfoDetails();
    boolean errorFlag = false;

    String sql = "SELECT CurrentIEPCompanyId,ch_pool_id FROM Equipment WHERE EqPrefix = ? AND EqNumber = ?";
    Map<String, Object> eqDetailsMap = run.query(sql, new MapHandler(), new Object[] { eqPrefix, eqNumber });

    if (eqDetailsMap != null && eqDetailsMap.size() > 0) {
        if (!ValidationUtils.validateStringObject(eqDetailsMap.get("CurrentIEPCompanyId")).equals("")
                && !ValidationUtils.validateStringObject(eqDetailsMap.get("ch_pool_id")).equals("")) {
            String companyId = eqDetailsMap.get("CurrentIEPCompanyId").toString();
            String chassisPoolId = eqDetailsMap.get("ch_pool_id").toString();

            sql = "SELECT CompanySCACcd, USDOTNumber FROM Company WHERE CompanyId = ?";
            Map<String, Object> companyDetailsMap = run.query(sql, new MapHandler(),
                    new Object[] { companyId });

            if (companyDetailsMap != null && companyDetailsMap.size() > 0) {
                if (!ValidationUtils.validateStringObject(companyDetailsMap.get("CompanySCACcd")).equals("")
                        && !ValidationUtils.validateStringObject(companyDetailsMap.get("USDOTNumber"))
                                .equals("")) {
                    String scacCode = companyDetailsMap.get("CompanySCACcd").toString();
                    String usdotNumber = companyDetailsMap.get("USDOTNumber").toString();

                    sql = "SELECT CH_POOL_ID, CH_POOL_NAME FROM chassispool WHERE POOL_ID = ?";
                    Map<String, Object> poolDetailsMap = run.query(sql, new MapHandler(),
                            new Object[] { chassisPoolId });
                    if (poolDetailsMap != null && poolDetailsMap.size() > 0) {
                        if (!ValidationUtils.validateStringObject(poolDetailsMap.get("CH_POOL_ID")).equals("")
                                && !ValidationUtils.validateStringObject(poolDetailsMap.get("CH_POOL_NAME"))
                                        .equals("")) {
                            String ch_pool_id = poolDetailsMap.get("CH_POOL_ID").toString();
                            String ch_pool_name = poolDetailsMap.get("CH_POOL_NAME").toString();
                            gierInfo = setGIERDetails(ch_pool_id, ch_pool_name, scacCode, usdotNumber);

                        } else {
                            gierInfo = setGIERDetails("", "", scacCode, usdotNumber);
                        }/*from ww  w.  j av a 2  s .c om*/

                    } else {
                        gierInfo = setGIERDetails("", "", scacCode, usdotNumber);
                    }

                } else {
                    errorFlag = true;
                }
            } else {
                errorFlag = true;
            }
        } else {
            errorFlag = true;
        }
    } else {
        errorFlag = true;
    }

    if (errorFlag) {
        gierInfo = setGIERDetails("", "", "", "");
    }

    return gierInfo;
}