Ò»¡¢ÏµÍ³¼¯³É»ù´¡ÇéÐÎÉèÖÃ
ÈÕÆ¨Èí¼þÓëÆäËû¹¤¾ßʵÏÖÉî¶ÈÕûºÏµÄÌõ¼þÊÇÍê³Éµ×²ãÇéÐδ¡£ÔÚTJJÕ¾³¤ÖúÊÖ¿ØÖÆÌ¨ÖУ¬ÆôÓÃ"¿çƽ̨ͨѶģ¿é"£¬¸Ã¹¦Ð§Ö§³ÖTCP/IPÓëWebSocketË«ÐÒé´«Êä¡£ÇéÐαäÁ¿ÉèÖÃÐè×¢ÖØ·À»ðǽ¶Ë¿Ú¿ª·Å¹æÔò£¬½¨ÒéΪRPA»úеÈ˵¥¶À»®·Ö5000-6000¶Ë¿ÚÇø¼ä¡£ÉèÖÃÎļþ²ÎÊýÐèÓëÄ¿µÄϵͳµÄSDK°æ±¾¼á³Öͬ²½£¬OracleÊý¾Ý¿âÅþÁ¬×Ö·û´®µÄÃûÌÃУÑéÖ±½ÓÓ°ÏìÊý¾ÝǨáãµÄÎȹÌÐÔ¡£
¶þ¡¢API½Ó¿Ú¶Ô½ÓʵսÆÊÎö
¹¤¾ß¼¯³ÉµÄ½¹µã»·½ÚÔÚÓÚAPI½Ó¿ÚŲÓõľ«×¼¿ØÖÆ¡£Í¨¹ý·â×°RESTful½Ó¿ÚÄ£°å£¬¿ÉʵÏÖÈÕÆ¨Èí¼þÓëÖ÷Á÷CRMϵͳµÄË«ÏòÊý¾Ý½»»¥¡£Ïêϸ²Ù×÷Éæ¼°Èý¸öÒªº¦°ì·¨£ºÅ²ÓÃOAuth2.0ÊÚȨÐÒé»ñÈ¡»á¼ûÁîÅÆ£¨Access Token£©¡¢ÉèÖö¯Ì¬ÇëÇóÍ·²ÎÊý¡¢±àдJSONÊý¾ÝÆÊÎöÄ£¿é¡£ÔõÑùÔÚ´¦Öóͷ£429״̬ÂëʱʵÏÖÖÇÄÜÖØÊÔ»úÖÆ£¿ÕâÐèÒªÁ¬ÏµTJJÕ¾³¤ÖúÊÖµÄÁ÷Á¿¿ØÖÆÄ£¿é£¬ÉèÖÃ×Ô˳ӦÂÖѯ¾àÀëËã·¨À´¹æ±ÜЧÀÍÏÞÁ÷¡£
Èý¡¢Êý¾Ý¿âÁª¶¯ÉèÖü¼ÇÉ
Õë¶ÔMySQL¡¢PostgreSQLµÈ¹ØÏµÐÍÊý¾Ý¿âµÄÉî¶È¼¯³É£¬±ØÐ轨ÉèÊÂÎñ»Ø¹ö°ü¹Ü»úÖÆ¡£Í¨¹ýÉèÖÃ"Á½½×¶ÎÌá½»"ÐÒ飬¿ÉÈ·±£ÈÕÆ¨Èí¼þÔÚÊý¾Ýͬ²½Àú³ÌÖеÄÔ×ÓÐÔ²Ù×÷¡£ÅþÁ¬³Ø²ÎÊýµÄ¶¯Ì¬ÓÅ»¯Ö±½ÓÓ°ÏìϵͳÐÔÄÜ£¬½¨Ò齫max_pool_sizeÉèÖÃΪ»îÔ¾ÅþÁ¬ÊýµÄ1.5±¶¡£ÒªÌØÊâ×¢ÖØ×Ö·û¼¯±àÂëµÄÒ»ÖÂÐÔ£¬ÍƼöͳһʹÓÃUTF-8MB4ÃûÌÃÒÔ±ÜÃâÊý¾ÝÂÒÂëÎÊÌⱬ·¢¡£
ËÄ¡¢Í¼ÐνçÃæÔªËØ¾«×¼Æ¥Åä
µ±¼¯³ÉÐèÒª²Ù×÷GUI½çÃæµÄ¹Å°åÈí¼þʱ£¬½çÃæÔªËØµÄ¾«×¼¶¨Î»³ÉΪÊÖÒÕÄѵ㡣TJJÕ¾³¤ÖúÊÖÌṩµÄÔªËØÌ½²âÆ÷¹¤¾ß£¬¿Éͨ¹ýÌìÉúΨһXPath¶¨Î»·ûËø¶¨Ä¿µÄ¿Ø¼þ¡£Õë¶Ô¶¯Ì¬ÌìÉúµÄDOMÔªËØ£¬Ó¦ÆôÓÃÊÓ¾õÌØÕ÷Æ¥ÅäÊÖÒÕ£¬ÉèÖÃÏàËÆ¶ÈãÐÖµ¡Ý85%µÄÈÝ´í»úÖÆ¡£ÔõÑùÓ¦¶Ô½çÃæÇø·ÖÂÊת±äµ¼ÖµÄÔªËØÆ«ÒÆ£¿½¨Éè»ùÓÚCSSÑ¡ÔñÆ÷µÄ×Ô˳Ӧ½á¹¹¼à²âÄ£×ÓÄÜÓÐÓÃÌáÉý²Ù×÷ÀÖ³ÉÂÊ¡£
Î塢ϵͳȨÏÞ¼°Çå¾²ÉèÖÃ
¼¯³ÉÇéÐεÄÇå¾²·À»¤ÊÇÈ·±£×Ô¶¯»¯Á÷³ÌÎȹÌÔËÐеĻù´¡¡£ÔÚTJJÕ¾³¤ÖúÊÖµÄȨÏÞÖÎÀí½çÃæ£¬Ðè×ñÕÕ"×îСȨÏÞÔÔò"ÉèÖÃÓû§½ÇÉ«£¬½¨Ò齫²Ù×÷ȨÏÞϸ·ÖΪ¶ÁÈ¡¡¢Ð´Èë¡¢Ö´ÐÐÈý¸öÆ·¼¶¡£ÃÜÔ¿ÖÎÀíϵͳ±ØÐè½ÓÄÉAES-256¼ÓÃÜËã·¨´æ´¢Ãô¸ÐÐÅÏ¢£¬Í¬Ê±¿ªÆôË«ÒòËØÈÏÖ¤¹¦Ð§¡£°´ÆÚÖ´ÐÐÇå¾²Éó¼ÆÊ±£¬ÒªÌØÊâ×¢ÖØ¼ì²é¿çϵͳ»á¼ûÈÕÖ¾ÖеÄ401δÊÚȨÇëÇó¼Í¼¡£
Áù¡¢Òì³£´¦Öóͷ£ÓëÐÔÄÜÓÅ»¯
¹¹½¨½áʵµÄÒì³£´¦Öóͷ£ÏµÍ³ÊǼ¯³ÉÏîÄ¿µÄ×îÖÕÄ¥Á·¡£ÔÚTJJÕ¾³¤ÖúÊÖµÄÊÂÎñÖÎÀíÖÐÐÄ£¬ÉèÖÃÎå¼¶¸æ¾¯ÏìÓ¦»úÖÆ£º´Ó»ù´¡µÄÖØÊÔÕ½ÂÔµ½È˹¤½éÈëÁ÷³Ì¡£ÐÔÄÜ¼à¿Ø·½Ã棬ÐèÖØµã¹Ø×¢ÄÚ´æ×ß©µÄÔ¤·À£¬½¨Ò齫.NET FrameworkµÄÀ¬»ø½ÓÄÉģʽÉèÖÃΪ"ЧÀÍÆ÷ģʽ"¡£µ±Óöµ½ÍøÂçÑÓ³Ùµ¼Öµij¬Ê±¹ÊÕÏʱ£¬Í¨¹ý¶¯Ì¬µ÷½âTCP´°¿Ú¾ÞϸºÍÆôÓÃÊý¾ÝѹËõÐÒ飬¿É½«´«ÊäЧÂÊÌáÉý40%ÒÔÉÏ¡£
ͨ¹ý±¾Ö¸ÄϵÄϵͳÐÔ½â˵£¬ÈÕÆ¨Èí¼þÓëµÚÈý·½¹¤¾ß¼¯³ÉÒÑÐγɱê×¼»¯ÊµÑé·¾¶¡£ÕÆÎÕTJJÕ¾³¤ÖúÊֵĽ¹µã¹¦Ð§Ä£¿éºó£¬Óû§¿É¿ìËÙ¹¹½¨Ö§³Ö¶àϽµµÍª¶¯µÄ×Ô¶¯»¯¾ØÕó¡£½¨Òé°´ÆÚ¸üÐÂSDK×é¼þ°üÒÔÊÊÅäÐÂÐÍAPI½Ó¿Ú£¬Í¬Ê±ÔÚȨÏÞÉ󼯷½ÃæÒ»Á¬ÔöÇ¿Çå¾²·À»¤¼¶±ð£¬×îÖÕʵÏÖÆóÒµ¼¶Á÷³Ì×Ô¶¯»¯ÏµÍ³µÄÎȽ¡ÔËÓª¡£
Ò»¡¢ÏµÍ³¼¯³É»ù´¡ÇéÐÎÉèÖÃ
ÈÕÆ¨Èí¼þÓëÆäËû¹¤¾ßʵÏÖÉî¶ÈÕûºÏµÄÌõ¼þÊÇÍê³Éµ×²ãÇéÐδ¡£ÔÚTJJÕ¾³¤ÖúÊÖ¿ØÖÆÌ¨ÖУ¬ÆôÓÃ"¿çƽ̨ͨѶģ¿é"£¬¸Ã¹¦Ð§Ö§³ÖTCP/IPÓëWebSocketË«ÐÒé´«Êä¡£ÇéÐαäÁ¿ÉèÖÃÐè×¢ÖØ·À»ðǽ¶Ë¿Ú¿ª·Å¹æÔò£¬½¨ÒéΪRPA»úеÈ˵¥¶À»®·Ö5000-6000¶Ë¿ÚÇø¼ä¡£ÉèÖÃÎļþ²ÎÊýÐèÓëÄ¿µÄϵͳµÄSDK°æ±¾¼á³Öͬ²½£¬OracleÊý¾Ý¿âÅþÁ¬×Ö·û´®µÄÃûÌÃУÑéÖ±½ÓÓ°ÏìÊý¾ÝǨáãµÄÎȹÌÐÔ¡£
¶þ¡¢API½Ó¿Ú¶Ô½ÓʵսÆÊÎö
¹¤¾ß¼¯³ÉµÄ½¹µã»·½ÚÔÚÓÚAPI½Ó¿ÚŲÓõľ«×¼¿ØÖÆ¡£Í¨¹ý·â×°RESTful½Ó¿ÚÄ£°å£¬¿ÉʵÏÖÈÕÆ¨Èí¼þÓëÖ÷Á÷CRMϵͳµÄË«ÏòÊý¾Ý½»»¥¡£Ïêϸ²Ù×÷Éæ¼°Èý¸öÒªº¦°ì·¨£ºÅ²ÓÃOAuth2.0ÊÚȨÐÒé»ñÈ¡»á¼ûÁîÅÆ£¨Access Token£©¡¢ÉèÖö¯Ì¬ÇëÇóÍ·²ÎÊý¡¢±àдJSONÊý¾ÝÆÊÎöÄ£¿é¡£ÔõÑùÔÚ´¦Öóͷ£429״̬ÂëʱʵÏÖÖÇÄÜÖØÊÔ»úÖÆ£¿ÕâÐèÒªÁ¬ÏµTJJÕ¾³¤ÖúÊÖµÄÁ÷Á¿¿ØÖÆÄ£¿é£¬ÉèÖÃ×Ô˳ӦÂÖѯ¾àÀëËã·¨À´¹æ±ÜЧÀÍÏÞÁ÷¡£
Èý¡¢Êý¾Ý¿âÁª¶¯ÉèÖü¼ÇÉ
Õë¶ÔMySQL¡¢PostgreSQLµÈ¹ØÏµÐÍÊý¾Ý¿âµÄÉî¶È¼¯³É£¬±ØÐ轨ÉèÊÂÎñ»Ø¹ö°ü¹Ü»úÖÆ¡£Í¨¹ýÉèÖÃ"Á½½×¶ÎÌá½»"ÐÒ飬¿ÉÈ·±£ÈÕÆ¨Èí¼þÔÚÊý¾Ýͬ²½Àú³ÌÖеÄÔ×ÓÐÔ²Ù×÷¡£ÅþÁ¬³Ø²ÎÊýµÄ¶¯Ì¬ÓÅ»¯Ö±½ÓÓ°ÏìϵͳÐÔÄÜ£¬½¨Ò齫max_pool_sizeÉèÖÃΪ»îÔ¾ÅþÁ¬ÊýµÄ1.5±¶¡£ÒªÌØÊâ×¢ÖØ×Ö·û¼¯±àÂëµÄÒ»ÖÂÐÔ£¬ÍƼöͳһʹÓÃUTF-8MB4ÃûÌÃÒÔ±ÜÃâÊý¾ÝÂÒÂëÎÊÌⱬ·¢¡£
ËÄ¡¢Í¼ÐνçÃæÔªËØ¾«×¼Æ¥Åä
µ±¼¯³ÉÐèÒª²Ù×÷GUI½çÃæµÄ¹Å°åÈí¼þʱ£¬½çÃæÔªËØµÄ¾«×¼¶¨Î»³ÉΪÊÖÒÕÄѵ㡣TJJÕ¾³¤ÖúÊÖÌṩµÄÔªËØÌ½²âÆ÷¹¤¾ß£¬¿Éͨ¹ýÌìÉúΨһXPath¶¨Î»·ûËø¶¨Ä¿µÄ¿Ø¼þ¡£Õë¶Ô¶¯Ì¬ÌìÉúµÄDOMÔªËØ£¬Ó¦ÆôÓÃÊÓ¾õÌØÕ÷Æ¥ÅäÊÖÒÕ£¬ÉèÖÃÏàËÆ¶ÈãÐÖµ¡Ý85%µÄÈÝ´í»úÖÆ¡£ÔõÑùÓ¦¶Ô½çÃæÇø·ÖÂÊת±äµ¼ÖµÄÔªËØÆ«ÒÆ£¿½¨Éè»ùÓÚCSSÑ¡ÔñÆ÷µÄ×Ô˳Ӧ½á¹¹¼à²âÄ£×ÓÄÜÓÐÓÃÌáÉý²Ù×÷ÀÖ³ÉÂÊ¡£
Î塢ϵͳȨÏÞ¼°Çå¾²ÉèÖÃ
¼¯³ÉÇéÐεÄÇå¾²·À»¤ÊÇÈ·±£×Ô¶¯»¯Á÷³ÌÎȹÌÔËÐеĻù´¡¡£ÔÚTJJÕ¾³¤ÖúÊÖµÄȨÏÞÖÎÀí½çÃæ£¬Ðè×ñÕÕ"×îСȨÏÞÔÔò"ÉèÖÃÓû§½ÇÉ«£¬½¨Ò齫²Ù×÷ȨÏÞϸ·ÖΪ¶ÁÈ¡¡¢Ð´Èë¡¢Ö´ÐÐÈý¸öÆ·¼¶¡£ÃÜÔ¿ÖÎÀíϵͳ±ØÐè½ÓÄÉAES-256¼ÓÃÜËã·¨´æ´¢Ãô¸ÐÐÅÏ¢£¬Í¬Ê±¿ªÆôË«ÒòËØÈÏÖ¤¹¦Ð§¡£°´ÆÚÖ´ÐÐÇå¾²Éó¼ÆÊ±£¬ÒªÌØÊâ×¢ÖØ¼ì²é¿çϵͳ»á¼ûÈÕÖ¾ÖеÄ401δÊÚȨÇëÇó¼Í¼¡£
Áù¡¢Òì³£´¦Öóͷ£ÓëÐÔÄÜÓÅ»¯
¹¹½¨½áʵµÄÒì³£´¦Öóͷ£ÏµÍ³ÊǼ¯³ÉÏîÄ¿µÄ×îÖÕÄ¥Á·¡£ÔÚTJJÕ¾³¤ÖúÊÖµÄÊÂÎñÖÎÀíÖÐÐÄ£¬ÉèÖÃÎå¼¶¸æ¾¯ÏìÓ¦»úÖÆ£º´Ó»ù´¡µÄÖØÊÔÕ½ÂÔµ½È˹¤½éÈëÁ÷³Ì¡£ÐÔÄÜ¼à¿Ø·½Ã棬ÐèÖØµã¹Ø×¢ÄÚ´æ×ß©µÄÔ¤·À£¬½¨Ò齫.NET FrameworkµÄÀ¬»ø½ÓÄÉģʽÉèÖÃΪ"ЧÀÍÆ÷ģʽ"¡£µ±Óöµ½ÍøÂçÑÓ³Ùµ¼Öµij¬Ê±¹ÊÕÏʱ£¬Í¨¹ý¶¯Ì¬µ÷½âTCP´°¿Ú¾ÞϸºÍÆôÓÃÊý¾ÝѹËõÐÒ飬¿É½«´«ÊäЧÂÊÌáÉý40%ÒÔÉÏ¡£
ͨ¹ý±¾Ö¸ÄϵÄϵͳÐÔ½â˵£¬ÈÕÆ¨Èí¼þÓëµÚÈý·½¹¤¾ß¼¯³ÉÒÑÐγɱê×¼»¯ÊµÑé·¾¶¡£ÕÆÎÕTJJÕ¾³¤ÖúÊֵĽ¹µã¹¦Ð§Ä£¿éºó£¬Óû§¿É¿ìËÙ¹¹½¨Ö§³Ö¶àϽµµÍª¶¯µÄ×Ô¶¯»¯¾ØÕó¡£½¨Òé°´ÆÚ¸üÐÂSDK×é¼þ°üÒÔÊÊÅäÐÂÐÍAPI½Ó¿Ú£¬Í¬Ê±ÔÚȨÏÞÉ󼯷½ÃæÒ»Á¬ÔöÇ¿Çå¾²·À»¤¼¶±ð£¬×îÖÕʵÏÖÆóÒµ¼¶Á÷³Ì×Ô¶¯»¯ÏµÍ³µÄÎȽ¡ÔËÓª¡£