¿ìËÙÒµÎñͨµÀ

ͨ¹ý»º´æÊý¾Ý¿â½á¹ûÌá¸ßPHPÐÔÄÜ

×÷Õß ØýÃû¼¼Êõ À´Ô´ NET±à³Ì ä¯ÀÀ ·¢²¼Ê±¼ä 2012-05-25
PL/SQL ¿é£¬ËüΪ orders_nf_callback ֪ͨ´¦Àí³ÌÐò´´½¨²éѯע²á¡£

¡¡¡¡Çåµ¥ 3. Ϊ֪ͨ´¦Àí³ÌÐò´´½¨²éѯע²á

DECLARE
REGDS SYS.CHNF ͨ¹ý»º´æÊý¾Ý¿â½á¹ûÌá¸ßPHPÐÔÄÜ - ÁèÖڿƼ¼

¿ìËÙÒµÎñͨµÀ

ͨ¹ý»º´æÊý¾Ý¿â½á¹ûÌá¸ßPHPÐÔÄÜ

×÷Õß ØýÃû¼¼Êõ À´Ô´ NET±à³Ì ä¯ÀÀ ·¢²¼Ê±¼ä 2012-05-25
content

ÁèÖڿƼ¼×¨ÒµÌṩ·þÎñÆ÷×âÓᢷþÎñÆ÷Íйܡ¢ÆóÒµÓʾ֡¢ÐéÄâÖ÷»úµÈ·þÎñ£¬¹«Ë¾ÍøÕ¾£ºhttp://www.lingzhong.cn ΪÁ˸ø¹ã´ó¿Í»§Á˽â¸ü¶àµÄ¼¼ÊõÐÅÏ¢£¬±¾¼¼ÊõÎÄÕÂÊÕ¼¯À´Ô´ÓÚÍøÂç,ÁèÖڿƼ¼×ðÖØÎÄÕÂ×÷ÕߵİæȨ£¬Èç¹ûÓÐÉæ¼°ÄãµÄ°æȨÓбØҪɾ³ýÄãµÄÎÄÕ£¬ÇëºÍÎÒÃÇÁªÏµ¡£ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúҪתÔر¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!

·ÖÏíµ½£º ¸ü¶à
Äã¿ÉÄܶÔÏÂÃæµÄÎÄÕ¸ÐÐËȤ
    HTTP/1.1 401 Access Denied

Copyright ©1999-2011 ÏÃÃÅÁèÖڿƼ¼ÓÐÏÞ¹«Ë¾ ÏÃÃÅÓÅͨ»¥Áª¿Æ¼¼¿ª·¢ÓÐÏÞ¹«Ë¾ All rights reserved

µØÖ·(ADD)£ºÏÃÃÅÈí¼þÔ°¶þÆÚÍûº£Â·63ºÅ701E£¨¶«ÄÏÈÚͨÅÔ£© Óʱà(ZIP)£º361008

µç»°£º0592-5908028 ´«Õ棺0592-5908039 ×ÉѯÐÅÏ䣺web@lingzhong.cn ×ÉѯOICQ£º173723134

¡¶ÖлªÈËÃñ¹²ºÍ¹úÔöÖµµçÐÅÒµÎñ¾­ÓªÐí¿ÉÖ¤¡·ÃöB2-20100024  ICP±¸°¸:ÃöICP±¸05037997ºÅ

REG_INFO;
regid NUMBER;
ord_id NUMBER;
qosflags NUMBER;
BEGIN
qosflags := DBMS_CHANGE_NOTIFICATION.QOS_RELIABLE + 
DBMS_CHANGE_NOTIFICATION.QOS_ROWIDS;
REGDS := SYS.CHNF ͨ¹ý»º´æÊý¾Ý¿â½á¹ûÌá¸ßPHPÐÔÄÜ - ÁèÖڿƼ¼
¿ìËÙÒµÎñͨµÀ

ͨ¹ý»º´æÊý¾Ý¿â½á¹ûÌá¸ßPHPÐÔÄÜ

×÷Õß ØýÃû¼¼Êõ À´Ô´ NET±à³Ì ä¯ÀÀ ·¢²¼Ê±¼ä 2012-05-25
content

ÁèÖڿƼ¼×¨ÒµÌṩ·þÎñÆ÷×âÓᢷþÎñÆ÷Íйܡ¢ÆóÒµÓʾ֡¢ÐéÄâÖ÷»úµÈ·þÎñ£¬¹«Ë¾ÍøÕ¾£ºhttp://www.lingzhong.cn ΪÁ˸ø¹ã´ó¿Í»§Á˽â¸ü¶àµÄ¼¼ÊõÐÅÏ¢£¬±¾¼¼ÊõÎÄÕÂÊÕ¼¯À´Ô´ÓÚÍøÂç,ÁèÖڿƼ¼×ðÖØÎÄÕÂ×÷ÕߵİæȨ£¬Èç¹ûÓÐÉæ¼°ÄãµÄ°æȨÓбØҪɾ³ýÄãµÄÎÄÕ£¬ÇëºÍÎÒÃÇÁªÏµ¡£ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúҪתÔر¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!

