Example #1
0
 private String getColumnIdentifier(ResultSetMetaData rsmd, int i) throws SQLException {
   if (delegate.isUseColumnLabel()) {
     return rsmd.getColumnLabel(i);
   } else {
     return rsmd.getColumnName(i);
   }
 }
Example #2
0
  private void initializeBeanResults(ResultSet rs) {
    try {
      ClassInfo classInfo = ClassInfo.getInstance(getResultClass());
      String[] propertyNames = classInfo.getWriteablePropertyNames();

      Map propertyMap = new HashMap();
      for (int i = 0; i < propertyNames.length; i++) {
        propertyMap.put(propertyNames[i].toUpperCase(java.util.Locale.ENGLISH), propertyNames[i]);
      }

      List resultMappingList = new ArrayList();
      ResultSetMetaData rsmd = rs.getMetaData();
      for (int i = 0, n = rsmd.getColumnCount(); i < n; i++) {
        String columnName = getColumnIdentifier(rsmd, i + 1);
        String upperColumnName = columnName.toUpperCase(java.util.Locale.ENGLISH);
        String matchedProp = (String) propertyMap.get(upperColumnName);
        Class type = null;
        if (matchedProp == null) {
          Probe p = ProbeFactory.getProbe(this.getResultClass());
          try {
            type = p.getPropertyTypeForSetter(this.getResultClass(), columnName);
          } catch (Exception e) {
            // TODO - add logging to this class?
          }
        } else {
          type = classInfo.getSetterType(matchedProp);
        }
        if (type != null || matchedProp != null) {
          ResultMapping resultMapping = new ResultMapping();
          resultMapping.setPropertyName((matchedProp != null ? matchedProp : columnName));
          resultMapping.setColumnName(columnName);
          resultMapping.setColumnIndex(i + 1);
          resultMapping.setTypeHandler(
              getDelegate().getTypeHandlerFactory().getTypeHandler(type)); // map SQL to JDBC type
          resultMappingList.add(resultMapping);
        }
      }
      setResultMappingList(resultMappingList);

    } catch (SQLException e) {
      throw new RuntimeException("Error automapping columns. Cause: " + e);
    }
  }
Example #3
0
 private void initializeXmlResults(ResultSet rs) {
   try {
     List resultMappingList = new ArrayList();
     ResultSetMetaData rsmd = rs.getMetaData();
     for (int i = 0, n = rsmd.getColumnCount(); i < n; i++) {
       String columnName = getColumnIdentifier(rsmd, i + 1);
       ResultMapping resultMapping = new ResultMapping();
       resultMapping.setPropertyName(columnName);
       resultMapping.setColumnName(columnName);
       resultMapping.setColumnIndex(i + 1);
       resultMapping.setTypeHandler(
           getDelegate().getTypeHandlerFactory().getTypeHandler(String.class));
       resultMappingList.add(resultMapping);
     }
     setResultMappingList(resultMappingList);
   } catch (SQLException e) {
     throw new RuntimeException("Error automapping columns. Cause: " + e);
   }
 }