67,513
社区成员
发帖
与我相关
我的任务
分享
JdbcTemplate 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));