{"id":692,"date":"2023-02-26T14:56:29","date_gmt":"2023-02-26T06:56:29","guid":{"rendered":"https:\/\/www.appblog.cn\/?p=692"},"modified":"2023-04-29T17:55:49","modified_gmt":"2023-04-29T09:55:49","slug":"mybatis-batch-query-list-results-sorting-problem-based-on-list","status":"publish","type":"post","link":"https:\/\/www.appblog.cn\/index.php\/2023\/02\/26\/mybatis-batch-query-list-results-sorting-problem-based-on-list\/","title":{"rendered":"MyBatis\u6839\u636eList\u6279\u91cf\u67e5\u8be2List\u7ed3\u679c\u6392\u5e8f\u95ee\u9898"},"content":{"rendered":"

MyBatis\u914d\u7f6e<\/h2>\n
public interface RouteServiceMapper {\n    List<RouteService> selectRouteServiceList(@Param("routeServiceList") List<Map<String, String>> routeServiceList);\n}<\/code><\/pre>\n
\u67e5\u8be2\u51fa\u6765\u7684RouteServiceList\u987a\u5e8f\u4e0e\u4f20\u5165\u7684List\u4fe1\u606f\u987a\u5e8f\u4e0d\u4e00\u81f4\uff1a<\/p>\n
<\/p>\n
<select id="selectRouteServiceList" parameterType="java.util.List" resultMap="BaseResultMap">\n    select\n    <include refid="Base_Column_List"\/>\n    from route_service rs\n    where\n    rs.route_code in\n    <foreach item="routeService" index="index" collection="routeServiceList"\n             open="(" separator="," close=")">\n        #{routeService.route_code}\n    <\/foreach>\n    and rs.service_code in\n    <foreach item="routeService" index="index" collection="routeServiceList"\n            open="(" separator="," close=")">\n        #{routeService.service_code}\n    <\/foreach>\n    and rs.status = 'ENABLE'\n<\/select><\/code><\/pre>\n
\u89e3\u51b3\u65b9\u5f0f\uff1a<\/p>\n
<select id="selectRouteServiceList" parameterType="java.util.List" resultMap="BaseResultMap">\n    select * from\n    <foreach item="routeService" index="index" collection="routeServiceList"\n             open="(" separator="union all" close=")">\n        select <include refid="Base_Column_List"\/>\n        from route_service rs where\n        rs.route_code=#{routeService.route_code,jdbcType=VARCHAR} and\n        rs.service_code=#{routeService.service_code,jdbcType=VARCHAR} and\n        rs.status = 'ENABLE'\n    <\/foreach> as rs\n<\/select><\/code><\/pre>\n
SQL\u6d4b\u8bd5<\/h2>\n
    \n
  • \u5f85\u67e5\u8be2\u6570\u7ec4\u987a\u5e8f<\/li>\n<\/ul>\n
    [{"service_code":"ALIPAY_QR","route_code":"alipay"},\n {"service_code":"WECHATPAY_QR","route_code":"wechatpay"}]<\/code><\/pre>\n
      \n
    • \u987a\u5e8f\u4e0d\u4e00\u81f4\u67e5\u8be2\u8f6c\u4e49<\/li>\n<\/ul>\n
      select id, route_code, service_code, service_app_name, pay_outer, status, creation_time, modification_time \nfrom tp_channel_service cs \nwhere cs.route_code in ( 'alipay','wechatpay' ) \n  and cs.service_code in ( 'ALIPAY_QR','WECHATPAY_QR' ) \n  and cs.status = 'ENABLE'<\/code><\/pre>\n
        \n
      • \u987a\u5e8f\u4e00\u81f4\u67e5\u8be2\u8f6c\u4e49<\/li>\n<\/ul>\n
        select id, route_code, service_code, service_app_name, pay_outer, status, creation_time, modification_time from\n    (\n    select id, route_code, service_code, service_app_name, pay_outer, status, creation_time, modification_time from tp_channel_service cs where\n        cs.route_code='alipay' and cs.service_code='ALIPAY_QR' and cs.status = 'ENABLE'\n    UNION ALL\n    select id, route_code, service_code, service_app_name, pay_outer, status, creation_time, modification_time from tp_channel_service cs where\n        cs.route_code='wechatpay' and cs.service_code='WECHATPAY_QR' and cs.status = 'ENABLE'\n    )\nas cs<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
        MyBatis\u914d\u7f6e public interface RouteServiceMapper { List&lt […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[111],"class_list":["post-692","post","type-post","status-publish","format-standard","hentry","category-mybatis","tag-mybatis"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/comments?post=692"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/692\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}