Guest User

Untitled

a guest
Oct 17th, 2018
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. SqlParameterSource namedParameters = new MapSqlParameterSource().addValue("id", id);
  2. String name = jdbcTemplateObject.queryForObject("SELECT USER_NAME FROM USER WHERE USER_ID = :id", namedParameters, String.class);
  3. String mail = jdbcTemplateObject.queryForObject("SELECT USER_MAIL FROM USER WHERE USER_ID = :id", namedParameters, String.class);
  4. String password = jdbcTemplateObject.queryForObject("SELECT USER_PASSWORD FROM USER WHERE USER_ID = :id", namedParameters, String.class);
  5.  
  6. User user = new User();
  7. user.setId(id);
  8. user.setName(name);
  9. user.setMail(mail);
  10. user.setPassword(password);
  11. return user;
Add Comment
Please, Sign In to add comment