@Override
public Long getCount() {
String sql = "select count(*) from customers";
Integer count = jdbcTemplate.queryForObject(sql, Integer.class);
return Long.valueOf(count);
}
@Override
public Date getMaxBirth() {
String sql = "select max(birth) from customers";
Date date = jdbcTemplate.queryForObject(sql, Date.class);
return date;
}
@Override
public String getCustomerName(int id) {
String sql = "select name from customers where id = ?";
Object[] args = {id};
String name = jdbcTemplate.queryForObject(sql, String.class,args);
return name;
}