Java JdbcUtils.lookupColumnName方法代码示例

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
/**
 * Implementation of ResultSetCallbackHandler.
 * Work out column size if this is the first row, otherwise just count rows.
 * <p>Subclasses can perform custom extraction or processing
 * by overriding the {@code processRow(ResultSet, int)} method.
 * @see #processRow(java.sql.ResultSet, int)
 */
@Override
public final void processRow(ResultSet rs) throws SQLException {
	if (this.rowCount == 0) {
		ResultSetMetaData rsmd = rs.getMetaData();
		this.columnCount = rsmd.getColumnCount();
		this.columnTypes = new int[this.columnCount];
		this.columnNames = new String[this.columnCount];
		for (int i = 0; i < this.columnCount; i++) {
			this.columnTypes[i] = rsmd.getColumnType(i + 1);
			this.columnNames[i] = JdbcUtils.lookupColumnName(rsmd, i + 1);
		}
		// could also get column names
	}
	processRow(rs, this.rowCount++);
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
@Override
public T mapRow(ResultSet rs, int rowNum) throws SQLException {
    T mappedObject = this.entityMapper.createInstance();
    ResultSetMetaData rsmd = rs.getMetaData();
    int columnCount = rsmd.getColumnCount();
    Map<String, Class<?>> types = this.entityMapper.types();

    this.entityMapper.startMapping(mappedObject);
    for (int index = 1; index <= columnCount; index++) {
        String column = JdbcUtils.lookupColumnName(rsmd, index);
        Object value = JdbcUtils.getResultSetValue(rs, index, types.get(column));

        this.entityMapper.setValue(mappedObject, column, value);
    }
    this.entityMapper.finishMapping(mappedObject);
    return mappedObject;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
/**
 * <B>方法名称：</B>映射行数据<BR>
 * <B>概要说明：</B><BR>
 * 
 * @param rs 结果集
 * @param row 行号
 * @return JSONObject 数据
 * @throws SQLException SQL异常错误
 * @see RowMapper#mapRow(ResultSet,
 *      int)
 */
public JSONObject mapRow(ResultSet rs, int row) throws SQLException {
    String key = null;
    Object obj = null;
    JSONObject json = new JSONObject();
    ResultSetMetaData rsmd = rs.getMetaData();
    int count = rsmd.getColumnCount();
    for (int i = 1; i <= count; i++) {
        key = JdbcUtils.lookupColumnName(rsmd, i);
        obj = JdbcUtils.getResultSetValue(rs, i);
        try {
            json.put(key, obj);
        }
        catch (JSONException e) {
        }
    }
    return json;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
@Override
public T mapRow(ResultSet rs, int rowNum) throws SQLException {
	Assert.state(this.mappedClass != null, "Mapped class was not specified");
	T bean = BeanUtils.instantiate(this.mappedClass);
	ResultSetMetaData rsmd = rs.getMetaData();
	int columnCount = rsmd.getColumnCount();
	for (int index = 1; index <= columnCount; index++) {
		String columnName = JdbcUtils.lookupColumnName(rsmd, index);
		// System.err.println("column:" + column);
		columnName = columnName.replaceAll(" ", "").toLowerCase();
		columnName = columnName.replace("_", "");

		Field field = this.mappedFields.get(columnName);

		// if (field == null) {
		// this.mappedFields.get(underscoreName(column));
		// }
		// System.out.println("column:" + column + " field:" + field);

		if (field == null && columnName.endsWith("s")) {
			// TODO images转imageList的临时实现?
			String column2 = columnName.substring(0, columnName.length() - 1) + "list";
			field = this.mappedFields.get(column2);
			// System.out.println("column2:" + column2 + " field:" + field);
		}

		if (field != null) {
			this.loadFieldValue(bean, rs, index, rsmd, columnName, field);
		}
	}
	return bean;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
private Map<String, Integer> createFieldIndex(ResultSet rs) throws SQLException {
	ResultSetMetaData rsmd = rs.getMetaData();
	int columnCount = rsmd.getColumnCount();
	Map<String, Integer> fieldIndex = new LinkedHashMap<String, Integer>(columnCount);

	for (int i = 1; i <= columnCount; i++) {
		String field = JdbcUtils.lookupColumnName(rsmd, i);
		fieldIndex.put(field, Integer.valueOf(i));
	}

	return fieldIndex;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
@Override
public JsonNode mapRow(ResultSet rs, int rowNum) throws SQLException {
    ObjectNode objectNode = mapper.createObjectNode();
    ResultSetMetaData rsmd = rs.getMetaData();
    int columnCount = rsmd.getColumnCount();
    for (int index = 1; index <= columnCount; index++) {
        String column = JdbcUtils.lookupColumnName(rsmd, index);
        Object value = rs.getObject(column);
        column = this.snakeCaseToCamelCase(column);
        if (value == null) {
            objectNode.putNull(column);
        } else if (value instanceof Integer) {
            objectNode.put(column, (Integer) value);
        } else if (value instanceof String) {
            objectNode.put(column, (String) value);
        } else if (value instanceof Boolean) {
            objectNode.put(column, (Boolean) value);
        } else if (value instanceof Date) {
            objectNode.put(column, ((Date) value).getTime());
        } else if (value instanceof Long) {
            objectNode.put(column, (Long) value);
        } else if (value instanceof Double) {
            objectNode.put(column, (Double) value);
        } else if (value instanceof Float) {
            objectNode.put(column, (Float) value);
        } else if (value instanceof BigDecimal) {
            objectNode.put(column, (BigDecimal) value);
        } else if (value instanceof Byte) {
            objectNode.put(column, (Byte) value);
        } else if (value instanceof byte[]) {
            objectNode.put(column, (byte[]) value);
        } else {
            throw new IllegalArgumentException("Unmappable object type: " + value.getClass());
        }
    }
    return objectNode;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
/**
 * Implementation of ResultSetCallbackHandler.
 * Work out column size if this is the first row, otherwise just count rows.
 * <p>Subclasses can perform custom extraction or processing
 * by overriding the {@code processRow(ResultSet, int)} method.
 * @see #processRow(java.sql.ResultSet, int)
 */
public final void processRow(ResultSet rs) throws SQLException {
	if (this.rowCount == 0) {
		ResultSetMetaData rsmd = rs.getMetaData();
		this.columnCount = rsmd.getColumnCount();
		this.columnTypes = new int[this.columnCount];
		this.columnNames = new String[this.columnCount];
		for (int i = 0; i < this.columnCount; i++) {
			this.columnTypes[i] = rsmd.getColumnType(i + 1);
			this.columnNames[i] = JdbcUtils.lookupColumnName(rsmd, i + 1);
		}
		// could also get column names
	}
	processRow(rs, this.rowCount++);
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
/**
 * {@inheritDoc}
 */
@Override
public T mapRow(ResultSet rs, int rowNumber) throws SQLException {
    Assert.state(this.mappedClass != null, "Mapped class was not specified");
    T mappedObject = BeanUtils.instantiate(this.mappedClass);
    BeanWrapper bw = PropertyAccessorFactory.forBeanPropertyAccess(mappedObject);

    ResultSetMetaData metaData = rs.getMetaData();
    int columnCount = metaData.getColumnCount();

    for (int index = 1; index <= columnCount; index++) {
        String column = JdbcUtils.lookupColumnName(metaData, index);

        String name = column.replaceAll(" ", "").toLowerCase();
        Object value = null;
        if (privateFields.containsKey(name)) {
            PropertyDescriptor pd = privateFields.get(name);
            value = getColumnValue(rs, index, pd.getPropertyType());
            if (logger.isDebugEnabled() && rowNumber == 0) {
                logger.debug("Mapping column '" + column + "' to property '" + pd.getName() + "' of type " + pd.getPropertyType());
            }
            // TODO: care about assign null to primitive field. See BeanPropertyRowMapper
            bw.setPropertyValue(pd.getName(), value);
        } else if (publicFields.containsKey(name)) {
            Field field = this.publicFields.get(name);
            value = getColumnValue(rs, index, field.getType());
            if (logger.isDebugEnabled() && rowNumber == 0) {
                logger.debug("Mapping column '" + column + "' to property '" + field.getName() + "' of type " + field.getType());
            }
            try {
                field.set(mappedObject, value);
            } catch (IllegalAccessException e) {
                throw new RuntimeException(e);
            }
        }
    }

    return mappedObject;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
@Override
public Map<String, String> mapRow(ResultSet rs, int rowNum) throws SQLException {
    Map<String, String> object = new HashMap<String, String>();
    ResultSetMetaData metaData = rs.getMetaData();
    for (int i = 1; i <= metaData.getColumnCount(); i++) {
        String columnName = JdbcUtils.lookupColumnName(metaData, i);
        object.put(columnName, rs.getString(i));
    }
    return object;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
/**
 * Extract the values for all columns in the current row.
 * <p>Utilizes public setters and result set metadata.
 * @see java.sql.ResultSetMetaData
 */
@Override
public T mapRow(ResultSet rs, int rowNumber) throws SQLException {
	Assert.state(this.mappedClass != null, "Mapped class was not specified");
	T mappedObject = BeanUtils.instantiate(this.mappedClass);
	BeanWrapper bw = PropertyAccessorFactory.forBeanPropertyAccess(mappedObject);
	initBeanWrapper(bw);

	ResultSetMetaData rsmd = rs.getMetaData();
	int columnCount = rsmd.getColumnCount();
	Set<String> populatedProperties = (isCheckFullyPopulated() ? new HashSet<String>() : null);

	for (int index = 1; index <= columnCount; index++) {
		String column = JdbcUtils.lookupColumnName(rsmd, index);
		PropertyDescriptor pd = this.mappedFields.get(column.replaceAll(" ", "").toLowerCase());
		if (pd != null) {
			try {
				Object value = getColumnValue(rs, index, pd);
				if (logger.isDebugEnabled() && rowNumber == 0) {
					logger.debug("Mapping column '" + column + "' to property '" +
							pd.getName() + "' of type " + pd.getPropertyType());
				}
				try {
					bw.setPropertyValue(pd.getName(), value);
				}
				catch (TypeMismatchException e) {
					if (value == null && primitivesDefaultedForNullValue) {
						logger.debug("Intercepted TypeMismatchException for row " + rowNumber +
								" and column '" + column + "' with value " + value +
								" when setting property '" + pd.getName() + "' of type " + pd.getPropertyType() +
								" on object: " + mappedObject);
					}
					else {
						throw e;
					}
				}
				if (populatedProperties != null) {
					populatedProperties.add(pd.getName());
				}
			}
			catch (NotWritablePropertyException ex) {
				throw new DataRetrievalFailureException(
						"Unable to map column " + column + " to property " + pd.getName(), ex);
			}
		}
	}

	if (populatedProperties != null && !populatedProperties.equals(this.mappedProperties)) {
		throw new InvalidDataAccessApiUsageException("Given ResultSet does not contain all fields " +
				"necessary to populate object of class [" + this.mappedClass + "]: " + this.mappedProperties);
	}

	return mappedObject;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
@Override
public T mapRow(ResultSet rs, int rowNumber) throws SQLException {
	Assert.state(this.mappedClass != null, "Mapped class was not specified");
	T mappedObject = BeanUtils.instantiate(this.mappedClass);
	BeanWrapper bw = PropertyAccessorFactory.forBeanPropertyAccess(mappedObject);

	ResultSetMetaData rsmd = rs.getMetaData();
	int columnCount = rsmd.getColumnCount();
	
	for (int index = 1; index <= columnCount; index++) {
		String column = JdbcUtils.lookupColumnName(rsmd, index);
		String dbFieldName = column.replaceAll(" ", "");
		FieldMapper fieldMapper = this.tableMapper.getFieldMapper(dbFieldName);
		PropertyDescriptor pd;
		if (fieldMapper != null && (pd=fieldMapper.getPropertyDescriptor()) != null ) {
			try {
				Object value = getColumnValue(rs, index, pd);
				if (logger.isDebugEnabled() && rowNumber == 0) {
					logger.debug("Mapping column '" + column + "' to property '" +pd.getName() + "' of type " + pd.getPropertyType());
				}
				try {
					bw.setPropertyValue(pd.getName(), value);
				}
				catch (TypeMismatchException e) {
					if (value == null) {
						logger.debug("Intercepted TypeMismatchException for row " + rowNumber +
								" and column '" + column + "' with value " + value +
								" when setting property '" + pd.getName() + "' of type " + pd.getPropertyType() +
								" on object: " + mappedObject);
					}
					else {
						throw e;
					}
				}
			}
			catch (NotWritablePropertyException ex) {
				throw new DataRetrievalFailureException("Unable to map column " + column + " to property " + pd.getName(), ex);
			}
		}
	}
	
	
	return mappedObject;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
/**
 * Extract the values for all columns in the current row.
 * <p>Utilizes public setters and result set metadata.
 * @see java.sql.ResultSetMetaData
 */
public T mapRow(ResultSet rs, int rowNumber) throws SQLException {
	Assert.state(this.mappedClass != null, "Mapped class was not specified");
	T mappedObject = BeanUtils.instantiate(this.mappedClass);
	BeanWrapper bw = PropertyAccessorFactory.forBeanPropertyAccess(mappedObject);
	initBeanWrapper(bw);

	ResultSetMetaData rsmd = rs.getMetaData();
	int columnCount = rsmd.getColumnCount();
	Set<String> populatedProperties = (isCheckFullyPopulated() ? new HashSet<String>() : null);

	for (int index = 1; index <= columnCount; index++) {
		String column = JdbcUtils.lookupColumnName(rsmd, index);
		PropertyDescriptor pd = this.mappedFields.get(column.replaceAll(" ", "").toLowerCase());
		if (pd != null) {
			try {
				Object value = getColumnValue(rs, index, pd);
				if (logger.isDebugEnabled() && rowNumber == 0) {
					logger.debug("Mapping column '" + column + "' to property '" +
							pd.getName() + "' of type " + pd.getPropertyType());
				}
				try {
					bw.setPropertyValue(pd.getName(), value);
				}
				catch (TypeMismatchException e) {
					if (value == null && primitivesDefaultedForNullValue) {
						logger.debug("Intercepted TypeMismatchException for row " + rowNumber +
								" and column '" + column + "' with value " + value +
								" when setting property '" + pd.getName() + "' of type " + pd.getPropertyType() +
								" on object: " + mappedObject);
					}
					else {
						throw e;
					}
				}
				if (populatedProperties != null) {
					populatedProperties.add(pd.getName());
				}
			}
			catch (NotWritablePropertyException ex) {
				throw new DataRetrievalFailureException(
						"Unable to map column " + column + " to property " + pd.getName(), ex);
			}
		}
	}

	if (populatedProperties != null && !populatedProperties.equals(this.mappedProperties)) {
		throw new InvalidDataAccessApiUsageException("Given ResultSet does not contain all fields " +
				"necessary to populate object of class [" + this.mappedClass + "]: " + this.mappedProperties);
	}

	return mappedObject;
}
 

import org.springframework.jdbc.support.JdbcUtils; //导入方法依赖的package包/类
/**
 * Extract the values for all columns in the current row.
 * <p>Utilizes public setters and result set metadata.
 * @see java.sql.ResultSetMetaData
 */
@SuppressWarnings("rawtypes")
public Object mapRow2SubObj(ResultSet rs, int rowNumber,Class subClz) throws SQLException {
	Assert.state(subClz != null, "Mapped class was not specified");
	Object mappedObject = BeanUtils.instantiate(subClz);
	BeanWrapper bw = PropertyAccessorFactory.forBeanPropertyAccess(mappedObject);
	initBeanWrapper(bw);
	
	ResultSetMetaData rsmd = rs.getMetaData();
	int columnCount = rsmd.getColumnCount();
	Set<String> populatedProperties = (isCheckFullyPopulated() ? new HashSet<String>() : null);
	
	for (int index = 1; index <= columnCount; index++) {
		String column = JdbcUtils.lookupColumnName(rsmd, index);
		PropertyDescriptor pd = this.subMappedFields.get(column.replaceAll(" ", "").toLowerCase());
		Class clz = this.subMappedFieldsSuperClz.get(column.replaceAll(" ", "").toLowerCase());
		if (pd != null&&clz==subClz) {
			try {
				Object value = getColumnValue(rs, index, pd);
				if (logger.isDebugEnabled() && rowNumber == 0) {
					//logger.debug("Mapping column '" + column + "' to property '" +
					//		pd.getName() + "' of type " + pd.getPropertyType());
				}
				try {
					bw.setPropertyValue(pd.getName(), value);
				}catch (TypeMismatchException e) {
					if (value == null && primitivesDefaultedForNullValue) {
						logger.debug("Intercepted TypeMismatchException for row " + rowNumber +
								" and column '" + column + "' with value " + value +
								" when setting property '" + pd.getName() + "' of type " + pd.getPropertyType() +
								" on object: " + mappedObject);
					}
					else {
						throw e;
					}
				}
				if (populatedProperties != null) {
					populatedProperties.add(pd.getName());
				}
			}
			catch (NotWritablePropertyException ex) {
				throw new DataRetrievalFailureException(
						"Unable to map column " + column + " to property " + pd.getName(), ex);
			}
		} 
	}
	
	if (populatedProperties != null && !populatedProperties.equals(this.subMappedProperties)) {
		throw new InvalidDataAccessApiUsageException("Given ResultSet does not contain all fields " +
				"necessary to populate object of class [" + subClz+ "]: " + this.subMappedProperties);
	}
	
	return mappedObject;
}