backward forwad Contents

Class #11: Ŭ¶óÀ̾ðÆ®/¼­¹ö µ¥ÀÌŸº£À̽º °³¹ß (2)
in place May 9, 2002, lasted modified May 9, 2002, working


Ŭ¶óÀ̾ðÆ® ¼­¹ö ¸ðµ¨

°èÃþ ¸ðµ¨

°£´ÜÇÑ Å¬¶óÀ̾ðÆ®/¼­¹ö ÇÁ·Î±×·¥ ¸¸µé±â

µ¥ÀÌŸº£À̽º ÀÛ¼º (ACCESS)

  • ÇÊ¿äÇÑ View »ý¼º - ¼÷Á¦ Á¦Ãâ ÇöȲ¿¡ ´ëÇÑ ÀÀ¿ë ÇÁ·Î±×·¥
    	SELECT CLASS.class_no, STUDENT.std_id, CLASS.class_name, STUDENT.std_name,
    	HOMEWORK.title, HOMEWORK.create_date, COURSE.year, HOMEWORK.path, COURSE.season
    	FROM  STUDENT, CLASS, COURSE, HOMEWORK 
    	WHERE 
    	CLASS.class_id = COURSE.class_id AND STUDENT.std_id = COURSE.std_id
       	AND COURSE.ID = HOMEWORK.course_id
       	AND CLASS.class_id = 2
    
    	

    µ¥ÀÌŸº£À̽º Connection ÀÛ¼º (ODBC)

    • ÀÏÁ¾ÀÇ ¹Ìµé¿þ¾îÀÎ ODBC¸¦ ÀÌ¿ëÇÏ¿© µ¥ÀÌŸº£À̽º Connection »ý¼º

      fig 11-4
      ±×¸² 11-4 ODBC ¼³Á¤

    ÇÁ·Î±×·¥ ÀÛ¼º (2 tier)

    • Form ÀÛ¼º - °¢Á¾ ControlÀÇ ¼Ó¼º Á¶Á¤
    • Database Connection Componet ¿¬°á - ODBC
    • Database Connection Componet ¿¬°á - SQL Query ¼³Á¤
    • Display Control¿¡ Database Connection ¿¬µ¿

      fig 11-5
      ±×¸² 11-5 µ¥ÀÌŸº£À̽º ¼÷Á¦Á¦Ãâ »óȲ Form ¼³Á¤

  • backward forwad Contents


    Knowledge & Engineering Databases (c) copyright Namchul Do, 2002