ÀÌÀü Ç׸ñ´ÙÀ½ Ç׸ñ


µ¿Àû Á¶È¸ Á¤ÀÇ ¹æ¹ý

  1. µ¥ÀÌÅÍ ¼¼Æ®ÀÇ Á¶È¸ ÆäÀÌÁö¿¡¼­ ´ÙÀ½°ú °°ÀÌ SQL Á¶È¸¸¦ Á¤ÀÇÇϽʽÿÀ.
  2. SELECT CUSTOMERNAME FROM CUSTOMERS 
    
  3. º¸°í¼­ ·¹À̾ƿô¿¡¼­ ÀÌ µ¥ÀÌÅÍ ¼¼Æ®¸¦ »ç¿ëÇÏ´Â Å×À̺íÀ» ÀÛ¼ºÇϽʽÿÀ.
  4. º¸°í¼­ ¸Å°³º¯¼ö(¿¹: "passName"À̶ó°í ÇÏ´Â ¹®ÀÚ¿­ ¸Å°³º¯¼ö)¸¦ ÀÛ¼ºÇϽʽÿÀ.
  5. µ¥ÀÌÅÍ ¼¼Æ® ÆíÁý¿¡¼­ Ư¼º ¹ÙÀεùÀ» ¼±ÅÃÇÏ°í »ç¿ëÀÚ°¡ ÀÛ¼ºÇÑ º¸°í¼­ ¸Å°³º¯¼ö¸¦ »ç¿ëÇϱâ À§ÇÑ Á¶È¸ ÅØ½ºÆ®¸¦ Á¤ÀÇÇϽʽÿÀ.
  6. "SELECT CustomerName From CUSTOMERS WHERE CustomerName LIKE 
    " + params["passName"]  
    
  7. È®ÀÎÀ» ¼±ÅÃÇϽʽÿÀ.

(c) Copyright Actuate Corporation 2006

ÀÌÀü Ç׸ñ´ÙÀ½ Ç׸ñ