ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ¾È³»¼­

PerlÀÇ ¸Å°³º¯¼ö Ç¥½Ã¹®ÀÚ

ÁöÁ¤µÈ Çʵ忡 ´ëÇØ ¿©·¯ ÀÔ·Â °ªÀ» »ç¿ëÇÏ¿© ÁغñµÈ ¸í·É¹®À» ½ÇÇàÇÏ·Á¸é Perl DBI ¸ðµâÀº »ç¿ëÀÚ°¡ ¸Å°³º¯¼ö Ç¥½Ã¹®ÀÚ¸¦ »ç¿ëÇÏ¿© ¸í·É¹®À» ÁغñÇÏ°í ½ÇÇàÇÒ ¼ö ÀÖ°Ô ÇÕ´Ï´Ù. SQl¹®¿¡ ¸Å°³º¯¼ö Ç¥½Ã¹®ÀÚ¸¦ Æ÷ÇÔ½ÃŰ·Á¸é ¹°À½Ç¥(?) ¹®ÀÚ¸¦ »ç¿ëÇϽʽÿÀ.

´ÙÀ½ Perl ÄÚµå´Â SELECT¹®ÀÇ WHEREÀý¿¡ ´ëÇØ ¸Å°³º¯¼ö Ç¥½Ã¹®ÀÚ¸¦ ½ÂÀÎÇÏ´Â ¸í·É¹® ÇÚµéÀ» ÀÛ¼ºÇÕ´Ï´Ù. ±×·¯¸é ÄÚµå´Â ¸Å°³º¯¼ö Ç¥½Ã¹®ÀÚ¸¦ ¹Ù²Ù±â À§ÇØ ÀÔ·Â °ª 25000°ú 35000À» µÎ¹ø »ç¿ëÇÏ¿© ¸í·É¹®À» ½ÇÇàÇÕ´Ï´Ù.

   my $sth = $dbhandle->prepare(
      'SELECT firstnme, lastname
         FROM employee
         WHERE salary > ?'
      );
 
   my $rc = $sth->execute(25000);
   
·
·
·
my $rc = $sth->execute(35000);


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]