@Override
 public Long insert(User user) {
   return jdbcTemplate.queryForObject(
       "INSERT INTO users (role, username, password)" + " VALUES (?,?,?) returning id",
       new Object[] {user.getRole().name(), user.getUsername(), user.getPassword()},
       new IdMapper());
 }
 @Override
 public void update(User user) {
   jdbcTemplate.update(
       "UPDATE users " + "SET role=?, username=?, password=?" + " WHERE id=?",
       user.getRole().name(),
       user.getUsername(),
       user.getPassword(),
       user.getId());
 }