14. ±â Ÿ


14.1 Stored Procedure

 DBMS¿¡ ÀúÀåµÈ procedure¸¦ ºÒ·¯¼­ »ç¿ëÇÒ ¼ö ÀÖ´Ù. »ç¿ëÇϱâ À§Çؼ­´Â ¸ÕÀú prototypeÀ» Á¤ÀÇÇÏ°í³ª¼­ ºÒ·¯¼­ ¾µ ¼ö ÀÖ´Ù.

  • prototypeÁ¤ÀÇ

      checkpass¶ó´Â stroed procedure°¡ Àִµ¥, 2°³ÀÇ input°ªÀ» ¹Þ°í ¸®ÅÏ°ªÀÌ Çϳª ÀÖ´Ù¸é,

    database.stroedProcArgs("checkpass", "IN", "IN", "OUT");
      stored procedure¸¦ ÀÛ¼ºÇÒ ¶§ Àμö¸¦ ¼³Á¤Çϴµ¥, ±×¼ø¼­¸¦ ±×´ë·Î »ç¿ëÇÏ¸é µÈ´Ù. IN, OUT, INOUTÀÇ ¼¼°¡Áö °ªÀÌ ÀÖ´Ù.

  • »ç ¿ë

      ´ÙÀ½°ú °°ÀÌ storedPorc¶ó´Â ÇÔ¼ö¸¦ ÅëÇؼ­ »ç¿ëÇÏ¸é µÈ´Ù.

    result = database.storedProc("checkpass", "Father", 10);


14.2 ¿ÜºÎÇÔ¼ö È£Ãâ( C ÇÔ¼ö È£Ãâ )

  • µî ·Ï

      °£´ÜÈ÷ ¸»ÇÏÀÚ¸é, C·Î ÀÛ¼ºµÈ ¾î¶² ÇÔ¼ö¸¦ º°µµÀÇ À̸§À» Á־ È£ÃâÇÏ¿© »ç¿ëÇÒ ¼ö ÀÖ°Ô µÈ´Ù.

    registerCFunction(JSFunctionName, librarayPath, CFunctionName);
  • »ç ¿ë

    callC(JSFunctionName, arguments);
    cfun = registerCFunction("test","c:\temp\test.dll", "getParam");
    if( cfun == true ){
        result = callC("test", "first Agr", 22, "arg..");

        write(result);
    }

- Last Update : 2001.7.5 by Deadfire(http://www.deadfire.net)

LiveWire °­ÁÂ
LiveWire¶õ?
ÃÖÃÊ¿¹Á¦/µ¿ÀÛ¿ø¸®
½ÇÇàȯ°æ Áغñ
ÄÄÆÄÀÏ ¹× ½ÇÇà
SSJSÀÇ ±âº»
     - Function
     - Classes/Objects
     - »ç¿ë Tag
     - SSJSÀÇ Ã³¸®°úÁ¤
±âº» ÇÔ¼ö
Client To Server
     - FORM Tag
     - URL
Server To Client
     - FORM Tag
     - Cookie
Session
Client
Project/Server
File
Database
     - Database°í·Á»çÇ×
     - Function/¿¹Á¦
±â Ÿ
     - Stored Procedure
     - ¿ÜºÎÇÔ¼öÈ£Ãâ
¸¶Ä¡¸ç

Copyright ¨Ï 1997 ~, Deadfire Program Master