Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

package gov.va.med.ars.dao.ewv.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;

import javax.sql.DataSource;

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;

import gov.va.med.ars.dao.ewv.ILuClaimAdjustReasonCodeRepository;


@Repository
public class LuClaimAdjustReasonCodeRepositoryImpl implements ILuClaimAdjustReasonCodeRepository {

public static final Logger logger = LogManager.getLogger(LuClaimAdjustReasonCodeRepositoryImpl.class);

/* private JdbcTemplate jdbcTemplate;


*//**
* @param dataSource
*//*
@Autowired
public void setJdbcTemplate(DataSource dataSource) {
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
*/

private NamedParameterJdbcTemplate namedParameterJdbcTemplate;
private static HashMap<String, Object> searchParametersToSet = new HashMap<String, Object>();

/**
* @param dataSource
*/
@Autowired
public void setJdbcTemplate(DataSource dataSource) {
this.namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
}


/**
* @param userName
* @return
*/
public String getNoteByReasonCode(String claimAdjustReasonCode) {
logger.info("getNoteByReasonCode");
String note ="";
String sqlQuery = "select NOTE from EWV.LU_CLAIM_ADJUST_REASON_CODE lu where lu.CLAIM_ADJUST_REASON_CODE=:claimAdjustReasonCode";
searchParametersToSet.put("claimAdjustReasonCode", claimAdjustReasonCode);

try {
List<String> noteList = namedParameterJdbcTemplate.query(sqlQuery, searchParametersToSet,
new RowMapper<String>() {

@Override
public String mapRow(ResultSet rs, int rowNum) throws SQLException {
String note = rs.getString("NOTE");
return note;
}
});

if (noteList.size() > 0 && noteList.get(0) !=null) {
note = noteList.get(0);
}
searchParametersToSet.clear();
} catch (Exception e) {
logger.error("Error when getting note from EWV.LU_CLAIM_ADJUST_REASON_CODE table -" ,e);
}
return note;
}

}