JSP Form, JSTL, @Query Like

https://velog.io/@dbsrud11/Spring-Boot-%ED%8F%BC-%EB%8D%B0%EC%9D%B4%ED%84%B0-%EC%A3%BC%EA%B3%A0-%EB%B0%9B%EA%B8%B0

 

검색기능 추가중

 

<form> 태그의 action 속성

폼 데이터(form data)를 서버로 보낼 때 해당 데이터가 도착할 URL을 명시한다.

 

<form action = "URL">

 

또한 보낸 데이터를 Spring Boot Controller에서 매개변수로 받으려면

필드명과 같은 이름으로 name이라는 속성을 이용해 변수명을 입력해주어야 한다.

 

https://intel199.tistory.com/35

JSTL if, else 조건문 사용법

 

<c:choose> 
	<c:when test="${}">
	</c:when> 
	<c:otherwise>
	</c:otherwise> 
</c:choose>

 

https://stackoverflow.com/questions/21456494/spring-jpa-query-with-like

Spring JPA @Query Like 사용법

@Query("SELECT u.username FROM User u WHERE u.username LIKE CONCAT('%',:username,'%')")

 

@Query(value="SELECT * FROM board WHERE board.title LIKE CONCAT('%',?1,'%')", nativeQuery = true)
List<Board> searchBoardByTitle(String title);

@Query(value="SELECT * FROM board WHERE board.content LIKE CONCAT('%',?1,'%')", nativeQuery = true)
List<Board> searchBoardByContent(String content);

@Query(value="select * from board inner join (select * from user where username LIKE CONCAT('%',?1,'%')) a on board.userId = a.id", nativeQuery = true)
List<Board> searchBoardByUser(String user);