·ÖÏíµ½£º ¸ü¶à
Äã¿ÉÄܶÔÏÂÃæµÄÎÄÕ¸ÐÐËȤ

Copyright ©1999-2011 ÏÃÃÅÁèÖڿƼ¼ÓÐÏÞ¹«Ë¾ ÏÃÃÅÓÅͨ»¥Áª¿Æ¼¼¿ª·¢ÓÐÏÞ¹«Ë¾ All rights reserved

µØÖ·(ADD)£ºÏÃÃÅÈí¼þÔ°¶þÆÚÍûº£Â·63ºÅ701E£¨¶«ÄÏÈÚͨÅÔ£© Óʱà(ZIP)£º361008

µç»°£º0592-5908028 ´«Õ棺0592-5908039 ×ÉѯÐÅÏ䣺web@lingzhong.cn ×ÉѯOICQ£º173723134

¡¶ÖлªÈËÃñ¹²ºÍ¹úÔöÖµµçÐÅÒµÎñ¾­ÓªÐí¿ÉÖ¤¡·ÃöB2-20100024  ICP±¸°¸:ÃöICP±¸05037997ºÅ

REG_INFO (''orders_nf_callback'', qosflags, 0,0,0);
regid := DBMS_CHANGE_NOTIFICATION.NEW_REG_START (REGDS);
SELECT order_id INTO ord_id FROM orders WHERE ROWNUM£¼2;
DBMS_CHANGE_NOTIFICATION.REG_END;
END;
/
¡¡¡¡±¾Ê¾ÀýÕë¶Ô ORDERS ±í´´½¨ÁËÒ»¸ö×¢²á£¬²¢½« orders_nf_callback ÓÃ×÷֪ͨ´¦Àí³ÌÐò¡£ÏÖÔÚ£¬Èç¹ûÄúʹÓà DML »ò DDL Óï¾äÐÞ¸Ä ORDERS ±í²¢Ìá½»ÊÂÎñ£¬Ôò½«×Ô¶¯µ÷Óà orders_nf_callback º¯Êý¡£ÀýÈ磬Äú¿ÉÄÜÕë¶Ô ORDERS ±íÖ´ÐÐÏÂÁÐ UPDATE Óï¾ä²¢Ìá½»¸ÃÊÂÎñ£º

UPDATE ORDERS SET order_mode = ''direct'' WHERE order_id=2421;
UPDATE ORDERS SET order_mode = ''direct'' WHERE order_id=2422;
COMMIT;
¡¡¡¡ÒªÈ·±£Êý¾Ý¿â·¢²¼ÁË֪ͨÀ´ÏìÓ¦ÒÔÉÏÊÂÎñ£¬Äú¿ÉÒÔ¼ì²é nfresults ±í£º

SELECT TO_CHAR(operdate, ''dd-mon-yy hh:mi:ss'') operdate, 
tblname, rslt_msg FROM nfresults;
¡¡¡¡½á¹ûÓ¦ÈçÏÂËùʾ£º

OPERDATE              TBLNAME     RSLT_MSG
--------------------- ----------- ---------
02-mar-06 04:31:28    OE.ORDERS   Not Found
02-mar-06 04:31:29    OE.ORDERS   Not Found
¡¡¡¡´ÓÒÔÉϽá¹ûÖпÉÒÔÇå³þµØ¿´µ½£¬orders_nf_callback ÒѾ­Õý³£¹¤×÷£¬µ«Î´ÕÒµ½¿Í»§¶Ë½Å±¾¡£ÔÚ¸ÃʾÀýÖгöÏÖÕâÖÖÇé¿ö²¢²»ÒâÍ⣬ÕâÊÇÒòΪÄú²¢Î´´´½¨ URL ÖÐÖ¸¶¨µÄ dropResults.php ½Å±¾¡£ÓÐ¹Ø dropResults.php ½Å±¾µÄ˵Ã÷£¬Çë²ÎÔı¾ÎĺóÃæµÄ¹¹½¨¿Í»§¶Ë ²¿·Ö¡£

½«±íÌí¼Óµ½ÏÖÓÐ×¢²á

