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

Introduction

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

Prototype

public BeanHandler(Class<T> type, RowProcessor convert) 

Source Link

Document

Creates a new instance of BeanHandler.

Usage

From source file:com.demo.db.dao.impl.DriverDaoImpl.java

@Override
public Driver get(Long id) {
    QueryRunner queryRunner = dbHelper.getRunner();
    Driver driver = null;/*w  w w .j  ava 2  s.  com*/
    try {
        BeanProcessor beanProcessor = new GenerousBeanProcessor();
        RowProcessor rowProcessor = new BasicRowProcessor(beanProcessor);
        driver = queryRunner.query("select " + DRIVER_COLUMN_STRING + " from demo_driver where id = ? limit 1",
                new BeanHandler<Driver>(Driver.class, rowProcessor), id);
    } catch (SQLException e) {
        String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();
        LOGGER.error("{}??{}", methodName, id);
        throw new RuntimeException(e);
    }
    return driver;
}

---

From source file:com.demo.admin.dao.impl.AdminDriverDaoImpl.java

@Override
public Driver getDriverById(Long id) {
    QueryRunner queryRunner = dbHelper.getRunner();
    Driver driver = null;/*from   w  ww .  j a  v  a2  s.  c  o m*/
    BeanProcessor beanProcessor = new GenerousBeanProcessor();
    RowProcessor rowProcessor = new BasicRowProcessor(beanProcessor);
    try {
        driver = queryRunner.query("select * from demo_driver where id=? limit 1",
                new BeanHandler<Driver>(Driver.class, rowProcessor), id);
    } catch (SQLException e) {
        String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();
        logger.error("{}??{},{}", methodName, id);
        throw new RuntimeException(e);
    }
    return driver;
}

---

From source file:com.demo.db.dao.impl.DriverDaoImpl.java

@Override
public Driver get(String cell) {
    QueryRunner queryRunner = dbHelper.getRunner();
    Driver driver = null;// w  w  w. j  a  v  a2s  .  c om
    try {
        BeanProcessor beanProcessor = new GenerousBeanProcessor();
        RowProcessor rowProcessor = new BasicRowProcessor(beanProcessor);
        driver = queryRunner.query(
                "select " + DRIVER_COLUMN_STRING + " from demo_driver where cell = ? limit 1",
                new BeanHandler<Driver>(Driver.class, rowProcessor), cell);
    } catch (SQLException e) {
        String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();
        LOGGER.error("{}??{}", methodName, cell);
        throw new RuntimeException(e);
    }
    return driver;
}

---

From source file:com.demo.db.dao.impl.DriverAuditDaoImpl.java

@Override
public DriverAudit getByDriverId(Long driverId) {
    QueryRunner queryRunner = dbHelper.getRunner();

    DriverAudit driverAudit = null;//from  w ww  .  j a v a  2  s .  co m
    BeanProcessor beanProcessor = new GenerousBeanProcessor();
    RowProcessor rowProcessor = new BasicRowProcessor(beanProcessor);
    try {
        driverAudit = queryRunner.query("select * from demo_driver_audit where driver_id = ?",
                new BeanHandler<DriverAudit>(DriverAudit.class, rowProcessor), driverId);
        return driverAudit;
    } catch (SQLException e) {
        logger.error("??? ?{}", driverId);
        throw new RuntimeException("???", e);
    }
}

---

From source file:com.demo.admin.dao.impl.AdminDriverDaoImpl.java

@Override
public DriverPlace getDriverPlace(Long driverPlaceId) {
    QueryRunner queryRunner = dbHelper.getRunner();
    DriverPlace driverPlace = null;/*from   w  w  w .j av  a  2s.  c  om*/
    BeanProcessor beanProcessor = new GenerousBeanProcessor();
    RowProcessor rowProcessor = new BasicRowProcessor(beanProcessor);
    try {
        driverPlace = queryRunner.query("select * from demo_driver_place where id=? limit 1",
                new BeanHandler<DriverPlace>(DriverPlace.class, rowProcessor), driverPlaceId);
    } catch (SQLException e) {
        String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();
        logger.error("{}??{}", methodName, driverPlaceId);
        throw new RuntimeException(e);
    }
    return driverPlace;
}

