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.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 @Override
32 public void setUp() throws Exception {
33 super.setUp();
34 this.rs = StringTrimmedResultSet.wrap(this.rs);
35 }
36
37 public void testGetObject() throws SQLException {
38 this.rs.next();
39 assertEquals("notInBean", rs.getObject(4));
40 }
41
42 public void testGetString() throws SQLException {
43 this.rs.next();
44 assertEquals("notInBean", rs.getString(4));
45 }
46
47 /**
48 * Make sure 2 wrappers work together.
49 * @throws SQLException if a database access error occurs
50 */
51 public void testMultipleWrappers() throws Exception {
52 // Create a ResultSet with data
53 final Object[][] rows = { { null }
54 };
55 ResultSet rs = MockResultSet.create(metaData, rows);
56
57 // Wrap the ResultSet with a null checked version
58 final SqlNullCheckedResultSet ncrs = new SqlNullCheckedResultSet(rs);
59 ncrs.setNullString(" trim this ");
60 rs = ProxyFactory.instance().createResultSet(ncrs);
61
62 // Wrap the wrapper with a string trimmed version
63 rs = StringTrimmedResultSet.wrap(rs);
64
65 rs.next();
66 assertEquals("trim this", rs.getString(1));
67 }
68
69 }