JdbcContactSfDao.java

package com.company.app.annotation.dao;

import java.util.List;

import javax.annotation.Resource;
import javax.sql.DataSource;

import org.springframework.stereotype.Repository;

import com.company.app.annotation.procedure.SfFirstNameById;

@Repository("contactSfDao")
public class JdbcContactSfDao implements ContactSfDao {

	private DataSource dataSource;
	
	private SfFirstNameById sfFirstNameById;
	
	@Resource(name="dataSource")
	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
		sfFirstNameById = new SfFirstNameById(dataSource);
	}	
	
	public DataSource getDataSource() {
		return dataSource;
	}	
	
	public String getFirstNameById(Long id) {
		List<String> result = sfFirstNameById.execute(id); 
		return result.get(0); 
	}

}