UserDAO
public class UserDAO {
public List<User> loadUsers(final int id) {
final UserBuilder userBuilder = new UserBuilder();
getJdbcTemplate().query(selectSql, new Object[] { id }, userBuilder);
return userBuilder.getUserList();
}
class UserBuilder implements RowCallbackHandler {
private transient final List<User> userList = new ArrayList<User>();
@Override
public void processRow(final ResultSet rs) throws SQLException {
final User user = new User();
user.setName(rs.getString("name"));
userList.add(user);
}
public List<User> getUserList() {
return userList;
}
}
}