08-3. SimpleBoard (Paging, Searching) [Spring]

Search 쿼리문 (Dynamic SQL)

<select id="getBoardCount" resultType="_int" parameterType="BoardSearchVO">

SELECT    COUNT(1)

FROM    BRD B

<if test="searchType == 1">

WHERE    B.SBJ LIKE '%' || #{searchKeyword} || '%'

</if>

<IF TEST="searchType == 2">

, USR U

WHERE    B.USR_ID = U.USR_ID

AND        U.USR_NICK_NAME LIKE '%' || #{searchKeyword} || '%'

</if>

<select>

3일차 : Paging, Searching, 자신이 쓴글에는 포인트가 까이지 않는다.

↓↓↓↓↓

SimpleBoard03.zip