---

From source file:com.demo.admin.dao.impl.AdminDriverDaoImpl.java

@Override
public DriverAudit getDriverAudit(Long driverId) {
    QueryRunner queryRunner = dbHelper.getRunner();
    DriverAudit driverAudit = null;//from w  ww  .j  a  va 2s .c  o m
    BeanProcessor beanProcessor = new GenerousBeanProcessor();
    RowProcessor rowProcessor = new BasicRowProcessor(beanProcessor);
    try {
        driverAudit = queryRunner.query(
                "select HEX(uuid) as uuid,name,cell,sfz_a,sfz_b,jsz_a,xsz_a,driver_id,driver_place_id,license_plate,name_reject,cell_reject,sfz_a_reject,sfz_b_reject,jsz_a_reject,xsz_a_reject,license_plate_reject,created_time,updated_time from demo_driver_audit where driver_id=? limit 1",
                new BeanHandler<DriverAudit>(DriverAudit.class, rowProcessor), driverId);
    } catch (SQLException e) {
        String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();
        logger.error("{}??{}", methodName, driverId);
        throw new RuntimeException(e);
    }
    return driverAudit;
}

---

From source file:com.xeiam.yank.Yank.java

/**
 * Return just one Bean given an SQL statement. If more than one row match the query, only the first row is returned.
 *
 * @param sql The SQL statement//from  www.j  a  va2s.c o  m
 * @param params The replacement parameters
 * @param beanType The Class of the desired return Object matching the table
 * @return The Object
 */
public static <T> T queryBean(String sql, Class<T> beanType, Object[] params) {

    T returnObject = null;

    try {

        BeanHandler<T> resultSetHandler = new BeanHandler<T>(beanType,
                new BasicRowProcessor(new YankBeanProcessor<T>(beanType)));

        returnObject = new QueryRunner(YANK_POOL_MANAGER.getDataSource()).query(sql, resultSetHandler, params);

    } catch (SQLException e) {
        handleSQLException(e);
    }

    return returnObject;
}

---

From source file:be.bittich.dynaorm.repository.GenericDynaRepository.java

protected ResultSetHandler<T> getHandler() {
    ResultSetHandler<T> handler = new BeanHandler(clazz, rowProcessor);
    return handler;
}

---

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

/**
 * ???IO/*from  ww  w. ja va  2 s  .c o  m*/
 *
 * @param <T>
 *            ??
 * @param modelName
 *            ??
 * @param sql
 *            ?sql
 * @param params
 *            sql
 * @return ??
 */
private static <T> T getBean(final String modelName, final String sql, final Object... params) {

    Class<?> type = ModelUtil.getBlankModel(modelName).getClass();

    RowProcessor rp = getRowProcessor(modelName);

    @SuppressWarnings({ "rawtypes", "unchecked" })
    ResultSetHandler rsh = new BeanHandler(type, rp);

    T bean = query(sql, rsh, params);
    if (bean != null) {
        cp2org(bean);
    }

    return bean;
}

---

From source file:jdao.JDAO.java

public <T> T queryForBean(String sql, Class<T> beanClazz, Object... args) throws Exception {
    ResultSetHandler<T> handler = new BeanHandler<T>(beanClazz,
            IBean.class.isAssignableFrom(beanClazz) ? new BasicRowProcessor(IBeanProcessor.of(beanClazz))
                    : this.generousRowProcessor);

    return this.queryForT(this.getDbType(), handler, this.getConnection(), this.getQueryRunner(), sql, args);
}

---

• «
• 1
• 2
• »