Guest User

Untitled

a guest
Apr 25th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. select id, birth_date, fullname from some_table where fullname ~ 'mSTACKM'
  2.  
  3. String sql = "select id, fullname, birth_date from some_table where fullname ~ 'm:nameM' and birth_date = :birth_date";
  4.  
  5. SqlParameterSource params = new MapSqlParameterSource()
  6. .addValue("name", "STACK")
  7. .addValue("birth_date", "22.07.2002");
  8.  
  9. namedJdbcTemplate.query(sql, params, ....);
  10.  
  11. SELECT id, fullname, birth_date FROM some_table WHERE fullname ~ 'm:nameM' AND birth_date = ?;
Add Comment
Please, Sign In to add comment