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(BeanProcessor convert) 

Source Link

Document

BasicRowProcessor constructor.

Usage

From source file:jp.gr.java_conf.ka_ka_xyz.processor.JPA20AnnotationProcessorPropertyAccessTest.java

@Test
public void testBindEmployeeByPropertyAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new JPA20AnnotationProcessor(Jpa20Employee.class));
    ResultSetHandler<List<Jpa20Employee>> ersh = new BeanListHandler<Jpa20Employee>(Jpa20Employee.class, rp);
    String sql = "SELECT * from person INNER JOIN employee ON person.id = employee.person_id ORDER BY id ASC";
    List<Jpa20Employee> employees = run.query(conn, sql, ersh);
    assertEquals(3, employees.size());//from  ww  w.j  av a2  s .  c o  m
    assertEquals(new Jpa20Employee(1, "Howard", "Lovecraft", "EMP001", "Weird Tales Div."), employees.get(0));
    assertEquals(new Jpa20Employee(2, "August", "Derleth", "EMP002", "Arkham House Div."), employees.get(1));
    assertEquals(new Jpa20Employee(3, "Robert", "Bloch", "EMP003", "Weird Tales Div."), employees.get(2));
}

---

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

@Override
public Driver get(String cell) {
    QueryRunner queryRunner = dbHelper.getRunner();
    Driver driver = null;/*from  w w  w .  j  av  a2 s . com*/
    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 {//from  w w  w . j  av  a  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   w  w w  .j  ava2s  . c om*/
    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;/*www. j  a  v a2s  .  c  o m*/
    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   www .  j a  va 2  s.  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  w  ww  .ja v a  2 s  .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:com.xeiam.yank.Yank.java

/**
 * Return a List of Beans given an SQL statement
 *
 * @param sql The SQL statement//from w  w  w  .j a v a2s.c  om
 * @param beanType The Class of the desired return Objects matching the table
 * @param params The replacement parameters
 * @return The List of Objects
 */
public static <T> List<T> queryBeanList(String sql, Class<T> beanType, Object[] params) {

    List<T> returnList = null;

    try {

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

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

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

---

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

/**
 * dbutils?/*from   w  w  w.  j a v  a2  s  . c om*/
 *
 * @param modelName
 *            ??
 * @return RowProcessor
 */
private static RowProcessor getRowProcessor(final String modelName) {

    Map<String, String> mapping = new LinkedHashMap<String, String>();

    Map<String, String> propertyMeis = ModelUtil.getPropertyMeis(modelName);

    TableInfo tableInfo = MetaData.getTableInfo(modelName);

    for (String propertyName : propertyMeis.keySet()) {
        ColumnInfo columnInfo = tableInfo.getColumnInfo(propertyName);
        String columnName = columnInfo.getColumnName();
        mapping.put(columnName, propertyName);
    }

    BeanProcessor convert = new BeanProcessor(mapping);

    return new BasicRowProcessor(convert);
}

---

From source file:jdao.JDAO.java

public <K, V> Map<K, V> queryForBeanMap(String sql, Class<K> idClazz, Class<V> beanClazz, Object... args)
        throws Exception {
    BeanMapHandler<K, V> handler = new BeanMapHandler<K, V>(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
• 3
• 4
• »