¡¡¡¡Ç°Ò»²¿·Ö½éÉÜÁËÈçºÎʹÓøü¸Ä֪ͨ·þÎñʹÊý¾Ý¿âÔÚ×¢²á¶ÔÏó£¨ÔÚÒÔÉÏʾÀýÖÐΪ ORDERS ±í£©·¢Éú¸ü¸Äʱ·¢³ö֪ͨ¡£µ«´ÓÐÔÄܽǶȶøÑÔ£¬¿Í»§¶ËÓ¦ÓóÌÐò¿ÉÄܸüÏ£Íû»º´æ ORDER_ITEMS ±í¶ø·Ç ORDERS ±í±¾ÉíµÄ²éѯ½á¹û¼¯£¬ÕâÊÇÒòΪËüÔÚÿ´Î·ÃÎʶ©µ¥Ê±£¬²»µÃ²»´Ó ORDERS ±íÖÐÖ»¼ìË÷Ò»ÐУ¬µ«Í¬Ê±±ØÐë´Ó ORDER_ITEMS ±íÖмìË÷¶à¸öÐС£ÔÚʵ¼ÊÇé¿öÖУ¬¶©µ¥¿ÉÄÜ°üº¬ÊýÊ®¸öÉõÖÁÊý°Ù¸ö¶©µ¥Ïî¡£

¡¡¡¡ÓÉÓÚÄúÒѾ­¶Ô ORDERS ±í×¢²áÁ˲éѯ£¬Òò´Ë²»±ØÔÙ´´½¨Ò»¸ö×¢²áÀ´×¢²á¶Ô ORDER_ITEMS ±íµÄ²éѯÁË¡£Ïà·´£¬Äú¿ÉÒÔʹÓÃÏÖÓÐ×¢²á¡£Îª´Ë£¬ÄúÊ×ÏÈÐèÒª¼ìË÷ÏÖÓÐ×¢²áµÄ ID¡£¿ÉÒÔÖ´ÐÐÒÔϲéѯÀ´Íê³É´Ë¹¤×÷£º

SELECT regid, table_name FROM user_change_notification_regs;¡¡¡¡½á¹û¿ÉÄÜÈçÏÂËùʾ£º

REGID TABLE_NAME
----- --------------
241 OE.ORDERS
¡¡¡¡»ñȡע²á ID ºó£¬¿ÉÒÔʹÓà DBMS_CHANGE_NOTIFICATION.ENABLE_REG º¯Êý½«Ò»¸öжÔÏóÌí¼Óµ½¸Ã×¢²á£¬ÈçÏÂËùʾ£º

DECLARE
ord_id NUMBER;
BEGIN
DBMS_CHANGE_NOTIFICATION.ENABLE_REG(241);
SELECT order_id INTO ord_id FROM order_items WHERE ROWNUM £¼ 2;
DBMS_CHANGE_NOTIFICATION.REG_END;
END;
/
¡¡¡¡Íê³ÉÁË£¡´ÓÏÖÔÚ¿ªÊ¼£¬Êý¾Ý¿â½«Éú³ÉÒ»¸ö֪ͨÀ´ÏìÓ¦¶Ô ORDERS ºÍ ORDER_ITEMS Ëù×öµÄÈκθü¸Ä£¬²¢µ÷Óà orders_nf_callback ¹ý³ÌÀ´´¦Àí֪ͨ¡£Òò´Ë£¬ÏÂÒ»²½¾ÍÊDZ༭ orders_nf_callback£¬ÒÔ±ãËü¿ÉÒÔ´¦ÀíÒò¶Ô ORDER_ITEMS ±íÖ´ÐÐ DML ²Ù×÷¶øÉú³ÉµÄ֪ͨ¡£µ«ÔÚÖØд´½¨ orders_nf_callback ¹ý³Ì֮ǰ£¬ÄúÐèÒª´´½¨ÒÔϽ«ÔÚ¸üйý³ÌÖÐÒýÓõıíÀàÐÍ£º

CREATE TYPE rdesc_tab AS TABLE OF SYS.CHNF ͨ¹ý»º´æÊý¾Ý¿â½á¹ûÌá¸ßPHPÐÔÄÜ - ÁèÖڿƼ¼

¿ìËÙÒµÎñͨµÀ

ͨ¹ý»º´æÊý¾Ý¿â½á¹ûÌá¸ßPHPÐÔÄÜ

×÷Õß ØýÃû¼¼Êõ À´Ô´ NET±à³Ì ä¯ÀÀ ·¢²¼Ê±¼ä 2012-05-25
content

ÁèÖڿƼ¼×¨ÒµÌṩ·þÎñÆ÷×âÓᢷþÎñÆ÷Íйܡ¢ÆóÒµÓʾ֡¢ÐéÄâÖ÷»úµÈ·þÎñ£¬¹«Ë¾ÍøÕ¾£ºhttp://www.lingzhong.cn ΪÁ˸ø¹ã´ó¿Í»§Á˽â¸ü¶àµÄ¼¼ÊõÐÅÏ¢£¬±¾¼¼ÊõÎÄÕÂÊÕ¼¯À´Ô´ÓÚÍøÂç,ÁèÖڿƼ¼×ðÖØÎÄÕÂ×÷ÕߵİæȨ£¬Èç¹ûÓÐÉæ¼°ÄãµÄ°æȨÓбØҪɾ³ýÄãµÄÎÄÕ£¬ÇëºÍÎÒÃÇÁªÏµ¡£ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúҪתÔر¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!

