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: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   w  w  w.  j  av a 2s .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: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. ja v a2s.  co m*/
    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  www.j  a va 2  s  . c o  m*/
    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());//  w ww  .ja v a2  s  .  c om
    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   ww  w .  ja  v a  2 s . com*/
    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:com.demo.db.dao.impl.DriverDaoImpl.java

@Override
public Driver get(Long id) {
    QueryRunner queryRunner = dbHelper.getRunner();
    Driver driver = null;/*from  w w w  .j ava 2  s  .c  om*/
    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;//  w ww .ja  v  a 2 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: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());//from www . j  a v  a  2s  .  co  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());/*www . j a v  a2 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 a  va 2s .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));
}

---

• «
• 1
• 2
• 3
• 4
• »