001: /*
002: * hgcommons 7
003: * Hammurapi Group Common Library
004: * Copyright (C) 2003 Hammurapi Group
005: *
006: * This program is free software; you can redistribute it and/or
007: * modify it under the terms of the GNU Lesser General Public
008: * License as published by the Free Software Foundation; either
009: * version 2 of the License, or (at your option) any later version.
010: *
011: * This program is distributed in the hope that it will be useful,
012: * but WITHOUT ANY WARRANTY; without even the implied warranty of
013: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
014: * Lesser General Public License for more details.
015: *
016: * You should have received a copy of the GNU Lesser General Public
017: * License along with this library; if not, write to the Free Software
018: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
019: *
020: * URL: http://www.hammurapi.biz/hammurapi-biz/ef/xmenu/hammurapi-group/products/products/hgcommons/index.html
021: * e-Mail: support@hammurapi.biz
022: */
023: package biz.hammurapi.sql;
024:
025: import java.sql.ResultSet;
026: import java.sql.SQLException;
027: import java.util.Map;
028: import java.util.StringTokenizer;
029:
030: /**
031: * Base class for reflection projectors.
032: * @author Pavel Vlasov
033: * @version $Revision: 1.2 $
034: */
035: public class BaseReflectionProjector {
036:
037: private Map typeMap;
038:
039: /**
040: * @param typeMap type map to be used in java.sql.ResultSet.getField(String/int, Map) method
041: */
042: protected BaseReflectionProjector(Map typeMap) {
043: this .typeMap = typeMap;
044: }
045:
046: /**
047: * This implmentation uses ResultSet.getObject() method to obtain field value.
048: * Override this method if needed to provide custom type conversion.
049: * @param rs ResultSet
050: * @param columnName Field name
051: * @return Column value
052: * @throws SQLException
053: */
054: protected Object getColumn(ResultSet rs, String columnName)
055: throws SQLException {
056: return typeMap == null ? rs.getObject(columnName) : rs
057: .getObject(columnName, typeMap);
058: }
059:
060: /**
061: * This implmentation uses ResultSet.getObject() method to obtain field value.
062: * Override this method if needed to provide custom type conversion.
063: * @param rs ResultSet
064: * @param columnNo Column number
065: * @return Field value
066: * @throws SQLException
067: */
068: protected Object getColumn(ResultSet rs, int columnNo)
069: throws SQLException {
070: return typeMap == null ? rs.getObject(columnNo) : rs.getObject(
071: columnNo, typeMap);
072: }
073:
074: /**
075: * Converts column name such as "MY_COLUMN" to java property name such as myColumn
076: * @param columnName
077: * @return
078: */
079: public static String propertyName(String columnName) {
080: StringTokenizer st = new StringTokenizer(columnName, "_");
081: StringBuffer ret = new StringBuffer();
082: boolean capitalize = false;
083: while (st.hasMoreTokens()) {
084: String token = st.nextToken();
085: if (capitalize) {
086: ret.append(Character.toUpperCase(token.charAt(0)));
087: if (token.length() > 1) {
088: ret.append(token.substring(1).toLowerCase());
089: }
090: } else {
091: ret.append(token.toLowerCase());
092: capitalize = true;
093: }
094: }
095: return ret.toString();
096: }
097:
098: /**
099: * MY_COLUMN -> getMyColumn
100: * @param columnName
101: * @return
102: */
103: public static String accessorName(String columnName) {
104: String propertyName = propertyName(columnName);
105: return "get"
106: + (propertyName.length() < 2 ? propertyName
107: .toUpperCase() : propertyName.substring(0, 1)
108: .toUpperCase()
109: + propertyName.substring(1));
110: }
111:
112: /**
113: * MY_COLUMN -> setMyColumn
114: * @param columnName
115: * @return
116: */
117: public static String mutatorName(String columnName) {
118: String propertyName = propertyName(columnName);
119: return "set"
120: + (propertyName.length() < 2 ? propertyName
121: .toUpperCase() : propertyName.substring(0, 1)
122: .toUpperCase()
123: + propertyName.substring(1));
124: }
125: }
|