[Error] 쇼핑몰 목록페이지

목록 페이지에 판매 금액 , 남은 수량 표시가 안된다,,,

 

Mapper.xml 에서 value 넣어주니 error 해결!

<!-- 글 목록 -->
	<select id="selectList" parameterType="map" resultType="kitVO">
		SELECT
		*
		FROM (SELECT
				a.*,
			rownum rnum
		FROM (SELECT 
					k.kit_num,
		<![CDATA[REPLACE(REPLACE(k.kit_name, '<', '&lt;'),'>','&gt;') kit_name,]]>
					k.kit_price,
					k.kit_quantity,
					k.reg_date,
					k.hit,
					u.user_num
				 FROM okit k 
				 JOIN ouser	u 
				 ON k.user_num = u.user_num
				 	<where>
			 			<if test="keyword!='' and keyfield==1">	
			 				k.kit_name LIKE '%' || #{keyword} || '%'
			 			</if>
			 			<if test="keyword!='' and keyfield==2">
			 				u.user_num LIKE '%' || #{keyword} || '%'
			 			</if>
			 			<if test="keyword!='' and keyfield==3">
			 				k.kit_content LIKE '%' || #{keyword} || '%'
			 			</if>
			 			<if test="keyword!='' and keyfield==4">
			 				k.kit_name LIKE '%' || #{keyword} || '%' or
			 				k.kit_content LIKE '%' || #{keyword} || '%'
			 			</if>
			 		</where>
			 		
				 ORDER BY k.kit_num DESC)a)
		 	 
		<![CDATA[WHERE rnum >= #{start} AND rnum <= #{end}]]>
	</select>