BeanPropertyRowMapper

BeanPropertyRowMapper

 

转自（http://www.blogjava.net/cmzy/archive/2008/09/11/228271.html）

 

今天看SpringAPI的时候无意中发现了Spring2.5新增了一个RowMapper的实现类org.springframework.jdbc.core.BeanPropertyRowMapper，但是貌似Spring的refrence里面根本就没提及到。Google了一下……貌似也莫得多少文档。

 

Spring API Doc的说明如下：

 

RowMapper implementation that converts a row into a new instance of the specified mapped target class. The mapped target class must be a top-level class and it must have a default or no-arg constructor.

 

Column values are mapped based on matching the column name as obtained from result set metadata to public setters for the corresponding properties. The names are matched either directly or by transforming a name separating the parts with underscores to the same name using "camel" case.

 

Mapping is provided for fields in the target class for many common types, e.g.: String, boolean, Boolean, byte, Byte, short, Short, int, Integer, long, Long, float, Float, double, Double, BigDecimal, java.util.Date, etc.

 

To facilitate mapping between columns and fields that don't have matching names, try using column aliases in the SQL statement like "select fname as first_name from customer".

 

Please note that this class is designed to provide convenience rather than high performance. For best performance consider using a custom RowMapper.

 

也就说，它可以把ResultSet和实体类的字段进行实现自动映射。