Item Processors - Spring Batch - page 243

}
AccountExecutive
package com.apress.springbatch.chapter8;
public class AccountExecutive {
private long id;
private String firstName;
private String lastName;
// Accessors go here
…
}
To support the need to be able to read from this table, you will implement a new DAO that extends
Spring's JdbcTemplate. This DAO will have a single method used to get an AccountExecutive object from
the database based upon the Customer provided. Listing 8-14 shows the implementation of the
AccountExecutiveDaoImpl .
Listing 8-14. AccountExecutiveDaoImpl
package com.apress.springbatch.chapter8;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
public class AccountExecutiveDaoImpl extends JdbcTemplate implements
AccountExecutiveDao {
private String BY_CUSTOMER = "select a.* from accountExecutive a inner join " +
"customer c on a.id = c.accountExecutiveId where c.id = ?";
public AccountExecutive getAccountExecutiveByCustomer(Customer customer) {
return (AccountExecutive) queryForObject(BY_CUSTOMER,
new Object [] {customer.getId()},
new RowMapper()
{
public Object mapRow(ResultSet rs, int arg1) throws SQLException {
AccountExecutive result = new AccountExecutive();
result.setFirstName(rs.getString("firstName"));
result.setLastName(rs.getString("lastName"));
result.setId(rs.getLong("id"));
return result;
}
});
}