»Ë»Ñ Æ÷·³
°³¹ßÀÚÆ÷·³ ÀÔ´Ï´Ù.
  • ºÏ¸¶Å© ¾ÆÀÌÄÜ

spring sql¹®Á» µµ¿ÍÁÖ¼¼¿ä ..4

  • f-orest
  • µî·ÏÀÏ 2015-06-19 19:05
  • Á¶È¸¼ö 1058
½ÅÀÔ
1~2³â
..
4~5³â
5³âÀÌ»ó..

<select id=career" parameterType="Map" resultType="CompanyDTO">
                select * from recruit
        <where>
        <if test="first != null">career<![CDATA[>=]]>#{first}</if>        
        <if test="last != null">and career<![CDATA[<=]]>#{last}</if>
        </where>
</select>
DBÀÇ career Ä÷³ÀÇ Å¸ÀÔÀº varchar2ÀÔ´Ï´Ù.
¸Ê°´Ã¼¿¡ ´ã¾Æ¼­ °ªÀ» ³Ñ±æ¶§  
companyCareerList.do?first=2&last=3
first=2 , last=3 À̸é 2~3 °ª¸¸ ³ª¿Í¾ßÇϴµ¥

first °ªÀÌ ÀνÄÀ̾ȵǰí , last °ªÀÌ ÀνĵǾî
1~3ÀÇ °á°ú°ªÀÌ ³ª¿Í¼­ ¸Ó¸®ºüÁö°íÀÖ½À´Ï´Ù..
ÇØ°á¹æ¹ýÁ» ¾Ë·ÁÁÖ¼¼¿ä

0
ÃßõÇϱ⠴ٸ¥ÀÇ°ß 0
|
°øÀ¯¹öÆ°

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 ½Ä»óÇØ

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 f-orest

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 [* ºñȸ¿ø *]

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 f-orest
  • ¾Ë¸² ¿å¼³, »óó ÁÙ ¼ö ÀÖ´Â ¾ÇÇÃÀº »ï°¡ÁÖ¼¼¿ä.
©¹æ »çÁø  
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û ¸ñ·Ïº¸±â