bookVO 리스트불러오기(+검색) 추가 쿼리

  	 <select id="list" parameterType="String" resultType="bookVO">
	WITH T AS(
	    SELECT ROW_NUMBER() OVER(ORDER BY BOOK_ID DESC) RNUM
	    , ROWNUM NUM1
	    , BOOK_ID, TITLE, CATEGORY, PRICE, INSERT_DATE, CONTENT
	    FROM   BOOK
	    WHERE 1 = 1
	    <if test="keyword!=null and keyword!=''">
	    	AND(
	    		TITLE LIKE '%' || #{keyword} || '%'
	    	OR CATEGORY LIKE '%' || #{keyword} || '%'
	    	OR CONTENT LIKE '%' || #{keyword} || '%'
	    	)
	    </if>
	)
	SELECT T.RNUM, T.BOOK_ID, T.TITLE, T.CATEGORY, T.PRICE
	     , T.INSERT_DATE, T.CONTENT 
	FROM   T
  	 </select>