Spring的JdbcTemplate从数据库中获取对象属性总为null

建议：实体类一定要用工具自动生成，避免手误！

原因：对象的属性名和表的列名不同，实例：

private String metaIsManage;//是否管理项
@Column(name = "MATE_IS_MANAGE")
public String getMetaIsManage() {
	return metaIsManage;
}

public void setMetaIsManage(String metaIsManage) {
	this.metaIsManage = metaIsManage;
}

注意上面代码中属性名和列名字母顺序不同，导致使用如下代码查询出来的metaIsManage属性总是为null

String sql = "SELECT * FROM el_table_column " +
					 "WHERE table_Id = ? " +
					 "ORDER BY column_order ASC, catalog_table_addtime DESC";
		return jdbc.query(sql, new Object[]{tableId}, new BeanPropertyRowMapper(ElTableColumn.class));

跟踪spring的源码发现：

mappedFields的hashMap中的内容如下：

{mate_id=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=mateId],
catalogtableiscodeset=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogTableIscodeset], 
columndesc=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnDesc],
columnname=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnName],
mateno=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=mateNo], 
columnid=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnId],
column_name=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnName],
metaismanage=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=metaIsManage],
catalog_pk=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogPk], 
isshow=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=isShow],
catalogitemid=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogItemId], 
catalogtablecodesetpk=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogTableCodesetPk],
catalog_table_codeset_pk=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogTableCodesetPk], 
length=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=length], 
column_order=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnOrder],
catalog_table_modifytime=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogTableModifytime],
meta_is_manage=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=metaIsManage],
column_type=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnType],
catalogitemno=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogItemNo],
meta_column_format=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=metaColumnFormat], 
column_desc=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnDesc], 
column_id=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnId],
table_id=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=tableId], 
nullable=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=nullable],
metacolumnformat=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=metaColumnFormat],
iskey=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=isKey],
catalogtablemodifytime=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogTableModifytime], 
catalogpk=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogPk], 
is_key=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=isKey],
is_show=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=isShow], 
catalog_item_id=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogItemId],
tableid=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=tableId], 
catalog_table_addtime=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogTableAddtime],
catalog_item_no=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogItemNo],
mate_no=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=mateNo], 
catalog_table_iscodeset=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogTableIscodeset], 
mateid=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=mateId],
catalogtableaddtime=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=catalogTableAddtime],
columnorder=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnOrder],
columntype=org.springframework.beans.GenericTypeAwarePropertyDescriptor[name=columnType]}

所以根据mate_is_manage为key获取value自然获取不到！

建议：实体类一定要用工具自动生成，避免手误！