1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17 package org.apache.commons.dbutils.wrappers;
18
19 import java.sql.ResultSet;
20 import java.sql.SQLException;
21
22 import org.apache.commons.dbutils.BaseTestCase;
23 import org.apache.commons.dbutils.MockResultSet;
24 import org.apache.commons.dbutils.ProxyFactory;
25
26 /**
27 * StringTrimmedResultSetTest
28 */
29 public class StringTrimmedResultSetTest extends BaseTestCase {
30
31 public StringTrimmedResultSetTest(String name) {
32 super(name);
33 }
34
35 public void setUp() throws Exception {
36 super.setUp();
37 this.rs = StringTrimmedResultSet.wrap(this.rs);
38 }
39
40 public void testGetString() throws SQLException {
41 this.rs.next();
42 assertEquals("notInBean", rs.getString(4));
43 }
44
45 public void testGetObject() throws SQLException {
46 this.rs.next();
47 assertEquals("notInBean", rs.getObject(4));
48 }
49
50 /**
51 * Make sure 2 wrappers work together.
52 * @throws SQLException if a database access error occurs
53 */
54 public void testMultipleWrappers() throws Exception {
55
56 Object[][] rows = new Object[][] { { null }
57 };
58 ResultSet rs = MockResultSet.create(metaData, rows);
59
60
61 SqlNullCheckedResultSet ncrs = new SqlNullCheckedResultSet(rs);
62 ncrs.setNullString(" trim this ");
63 rs = ProxyFactory.instance().createResultSet(ncrs);
64
65
66 rs = StringTrimmedResultSet.wrap(rs);
67
68 rs.next();
69 assertEquals("trim this", rs.getString(1));
70 }
71
72 }