{"id":2825,"date":"2022-07-16T09:21:01","date_gmt":"2022-07-16T01:21:01","guid":{"rendered":"https:\/\/ufqi.com\/blog\/?p=2825"},"modified":"2022-07-23T15:21:58","modified_gmt":"2022-07-23T07:21:58","slug":"gwa2-pagenavi-pnoo","status":"publish","type":"post","link":"https:\/\/ufqi.com\/blog\/gwa2-pagenavi-pnoo\/","title":{"rendered":"GWA2\u5409\u5a03\u5154\ud83d\udc07\u5f15\u5165PNOO\u5173\u4e8e\u6392\u5e8f\u5b57\u6bb5\u7684\u987a\u5e8f"},"content":{"rendered":"\n

\u8ddd\u79bb2022\u5e7406\u6708\u4e0a\u4e00\u7bc7Blog\u5dee\u4e0d\u591a\u8fc7\u53bb\u4e00\u4e2a\u6708\u4e86\uff08 UfqiFina\u6709\u798f\u91d1\u878d\u66f4\u65b0\uff1aJavaScript\u7684\u6570\u636e\u7c7b\u578b\u5f3a\u5236\u7b49\uff0c https:\/\/ufqi.com\/blog\/ufqifina-javascript-tofixed\/ \uff09\u3002<\/p>\n\n\n\n

GWA2\u5409\u5a03\u5154\u5728\u7814\u53d1\u4e0e\u90e8\u7f72\u4e2d\uff0c\u6301\u7eed\u6539\u8fdb\u5347\u7ea7\u4f18\u5316\uff0c\u65e5\u76ca\u5065\u58ee\u5f3a\u5927\u3002\u8fd1\u671f\u7684\u4e00\u4e2a\u4e3b\u8981\u6539\u8fdb\u5347\u7ea7\u662f\u5728Page Navigator\u5206\u9875\u5bfc\u822a\u6a21\u5757\u5f15\u5165\u4e86PNOO\u5173\u952e\u8bcd\u3002
PNOO\uff0c Page Navigator Order of multiple Order-by fields, \u5206\u9875\u5bfc\u822a\u4e2d\u7684\u6392\u5e8f\u5b57\u6bb5\u7684\u987a\u5e8f\u3002<\/p>\n\n\n\n

\u4e4b\u524d\u7684\u7ec4\u5408\u914d\u5bf9\u5173\u952e\u8bcd PNOB\uff0c
PNOB\uff0c Page Navigator Order By \uff0c \u5206\u9875\u5bfc\u822a\u4e2d\u7684\u67d0\u4e2a\u6392\u5e8f\u5b57\u6bb5\uff0c
\u4e4b\u524d\u7684\u7ec4\u5408\u914d\u5bf9\u5173\u952e\u8bcdPNSK,
PNSK, Page Navigator Search Key, \u5206\u9875\u5bfc\u822a\u4e2d\u7684\u641c\u7d22\u5b57\u6bb5\uff0c
\u4e4b\u524d\u7684\u7ec4\u5408\u914d\u5bf9\u5173\u952e\u8bcdOPPNSK,
OPPNSK, Operator of PNSK, \u5206\u9875\u5bfc\u822a\u4e2d\u7684\u67d0\u5404\u641c\u7d22\u5b57\u6bb5\u7684\u64cd\u4f5c\u7b26.<\/p>\n\n\n\n

\u95ee\u9898\u7684\u80cc\u666f\u662f\uff0c\u5f53\u6211\u4eec\u4f7f\u7528 GWA2\u4e2d\u7684Page Navigator\u6a21\u5757\u901a\u8fc7\u5730\u5740\u680f\u7684\u8bf7\u6c42\u53c2\u6570\u8fdb\u884c\u6570\u636e\u5e93SQL\u67e5\u8be2\u8bed\u53e5\u7684\u7ec4\u88c5\u65f6\uff0c\u9664\u4e86\u4f7f\u7528\u6784\u9020\u6761\u4ef6\u7684 PNSKxxx=yyy \u8fd9\u6837\u7684\u5173\u952e\u8bcd\uff0c OPPNSKxxx=yyy \u8fd9\u6837\u7684\u64cd\u4f5c\u7b26\uff0c\u8fd8\u4f1a\u4f7f\u7528\u5230 PNOBxxx=0|1 \u8fd9\u6837\u7684\u6761\u4ef6\u6765\u8bbe\u7f6e\u67e5\u8be2\u7ed3\u679c\u7684\u6392\u5e8f\u3002\u76f8\u5173\u53c2\u8003\uff1a GWA2\u5409\u5a03\u5154\"\ud83d\udc07\"\u5347\u7ea7\u589e\u52a0\u641c\u7d22\u6a21\u7cca\u8bed\u6cd5\u652f\u6301\uff0c https:\/\/ufqi.com\/blog\/gwa2-fuzzy-search\/ \u3002<\/p>\n\n\n\n

PNOBxxx=0|1 \u4f1a\u6700\u7ec8\u6620\u5c04\u5230\u6570\u636e\u5e93SQL\u67e5\u8be2\u8bed\u53e5\u4e2d\u7684 order by xxx \u3002 \u7531\u4e8e\u5730\u5740\u680f\u8bf7\u6c42\u7684\u53c2\u6570\u662f\u4ee5Hash\u5217\u8868\u65b9\u5f0f\u4ece\u5ba2\u6237\u7aef\u4f20\u9012\u5230\u670d\u52a1\u5668\u7aef\uff0c\u6240\u4ee5\u5f53\u6709\u4e24\u4e2a\u4ee5\u4e0a\u7684\u6392\u5e8f\u6761\u4ef6\u65f6\uff0cHash\u5217\u8868\u7684\u6570\u636e\u5e76\u4e0d\u80fd\u533a\u5206\u51fa\u5148\u540e\u5173\u7cfb\u6765\u3002\u76f8\u53cd\u5730\uff0c\u5728\u6570\u636e\u5e93SQL\u8bed\u53e5\u4e2d\uff0c order by xxx, yyy \u548c order by yyy, xxx \u662f\u6709\u660e\u663e\u5148\u540e\u987a\u5e8f\u533a\u522b\u7684\u3002\u524d\u8005\u662f\u9488\u5bf9\u7ed3\u679c\u96c6\u5148\u6309xxx\u8fdb\u884c\u67d0\u79cd\u6392\u5e8f\uff0c\u7136\u540e\u5728\u8fd9\u4e2a\u57fa\u7840\u4e0a\u518d\u6309yyy\u8fdb\u884c\u6392\u5e8f\uff0c\u540e\u8005\u5219\u521a\u597d\u76f8\u53cd\u3002<\/p>\n\n\n\n

\u5982\u6b64\u4ee5\u6765\uff0cGWA2\u5409\u5a03\u5154\u7684Page Navigator\u9700\u8981\u67d0\u79cd\u673a\u5236\uff0c\u5728\u5904\u7406\u591a\u4e2a\u6392\u5e8f\u6761\u4ef6\u65f6\uff0c\u786e\u9700\u77e5\u9053\u8fd9\u4e9b\u6392\u5e8f\u5b57\u6bb5\u7684\u5148\u540e\u987a\u5e8f\u3002\u9274\u4e8eHash\u5217\u8868\u6570\u636e\u65e0\u6cd5\u786e\u4fdd\u5148\u540e\u987a\u5e8f\uff0c\u6211\u4eec\u8003\u8651\u5f15\u5165\u4e00\u4e2a\u65b0\u7684\u5173\u952e\u8bcd PNOO \u6765\u5b8c\u6210\u8fd9\u4e00\u4efb\u52a1\u3002
\u5728\u524d\u7aef\u5730\u5740\u680f\u53d1\u8d77\u8bf7\u6c42\u65f6\uff0c\u5982\u679c\u6307\u5b9a\u4e86\u591a\u4e2a\u6392\u5e8f\u6761\u4ef6\uff0c\u9700\u8981\u989d\u5916\u5730\u901a\u8fc7 PNOO\u6765\u6307\u660e\u8fd9\u4e9b\u6392\u5e8f\u6761\u4ef6\u7684\u5148\u540e\u987a\u5e8f\uff0c\u4e5f\u5373\uff0c
pnobfielda=1&pnobfieldb=0&pnobfieldc=1&pnoo=fielda,fieldb,fieldc<\/p>\n\n\n\n

\u8fd9\u5404\u8bf7\u6c42\u5c06\u6784\u9020\u4e00\u4e2a\u5982\u4e0b\u7684SQL\u6392\u5e8f\u8bed\u53e5\uff0c
order by fielda desc, fieldb, fieldc desc<\/p>\n\n\n\n

\u5982\u679c\u4e0d\u542f\u7528 pnoo \u53c2\u6570\u8fdb\u884c\u6307\u5b9a\u987a\u5e8f\uff0c\u5219Page Navigator\u6309Hash\u5217\u8868\u9ed8\u8ba4\u7684\u987a\u5e8f\u6267\u884c\uff0c\u5411\u524d\u517c\u5bb9\u6240\u6709\u7248\u672c\u3002
\u76ee\u524d\uff0c\u8fd9\u4e00\u4f18\u5316\u6539\u8fdb\u5df2\u7ecf\u5728 GWA2 Java \u548c GWA2 PHP \u4e2d\u5b9e\u65bd\uff0c\u5728\u968f\u540e\u7684\u7248\u672c\u4e2d\uff0c\u5f00\u53d1\u8005\u53ef\u4ee5\u8c03\u7528PNOO\u6765\u8bbe\u7f6e\u5728\u591a\u4e2a\u6392\u5e8f\u5b57\u6bb5\u6761\u4ef6\u4e0b\u7684\u5404\u4e2a\u5b57\u6bb5\u7684\u5148\u540e\u987a\u5e8f\u3002
\u5728\u4ee3\u7801\u5c42\u9762\u7684\u5b9e\u73b0\u903b\u8f91\u662f\uff0c\u5728mod\/PageNavi.class \u4e2d\u7684 getOrder \u91cc\uff0c\u589e\u52a0\u5148\u68c0\u67e5\u5f53\u524d\u8bf7\u6c42\u662f\u5426\u5305\u542b\u3001\u9884\u8bbe\u4e86 PNOO\uff0c \u5982\u679c\u6ca1\u6709\u9884\u8bbe\uff0c\u8bf4\u660e\u662f\u4e4b\u524d\u7684\u8001\u65e7\u7248\u672c\uff0c\u4e0d\u652f\u6301\u65b0\u529f\u80fd PNOO\uff0c\u6392\u5e8f\u6309\u9ed8\u8ba4\u987a\u5e8f\u6267\u884c\u3002
\u5982\u679c\u68c0\u6d4b\u5230\u5305\u542b\u3001\u9884\u8bbe\u4e86PNOO\uff0c\u5219\u8bf4\u660e\u662f\u65b0\u7248\u672c\uff0c\u6709\u5bf9PNOO\u7684\u652f\u6301\uff0c\u8fdb\u4e00\u6b65\u5730\u62c6\u89e3\u51fa\u5e26\u987a\u5e8f\u7684\u6392\u5e8f\u5b57\u6bb5\uff0c\u7136\u540e\u987a\u5e8f\u6267\u884c\u3001\u5b89\u6392\u6392\u5e8f\u5b57\u6bb5\u7684\u5347\u964d\u8bbe\u7f6e\u3002<\/p>\n\n\n\n

\u9898\u59161.
\u5b9e\u9645\u5e94\u7528\u5f00\u53d1\u4e2d\uff0c\u591a\u4e2a\u6392\u5e8f\u6761\u4ef6\u540c\u65f6\u4f7f\u7528\u7684\u573a\u666f\u5e76\u4e0d\u591a\uff0c\u800c\u4e14\u5176\u6548\u679c\u4e5f\u5e76\u4e0d\u660e\u663e\u3002\u6bd4\u5982\u6309\u4ef7\u683c\u6392\u5e8f\u4e4b\u540e\u518d\u6309\u91cd\u91cf\u6392\u5e8f\uff0c\u6216\u8005\u53cd\u8fc7\u6765\uff0c\u6309\u91cd\u91cf\u6392\u5e8f\u4e4b\u540e\u518d\u6309\u4ef7\u683c\u6392\u5e8f\uff0c\u8fd9\u6837\u7684\u7ed3\u679c\u96c6\u4e0e\u53ea\u4f7f\u7528\u5176\u4e2d\u4e00\u4e2a\u6392\u5e8f\u6761\u4ef6\u6765\u770b\uff0c\u5dee\u522b\u5e76\u4e0d\u7279\u522b\u660e\u663e\u3002\u7ec6\u5fae\u4e4b\u5904\u53ea\u5728\u4e8e\u4ef7\u683c\u76f8\u540c\u65f6\uff0c\u518d\u770b\u91cd\u91cf\u7684\u5927\u5c0f\u3002\u591a\u6570\u60c5\u51b5\u4e0b\uff0c\u4ef7\u683c\u4e0e\u91cd\u91cf\u662f\u6b63\u76f8\u5173\u6216\u8005\u8d1f\u76f8\u5173\u5f88\u5f3a\u7684\u4e24\u4e2a\u5b57\u6bb5\u3002\u5927\u6982\u53ea\u6709\u5728\u4e24\u4e2a\u4e0d\u76f8\u5173\u7684\u6392\u5e8f\u5b57\u6bb5\u7ec4\u5408\u4e0b\uff0c\u6548\u679c\u624d\u4f1a\u660e\u663e\u4e00\u4e9b\u3002<\/p>\n\n\n\n

\u9898\u59162.
\u6570\u636e\u5e93SQL\u67e5\u8be2\u8bed\u53e5 order by \u6709\u65f6\u5019\u9700\u8981\u6309\u6761\u4ef6\u5730\u7ec4\u5408\u6392\u5e8f\u5b57\u6bb5\uff0c\u6bd4\u5982\u6839\u636e\u6570\u636e\u7684\u72b6\u6001\u5b57\u6bb5\u51b3\u5b9a\u6392\u5e8f\u662f\u6309Id\u3001\u72b6\u6001\u672c\u8eab\u3001\u521b\u5efa\u65f6\u95f4\u6216\u8005\u66f4\u65b0\u65f6\u95f4\u7b49\u3002\u4f8b\u5982\uff0c<\/p>\n\n\n\n

… ORDER BY
CASE
WHEN ali.LIVE_STATUS IN ( 0, 1 ) THEN
ali.LIVE_STATUS
END DESC,
CASE
WHEN ali.LIVE_STATUS = 3 THEN
ali.LIVE_START_TIME
END ASC,
CASE
WHEN ali.LIVE_STATUS = 2 THEN
ali.CREATE_TIME
END DESC<\/p>\n\n\n\n

\u9898\u59163.
\u59cb\u4e8e2022\u5e7402\u670824\u65e5\u4fc4\u7f57\u65af\u4fb5\u7565\u4e4c\u514b\u5170\u7684\u6218\u4e89\u8fd8\u5728\u6301\u7eed\uff0c\u597d\u6d88\u606f\u662f\u82f1\u52c7\u7684\u4e4c\u514b\u5170\u4eba\u8fd8\u5728\u987d\u5f3a\u5730\u62b5\u6297\u5165\u4fb5\u8005\uff0c\u56fd\u9645\u652f\u63f4\u4e0e\u5fd7\u613f\u519b\u8fd8\u5728\u6e90\u6e90\u4e0d\u65ad\u5730\u6d8c\u5165\u6297\u6218\u4e00\u7ebf\uff0c\u574f\u6d88\u606f\u662f\u4e4c\u514b\u5170\u5b9e\u9645\u4e0a\u4e22\u5931\u4e86\u4e00\u5c0f\u90e8\u5206\u8fb9\u5883\u9886\u571f\u3002\u53e0\u52a0\u4e0a\u82f1\u56fd\u9996\u76f8\u7ea6\u7ff0\u9c8d\u91cc\u65af\u56e0\u5e55\u50da\u8bda\u4fe1\u95ee\u9898\u88ab\u8feb\u5ba3\u5e03\u5373\u5c06\u4e0b\u91ce\uff0c\u65e5\u672c\u524d\u9996\u76f8\u5b89\u500d\u664b\u4e09\u56e0\u4e0d\u660e\u539f\u56e0\u5728\u7ade\u9009\u6f14\u8bf4\u4e2d\u9047\u88ad\u8eab\u4ea1\uff0c\u6c11\u4e3b\u81ea\u7531\u4e16\u754c\u8499\u53d7\u4e86\u6781\u5927\u7684\u635f\u5931\uff0c\u906d\u9047\u5230\u5de8\u5927\u7684\u6311\u6218\u3002
\u9053\u957f\u4e14\u963b\uff0c\u884c\u5219\u5c06\u81f3\u3002<\/p>\n\n\n\n

\u9664\u4e86\u952e\u76d8\u4fa0\u6253\u5634\u70ae\uff0c\u6211\u4eec\u8fd8\u53ef\u4ee5\u771f\u91d1\u767d\u94f6\u5730\u652f\u6301\u53d1\u751f\u5728\u4e4c\u514b\u5170\u7684\u81ea\u7531\u4e0e\u5974\u5f79\u76f8\u5bf9\u51b3\u7684\u53cd\u4fb5\u7565\u6218\u4e89\u3002\u6350\u52a9\u4e4c\u514b\u5170\u7f51\u7ad9\uff1a https:\/\/u24.gov.ua\/<\/a> .<\/p>\n\n\n\n

\u9898\u59164.
\u5982\u679c\u4e00\u5207\u987a\u5229\uff0cyoyo\u5c06\u5b8c\u6210\u521d\u4e2d\u5b66\u4e1a\uff0c\u4ece\u4e1c\u5317\u5e08\u5927\u9644\u4e2d\u671d\u9633\u5b66\u6821\u4ee5\u4f18\u5f02\u6210\u7ee9\u6bd5\u4e1a\uff0c\u8363\u83b7\u5317\u4eac\u5e02\u4e09\u597d\u5b66\u751f\u79f0\u53f7\uff0c\u5373\u5c06\u57282022\u5e74\u79cb\u5929\u5165\u8bfb\u6e05\u534e\u5927\u5b66\u9644\u4e2d\u671d\u9633\u5b66\u6821\uff08\u9ad8\u4e2d\u6821\uff09\u3002
Hanu\u5c06\u6beb\u65e0\u60ac\u5ff5\u7684\u4ece\u4e8c\u5e74\u7ea7\u7ed3\u4e1a\uff0c\u57282022\u5e74\u79cb\u5b63\u5f00\u59cb\u5c0f\u5b66\u4e09\u5e74\u7ea7\u7684\u6253\u602a\u5347\u7ea7\u4e4b\u8def\u3002<\/p>\n\n\n\n

\u5168\u6587\u9996\u53d1\u5730\u5740\uff1a https:\/\/ufqi.com\/blog\/gwa2-pagenavi-pnoo\/ \uff0c -R\/x12Sc<\/a><\/strong> <\/p>\n\n\n\n

\n\n\n\n
\"\"\/
GWA2\u5409\u5a03\u5154<\/figcaption><\/figure>\n\n\n\n

-GWA2 \u5409\u5a03\u5154<\/a>\u00a0\u662f\u201d\u901a\u7528\u7f51\u7edc\u5e94\u7528\u67b6\u6784( General Web Application Architecture,\u00a0https:\/\/ufqi.com\/dev\/gwa2\/ )\u201d\uff0c\u57fa\u4e8e -GWA2 \u53ef\u4ee5\u8f7b\u4fbf\u6784\u5efa\u5404\u79cd\u7f51\u7edc\u5e94\u7528\u7a0b\u5e8f,
\u5305\u62ec\u590d\u6742\u7684\u5728\u7ebf\u8d2d\u7269\u5546\u57ce\u3001\u5728\u7ebf\u533b\u7597\u3001\u5728\u7ebf\u6559\u80b2\u3001 \u65c5\u6e38\u4ea4\u6613\u5e73\u53f0\u3001\u793e\u7fa4\u6216\u8005\u793e\u4ea4\u7f51\u7ad9\u548c\u65b0\u95fb\u8d44\u8baf\u7f51\u7ad9\u7b49\uff0c
\u4e5f\u5305\u62ec\u5404\u79cd\u4f01\u4e8b\u4e1a\u5355\u4f4d\u7f51\u4e0a\u95e8\u6237\uff0c\u5728\u7ebf\u4ea4\u4e92\u53ca\u670d\u52a1\u4f5c\u4e1a\u7cfb\u7edf\u7b49.
\u8fd8\u53ef\u4ee5\u5305\u62ec\u4e3aNativeApp\u505a\u670d\u52a1\u5668\u7aef\u652f\u6301, \u751a\u81f3\u662fWebApp\u7684\u5168\u90e8.
-GWA2 \u662f\u4e3a\u6570\u4e0d\u591a\u7684\u652f\u6301\u8de8\u5f00\u53d1\u8bed\u8a00\u7684\u5e94\u7528\u6846\u67b6\uff0c\u76ee\u524d\u652f\u6301 -Java, -PHP, -Perl, -Aspx and -Python .<\/p>\n\n\n\n

-GWA2 is a \u201cGeneral Web Application Architecture\u201d and based on -GWA2 developers can easily build a variety of network applications,
including complex online shopping malls, online medical services, online teaching, travel trading platforms, community or social networking sites and news information sites, etc.
Also the applications include various online portals of enterprises and institutions, online interaction and service operations systems.
Moreover it contains server-side support for Native App, or even all of the WebApp.
-GWA2 is one of the web frameworks which provide cross-language support for -Java, -PHP, -Perl, -Aspx and -Python at present.<\/p>\n\n\n\n

-GWA2 is E.A.S.Y <\/strong>
Easy Along, Swift Yield
<\/strong>\u8f7b\u677e\u542f\u52a8, \u5feb\u901f\u4ea7\u51fa.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\u8ddd\u79bb2022\u5e7406\u6708\u4e0a\u4e00\u7bc7Blog\u5dee\u4e0d\u591a\u8fc7\u53bb\u4e00\u4e2a\u6708\u4e86\uff08 UfqiFina\u6709\u798f\u91d1\u878d … \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[41,42,6,2],"tags":[86,482,498,152,499,500],"_links":{"self":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/2825"}],"collection":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/comments?post=2825"}],"version-history":[{"count":12,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/2825\/revisions"}],"predecessor-version":[{"id":2840,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/2825\/revisions\/2840"}],"wp:attachment":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/media?parent=2825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/categories?post=2825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/tags?post=2825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}