Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SqlParameterSource namedParameters = new MapSqlParameterSource().addValue("id", id);
- String name = jdbcTemplateObject.queryForObject("SELECT USER_NAME FROM USER WHERE USER_ID = :id", namedParameters, String.class);
- String mail = jdbcTemplateObject.queryForObject("SELECT USER_MAIL FROM USER WHERE USER_ID = :id", namedParameters, String.class);
- String password = jdbcTemplateObject.queryForObject("SELECT USER_PASSWORD FROM USER WHERE USER_ID = :id", namedParameters, String.class);
- User user = new User();
- user.setId(id);
- user.setName(name);
- user.setMail(mail);
- user.setPassword(password);
- return user;
Add Comment
Please, Sign In to add comment