SELECT a.*, b.`level` FROM `km_product` AS a
JOIN `km_member` AS b ON a.`seller` = b.`uid`
WHERE `cate1`=#{cate1} AND `cate2`=#{cate2}
ORDER BY ${order} DESC LIMIT #{start}, 10;
ORDER BY `price` ASC LIMIT #{start}, 10;
">
SELECT a.*, b.`level` FROM `km_product` AS a
JOIN `km_member` AS b ON a.`seller` = b.`uid`
WHERE `cate1`=#{cate1} AND `cate2`=#{cate2}
ORDER BY ${order} DESC LIMIT #{start}, 10;
ORDER BY `price` ASC LIMIT #{start}, 10;
">
SELECT a.*, b.`level` FROM `km_product` AS a
JOIN `km_member` AS b ON a.`seller` = b.`uid`
WHERE `cate1`=#{cate1} AND `cate2`=#{cate2}
ORDER BY ${order} DESC LIMIT #{start}, 10;
ORDER BY `price` ASC LIMIT #{start}, 10;
">
<select id="selectProductsByCate" resultType="ProductVO">
SELECT a.*, b.`level` FROM `km_product` AS a
JOIN `km_member` AS b ON a.`seller` = b.`uid`
WHERE `cate1`=#{cate1} AND `cate2`=#{cate2}
<if test="order != 'lowprice'.toString()">
ORDER BY ${order} DESC LIMIT #{start}, 10;
</if>
<if test="order == 'lowprice'.toString()">
ORDER BY `price` ASC LIMIT #{start}, 10;
</if>
</select>
<!--
#{}의 경우 자동으로 '값' 형태가 된다.
${}의 경우 그대로 들어오므로 테이블이나 컬럼명을 동적으로 사용 가능하다.
-->