1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17 package org.apache.commons.dbutils;
18
19
20 import java.beans.PropertyDescriptor;
21 import java.sql.ResultSetMetaData;
22 import java.sql.SQLException;
23 import java.util.Arrays;
24
25
26
27
28
29
30
31
32 public class GenerousBeanProcessor extends BeanProcessor {
33
34
35
36
37 public GenerousBeanProcessor() {
38 }
39
40 @Override
41 protected int[] mapColumnsToProperties(final ResultSetMetaData rsmd,
42 final PropertyDescriptor[] props) throws SQLException {
43
44 final int cols = rsmd.getColumnCount();
45 final int[] columnToProperty = new int[cols + 1];
46 Arrays.fill(columnToProperty, PROPERTY_NOT_FOUND);
47
48 for (int col = 1; col <= cols; col++) {
49 String columnName = rsmd.getColumnLabel(col);
50
51 if (null == columnName || 0 == columnName.length()) {
52 columnName = rsmd.getColumnName(col);
53 }
54
55 final String generousColumnName = columnName
56 .replace("_", "")
57 .replace(" ", "");
58
59 for (int i = 0; i < props.length; i++) {
60 final String propName = props[i].getName();
61
62
63 if (columnName.equalsIgnoreCase(propName) ||
64 generousColumnName.equalsIgnoreCase(propName)) {
65 columnToProperty[col] = i;
66 break;
67 }
68 }
69 }
70
71 return columnToProperty;
72 }
73
74 }