Java Reference
In-Depth Information
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 = c.accountExecutiveId where = ?";
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();
return result;
Search WWH ::

Custom Search