{"id":524,"date":"2025-03-24T08:53:17","date_gmt":"2025-03-23T23:53:17","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=524"},"modified":"2025-03-24T08:53:17","modified_gmt":"2025-03-23T23:53:17","slug":"%e3%80%90%e5%ae%9f%e8%b7%b5%e3%82%ac%e3%82%a4%e3%83%89%e3%80%91mybatis-if%e8%a6%81%e7%b4%a0%e3%81%ae%e4%bd%bf%e3%81%84%e6%96%b97%e9%81%b8%ef%bc%81%e7%8f%be%e5%a0%b4%e3%81%a7%e4%bd%bf%e3%81%88%e3%82%8b","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=524","title":{"rendered":"\u3010\u5b9f\u8df5\u30ac\u30a4\u30c9\u3011MyBatis if\u8981\u7d20\u306e\u4f7f\u3044\u65b97\u9078\uff01\u73fe\u5834\u3067\u4f7f\u3048\u308b\u52d5\u7684SQL\u5b9f\u88c5\u30c6\u30af\u30cb\u30c3\u30af"},"content":{"rendered":"\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u3053\u306e\u30ac\u30a4\u30c9\u3067\u5b66\u3079\u308b\u3053\u3068<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>MyBatis if\u3092\u4f7f\u7528\u3057\u305f\u52d5\u7684SQL\u306e\u57fa\u672c\u304b\u3089\u5fdc\u7528\u307e\u3067<\/li>\n\n\n\n<li>\u5b9f\u52d9\u3067\u5373\u4f7f\u3048\u308b7\u3064\u306e\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u8003\u616e\u3057\u305f\u5b9f\u88c5\u65b9\u6cd5<\/li>\n\n\n\n<li>\u30c8\u30e9\u30d6\u30eb\u56de\u907f\u306e\u305f\u3081\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"toc\"><br \/>\n<b>Warning<\/b>:  Undefined array key \"is_admin\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>116<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_category_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>121<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_top\" in <b>\/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>128<\/b><br \/>\n    <div id=\"toc_container\" class=\"sgb-toc--bullets js-smooth-scroll\" data-dialog-title=\"\u76ee\u6b21\">\n      <p class=\"toc_title\">\u76ee\u6b21 <\/p>\n      <ul class=\"toc_list\">  <li class=\"first\">    <span><\/span>    <ul class=\"menu_level_1\">      <li class=\"first last\">        <a href=\"#i-0\">MyBatis if\u3068\u306f\uff1f\u52d5\u7684SQL\u306b\u304a\u3051\u308b\u91cd\u8981\u6027<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-3\">MyBatis if\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3068\u6587\u6cd5<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-4\">if\u8981\u7d20\u306e\u57fa\u672c\u69cb\u6587\u3068\u6761\u4ef6\u5f0f\u306e\u66f8\u304d\u65b9<\/a>      <\/li>      <li>        <a href=\"#i-7\">test\u5c5e\u6027\u3067\u4f7f\u7528\u53ef\u80fd\u306a\u6f14\u7b97\u5b50\u3068\u5f0f<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-10\">\u3088\u304f\u3042\u308b\u6587\u6cd5\u30df\u30b9\u3068\u5bfe\u51e6\u6cd5<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-15\">\u5b9f\u8df5\u7684\u306aMyBatis if\u6d3b\u7528\u88537\u9078<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-16\">1. \u691c\u7d22\u6761\u4ef6\u306e\u52d5\u7684\u751f\u6210\u30d1\u30bf\u30fc\u30f3<\/a>      <\/li>      <li>        <a href=\"#i-17\">2. \u66f4\u65b0\u9805\u76ee\u306e\u9078\u629e\u7684\u8a2d\u5b9a\u30d1\u30bf\u30fc\u30f3<\/a>      <\/li>      <li>        <a href=\"#i-18\">3. \u8907\u6570\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b\u30d1\u30bf\u30fc\u30f3<\/a>      <\/li>      <li>        <a href=\"#i-19\">4. NULL\u5024\u306e\u9069\u5207\u306a\u51e6\u7406\u30d1\u30bf\u30fc\u30f3<\/a>      <\/li>      <li>        <a href=\"#i-20\">5. \u65e5\u4ed8\u7bc4\u56f2\u6307\u5b9a\u30d1\u30bf\u30fc\u30f3<\/a>      <\/li>      <li>        <a href=\"#i-21\">6. IN\u53e5\u306e\u52d5\u7684\u751f\u6210\u30d1\u30bf\u30fc\u30f3<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-22\">7. \u30da\u30fc\u30b8\u30f3\u30b0\u51e6\u7406\u3068\u306e\u7d44\u307f\u5408\u308f\u305b\u30d1\u30bf\u30fc\u30f3<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-23\">\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-24\">\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u3068\u89e3\u6c7a\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-29\">\u30c7\u30d0\u30c3\u30b0\u306e\u30b3\u30c4\u3068\u30ed\u30b0\u78ba\u8a8d\u65b9\u6cd5<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-33\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u4f4e\u4e0b\u6642\u306e\u6539\u5584\u30dd\u30a4\u30f3\u30c8<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-39\">\u307e\u3068\u3081\uff1aMyBatis if\u306e\u5b9f\u8df5\u7684\u306a\u6d3b\u7528\u306b\u5411\u3051\u3066<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-40\">\u672c\u8a18\u4e8b\u3067\u89e3\u8aac\u3057\u305f\u91cd\u8981\u30dd\u30a4\u30f3\u30c8<\/a>      <\/li>      <li>        <a href=\"#i-45\">\u5b9f\u8df5\u306e\u305f\u3081\u306e\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/a>      <\/li>      <li>        <a href=\"#i-48\">\u6b21\u306e\u30b9\u30c6\u30c3\u30d7<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-49\">\u6700\u5f8c\u306b<\/a>      <\/li>    <\/ul>  <\/li><\/ul>\n      <a href=\"#\" class=\"sgb-toc-button js-toc-button\" rel=\"nofollow\" data-open-dialog=\"true\"><i class=\"fa fa-list\"><\/i><span class=\"sgb-toc-button__text\">\u76ee\u6b21\u3078<\/span><\/a>\n    <\/div><\/div><h2 class=\"wp-block-heading\" id=\"i-0\">MyBatis if\u3068\u306f\uff1f\u52d5\u7684SQL\u306b\u304a\u3051\u308b\u91cd\u8981\u6027<\/h2>\n\n\n\n<div class=\"wp-block-sgb-message\"><div class=\"memo sng-shadow-0\" style=\"border-radius:0px;background-color:#b4e0fa;color:#009EF3\"><div class=\"memo_ttl dfont\"><span class=\"sng-box-msg__icon\" style=\"background:#009EF3\"><i class=\"far fa-lightbulb\"><\/i><\/span><div class=\"sng-box-msg__title\">\ud83d\udca1 <strong>\u91cd\u8981\u30dd\u30a4\u30f3\u30c8<\/strong><\/div><\/div><div class=\"sng-box-msg__contents\">\n<ul class=\"wp-block-list\">\n<li>\u52d5\u7684SQL\u306f\u6761\u4ef6\u306b\u5fdc\u3058\u3066\u30af\u30a8\u30ea\u3092\u7d44\u307f\u7acb\u3066\u308b\u5f37\u529b\u306a\u6a5f\u80fd<\/li>\n\n\n\n<li>if\u8981\u7d20\u306f\u6700\u3082\u57fa\u672c\u7684\u304b\u3064\u91cd\u8981\u306a\u52d5\u7684SQL\u8981\u7d20<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u4f7f\u7528\u3067\u4fdd\u5b88\u6027\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u4e21\u7acb<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">\u52d5\u7684SQL\u306e\u57fa\u790e\u77e5\u8b58\u3068if\u8981\u7d20\u306e\u5f79\u5272<\/h3>\n\n\n\n<p>\u52d5\u7684SQL\u306f\u3001\u6761\u4ef6\u306b\u5fdc\u3058\u3066SQL\u6587\u3092\u52d5\u7684\u306b\u7d44\u307f\u7acb\u3066\u308bMyBatis\u306e\u6838\u3068\u306a\u308b\u6a5f\u80fd\u3067\u3059\u3002\u4e2d\u3067\u3082if\u8981\u7d20\u306f\u3001\u4ee5\u4e0b\u306e\u7279\u5fb4\u3092\u6301\u3064\u6700\u3082\u57fa\u672c\u7684\u306a\u5236\u5fa1\u8981\u7d20\u3067\u3059\uff1a<\/p>\n\n\n\n<p>\u4e3b\u8981\u306a\u52d5\u7684SQL\u8981\u7d20\uff1a<\/p>\n\n\n<div id=\"id-af73ff4f-2783-4554-a552-960a00a4fc82\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u8981\u7d20<\/th><th>\u4e3b\u306a\u7528\u9014<\/th><th>\u7279\u5fb4<\/th><\/tr><\/thead><tbody><tr><td>if<\/td><td>\u5358\u4e00\u6761\u4ef6\u306e\u5206\u5c90<\/td><td>\u6700\u3082\u57fa\u672c\u7684\u3067\u6c4e\u7528\u7684<\/td><\/tr><tr><td>choose\/when\/otherwise<\/td><td>\u8907\u6570\u6761\u4ef6\u306e\u5206\u5c90<\/td><td>if-else\u306e\u3088\u3046\u306a\u5236\u5fa1\u304c\u53ef\u80fd<\/td><\/tr><tr><td>where<\/td><td>WHERE\u53e5\u306e\u751f\u6210<\/td><td>AND\u3084OR\u306e\u81ea\u52d5\u5236\u5fa1<\/td><\/tr><tr><td>set<\/td><td>UPDATE\u6587\u306e\u5236\u5fa1<\/td><td>\u30ab\u30f3\u30de\u306e\u81ea\u52d5\u5236\u5fa1<\/td><\/tr><tr><td>foreach<\/td><td>\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u51e6\u7406<\/td><td>\u914d\u5217\u3084\u30ea\u30b9\u30c8\u306e\u5c55\u958b<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<p class=\"is-style-sango-paragraph-memo-alt\">\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u57fa\u672c\u7684\u306aif\u8981\u7d20\u306e\u4f7f\u7528\u4f8b --&gt;\n&lt;select id=\"findUsers\" resultType=\"User\"&gt;\n    SELECT * FROM users\n    &lt;where&gt;\n        &lt;!-- \u6ce8\u610f: null\u5224\u5b9a\u306f\u5fc5\u305a\u5b9f\u65bd\u3059\u308b --&gt;\n        &lt;if test=\"name != null and name != ''\"&gt;\n            AND name LIKE #{name}\n        &lt;\/if&gt;\n        &lt;!-- \u6ce8\u610f: \u6570\u5024\u578b\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u306enull\u5224\u5b9a --&gt;\n        &lt;if test=\"age != null\"&gt;\n            AND age &gt;= #{age}\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n&lt;\/select&gt;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">if\u8981\u7d20\u304c\u306a\u305c\u5fc5\u8981\u306a\u306e\u304b\uff1f\u5177\u4f53\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u691c\u7d22\u6761\u4ef6\u306e\u52d5\u7684\u751f\u6210<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: \u691c\u7d22\u6761\u4ef6\u3092\u52d5\u7684\u306b\u7d44\u307f\u7acb\u3066\u308b\u5b9f\u88c5\u4f8b\npublic class UserSearchService {\n    private final UserMapper userMapper;\n\n    public List&lt;User&gt; searchUsers(String name, Integer age) {\n        \/\/ \u6ce8\u610f: \u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u4e8b\u524d\u691c\u8a3c\n        Map&lt;String, Object&gt; params = new HashMap&lt;&gt;();\n        if (StringUtils.hasText(name)) {\n            params.put(\"name\", \"%\" + name + \"%\");\n        }\n        if (age != null &amp;&amp; age &gt; 0) {\n            params.put(\"age\", age);\n        }\n        return userMapper.findUsers(params);\n    }\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u66f4\u65b0\u6642\u306e\u5236\u5fa1<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u66f4\u65b0\u9805\u76ee\u3092\u52d5\u7684\u306b\u5236\u5fa1\u3059\u308b\u5b9f\u88c5\u4f8b --&gt;\n&lt;update id=\"updateUser\"&gt;\n    UPDATE users\n    &lt;set&gt;\n        &lt;!-- \u6ce8\u610f: \u66f4\u65b0\u9805\u76ee\u306e\u9078\u629e\u7684\u306a\u8a2d\u5b9a --&gt;\n        &lt;if test=\"name != null\"&gt;name = #{name},&lt;\/if&gt;\n        &lt;if test=\"email != null\"&gt;email = #{email},&lt;\/if&gt;\n        updated_at = CURRENT_TIMESTAMP\n    &lt;\/set&gt;\n    WHERE id = #{id}\n&lt;\/update&gt;<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>\u30d0\u30c3\u30c1\u51e6\u7406\u3067\u306e\u6761\u4ef6\u5206\u5c90<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u30d0\u30c3\u30c1\u51e6\u7406\u3067\u306e\u6761\u4ef6\u5206\u5c90\u306e\u4f8b --&gt;\n&lt;update id=\"batchUpdateUsers\"&gt;\n    UPDATE users\n    &lt;set&gt;\n        status = \n        &lt;!-- \u6ce8\u610f: \u30b9\u30c6\u30fc\u30bf\u30b9\u66f4\u65b0\u306e\u6761\u4ef6\u5206\u5c90 --&gt;\n        &lt;if test=\"lastLoginDate == null\"&gt;'INACTIVE'&lt;\/if&gt;\n        &lt;if test=\"lastLoginDate != null\"&gt;'ACTIVE'&lt;\/if&gt;,\n        updated_at = CURRENT_TIMESTAMP\n    &lt;\/set&gt;\n    WHERE id = #{id}\n&lt;\/update&gt;<\/pre>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u3001if\u8981\u7d20\u306f\u5358\u306a\u308b\u6761\u4ef6\u5206\u5c90\u4ee5\u4e0a\u306e\u5f79\u5272\u3092\u679c\u305f\u3057\u3001SQL\u306e\u52d5\u7684\u751f\u6210\u306b\u304a\u3044\u3066\u4e2d\u5fc3\u7684\u306a\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u7d9a\u304f\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3088\u308a\u5b9f\u8df5\u7684\u306a\u4f7f\u7528\u65b9\u6cd5\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-3\">MyBatis if\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3068\u6587\u6cd5<\/h1>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u5b66\u3079\u308b\u3053\u3068<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>if\u8981\u7d20\u306e\u57fa\u672c\u7684\u306a\u6587\u6cd5\u3068\u69cb\u6587\u898f\u5247<\/li>\n\n\n\n<li>test\u5c5e\u6027\u3067\u4f7f\u7528\u53ef\u80fd\u306a\u6f14\u7b97\u5b50\u3068\u5f0f\u306e\u7a2e\u985e<\/li>\n\n\n\n<li>\u5b9f\u88c5\u6642\u306e\u6ce8\u610f\u70b9\u3068\u30a8\u30e9\u30fc\u9632\u6b62\u65b9\u6cd5<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-sgb-message\"><div class=\"memo sng-shadow-0\" style=\"border-radius:0px;background-color:#b4e0fa;color:#009EF3\"><div class=\"memo_ttl dfont\"><span class=\"sng-box-msg__icon\" style=\"background:#009EF3\"><i class=\"far fa-lightbulb\"><\/i><\/span><div class=\"sng-box-msg__title\">\ud83d\udca1 <strong>\u91cd\u8981\u30dd\u30a4\u30f3\u30c8<\/strong><\/div><\/div><div class=\"sng-box-msg__contents\">\n<ul class=\"wp-block-list\">\n<li>test\u5c5e\u6027\u3067\u306f\u5fc5\u305a\u4e8c\u91cd\u30a4\u30b3\u30fc\u30eb\uff08==\uff09\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>null\u5224\u5b9a\u306f\u78ba\u5b9f\u306b\u884c\u3046<\/li>\n\n\n\n<li>\u6587\u5b57\u5217\u6bd4\u8f03\u3067\u306f\u7a7a\u6587\u5b57\u30c1\u30a7\u30c3\u30af\u3082\u5fd8\u308c\u305a\u306b<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-4\">if\u8981\u7d20\u306e\u57fa\u672c\u69cb\u6587\u3068\u6761\u4ef6\u5f0f\u306e\u66f8\u304d\u65b9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-5\">\u57fa\u672c\u69cb\u6587<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: if\u8981\u7d20\u306e\u57fa\u672c\u69cb\u6587 --&gt;\n&lt;if test=\"\u6761\u4ef6\u5f0f\"&gt;\n    SQL\u306e\u4e00\u90e8\n&lt;\/if&gt;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-6\">\u6761\u4ef6\u5f0f\u306e\u57fa\u672c\u30d1\u30bf\u30fc\u30f3<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u3088\u304f\u4f7f\u7528\u3055\u308c\u308b\u6761\u4ef6\u5f0f\u30d1\u30bf\u30fc\u30f3 --&gt;\n&lt;select id=\"findUsers\" resultType=\"User\"&gt;\n    SELECT * FROM users\n    &lt;where&gt;\n        &lt;!-- \u6ce8\u610f: \u6570\u5024\u306e\u6bd4\u8f03 --&gt;\n        &lt;if test=\"age != null and age &gt;= 20\"&gt;\n            AND is_adult = true\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u6587\u5b57\u5217\u306e\u6bd4\u8f03\uff08null \u3068 \u7a7a\u6587\u5b57\u3092\u30c1\u30a7\u30c3\u30af\uff09 --&gt;\n        &lt;if test=\"name != null and name != ''\"&gt;\n            AND name LIKE CONCAT('%', #{name}, '%')\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u771f\u507d\u5024\u306e\u6bd4\u8f03 --&gt;\n        &lt;if test=\"isActive != null and isActive\"&gt;\n            AND status = 'ACTIVE'\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n&lt;\/select&gt;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-7\">test\u5c5e\u6027\u3067\u4f7f\u7528\u53ef\u80fd\u306a\u6f14\u7b97\u5b50\u3068\u5f0f<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-8\">\u6bd4\u8f03\u6f14\u7b97\u5b50\u4e00\u89a7<\/h3>\n\n\n<div id=\"id-ee7f2377-38e3-478e-adcb-7a0d2dec7684\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u6f14\u7b97\u5b50<\/th><th>\u8aac\u660e<\/th><th>\u4f7f\u7528\u4f8b<\/th><th>\u6ce8\u610f\u70b9<\/th><\/tr><\/thead><tbody><tr><td>==<\/td><td>\u7b49\u3057\u3044<\/td><td><code>test=\"status == 'ACTIVE'\"<\/code><\/td><td>\u6587\u5b57\u5217\u6bd4\u8f03\u6642\u306f\u5f15\u7528\u7b26\u5fc5\u9808<\/td><\/tr><tr><td>!=<\/td><td>\u7b49\u3057\u304f\u306a\u3044<\/td><td><code>test=\"type != 'ADMIN'\"<\/code><\/td><td>null\u5024\u306e\u8003\u616e\u304c\u5fc5\u8981<\/td><\/tr><tr><td>&gt;<\/td><td>\u3088\u308a\u5927\u304d\u3044<\/td><td><code>test=\"price &gt; 1000\"<\/code><\/td><td>\u6570\u5024\u6bd4\u8f03\u306e\u307f\u4f7f\u7528\u53ef<\/td><\/tr><tr><td>&gt;=<\/td><td>\u4ee5\u4e0a<\/td><td><code>test=\"age &gt;= 20\"<\/code><\/td><td>\u6570\u5024\u6bd4\u8f03\u306e\u307f\u4f7f\u7528\u53ef<\/td><\/tr><tr><td>&lt;<\/td><td>\u3088\u308a\u5c0f\u3055\u3044<\/td><td><code>test=\"stock &lt; 10\"<\/code><\/td><td>\u6570\u5024\u6bd4\u8f03\u306e\u307f\u4f7f\u7528\u53ef<\/td><\/tr><tr><td>&lt;=<\/td><td>\u4ee5\u4e0b<\/td><td><code>test=\"discount &lt;= 30\"<\/code><\/td><td>\u6570\u5024\u6bd4\u8f03\u306e\u307f\u4f7f\u7528\u53ef<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-9\">\u8ad6\u7406\u6f14\u7b97\u5b50\u306e\u4f7f\u7528\u4f8b<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u8ad6\u7406\u6f14\u7b97\u5b50\u3092\u4f7f\u7528\u3057\u305f\u6761\u4ef6\u5f0f --&gt;\n&lt;select id=\"searchProducts\" resultType=\"Product\"&gt;\n    SELECT * FROM products\n    &lt;where&gt;\n        &lt;!-- \u6ce8\u610f: AND\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b --&gt;\n        &lt;if test=\"category != null and price != null\"&gt;\n            AND category = #{category}\n            AND price &lt;= #{price}\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: OR\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b --&gt;\n        &lt;if test=\"status == 'NEW' or status == 'SALE'\"&gt;\n            AND status IN ('NEW', 'SALE')\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u8907\u96d1\u306a\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b --&gt;\n        &lt;if test=\"(type == 'PREMIUM' and price &gt;= 10000) or (type == 'NORMAL' and price &gt;= 5000)\"&gt;\n            AND is_featured = true\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n&lt;\/select&gt;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-10\">\u3088\u304f\u3042\u308b\u6587\u6cd5\u30df\u30b9\u3068\u5bfe\u51e6\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-11\">1. \u6bd4\u8f03\u6f14\u7b97\u5b50\u306e\u30df\u30b9<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u274c \u9593\u9055\u3063\u305f\u5b9f\u88c5\u4f8b --&gt;\n&lt;if test=\"status = 'ACTIVE'\"&gt;  &lt;!-- \u4ee3\u5165\u6f14\u7b97\u5b50\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b --&gt;\n    AND status = #{status}\n&lt;\/if&gt;\n\n&lt;!-- \u2705 \u6b63\u3057\u3044\u5b9f\u88c5\u4f8b --&gt;\n&lt;if test=\"status == 'ACTIVE'\"&gt;  &lt;!-- \u6bd4\u8f03\u6f14\u7b97\u5b50\u3092\u4f7f\u7528 --&gt;\n    AND status = #{status}\n&lt;\/if&gt;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-12\">2. null\u5b89\u5168\u6027\u3078\u306e\u8003\u616e\u4e0d\u8db3<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u274c \u9593\u9055\u3063\u305f\u5b9f\u88c5\u4f8b --&gt;\n&lt;if test=\"name.length() &gt; 0\"&gt;  &lt;!-- NullPointerException\u306e\u5371\u967a --&gt;\n    AND name LIKE #{name}\n&lt;\/if&gt;\n\n&lt;!-- \u2705 \u6b63\u3057\u3044\u5b9f\u88c5\u4f8b --&gt;\n&lt;if test=\"name != null and name.length() &gt; 0\"&gt;  &lt;!-- null\u5b89\u5168\u306a\u5b9f\u88c5 --&gt;\n    AND name LIKE #{name}\n&lt;\/if&gt;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-13\">3. \u6761\u4ef6\u306e\u512a\u5148\u9806\u4f4d\u306e\u8aa4\u308a<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u274c \u9593\u9055\u3063\u305f\u5b9f\u88c5\u4f8b --&gt;\n&lt;if test=\"type == 'A' or type == 'B' and status == 'ACTIVE'\"&gt;\n    &lt;!-- AND\u6f14\u7b97\u5b50\u304c\u512a\u5148\u3055\u308c\u3001\u610f\u56f3\u3057\u306a\u3044\u52d5\u4f5c\u306b\u306a\u308b --&gt;\n&lt;\/if&gt;\n\n&lt;!-- \u2705 \u6b63\u3057\u3044\u5b9f\u88c5\u4f8b --&gt;\n&lt;if test=\"(type == 'A' or type == 'B') and status == 'ACTIVE'\"&gt;\n    &lt;!-- \u62ec\u5f27\u3067\u512a\u5148\u9806\u4f4d\u3092\u660e\u78ba\u306b\u6307\u5b9a --&gt;\n&lt;\/if&gt;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-14\">\u5b9f\u88c5\u6642\u306e\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[ ] \u6bd4\u8f03\u6f14\u7b97\u5b50\u306f <code>==<\/code> \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] null\u5224\u5b9a\u3092\u9069\u5207\u306b\u884c\u3063\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u6587\u5b57\u5217\u6bd4\u8f03\u6642\u306f\u7a7a\u6587\u5b57\u30c1\u30a7\u30c3\u30af\u3082\u884c\u3063\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u8907\u96d1\u306a\u6761\u4ef6\u306f\u62ec\u5f27\u3067\u512a\u5148\u9806\u4f4d\u3092\u660e\u78ba\u306b\u3057\u3066\u3044\u308b\u304b<\/li>\n\n\n\n<li>[ ] \u6570\u5024\u6bd4\u8f03\u306e\u578b\u306f\u9069\u5207\u304b<\/li>\n\n\n\n<li>[ ] SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56\u3068\u3057\u3066 <code>#{}<\/code>\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u304b<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u8aac\u660e\u3057\u305f\u57fa\u672c\u6587\u6cd5\u3068\u6ce8\u610f\u70b9\u3092\u62bc\u3055\u3048\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u5b89\u5168\u3067\u4fdd\u5b88\u6027\u306e\u9ad8\u3044MyBatis\u306e\u5b9f\u88c5\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-15\">\u5b9f\u8df5\u7684\u306aMyBatis if\u6d3b\u7528\u88537\u9078<\/h1>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u5b66\u3079\u308b\u3053\u3068<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>\u5b9f\u52d9\u3067\u3088\u304f\u4f7f\u7528\u3055\u308c\u308b7\u3064\u306e\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3<\/li>\n\n\n\n<li>\u5404\u30d1\u30bf\u30fc\u30f3\u306e\u5177\u4f53\u7684\u306a\u5b9f\u88c5\u65b9\u6cd5<\/li>\n\n\n\n<li>\u30d1\u30bf\u30fc\u30f3\u3054\u3068\u306e\u6ce8\u610f\u70b9\u3068\u6700\u9069\u5316\u65b9\u6cd5<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-sgb-message\"><div class=\"memo sng-shadow-0\" style=\"border-radius:0px;background-color:#b4e0fa;color:#009EF3\"><div class=\"memo_ttl dfont\"><span class=\"sng-box-msg__icon\" style=\"background:#009EF3\"><i class=\"far fa-lightbulb\"><\/i><\/span><div class=\"sng-box-msg__title\">\ud83d\udca1 <strong>\u91cd\u8981\u30dd\u30a4\u30f3\u30c8<\/strong><\/div><\/div><div class=\"sng-box-msg__contents\">\n<ul class=\"wp-block-list\">\n<li>\u5404\u30d1\u30bf\u30fc\u30f3\u306f\u5b9f\u52d9\u3067\u306e\u4f7f\u7528\u983b\u5ea6\u304c\u9ad8\u3044\u3082\u306e\u3092\u53b3\u9078<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u4fdd\u5b88\u6027\u3092\u8003\u616e\u3057\u305f\u5b9f\u88c5\u4f8b\u3092\u63d0\u4f9b<\/li>\n\n\n\n<li>\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3059\u3050\u306b\u6d3b\u7528\u53ef\u80fd\u306a\u5f62\u3067\u63d0\u4f9b<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-16\">1. \u691c\u7d22\u6761\u4ef6\u306e\u52d5\u7684\u751f\u6210\u30d1\u30bf\u30fc\u30f3<\/h2>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>\u8907\u6570\u306e\u691c\u7d22\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u691c\u7d22\u6a5f\u80fd<\/li>\n\n\n\n<li>\u4efb\u610f\u306e\u6761\u4ef6\u3092\u6307\u5b9a\u53ef\u80fd\u306a\u691c\u7d22\u753b\u9762<\/li>\n\n\n\n<li>\u30ec\u30dd\u30fc\u30c8\u51fa\u529b\u306e\u305f\u3081\u306e\u6761\u4ef6\u6307\u5b9a<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: \u691c\u7d22\u6761\u4ef6\u3092\u4fdd\u6301\u3059\u308bDTO\u30af\u30e9\u30b9\n@Data\npublic class UserSearchCondition {\n    private String name;\n    private Integer ageFrom;\n    private Integer ageTo;\n    private List&lt;String&gt; statusList;\n    private LocalDate registeredDateFrom;\n    private LocalDate registeredDateTo;\n\n    \/\/ \u6ce8\u610f: \u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u30e1\u30bd\u30c3\u30c9\u306e\u8ffd\u52a0\n    public boolean isValid() {\n        if (ageFrom != null &amp;&amp; ageTo != null &amp;&amp; ageFrom &gt; ageTo) {\n            return false;\n        }\n        if (registeredDateFrom != null &amp;&amp; registeredDateTo != null \n            &amp;&amp; registeredDateFrom.isAfter(registeredDateTo)) {\n            return false;\n        }\n        return true;\n    }\n}<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u52d5\u7684\u306a\u691c\u7d22\u6761\u4ef6\u306eMapper\u5b9f\u88c5 --&gt;\n&lt;select id=\"searchUsers\" resultType=\"User\" parameterType=\"UserSearchCondition\"&gt;\n    SELECT \n        u.id,\n        u.name,\n        u.age,\n        u.status,\n        u.registered_date\n    FROM \n        users u\n    &lt;where&gt;\n        &lt;!-- \u6ce8\u610f: LIKE\u691c\u7d22\u6642\u306e\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9 --&gt;\n        &lt;if test=\"name != null and name != ''\"&gt;\n            AND u.name LIKE CONCAT('%', #{name}, '%')\n        &lt;\/if&gt;\n        &lt;!-- \u6ce8\u610f: \u7bc4\u56f2\u691c\u7d22\u306e\u5b9f\u88c5 --&gt;\n        &lt;if test=\"ageFrom != null\"&gt;\n            AND u.age &gt;= #{ageFrom}\n        &lt;\/if&gt;\n        &lt;if test=\"ageTo != null\"&gt;\n            AND u.age &lt;= #{ageTo}\n        &lt;\/if&gt;\n        &lt;!-- \u6ce8\u610f: IN\u53e5\u306e\u52d5\u7684\u751f\u6210 --&gt;\n        &lt;if test=\"statusList != null and !statusList.isEmpty()\"&gt;\n            AND u.status IN\n            &lt;foreach item=\"status\" collection=\"statusList\"\n                     open=\"(\" separator=\",\" close=\")\"&gt;\n                #{status}\n            &lt;\/foreach&gt;\n        &lt;\/if&gt;\n        &lt;!-- \u6ce8\u610f: \u65e5\u4ed8\u7bc4\u56f2\u691c\u7d22 --&gt;\n        &lt;if test=\"registeredDateFrom != null\"&gt;\n            AND DATE(u.registered_date) &gt;= #{registeredDateFrom}\n        &lt;\/if&gt;\n        &lt;if test=\"registeredDateTo != null\"&gt;\n            AND DATE(u.registered_date) &lt;= #{registeredDateTo}\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n    ORDER BY u.id DESC\n&lt;\/select&gt;<\/pre>\n\n\n\n<div class=\"wp-block-sgb-message\"><div class=\"memo sng-shadow-0\" style=\"border-radius:0px;background-color:#fff9e6;color:#ffb36b\"><div class=\"memo_ttl dfont\"><span class=\"sng-box-msg__icon\" style=\"background:#ffb36b\"><i class=\"fas fa-pencil-alt\"><\/i><\/span><div class=\"sng-box-msg__title\">\u5b9f\u88c5\u306e\u30dd\u30a4\u30f3\u30c8<\/div><\/div><div class=\"sng-box-msg__contents\">\n<ol class=\"wp-block-list\">\n<li>\u691c\u7d22\u6761\u4ef6\u306e\u59a5\u5f53\u6027\u691c\u8a3c<\/li>\n\n\n\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8003\u616e\u3057\u305f\u6761\u4ef6\u9806\u5e8f<\/li>\n\n\n\n<li>LIKE\u691c\u7d22\u6642\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8003\u616e<\/li>\n\n\n\n<li>\u65e5\u4ed8\u7bc4\u56f2\u691c\u7d22\u306e\u9069\u5207\u306a\u51e6\u7406<\/li>\n<\/ol>\n<\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-17\">2. \u66f4\u65b0\u9805\u76ee\u306e\u9078\u629e\u7684\u8a2d\u5b9a\u30d1\u30bf\u30fc\u30f3<\/h2>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>\u30e6\u30fc\u30b6\u30fc\u30d7\u30ed\u30d5\u30a1\u30a4\u30eb\u306e\u90e8\u5206\u66f4\u65b0<\/li>\n\n\n\n<li>\u5546\u54c1\u60c5\u5831\u306e\u9078\u629e\u7684\u66f4\u65b0<\/li>\n\n\n\n<li>\u30b9\u30c6\u30fc\u30bf\u30b9\u66f4\u65b0\u51e6\u7406<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: \u66f4\u65b0\u60c5\u5831\u3092\u4fdd\u6301\u3059\u308bDTO\u30af\u30e9\u30b9\n@Data\npublic class UserUpdateRequest {\n    private Long id;\n    private String name;\n    private String email;\n    private String phoneNumber;\n    private Address address;  \/\/ \u6ce8\u610f: \u8907\u5408\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n\n    @Data\n    public static class Address {\n        private String postalCode;\n        private String prefecture;\n        private String city;\n        private String street;\n    }\n}<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u9078\u629e\u7684\u66f4\u65b0\u306eMapper\u5b9f\u88c5 --&gt;\n&lt;update id=\"updateUser\" parameterType=\"UserUpdateRequest\"&gt;\n    UPDATE users\n    &lt;set&gt;\n        &lt;!-- \u6ce8\u610f: \u57fa\u672c\u60c5\u5831\u306e\u66f4\u65b0 --&gt;\n        &lt;if test=\"name != null\"&gt;name = #{name},&lt;\/if&gt;\n        &lt;if test=\"email != null\"&gt;email = #{email},&lt;\/if&gt;\n        &lt;if test=\"phoneNumber != null\"&gt;phone_number = #{phoneNumber},&lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u8907\u5408\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u51e6\u7406 --&gt;\n        &lt;if test=\"address != null\"&gt;\n            &lt;if test=\"address.postalCode != null\"&gt;\n                postal_code = #{address.postalCode},\n            &lt;\/if&gt;\n            &lt;if test=\"address.prefecture != null\"&gt;\n                prefecture = #{address.prefecture},\n            &lt;\/if&gt;\n            &lt;if test=\"address.city != null\"&gt;\n                city = #{address.city},\n            &lt;\/if&gt;\n            &lt;if test=\"address.street != null\"&gt;\n                street = #{address.street},\n            &lt;\/if&gt;\n        &lt;\/if&gt;\n\n        updated_at = CURRENT_TIMESTAMP\n    &lt;\/set&gt;\n    WHERE id = #{id}\n&lt;\/update&gt;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-18\">3. \u8907\u6570\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b\u30d1\u30bf\u30fc\u30f3<\/h2>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>\u8907\u96d1\u306a\u696d\u52d9\u30ed\u30b8\u30c3\u30af\u306e\u5b9f\u88c5<\/li>\n\n\n\n<li>\u6a29\u9650\u306b\u5fdc\u3058\u305f\u6761\u4ef6\u5206\u5c90<\/li>\n\n\n\n<li>\u30b9\u30c6\u30fc\u30bf\u30b9\u3068\u65e5\u4ed8\u306b\u3088\u308b\u8907\u5408\u6761\u4ef6<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: \u8907\u5408\u6761\u4ef6\u3092\u6271\u3046DTO\u30af\u30e9\u30b9\n@Data\npublic class OrderSearchCriteria {\n    private String orderStatus;\n    private BigDecimal minAmount;\n    private BigDecimal maxAmount;\n    private List&lt;String&gt; paymentMethods;\n    private boolean includeExpired;\n    private UserRole userRole;  \/\/ \u6a29\u9650\u306b\u3088\u308b\u6761\u4ef6\u5206\u5c90\u7528\n\n    public enum UserRole {\n        ADMIN, MANAGER, OPERATOR\n    }\n}<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u8907\u96d1\u306a\u6761\u4ef6\u5206\u5c90\u306eMapper\u5b9f\u88c5 --&gt;\n&lt;select id=\"findOrders\" resultType=\"Order\"&gt;\n    SELECT \n        o.id,\n        o.order_number,\n        o.status,\n        o.amount,\n        o.created_at\n    FROM \n        orders o\n    &lt;where&gt;\n        &lt;!-- \u6ce8\u610f: \u6a29\u9650\u306b\u3088\u308b\u6761\u4ef6\u5206\u5c90 --&gt;\n        &lt;choose&gt;\n            &lt;when test=\"criteria.userRole == 'ADMIN'\"&gt;\n                &lt;!-- \u7ba1\u7406\u8005\u306f\u5168\u4ef6\u53c2\u7167\u53ef\u80fd --&gt;\n            &lt;\/when&gt;\n            &lt;when test=\"criteria.userRole == 'MANAGER'\"&gt;\n                AND o.department_id = #{currentDepartmentId}\n            &lt;\/when&gt;\n            &lt;otherwise&gt;\n                AND o.created_by = #{currentUserId}\n            &lt;\/otherwise&gt;\n        &lt;\/choose&gt;\n\n        &lt;!-- \u6ce8\u610f: \u30b9\u30c6\u30fc\u30bf\u30b9\u3068\u91d1\u984d\u306b\u3088\u308b\u7d5e\u308a\u8fbc\u307f --&gt;\n        &lt;if test=\"criteria.orderStatus != null\"&gt;\n            AND o.status = #{criteria.orderStatus}\n        &lt;\/if&gt;\n        &lt;if test=\"criteria.minAmount != null\"&gt;\n            AND o.amount &gt;= #{criteria.minAmount}\n        &lt;\/if&gt;\n        &lt;if test=\"criteria.maxAmount != null\"&gt;\n            AND o.amount &lt;= #{criteria.maxAmount}\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u652f\u6255\u65b9\u6cd5\u306b\u3088\u308b\u7d5e\u308a\u8fbc\u307f --&gt;\n        &lt;if test=\"criteria.paymentMethods != null and !criteria.paymentMethods.isEmpty()\"&gt;\n            AND o.payment_method IN\n            &lt;foreach item=\"method\" collection=\"criteria.paymentMethods\"\n                     open=\"(\" separator=\",\" close=\")\"&gt;\n                #{method}\n            &lt;\/foreach&gt;\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u6709\u52b9\u671f\u9650\u5207\u308c\u306e\u9664\u5916\/\u5305\u542b --&gt;\n        &lt;if test=\"!criteria.includeExpired\"&gt;\n            AND (o.expired_at IS NULL OR o.expired_at &gt; CURRENT_TIMESTAMP)\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n    ORDER BY o.created_at DESC\n&lt;\/select&gt;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-19\">4. NULL\u5024\u306e\u9069\u5207\u306a\u51e6\u7406\u30d1\u30bf\u30fc\u30f3<\/h2>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>NULL\u5024\u3092\u542b\u3080\u691c\u7d22\u6761\u4ef6<\/li>\n\n\n\n<li>NULL\u5024\u306e\u66f4\u65b0\u51e6\u7406<\/li>\n\n\n\n<li>NULL\u5024\u306e\u6bd4\u8f03\u30ed\u30b8\u30c3\u30af<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: NULL\u5024\u3092\u6271\u3046\u305f\u3081\u306e\u6761\u4ef6\u30af\u30e9\u30b9\n@Data\npublic class ProductSearchCriteria {\n    private String name;\n    private String category;\n    private Boolean isDiscontinued;  \/\/ \u4e09\u5024\u8ad6\u7406\n    private NullablePrice price;     \/\/ NULL\u53ef\u80fd\u306a\u4fa1\u683c\n\n    @Data\n    public static class NullablePrice {\n        private BigDecimal value;\n        private boolean includeNull;  \/\/ NULL\u5024\u3092\u542b\u3081\u308b\u304b\u3069\u3046\u304b\n    }\n}<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: NULL\u5024\u3092\u8003\u616e\u3057\u305fMapper\u5b9f\u88c5 --&gt;\n&lt;select id=\"searchProducts\" resultType=\"Product\"&gt;\n    SELECT * FROM products p\n    &lt;where&gt;\n        &lt;!-- \u6ce8\u610f: \u901a\u5e38\u306e\u691c\u7d22\u6761\u4ef6 --&gt;\n        &lt;if test=\"criteria.name != null and criteria.name != ''\"&gt;\n            AND p.name LIKE CONCAT('%', #{criteria.name}, '%')\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u30ab\u30c6\u30b4\u30ea\u307e\u305f\u306fNULL --&gt;\n        &lt;if test=\"criteria.category != null\"&gt;\n            AND (p.category = #{criteria.category} \n                 &lt;if test=\"criteria.includeNullCategory\"&gt;\n                     OR p.category IS NULL\n                 &lt;\/if&gt;\n            )\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u4e09\u5024\u8ad6\u7406\u306e\u51e6\u7406 --&gt;\n        &lt;if test=\"criteria.isDiscontinued != null\"&gt;\n            AND p.is_discontinued = #{criteria.isDiscontinued}\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: NULL\u53ef\u80fd\u306a\u4fa1\u683c\u306e\u51e6\u7406 --&gt;\n        &lt;if test=\"criteria.price != null\"&gt;\n            &lt;choose&gt;\n                &lt;when test=\"criteria.price.includeNull\"&gt;\n                    AND (p.price = #{criteria.price.value} OR p.price IS NULL)\n                &lt;\/when&gt;\n                &lt;otherwise&gt;\n                    AND p.price = #{criteria.price.value}\n                    AND p.price IS NOT NULL\n                &lt;\/otherwise&gt;\n            &lt;\/choose&gt;\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n    ORDER BY p.id\n&lt;\/select&gt;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-20\">5. \u65e5\u4ed8\u7bc4\u56f2\u6307\u5b9a\u30d1\u30bf\u30fc\u30f3<\/h2>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>\u671f\u9593\u6307\u5b9a\u691c\u7d22<\/li>\n\n\n\n<li>\u65e5\u6642\u7bc4\u56f2\u306e\u91cd\u8907\u30c1\u30a7\u30c3\u30af<\/li>\n\n\n\n<li>\u671f\u9650\u5207\u308c\u5224\u5b9a<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: \u65e5\u4ed8\u7bc4\u56f2\u3092\u6271\u3046DTO\u30af\u30e9\u30b9\n@Data\npublic class DateRangeCondition {\n    private LocalDateTime startDate;\n    private LocalDateTime endDate;\n    private DateRangeType rangeType;\n\n    public enum DateRangeType {\n        INCLUSIVE,      \/\/ \u958b\u59cb\u65e5\u3068\u7d42\u4e86\u65e5\u3092\u542b\u3080\n        EXCLUSIVE,      \/\/ \u958b\u59cb\u65e5\u3068\u7d42\u4e86\u65e5\u3092\u542b\u307e\u306a\u3044\n        START_INCLUSIVE, \/\/ \u958b\u59cb\u65e5\u306e\u307f\u542b\u3080\n        END_INCLUSIVE   \/\/ \u7d42\u4e86\u65e5\u306e\u307f\u542b\u3080\n    }\n\n    \/\/ \u6ce8\u610f: \u65e5\u4ed8\u7bc4\u56f2\u306e\u59a5\u5f53\u6027\u30c1\u30a7\u30c3\u30af\n    public boolean isValid() {\n        if (startDate == null || endDate == null) {\n            return false;\n        }\n        return !startDate.isAfter(endDate);\n    }\n}<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u65e5\u4ed8\u7bc4\u56f2\u691c\u7d22\u306eMapper\u5b9f\u88c5 --&gt;\n&lt;select id=\"findByDateRange\" resultType=\"Event\"&gt;\n    SELECT * FROM events e\n    &lt;where&gt;\n        &lt;!-- \u6ce8\u610f: \u65e5\u4ed8\u7bc4\u56f2\u306e\u52d5\u7684\u751f\u6210 --&gt;\n        &lt;if test=\"range != null and range.startDate != null\"&gt;\n            &lt;choose&gt;\n                &lt;when test=\"range.rangeType == 'INCLUSIVE' or range.rangeType == 'START_INCLUSIVE'\"&gt;\n                    AND e.event_date &gt;= #{range.startDate}\n                &lt;\/when&gt;\n                &lt;otherwise&gt;\n                    AND e.event_date &gt; #{range.startDate}\n                &lt;\/otherwise&gt;\n            &lt;\/choose&gt;\n        &lt;\/if&gt;\n        &lt;if test=\"range != null and range.endDate != null\"&gt;\n            &lt;choose&gt;\n                &lt;when test=\"range.rangeType == 'INCLUSIVE' or range.rangeType == 'END_INCLUSIVE'\"&gt;\n                    AND e.event_date &lt;= #{range.endDate}\n                &lt;\/when&gt;\n                &lt;otherwise&gt;\n                    AND e.event_date &lt; #{range.endDate}\n                &lt;\/otherwise&gt;\n            &lt;\/choose&gt;\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306e\u8003\u616e --&gt;\n        AND e.event_date AT TIME ZONE 'UTC' \n            AT TIME ZONE #{userTimezone} &gt;= CURRENT_TIMESTAMP\n    &lt;\/where&gt;\n    ORDER BY e.event_date\n&lt;\/select&gt;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-21\">6. IN\u53e5\u306e\u52d5\u7684\u751f\u6210\u30d1\u30bf\u30fc\u30f3<\/h2>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>\u8907\u6570ID\u306b\u3088\u308b\u4e00\u62ec\u691c\u7d22<\/li>\n\n\n\n<li>\u30ab\u30c6\u30b4\u30ea\u3084\u30bf\u30b0\u306b\u3088\u308b\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u6a29\u9650\u306b\u3088\u308b\u8907\u6570\u6761\u4ef6\u30d5\u30a3\u30eb\u30bf<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: IN\u53e5\u3067\u4f7f\u7528\u3059\u308b\u6761\u4ef6\u3092\u6271\u3046DTO\u30af\u30e9\u30b9\n@Data\npublic class BatchSearchCondition&lt;T&gt; {\n    private List&lt;T&gt; includeItems;    \/\/ IN\u53e5\u306b\u542b\u3081\u308b\u9805\u76ee\n    private List&lt;T&gt; excludeItems;    \/\/ NOT IN\u53e5\u306b\u542b\u3081\u308b\u9805\u76ee\n    private Integer maxItemCount;     \/\/ \u6700\u5927\u4ef6\u6570\u5236\u9650\n\n    \/\/ \u6ce8\u610f: \u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u30e1\u30bd\u30c3\u30c9\n    public boolean isValid() {\n        if (includeItems == null || includeItems.isEmpty()) {\n            return false;\n        }\n        \/\/ \u6ce8\u610f: \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u8003\u616e\u3057\u305f\u4e0a\u9650\u30c1\u30a7\u30c3\u30af\n        if (maxItemCount != null &amp;&amp; includeItems.size() &gt; maxItemCount) {\n            return false;\n        }\n        return true;\n    }\n}\n\n\/\/ \u8aac\u660e: \u8907\u6570\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u691c\u7d22\u7528DTO\n@Data\npublic class ProductBatchSearchRequest {\n    private BatchSearchCondition&lt;Long&gt; productIds;\n    private BatchSearchCondition&lt;String&gt; categories;\n    private BatchSearchCondition&lt;String&gt; tags;\n    private boolean includePriceInfo;  \/\/ \u4fa1\u683c\u60c5\u5831\u3092\u542b\u3081\u308b\u304b\u3069\u3046\u304b\n    private boolean includeStockInfo;  \/\/ \u5728\u5eab\u60c5\u5831\u3092\u542b\u3081\u308b\u304b\u3069\u3046\u304b\n}<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: IN\u53e5\u3092\u4f7f\u7528\u3057\u305f\u52d5\u7684\u30af\u30a8\u30ea\u306eMapper\u5b9f\u88c5 --&gt;\n&lt;select id=\"findProductsByBatchCondition\" resultType=\"Product\"&gt;\n    SELECT \n        p.id,\n        p.name,\n        p.category,\n        &lt;!-- \u6ce8\u610f: \u52d5\u7684\u306a\u30ab\u30e9\u30e0\u9078\u629e --&gt;\n        &lt;if test=\"request.includePriceInfo\"&gt;\n            p.price,\n            p.discount_rate,\n        &lt;\/if&gt;\n        &lt;if test=\"request.includeStockInfo\"&gt;\n            p.stock_quantity,\n            p.reserved_quantity,\n        &lt;\/if&gt;\n        p.updated_at\n    FROM \n        products p\n    &lt;!-- \u6ce8\u610f: \u30bf\u30b0\u60c5\u5831\u306e\u7d50\u5408 --&gt;\n    &lt;if test=\"request.tags != null and !request.tags.includeItems.isEmpty()\"&gt;\n        INNER JOIN product_tags pt ON p.id = pt.product_id\n    &lt;\/if&gt;\n    &lt;where&gt;\n        &lt;!-- \u6ce8\u610f: \u5546\u54c1ID\u306b\u3088\u308b\u7d5e\u308a\u8fbc\u307f --&gt;\n        &lt;if test=\"request.productIds != null and !request.productIds.includeItems.isEmpty()\"&gt;\n            p.id IN\n            &lt;foreach item=\"id\" collection=\"request.productIds.includeItems\"\n                     open=\"(\" separator=\",\" close=\")\"&gt;\n                #{id}\n            &lt;\/foreach&gt;\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u9664\u5916\u3059\u308b\u5546\u54c1ID --&gt;\n        &lt;if test=\"request.productIds != null and !request.productIds.excludeItems.isEmpty()\"&gt;\n            AND p.id NOT IN\n            &lt;foreach item=\"id\" collection=\"request.productIds.excludeItems\"\n                     open=\"(\" separator=\",\" close=\")\"&gt;\n                #{id}\n            &lt;\/foreach&gt;\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u30ab\u30c6\u30b4\u30ea\u306b\u3088\u308b\u7d5e\u308a\u8fbc\u307f --&gt;\n        &lt;if test=\"request.categories != null and !request.categories.includeItems.isEmpty()\"&gt;\n            AND p.category IN\n            &lt;foreach item=\"category\" collection=\"request.categories.includeItems\"\n                     open=\"(\" separator=\",\" close=\")\"&gt;\n                #{category}\n            &lt;\/foreach&gt;\n        &lt;\/if&gt;\n\n        &lt;!-- \u6ce8\u610f: \u30bf\u30b0\u306b\u3088\u308b\u7d5e\u308a\u8fbc\u307f --&gt;\n        &lt;if test=\"request.tags != null and !request.tags.includeItems.isEmpty()\"&gt;\n            AND pt.tag_name IN\n            &lt;foreach item=\"tag\" collection=\"request.tags.includeItems\"\n                     open=\"(\" separator=\",\" close=\")\"&gt;\n                #{tag}\n            &lt;\/foreach&gt;\n            &lt;!-- \u6ce8\u610f: \u30bf\u30b0\u306e\u91cd\u8907\u3092\u9664\u53bb --&gt;\n            GROUP BY p.id, p.name, p.category\n            &lt;if test=\"request.includePriceInfo\"&gt;\n                , p.price, p.discount_rate\n            &lt;\/if&gt;\n            &lt;if test=\"request.includeStockInfo\"&gt;\n                , p.stock_quantity, p.reserved_quantity\n            &lt;\/if&gt;\n            , p.updated_at\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n    ORDER BY p.id\n&lt;\/select&gt;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-22\">7. \u30da\u30fc\u30b8\u30f3\u30b0\u51e6\u7406\u3068\u306e\u7d44\u307f\u5408\u308f\u305b\u30d1\u30bf\u30fc\u30f3<\/h2>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>\u5927\u91cf\u30c7\u30fc\u30bf\u306e\u52b9\u7387\u7684\u306a\u53d6\u5f97<\/li>\n\n\n\n<li>\u52d5\u7684\u306a\u4e26\u3073\u66ff\u3048<\/li>\n\n\n\n<li>\u691c\u7d22\u6761\u4ef6\u4ed8\u304d\u30da\u30fc\u30b8\u30f3\u30b0<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: \u30da\u30fc\u30b8\u30f3\u30b0\u60c5\u5831\u3092\u6271\u3046DTO\u30af\u30e9\u30b9\n@Data\npublic class PageRequest {\n    private Integer page;      \/\/ \u30da\u30fc\u30b8\u756a\u53f7\uff080\u30d9\u30fc\u30b9\uff09\n    private Integer size;      \/\/ \u30da\u30fc\u30b8\u30b5\u30a4\u30ba\n    private String sortField;  \/\/ \u30bd\u30fc\u30c8\u30d5\u30a3\u30fc\u30eb\u30c9\n    private SortDirection sortDirection;  \/\/ \u30bd\u30fc\u30c8\u65b9\u5411\n\n    public enum SortDirection {\n        ASC, DESC\n    }\n\n    \/\/ \u6ce8\u610f: \u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u306e\u8a2d\u5b9a\n    @Builder.Default\n    private Integer maxPageSize = 100;  \/\/ \u6700\u5927\u30da\u30fc\u30b8\u30b5\u30a4\u30ba\n\n    \/\/ \u6ce8\u610f: \u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u30e1\u30bd\u30c3\u30c9\n    public boolean isValid() {\n        if (page == null || page &lt; 0) return false;\n        if (size == null || size &lt;= 0 || size &gt; maxPageSize) return false;\n        if (sortField != null &amp;&amp; !ALLOWED_SORT_FIELDS.contains(sortField)) return false;\n        return true;\n    }\n\n    \/\/ \u6ce8\u610f: OFFSET\u5024\u306e\u8a08\u7b97\n    public long getOffset() {\n        return (long) page * size;\n    }\n}\n\n\/\/ \u8aac\u660e: \u691c\u7d22\u6761\u4ef6\u4ed8\u304d\u30da\u30fc\u30b8\u30f3\u30b0\u7528DTO\n@Data\npublic class ProductSearchPageRequest {\n    private String keyword;\n    private List&lt;String&gt; categories;\n    private PriceRange priceRange;\n    private PageRequest pageRequest;\n\n    @Data\n    public static class PriceRange {\n        private BigDecimal min;\n        private BigDecimal max;\n    }\n}<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u8aac\u660e: \u30da\u30fc\u30b8\u30f3\u30b0\u51e6\u7406\u3092\u542b\u3080Mapper\u5b9f\u88c5 --&gt;\n&lt;select id=\"findProductsWithPaging\" resultType=\"Product\"&gt;\n    &lt;!-- \u6ce8\u610f: WITH\u53e5\u3067\u5171\u901a\u6761\u4ef6\u3092\u5b9a\u7fa9 --&gt;\n    WITH filtered_products AS (\n        SELECT \n            p.id,\n            p.name,\n            p.category,\n            p.price,\n            p.created_at\n        FROM \n            products p\n        &lt;where&gt;\n            &lt;!-- \u6ce8\u610f: \u30ad\u30fc\u30ef\u30fc\u30c9\u691c\u7d22 --&gt;\n            &lt;if test=\"request.keyword != null and request.keyword != ''\"&gt;\n                AND (\n                    p.name ILIKE CONCAT('%', #{request.keyword}, '%')\n                    OR p.description ILIKE CONCAT('%', #{request.keyword}, '%')\n                )\n            &lt;\/if&gt;\n\n            &lt;!-- \u6ce8\u610f: \u30ab\u30c6\u30b4\u30ea\u30d5\u30a3\u30eb\u30bf --&gt;\n            &lt;if test=\"request.categories != null and !request.categories.isEmpty()\"&gt;\n                AND p.category IN\n                &lt;foreach item=\"category\" collection=\"request.categories\"\n                         open=\"(\" separator=\",\" close=\")\"&gt;\n                    #{category}\n                &lt;\/foreach&gt;\n            &lt;\/if&gt;\n\n            &lt;!-- \u6ce8\u610f: \u4fa1\u683c\u7bc4\u56f2\u30d5\u30a3\u30eb\u30bf --&gt;\n            &lt;if test=\"request.priceRange != null\"&gt;\n                &lt;if test=\"request.priceRange.min != null\"&gt;\n                    AND p.price &gt;= #{request.priceRange.min}\n                &lt;\/if&gt;\n                &lt;if test=\"request.priceRange.max != null\"&gt;\n                    AND p.price &lt;= #{request.priceRange.max}\n                &lt;\/if&gt;\n            &lt;\/if&gt;\n        &lt;\/where&gt;\n    )\n    SELECT *\n    FROM filtered_products\n    &lt;!-- \u6ce8\u610f: \u52d5\u7684\u306a\u30bd\u30fc\u30c8\u6761\u4ef6 --&gt;\n    &lt;choose&gt;\n        &lt;when test=\"request.pageRequest.sortField != null\"&gt;\n            ORDER BY \n            ${request.pageRequest.sortField} \n            ${request.pageRequest.sortDirection}\n        &lt;\/when&gt;\n        &lt;otherwise&gt;\n            ORDER BY id DESC\n        &lt;\/otherwise&gt;\n    &lt;\/choose&gt;\n    &lt;!-- \u6ce8\u610f: \u30da\u30fc\u30b8\u30f3\u30b0\u51e6\u7406 --&gt;\n    LIMIT #{request.pageRequest.size}\n    OFFSET #{request.pageRequest.offset}\n&lt;\/select&gt;\n\n&lt;!-- \u6ce8\u610f: \u7dcf\u4ef6\u6570\u53d6\u5f97\u7528\u306e\u30af\u30a8\u30ea --&gt;\n&lt;select id=\"countFilteredProducts\" resultType=\"long\"&gt;\n    SELECT COUNT(*)\n    FROM products p\n    &lt;where&gt;\n        &lt;!-- \u6ce8\u610f: \u691c\u7d22\u6761\u4ef6\u306f\u4e0a\u8a18\u3068\u540c\u3058 --&gt;\n        &lt;if test=\"request.keyword != null and request.keyword != ''\"&gt;\n            AND (\n                p.name ILIKE CONCAT('%', #{request.keyword}, '%')\n                OR p.description ILIKE CONCAT('%', #{request.keyword}, '%')\n            )\n        &lt;\/if&gt;\n        &lt;if test=\"request.categories != null and !request.categories.isEmpty()\"&gt;\n            AND p.category IN\n            &lt;foreach item=\"category\" collection=\"request.categories\"\n                     open=\"(\" separator=\",\" close=\")\"&gt;\n                #{category}\n            &lt;\/foreach&gt;\n        &lt;\/if&gt;\n        &lt;if test=\"request.priceRange != null\"&gt;\n            &lt;if test=\"request.priceRange.min != null\"&gt;\n                AND p.price &gt;= #{request.priceRange.min}\n            &lt;\/if&gt;\n            &lt;if test=\"request.priceRange.max != null\"&gt;\n                AND p.price &lt;= #{request.priceRange.max}\n            &lt;\/if&gt;\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n&lt;\/select&gt;<\/pre>\n\n\n\n<div class=\"wp-block-sgb-message\"><div class=\"memo sng-shadow-0\" style=\"border-radius:0px;background-color:#ffebeb;color:#f88080\"><div class=\"memo_ttl dfont\"><span class=\"sng-box-msg__icon\" style=\"background:#f88080\"><i class=\"fas fa-exclamation\"><\/i><\/span><div class=\"sng-box-msg__title\">\u5b9f\u88c5\u6642\u306e\u6ce8\u610f\u70b9<\/div><\/div><div class=\"sng-box-msg__contents\">\n<ol class=\"wp-block-list\">\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8003\u616e\u4e8b\u9805\n<ul class=\"wp-block-list\">\n<li>\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08<\/li>\n\n\n\n<li>\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u5236\u9650<\/li>\n\n\n\n<li>\u52b9\u7387\u7684\u306a\u30bd\u30fc\u30c8\u51e6\u7406<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u8003\u616e\u4e8b\u9805\n<ul class=\"wp-block-list\">\n<li>SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56<\/li>\n\n\n\n<li>\u6a29\u9650\u30c1\u30a7\u30c3\u30af<\/li>\n\n\n\n<li>\u5165\u529b\u5024\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u4fdd\u5b88\u6027\u5411\u4e0a\u306e\u30dd\u30a4\u30f3\u30c8\n<ul class=\"wp-block-list\">\n<li>\u5171\u901a\u6761\u4ef6\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u5316<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30b3\u30e1\u30f3\u30c8\u4ed8\u4e0e<\/li>\n\n\n\n<li>\u578b\u5b89\u5168\u6027\u306e\u78ba\u4fdd<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/div><\/div><\/div>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-23\">\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/h1>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\"><strong>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u5b66\u3079\u308b\u3053\u3068<\/strong><\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>MyBatis if\u3067\u767a\u751f\u3059\u308b\u4e3b\u8981\u306a\u30a8\u30e9\u30fc\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5<\/li>\n\n\n\n<li>\u52b9\u7387\u7684\u306a\u30c7\u30d0\u30c3\u30b0\u624b\u6cd5<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u554f\u984c\u306e\u7279\u5b9a\u3068\u6539\u5584\u65b9\u6cd5<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-sgb-message\"><div class=\"memo sng-shadow-0\" style=\"border-radius:0px;background-color:#b4e0fa;color:#009EF3\"><div class=\"memo_ttl dfont\"><span class=\"sng-box-msg__icon\" style=\"background:#009EF3\"><i class=\"far fa-lightbulb\"><\/i><\/span><div class=\"sng-box-msg__title\">\ud83d\udca1 <strong>\u91cd\u8981\u30dd\u30a4\u30f3\u30c8<\/strong><\/div><\/div><div class=\"sng-box-msg__contents\">\n<ul class=\"wp-block-list\">\n<li>\u30a8\u30e9\u30fc\u306e\u539f\u56e0\u306f\u5927\u304d\u304f\u300c\u69cb\u6587\u30a8\u30e9\u30fc\u300d\u300c\u30ed\u30b8\u30c3\u30af\u30a8\u30e9\u30fc\u300d\u300c\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u554f\u984c\u300d\u306b\u5206\u985e\u3055\u308c\u308b<\/li>\n\n\n\n<li>\u30ed\u30b0\u8a2d\u5b9a\u3092\u9069\u5207\u306b\u884c\u3046\u3053\u3068\u3067\u30c7\u30d0\u30c3\u30b0\u304c\u5bb9\u6613\u306b\u306a\u308b<\/li>\n\n\n\n<li>\u5b9f\u884c\u8a08\u753b\u306e\u78ba\u8a8d\u304c\u6027\u80fd\u6539\u5584\u306e\u9375\u3068\u306a\u308b<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-24\">\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u3068\u89e3\u6c7a\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-25\">1. \u69cb\u6587\u30a8\u30e9\u30fc\u306e\u5bfe\u51e6<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-26\">OGNL\u5f0f\u306e\u69cb\u6587\u30a8\u30e9\u30fc<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u274c \u30a8\u30e9\u30fc\u30d1\u30bf\u30fc\u30f31: \u4ee3\u5165\u6f14\u7b97\u5b50\u306e\u8aa4\u7528 --&gt;\n&lt;if test=\"status = 'ACTIVE'\"&gt;  &lt;!-- \u30b3\u30f3\u30d1\u30a4\u30eb\u30a8\u30e9\u30fc --&gt;\n    AND status = #{status}\n&lt;\/if&gt;\n\n&lt;!-- \u2705 \u6b63\u3057\u3044\u5b9f\u88c5 --&gt;\n&lt;if test=\"status == 'ACTIVE'\"&gt;  &lt;!-- \u6bd4\u8f03\u6f14\u7b97\u5b50\u3092\u4f7f\u7528 --&gt;\n    AND status = #{status}\n&lt;\/if&gt;\n\n&lt;!-- \u274c \u30a8\u30e9\u30fc\u30d1\u30bf\u30fc\u30f32: \u30e1\u30bd\u30c3\u30c9\u547c\u3073\u51fa\u3057\u306e\u8aa4\u308a --&gt;\n&lt;if test=\"list.size &gt; 0\"&gt;  &lt;!-- NullPointerException \u306e\u5371\u967a --&gt;\n    AND id IN ...\n&lt;\/if&gt;\n\n&lt;!-- \u2705 \u6b63\u3057\u3044\u5b9f\u88c5 --&gt;\n&lt;if test=\"list != null and !list.isEmpty()\"&gt;  &lt;!-- \u5b89\u5168\u306a\u30c1\u30a7\u30c3\u30af --&gt;\n    AND id IN ...\n&lt;\/if&gt;<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-27\">SQL\u30a8\u30e9\u30fc\u306e\u9632\u6b62<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u274c \u30a8\u30e9\u30fc\u30d1\u30bf\u30fc\u30f3: \u30ab\u30f3\u30de\u306e\u6271\u3044 --&gt;\n&lt;update id=\"updateUser\"&gt;\n    UPDATE users SET\n    &lt;if test=\"name != null\"&gt;\n        name = #{name},   &lt;!-- \u6700\u5f8c\u306e\u30ab\u30f3\u30de\u304c\u554f\u984c\u306b --&gt;\n    &lt;\/if&gt;\n    &lt;if test=\"email != null\"&gt;\n        email = #{email}, &lt;!-- \u6700\u5f8c\u306e\u30ab\u30f3\u30de\u304c\u554f\u984c\u306b --&gt;\n    &lt;\/if&gt;\n    updated_at = CURRENT_TIMESTAMP\n&lt;\/update&gt;\n\n&lt;!-- \u2705 \u6b63\u3057\u3044\u5b9f\u88c5 --&gt;\n&lt;update id=\"updateUser\"&gt;\n    UPDATE users\n    &lt;set&gt;\n        &lt;if test=\"name != null\"&gt;name = #{name},&lt;\/if&gt;\n        &lt;if test=\"email != null\"&gt;email = #{email},&lt;\/if&gt;\n        updated_at = CURRENT_TIMESTAMP\n    &lt;\/set&gt;\n    WHERE id = #{id}\n&lt;\/update&gt;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-28\">\u30a8\u30e9\u30fc\u5bfe\u5fdc\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/h3>\n\n\n<div id=\"id-cea2d8c6-d776-4b2e-bfd2-5d98015c6f6c\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u30a8\u30e9\u30fc\u306e\u7a2e\u985e<\/th><th>\u78ba\u8a8d\u30dd\u30a4\u30f3\u30c8<\/th><th>\u5bfe\u51e6\u65b9\u6cd5<\/th><\/tr><\/thead><tbody><tr><td>OGNL\u5f0f\u30a8\u30e9\u30fc<\/td><td>\u2013 \u6bd4\u8f03\u6f14\u7b97\u5b50\u306e\u4f7f\u7528<br>\u2013 NULL \u30c1\u30a7\u30c3\u30af<br>\u2013 \u30e1\u30bd\u30c3\u30c9\u547c\u3073\u51fa\u3057<\/td><td>\u2013 <code>==<\/code> \u3092\u4f7f\u7528<br>\u2013 <code>null<\/code> \u30c1\u30a7\u30c3\u30af\u3092\u8ffd\u52a0<br>\u2013 \u5b89\u5168\u306a\u30e1\u30bd\u30c3\u30c9\u547c\u3073\u51fa\u3057<\/td><\/tr><tr><td>SQL\u69cb\u6587\u30a8\u30e9\u30fc<\/td><td>\u2013 \u30ab\u30f3\u30de\u306e\u51e6\u7406<br>\u2013 WHERE\u53e5\u306e\u6761\u4ef6<br>\u2013 \u4e88\u7d04\u8a9e\u306e\u4f7f\u7528<\/td><td>\u2013 <code>&lt;set&gt;<\/code> \u8981\u7d20\u306e\u4f7f\u7528<br>\u2013 <code>&lt;where&gt;<\/code> \u8981\u7d20\u306e\u4f7f\u7528<br>\u2013 \u30ab\u30e9\u30e0\u540d\u306e\u30a8\u30b9\u30b1\u30fc\u30d7<\/td><\/tr><tr><td>\u30d0\u30a4\u30f3\u30c9\u30a8\u30e9\u30fc<\/td><td>\u2013 \u30d1\u30e9\u30e1\u30fc\u30bf\u578b\u306e\u4e00\u81f4<br>\u2013 \u540d\u524d\u306e\u4e00\u81f4<br>\u2013 \u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u51e6\u7406<\/td><td>\u2013 DTO\u306e\u578b\u3092\u78ba\u8a8d<br>\u2013 \u30d1\u30e9\u30e1\u30fc\u30bf\u540d\u3092\u78ba\u8a8d<br>\u2013 <code>&lt;foreach&gt;<\/code> \u306e\u9069\u5207\u306a\u4f7f\u7528<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"i-29\">\u30c7\u30d0\u30c3\u30b0\u306e\u30b3\u30c4\u3068\u30ed\u30b0\u78ba\u8a8d\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-30\">1. \u30ed\u30b0\u8a2d\u5b9a<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># application.properties\n# \u57fa\u672c\u7684\u306aMyBatis\u306e\u30ed\u30b0\u8a2d\u5b9a\nmybatis.configuration.log-impl=org.apache.ibatis.logging.slf4j.Slf4jImpl\nlogging.level.your.package.mapper=DEBUG\n\n# \u8a73\u7d30\u306aSQL\u30ed\u30b0\nlogging.level.org.apache.ibatis=TRACE<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-31\">2. \u30c7\u30d0\u30c3\u30b0\u7528\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\u30af\u30e9\u30b9<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: SQL\u30c7\u30d0\u30c3\u30b0\u7528\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\n@Slf4j\npublic class MyBatisDebugUtil {\n    \/\/ \u8aac\u660e: \u751f\u6210\u3055\u308c\u305fSQL\u3092\u30ed\u30b0\u51fa\u529b\n    public static void logGeneratedSql(SqlSession sqlSession, \n                                     String mapperId, \n                                     Object parameter) {\n        try {\n            Configuration configuration = sqlSession.getConfiguration();\n            MappedStatement ms = configuration.getMappedStatement(mapperId);\n            BoundSql boundSql = ms.getBoundSql(parameter);\n\n            log.debug(\"=== Generated SQL ===\");\n            log.debug(boundSql.getSql());\n            log.debug(\"=== Parameters ===\");\n            log.debug(parameter.toString());\n\n            \/\/ \u8aac\u660e: \u30d0\u30a4\u30f3\u30c9\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u51fa\u529b\n            List&lt;ParameterMapping&gt; paramMappings = boundSql.getParameterMappings();\n            for (ParameterMapping mapping : paramMappings) {\n                String property = mapping.getProperty();\n                Object value = ExpressionEvaluator.getValue(property, parameter);\n                log.debug(\"{} = {}\", property, value);\n            }\n        } catch (Exception e) {\n            log.error(\"SQL logging failed\", e);\n        }\n    }\n\n    \/\/ \u8aac\u660e: \u30a8\u30e9\u30fc\u767a\u751f\u6642\u306e\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u60c5\u5831\u51fa\u529b\n    public static void logErrorContext(Exception e, \n                                     String mapperId, \n                                     Object parameter) {\n        log.error(\"=== Error Context ===\");\n        log.error(\"Mapper ID: {}\", mapperId);\n        log.error(\"Parameter: {}\", parameter);\n        log.error(\"Exception: \", e);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-32\">3. \u30c7\u30d0\u30c3\u30b0\u624b\u9806<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30a8\u30e9\u30fc\u306e\u7279\u5b9a<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">try {\n    List&lt;User&gt; users = userMapper.findByCondition(condition);\n} catch (Exception e) {\n    MyBatisDebugUtil.logErrorContext(e, \"UserMapper.findByCondition\", condition);\n    throw e;\n}<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>SQL\u5b9f\u884c\u8a08\u753b\u306e\u78ba\u8a8d<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- \u8aac\u660e: \u5b9f\u884c\u8a08\u753b\u306e\u78ba\u8a8d\nEXPLAIN ANALYZE\nSELECT * FROM users\nWHERE status = 'ACTIVE'\nAND age &gt;= 20\nORDER BY created_at DESC;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-33\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u4f4e\u4e0b\u6642\u306e\u6539\u5584\u30dd\u30a4\u30f3\u30c8<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-34\">1. \u5b9f\u884c\u8a08\u753b\u306e\u5206\u6790<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u8aac\u660e: \u5b9f\u884c\u8a08\u753b\u3092\u53d6\u5f97\u3059\u308b\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\n@Slf4j\npublic class QueryPlanUtil {\n    public static void analyzeQueryPlan(DataSource dataSource, \n                                      String sql, \n                                      Map&lt;String, Object&gt; params) {\n        try (Connection conn = dataSource.getConnection()) {\n            String explainSql = \"EXPLAIN ANALYZE \" + sql;\n            try (PreparedStatement stmt = conn.prepareStatement(explainSql)) {\n                \/\/ \u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u30d0\u30a4\u30f3\u30c9\n                for (Map.Entry&lt;String, Object&gt; param : params.entrySet()) {\n                    stmt.setObject(param.getKey(), param.getValue());\n                }\n\n                try (ResultSet rs = stmt.executeQuery()) {\n                    while (rs.next()) {\n                        log.info(\"Query Plan: {}\", rs.getString(1));\n                    }\n                }\n            }\n        } catch (SQLException e) {\n            log.error(\"Failed to analyze query plan\", e);\n        }\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-35\">2. \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6539\u5584\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-36\">\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6700\u9069\u5316<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- \u8aac\u660e: \u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u4f5c\u6210\nCREATE INDEX idx_users_status_age ON users(status, age);\n\n-- \u8aac\u660e: B-tree\u4ee5\u5916\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u691c\u8a0e\nCREATE INDEX idx_users_name_gin ON users USING gin (name gin_trgm_ops);<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-37\">\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;!-- \u274c \u975e\u52b9\u7387\u306a\u30af\u30a8\u30ea --&gt;\n&lt;select id=\"findUsers\"&gt;\n    SELECT * FROM users u\n    LEFT JOIN departments d ON u.department_id = d.id\n    LEFT JOIN user_profiles up ON u.id = up.user_id\n    &lt;where&gt;\n        &lt;if test=\"name != null\"&gt;\n            AND LOWER(u.name) LIKE LOWER(CONCAT('%', #{name}, '%'))\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n&lt;\/select&gt;\n\n&lt;!-- \u2705 \u6700\u9069\u5316\u3055\u308c\u305f\u30af\u30a8\u30ea --&gt;\n&lt;select id=\"findUsers\"&gt;\n    SELECT u.id, u.name, u.email\n    FROM users u\n    &lt;where&gt;\n        &lt;if test=\"name != null\"&gt;\n            AND u.name ILIKE #{name} || '%'\n        &lt;\/if&gt;\n    &lt;\/where&gt;\n    ORDER BY u.id\n    LIMIT #{pageSize} OFFSET #{offset}\n&lt;\/select&gt;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-38\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6539\u5584\u6226\u7565<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30ab\u30e9\u30e0\u53d6\u5f97<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u4f7f\u7528<\/li>\n\n\n\n<li>LIKE\u691c\u7d22\u306e\u6700\u9069\u5316<\/li>\n\n\n\n<li>\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u5236\u9650<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\n<ul class=\"wp-block-list\">\n<li>MyBatis\u306e2\u6b21\u30ad\u30e3\u30c3\u30b7\u30e5\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30ec\u30d9\u30eb\u306e\u30ad\u30e3\u30c3\u30b7\u30e5<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u6709\u52b9\u671f\u9650\u8a2d\u5b9a<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u6700\u9069\u5316\n<ul class=\"wp-block-list\">\n<li>\u9069\u5207\u306a\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406<\/li>\n\n\n\n<li>\u4e00\u62ecINSERT\/UPDATE\u51e6\u7406<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-39\">\u307e\u3068\u3081\uff1aMyBatis if\u306e\u5b9f\u8df5\u7684\u306a\u6d3b\u7528\u306b\u5411\u3051\u3066<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-40\">\u672c\u8a18\u4e8b\u3067\u89e3\u8aac\u3057\u305f\u91cd\u8981\u30dd\u30a4\u30f3\u30c8<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-41\">1. \u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>if\u8981\u7d20\u306f\u52d5\u7684SQL\u306e\u57fa\u672c\u3068\u306a\u308b\u5236\u5fa1\u69cb\u6587<\/li>\n\n\n\n<li>\u5e38\u306bnull\u5224\u5b9a\u3092\u884c\u3044\u3001\u5b89\u5168\u306a\u5b9f\u88c5\u3092\u5fc3\u304c\u3051\u308b<\/li>\n\n\n\n<li>\u6bd4\u8f03\u6f14\u7b97\u5b50\u306f<code>==<\/code>\u3092\u4f7f\u7528\u3057\u3001\u6587\u6cd5\u30a8\u30e9\u30fc\u3092\u9632\u3050<\/li>\n\n\n\n<li>\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3068\u30a4\u30f3\u30c7\u30f3\u30c8\u3092\u6574\u7406\u3057\u3001\u53ef\u8aad\u6027\u3092\u78ba\u4fdd<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-42\">2. \u5b9f\u8df5\u7684\u306a\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3<\/h3>\n\n\n\n<p>\u2705 <strong>\u7fd2\u5f97\u3059\u3079\u304d7\u3064\u306e\u30d1\u30bf\u30fc\u30f3<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u691c\u7d22\u6761\u4ef6\u306e\u52d5\u7684\u751f\u6210\u30d1\u30bf\u30fc\u30f3<\/li>\n\n\n\n<li>\u66f4\u65b0\u9805\u76ee\u306e\u9078\u629e\u7684\u8a2d\u5b9a\u30d1\u30bf\u30fc\u30f3<\/li>\n\n\n\n<li>\u8907\u6570\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b\u30d1\u30bf\u30fc\u30f3<\/li>\n\n\n\n<li>NULL\u5024\u306e\u9069\u5207\u306a\u51e6\u7406\u30d1\u30bf\u30fc\u30f3<\/li>\n\n\n\n<li>\u65e5\u4ed8\u7bc4\u56f2\u6307\u5b9a\u30d1\u30bf\u30fc\u30f3<\/li>\n\n\n\n<li>IN\u53e5\u306e\u52d5\u7684\u751f\u6210\u30d1\u30bf\u30fc\u30f3<\/li>\n\n\n\n<li>\u30da\u30fc\u30b8\u30f3\u30b0\u51e6\u7406\u3068\u306e\u7d44\u307f\u5408\u308f\u305b\u30d1\u30bf\u30fc\u30f3<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-43\">3. \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n<div id=\"id-76bd5a97-023b-49ba-9581-21f4f5a51a3a\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u89b3\u70b9<\/th><th>\u5b9f\u65bd\u3059\u3079\u304d\u5bfe\u7b56<\/th><\/tr><\/thead><tbody><tr><td>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9<\/td><td>\u2013 \u691c\u7d22\u6761\u4ef6\u306b\u5fdc\u3058\u305f\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u8a2d\u8a08<br>\u2013 \u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u6d3b\u7528<\/td><\/tr><tr><td>\u30af\u30a8\u30ea\u6700\u9069\u5316<\/td><td>\u2013 \u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30ab\u30e9\u30e0\u53d6\u5f97<br>\u2013 \u7d50\u679c\u30bb\u30c3\u30c8\u306e\u5236\u9650<br>\u2013 \u52b9\u7387\u7684\u306a\u30bd\u30fc\u30c8\u51e6\u7406<\/td><\/tr><tr><td>\u30ad\u30e3\u30c3\u30b7\u30e5\u6d3b\u7528<\/td><td>\u2013 MyBatis\u306e2\u6b21\u30ad\u30e3\u30c3\u30b7\u30e5\u8a2d\u5b9a<br>\u2013 \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30ec\u30d9\u30eb\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u5c0e\u5165<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-44\">4. \u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u306e\u8981\u70b9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9069\u5207\u306a\u30ed\u30b0\u8a2d\u5b9a\u3067\u30c7\u30d0\u30c3\u30b0\u3092\u52b9\u7387\u5316<\/li>\n\n\n\n<li>\u5b9f\u884c\u8a08\u753b\u306e\u78ba\u8a8d\u3067\u6027\u80fd\u554f\u984c\u3092\u7279\u5b9a<\/li>\n\n\n\n<li>\u30a8\u30e9\u30fc\u30d1\u30bf\u30fc\u30f3\u3092\u7406\u89e3\u3057\u3001\u4e88\u9632\u7684\u306b\u5bfe\u51e6<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-45\">\u5b9f\u8df5\u306e\u305f\u3081\u306e\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-46\">\u958b\u767a\u6642\u306e\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[ ] DTO\u30af\u30e9\u30b9\u3067\u306e\u9069\u5207\u306a\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u5b9f\u88c5<\/li>\n\n\n\n<li>[ ] SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56\u306e\u5b9f\u65bd<\/li>\n\n\n\n<li>[ ] \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u8003\u616e\u3057\u305f\u30af\u30a8\u30ea\u8a2d\u8a08<\/li>\n\n\n\n<li>[ ] \u9069\u5207\u306a\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u306e\u5b9f\u88c5<\/li>\n\n\n\n<li>[ ] \u30b3\u30fc\u30c9\u306e\u53ef\u8aad\u6027\u5411\u4e0a\u5bfe\u7b56<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-47\">\u904b\u7528\u6642\u306e\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[ ] \u30ed\u30b0\u8a2d\u5b9a\u306e\u6700\u9069\u5316<\/li>\n\n\n\n<li>[ ] \u6027\u80fd\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u306e\u5b9f\u65bd<\/li>\n\n\n\n<li>[ ] \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5b9a\u671f\u7684\u306a\u898b\u76f4\u3057<\/li>\n\n\n\n<li>[ ] \u30af\u30a8\u30ea\u5b9f\u884c\u8a08\u753b\u306e\u78ba\u8a8d<\/li>\n\n\n\n<li>[ ] \u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u8a55\u4fa1<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-48\">\u6b21\u306e\u30b9\u30c6\u30c3\u30d7<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u57fa\u790e\u306e\u5f37\u5316<\/strong>\n<ul class=\"wp-block-list\">\n<li>MyBatis\u306e\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u53c2\u7167<\/li>\n\n\n\n<li>\u52d5\u7684SQL\u306e\u4ed6\u306e\u8981\u7d20\u306e\u5b66\u7fd2<\/li>\n\n\n\n<li>SQL\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306e\u6df1\u6398\u308a<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u5b9f\u88c5\u306e\u6539\u5584<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u65e2\u5b58\u30b3\u30fc\u30c9\u3078\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u9069\u7528<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u5b9f\u65bd<\/li>\n\n\n\n<li>\u30e6\u30cb\u30c3\u30c8\u30c6\u30b9\u30c8\u306e\u62e1\u5145<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u5fdc\u7528\u7684\u306a\u53d6\u308a\u7d44\u307f<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30ab\u30b9\u30bf\u30e0\u30bf\u30a4\u30d7\u30cf\u30f3\u30c9\u30e9\u30fc\u306e\u4f5c\u6210<\/li>\n\n\n\n<li>\u72ec\u81ea\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u958b\u767a<\/li>\n\n\n\n<li>\u3088\u308a\u8907\u96d1\u306a\u52d5\u7684SQL\u5b9f\u88c5\u3078\u306e\u6311\u6226<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-49\">\u6700\u5f8c\u306b<\/h2>\n\n\n\n<p>MyBatis if\u306e\u9069\u5207\u306a\u4f7f\u7528\u306f\u3001\u4fdd\u5b88\u6027\u304c\u9ad8\u304f\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u826f\u3044\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5c64\u306e\u5b9f\u88c5\u306b\u4e0d\u53ef\u6b20\u3067\u3059\u3002\u672c\u8a18\u4e8b\u3067\u89e3\u8aac\u3057\u305f\u5b9f\u88c5\u30d1\u30bf\u30fc\u30f3\u3084\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3092\u57fa\u306b\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8981\u4ef6\u306b\u5fdc\u3058\u305f\u6700\u9069\u306a\u5b9f\u88c5\u3092\u76ee\u6307\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p>\u307e\u305f\u3001\u5e38\u306b\u4ee5\u4e0b\u306e\u70b9\u3092\u610f\u8b58\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u826f\u3044\u5b9f\u88c5\u3092\u5b9f\u73fe\u3067\u304d\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u578b\u5b89\u5168\u6027\u306e\u78ba\u4fdd<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u306e\u4e21\u7acb<\/li>\n\n\n\n<li>\u30b3\u30fc\u30c9\u306e\u53ef\u8aad\u6027\u7dad\u6301<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u52b9\u679c\u7684\u306a\u30c6\u30b9\u30c8\u6226\u7565<\/li>\n<\/ul>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u77e5\u8b58\u3068\u5b9f\u8df5\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u5805\u7262\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u304c\u53ef\u80fd\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Warning: Undefined array key &#8220;is_admin&#8221; in \/home\/xs392991\/dexall.co.jp\/public_html\/articles\/wp-content\/themes\/ &#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":{"0":"post-524","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-java","7":"nothumb"},"_links":{"self":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/524","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=524"}],"version-history":[{"count":2,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/524\/revisions"}],"predecessor-version":[{"id":533,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/524\/revisions\/533"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}