IBM Books

Net.Data ÂüÁ¶¼­

¼û°ÜÁø º¯¼ö


AIX HP-UX OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X

¼û°ÜÁø º¯¼ö¸¦ ÅëÇØ HTML ¼Ò½º¿¡ ½ÇÁ¦ º¯¼ö °ªÀÌ ¼û°ÜÁ® ÀÖ´Â °æ¿ì¿¡µµ º¯¼ö¸¦ ÂüÁ¶ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¼û°ÜÁø º¯¼ö¸¦ »ç¿ëÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.

  1. ¼û±â·Á´Â °¢ ¹®ÀÚ¿­¿¡ ´ëÇØ º¯¼ö¸¦ Á¤ÀÇÇϽʽÿÀ.

  2. º¯¼ö¸¦ ÂüÁ¶ÇÏ·Á¸é, º¯¼ö°¡ ÂüÁ¶µÇ´Â HTML ºí·Ï¿¡¼­ ÇϳªÀÇ ´Þ·¯ ±âÈ£ ´ë½Å µÎ °³ÀÇ ´Þ·¯ ±âÈ£¸¦ »ç¿ëÇϽʽÿÀ. ¿¹¸¦ µé¸é, $(X) ´ë½Å $$(X)¸¦ »ç¿ëÇϽʽÿÀ.

¿¹Á¦ 1: HTML Çü½ÄÀ¸·Î ¼û°ÜÁø º¯¼ö

%HTML(INPUT){
<FORM ...>
<P>Select fields to view:
<SELECT NAME="Field">
<OPTION VALUE="$$(name)"> Name
<OPTION VALUE="$$(addr)"> Address
.
.
.
</FORM>
%}
 
%DEFINE{
name="customer.name"
addr="customer.address"
%}
 
%FUNCTION(DTW_SQL) mySelect() {
  SELECT $(Field) FROM customer
%}
.
.
.

HTML Çü½ÄÀÌ À¥ ºê¶ó¿ìÀú¿¡ ³ªÅ¸³ª¸é $$(name) ¿Í $$(addr)°¡ °¢°¢ $(name) ¿Í $(addr)·Î ´ëüµÇ¾î ½ÇÁ¦ Å×ÀÌºí ¹× Ä÷³¸íÀÌ HTML Çü½ÄÀ¸·Î ³ªÅ¸³ªÁö ¾ÊÀ¸¹Ç·Î ½ÇÁ¦ º¯¼ö¸íÀÌ ¼û°ÜÁ® ÀÖ´Ù´Â »ç½ÇÀ» ¾Æ¹«µµ ¾Ë ¼ö ¾ø½À´Ï´Ù. »ç¿ëÀÚ°¡ ¾ç½ÄÀ» Á¦ÃâÇϸé, HTML(REPORT) ºí·ÏÀÌ È£ÃâµË´Ï´Ù. @mySelect()°¡ FUNCTION ºí·ÏÀ» È£ÃâÇϸé $(Field)´Â SQL¹®¿¡¼­´Â customer.nameÀ¸·Î, SQL Á¶È¸¿¡¼­´Â customer.addr·Î ´ëüµË´Ï´Ù.


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