{"id":207,"date":"2026-04-17T10:42:19","date_gmt":"2026-04-17T02:42:19","guid":{"rendered":"https:\/\/blog.higgus17.cloud\/?p=207"},"modified":"2026-04-27T09:56:39","modified_gmt":"2026-04-27T01:56:39","slug":"%e6%95%b0%e6%8d%ae%e6%9c%8d%e5%8a%a1%e5%b1%82-api-%e5%85%b7%e4%bd%93%e6%ba%90%e7%a0%81%e5%ae%9e%e7%8e%b0","status":"publish","type":"post","link":"https:\/\/blog.higgus17.cloud\/?p=207","title":{"rendered":"\u6570\u636e\u670d\u52a1\u5c42 API \u5177\u4f53\u6e90\u7801\u5b9e\u73b0"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5bf9\u4e8e\u6570\u636e\u4e2d\u53f0\u63cf\u8ff0\uff0c\u6211\u9700\u8981\u5c06\u60c5\u51b5\u8bb2\u6e05\u695a\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ece\u4e00\u4e2a\u5177\u4f53\u7684 Java \u7684 Data Object \u5bf9\u8c61\u7684\u5b9e\u73b0\u5c42\u9762\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u542f\u52a8\u6d41\u7a0b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">qData \u4f7f\u7528\u7684\u662f Spring Boot \u7684\u6846\u67b6\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u5b9e\u73b0\u4e0a\uff0c\u6570\u636e\u670d\u52a1\u5c42\u7684\u62bd\u8c61\u4f7f\u7528 ApplicationRunner \u63a5\u53e3\u5b9e\u73b0\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c DS API \u7684\u6301\u7eed\u670d\u52a1\u63d0\u4f9b\u529f\u80fd\u7684\u521d\u59cb\u542f\u52a8\u72b6\u6001\u662f\u4f5c\u4e3a\u7ec4\u4ef6\u542f\u52a8\u7684\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5177\u4f53\u60c5\u51b5\u4e2d\uff0c\u6211\u4eec\u7684 qdata-module-ds \u5fae\u670d\u52a1\u542f\u52a8\u65f6\uff0c\u4f4d\u4e8e package tech.qiantong.qdata.module.ds.config.api \u5904\u7684 StartedUpRunner \u7c7b\u5b9e\u73b0\u4e86 ApplicationRunner \u63a5\u53e3\u7684\u7c7b StartedUpRunner \uff0c\u4e5f\u56e0\u6b64\u5728\u4e3b\u542f\u52a8\u7c7b\uff08\u5e94\u7528\u7a0b\u5e8f\uff09\u987a\u5229\u542f\u52a8\u540e\uff0c\u903b\u8f91\u4e0a\u5b83\u7684 public void run(ApplicationArguments args) \u51fd\u6570\u4f1a\u7acb\u5373\u6267\u884c\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728 run() \u51fd\u6570\u4e2d\uff0c\u53ef\u4ee5\u770b\u5230\u6838\u5fc3\u903b\u8f91\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9996\u5148\uff0c\u68c0\u67e5 ConfigurableApplicationContext \u7684\u914d\u7f6e<\/li>\n\n\n\n<li>\u63a5\u7740\uff0c\u4f7f\u7528 Service \u5bf9\u8c61\u5b9e\u4f8b\u7684\u67e5\u8be2\u65b9\u6cd5 lambdaQuery\uff0c\u5176\u5b9e\u73b0\u4e2d\u8c03\u7528 BaseMapper \u548c BaseEntity \u8c03\u7528 DsApiDO \u5bf9\u8c61\u5b9e\u73b0\u5bf9\u6570\u636e\u5e93\u7684\u8bfb\u53d6\uff0c.eq() \u7b5b\u9009\u903b\u8f91\uff0c\u518d\u901a\u8fc7 .List(T) \u4ee5\u96c6\u5408\u7684\u5f62\u5f0f\u8fd4\u56de\uff0c\u6210\u4e3a\u6211\u4eec\u53ef\u4f7f\u7528\u7684 Java \u5bf9\u8c61\u3002<\/li>\n\n\n\n<li>\u63a5\u7740\uff0c\u5982\u679c\u5217\u8868\u4e2d\u5b58\u5728\u4efb\u610f\u4e00\u6761 api \u5bf9\u8c61\u6570\u636e\uff0c\u8c03\u7528 mapperHandlerMapping \u7684 registerMapping(api) \u65b9\u6cd5\u8fdb\u884c\u8def\u7531\u6ce8\u518c\u3002\u518d\u7ecf\u8fc7\u4e00\u8f6e\u903b\u8f91\u68c0\u9a8c\uff0c\u6700\u7ec8\u4f1a\u8c03\u7528 Spring Boot \u4e2d\u7684 requestMappingHandlerMapping \u7c7b\u7684 registerMapping(requestMapping, handler, method) \u65b9\u6cd5\u8fdb\u884c\u6ce8\u518c\u3002<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u7ef4\u62a4\u7684\u6570\u636e\u670d\u52a1\u5c42 API<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">API \u670d\u52a1 DO \u5bf9\u8c61 DS_API<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8bbe\u8ba1\u4e0a\uff0cqData \u7cfb\u7edf\u5c06 DO \u5bf9\u8c61\u5b58\u50a8<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e0e\u6570\u636e\u6e90\u7684\u8fde\u63a5\u8bbe\u8ba1\u62bd\u8c61 ExecuteConfig<\/h3>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary>\u5177\u4f53\u5b9e\u73b0<\/summary>\n<pre class=\"wp-block-code\"><code>@Data\npublic class ExecuteConfig implements Serializable {\n\n    private static final long serialVersionUID=1L;\n\n    @NotBlank(message = \"\u6570\u636e\u6e90\u4e0d\u80fd\u4e3a\u7a7a\")\n    private String sourceId;\n\n    @NotNull(message = \"\u914d\u7f6e\u65b9\u5f0f\u4e0d\u80fd\u4e3a\u7a7a\")\n    private String apiServiceType;\n\n    private String tableId;\n\n    private String tableName;\n\n    private String dbName;\n\n    @Valid\n    private List&lt;FieldParam&gt; fieldParams;\n\n    \/**\n     * \u89e3\u6790SQL\n     *\/\n    private String sqlText;\n}\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/details>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u6570\u636e\u5982\u4f55\u4ece\u6570\u636e\u6e90\u8bfb\u51fa<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u7528\u4e86\u4e00\u4e2a\u81ea\u5b9a\u4e49\u7684 Wrapper \u7c7b\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6cdb\u578b\u64e6\u9664\u3001\u53cd\u5c04\u673a\u5236\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary>\u5b9e\u73b0\u4ee3\u7801<\/summary>\n<pre class=\"wp-block-code\"><code>public interface DsApiMapper extends BaseMapperX&lt;DsApiDO> {\n\n    default PageResult&lt;DsApiDO> selectPage(DsApiPageReqVO reqVO) {\n        \/\/ \u5b9a\u4e49\u6392\u5e8f\u7684\u5b57\u6bb5\uff08\u9632\u6b62 SQL \u6ce8\u5165\uff0c\u4e0e\u6570\u636e\u5e93\u5b57\u6bb5\u540d\u79f0\u4e00\u81f4\uff09\n        MPJLambdaWrapper&lt;DsApiDO> lambdaWrapper = new MPJLambdaWrapper();\n        lambdaWrapper.selectAll(DsApiDO.class)\n                .select(\"t2.NAME AS catName\")\n                .leftJoin(\"ATT_API_CAT t2 on t.CAT_CODE = t2.CODE AND t2.DEL_FLAG = '0'\")\n                .between(reqVO.getParamByKey(\"beginCreateTime\") != null &amp;&amp; reqVO.getParamByKey(\"endCreateTime\") != null,\n                        DsApiDO::getCreateTime,\n                        reqVO.getParamByKey(\"beginCreateTime\"),\n                        reqVO.getParamByKey(\"endCreateTime\"))\n                .like(StringUtils.isNotBlank(reqVO.getName()),DsApiDO::getName, reqVO.getName())\n                .in(reqVO.getApiIdList() != null &amp;&amp; !reqVO.getApiIdList().isEmpty(),DsApiDO::getId,reqVO.getApiIdList())\n                .in(reqVO.getCatIds() != null &amp;&amp; !reqVO.getCatIds().isEmpty(),DsApiDO::getCatId,reqVO.getCatIds())\n                .likeRight(StringUtils.isNotBlank(reqVO.getCatCode()), DsApiDO::getCatCode, reqVO.getCatCode())\n                .eq(StringUtils.isNotBlank(reqVO.getStatus()),DsApiDO::getStatus, reqVO.getStatus())\n                .orderByStr(StringUtils.isNotBlank(reqVO.getOrderByColumn()), StringUtils.equals(\"asc\", reqVO.getIsAsc()), StringUtils.isNotBlank(reqVO.getOrderByColumn()) ? Arrays.asList(reqVO.getOrderByColumn().split(\",\")) : null);\n        return selectJoinPage(reqVO, DsApiDO.class, lambdaWrapper);\n    }\n}<\/code><\/pre>\n<\/details>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u65b9\u6cd5\u5f15\u7528\u548c\u666e\u901a\u65b9\u6cd5\u8c03\u7528<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u53ef\u4ee5\u6ce8\u610f\u5230\u975e\u5e38\u6709\u8da3\u7684\u4e00\u4e2a\u5c0f\u7ec6\u8282\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>...(reqVO.getName(), DsAPIDO::getName)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd9\u4e2a\u5b9e\u9645\u4e0a\u662f\u65b9\u6cd5\u5f15\u7528\u548c\u666e\u901a\u65b9\u6cd5\u8c03\u7528\u7684\u5dee\u5f02\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u65b9\u6cd5\u5f15\u7528\u5b9e\u9645\u4e0a\u662f\u4e00\u79cd\u9884\u7559\uff0c\u610f\u5473\u7740\u5728\u672a\u6765\u5b9e\u9645\u53d1\u751f\u8c03\u7528\u65f6\uff0c\u4f1a\u4f7f\u7528\u8be5\u65b9\u6cd5\uff0c\u800c\u76ee\u524d\u77e5\u8bc6\u4f20\u9012\u4e86\u65b9\u6cd5\u7684\u2308\u5f15\u7528\u230b\u3002\u76ee\u524d\u5728\u8fd9\u91cc\uff0cDsAPIDO \u8fd8\u662f\u672a\u5b9e\u4f8b\u5316\u7684\u3002\u800c reqVO \u5728\u5b9e\u4f8b\u5316\u4e4b\u540e\uff0c\u8fd9\u91cc\u4f7f\u7528 getName() \u65b9\u6cd5\u4f1a\u8fdb\u884c\u5b9e\u9645\u7684\u89e3\u6790\u548c\u6570\u636e\u8c03\u7528\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5bf9\u4e8e\u6570\u636e\u4e2d\u53f0\u63cf\u8ff0\uff0c\u6211\u9700\u8981\u5c06\u60c5\u51b5\u8bb2\u6e05\u695a\u3002 \u4ece\u4e00\u4e2a\u5177\u4f53\u7684 Java \u7684 Data Object \u5bf9\u8c61\u7684\u5b9e\u73b0\u5c42\u9762\u3002  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-207","post","type-post","status-publish","format-standard","hentry","category-9"],"_links":{"self":[{"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=\/wp\/v2\/posts\/207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=207"}],"version-history":[{"count":15,"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=\/wp\/v2\/posts\/207\/revisions"}],"predecessor-version":[{"id":245,"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=\/wp\/v2\/posts\/207\/revisions\/245"}],"wp:attachment":[{"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.higgus17.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}