（殘夢追月原創(chuàng)，轉(zhuǎn)載請注明）

本文地址：http://www.aygfsteel.com/cmzy/archive/2008/09/11/228271.html?

?? 今天看SpringAPI的時(shí)候無意中發(fā)現(xiàn)了Spring2.5新增了一個(gè)RowMapper的實(shí)現(xiàn)類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和實(shí)體類的字段進(jìn)行實(shí)現(xiàn)自動(dòng)映射。

?? 一個(gè)具體的例子如下：

?? 假如有這樣一個(gè)表，SQL-Server2000的建表腳本如下：

/* 管理員表 */ CREATE TABLE admin( id int identity(1,1) primary key, username varchar(20) not null, password varchar(32) not null, )

?? 為此，我們編寫一個(gè)對應(yīng)的實(shí)體類admin，它是一個(gè)標(biāo)準(zhǔn)的javaBean，代碼如下：

/** * */ package db.demo; /** * @author zhangyong * * @version 8:11:57 PM * */ public class Admin { private int id; private String username; private String password; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } }

?? 以前，在相應(yīng)的AdminDAO中，我們以前是這么做滴，看起來很麻煩，如果一個(gè)表的字段很多的話，就要人命了，我們必須不停的set、get：

/** * */ package db.demo; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; import org.springframework.jdbc.core.RowMapper; import org.springframework.jdbc.core.support.JdbcDaoSupport; /** * @author zhangyong * * @version 10:05:37 PM * */ public class AdminDAO extends JdbcDaoSupport { private final String ID = "id"; private final String USERNAME = "username"; private final String PASSWORD = "password"; private final String TABLE_NAME = "admin"; /** * 查詢記錄總數(shù)<br/> */ public List<Admin> queryAll() { final String sql = "Select * from " + TABLE_NAME; return getJdbcTemplate().query(sql, new RowMapper(){ public Object mapRow(ResultSet rs, int rowNum) throws SQLException { Admin admin = new Admin(); admin.setId(rs.getInt(ID)); admin.setUsername(rs.getString(USERNAME)); admin.setPassword(rs.getString(PASSWORD)); return admin; } }); } }

?? 可見，我們必須的手工對ResultSet和Admin進(jìn)行映射。而現(xiàn)在，我們只是需要這樣：

/** * */ package db.demo; import java.util.List; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.support.JdbcDaoSupport; /** * @author zhangyong * * @version 10:05:37 PM * */ public class AdminDAO extends JdbcDaoSupport { private final String TABLE_NAME = "admin"; /** * 查詢記錄總數(shù)<br/> */ public List<Admin> queryAll() { final String sql = "Select * from " + TABLE_NAME; return getJdbcTemplate().query(sql, new BeanPropertyRowMapper(Admin.class)); } }

??? 呵呵，只是一句話就完全搞定了……Sprin會(huì)為我們自動(dòng)映射……顯然這樣比以前方便多了。我們還可以把它用在其它任何使用RowMapper的場合……畢竟它繼承自RowMapper……

??? 需要注意的是：BeanPropertyRowMapper是根據(jù)字段名和實(shí)體類中的標(biāo)準(zhǔn)Setter方法進(jìn)行映射滴。也就是說，我們需要使表中的字段名和實(shí)體類的成員變量名稱一致。