Tennis

감사합니다. 댓글 참조하여 다음과 같이 작성해보았습니다.
<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">public Optional<Member> findByIdOrName(Long id, String name) { StringBuilder query = new StringBuilder("select * from member where 1=1"); List<String> queryArgs = new ArrayList<>(); if(id != null) { query.append(" and id=?"); queryArgs.add(String.valueOf(id)); } if(name != null) { query.append(" and name=?"); queryArgs.add(name); } List<Member> result = jdbcTemplate.query(query.toString(), memberRowMapper() , queryArgs.toArray()); return result.stream().findAny(); }</pre>

Tennis

Posts