{"id":10008379,"date":"2024-02-21T12:11:33","date_gmt":"2024-02-21T04:11:33","guid":{"rendered":"https:\/\/blog.itmax.cn\/?p=10008379"},"modified":"2024-02-21T12:11:33","modified_gmt":"2024-02-21T04:11:33","slug":"spel%e5%ba%94%e7%94%a8%e5%ae%9e%e6%88%98","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10008379","title":{"rendered":"SpEL\u5e94\u7528\u5b9e\u6218"},"content":{"rendered":"<h2>\u4e00\u3001\u80cc\u666f<\/h2>\n<h3>\u8d44\u91d1\u5e73\u53f0\u6982\u8ff0<\/h3>\n<p>\u4e3a\u4e86\u76d1\u63a7\u96c6\u56e2\u5404\u4e1a\u52a1\u7ebf\u7684\u8d44\u91d1\u6765\u6e90\u548c\u53bb\u5411\uff0c\u8d44\u91d1\u90e8\u9700\u6bcf\u5929\u5206\u6790\u6240\u6709\u8d26\u6237\u51fa\u91d1\u548c\u5165\u91d1\u60c5\u51b5\u3002\u4e3a\u6b64\uff0c\u6211\u4eec\u63d0\u4f9b\u4e86\u8d44\u91d1\u7ba1\u7406\u5e73\u53f0\uff0c\u8be5\u5e73\u53f0\u62e5\u6709\u8d26\u6237\u6536\u652f\u6d41\u6c34\u548c\u8d26\u5355\u62c9\u53d6\u7b49\u529f\u80fd\uff0c\u4ee5\u53ca\u73b0\u91d1\u6d41\u6253\u6807\u80fd\u529b\uff0c\u4e3a\u8d44\u91d1\u90e8\u63d0\u4f9b\u66f4\u52a0\u7cbe\u51c6\u7684\u73b0\u91d1\u6d41\u5206\u6790\u3002<\/p>\n<h3>\u9700\u6c42\u573a\u666f<\/h3>\n<p>\u8d44\u91d1\u7ba1\u7406\u5e73\u53f0\u4f5c\u4e3a\u53d1\u8d77\u65b9\uff0c\u4ee5\u8d26\u6237\u7ef4\u5ea6\u8bf7\u6c42\u652f\u4ed8\u7cfb\u7edf\u4e0b\u8f7d\u6e20\u9053\u8d26\u5355(\u4e0d\u540c\u6e20\u9053\u4f20\u53c2\u4e0d\u540c)\uff0c\u89e3\u6790\u6d41\u6c34\u843d\u5e93\u540e\u505a\u73b0\u91d1\u6d41\u6253\u6807\u3002<\/p>\n<h3>\u7cfb\u7edf\u4ea4\u4e92\u7b80\u56fe<\/h3>\n<p><img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044644568\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\"><\/p>\n<h3>\u629b\u51fa\u95ee\u9898<\/h3>\n<p>\u4e0a\u8ff0\u9700\u6c42\u4e2d\u8d44\u91d1\u5e73\u53f0\u8bf7\u6c42\u652f\u4ed8\u7cfb\u7edf\u4e0b\u8f7d\u8d26\u5355\u529f\u80fd\u8fd9\u4e00\u70b9\uff0c\u8003\u8651\u5230\u4e0d\u540c\u6e20\u9053\u7684\u8d26\u6237\uff0c\u8bf7\u6c42\u4f20\u53c2\u4e0d\u540c\uff0c\u8be5\u573a\u666f\u5982\u4f55\u505a\u529f\u80fd\u8bbe\u8ba1\uff1f<\/p>\n<h3>\u5b9e\u73b0\u65b9\u6848<\/h3>\n<p><strong>\u65b9\u6848 1(\u7b80\u5199)<\/strong>\uff1a\u65e0\u8111\u5806 if else<\/p>\n<p><strong>\u7f3a\u70b9<\/strong>\uff1a\u6bcf\u65b0\u589e\u4e00\u4e2a\u6e20\u9053\uff0c\u90fd\u8981\u5728\u539f\u6709\u4ee3\u7801\u57fa\u7840\u4e0a\u6dfb\u52a0\u53c2\u6570\u5904\u7406\u903b\u8f91\uff0c\u5bfc\u81f4\u4ee3\u7801\u81c3\u80bf\uff0c\u96be\u4ee5\u7ef4\u62a4\uff0c\u96be\u4ee5\u652f\u6301\u7cfb\u7edf\u7684\u6301\u7eed\u6f14\u8fdb\u548c\u6269\u5c55\u3002\u8fdd\u53cd\u5f00\u95ed\u539f\u5219\uff0c\u4fee\u6539\u4f1a\u5bf9\u539f\u6709\u529f\u80fd\u4ea7\u751f\u5f71\u54cd\uff0c\u589e\u52a0\u4e86\u5f15\u5165\u9519\u8bef\u7684\u98ce\u9669\u3002<\/p>\n<pre><code>\/**\n * \u8d44\u91d1\u7cfb\u7edf\u8bf7\u6c42\u652f\u4ed8\u7cfb\u7edf\u4e0b\u8f7d\u6e20\u9053\u8d26\u5355\n * \n * @param instCode \u6e20\u9053\u540d\n * @param instAccountNo \u8d26\u6237\n * @return \u540c\u6b65\u7ed3\u679c\n *\/\npublic String applyFileBill(String instCode, String instAccountNo) {\n    \/\/ \u4e0d\u540c\u6e20\u9053\u5165\u53c2\u7ec4\u88c5\n    FileBillReqDTO channelReq = new FileBillReqDTO();\n    if (&quot;\u652f\u4ed8\u5b9d&quot;.equals(instCode)) {\n        channelReq.setBusinessCode(&quot;ALIPAY_&quot; + instAccountNo + &quot;_BUSINESS&quot;);\n        channelReq.setPayTool(4);\n        channelReq.setTransType(50);\n    } else if (&quot;\u5fae\u4fe1&quot;.equals(instCode)) {\n        channelReq.setBusinessCode(&quot;WX_&quot; + instAccountNo);\n        channelReq.setPayTool(3);\n        channelReq.setTransType(13);\n    } else if (&quot;\u901a\u8054&quot;.equals(instCode)) {\n        channelReq.setBusinessCode(&quot;TL_&quot; + instAccountNo);\n        channelReq.setPayTool(5);\n        channelReq.setTransType(13);\n    }\n    \/\/ ... \u53ef\u4ee5\u7ee7\u7eed\u6dfb\u52a0\u5176\u4ed6\u6e20\u9053\u7684\u5904\u7406\u903b\u8f91\n    \n    \/\/ \u8bf7\u6c42\u652f\u4ed8\u7cfb\u7edf\u62c9\u53d6\u8d26\u5355\u6587\u4ef6\uff0c\u540c\u6b65\u8fd4\u56de\u5904\u7406\u4e2d\uff0c\u5f02\u6b65MQ\u901a\u77e5\u4e0b\u8f7d\u7ed3\u679c\n    BaseResult&lt;FileBillResDTO&gt; result = cnRegionDataFetcher.applyFileBill(channelReq, &quot;\u8d44\u91d1\u8d26\u5355\u4e0b\u8f7d&quot;);\n    return &quot;\u5904\u7406\u4e2d&quot;;\n}<\/code><\/pre>\n<p><strong>\u65b9\u6848 2<\/strong>\uff1a\u7b56\u7565\u6a21\u5f0f\u4f18\u5316<\/p>\n<p><strong>\u4f18\u70b9<\/strong>\uff1a\u7b26\u5408\u5f00\u95ed\u539f\u5219\uff0c\u65b0\u589e\u6e20\u9053\u63a5\u5165\u65f6\uff0c\u53ea\u9700\u521b\u5efa\u65b0\u7684\u5177\u4f53\u7b56\u7565\u5b9e\u73b0\u7c7b\u5e76\u5b9e\u73b0\u63a5\u53e3\u5373\u53ef\uff0c\u65e0\u9700\u4fee\u6539\u539f\u6709\u4ee3\u7801\uff0c\u7cfb\u7edf\u7075\u6d3b\u6027\u548c\u53ef\u6269\u5c55\u6027\u8f83\u597d\u3002<\/p>\n<p><strong>\u7f3a\u70b9<\/strong>\uff1a\u6bcf\u63a5\u5165\u4e00\u4e2a\u65b0\u6e20\u9053\uff0c\u8fd8\u662f\u5b58\u5728\u4ee3\u7801\u5f00\u53d1\u548c\u90e8\u7f72\u7684\u5de5\u4f5c\u91cf\uff0c\u4e14\u968f\u7740\u6e20\u9053\u63a5\u5165\u6570\u91cf\u7684\u589e\u52a0\uff0c\u7b56\u7565\u7c7b\u6570\u91cf\u589e\u591a\uff0c\u4ee3\u7801\u7ef4\u62a4\u6210\u672c\u53d8\u9ad8\u3002<\/p>\n<pre><code>\/\/ \u5b9a\u4e49\u7b56\u7565\u63a5\u53e3\npublic interface IChannelApplyFileStrategy {\n    \/**\n     * \u6e20\u9053\u5339\u914d\u7b56\u7565\n     *\n     * @param instCode \u6e20\u9053\u540d\n     * @return \u662f\u5426\u5339\u914d\n     *\/\n    boolean match(String instCode);\n\n    \/**\n     * \u5165\u53c2\u7ec4\u88c5\n     *\n     * @param instAccountNo \u8d26\u6237\n     * @return \u8bf7\u6c42\u652f\u4ed8\u5165\u53c2\n     *\/\n    FileBillReqDTO assembleReqData(String instAccountNo);\n}\n\n\n\/\/ \u4e0d\u540c\u6e20\u9053\u5177\u4f53\u7b56\u7565\u7c7b\n@Component\npublic class AlipayChannelApplyFileStrategy implements IChannelApplyFileStrategy {\n    @Override\n    public boolean match(String instCode) {\n        return &quot;\u652f\u4ed8\u5b9d&quot;.equals(instCode);\n    }\n\n    @Override\n    public FileBillReqDTO assembleReqData(String instAccountNo) {\n        FileBillReqDTO channelReq = new FileBillReqDTO();\n        channelReq.setBusinessCode(&quot;ALIPAY_&quot; + instAccountNo + &quot;_BUSINESS&quot;);\n        channelReq.setPayTool(4);\n        channelReq.setTransType(50);\n        return channelReq;\n    }\n}\n\n@Component\npublic class WechatChannelApplyFileStrategy implements IChannelApplyFileStrategy {\n    @Override\n    public boolean match(String instCode) {\n        return &quot;\u5fae\u4fe1&quot;.equals(instCode);\n    }\n\n    @Override\n    public FileBillReqDTO assembleReqData(String instAccountNo) {\n        FileBillReqDTO channelReq = new FileBillReqDTO();\n        channelReq.setBusinessCode(&quot;WX_&quot; + instAccountNo);\n        channelReq.setPayTool(3);\n        channelReq.setTransType(13);\n        return channelReq;\n    }\n}\n\n@Component\npublic class TlbChannelApplyFileStrategy implements IChannelApplyFileStrategy {\n    @Override\n    public boolean match(String instCode) {\n        return &quot;\u901a\u8054&quot;.equals(instCode);\n    }\n\n    @Override\n    public FileBillReqDTO assembleReqData(String instAccountNo) {\n        FileBillReqDTO channelReq = new FileBillReqDTO();\n        channelReq.setBusinessCode(&quot;TL_&quot; + instAccountNo);\n        channelReq.setPayTool(5);\n        channelReq.setTransType(13);\n        return channelReq;\n    }\n}\n\n\n\/\/ \u8c03\u7528\u7c7b\n@Component\npublic class ChannelApplyFileClient {\n    \/\/ IOC\u5c5e\u6027\u81ea\u52a8\u6ce8\u5165\u7b56\u7565\u5b9e\u73b0\u7c7b\u96c6\u5408\n    @Resource\n    private List&lt;IChannelApplyFileStrategy&gt; iChannelApplyFileStrategies;\n    @Resource\n    private CNRegionDataFetcher cnRegionDataFetcher;\n\n    public String applyFileBill(String instCode, String instAccountNo) {\n        \/\/ \u4e0d\u540c\u6e20\u9053\u5165\u53c2\u7ec4\u88c5\n        IChannelApplyFileStrategy strategy = iChannelApplyFileStrategies.stream().filter(item -&gt; item.match(instCode)).findFirst().orElse(null);\n        FileBillReqDTO channelReq = strategy.assembleReqData(instAccountNo);\n\n        \/\/ \u8bf7\u6c42\u652f\u4ed8\u7cfb\u7edf\u62c9\u53d6\u8d26\u5355\u6587\u4ef6\uff0c\u540c\u6b65\u8fd4\u56de\u5904\u7406\u4e2d\uff0c\u5f02\u6b65MQ\u901a\u77e5\u4e0b\u8f7d\u7ed3\u679c\n        BaseResult&lt;FileBillResDTO&gt; result = cnRegionDataFetcher.applyFileBill(channelReq, &quot;\u8d44\u91d1\u8d26\u5355\u4e0b\u8f7d&quot;);\n        return &quot;\u5904\u7406\u4e2d&quot;;\n    }\n}<\/code><\/pre>\n<h3>\u601d\u8003<\/h3>\n<p>\u4e0a\u8ff0\u4e24\u79cd\u8bbe\u8ba1\u4f3c\u4e4e\u5bf9\u53c2\u6570\u5904\u7406\u80fd\u529b\u7684\u62bd\u8c61\u529b\u5ea6\u8fd8\u4e0d\u591f\uff0c\u662f\u5426\u80fd\u5c06\u5176\u62bd\u8c61\u4e3a\u4e00\u4e2a\u9886\u57df\u80fd\u529b\uff0c\u4ee5\u5b9e\u73b0\u53c2\u6570\u5904\u7406\u7684\u52a8\u6001\u5316\u6216\u53ef\u914d\u7f6e\u5316\uff0c\u800c\u4e0d\u518d\u4f9d\u8d56\u4e8e\u786c\u7f16\u7801\u7684\u53c2\u6570\u5904\u7406\u903b\u8f91\u3002<\/p>\n<p>\u57fa\u4e8e\u8fd9\u4e2a\u8bbe\u8ba1\u601d\u8def\uff0c\u53ef\u4ee5\u8fdb\u884c\u4ee5\u4e0b\u6b65\u9aa4\uff1a<\/p>\n<ul>\n<li>\u5b9a\u4e49\u9886\u57df\u6a21\u578b\uff1a\u786e\u5b9a\u9700\u8981\u5904\u7406\u7684\u9886\u57df\u5bf9\u8c61\u548c\u9886\u57df\u64cd\u4f5c\u3002\u5728\u8fd9\u4e2a\u573a\u666f\u4e2d\uff0c\u9886\u57df\u5bf9\u8c61\u8868\u793a\u4e0d\u540c\u6e20\u9053\uff0c\u9886\u57df\u64cd\u4f5c\u8868\u793a\u53c2\u6570\u5904\u7406\u548c\u63a5\u53e3\u8c03\u7528\u3002<\/li>\n<li>\u521b\u5efa\u914d\u7f6e\u8868\uff1a\u8bbe\u8ba1\u4e00\u4e2a\u914d\u7f6e\u8868\uff0c\u7528\u4e8e\u5b58\u50a8\u4e0d\u540c\u6e20\u9053\u548c\u5176\u5bf9\u5e94\u7684\u53c2\u6570\u5904\u7406\u7b56\u7565\uff0c\u8be5\u8868\u53ef\u4ee5\u5305\u542b\u6e20\u9053\u540d\u79f0\u548c\u7b56\u7565\u6807\u8bc6\u7b49\u5b57\u6bb5\u3002<\/li>\n<li>\u5b9e\u73b0\u52a8\u6001\u53c2\u6570\u5904\u7406\u7b56\u7565\uff1a\u6839\u636e\u914d\u7f6e\u8868\u7684\u4fe1\u606f\uff0c\u5728\u7cfb\u7edf\u8fd0\u884c\u65f6\u52a8\u6001\u52a0\u8f7d\u548c\u6267\u884c\u53c2\u6570\u5904\u7406\u7b56\u7565\u3002\u53ef\u4ee5\u4f7f\u7528 SpEL \u8868\u8fbe\u5f0f\u89e3\u6790\u548c\u53cd\u5c04\u7684\u65b9\u5f0f\u6765\u5b9e\u73b0\u3002<\/li>\n<li>\u914d\u7f6e\u5173\u8054\u5173\u7cfb\uff1a\u901a\u8fc7\u914d\u7f6e\u8868\u7ef4\u62a4\u6e20\u9053\u548c\u5176\u5bf9\u5e94\u53c2\u6570\u5904\u7406\u7b56\u7565\u7684\u5173\u8054\u5173\u7cfb\u3002\u5728\u65b0\u589e\u6e20\u9053\u65f6\uff0c\u53ea\u9700\u8981\u5728\u914d\u7f6e\u8868\u4e2d\u6dfb\u52a0\u4e00\u6761\u65b0\u7684\u914d\u7f6e\u8bb0\u5f55\uff0c\u6307\u660e\u6e20\u9053\u540d\u79f0\u548c\u5bf9\u5e94\u7684\u7b56\u7565\u6807\u8bc6\u3002<\/li>\n<\/ul>\n<p>\u901a\u8fc7\u4ee5\u4e0a\u8bbe\u8ba1\u601d\u8def\uff0c\u53ef\u4ee5\u5b9e\u73b0\u4e00\u4e2a\u53ef\u914d\u7f6e\u7684\u9886\u57df\u80fd\u529b\uff0c\u63d0\u9ad8\u4ee3\u7801\u7684\u53ef\u7ef4\u62a4\u6027\u548c\u6269\u5c55\u6027\uff0c\u540c\u65f6\u964d\u4f4e\u4e86\u5f00\u53d1\u548c\u90e8\u7f72\u7684\u5de5\u4f5c\u91cf\u3002\u914d\u7f6e\u8868\u7684\u7ef4\u62a4\u4e5f\u63d0\u4f9b\u4e86\u66f4\u5927\u7684\u7075\u6d3b\u6027\uff0c\u4f7f\u5f97\u7cfb\u7edf\u53ef\u4ee5\u5feb\u901f\u54cd\u5e94\u548c\u9002\u5e94\u4e0d\u540c\u6e20\u9053\u7684\u53d8\u5316\u548c\u9700\u6c42\u3002<\/p>\n<h3>\u65b9\u6848\u9009\u7528<\/h3>\n<p>\u4e3a\u4e86\u5b9e\u73b0\u4e0d\u540c\u6e20\u9053\u53c2\u6570\u7684\u52a8\u6001\u5316\u914d\u7f6e\uff0c\u6211\u4eec\u5f15\u5165\u4e86 Spring \u8868\u8fbe\u5f0f\u8bed\u8a00\uff08SpEL\uff09\u3002\u901a\u8fc7\u4f7f\u7528 SpEL\uff0c\u6211\u4eec\u53ef\u4ee5\u5c06\u53c2\u6570\u5904\u7406\u903b\u8f91\u8868\u8fbe\u4e3a\u5b57\u7b26\u4e32\u8868\u8fbe\u5f0f\uff0c\u5e76\u5728\u8fd0\u884c\u65f6\u52a8\u6001\u5730\u89e3\u6790\u548c\u6267\u884c\u8868\u8fbe\u5f0f\uff0c\u4ece\u800c\u5b9e\u73b0\u5bf9\u4e0d\u540c\u6e20\u9053\u53c2\u6570\u7684\u5904\u7406\u3002\u4f7f\u7528 SpEL \u4e0d\u4ec5\u63d0\u9ad8\u4e86\u5904\u7406\u53c2\u6570\u7684\u7075\u6d3b\u6027\u548c\u53ef\u914d\u7f6e\u6027\uff0c\u8fd8\u80fd\u66f4\u597d\u5730\u9075\u5faa\u9762\u5411\u5bf9\u8c61\u8bbe\u8ba1\u539f\u5219\u548c\u9886\u57df\u9a71\u52a8\u8bbe\u8ba1\u601d\u60f3\uff0c\u5c06\u53c2\u6570\u5904\u7406\u89c6\u4e3a\u4e00\u4e2a\u5177\u6709\u72ec\u7acb\u804c\u8d23\u7684\u9886\u57df\u6a21\u578b\u3002<\/p>\n<h2>\u4e8c\u3001\u5f15\u5165SpEL<\/h2>\n<h3>\u4ecb\u7ecd<\/h3>\n<p>SpEL \u5373 Spring \u8868\u8fbe\u5f0f\u8bed\u8a00\uff0c\u662f\u4e00\u79cd\u5f3a\u5927\u7684\u8868\u8fbe\u5f0f\u8bed\u8a00\uff0c\u53ef\u4ee5\u5728\u8fd0\u884c\u65f6\u8bc4\u4f30\u8868\u8fbe\u5f0f\u5e76\u751f\u6210\u503c\u3002SpEL \u6700\u5e38\u7528\u4e8e Spring Framework \u4e2d\u7684\u6ce8\u89e3\u548c XML \u914d\u7f6e\u6587\u4ef6\u4e2d\u7684\u5c5e\u6027\uff0c\u4e5f\u53ef\u4ee5\u4ee5\u7f16\u7a0b\u65b9\u5f0f\u5728 Java \u5e94\u7528\u7a0b\u5e8f\u4e2d\u4f7f\u7528\u3002<\/p>\n<h3>SpEL\u7684\u5e94\u7528\u573a\u666f<\/h3>\n<ul>\n<li>\u52a8\u6001\u53c2\u6570\u914d\u7f6e\uff1a\u53ef\u4ee5\u901a\u8fc7 SpEL \u5c06\u5e94\u7528\u7a0b\u5e8f\u4e2d\u7684\u5404\u79cd\u53c2\u6570\u914d\u7f6e\u5316\uff0c\u4f8b\u5982\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u3001\u4e1a\u52a1\u89c4\u5219\u7b49\u3002\u901a\u8fc7\u52a8\u6001\u914d\u7f6e\uff0c\u53ef\u4ee5\u5728\u8fd0\u884c\u65f6\u6839\u636e\u4e0d\u540c\u7684\u73af\u5883\u6216\u9700\u6c42\u6765\u8fdb\u884c\u7075\u6d3b\u7684\u53c2\u6570\u8bbe\u7f6e\u3002<\/li>\n<li>\u8fd0\u884c\u65f6\u6ce8\u5165\uff1a\u4f7f\u7528SpEL\uff0c\u53ef\u4ee5\u5728\u8fd0\u884c\u65f6\u52a8\u6001\u6ce8\u5165\u5c5e\u6027\u503c\uff0c\u800c\u4e0d\u9700\u8981\u5728\u7f16\u7801\u65f6\u786c\u7f16\u7801\u3002\u8fd9\u5bf9\u4e8e\u9700\u8981\u6839\u636e\u5f53\u524d\u4e0a\u4e0b\u6587\u52a8\u6001\u8c03\u6574\u5c5e\u6027\u503c\u7684\u573a\u666f\u975e\u5e38\u6709\u7528\u3002<\/li>\n<li>\u6761\u4ef6\u5224\u65ad\u4e0e\u4e1a\u52a1\u903b\u8f91\uff1aSpEL\u652f\u6301\u590d\u6742\u7684\u6761\u4ef6\u5224\u65ad\u548c\u903b\u8f91\u8ba1\u7b97\uff0c\u53ef\u4ee5\u65b9\u4fbf\u5730\u5728\u8fd0\u884c\u65f6\u6839\u636e\u6761\u4ef6\u6765\u6267\u884c\u7279\u5b9a\u7684\u4ee3\u7801\u903b\u8f91\u3002\u4f8b\u5982\uff0c\u5728\u6743\u9650\u63a7\u5236\u4e2d\uff0c\u53ef\u4ee5\u4f7f\u7528SpEL\u8fdb\u884c\u8d44\u6e90\u548c\u89d2\u8272\u7684\u52a8\u6001\u6388\u6743\u5224\u65ad\u3002<\/li>\n<li>\u8868\u8fbe\u5f0f\u6a21\u677f\u5316\uff1aSpEL\u652f\u6301\u5728\u8868\u8fbe\u5f0f\u4e2d\u4f7f\u7528\u6a21\u677f\u8bed\u6cd5\uff0c\u5141\u8bb8\u5c06\u4e00\u4e9b\u5e38\u7528\u7684\u8868\u8fbe\u5f0f\u4f5c\u4e3a\u6a21\u677f\uff0c\u7136\u540e\u5728\u8fd0\u884c\u65f6\u901a\u8fc7\u586b\u5145\u4e0d\u540c\u7684\u503c\u6765\u751f\u6210\u6700\u7ec8\u7684\u8868\u8fbe\u5f0f\u3002\u8fd9\u4f7f\u5f97\u8868\u8fbe\u5f0f\u7684\u590d\u7528\u548c\u52a8\u6001\u751f\u6210\u66f4\u52a0\u65b9\u4fbf\u3002<\/li>\n<\/ul>\n<p>\u603b\u7684\u6765\u8bf4\uff0cSpEL\u53ef\u4ee5\u63d0\u4f9b\u66f4\u5927\u7684\u7075\u6d3b\u6027\u548c\u53ef\u914d\u7f6e\u6027\uff0c\u4f7f\u5f97\u5e94\u7528\u7a0b\u5e8f\u7684\u53c2\u6570\u914d\u7f6e\u548c\u903b\u8f91\u5904\u7406\u66f4\u4e3a\u52a8\u6001\u548c\u53ef\u6269\u5c55\u3002\u5b83\u7684\u5f3a\u5927\u8868\u8fbe\u80fd\u529b\u548c\u8fd0\u884c\u65f6\u6c42\u503c\u7279\u6027\u53ef\u4ee5\u5728\u5f88\u591a\u573a\u666f\u4e0b\u53d1\u6325\u4f5c\u7528\uff0c\u7b80\u5316\u5f00\u53d1\u548c\u7ef4\u62a4\u5de5\u4f5c\u3002<\/p>\n<h3>\u7b80\u5355\u4e3e\u4f8b<\/h3>\n<pre><code>\/**\n\n * \u9a8c\u8bc1\u6570\u5b57\u662f\u5426\u5927\u4e8e10\n *\n * @param number \u6570\u5b57\n * @return \u7ed3\u679c\n *\/\npublic String spELSample(int number) {\n    \/\/ \u521b\u5efaExpressionParser\u5bf9\u8c61\uff0c\u7528\u4e8e\u89e3\u6790SpEL\u8868\u8fbe\u5f0f\n    ExpressionParser parser = new SpelExpressionParser();\n    String expressionStr = &quot;#number &gt; 10 ? 'true' : 'false'&quot;;\n    Expression expression = parser.parseExpression(expressionStr);\n\n    \/\/ \u521b\u5efaEvaluationContext\u5bf9\u8c61\uff0c\u7528\u4e8e\u8bbe\u7f6e\u53c2\u6570\u503c\n    StandardEvaluationContext context = new StandardEvaluationContext();\n    context.setVariable(&quot;number&quot;, number);\n\n    \/\/ \u6c42\u89e3\u8868\u8fbe\u5f0f\uff0c\u83b7\u53d6\u7ed3\u679c\n    return expression.getValue(context, String.class);\n}<\/code><\/pre>\n<h3>\u5904\u7406\u8fc7\u7a0b\u5206\u6790<\/h3>\n<p>\u7ed9\u5b9a\u4e00\u4e2a\u5b57\u7b26\u4e32\u6700\u7ec8\u89e3\u6790\u6210\u4e00\u4e2a\u503c\uff0c\u8fd9\u4e2d\u95f4\u81f3\u5c11\u7ecf\u5386\uff1a\u5b57\u7b26\u4e32-&gt;\u8bed\u6cd5\u5206\u6790-&gt;\u751f\u6210\u8868\u8fbe\u5f0f\u5bf9\u8c61-&gt;\u6dfb\u52a0\u6267\u884c\u4e0a\u4e0b\u6587-&gt;\u6267\u884c\u6b64\u8868\u8fbe\u5f0f\u5bf9\u8c61-&gt;\u8fd4\u56de\u7ed3\u679c\u3002<\/p>\n<p>\u5173\u4e8e SpEL \u7684\u51e0\u4e2a\u6982\u5ff5\uff1a<\/p>\n<ul>\n<li>\u8868\u8fbe\u5f0f\uff08\u201c\u5e72\u4ec0\u4e48\u201d\uff09\uff1aSpEL \u7684\u6838\u5fc3\uff0c\u6240\u4ee5\u8868\u8fbe\u5f0f\u8bed\u8a00\u90fd\u662f\u56f4\u7ed5\u8868\u8fbe\u5f0f\u8fdb\u884c\u7684\u3002<\/li>\n<li>\u89e3\u6790\u5668\uff08\u201c\u8c01\u6765\u5e72\u201d\uff09\uff1a\u7528\u4e8e\u5c06\u5b57\u7b26\u4e32\u8868\u8fbe\u5f0f\u89e3\u6790\u4e3a\u8868\u8fbe\u5f0f\u5bf9\u8c61\u3002<\/li>\n<li>\u4e0a\u4e0b\u6587\uff08\u201c\u5728\u54ea\u5e72\u201d\uff09\uff1a\u8868\u8fbe\u5f0f\u5bf9\u8c61\u6267\u884c\u7684\u73af\u5883\uff0c\u8be5\u73af\u5883\u53ef\u80fd\u5b9a\u4e49\u53d8\u91cf\u3001\u5b9a\u4e49\u81ea\u5b9a\u4e49\u51fd\u6570\u3001\u63d0\u4f9b\u7c7b\u578b\u8f6c\u6362\u7b49\u7b49\u3002<\/li>\n<li>Root \u6839\u5bf9\u8c61\u53ca\u6d3b\u52a8\u4e0a\u4e0b\u6587\u5bf9\u8c61\uff08\u201c\u5bf9\u8c01\u5e72\u201d\uff09\uff1aRoot \u6839\u5bf9\u8c61\u662f\u9ed8\u8ba4\u7684\u6d3b\u52a8\u4e0a\u4e0b\u6587\u5bf9\u8c61\uff0c\u6d3b\u52a8\u4e0a\u4e0b\u6587\u5bf9\u8c61\u8868\u793a\u4e86\u5f53\u524d\u8868\u8fbe\u5f0f\u64cd\u4f5c\u7684\u5bf9\u8c61\u3002<\/li>\n<\/ul>\n<p>\u5904\u7406\u6d41\u7a0b\uff1a<\/p>\n<ul>\n<li>\u8868\u8fbe\u5f0f\u89e3\u6790\uff1a\u9996\u5148\uff0cSpEL \u5bf9\u8868\u8fbe\u5f0f\u8fdb\u884c\u89e3\u6790\uff0c\u5c06\u5176\u8f6c\u6362\u4e3a\u5185\u90e8\u8868\u793a\u5f62\u5f0f\u5373\u62bd\u8c61\u8bed\u6cd5\u6811\uff08AST\uff09\u6216\u8005\u5176\u4ed6\u5f62\u5f0f\u7684\u4e2d\u95f4\u8868\u793a\u3002<\/li>\n<li>\u4e0a\u4e0b\u6587\u8bbe\u7f6e\uff1a\u5728\u8868\u8fbe\u5f0f\u6c42\u503c\u4e4b\u524d\uff0c\u9700\u8981\u8bbe\u7f6e\u4e0a\u4e0b\u6587\u4fe1\u606f\u3002\u4e0a\u4e0b\u6587\u53ef\u4ee5\u662f\u4e00\u4e2a\u5bf9\u8c61\uff0c\u5b83\u5305\u542b\u4e86\u8868\u8fbe\u5f0f\u4e2d\u8981\u5f15\u7528\u7684\u53d8\u91cf\u548c\u65b9\u6cd5\u3002\u901a\u8fc7\u5c06\u4e0a\u4e0b\u6587\u5bf9\u8c61\u4f20\u9012\u7ed9\u8868\u8fbe\u5f0f\u6c42\u503c\u5f15\u64ce\uff0c\u8868\u8fbe\u5f0f\u53ef\u4ee5\u8bbf\u95ee\u5e76\u64cd\u4f5c\u4e0a\u4e0b\u6587\u4e2d\u7684\u6570\u636e\u3002<\/li>\n<li>\u8868\u8fbe\u5f0f\u6c42\u503c\uff1a\u4e00\u65e6\u8868\u8fbe\u5f0f\u88ab\u89e3\u6790\u548c\u4e0a\u4e0b\u6587\u8bbe\u7f6e\u5b8c\u6210\uff0cSpEL \u5f00\u59cb\u6c42\u503c\u8868\u8fbe\u5f0f\u3002\u6c42\u503c\u8fc7\u7a0b\u9075\u5faa AST \u7684\u7ed3\u6784\uff0c\u4ece\u6839\u8282\u70b9\u5f00\u59cb\uff0c\u9010\u7ea7\u5411\u4e0b\u904d\u5386\u5e76\u5bf9\u6bcf\u4e2a\u8282\u70b9\u8fdb\u884c\u6c42\u503c\u3002\u6c42\u503c\u8fc7\u7a0b\u53ef\u80fd\u6d89\u53ca\u9012\u5f52\u64cd\u4f5c\uff0c\u76f4\u5230\u6240\u6709\u8282\u70b9\u90fd\u88ab\u6c42\u503c\u3002<\/li>\n<li>\n<p>\u7ed3\u679c\u8fd4\u56de\uff1a\u8868\u8fbe\u5f0f\u6c42\u503c\u7684\u7ed3\u679c\u4f5c\u4e3a\u6700\u7ec8\u7ed3\u679c\u8fd4\u56de\u7ed9\u8c03\u7528\u8005\u3002\u8fd4\u56de\u7ed3\u679c\u53ef\u4ee5\u662f\u4efb\u4f55\u7c7b\u578b\uff0c\u5305\u62ec\u57fa\u672c\u7c7b\u578b\u3001\u5bf9\u8c61\u3001\u96c6\u5408\u7b49\u3002<br \/><img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044644569\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\" loading=\"lazy\"><\/p>\n<h2>\u4e09\u3001SpEL\u5e94\u7528\u5b9e\u6218<\/h2>\n<\/li>\n<\/ul>\n<h3>\u914d\u7f6e\u8868\u8bbe\u8ba1<\/h3>\n<p><strong>\u7ef4\u62a4\u6e20\u9053\u548c\u5176\u5bf9\u5e94\u53c2\u6570\u5904\u7406\u7b56\u7565\u7684\u5173\u8054\u5173\u7cfb\uff1a<\/strong><\/p>\n<p><strong>\u6e20\u9053\u8868<\/strong><br \/><img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044644570\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\" loading=\"lazy\"><br \/><strong>\u6e20\u9053 API \u8868<\/strong><br \/><img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044644571\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\" loading=\"lazy\"><br \/><strong>\u8bf4\u660e\uff1a\u00a0<\/strong>\u6bcf\u65b0\u589e\u4e00\u4e2a\u6e20\u9053\u63a5\u5165\u65f6\u4e0d\u9700\u8981\u8fdb\u884c\u4ee3\u7801\u5f00\u53d1\uff0c\u53ea\u9700\u5728\u914d\u7f6e\u8868\u4e2d\u7ef4\u62a4\u5173\u8054\u5173\u7cfb\u3002\u6839\u636e inst_code \u5339\u914d\u5bf9\u5e94\u7b56\u7565\u6807\u8bc6 channel_code\uff0c\u6839\u636e\u7b56\u7565\u6807\u8bc6\u627e\u5230\u5177\u4f53\u53c2\u6570\u5904\u7406\u7b56\u7565\u8868\u8fbe\u5f0f\u3002<\/p>\n<h3>\u5b9e\u73b0\u52a8\u6001\u53c2\u6570\u5904\u7406\u7b56\u7565<\/h3>\n<pre><code>\/\/ \u5b9a\u4e49\u89e3\u6790\u5de5\u5177\u7c7b\n\n@Slf4j\n@Service\n@CacheConfig(cacheNames = CacheNames.EXPRESSION)\npublic class ExpressionUtil {\n    private final ExpressionParser expressionParser = new SpelExpressionParser();\n\n    \/\/ \u521b\u5efa\u4e0a\u4e0b\u6587\u5bf9\u8c61\uff0c\u8bbe\u7f6e\u81ea\u5b9a\u4e49\u53d8\u91cf\u3001\u81ea\u5b9a\u4e49\u51fd\u6570\n    public StandardEvaluationContext createContext(String instAccountNo){\n        StandardEvaluationContext context = new StandardEvaluationContext();\n        context.setVariable(&quot;instAccountNo&quot;, instAccountNo);\n        \/\/ \u6ce8\u518c\u81ea\u5b9a\u4e49\u51fd\u6570\n        this.registryFunction(context);\n        return context;\n    }\n\n    \/\/ \u6ce8\u518c\u81ea\u5b9a\u4e49\u51fd\u6570\n    private void registryFunction(StandardEvaluationContext context) {\n        try {\n            context.addPropertyAccessor(new MapAccessor());\n            context.registerFunction(&quot;yuanToCent&quot;, ExpressionHelper.class.getDeclaredMethod(&quot;yuanToCent&quot;, String.class));\n            context.registerFunction(&quot;substringBefore&quot;, StringUtils.class.getDeclaredMethod(&quot;substringBefore&quot;,String.class,String.class));\n        } catch (Exception e) {\n            log.info(&quot;SpEL\u51fd\u6570\u6ce8\u518c\u5931\u8d25:&quot;, e);\n        }\n    }\n\n    \/\/ \u5f00\u542f\u7f13\u5b58\uff0c\u4f7f\u7528\u89e3\u6790\u5668\u89e3\u6790\u8868\u8fbe\u5f0f\uff0c\u8fd4\u56de\u8868\u8fbe\u5f0f\u5bf9\u8c61\n    @Cacheable(key=&quot;'getExpressionWithCache:'+#cacheKey&quot;, unless = &quot;#result == null&quot;)\n    public Expression getExpressionWithCache(String cacheKey, String expressionString) {\n        try {\n            return expressionParser.parseExpression(expressionString);\n        } catch (Exception e) {\n            log.error(&quot;SpEL\u8868\u8fbe\u5f0f\u89e3\u6790\u5f02\u5e38,\u8868\u8fbe\u5f0f:[{}]&quot;, expressionString, e);\n            throw new BizException(ReturnCode.EXCEPTION.getCode(),String.format(&quot;SpEL\u8868\u8fbe\u5f0f\u89e3\u6790\u5f02\u5e38:[%s]&quot;,expressionString),e);\n        }\n    }\n}\n\n\n\/\/ \u5b9a\u4e49\u89e3\u6790\u7c7b\uff1a\n@Slf4j\n@Service\npublic class ExpressionService {\n    @Resource\n    private ExpressionUtil expressionUtil;\n\n    public FileBillReqDTO transform(ChannelEntity channel, String instAccountNo) throws Exception {\n        \/\/ \u83b7\u53d6\u4e0a\u4e0b\u6587\u5bf9\u8c61(\u53d8\u91cf\u8bbe\u7f6e\u3001\u51fd\u6570\u8bbe\u7f6e)\n        StandardEvaluationContext context = expressionUtil.createContext(instAccountNo);\n        \/\/ \u83b7\u53d6\u652f\u4ed8\u8bf7\u6c42\u7c7b\u5bf9\u8c61\n        FileBillReqDTO target = ClassHelper.newInstance(FileBillReqDTO.class);\n        \/\/ t_channel_api\u8868\u914d\u7f6e\u7684api\u6620\u5c04\u8868\u8fbe\u5f0f\n        for (ChannelApiEntity api : channel.getApis()) {\n            \/\/ \u901a\u8fc7\u53cd\u5c04\u83b7\u53d6FileBillReqDTO\u7c7b\u5c5e\u6027\u540d\u5bf9\u8c61\n            Field field = ReflectionUtils.findField(FileBillReqDTO.class, api.getFieldCode());\n            \/\/ \u8868\u8fbe\u5f0f\n            String expressionString = api.getFieldExpression();\n            \/\/ \u5f00\u542f\u7f13\u5b58\uff0c\u4f7f\u7528\u89e3\u6790\u5668\u89e3\u6790\u8868\u8fbe\u5f0f\uff0c\u8fd4\u56de\u8868\u8fbe\u5f0f\u5bf9\u8c61\n            Expression expression = expressionUtil.getExpressionWithCache(api.fieldExpressionKey(), expressionString);\n            \/\/ \u901a\u8fc7\u8868\u8fbe\u5f0f\u5bf9\u8c61\u83b7\u53d6\u89e3\u6790\u540e\u7684\u7ed3\u679c\u503c\n            Object value = expression.getValue(context, FileBillReqDTO.class);\n            \/\/ \u5c06\u7ed3\u679c\u901a\u8fc7\u53cd\u5c04\u8d4b\u503c\u7ed9FileBillReqDTO\u5bf9\u8c61\u4e2d\u6307\u5b9a\u5c5e\u6027\u5b57\u6bb5\n            field.setAccessible(true);\n            field.set(target, value);\n        }\n        \/\/ \u8fd4\u56de\u89e3\u6790\u8d4b\u503c\u540e\u7684\u5b8c\u6574\u5bf9\u8c61\n        return target;\n    }\n}\n\n\n\/\/ \u8c03\u7528\u7c7b\n@Component\npublic class ChannelApplyFileClient {\n    @Resource\n    private CNRegionDataFetcher cnRegionDataFetcher;\n    @Resource\n    private ExpressionService expressionService;\n    @Resource\n    private ChannelRepository channelRepository;\n\n    public String applyFileBill(String instCode, String instAccountNo) {\n        \/\/ \u6839\u636e\u6e20\u9053\u7801\u67e5\u8be2t_channel\u3001t_channel_api\u8868\uff0c\u8fd4\u56deChannelEntity\u5bf9\u8c61\n        ChannelEntity channel = channelRepository.findByInstCode(instCode);\n        \/\/ \u901a\u8fc7SpEL\u89e3\u6790t_channel_api\u8868\u4e2d\u8868\u8fbe\u5f0f\uff0c\u5e76\u5c06\u503c\u8d4b\u503c\u7ed9\u5bf9\u5e94\u5c5e\u6027\u4e2d\uff0c\u8fd4\u56de\u5b8c\u6574\u8bf7\u6c42\u5bf9\u8c61\n        FileBillReqDTO channelReq = expressionService.transform(channel, instAccountNo);\n        \/\/ \u8bf7\u6c42\u652f\u4ed8\u7cfb\u7edf\u62c9\u53d6\u8d26\u5355\u6587\u4ef6\uff0c\u540c\u6b65\u8fd4\u56de\u5904\u7406\u4e2d\uff0c\u5f02\u6b65MQ\u901a\u77e5\u4e0b\u8f7d\u7ed3\u679c\n        BaseResult&lt;FileBillResDTO&gt; result = cnRegionDataFetcher.applyFileBill(channelReq, &quot;\u8d44\u91d1\u8d26\u5355\u4e0b\u8f7d&quot;);\n        return &quot;\u5904\u7406\u4e2d&quot;;\n    }\n}<\/code><\/pre>\n<p><strong>\u4f18\u70b9<\/strong>\uff1a\u901a\u8fc7\u9886\u57df\u80fd\u529b\u62bd\u8c61\u548c SpEL \u7684\u8fd0\u7528\uff0c\u5b9e\u73b0\u53c2\u6570\u5904\u7406\u7684\u52a8\u6001\u5316\u6216\u53ef\u914d\u7f6e\u5316\uff0c\u4e0d\u518d\u4f9d\u8d56\u4e8e\u786c\u7f16\u7801\u7684\u53c2\u6570\u5904\u7406\u903b\u8f91\uff0c\u63d0\u9ad8\u4ee3\u7801\u7684\u53ef\u7ef4\u62a4\u6027\u548c\u6269\u5c55\u6027\uff0c\u540c\u65f6\u964d\u4f4e\u4e86\u5f00\u53d1\u548c\u90e8\u7f72\u7684\u5de5\u4f5c\u91cf\uff0c\u66f4\u597d\u5730\u9075\u5faa\u9762\u5411\u5bf9\u8c61\u8bbe\u8ba1\u539f\u5219\u548c\u9886\u57df\u9a71\u52a8\u8bbe\u8ba1\u601d\u60f3\uff0c\u6210\u4e3a\u4e00\u4e2a\u5177\u6709\u72ec\u7acb\u804c\u8d23\u7684\u9886\u57df\u6a21\u578b\u3002<\/p>\n<h2>\u56db\u3001\u6269\u5c55-\u5176\u4ed6\u5e94\u7528-Excel\u89e3\u6790<\/h2>\n<h3>\u9700\u6c42<\/h3>\n<p>\u8d44\u91d1\u5e73\u53f0\u9700\u4ece\u4e0d\u540c\u7684\u6e20\u9053\u4e0b\u8f7d\u8d26\u5355\uff0c\u5e76\u5bf9\u8d26\u5355\u8fdb\u884c\u89e3\u6790\uff0c\u89e3\u6790\u540e\u7684\u6570\u636e\u843d\u5165\u6d41\u6c34\u8868\u3002\u6ce8\u610f\u4e0d\u540c\u6e20\u9053\u7684\u8d26\u5355\u7684\u5934\u5b57\u6bb5\u548c\u683c\u5f0f\u5b58\u5728\u5dee\u5f02\u3002<\/p>\n<h3>\u65b9\u6848<\/h3>\n<p>\u4f20\u7edf\u7684\u65b9\u5f0f\u4e2d\uff0c\u89e3\u6790 Excel \u901a\u5e38\u9700\u8981\u901a\u8fc7\u521b\u5efa\u5b9e\u4f53\u7c7b\u6765\u6620\u5c04 Excel \u7684\u7ed3\u6784\u548c\u6570\u636e\u3002\u6bcf\u4e2a\u5b9e\u4f53\u7c7b\u4ee3\u8868\u4e00\u4e2a Excel \u884c\u6216\u5217\uff0c\u9700\u8981\u624b\u52a8\u7f16\u5199\u4ee3\u7801\u6765\u5c06 Excel \u6570\u636e\u89e3\u6790\u4e3a\u76f8\u5e94\u7684\u5b9e\u4f53\u5bf9\u8c61\u3002<\/p>\n<p>\u800c\u4f7f\u7528 SpEL \u65b9\u5f0f\u89e3\u6790 Excel \u5219\u5177\u6709\u66f4\u52a0\u52a8\u6001\u548c\u7075\u6d3b\u7684\u7279\u6027\uff0c\u907f\u514d\u4e86\u663e\u5f0f\u521b\u5efa\u548c\u7ef4\u62a4\u5927\u91cf\u7684\u5b9e\u4f53\u7c7b\u3002\u4ee5\u4e0b\u662f\u4f7f\u7528 SpEL \u65b9\u5f0f\u52a8\u6001\u89e3\u6790 Excel \u7684\u4e00\u822c\u6b65\u9aa4\uff1a<\/p>\n<ul>\n<li>\u4f7f\u7528 Apache POI \u7b49\u5de5\u5177\u8bfb\u53d6 Excel \u6570\u636e\u8868\u3002<\/li>\n<li>\u6839\u636e\u914d\u7f6e\u8868\uff0c\u5c06 Excel \u4e2d\u7684\u5217\u4e0e SpEL \u8868\u8fbe\u5f0f\u8fdb\u884c\u5173\u8054\u3002<\/li>\n<li>\u4f7f\u7528 SpEL \u89e3\u6790\u5668\uff0c\u5728\u8fd0\u884c\u65f6\u89e3\u6790\u8fd9\u4e9b SpEL \u8868\u8fbe\u5f0f\u3002<\/li>\n<li>\u5c06\u89e3\u6790\u540e\u7684\u7ed3\u679c\u505a\u6570\u636e\u6e05\u6d17\u540e\u843d\u8868\uff0c\u5e94\u7528\u4e8e\u73b0\u91d1\u6d41\u6253\u6807\u4e1a\u52a1\u3002<\/li>\n<\/ul>\n<p>\u914d\u7f6e\u8868\u4e2d\u7ef4\u62a4\u7684\u5173\u8054\u5173\u7cfb\uff1a\uff08\u8868\u8fbe\u5f0f\u4e2d #source.column \u53d8\u91cf\u8868\u793a\u5217\u4e0e Excel Sample \u5217\u76f8\u5bf9\u5e94\uff09<br \/><img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044644572\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\" loading=\"lazy\"><br \/><strong>Excel Sample\uff1a<\/strong><br \/><img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044644573\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\" loading=\"lazy\"><\/p>\n<h2>\u4e94\u3001\u603b\u7ed3<\/h2>\n<p>\u603b\u7684\u6765\u8bf4\uff0cSpEL \u8868\u8fbe\u5f0f\u8bed\u8a00\u5177\u5907\u52a8\u6001\u6027\u3001\u7075\u6d3b\u6027\u3001\u53ef\u6269\u5c55\u6027\u7b49\u4f18\u70b9\u3002\u7ed3\u5408\u5177\u4f53\u4e1a\u52a1\u9700\u6c42\u548c\u7cfb\u7edf\u8bbe\u8ba1\uff0c\u5176\u53ef\u5e94\u7528\u4e8e\u5f88\u591a\u7cfb\u7edf\u573a\u666f\uff1a<\/p>\n<ul>\n<li>Excel \u89e3\u6790\uff1aSpEL \u53ef\u4ee5\u7528\u4e8e\u89e3\u6790 Excel \u8868\u683c\u4e2d\u7684\u6570\u636e\u3002\u53ef\u4ee5\u4f7f\u7528 SpEL \u8868\u8fbe\u5f0f\u6765\u6307\u5b9a\u9700\u8981\u89e3\u6790\u7684\u5355\u5143\u683c\u3001\u884c\u3001\u5217\u7b49\u7b49\uff0c\u63d0\u53d6\u6570\u636e\u5e76\u5e94\u7528\u76f8\u5e94\u7684\u903b\u8f91\u3002\u8fd9\u4f7f\u5f97\u89e3\u6790\u8fc7\u7a0b\u66f4\u52a0\u7075\u6d3b\u548c\u53ef\u6269\u5c55\u3002<\/li>\n<li>\u89c4\u5219\u5f15\u64ce\uff1a\u5728\u4f7f\u7528\u89c4\u5219\u5f15\u64ce\u65f6\uff0cSpEL \u53ef\u4ee5\u7528\u4e8e\u5b9a\u4e49\u89c4\u5219\u6761\u4ef6\u548c\u6267\u884c\u52a8\u4f5c\u3002\u901a\u8fc7 SpEL \u8868\u8fbe\u5f0f\uff0c\u53ef\u4ee5\u52a8\u6001\u5730\u6839\u636e\u7279\u5b9a\u7684\u6761\u4ef6\u5bf9\u6570\u636e\u8fdb\u884c\u5904\u7406\u548c\u51b3\u7b56\u3002\u8fd9\u4f7f\u5f97\u89c4\u5219\u5f15\u64ce\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u5728\u8fd0\u884c\u65f6\u8fdb\u884c\u7075\u6d3b\u7684\u5224\u65ad\u548c\u51b3\u7b56\u3002<\/li>\n<li>\u6a21\u677f\u5f15\u64ce\uff1aSpEL \u53ef\u4ee5\u7528\u4e8e\u586b\u5145\u6a21\u677f\u6570\u636e\u3002\u901a\u8fc7 SpEL \u8868\u8fbe\u5f0f\uff0c\u53ef\u4ee5\u5728\u6a21\u677f\u4e2d\u5f15\u7528\u5bf9\u8c61\u7684\u5c5e\u6027\u3001\u65b9\u6cd5\u6216\u51fd\u6570\u3002\u8fd9\u4f7f\u5f97\u6a21\u677f\u5f15\u64ce\u53ef\u4ee5\u6839\u636e\u5bf9\u8c61\u7684\u5c5e\u6027\u52a8\u6001\u5730\u751f\u6210\u5185\u5bb9\u3002<\/li>\n<li>\u914d\u7f6e\u6587\u4ef6\u89e3\u6790\uff1aSpEL \u53ef\u4ee5\u7528\u4e8e\u89e3\u6790\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684\u52a8\u6001\u503c\u3002\u901a\u8fc7 SpEL \u8868\u8fbe\u5f0f\uff0c\u53ef\u4ee5\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u5f15\u7528\u5176\u4ed6\u5c5e\u6027\u6216\u65b9\u6cd5\u7684\u503c\u3002\u8fd9\u4f7f\u5f97\u914d\u7f6e\u6587\u4ef6\u5177\u5907\u52a8\u6001\u6027\uff0c\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u8fdb\u884c\u52a8\u6001\u7684\u914d\u7f6e\u548c\u8c03\u6574\u3002<\/li>\n<li>\u9a8c\u8bc1\u89c4\u5219\uff1a\u5728\u6570\u636e\u9a8c\u8bc1\u7684\u573a\u666f\u4e2d\uff0cSpEL \u53ef\u4ee5\u7528\u4e8e\u5b9a\u4e49\u9a8c\u8bc1\u89c4\u5219\u3002\u901a\u8fc7 SpEL \u8868\u8fbe\u5f0f\uff0c\u53ef\u4ee5\u5bf9\u6570\u636e\u8fdb\u884c\u590d\u6742\u7684\u9a8c\u8bc1\u548c\u5904\u7406\u3002\u8fd9\u4f7f\u5f97\u9a8c\u8bc1\u8fc7\u7a0b\u66f4\u52a0\u7075\u6d3b\u548c\u53ef\u914d\u7f6e\u3002<\/li>\n<\/ul>\n<p><strong>*\u6587\/\u91d1\u6a59\u4e94<\/strong><\/p>\n<p>\u672c\u6587\u5c5e\u5f97\u7269\u6280\u672f\u539f\u521b\uff0c\u66f4\u591a\u7cbe\u5f69\u6587\u7ae0\u8bf7\u770b\uff1a<a target=\"_blank\" href=\"https:\/\/link.segmentfault.com\/?enc=TbJeeXPesFQlb%2FAaaILc0w%3D%3D.eNEh9Xsbfw8IPvEMDlVAEhVxKozrx7rLHo%2BF8yfmjb4%3D\" rel=\"noopener noreferrer\">\u5f97\u7269\u6280\u672f\u5b98\u7f51<\/a><\/p>\n<p>\u672a\u7ecf\u5f97\u7269\u6280\u672f\u8bb8\u53ef\u4e25\u7981\u8f6c\u8f7d\uff0c\u5426\u5219\u4f9d\u6cd5\u8ffd\u7a76\u6cd5\u5f8b\u8d23\u4efb\uff01<\/p>\n<p><a href=\"https:\/\/segmentfault.com\/a\/1190000044644566\">https:\/\/segmentfault.com\/a\/1190000044644566<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u80cc\u666f \u8d44\u91d1\u5e73\u53f0\u6982\u8ff0 \u4e3a\u4e86\u76d1\u63a7\u96c6\u56e2\u5404\u4e1a\u52a1\u7ebf\u7684\u8d44\u91d1\u6765\u6e90\u548c\u53bb\u5411\uff0c\u8d44\u91d1\u90e8\u9700\u6bcf\u5929\u5206\u6790\u6240\u6709\u8d26\u6237\u51fa\u91d1\u548c\u5165\u91d1\u60c5\u51b5\u3002\u4e3a\u6b64\uff0c\u6211 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10008379","post","type-post","status-publish","format-standard","hentry","category-share"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10008379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10008379"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10008379\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10008379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10008379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10008379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}