1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17 package org.apache.commons.dbutils.handlers;
18
19 import java.sql.SQLException;
20 import java.util.Iterator;
21 import java.util.List;
22
23 import org.apache.commons.dbutils.BaseTestCase;
24 import org.apache.commons.dbutils.ResultSetHandler;
25 import org.apache.commons.dbutils.TestBean;
26
27
28
29
30 public class BeanListHandlerTest extends BaseTestCase {
31
32 public void testHandle() throws SQLException {
33 ResultSetHandler h = new BeanListHandler(TestBean.class);
34 List results = (List) h.handle(this.rs);
35
36 assertNotNull(results);
37 assertEquals(ROWS, results.size());
38
39 Iterator iter = results.iterator();
40 TestBean row = null;
41 assertTrue(iter.hasNext());
42 row = (TestBean) iter.next();
43 assertEquals("1", row.getOne());
44 assertEquals("2", row.getTwo());
45 assertEquals("3", row.getThree());
46 assertEquals("not set", row.getDoNotSet());
47
48 assertTrue(iter.hasNext());
49 row = (TestBean) iter.next();
50
51 assertEquals("4", row.getOne());
52 assertEquals("5", row.getTwo());
53 assertEquals("6", row.getThree());
54 assertEquals("not set", row.getDoNotSet());
55
56 assertFalse(iter.hasNext());
57 }
58
59 public void testEmptyResultSetHandle() throws SQLException {
60 ResultSetHandler h = new BeanListHandler(TestBean.class);
61 List results = (List) h.handle(this.emptyResultSet);
62
63 assertNotNull(results);
64 assertTrue(results.isEmpty());
65 }
66
67 }