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

Introduction

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

Prototype

public GenerousBeanProcessor() 

Source Link

Document

Default constructor.

Usage

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

@Override
public List<Driver> queryByPage(Short offset, Short limit) {
    QueryRunner queryRunner = dbHelper.getRunner();
    List<Driver> drivers = null;
    try {/*w w  w  .ja  va2s .com*/
        BeanProcessor beanProcessor = new GenerousBeanProcessor();
        RowProcessor rowProcessor = new BasicRowProcessor(beanProcessor);
        drivers = queryRunner.query("select * from demo_driver order by actived asc, id asc limit ?, ?",
                new BeanListHandler<Driver>(Driver.class, rowProcessor), offset, limit);
    } catch (SQLException e) {
        String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();
        logger.error("{}??{},{}", methodName, offset, limit);
        throw new RuntimeException(e);
    }
    return drivers;
}

---

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

@Override
public Driver get(Long id) {
    QueryRunner queryRunner = dbHelper.getRunner();
    Driver driver = null;//from   www  .j  a  v  a  2 s  .  c o m
    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   www .j  av a  2  s . co 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;//from   www  . j  av a  2s. c  o  m
    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.admin.dao.impl.AdminDriverDaoImpl.java

@Override
public List<DriverPlace> queryDriverPlaceByPage(Short offset, Short limit) {
    QueryRunner queryRunner = dbHelper.getRunner();
    List<DriverPlace> listDriverPlace = null;
    try {//ww  w  .  j  ava 2 s. c  o  m
        BeanProcessor beanProcessor = new GenerousBeanProcessor();
        RowProcessor rowProcessor = new BasicRowProcessor(beanProcessor);
        if (null != offset && null != limit) {
            listDriverPlace = queryRunner.query("select * from demo_driver_place limit ?, ?",
                    new BeanListHandler<DriverPlace>(DriverPlace.class, rowProcessor), offset, limit);
        } else {
            logger.error("offset={}, limit={}", offset, limit);
            throw new RuntimeException("offset or limit's value is not correct.");
        }
    } catch (SQLException e) {
        String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();
        logger.error("{}??{},{}", methodName, offset, limit);
        throw new RuntimeException(e);
    }
    return listDriverPlace;
}

---

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

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

    DriverAudit driverAudit = null;/*from ww w.j  a va2 s  . c o  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;// w  w w. j  av a 2 s.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 w  w . j  a v  a2s.  c  om*/
    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;
}

---