@Test
public void testCollision2ndTime() {
Dining dining = Dining.createDining("100.00", "1234123412341234", "1234567890");
rewardNetwork.rewardAccountFor(dining);
String sql = "select SAVINGS from T_ACCOUNT_BENEFICIARY where NAME = ?";
assertEquals(Double.valueOf(4.00), jdbcTemplate.queryForObject(sql, Double.class, "Annabelle"));
assertEquals(Double.valueOf(4.00), jdbcTemplate.queryForObject(sql, Double.class, "Corgan"));
}
/** {@inheritDoc} */
public String getUserPassword(String username) {
SimpleJdbcTemplate jdbcTemplate =
new SimpleJdbcTemplate(SessionFactoryUtils.getDataSource(getSessionFactory()));
Table table = AnnotationUtils.findAnnotation(User.class, Table.class);
return jdbcTemplate.queryForObject(
"select password from " + table.name() + " where username=?", String.class, username);
}
@Override
public Message getMessage(Long id) {
Map<String, Object> paramMap = new HashMap<>();
paramMap.put("msgId", id);
Message message = jdbcTemplate.queryForObject(SELECT_MESSAGE_SQL, messageRowMapper, paramMap);
return message;
}
@Override
public Health find(Integer pk) {
Health health = null;
try {
health = template.queryForObject(SELECT_QUERY_PK, healthRowMapper, pk);
} catch (DataAccessException e) {
throw new LunchException(e);
}
return health;
}
public CspTo findByPkgName(String name) {
SimpleJdbcTemplate sjt = getSimpleJdbcTemplate();
String sql = "select * from PIDB_Csp where PKG_NAME='" + name + "'";
CspTo pkgTo;
try {
pkgTo = sjt.queryForObject(sql, new GenericRowMapper<CspTo>(CspTo.class), new Object[] {});
} catch (Exception e) {
// e.printStackTrace();
return null;
}
return pkgTo;
}
public Employee getSalaryForEmployee(Employee employee) {
int salary =
simpleJdbcTemplate.queryForObject(
QUERY_SALARY_FOR_ID, Integer.class, new Object[] {employee.getEmpId()});
logger.info(
"getSalaryForEmployee for employee id " + employee.getEmpId() + " returned " + salary);
employee.setSalary(salary);
return employee;
}
/**
* 获取相应的Object
*
* @param sql
* @param className
* @param obj
* @return
*/
public Object getObject(String sql, Class<? extends Serializable> className, Object[] obj) {
Object object = null;
try {
object =
simpleJdbcTemplate.queryForObject(sql, BeanPropertyRowMapper.newInstance(className), obj);
} catch (DataAccessException e) {
log.info(e);
return null;
// throw new DaoException("数据库操作失败！",e);
}
return object;
}
@Override
public User getUser(Long id) {
User user = jdbcTemplate.queryForObject(SELECT_USER_SQL, userRowMapper, id);
return user;
}
