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
28
29 public class StringTrimmedResultSetTest extends BaseTestCase {
30
31 public void setUp() throws Exception {
32 super.setUp();
33 this.rs = StringTrimmedResultSet.wrap(this.rs);
34 }
35
36 public void testGetString() throws SQLException {
37 this.rs.next();
38 assertEquals("notInBean", rs.getString(4));
39 }
40
41 public void testGetObject() throws SQLException {
42 this.rs.next();
43 assertEquals("notInBean", rs.getObject(4));
44 }
45
46
47
48
49
50 public void testMultipleWrappers() throws Exception {
51
52 Object[][] rows = new Object[][] { { null }
53 };
54 ResultSet rs = MockResultSet.create(metaData, rows);
55
56
57 SqlNullCheckedResultSet ncrs = new SqlNullCheckedResultSet(rs);
58 ncrs.setNullString(" trim this ");
59 rs = ProxyFactory.instance().createResultSet(ncrs);
60
61
62 rs = StringTrimmedResultSet.wrap(rs);
63
64 rs.next();
65 assertEquals("trim this", rs.getString(1));
66 }
67
68 }