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;
}
}