Posted on 2009-04-08 08:32
landor 閱讀(2246)
評論(0) 編輯 收藏 所屬分類:
spring
spring的jdbc支持中，2.0中
RowMapperResultSetExtractor 替換1.0中 RowMapperResultReader
但是用法基本一樣，以下是個例子：
dbcTemplate jdbcTemplate = new JdbcTemplate(dataSource); // reusable object
RowMapper rowMapper = new UserRowMapper(); // reusable object
List allUsers = (List) jdbcTemplate.query("select * from user",new RowMapperResultSetExtractor(rowMapper, 10));
User user = (User) jdbcTemplate.queryForObject("select * from user where id=?", new Object[] {id},
new RowMapperResultSetExtractor(rowMapper, 1));
//其中UserRowMapper可以這么實現：
public class UserRowMapper implements RowMapper {
public Object mapRow(ResultSet rs, int index) throws SQLException {
// TODO Auto-generated method stub
User user=new User();
user.setId(rs.getString("001"));
user.setPassword(rs.getString("xxx"));
return user;
}
}
參考網址
http://static.springframework.org/spring/docs/2.0.x/api/org/springframework/jdbc/core/RowMapperResultSetExtractor.html