·ÖÏíµ½£º ¸ü¶à
HTTP/1.1 401 Access Denied ±à³ÌÈëÃÅÍø" target="_blank">iBATIS 3ÄÚµÄÐÂÌØÐÔ£º½«iBATISÓÃ×÷Ó¦ÓóÌÐòÄÚµÄÒ»Öֳ־ÿò¼Ü - ±à³ÌÈëÃÅÍø
  • Photoshop»æÖƸ߹âË®¾§ÖʸÐË®¾§Æ»¹û
  • Copyright ©1999-2011 ÏÃÃÅÁèÖڿƼ¼ÓÐÏÞ¹«Ë¾ ÏÃÃÅÓÅͨ»¥Áª¿Æ¼¼¿ª·¢ÓÐÏÞ¹«Ë¾ All rights reserved

    µØÖ·(ADD)£ºÏÃÃÅÈí¼þÔ°¶þÆÚÍûº£Â·63ºÅ701E£¨¶«ÄÏÈÚͨÅÔ£© Óʱà(ZIP)£º361008

    µç»°£º0592-5908028 ´«Õ棺0592-5908039 ×ÉѯÐÅÏ䣺web@lingzhong.cn ×ÉѯOICQ£º173723134

    ¡¶ÖлªÈËÃñ¹²ºÍ¹úÔöÖµµçÐÅÒµÎñ¾­ÓªÐí¿ÉÖ¤¡·ÃöB2-20100024  ICP±¸°¸:ÃöICP±¸05037997ºÅ

    RDESC;¡¡¡¡È»ºó£¬·µ»ØÇåµ¥ 2£¬ÔÚÒÔÏ´úÂëÐÐÖ®

    ÁèÖڿƼ¼×¨ÒµÌṩ·þÎñÆ÷×âÓᢷþÎñÆ÷Íйܡ¢ÆóÒµÓʾ֡¢ÐéÄâÖ÷»úµÈ·þÎñ£¬¹«Ë¾ÍøÕ¾£ºhttp://www.lingzhong.cn ΪÁ˸ø¹ã´ó¿Í»§Á˽â¸ü¶àµÄ¼¼ÊõÐÅÏ¢£¬±¾¼¼ÊõÎÄÕÂÊÕ¼¯À´Ô´ÓÚÍøÂç,ÁèÖڿƼ¼×ðÖØÎÄÕÂ×÷ÕߵİæȨ£¬Èç¹ûÓÐÉæ¼°ÄãµÄ°æȨÓбØҪɾ³ýÄãµÄÎÄÕ£¬ÇëºÍÎÒÃÇÁªÏµ¡£ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúҪתÔر¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!

    tm" title="LinuxϵÄVsftpdÅäÖÃƪ" target="_blank">LinuxϵÄVsftpdÅäÖÃƪ
  • DIVºÍtableÒ³Ãæ²¼¾ÖµÄÇø±ðºÍÁªÏµ
  • ÈçºÎʵÏÖ¶þάÏòÁ¿ - ±à³ÌÈëÃÅÍø
  • ÍøÂçÓªÏú¹«Ë¾ÔÚÔËÓªÖеIJßÂÔ
  • iBATIS 3ÄÚµÄÐÂÌØÐÔ£º½«iBATISÓÃ×÷Ó¦ÓóÌÐòÄÚµÄÒ»Öֳ־ÿò¼Ü - ±à³ÌÈëÃÅÍø
  • Photoshop»æÖƸ߹âË®¾§ÖʸÐË®¾§Æ»¹û
  • Copyright ©1999-2011 ÏÃÃÅÁèÖڿƼ¼ÓÐÏÞ¹«Ë¾ ÏÃÃÅÓÅͨ»¥Áª¿Æ¼¼¿ª·¢ÓÐÏÞ¹«Ë¾ All rights reserved

    µØÖ·(ADD)£ºÏÃÃÅÈí¼þÔ°¶þÆÚÍûº£Â·63ºÅ701E£¨¶«ÄÏÈÚͨÅÔ£© Óʱà(ZIP)£º361008

    µç»°£º0592-5908028 ´«Õ棺0592-5908039 ×ÉѯÐÅÏ䣺web@lingzhong.cn ×ÉѯOICQ£º173723134

    ¡¶ÖлªÈËÃñ¹²ºÍ¹úÔöÖµµçÐÅÒµÎñ¾­ÓªÐí¿ÉÖ¤¡·ÃöB2-20100024  ICP±¸°¸:ÃöICP±¸05037997ºÅ