{"id":8461,"date":"2021-09-19T09:17:47","date_gmt":"2021-09-19T01:17:47","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=8461"},"modified":"2021-09-30T09:40:54","modified_gmt":"2021-09-30T01:40:54","slug":"day12-import%e4%b9%8b-1-%e4%bd%bf%e7%94%a8extension%e6%89%a9%e5%b1%95%e5%8a%9f%e8%83%bd","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=8461","title":{"rendered":"[day12] IMPORT\u4e4b 1: \u4f7f\u7528extension\u6269\u5c55\u529f\u80fd"},"content":{"rendered":"

\u6587\u7ae0\u6765\u81ea\uff1aiT \u90a6\u5e6b\u5fd9::\u4e00\u8d77\u5e6b\u5fd9\u89e3\u6c7a\u96e3\u984c\uff0c\u62ef\u6551 IT \u4eba\u7684\u4e00\u5929 (ithome.com.tw)<\/a><\/h2>\n

[day12] IMPORT\u4e4b 1: \u4f7f\u7528extension\u6269\u5c55\u529f\u80fd<\/h2>\n

\u8f6c\u6362\u4e3aGenero\u540e\uff0cFourJs\u2019 \u4e3a\u4e86\u6269\u5c55\u6574\u4f53\u7a0b\u5e8f\u8bed\u8a00\uff0c\u4ee4\u4ed6\u53ef\u4ee5\u6267\u884c\u66f4\u591a\u4e0d\u4e00\u5b9a\u4e0e\u6570\u636e\u5e93\u76f8\u5173\u7684\u529f\u80fd\uff0c\u5f80\u72ec\u7acb\u6b63\u5e38\u7684\u5957\u4ef6\u53d1\u5c55\uff0c\u5373\u5df2\u5f00\u653e\u6c47\u5165 IMPORT \u7684\u6307\u4ee4\u3002<\/p>\n

\u8bed\u6cd5\uff1a\u5728 4GL \u6bb5 function \u6216\u8bbe\u5b9a\u524d\uff0c\u5b9a\u4e49 IMPORT [\u8bed\u8a00\u522b] \u5957\u4ef6\u540d
\n\u4e0d\u987b\u6807\u6ce8\u8bed\u8a00\u4e3a\uff1aC \u3002\u9700\u7279\u522b\u6807\u6ce8\uff1aJAVA \/ FGL\u3002\u5176\u4ed6\u8bed\u8a00 extension\u6682\u65f6\u672a\u5f00\u653e\u5f15\u5165\u3002<\/p>\n

[\u7f55\u7528] IMPORT Cextension<\/h3>\n

Genero\u5957\u4ef6\u662f\u7531Native C\u91cd\u6784\u3002\u539f\u672c\u5c31\u53ef\u8bfb\u53d6 C\u5f00\u53d1\u51fa\u7684 .so ( .dll) \u4f7f\u7528\u8005\u81ea\u5b9a\u4e49\u4e49\u5ef6\u4f38\u5305\u3002
\n\u4f9d\u636e\u6587\u4ef6\u8981\u6c42\uff1a<\/p>\n

C \u6269\u5c55\u5fc5\u987b\u4f5c\u4e3a\u5171\u4eab\u5e93\uff08.DLL\u6216\u00a0.so\uff09\u5b58\u5728\u5e76\u4e14\u662f\u53ef\u52a0\u8f7d\u7684\uff08\u5fc5\u987b\u6b63\u786e\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf\uff09\u3002\u4e0eIMPORT\u6307\u4ee4\u4e00\u8d77\u4f7f\u7528\u7684 C \u6269\u5c55\u6a21\u5757\u00a0\u4e0d\u5fc5\u94fe\u63a5\u5230fglrun\uff1a\u8fd0\u884c\u65f6\u7cfb\u7edf\u52a8\u6001\u52a0\u8f7d\u4f9d\u8d56\u7684 C \u6269\u5c55\u6a21\u5757\u3002<\/p>\n

\u6b64\u610f\u6db5\u4e3a\uff1a\u82e5\u5f00\u53d1\u5b8c\u6210\u540e\uff0c\u7528\u6237\u81ea\u884c\u5b9a\u4e49\u7684 .so \u6863\u5e94\u8be5\u81ea\u884c\u590d\u5236\u653e\u5165 $FGLDIR\/lib \u63d0\u4f9b\u8fde\u7ed3\u3002\u5f53 FGL \u5957\u4ef6\u66f4\u65b0\u65f6\u52a1\u5fc5\u968f\u540c\u642c\u79fb\u6216\u590d\u5236\u3002<\/p>\n

\u53e6\u5916\uff0c\u4e3a\u6c42\u65b9\u4fbf\uff0c\u82e5\u5f00\u53d1\u7684\u6269\u5c55\u6a21\u5757\u547d\u540d\u4e3a\u300euserextension\u300f(\u94fe\u63a5\u5e93\u4e3a userextension.so) \u5219\u8fd0\u884c fglrun \u7684\u65f6\u5019\u4f1a\u81ea\u52a8\u9644\u52a0\uff0c\u4e0d\u5fc5\u7279\u522b\u4f7f\u7528 IMPORT userextension \u8fd9\u6837\u7684\u65b9\u5f0f\u5e26\u5165\u3002<\/p>\n

C \u6269\u5c55\u64b0\u5199\u65f6\u9650\u5236\u591a\uff0c\u5927\u591a\u6570\u72b6\u51b5\u5e76\u4e0d\u4f1a\u7279\u522b\u4f7f\u7528\uff0c\u6b64\u5904\u5e26\u8fc7\u4e0d\u52a0\u8303\u4f8b\u3002<\/p>\n

###[\u4ee5\u4e0b\u5e38\u7528] extend packages ###<\/p>\n

\u65e2\u7136\u53ef\u4ee5\uff0c\u4e3a\u4ec0\u4e48 Genero \u4e0d\u5148\u5e2e\u5fd9\u5199\u4e00\u4e9b\u5e38\u7528\u3001\u5e38\u89c1\u7684\u5de5\u5177\u534f\u52a9\u7528\u6237\u5462\uff1f
\nGenero 2.X \u7248\u672c\u5f00\u59cb\uff0c\u5957\u4ef6\u4e2d\u63d0\u4f9b\u9884\u5148\u5b8c\u6210\u7684\u5e38\u7528\u529f\u80fd (extend packages)\uff0c\u518d\u4f9d\u7167\u5e38\u7528\u7a0b\u5ea6\u5206\u4e3a\u4e24\u7c7b\uff1a\u5185\u7f6e\u5305 (built-in packages\uff0c\u4e0d\u9700\u8981\u4f7f\u7528IMPORT\u6c47\u5165\u5c31\u53ef\u4f7f\u7528)\uff0c\u6269\u5c55\u5305 (\u9700\u8981 IMPORT)<\/p>\n

\u8bf7\u6ce8\u610f\uff1a\u4ee5\u4e0b\u5c06\u4f1a\u4ee5\u73b0\u884c\u53d1\u5e03\u7248\u672c Genero 3.20\u4e3a\u51c6\uff0c
\nGenero 1.X \u7248\u672c\u65e0 extend package \u4e0eIMPORT\u975e C extension\u529f\u80fd\u652f\u6301
\nGenero 2.50 \u540e\u7248\u672c\u652f\u6301\u5927\u90e8\u5206\u529f\u80fd\u3002\u5404\u7248\u672c\u8be6\u7ec6\u652f\u6301\u60c5\u51b5\u8bf7\u67e5\u9605Genero Studio\u4e2d\u7684\u6c42\u52a9\u6587\u4ef6\u6216\u5728\u7ebf\u6587\u4ef6\u3002<\/p>\n

base.Application<\/h4>\n

\u5206\u7c7b\uff1a\u4e0d\u9700\u8981IMPORT\u53ef\u76f4\u63a5\u4f7f\u7528
\n\u529f\u80fd\uff1a\u53ef\u67e5\u9605\u7a0b\u5e8f\u540d\u79f0\u3001\u5f53\u4e0bFGL\u7cfb\u73af\u5883\u53d8\u91cf\u503c\u7b49\u57fa\u7840\u914d\u7f6e
\nMethod List<\/a>
\n\u7279\u522b\u6ce8\u610f\uff1a
\n1.base.Application.getStackTrace() \u5f88\u597d\u7528\uff0c\u5f53\u7a0b\u5e8f\u975e\u5e38\u590d\u6742\uff0c\u5c42\u5c42\u8fed\u8fed\u65f6\uff0c\u53ef\u4ee5\u76f4\u63a5<\/p>\n

DISPLAY base.Application.getStackTrace()<\/p>\n

\u53ef\u4ee5\u628a\u4ece MAIN \u6267\u884c\u5230\u672c\u5904\u7684 4GL Module\u5806\u6808\u5448\u73b0\u51fa\u6765\u3002\u4fbf\u5229\u4e8e\u67e5\u627e\u95ee\u9898\u4f7f\u7528\u3002
\n\u5448\u73b0\u7ed3\u679c\u5982
\n#0 sorry_stack() at sorry.4gl:119
\n#1 helloworld_again_err() at helloworld_again.4gl:870
\n#2 helloworld_again_fill() at helloworld_again.4gl:3675
\n#3 helloworld_query() at helloworld.4gl:11296
\n#4 helloworld_dialog() at helloworld.4gl:3320
\n#5 main() at hello.4gl:1246
\n2. base.Application.reloadResources() \u91cd\u65b0\u52a0\u8f7d\u8d44\u6e90\u6587\u4ef6(Resource Files\uff0c\u5c24\u5176\u630742s\u6863\u6848) \u529f\u80fd\u4e3a 3.20 \u540e\u63d0\u4f9b<\/p>\n

base.Channel<\/h4>\n

\u5206\u7c7b\uff1a\u4e0d\u9700\u8981IMPORT\u53ef\u76f4\u63a5\u4f7f\u7528
\n\u529f\u80fd\uff1a\u53ef\u7528\u6765\u8bfb\u53d6\/\u5199\u5165\u6863\u6848\u6570\u636e(openFile)\uff0c\u53ef\u8bfb\u53d6\u6267\u884c\u6307\u4ee4\u65f6\u5448\u73b0\u5728\u80cc\u666f\u753b\u9762\u4e0a\u7684\u8baf\u606f(openPipe)\u4e0e\u76f8\u5173\u64cd\u4f5c
\nMethod List<\/a>
\n\u7279\u522b\u6ce8\u610f\uff1a<\/p>\n

    \n
  1. \u7b80\u6613\u8303\u4f8b<\/a><\/li>\n
  2. \u8bfb\u53d6\u6863\u6848\u524d\uff0c\u4e00\u5b9a\u8981\u8bbe\u5b9a setDelimiter(“\u5206\u9694\u7b26”) \uff0c\u4e00\u822c\u666e\u901a\u6863\u6848\u8bbe\u5b9a\u4e3a “” \u5373\u53ef<\/li>\n<\/ol>\n

    base.SqlHandle (3.20\u4ee5\u4e0a\u63d0\u4f9b)<\/h4>\n

    \u5206\u7c7b\uff1a\u4e0d\u9700\u8981IMPORT\u53ef\u76f4\u63a5\u4f7f\u7528
    \n\u529f\u80fd\uff1a\u53ef\u4ee5\u7528\u300e\u52a8\u6001\u7684\u65b9\u6cd5\u300f\u6765\u521b\u9020SQL\u4ee5\u53ca\u6267\u884c\u3002
    \n    Method List<\/a>
    \n\u7279\u522b\u6ce8\u610f<\/p>\n

      \n
    1. FGL 3.20\u5957\u4ef6 DEMO \u4e2d\u6709\u4e00\u4e2a dbbrowser\u8868\u683c\u6570\u636e\u67e5\u8be2\u5668\uff0c\u540e\u7eed\u5c06\u4f1a\u4e13\u7ae0\u89e3\u8bf4\u8be5\u8303\u4f8b<\/li>\n<\/ol>\n

      base.StringBuffer<\/h4>\n

      \u5206\u7c7b\uff1a\u4e0d\u9700\u8981IMPORT\u53ef\u76f4\u63a5\u4f7f\u7528
      \n\u529f\u80fd\uff1astring \u53d8\u91cf\u578b\u6001\u867d\u7136\u53ef\u4ee5\u65e0\u4e0a\u9650\u4f7f\u7528\uff0c\u4f46\u82e5\u8d44\u6599\u91cf\u300e\u53ef\u80fd\u5927\u4e8e300K\u300f\u65f6\u5efa\u8bae\u8f6c\u7528StingBuffer\u8fdb\u884c\u5b57\u7b26\u4e32\u5904\u7406\u3002\u5982\u6574\u6279\u53d6\u66ff\u4ee3\u3001\u641c\u5bfb\u7b49\u5b57\u7b26\u4e32\u5904\u7406\u7b49\u529f\u80fd (\u8d85\u8fc7300K\u65f6\u4f7f\u7528\u6b64\u578b\u6001\u6548\u80fd\u8f83\u4f73)
      \n      Method List<\/a><\/p>\n

      base.StringTokenizer<\/h4>\n

      \u5206\u7c7b\uff1a\u4e0d\u9700\u8981IMPORT\u53ef\u76f4\u63a5\u4f7f\u7528
      \n\u529f\u80fd\uff1a\u5b57\u7b26\u4e32\u4e2d\u82e5\u6709 “a\/b\/c\/d\/e… ” \u7b49\u5143\u7d20\u7528\u540c\u6837\u7684\u6837\u5f0f (pattern) \u65f6\uff0c\u8981\u505a\u62c6\u89e3\u6216\u7ec4\u5408\u7528\u3002\u4f8b\u5982SQL\u4e2d\u7684\u5b57\u6bb5\u5217\u8868\u6216\u7a0b\u5e8f\u8def\u5f84\u7684\u5207\u8282\u7b49\u7b49\u3002
      \n      Method List<\/a>
      \n\u7279\u522b\u6ce8\u610f<\/p>\n

        \n
      1. \u62c6\u8def\u5f84\u7684\u8303\u4f8b<\/a><\/li>\n<\/ol>\n

        os.Path<\/h4>\n

        \u5206\u7c7b\uff1a\u9700\u8981 IMPORT os
        \n\u529f\u80fd\uff1a\u5904\u7406\u4e0e\u6587\u4ef6\u7cfb\u7edf\u4ea4\u4e92\u7684\u6240\u6709\u4e8b\u4ef6\u3002\u5982\u5207\u6362\u76ee\u524d\u6240\u5728\u8def\u5f84\uff0c\u67e5\u770b\u8def\u5f84\u8baf\u606f\u3001\u67e5\u770b\u6863\u6848\u8baf\u606f\u3001\u8bbe\u5b9a\u5c5e\u6027\u7b49\u7b49\u3002\u53ef\u642d\u914dchannel\u505a\u5230\u300e\u5207\u6362\u5230\u6307\u5b9a\u8def\u5f84\u4e0b\u5199\u5165\u6307\u5b9a\u5185\u5bb9\u300f\u4e4b\u7c7b\u7684\u5de5\u4f5c
        \n        Method List<\/a>
        \n\u7279\u522b\u6ce8\u610f\uff1a<\/p>\n

          \n
        1. \u6d4f\u89c8\u6307\u5b9a\u8def\u5f84\u76ee\u5f55\u7ed3\u6784\u7684\u8303\u4f8b<\/a><\/li>\n
        2. os.Path \u4e2d\u5e38\u7528\u7684\u662f os.Path.join \u7ec4\u5408\u8def\u5f84<\/li>\n<\/ol>\n

          util.Strings<\/h4>\n

          \u5206\u7c7b\uff1a\u9700\u8981 IMPORT util (\u5927\u90e8\u5206\u529f\u80fd\u4ec5\u5728Genero 3.00\u4ee5\u4e0a\u7248\u672c\u6709\u6548)
          \n\u529f\u80fd\uff1a\u63d0\u4f9b\u5b57\u7b26\u4e32\u4ee5 Base64 \u7f16\u7801\u6216\u8bd1\u7801\u529f\u80fd\uff0c\u7f51\u5740\u5217\u5b57\u7b26\u4e32(\u5982\u542b\u6709\u7279\u6b8a\u5b57\u7b26)\u7684URL\u7f16\/\u8bd1\u7801\u529f\u80fd
          \n          Method List<\/a>
          \n\u7279\u522b\u6ce8\u610f<\/p>\n

            \n
          1. Genero \u8fdb\u9636\u7684 Base64\u6216\u5176\u4ed6\u5982AES256\u7b49\u52a0\u5bc6\u65b9\u5f0f\uff0c\u5f52\u5c5e\u4e8e\u5b89\u5168\u5305(IMPORT Security)\u7684\u8303\u56f4<\/a><\/li>\n<\/ol>\n

            util.Math<\/h4>\n

            \u5206\u7c7b\uff1a\u9700\u8981 IMPORT util (\u5927\u90e8\u5206\u529f\u80fd\u4ec5\u5728Genero 3.00\u4ee5\u4e0a\u7248\u672c\u6709\u6548)
            \n\u529f\u80fd\uff1a\u63d0\u4f9b\u5305\u62ec\u53d6\u968f\u673a\u6570\u4e4b\u7c7b\u7684\u4e00\u5927\u5806\u5de5\u7a0b\u7ea7\u6570\u5b66\u51fd\u6570 (pi,sin,cos,log,\u89d2,\u5ea6,….)
            \n            Method List<\/a><\/p>\n

            util.JSON<\/h4>\n

            \u5206\u7c7b\uff1a\u9700\u8981 IMPORT util (\u5927\u90e8\u5206\u529f\u80fd\u4ec5\u5728Genero 3.00\u4ee5\u4e0a\u7248\u672c\u6709\u6548)
            \n\u529f\u80fd\uff1a\u63d0\u4f9bGenero RECORD\u548c JSON\u5b57\u7b26\u4e32\u4e92\u8f6c\u7684\u673a\u5236\uff0c\u5728\u64cd\u4f5c WEB Service\u6216API \u65f6\u9700\u8981\u4f7f\u7528
            \n            Method List<\/a><\/p>\n

            util.JSONObject<\/h4>\n

            \u5206\u7c7b\uff1a\u9700\u8981 IMPORT util (\u5927\u90e8\u5206\u529f\u80fd\u4ec5\u5728Genero 3.00\u4ee5\u4e0a\u7248\u672c\u6709\u6548)
            \n\u529f\u80fd\uff1aJSON\u5957\u4ef6\u7684\u6269\u5c55\u3002\u5f53\u9700\u8981\u5bf9\u63a5\u7684 JSON \u5177\u6709\u590d\u6742\u7684\u7ed3\u6784\u65f6\uff0c\u53ef\u5229\u7528\u6b64\u5bf9\u8c61\u627f\u63a5\uff0c\u53ef\u76f4\u63a5\u5728\u5bf9\u8c61\u5185\u64cd\u4f5c\u53d6\/\u6539\u503c\uff0c\u7ed3\u6784\u8c03\u6574\u5f02\u52a8\u7b49\u4e8b\u9879
            \n            Method List<\/a><\/p>\n

            util.JSONArray<\/h4>\n

            \u5206\u7c7b\uff1a\u9700\u8981 IMPORT util (\u5927\u90e8\u5206\u529f\u80fd\u4ec5\u5728Genero 3.00\u4ee5\u4e0a\u7248\u672c\u6709\u6548)
            \n\u529f\u80fd\uff1aJSON\u5b57\u7b26\u4e32\u4e2d\u82e5\u51fa\u73b0\u5982 [123,546,”abc”,”def”,”xyz”] \u7684\u6570\u7ec4\u5f62\u5f0f\uff0c\u53ef\u7528\u6b64\u5bf9\u8c61\u8fdb\u884c\u7ec4\u4ef6\u7684\u64cd\u4f5c
            \n            Method List<\/a><\/p>\n

            \u9664\u4e0a\u5217\u8f83\u4e3a\u57fa\u672c\u7684\u9879\u76ee\u5916\uff0c\u8fd8\u6709 COM\u7f51\u9875\u901a\u8baf\u5305\u3001XML\u5904\u7406\u5305\u3001Security\u5b89\u5168\u5305\u7b49\u63d0\u4f9b\u3002\u76f8\u5173\u8d44\u6e90\u540e\u7eed\u8fdb\u884c\u4e2a\u522b\u63a2\u8ba8\u3002<\/p>\n

            \u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » [day12] IMPORT\u4e4b 1: \u4f7f\u7528extension\u6269\u5c55\u529f\u80fd<\/a><\/p>","protected":false},"excerpt":{"rendered":"

            \u6587\u7ae0\u6765\u81ea\uff1aiT \u90a6\u5e6b\u5fd9::\u4e00\u8d77\u5e6b\u5fd9\u89e3\u6c7a\u96e3\u984c\uff0c\u62ef\u6551 IT \u4eba\u7684\u4e00\u5929 (ithome.com.tw) [day12] IMPORT\u4e4b 1: \u4f7f\u7528extension\u6269\u5c55\u529f\u80fd \u8f6c\u6362\u4e3aGenero\u540e\uff0cFourJs\u2019 \u4e3a\u4e86\u6269\u5c55\u6574\u4f53\u7a0b\u5e8f\u8bed\u8a00\uff0c\u4ee4\u4ed6\u53ef\u4ee5\u6267\u884c\u66f4\u591a\u4e0d\u4e00\u5b9a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[490,26],"tags":[1038,76,1025],"class_list":["post-8461","post","type-post","status-publish","format-standard","hentry","category-490","category-4gl","tag-extension","tag-import","tag-1025"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/8461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8461"}],"version-history":[{"count":2,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/8461\/revisions"}],"predecessor-version":[{"id":8534,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/8461\/revisions\/8534"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}