Spring framwork 프로젝트중 페이징에서 열의 정의가 애매합니다가 떴는데 이유를 모르겠네요

Question

<select id&#61;&#34;listShop&#34; resultMap&#61;&#34;shopMap&#34;><choose><when test&#61;&#34;searchShopWord &#61;&#61; 'itemname' orsearchShopWord &#61;&#61; 'company' orsearchShopWord &#61;&#61; 'contents'&#34;>SELECT * FROM(SELECT ROWNUM NUM, SB.* FROM(SELECT * FROM SHOP WHERE ${searchWord} LIKE '%' || #{key} || '%'ORDER BY NUM DESC)SB)WHERE NUM BETWEEN #{postStart} AND #{postEnd}</when><when test&#61;&#34;searchShopWord &#61;&#61; 'itemnameAndContents'&#34;>SELECT * FROM(SELECT ROWNUM NUM, SB.* FROM(SELECT * FROM SHOP WHERE ITEMNAME LIKE '%' || #{key} || '%'OR CONTENTS LIKE '%' || #{key} || '%' ORDER BY NUM DESC)SB)WHERE NUM BETWEEN #{postStart} AND #{postEnd}</when><otherwise>SELECT * FROM(SELECT ROWNUM NUM, SB.* FROM(SELECT * FROM SHOP ORDER BY NUM DESC)SB)WHERE NUM BETWEEN #{postStart} AND #{postEnd}</otherwise></choose></select><select id&#61;&#34;searchCount&#34; resultType&#61;&#34;int&#34;> <choose> <when test&#61;&#34;searchShopWord &#61;&#61; 'itemname' or searchShopWord &#61;&#61; 'company' or searchShopWord &#61;&#61; 'contents'&#34;> SELECT COUNT(*) FROM SHOP WHERE ${searchWord} LIKE '%' || #{key} || '%' </when> <when test&#61;&#34;searchShopWord &#61;&#61; 'itemnameAndContents'&#34;> SELECT COUNT(*) FROM SHOP WHERE ITEMNAME LIKE '%' || #{key} || '%' OR CONTENTS LIKE '%' || #{key} || '%' </when> <otherwise> SELECT COUNT(*) FROM SHOP </otherwise> </choose> </select>

하루의_spring · Answer

열의 정의가 애매한것은 테이블 여러곳을 사용할때 동일한 컬럼명이 존재해서 그렇습니다 지금처럼 * 을 사용하지 말고 필요한 컬럼을 올리는 방식으로 사용하세요

Spring framwork 프로젝트중 페이징에서 열의 정의가 애매합니다가 떴는데 이유를 모르겠네요

1개의 답변

#paging 목록