ÁöÁ¤µÈ Çʵ忡 ´ëÇØ ¿©·¯ ÀÔ·Â °ªÀ» »ç¿ëÇÏ¿© ÁغñµÈ ¸í·É¹®À» ½ÇÇàÇÏ·Á¸é 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);