1   /*
2    * Licensed to the Apache Software Foundation (ASF) under one or more
3    * contributor license agreements.  See the NOTICE file distributed with
4    * this work for additional information regarding copyright ownership.
5    * The ASF licenses this file to You under the Apache License, Version 2.0
6    * (the "License"); you may not use this file except in compliance with
7    * the License.  You may obtain a copy of the License at
8    *
9    *      http://www.apache.org/licenses/LICENSE-2.0
10   *
11   * Unless required by applicable law or agreed to in writing, software
12   * distributed under the License is distributed on an "AS IS" BASIS,
13   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14   * See the License for the specific language governing permissions and
15   * limitations under the License.
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  
26  /**
27   * ArrayListHandlerTest
28   */
29  public class ArrayListHandlerTest extends BaseTestCase {
30  
31  	public void testHandle() throws SQLException {
32  		ResultSetHandler h = new ArrayListHandler();
33  		List results = (List) h.handle(this.rs);
34  
35  		assertNotNull(results);
36  		assertEquals(ROWS, results.size());
37  
38  		Iterator iter = results.iterator();
39  	    Object[] row = null;
40  	    assertTrue(iter.hasNext());
41  	    row = (Object[]) iter.next();
42  	    assertEquals(COLS, row.length);
43  	    assertEquals("1", row[0]);
44  	    assertEquals("2", row[1]);
45  	    assertEquals("3", row[2]);
46  	        
47  	    assertTrue(iter.hasNext());
48  	    row = (Object[]) iter.next();
49  	    assertEquals(COLS, row.length);
50  
51  	    assertEquals("4", row[0]);
52  	    assertEquals("5", row[1]);
53  	    assertEquals("6", row[2]);
54  	        
55  	    assertFalse(iter.hasNext());
56  	}
57  
58  	public void testEmptyResultSetHandle() throws SQLException {
59  		ResultSetHandler h = new ArrayListHandler();
60  		List results = (List) h.handle(this.emptyResultSet);
61  
62  		assertNotNull(results);
63  		assertTrue(results.isEmpty());
64  	}
65  
66  }