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

Introduction

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

Prototype

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

Source Link

Document

Creates a new instance of BeanListHandler.

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 {//from  ww w . j  ava2s .c o m
        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.aw.core.dao.bean.sql.BeanSqlBuilder.java

protected List execSqlQuery(String fullSql, Object[] params) {
    Class beanClass = beanWrap.getWrappedClass();
    return (List) daoSQL.executeQuery(fullSql, params,
            new BeanListHandler(beanClass, new QTTbBnMapperBasicRowProcessor()));
}

---

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

@Test
public void testBindPersonAccessByFieldAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new AnnotationProcessor(Person.class));
    ResultSetHandler<List<Person>> prsh = new BeanListHandler<Person>(Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());//from w  w w.j  a  va2  s.c  om
    assertEquals(new Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Person(3, "Robert", "Bloch"), persons.get(2));

}

---

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

@Test
public void testBindPersonByPropertyAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new AnnotationProcessor(Person.class));
    ResultSetHandler<List<Person>> prsh = new BeanListHandler<Person>(Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());/*from w  w  w  .ja  v  a  2s  . com*/
    assertEquals(new Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Person(3, "Robert", "Bloch"), persons.get(2));

}

---

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

@Test
public void testBindPersonByFieldAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new JPA20AnnotationProcessor(Jpa20Person.class));
    ResultSetHandler<List<Jpa20Person>> prsh = new BeanListHandler<Jpa20Person>(Jpa20Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Jpa20Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());/*from ww  w . j a  va2s .c o m*/
    assertEquals(new Jpa20Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Jpa20Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Jpa20Person(3, "Robert", "Bloch"), persons.get(2));

}

---

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

@Test
public void testBindPersonByPropertyAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new JPA20AnnotationProcessor(Jpa20Person.class));
    ResultSetHandler<List<Jpa20Person>> prsh = new BeanListHandler<Jpa20Person>(Jpa20Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Jpa20Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());/*from   www.  j a v  a  2s.c  o  m*/
    assertEquals(new Jpa20Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Jpa20Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Jpa20Person(3, "Robert", "Bloch"), persons.get(2));

}

---

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

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

---

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

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

---

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

@Test
public void testBindEmployeeByFieldAccess() 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   w w  w .  j  ava 2  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: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());/*  w  w  w .j  av a 2  s. co 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));
}

---

• «
• 1
• 2
• 3
• »