{"id":535,"date":"2025-03-24T08:53:00","date_gmt":"2025-03-23T23:53:00","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=535"},"modified":"2025-03-24T08:53:00","modified_gmt":"2025-03-23T23:53:00","slug":"mybatis-plus%e3%81%a7%e5%ae%9f%e7%8f%be%e3%81%99%e3%82%8b%ef%bc%81java%e3%81%aedb%e6%93%8d%e4%bd%9c%e3%82%9210%e5%80%8d%e9%80%9f%e3%81%8f%e3%81%99%e3%82%8b%e5%ae%9f%e8%b7%b5%e3%82%ac%e3%82%a4%e3%83%89","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=535","title":{"rendered":"MyBatis Plus\u3067\u5b9f\u73fe\u3059\u308b\uff01Java\u306eDB\u64cd\u4f5c\u309210\u500d\u901f\u304f\u3059\u308b\u5b9f\u8df5\u30ac\u30a4\u30c92024"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"i-0\">MyBatis Plus\u3068\u306f\uff1f\u521d\u5fc3\u8005\u3067\u3082\u308f\u304b\u308b\u57fa\u790e\u89e3\u8aac<\/h1>\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\">    <a href=\"#i-0\">MyBatis Plus\u3068\u306f\uff1f\u521d\u5fc3\u8005\u3067\u3082\u308f\u304b\u308b\u57fa\u790e\u89e3\u8aac<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">MyBatis Plus\u304c\u89e3\u6c7a\u3059\u308b3\u3064\u306e\u958b\u767a\u8ab2\u984c<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-2\">\u5f93\u6765\u306eMyBatis\u3068\u6bd4\u3079\u3066\u4f55\u304c\u9055\u3046\uff1f<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-5\">\u3010\u74b0\u5883\u69cb\u7bc9\u30115\u5206\u3067\u59cb\u3081\u308bMyBatis Plus\u5c0e\u5165\u624b\u9806<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-6\">\u5fc5\u8981\u306a\u4f9d\u5b58\u95a2\u4fc2\u306e\u8ffd\u52a0\u65b9\u6cd5<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-9\">Spring Boot\u3067\u306e\u57fa\u672c\u8a2d\u5b9a<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-16\">CRUD\u64cd\u4f5c\u3092\u5287\u7684\u306b\u7c21\u7565\u5316\uff01\u57fa\u672c\u6a5f\u80fd\u306e\u4f7f\u3044\u65b9<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-17\">\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u3060\u3051\u3067\u5b9f\u88c5\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u9023\u643a<\/a>      <\/li>      <li>        <a href=\"#i-20\">\u305f\u3063\u305f3\u884c\u3067\u5b9f\u88c5\u3067\u304d\u308bCRUD\u64cd\u4f5c<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-22\">\u30ab\u30b9\u30bf\u30e0SQL\u306e\u66f8\u304d\u65b9\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-26\">\u958b\u767a\u52b9\u7387\u30922\u500d\u306b\u3059\u308b\uff01\u5b9f\u8df5\u7684\u306a\u6d3b\u7528\u30c6\u30af\u30cb\u30c3\u30af<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-27\">\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u6a5f\u80fd\u306e\u5b9f\u88c5\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-30\">\u52d5\u7684SQL\u3092\u4f7f\u3044\u3053\u306a\u3059\u30b3\u30c4<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-33\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u6700\u9069\u5316\u3059\u308b\u305f\u3081\u306e\u30d2\u30f3\u30c8<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-38\">\u73fe\u5834\u3067\u4f7f\u3048\u308b\uff01\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u3068Tips<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-39\">\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u3068\u89e3\u6c7a\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-46\">\u30c7\u30d0\u30c3\u30b0\u306e\u30b3\u30c4\u3068\u52b9\u7387\u7684\u306a\u30ed\u30b0\u8a2d\u5b9a<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-50\">\u672c\u756a\u74b0\u5883\u3067\u306e\u904b\u7528\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-55\">\u307e\u3068\u3081\uff1aMyBatis Plus\u3067\u5b9f\u73fe\u3059\u308b\u52b9\u7387\u7684\u306aDB\u958b\u767a<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-56\">\u672c\u8a18\u4e8b\u306e\u30dd\u30a4\u30f3\u30c8<\/a>      <\/li>      <li>        <a href=\"#i-57\">\u6b21\u306e\u30b9\u30c6\u30c3\u30d7<\/a>      <\/li>      <li>        <a href=\"#i-58\">\u5c0e\u5165\u52b9\u679c\u306e\u6307\u6a19<\/a>      <\/li>      <li>        <a href=\"#i-59\">\u6700\u5f8c\u306b<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-60\">Quick Reference<\/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-1\">MyBatis Plus\u304c\u89e3\u6c7a\u3059\u308b3\u3064\u306e\u958b\u767a\u8ab2\u984c<\/h2>\n\n\n\n<p>MyBatis Plus\u306f\u3001MyBatis\u3092\u62e1\u5f35\u3057\u305f\u5f37\u529b\u306a\u30d1\u30fc\u30b7\u30b9\u30c6\u30f3\u30b9\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3067\u3059\u3002\u4ee5\u4e0b\u306e3\u3064\u306e\u4e3b\u8981\u306a\u958b\u767a\u8ab2\u984c\u3092\u52b9\u679c\u7684\u306b\u89e3\u6c7a\u3057\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30dc\u30a4\u30e9\u30fc\u30d7\u30ec\u30fc\u30c8\u30b3\u30fc\u30c9\u306e\u524a\u6e1b<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5f93\u6765\u306eMyBatis\u3067\u306f\u5fc5\u8981\u3060\u3063\u305f\u57fa\u672c\u7684\u306aCRUD\u64cd\u4f5c\u306eXML\u30de\u30c3\u30d4\u30f3\u30b0\u304c\u4e0d\u8981<\/li>\n\n\n\n<li>\u6a19\u6e96\u7684\u306aSQL\u64cd\u4f5c\u3092\u81ea\u52d5\u751f\u6210<\/li>\n\n\n\n<li>\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e\u7c21\u6f54\u306a\u8a2d\u5b9a<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u958b\u767a\u751f\u7523\u6027\u306e\u5411\u4e0a<\/strong>\n<ul class=\"wp-block-list\">\n<li>AutoMapper\u306b\u3088\u308b\u81ea\u52d5\u30de\u30c3\u30d4\u30f3\u30b0\u6a5f\u80fd<\/li>\n\n\n\n<li>\u30b3\u30fc\u30c9\u751f\u6210\u30c4\u30fc\u30eb\u306e\u63d0\u4f9b<\/li>\n\n\n\n<li>\u8c4a\u5bcc\u306a\u30d7\u30e9\u30b0\u30a4\u30f3\u30a8\u30b3\u30b7\u30b9\u30c6\u30e0<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u4fdd\u5b88\u6027\u3068\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u6539\u5584<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u7d71\u4e00\u3055\u308c\u305f\u64cd\u4f5c\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9<\/li>\n\n\n\n<li>\u30af\u30ea\u30fc\u30f3\u306a\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306e\u4fc3\u9032<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u6a5f\u80fd\u306e\u7d44\u307f\u8fbc\u307f<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-2\">\u5f93\u6765\u306eMyBatis\u3068\u6bd4\u3079\u3066\u4f55\u304c\u9055\u3046\uff1f<\/h2>\n\n\n\n<p><\/p>\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\">\u4ee5\u4e0b\u306e\u8868\u3067\u3001\u4e3b\u8981\u306a\u9055\u3044\u3092\u6bd4\u8f03\u3057\u307e\u3059\uff1a<\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\"><div id=\"id-3341ba27-f5a5-4e71-84e4-89379b3ea4bf\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u6a5f\u80fd<\/th><th>MyBatis<\/th><th>MyBatis Plus<\/th><\/tr><\/thead><tbody><tr><td>CRUD\u64cd\u4f5c<\/td><td>XML\u5b9a\u7fa9\u304c\u5fc5\u8981<\/td><td>\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306e\u307f\u3067\u53ef\u80fd<\/td><\/tr><tr><td>\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3<\/td><td>\u624b\u52d5\u5b9f\u88c5\u304c\u5fc5\u8981<\/td><td>\u7d44\u307f\u8fbc\u307f\u6a5f\u80fd\u3068\u3057\u3066\u63d0\u4f9b<\/td><\/tr><tr><td>\u697d\u89b3\u7684\u30ed\u30c3\u30af<\/td><td>\u72ec\u81ea\u5b9f\u88c5\u304c\u5fc5\u8981<\/td><td>@Version\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u3067\u5bfe\u5fdc<\/td><\/tr><tr><td>\u8ad6\u7406\u524a\u9664<\/td><td>\u72ec\u81ea\u5b9f\u88c5\u304c\u5fc5\u8981<\/td><td>@TableLogic\u3067\u81ea\u52d5\u5bfe\u5fdc<\/td><\/tr><tr><td>\u30b3\u30fc\u30c9\u751f\u6210<\/td><td>\u5916\u90e8\u30c4\u30fc\u30eb\u304c\u5fc5\u8981<\/td><td>\u7d71\u5408\u30c4\u30fc\u30eb\u3068\u3057\u3066\u63d0\u4f9b<\/td><\/tr><tr><td>\u52d5\u7684\u30c6\u30fc\u30d6\u30eb\u540d<\/td><td>\u8907\u96d1\u306a\u8a2d\u5b9a\u304c\u5fc5\u8981<\/td><td>\u7c21\u5358\u306a\u8a2d\u5b9a\u3067\u5bfe\u5fdc\u53ef\u80fd<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-3\">\u5c0e\u5165\u306b\u3088\u308b\u5177\u4f53\u7684\u306a\u30e1\u30ea\u30c3\u30c8<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u958b\u767a\u6642\u9593\u306e\u77ed\u7e2e<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u57fa\u672c\u7684\u306aCRUD\u64cd\u4f5c\u304c\u6570\u884c\u3067\u5b9f\u88c5\u53ef\u80fd<\/li>\n\n\n\n<li>\u30b3\u30fc\u30c9\u751f\u6210\u6a5f\u80fd\u306b\u3088\u308b\u521d\u671f\u30b3\u30fc\u30c9\u306e\u81ea\u52d5\u751f\u6210<\/li>\n\n\n\n<li>\u8c4a\u5bcc\u306a\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\u30e1\u30bd\u30c3\u30c9\u306e\u63d0\u4f9b<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u4fdd\u5b88\u6027\u306e\u5411\u4e0a<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u7d71\u4e00\u3055\u308c\u305f\u64cd\u4f5c\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9<\/li>\n\n\n\n<li>\u6a19\u6e96\u5316\u3055\u308c\u305f\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u30b9\u30bf\u30a4\u30eb<\/li>\n\n\n\n<li>\u5145\u5b9f\u3057\u305f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3068\u30b3\u30df\u30e5\u30cb\u30c6\u30a3\u30b5\u30dd\u30fc\u30c8<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u62e1\u5f35\u6027\u306e\u78ba\u4fdd<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30d7\u30e9\u30b0\u30a4\u30f3\u306b\u3088\u308b\u6a5f\u80fd\u62e1\u5f35<\/li>\n\n\n\n<li>\u30ab\u30b9\u30bf\u30e0\u30a4\u30f3\u30b8\u30a7\u30af\u30bf\u30fc\u306e\u5b9f\u88c5<\/li>\n\n\n\n<li>\u72ec\u81ea\u306e\u6700\u9069\u5316\u6226\u7565\u306e\u9069\u7528<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316<\/strong>\n<ul class=\"wp-block-list\">\n<li>SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u9632\u6b62<\/li>\n\n\n\n<li>N+1\u554f\u984c\u306e\u89e3\u6c7a\u652f\u63f4<\/li>\n\n\n\n<li>\u52b9\u7387\u7684\u306a\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u5b9f\u88c5<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-4\">\u6280\u8853\u7684\u7279\u5fb4<\/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=\"\">\/\/ \u5f93\u6765\u306eMyBatis\u3067\u306eRepository\u5b9f\u88c5\npublic interface UserMapper {\n    @Select(\"SELECT * FROM users WHERE id = #{id}\")\n    User selectById(Long id);\n\n    @Insert(\"INSERT INTO users(name, age) VALUES(#{name}, #{age})\")\n    int insert(User user);\n    \/\/ \u4ed6\u306eCRUD\u64cd\u4f5c\u3082\u540c\u69d8\u306b\u5b9f\u88c5\u304c\u5fc5\u8981\n}\n\n\/\/ MyBatis Plus\u3067\u306e\u5b9f\u88c5\npublic interface UserMapper extends BaseMapper&lt;User&gt; {\n    \/\/ \u57fa\u672c\u7684\u306aCRUD\u64cd\u4f5c\u306f\u81ea\u52d5\u3067\u63d0\u4f9b\u3055\u308c\u308b\n    \/\/ \u30ab\u30b9\u30bf\u30e0\u64cd\u4f5c\u306e\u307f\u3092\u8ffd\u52a0\u5b9a\u7fa9\n}<\/pre>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u3001MyBatis Plus\u306f\u5f93\u6765\u306eMyBatis\u306e\u6a5f\u80fd\u3092\u5b8c\u5168\u306b\u7d99\u627f\u3057\u306a\u304c\u3089\u3001\u3088\u308a\u52b9\u7387\u7684\u3067\u4fdd\u5b88\u6027\u306e\u9ad8\u3044\u958b\u767a\u3092\u53ef\u80fd\u306b\u3057\u307e\u3059\u3002\u7279\u306b\u3001\u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u958b\u767a\u306b\u304a\u3044\u3066\u3001\u305d\u306e\u771f\u4fa1\u3092\u767a\u63ee\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-5\">\u3010\u74b0\u5883\u69cb\u7bc9\u30115\u5206\u3067\u59cb\u3081\u308bMyBatis Plus\u5c0e\u5165\u624b\u9806<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-6\">\u5fc5\u8981\u306a\u4f9d\u5b58\u95a2\u4fc2\u306e\u8ffd\u52a0\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-7\">Maven \u3067\u306e\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=\"\">&lt;!-- pom.xml\u306b\u4ee5\u4e0b\u306e\u4f9d\u5b58\u95a2\u4fc2\u3092\u8ffd\u52a0 --&gt;\n&lt;dependencies&gt;\n    &lt;!-- MyBatis Plus\u672c\u4f53 --&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;com.baomidou&lt;\/groupId&gt;\n        &lt;artifactId&gt;mybatis-plus-boot-starter&lt;\/artifactId&gt;\n        &lt;version&gt;3.5.5&lt;\/version&gt;\n    &lt;\/dependency&gt;\n\n    &lt;!-- \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c9\u30e9\u30a4\u30d0\uff08MySQL\u4f7f\u7528\u6642\u306e\u4f8b\uff09 --&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;mysql&lt;\/groupId&gt;\n        &lt;artifactId&gt;mysql-connector-java&lt;\/artifactId&gt;\n        &lt;version&gt;8.0.33&lt;\/version&gt;\n    &lt;\/dependency&gt;\n\n    &lt;!-- \u30b3\u30fc\u30c9\u751f\u6210\u30c4\u30fc\u30eb\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09 --&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;com.baomidou&lt;\/groupId&gt;\n        &lt;artifactId&gt;mybatis-plus-generator&lt;\/artifactId&gt;\n        &lt;version&gt;3.5.5&lt;\/version&gt;\n    &lt;\/dependency&gt;\n&lt;\/dependencies&gt;<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-8\">Gradle \u3067\u306e\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=\"\">\/\/ build.gradle\u306b\u4ee5\u4e0b\u306e\u4f9d\u5b58\u95a2\u4fc2\u3092\u8ffd\u52a0\ndependencies {\n    implementation 'com.baomidou:mybatis-plus-boot-starter:3.5.5'\n    implementation 'mysql:mysql-connector-java:8.0.33'\n    implementation 'com.baomidou:mybatis-plus-generator:3.5.5'\n}<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-9\">Spring Boot\u3067\u306e\u57fa\u672c\u8a2d\u5b9a<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-10\">1. \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\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.yml\nspring:\n  datasource:\n    url: jdbc:mysql:\/\/localhost:3306\/your_database\n    username: your_username\n    password: your_password\n    driver-class-name: com.mysql.cj.jdbc.Driver\n\nmybatis-plus:\n  configuration:\n    # SQL\u5b9f\u884c\u30ed\u30b0\u306e\u51fa\u529b\uff08\u958b\u767a\u6642\u306e\u307f\u63a8\u5968\uff09\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n    # \u30de\u30c3\u30d7\u30a2\u30f3\u30c0\u30fc\u30b9\u30b3\u30a2\u578b\u306e\u30ab\u30e9\u30e0\u540d\u3092\u30ad\u30e3\u30e1\u30eb\u30b1\u30fc\u30b9\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u30de\u30c3\u30d4\u30f3\u30b0\n    map-underscore-to-camel-case: true\n  global-config:\n    db-config:\n      # \u30d7\u30e9\u30a4\u30de\u30ea\u30fc\u30ad\u30fc\u306e\u81ea\u52d5\u63a1\u756a\u65b9\u5f0f\uff08AUTO\u3001INPUT\u3001ASSIGN_ID\u3001ASSIGN_UUID\uff09\n      id-type: ASSIGN_ID\n      # \u30c6\u30fc\u30d6\u30eb\u306e\u63a5\u982d\u8f9e\u8a2d\u5b9a\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09\n      table-prefix: t_\n      # \u8ad6\u7406\u524a\u9664\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u8a2d\u5b9a\n      logic-delete-field: deleted\n      logic-delete-value: 1\n      logic-not-delete-value: 0<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-11\">2. \u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u30af\u30e9\u30b9\u306e\u4f5c\u6210<\/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=\"\">import com.baomidou.mybatisplus.annotation.*;\nimport lombok.Data;\n\n@Data\n@TableName(\"users\")  \/\/ \u30c6\u30fc\u30d6\u30eb\u540d\u306e\u6307\u5b9a\npublic class User {\n    @TableId(type = IdType.ASSIGN_ID)  \/\/ \u30d7\u30e9\u30a4\u30de\u30ea\u30fc\u30ad\u30fc\u306e\u8a2d\u5b9a\n    private Long id;\n\n    @TableField(\"user_name\")  \/\/ \u30ab\u30e9\u30e0\u540d\u306e\u6307\u5b9a\n    private String userName;\n\n    private Integer age;\n\n    @TableLogic  \/\/ \u8ad6\u7406\u524a\u9664\u30d5\u30a3\u30fc\u30eb\u30c9\n    private Integer deleted;\n\n    @Version  \/\/ \u697d\u89b3\u7684\u30ed\u30c3\u30af\u7528\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u30d5\u30a3\u30fc\u30eb\u30c9\n    private Integer version;\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-12\">3. Mapper\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306e\u4f5c\u6210<\/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=\"\">import com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport org.apache.ibatis.annotations.Mapper;\n\n@Mapper\npublic interface UserMapper extends BaseMapper&lt;User&gt; {\n    \/\/ BaseMapper\u3092\u7d99\u627f\u3059\u308b\u3060\u3051\u3067\u57fa\u672c\u7684\u306aCRUD\u64cd\u4f5c\u304c\u4f7f\u7528\u53ef\u80fd\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-13\">4. \u30b5\u30fc\u30d3\u30b9\u5c64\u306e\u5b9f\u88c5<\/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=\"\">import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport org.springframework.stereotype.Service;\n\n@Service\npublic class UserService extends ServiceImpl&lt;UserMapper, User&gt; {\n    \/\/ ServiceImpl\u3092\u7d99\u627f\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u9ad8\u5ea6\u306a\u64cd\u4f5c\u30e1\u30bd\u30c3\u30c9\u304c\u4f7f\u7528\u53ef\u80fd\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-14\">\u8a2d\u5b9a\u78ba\u8a8d\u306e\u305f\u3081\u306e\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9<\/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=\"\">import org.junit.jupiter.api.Test;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.boot.test.context.SpringBootTest;\n\n@SpringBootTest\npublic class UserServiceTest {\n    @Autowired\n    private UserService userService;\n\n    @Test\n    public void testCrud() {\n        \/\/ \u30e6\u30fc\u30b6\u30fc\u306e\u4f5c\u6210\n        User user = new User();\n        user.setUserName(\"\u30c6\u30b9\u30c8\u30e6\u30fc\u30b6\u30fc\");\n        user.setAge(25);\n        userService.save(user);\n\n        \/\/ \u30e6\u30fc\u30b6\u30fc\u306e\u53d6\u5f97\n        User saved = userService.getById(user.getId());\n        assert saved != null;\n        assert saved.getUserName().equals(\"\u30c6\u30b9\u30c8\u30e6\u30fc\u30b6\u30fc\");\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-15\">\u4e3b\u306a\u8a2d\u5b9a\u30aa\u30d7\u30b7\u30e7\u30f3\u4e00\u89a7<\/h3>\n\n\n<div id=\"id-9802d511-bd1a-42d1-92cd-1e88a6e725fd\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u8a2d\u5b9a\u9805\u76ee<\/th><th>\u8aac\u660e<\/th><th>\u30c7\u30d5\u30a9\u30eb\u30c8\u5024<\/th><\/tr><\/thead><tbody><tr><td>map-underscore-to-camel-case<\/td><td>\u30b9\u30cd\u30fc\u30af\u30b1\u30fc\u30b9\u304b\u3089\u30ad\u30e3\u30e1\u30eb\u30b1\u30fc\u30b9\u3078\u306e\u81ea\u52d5\u5909\u63db<\/td><td>true<\/td><\/tr><tr><td>id-type<\/td><td>\u30d7\u30e9\u30a4\u30de\u30ea\u30fc\u30ad\u30fc\u306e\u751f\u6210\u65b9\u5f0f<\/td><td>ASSIGN_ID<\/td><\/tr><tr><td>table-prefix<\/td><td>\u30c6\u30fc\u30d6\u30eb\u540d\u306e\u63a5\u982d\u8f9e<\/td><td>\u306a\u3057<\/td><\/tr><tr><td>logic-delete-field<\/td><td>\u8ad6\u7406\u524a\u9664\u30d5\u30a3\u30fc\u30eb\u30c9\u540d<\/td><td>\u306a\u3057<\/td><\/tr><tr><td>capital-mode<\/td><td>\u5927\u6587\u5b57\u30c6\u30fc\u30d6\u30eb\u540d\u306e\u4f7f\u7528<\/td><td>false<\/td><\/tr><tr><td>refresh-mapper<\/td><td>XML\u306e\u71b1\u30ea\u30ed\u30fc\u30c9<\/td><td>true<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\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\"><strong>\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u6642\u306e\u6ce8\u610f\u70b9<\/strong><\/div><\/div><div class=\"sng-box-msg__contents\">\n<ol class=\"wp-block-list\">\n<li><strong>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u8a2d\u5b9a<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u63a5\u7d9aURL\u304c\u6b63\u3057\u3044\u3053\u3068\u3092\u78ba\u8a8d<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u6a29\u9650\u3092\u6301\u3064\u30e6\u30fc\u30b6\u30fc\u3092\u4f7f\u7528<\/li>\n\n\n\n<li>\u6587\u5b57\u30b3\u30fc\u30c9\u8a2d\u5b9a\u306e\u78ba\u8a8d<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u30de\u30c3\u30d4\u30f3\u30b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30c6\u30fc\u30d6\u30eb\u540d\u3068\u30af\u30e9\u30b9\u540d\u306e\u5bfe\u5fdc\u95a2\u4fc2\u306e\u78ba\u8a8d<\/li>\n\n\n\n<li>\u30ab\u30e9\u30e0\u540d\u3068\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u306e\u5bfe\u5fdc\u78ba\u8a8d<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306e\u4f7f\u7528<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u958b\u767a\u74b0\u5883\u3067\u306e\u8a2d\u5b9a<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30d0\u30c3\u30b0\u30ed\u30b0\u306e\u6709\u52b9\u5316<\/li>\n\n\n\n<li>HotReload\u306e\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30c6\u30b9\u30c8\u74b0\u5883\u306e\u5206\u96e2<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/div><\/div><\/div>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-16\">CRUD\u64cd\u4f5c\u3092\u5287\u7684\u306b\u7c21\u7565\u5316\uff01\u57fa\u672c\u6a5f\u80fd\u306e\u4f7f\u3044\u65b9<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-17\">\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u3060\u3051\u3067\u5b9f\u88c5\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u9023\u643a<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-18\">\u57fa\u672c\u7684\u306a\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\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=\"\">import com.baomidou.mybatisplus.annotation.*;\nimport lombok.Data;\nimport java.time.LocalDateTime;\n\n@Data\n@TableName(\"t_product\")\npublic class Product {\n    \/\/ ID\u306e\u81ea\u52d5\u751f\u6210\uff08\u96ea\u82b1\u30a2\u30eb\u30b4\u30ea\u30ba\u30e0\uff09\n    @TableId(type = IdType.ASSIGN_ID)\n    private Long id;\n\n    \/\/ \u30ab\u30e9\u30e0\u540d\u304c\u7570\u306a\u308b\u5834\u5408\u306e\u660e\u793a\u7684\u306a\u30de\u30c3\u30d4\u30f3\u30b0\n    @TableField(\"product_name\")\n    private String name;\n\n    private BigDecimal price;\n\n    \/\/ \u7279\u5b9a\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u30ab\u30e9\u30e0\u3068\u3057\u3066\u6271\u308f\u306a\u3044\n    @TableField(exist = false)\n    private String tempField;\n\n    \/\/ \u697d\u89b3\u7684\u30ed\u30c3\u30af\u7528\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u7ba1\u7406\n    @Version\n    private Integer version;\n\n    \/\/ \u8ad6\u7406\u524a\u9664\u30d5\u30e9\u30b0\n    @TableLogic\n    private Integer deleted;\n\n    \/\/ \u81ea\u52d5\u586b\u5145\u6a5f\u80fd\n    @TableField(fill = FieldFill.INSERT)\n    private LocalDateTime createTime;\n\n    @TableField(fill = FieldFill.INSERT_UPDATE)\n    private LocalDateTime updateTime;\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-19\">\u81ea\u52d5\u586b\u5145\u306e\u5b9f\u88c5\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=\"\">@Component\npublic class MyMetaObjectHandler implements MetaObjectHandler {\n    @Override\n    public void insertFill(MetaObject metaObject) {\n        \/\/ \u65b0\u898f\u767b\u9332\u6642\u306e\u81ea\u52d5\u8a2d\u5b9a\n        this.strictInsertFill(metaObject, \"createTime\", LocalDateTime.class, LocalDateTime.now());\n        this.strictInsertFill(metaObject, \"updateTime\", LocalDateTime.class, LocalDateTime.now());\n    }\n\n    @Override\n    public void updateFill(MetaObject metaObject) {\n        \/\/ \u66f4\u65b0\u6642\u306e\u81ea\u52d5\u8a2d\u5b9a\n        this.strictUpdateFill(metaObject, \"updateTime\", LocalDateTime.class, LocalDateTime.now());\n    }\n}<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-20\">\u305f\u3063\u305f3\u884c\u3067\u5b9f\u88c5\u3067\u304d\u308bCRUD\u64cd\u4f5c<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-21\">\u57fa\u672c\u7684\u306aCRUD\u64cd\u4f5c\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=\"\">@Service\n@RequiredArgsConstructor\npublic class ProductService extends ServiceImpl&lt;ProductMapper, Product&gt; {\n\n    \/\/ \u65b0\u898f\u767b\u9332\n    public void createProduct() {\n        Product product = new Product();\n        product.setName(\"\u65b0\u5546\u54c1\");\n        product.setPrice(new BigDecimal(\"1000\"));\n        \/\/ 1\u884c\u3067\u767b\u9332\u5b8c\u4e86\n        save(product);\n    }\n\n    \/\/ \u4e00\u4ef6\u53d6\u5f97\n    public Product getProduct(Long id) {\n        \/\/ 1\u884c\u3067\u53d6\u5f97\u5b8c\u4e86\n        return getById(id);\n    }\n\n    \/\/ \u66f4\u65b0\n    public void updateProduct(Long id) {\n        Product product = getById(id);\n        product.setPrice(new BigDecimal(\"2000\"));\n        \/\/ 1\u884c\u3067\u66f4\u65b0\u5b8c\u4e86\n        updateById(product);\n    }\n\n    \/\/ \u524a\u9664\n    public void deleteProduct(Long id) {\n        \/\/ 1\u884c\u3067\u524a\u9664\u5b8c\u4e86\uff08\u8ad6\u7406\u524a\u9664\u306e\u5834\u5408\u306f\u81ea\u52d5\u7684\u306b\u8ad6\u7406\u524a\u9664\u306b\u306a\u308b\uff09\n        removeById(id);\n    }\n\n    \/\/ \u30d0\u30c3\u30c1\u64cd\u4f5c\n    public void batchOperation() {\n        \/\/ \u30d0\u30c3\u30c1\u767b\u9332\n        List&lt;Product&gt; products = Arrays.asList(\n            new Product().setName(\"\u5546\u54c11\").setPrice(new BigDecimal(\"1000\")),\n            new Product().setName(\"\u5546\u54c12\").setPrice(new BigDecimal(\"2000\"))\n        );\n        saveBatch(products);\n\n        \/\/ \u30d0\u30c3\u30c1\u66f4\u65b0\n        updateBatchById(products);\n\n        \/\/ \u30d0\u30c3\u30c1\u524a\u9664\n        removeBatchByIds(Arrays.asList(1L, 2L, 3L));\n    }\n}<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-22\">\u30ab\u30b9\u30bf\u30e0SQL\u306e\u66f8\u304d\u65b9\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-23\">1. \u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e\u65b9\u6cd5<\/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=\"\">@Mapper\npublic interface ProductMapper extends BaseMapper&lt;Product&gt; {\n    \/\/ SELECT\u6587\u306e\u4f8b\n    @Select(\"SELECT * FROM t_product WHERE price &gt; #{minPrice}\")\n    List&lt;Product&gt; findExpensiveProducts(@Param(\"minPrice\") BigDecimal minPrice);\n\n    \/\/ UPDATE\u6587\u306e\u4f8b\n    @Update(\"UPDATE t_product SET stock = stock - #{quantity} WHERE id = #{productId}\")\n    int decreaseStock(@Param(\"productId\") Long productId, @Param(\"quantity\") Integer quantity);\n\n    \/\/ \u52d5\u7684SQL\u306e\u4f8b\n    @Select(\"\"\"\n        SELECT * FROM t_product \n        WHERE 1=1\n        &lt;if test=\"categoryId != null\"&gt;\n            AND category_id = #{categoryId}\n        &lt;\/if&gt;\n        &lt;if test=\"minPrice != null\"&gt;\n            AND price &gt;= #{minPrice}\n        &lt;\/if&gt;\n        ORDER BY create_time DESC\n    \"\"\")\n    List&lt;Product&gt; findByCriteria(@Param(\"categoryId\") Long categoryId, @Param(\"minPrice\") BigDecimal minPrice);\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-24\">2. Wrapper API\u3092\u4f7f\u7528\u3057\u305f\u52d5\u7684\u30af\u30a8\u30ea<\/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=\"\">@Service\n@RequiredArgsConstructor\npublic class ProductService extends ServiceImpl&lt;ProductMapper, Product&gt; {\n\n    public List&lt;Product&gt; searchProducts(String name, BigDecimal minPrice, BigDecimal maxPrice) {\n        \/\/ QueryWrapper\u3092\u4f7f\u7528\u3057\u305f\u52d5\u7684\u30af\u30a8\u30ea\u69cb\u7bc9\n        QueryWrapper&lt;Product&gt; queryWrapper = new QueryWrapper&lt;Product&gt;()\n            .like(StringUtils.isNotBlank(name), \"product_name\", name)\n            .ge(minPrice != null, \"price\", minPrice)\n            .le(maxPrice != null, \"price\", maxPrice)\n            .orderByDesc(\"create_time\");\n\n        return list(queryWrapper);\n    }\n\n    public List&lt;Product&gt; advancedSearch(ProductSearchDTO searchDTO) {\n        \/\/ LambdaQueryWrapper\u3092\u4f7f\u7528\u3057\u305f\u578b\u5b89\u5168\u306a\u30af\u30a8\u30ea\u69cb\u7bc9\n        LambdaQueryWrapper&lt;Product&gt; wrapper = new LambdaQueryWrapper&lt;Product&gt;()\n            .like(StringUtils.isNotBlank(searchDTO.getName()), Product::getName, searchDTO.getName())\n            .between(\n                searchDTO.getMinPrice() != null &amp;&amp; searchDTO.getMaxPrice() != null,\n                Product::getPrice,\n                searchDTO.getMinPrice(),\n                searchDTO.getMaxPrice()\n            )\n            .in(CollectionUtils.isNotEmpty(searchDTO.getCategoryIds()), \n                Product::getCategoryId,\n                searchDTO.getCategoryIds()\n            );\n\n        return list(wrapper);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-25\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u6027\u80fd\u6700\u9069\u5316\u306e\u30dd\u30a4\u30f3\u30c8<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30d0\u30c3\u30c1\u64cd\u4f5c\u306e\u6d3b\u7528<\/li>\n\n\n\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u306e\u53d6\u5f97<\/li>\n<\/ul>\n<\/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=\"\">\/\/ \u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u4f8b\nList&lt;Product&gt; products = new LambdaQueryWrapper&lt;Product&gt;()\n    .select(Product::getId, Product::getName, Product::getPrice)\n    .list();<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406<\/strong><\/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=\"\">@Transactional(rollbackFor = Exception.class)\npublic void complexOperation() {\n    \/\/ \u5546\u54c1\u306e\u767b\u9332\n    Product product = new Product();\n    product.setName(\"\u65b0\u5546\u54c1\");\n    save(product);\n\n    \/\/ \u5728\u5eab\u306e\u767b\u9332\n    Stock stock = new Stock();\n    stock.setProductId(product.getId());\n    stockMapper.insert(stock);\n\n    \/\/ \u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u5834\u5408\u306f\u5168\u3066\u81ea\u52d5\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\n}<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u697d\u89b3\u7684\u30ed\u30c3\u30af\u306e\u6d3b\u7528<\/strong><\/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=\"\">@Transactional\npublic boolean updateStock(Long productId, Integer quantity) {\n    Product product = getById(productId);\n    product.setStock(product.getStock() - quantity);\n    \/\/ \u30d0\u30fc\u30b8\u30e7\u30f3\u30c1\u30a7\u30c3\u30af\u304c\u81ea\u52d5\u7684\u306b\u884c\u308f\u308c\u308b\n    return updateById(product);\n}<\/pre>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><strong>\u30ab\u30b9\u30bf\u30e0SQL\u3068Wrapper API\u306e\u4f7f\u3044\u5206\u3051<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5358\u7d14\u306a\u6761\u4ef6\u691c\u7d22 \u2192 Wrapper API<\/li>\n\n\n\n<li>\u8907\u96d1\u306aJOIN\u3001\u96c6\u8a08 \u2192 \u30ab\u30b9\u30bf\u30e0SQL<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u91cd\u8981\u306a\u5834\u5408 \u2192 \u30ab\u30b9\u30bf\u30e0SQL<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-26\">\u958b\u767a\u52b9\u7387\u30922\u500d\u306b\u3059\u308b\uff01\u5b9f\u8df5\u7684\u306a\u6d3b\u7528\u30c6\u30af\u30cb\u30c3\u30af<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-27\">\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u6a5f\u80fd\u306e\u5b9f\u88c5\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-28\">\u57fa\u672c\u7684\u306a\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\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=\"\">@Service\n@RequiredArgsConstructor\npublic class ProductService extends ServiceImpl&lt;ProductMapper, Product&gt; {\n\n    public IPage&lt;Product&gt; getProductPage(Integer pageNum, Integer pageSize) {\n        \/\/ \u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u4f5c\u6210\n        Page&lt;Product&gt; page = new Page&lt;&gt;(pageNum, pageSize);\n\n        \/\/ \u30bd\u30fc\u30c8\u6761\u4ef6\u306e\u8ffd\u52a0\n        page.addOrder(OrderItem.desc(\"create_time\"));\n\n        \/\/ \u30da\u30fc\u30b8\u30f3\u30b0\u691c\u7d22\u306e\u5b9f\u884c\n        return page(page);\n    }\n\n    \/\/ \u691c\u7d22\u6761\u4ef6\u4ed8\u304d\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\n    public IPage&lt;Product&gt; searchProductPage(ProductSearchDTO searchDTO) {\n        Page&lt;Product&gt; page = new Page&lt;&gt;(searchDTO.getPageNum(), searchDTO.getPageSize());\n\n        LambdaQueryWrapper&lt;Product&gt; wrapper = new LambdaQueryWrapper&lt;Product&gt;()\n            .like(StringUtils.isNotBlank(searchDTO.getName()), \n                  Product::getName, searchDTO.getName())\n            .ge(searchDTO.getMinPrice() != null, \n                Product::getPrice, searchDTO.getMinPrice())\n            .orderByDesc(Product::getCreateTime);\n\n        return page(page, wrapper);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-29\">\u30ab\u30b9\u30bf\u30e0\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\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=\"\">@Mapper\npublic interface ProductMapper extends BaseMapper&lt;Product&gt; {\n    \/\/ \u8907\u96d1\u306aJOIN\u3092\u542b\u3080\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\n    @Select(\"\"\"\n        SELECT p.*, c.category_name, s.stock_quantity \n        FROM t_product p \n        LEFT JOIN t_category c ON p.category_id = c.id \n        LEFT JOIN t_stock s ON p.id = s.product_id \n        WHERE p.deleted = 0 \n        ${ew.customSqlSegment}\n    \"\"\")\n    IPage&lt;ProductDTO&gt; getProductWithDetails(Page&lt;ProductDTO&gt; page, \n                                          @Param(\"ew\") QueryWrapper&lt;Product&gt; wrapper);\n}\n\n\/\/ \u30b5\u30fc\u30d3\u30b9\u5c64\u3067\u306e\u4f7f\u7528\n@Service\npublic class ProductService extends ServiceImpl&lt;ProductMapper, Product&gt; {\n    public IPage&lt;ProductDTO&gt; getProductDetailsPage(ProductSearchDTO searchDTO) {\n        Page&lt;ProductDTO&gt; page = new Page&lt;&gt;(searchDTO.getPageNum(), searchDTO.getPageSize());\n\n        QueryWrapper&lt;Product&gt; wrapper = new QueryWrapper&lt;Product&gt;()\n            .like(StringUtils.isNotBlank(searchDTO.getName()), \"p.product_name\", searchDTO.getName())\n            .ge(searchDTO.getMinPrice() != null, \"p.price\", searchDTO.getMinPrice())\n            .orderByDesc(\"p.create_time\");\n\n        return baseMapper.getProductWithDetails(page, wrapper);\n    }\n}<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-30\">\u52d5\u7684SQL\u3092\u4f7f\u3044\u3053\u306a\u3059\u30b3\u30c4<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-31\">1. \u6761\u4ef6\u69cb\u7bc9\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=\"\">public class QueryHelper {\n    public static &lt;T&gt; LambdaQueryWrapper&lt;T&gt; buildWrapper(Consumer&lt;LambdaQueryWrapper&lt;T&gt;&gt; consumer) {\n        LambdaQueryWrapper&lt;T&gt; wrapper = new LambdaQueryWrapper&lt;&gt;();\n        consumer.accept(wrapper);\n        return wrapper;\n    }\n}\n\n\/\/ \u4f7f\u7528\u4f8b\n@Service\npublic class ProductService extends ServiceImpl&lt;ProductMapper, Product&gt; {\n    public List&lt;Product&gt; searchProducts(ProductSearchDTO searchDTO) {\n        return list(QueryHelper.buildWrapper(w -&gt; {\n            \/\/ \u691c\u7d22\u6761\u4ef6\u3092\u95a2\u6570\u578b\u3067\u69cb\u7bc9\n            Optional.ofNullable(searchDTO.getName())\n                .ifPresent(name -&gt; w.like(Product::getName, name));\n\n            Optional.ofNullable(searchDTO.getCategoryId())\n                .ifPresent(categoryId -&gt; w.eq(Product::getCategoryId, categoryId));\n\n            Optional.ofNullable(searchDTO.getStatus())\n                .ifPresent(status -&gt; w.eq(Product::getStatus, status));\n        }));\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-32\">2. \u8907\u96d1\u306a\u691c\u7d22\u6761\u4ef6\u306e\u5b9f\u88c5<\/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=\"\">@Service\npublic class ProductService extends ServiceImpl&lt;ProductMapper, Product&gt; {\n    \/\/ \u30cd\u30b9\u30c8\u3055\u308c\u305f\u6761\u4ef6\u306e\u4f8b\n    public List&lt;Product&gt; advancedSearch(ProductSearchDTO searchDTO) {\n        return list(new LambdaQueryWrapper&lt;Product&gt;()\n            .nested(w -&gt; \n                w.like(Product::getName, searchDTO.getName())\n                 .or()\n                 .like(Product::getDescription, searchDTO.getKeyword())\n            )\n            .and(w -&gt;\n                w.ge(Product::getPrice, searchDTO.getMinPrice())\n                 .le(Product::getPrice, searchDTO.getMaxPrice())\n            )\n            .orderByDesc(Product::getCreateTime));\n    }\n\n    \/\/ OR\u6761\u4ef6\u306e\u7d44\u307f\u5408\u308f\u305b\n    public List&lt;Product&gt; searchByMultipleCategories(List&lt;Long&gt; categoryIds, \n                                                  List&lt;String&gt; tags) {\n        return list(new LambdaQueryWrapper&lt;Product&gt;()\n            .and(w -&gt; \n                w.in(Product::getCategoryId, categoryIds)\n                 .or()\n                 .in(Product::getTags, tags)\n            )\n            .orderByDesc(Product::getCreateTime));\n    }\n}<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-33\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u6700\u9069\u5316\u3059\u308b\u305f\u3081\u306e\u30d2\u30f3\u30c8<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-34\">1. \u30d0\u30c3\u30c1\u51e6\u7406\u306e\u6700\u9069\u5316<\/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=\"\">@Service\n@Transactional(rollbackFor = Exception.class)\npublic class BatchService {\n    private static final int BATCH_SIZE = 1000;\n\n    @Autowired\n    private ProductService productService;\n\n    public void batchInsert(List&lt;Product&gt; products) {\n        \/\/ \u30ea\u30b9\u30c8\u3092\u9069\u5207\u306a\u30b5\u30a4\u30ba\u306b\u5206\u5272\u3057\u3066\u51e6\u7406\n        Lists.partition(products, BATCH_SIZE).forEach(batch -&gt; {\n            productService.saveBatch(batch, BATCH_SIZE);\n        });\n    }\n\n    \/\/ \u30d0\u30c3\u30c1\u66f4\u65b0\u306e\u6700\u9069\u5316\n    public void batchUpdate(List&lt;Product&gt; products) {\n        Lists.partition(products, BATCH_SIZE).forEach(batch -&gt; {\n            productService.updateBatchById(batch, BATCH_SIZE);\n        });\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-35\">2. \u30af\u30a8\u30ea\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316<\/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=\"\">@Service\npublic class ProductService extends ServiceImpl&lt;ProductMapper, Product&gt; {\n    \/\/ \u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u53d6\u5f97\n    public List&lt;ProductSimpleDTO&gt; getProductList() {\n        return list(new LambdaQueryWrapper&lt;Product&gt;()\n            .select(Product::getId, Product::getName, Product::getPrice)\n            .orderByDesc(Product::getCreateTime));\n    }\n\n    \/\/ EXISTS\u53e5\u306e\u6d3b\u7528\n    public boolean hasAvailableProducts(Long categoryId) {\n        return exists(new LambdaQueryWrapper&lt;Product&gt;()\n            .eq(Product::getCategoryId, categoryId)\n            .eq(Product::getStatus, ProductStatus.AVAILABLE));\n    }\n\n    \/\/ COUNT\u6700\u9069\u5316\n    public long countAvailableProducts() {\n        return count(new LambdaQueryWrapper&lt;Product&gt;()\n            .select(Product::getId) \/\/ ID\u306e\u307f\u3092\u30ab\u30a6\u30f3\u30c8\n            .eq(Product::getStatus, ProductStatus.AVAILABLE));\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-36\">3. \u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565<\/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=\"\">@Service\n@CacheConfig(cacheNames = \"product\")\npublic class ProductService extends ServiceImpl&lt;ProductMapper, Product&gt; {\n\n    @Cacheable(key = \"#id\")\n    @Override\n    public Product getById(Serializable id) {\n        return super.getById(id);\n    }\n\n    @CacheEvict(key = \"#id\")\n    @Override\n    public boolean removeById(Serializable id) {\n        return super.removeById(id);\n    }\n\n    @CachePut(key = \"#product.id\")\n    @Override\n    public boolean updateById(Product product) {\n        return super.updateById(product);\n    }\n\n    \/\/ \u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u4f7f\u7528\u3057\u305f\u9ad8\u901f\u306a\u5b58\u5728\u30c1\u30a7\u30c3\u30af\n    @Cacheable(key = \"'exists:' + #id\")\n    public boolean existsById(Long id) {\n        return exists(new LambdaQueryWrapper&lt;Product&gt;()\n            .eq(Product::getId, id));\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-37\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6226\u7565<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u691c\u7d22\u6761\u4ef6\u306b\u3088\u304f\u4f7f\u7528\u3055\u308c\u308b\u30ab\u30e9\u30e0\u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f5c\u6210<\/li>\n\n\n\n<li>\u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u9069\u5207\u306a\u8a2d\u8a08<\/li>\n\n\n\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u52b9\u679c\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306eEXPLAIN\u5206\u6790<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u6700\u9069\u5316<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u306e\u9069\u5207\u306a\u4f7f\u7528<\/li>\n\n\n\n<li>\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306e\u30b9\u30c8\u30ea\u30fc\u30e0\u6d3b\u7528<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u306e\u8a2d\u5b9a<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u8981\u306a\u30ab\u30e9\u30e0\u306e\u307f\u3092\u9078\u629e<\/li>\n\n\n\n<li>JOIN\u306e\u6700\u5c0f\u5316<\/li>\n\n\n\n<li>\u30b5\u30d6\u30af\u30a8\u30ea\u306e\u9069\u5207\u306a\u4f7f\u7528<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-38\">\u73fe\u5834\u3067\u4f7f\u3048\u308b\uff01\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u3068Tips<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-39\">\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u3068\u89e3\u6c7a\u65b9\u6cd5<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-40\">1. \u30de\u30c3\u30d4\u30f3\u30b0\u95a2\u9023\u306e\u30a8\u30e9\u30fc<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-41\">\u554f\u984c1: Unknown Column Error<\/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=\"\">org.apache.ibatis.exceptions.PersistenceException: Error attempting to get column 'user_name' from result set. \nCause: java.sql.SQLSyntaxErrorException: Unknown column 'user_name' in 'field list'<\/pre>\n\n\n\n<p class=\"is-style-sango-paragraph-idea-alt\"><strong>\u89e3\u6c7a\u7b56<\/strong>:<\/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=\"\">\/\/ \u6b63\u3057\u3044\u30de\u30c3\u30d4\u30f3\u30b0\u8a2d\u5b9a\n@TableName(\"t_user\")\npublic class User {\n    \/\/ \u30ab\u30e9\u30e0\u540d\u304c\u7570\u306a\u308b\u5834\u5408\u306f\u660e\u793a\u7684\u306b\u30de\u30c3\u30d4\u30f3\u30b0\n    @TableField(\"user_name\")\n    private String userName;\n\n    \/\/ \u30ad\u30e3\u30e1\u30eb\u30b1\u30fc\u30b9\u2192\u30b9\u30cd\u30fc\u30af\u30b1\u30fc\u30b9\u306e\u81ea\u52d5\u5909\u63db\u3092\u7121\u52b9\u5316\u3059\u308b\u5834\u5408\n    @TableField(value = \"user_name\", strategy = FieldStrategy.NOT_NULL)\n    private String userName;\n}<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-42\">\u554f\u984c2: Type Handling Error<\/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=\"\">org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null<\/pre>\n\n\n\n<p class=\"is-style-sango-paragraph-idea-alt\"><strong>\u89e3\u6c7a\u7b56<\/strong>:<\/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=\"\">\/\/ \u30ab\u30b9\u30bf\u30e0\u30bf\u30a4\u30d7\u30cf\u30f3\u30c9\u30e9\u30fc\u306e\u5b9f\u88c5\n@MappedTypes(YourEnum.class)\npublic class YourEnumTypeHandler extends BaseTypeHandler&lt;YourEnum&gt; {\n    @Override\n    public void setNonNullParameter(PreparedStatement ps, int i, YourEnum parameter, JdbcType jdbcType) \n            throws SQLException {\n        ps.setString(i, parameter.getCode());\n    }\n\n    @Override\n    public YourEnum getNullableResult(ResultSet rs, String columnName) throws SQLException {\n        return YourEnum.fromCode(rs.getString(columnName));\n    }\n    \/\/ \u4ed6\u306e\u30e1\u30bd\u30c3\u30c9\u3082\u5b9f\u88c5\n}\n\n\/\/ application.yml\u3067\u306e\u8a2d\u5b9a\nmybatis-plus:\n  type-handlers-package: com.your.package.handlers<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-43\">2. \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u95a2\u9023\u306e\u554f\u984c<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-44\">\u554f\u984c1: N+1\u554f\u984c<\/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=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\n@Service\npublic class OrderService extends ServiceImpl&lt;OrderMapper, Order&gt; {\n    @Autowired\n    private UserService userService;\n\n    public List&lt;OrderDTO&gt; getOrders() {\n        \/\/ N+1\u554f\u984c\u3092\u5f15\u304d\u8d77\u3053\u3059\u5b9f\u88c5\n        return list().stream()\n            .map(order -&gt; {\n                OrderDTO dto = new OrderDTO();\n                \/\/ \u5404\u30aa\u30fc\u30c0\u30fc\u306b\u5bfe\u3057\u3066\u500b\u5225\u306b\u30e6\u30fc\u30b6\u30fc\u60c5\u5831\u3092\u53d6\u5f97\n                User user = userService.getById(order.getUserId()); \/\/ N\u56de\u306e\u30af\u30a8\u30ea\u767a\u751f\n                dto.setUserName(user.getName());\n                return dto;\n            })\n            .collect(Collectors.toList());\n    }\n}\n\n\/\/ \u6700\u9069\u5316\u3055\u308c\u305f\u5b9f\u88c5\n@Mapper\npublic interface OrderMapper extends BaseMapper&lt;Order&gt; {\n    @Select(\"\"\"\n        SELECT o.*, u.name as user_name \n        FROM t_order o \n        LEFT JOIN t_user u ON o.user_id = u.id\n    \"\"\")\n    List&lt;OrderDTO&gt; getOrdersWithUser();\n}<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"i-45\">\u554f\u984c2: \u30e1\u30e2\u30ea\u4e0d\u8db3<\/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=\"\">\/\/ \u554f\u984c\u306e\u3042\u308b\u30b3\u30fc\u30c9\npublic void processLargeData() {\n    \/\/ \u5168\u30c7\u30fc\u30bf\u3092\u4e00\u5ea6\u306b\u30e1\u30e2\u30ea\u306b\u8aad\u307f\u8fbc\u3080\n    List&lt;Product&gt; products = list(); \/\/ \u30e1\u30e2\u30ea\u4e0d\u8db3\u306e\u53ef\u80fd\u6027\n\n    products.forEach(this::processProduct);\n}\n\n\/\/ \u6700\u9069\u5316\u3055\u308c\u305f\u5b9f\u88c5\npublic void processLargeData() {\n    \/\/ \u30da\u30fc\u30b8\u30f3\u30b0\u51e6\u7406\u306b\u3088\u308b\u6700\u9069\u5316\n    long count = count();\n    int pageSize = 1000;\n    int pages = (int) Math.ceil(count \/ (double) pageSize);\n\n    for (int i = 1; i &lt;= pages; i++) {\n        Page&lt;Product&gt; page = new Page&lt;&gt;(i, pageSize);\n        page(page).getRecords().forEach(this::processProduct);\n    }\n}<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-46\">\u30c7\u30d0\u30c3\u30b0\u306e\u30b3\u30c4\u3068\u52b9\u7387\u7684\u306a\u30ed\u30b0\u8a2d\u5b9a<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-47\">1. SQL\u30ed\u30b0\u306e\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.yml\nmybatis-plus:\n  configuration:\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n\nlogging:\n  level:\n    com.baomidou.mybatisplus: debug\n    com.your.mapper.package: debug<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-48\">2. \u30ab\u30b9\u30bf\u30e0\u30a4\u30f3\u30bf\u30fc\u30bb\u30d7\u30bf\u30fc\u306b\u3088\u308bSQL\u76e3\u8996<\/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=\"\">@Intercepts({\n    @Signature(type = Executor.class, method = \"update\", args = {MappedStatement.class, Object.class}),\n    @Signature(type = Executor.class, method = \"query\", args = {MappedStatement.class, Object.class, \n              RowBounds.class, ResultHandler.class})\n})\n@Component\npublic class SqlMonitorInterceptor implements Interceptor {\n    private static final Logger log = LoggerFactory.getLogger(SqlMonitorInterceptor.class);\n\n    @Override\n    public Object intercept(Invocation invocation) throws Throwable {\n        long startTime = System.currentTimeMillis();\n        try {\n            return invocation.proceed();\n        } finally {\n            long endTime = System.currentTimeMillis();\n            long sqlCost = endTime - startTime;\n\n            MappedStatement statement = (MappedStatement) invocation.getArgs()[0];\n            String sqlId = statement.getId();\n            log.info(\"SQL\u5b9f\u884c\u6642\u9593 - ID: {}, \u30b3\u30b9\u30c8: {}ms\", sqlId, sqlCost);\n\n            if (sqlCost &gt; 1000) {\n                log.warn(\"\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u691c\u51fa - ID: {}, \u30b3\u30b9\u30c8: {}ms\", sqlId, sqlCost);\n            }\n        }\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-49\">3. \u30c7\u30d0\u30c3\u30b0\u30e2\u30fc\u30c9\u3067\u306e\u958b\u767a\u52b9\u7387\u5316<\/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=\"\">@Slf4j\n@Service\npublic class DebugService {\n    \/\/ \u30c7\u30d0\u30c3\u30b0\u7528\u306e\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\u30e1\u30bd\u30c3\u30c9\n    public void debugQuery(LambdaQueryWrapper&lt;Product&gt; wrapper) {\n        String sql = SqlUtils.showSql(wrapper);\n        log.debug(\"\u751f\u6210\u3055\u308c\u305fSQL: {}\", sql);\n\n        \/\/ \u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u51fa\u529b\n        Map&lt;String, Object&gt; params = wrapper.getParamNameValuePairs();\n        log.debug(\"\u30d1\u30e9\u30e1\u30fc\u30bf: {}\", params);\n    }\n}<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-50\">\u672c\u756a\u74b0\u5883\u3067\u306e\u904b\u7528\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-51\">1. \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/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=\"\">@Aspect\n@Component\n@Slf4j\npublic class PerformanceMonitorAspect {\n\n    @Around(\"execution(* com.your.package.mapper.*Mapper.*(..))\")\n    public Object monitorMapperMethods(ProceedingJoinPoint joinPoint) throws Throwable {\n        String methodName = joinPoint.getSignature().getName();\n        long startTime = System.currentTimeMillis();\n\n        try {\n            return joinPoint.proceed();\n        } finally {\n            long executionTime = System.currentTimeMillis() - startTime;\n            if (executionTime &gt; 500) {\n                log.warn(\"\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u691c\u51fa: {} - \u5b9f\u884c\u6642\u9593: {}ms\", methodName, executionTime);\n                \/\/ \u30e1\u30c8\u30ea\u30af\u30b9\u53ce\u96c6\u30b7\u30b9\u30c6\u30e0\u3078\u306e\u8a18\u9332\n                MetricsCollector.recordSlowQuery(methodName, executionTime);\n            }\n        }\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-52\">2. \u672c\u756a\u74b0\u5883\u3067\u306e\u8a2d\u5b9a\u6700\u9069\u5316<\/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-prod.yml\nmybatis-plus:\n  configuration:\n    # \u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u6709\u52b9\u5316\n    cache-enabled: true\n    # \u30ed\u30b0\u51fa\u529b\u3092\u5fc5\u8981\u6700\u5c0f\u9650\u306b\n    log-impl: org.apache.ibatis.logging.nologging.NoLoggingImpl\n  global-config:\n    db-config:\n      # \u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u306e\u6700\u9069\u5316\n      batch-size: 1000\n      # ID\u30bf\u30a4\u30d7\u306e\u8a2d\u5b9a\n      id-type: assign_id\n      # \u8ad6\u7406\u524a\u9664\u306e\u8a2d\u5b9a\n      logic-delete-field: deleted\n      logic-delete-value: 1\n      logic-not-delete-value: 0\n    # \u30d0\u30ca\u30fc\uff08\u8d77\u52d5\u6642\u306e\u30ed\u30b4\u8868\u793a\uff09\u3092\u7121\u52b9\u5316\n    banner: false<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-53\">3. \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u5bfe\u7b56<\/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=\"\">\/\/ SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56\n@Service\npublic class SecureService {\n    \/\/ \u5b89\u5168\u306aLike\u691c\u7d22\u306e\u5b9f\u88c5\n    public List&lt;Product&gt; searchProducts(String keyword) {\n        \/\/ \u30ad\u30fc\u30ef\u30fc\u30c9\u306e\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406\n        String escapedKeyword = SqlUtils.escapeSQL(keyword);\n\n        return list(new LambdaQueryWrapper&lt;Product&gt;()\n            .like(Product::getName, escapedKeyword));\n    }\n\n    \/\/ \u6a29\u9650\u30c1\u30a7\u30c3\u30af\u306e\u5b9f\u88c5\n    @PreAuthorize(\"hasRole('ADMIN')\")\n    public void deleteProduct(Long id) {\n        removeById(id);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-54\">\u904b\u7528\u4e0a\u306e\u91cd\u8981\u306a\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u306e\u76e3\u8996<\/li>\n\n\n\n<li>\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u30d7\u30fc\u30eb\u306e\u6700\u9069\u5316<\/li>\n\n\n\n<li>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u76e3\u8996<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u5bfe\u7b56<\/strong>\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>\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30bb\u30f3\u30b7\u30c6\u30a3\u30d6\u30c7\u30fc\u30bf\u306e\u6697\u53f7\u5316<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u5fa9\u65e7<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5b9a\u671f\u7684\u306a\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/li>\n\n\n\n<li>\u30ea\u30b9\u30c8\u30a2\u624b\u9806\u306e\u78ba\u8a8d<\/li>\n\n\n\n<li>\u969c\u5bb3\u6642\u306e\u5207\u308a\u623b\u3057\u8a08\u753b<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u8a08\u753b<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u518d\u69cb\u7bc9<\/li>\n\n\n\n<li>\u7d71\u8a08\u60c5\u5831\u306e\u66f4\u65b0<\/li>\n\n\n\n<li>\u30ed\u30b0\u30ed\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-55\">\u307e\u3068\u3081\uff1aMyBatis Plus\u3067\u5b9f\u73fe\u3059\u308b\u52b9\u7387\u7684\u306aDB\u958b\u767a<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-56\">\u672c\u8a18\u4e8b\u306e\u30dd\u30a4\u30f3\u30c8<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>MyBatis Plus\u306e\u4e3b\u8981\u306a\u5229\u70b9<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30dc\u30a4\u30e9\u30fc\u30d7\u30ec\u30fc\u30c8\u30b3\u30fc\u30c9\u306e\u5927\u5e45\u306a\u524a\u6e1b<\/li>\n\n\n\n<li>\u958b\u767a\u751f\u7523\u6027\u306e\u5411\u4e0a<\/li>\n\n\n\n<li>\u4fdd\u5b88\u6027\u3068\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u6539\u5584<\/li>\n\n\n\n<li>\u8c4a\u5bcc\u306a\u6a5f\u80fd\u3068\u62e1\u5f35\u6027<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u5b9f\u88c5\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e\u7c21\u6f54\u306a\u5b9f\u88c5<\/li>\n\n\n\n<li>Wrapper API\u3092\u6d3b\u7528\u3057\u305f\u52d5\u7684\u30af\u30a8\u30ea<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u51e6\u7406<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u8003\u616e\u3057\u305f\u5b9f\u88c5<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u904b\u7528\u6642\u306e\u91cd\u8981\u30dd\u30a4\u30f3\u30c8<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u52b9\u679c\u7684\u306a\u30ed\u30b0\u8a2d\u5b9a\u3068\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565<\/li>\n\n\n\n<li>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u5bfe\u7b56\u306e\u5b9f\u65bd<\/li>\n\n\n\n<li>\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u624b\u6cd5\u306e\u78ba\u7acb<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-57\">\u6b21\u306e\u30b9\u30c6\u30c3\u30d7<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30b9\u30ad\u30eb\u30a2\u30c3\u30d7\u306e\u65b9\u5411\u6027<\/strong><\/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=\"\">   \/\/ \u4ee5\u4e0b\u306e\u9806\u5e8f\u3067\u306e\u5b66\u7fd2\u3092\u63a8\u5968\n   Step 1: \u57fa\u672c\u7684\u306aCRUD\u64cd\u4f5c\u306e\u7fd2\u5f97\n   Step 2: \u52d5\u7684\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u30fc\u306e\u6d3b\u7528\n   Step 3: \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u624b\u6cd5\u306e\u5b9f\u8df5\n   Step 4: \u9ad8\u5ea6\u306a\u6a5f\u80fd\uff08\u30d7\u30e9\u30b0\u30a4\u30f3\u958b\u767a\u306a\u3069\uff09\u306e\u7fd2\u5f97<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u5b9f\u8df5\u7684\u306a\u6d3b\u7528\u30b7\u30fc\u30f3<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u3067\u306e\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5c64\u5b9f\u88c5<\/li>\n\n\n\n<li>\u30ec\u30ac\u30b7\u30fc\u30b7\u30b9\u30c6\u30e0\u306e\u30ea\u30d5\u30a1\u30af\u30bf\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u51e6\u7406\u30b7\u30b9\u30c6\u30e0\u306e\u958b\u767a<\/li>\n\n\n\n<li>API\u958b\u767a\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306e\u6d3b\u7528<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u53c2\u8003\u30ea\u30bd\u30fc\u30b9<\/strong>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/baomidou.com\/\">MyBatis Plus\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/baomidou\/mybatis-plus\">GitHub Repository<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/baomidou\/mybatis-plus-samples\">Sample Projects<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-58\">\u5c0e\u5165\u52b9\u679c\u306e\u6307\u6a19<\/h2>\n\n\n<div id=\"id-606a0786-d6b5-45c9-8a4b-54aca8bafa3d\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u9805\u76ee<\/th><th>\u5f93\u6765\u306e\u5b9f\u88c5<\/th><th>MyBatis Plus\u4f7f\u7528\u6642<\/th><\/tr><\/thead><tbody><tr><td>CRUD\u5b9f\u88c5\u6642\u9593<\/td><td>2-3\u6642\u9593<\/td><td>30\u5206\u4ee5\u5185<\/td><\/tr><tr><td>\u30b3\u30fc\u30c9\u884c\u6570<\/td><td>100-200\u884c<\/td><td>20-30\u884c<\/td><\/tr><tr><td>\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u30b3\u30b9\u30c8<\/td><td>\u9ad8<\/td><td>\u4f4e<\/td><\/tr><tr><td>\u5b66\u7fd2\u30b3\u30b9\u30c8<\/td><td>\u4e2d<\/td><td>\u4f4e-\u4e2d<\/td><\/tr><tr><td>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9<\/td><td>\u6a19\u6e96<\/td><td>\u6700\u9069\u5316\u6e08\u307f<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"i-59\">\u6700\u5f8c\u306b<\/h2>\n\n\n\n<p>MyBatis Plus\u306f\u3001Java\u958b\u767a\u8005\u306b\u3068\u3063\u3066\u5f37\u529b\u306a\u6b66\u5668\u3068\u306a\u308a\u307e\u3059\u3002\u672c\u8a18\u4e8b\u3067\u89e3\u8aac\u3057\u305f\u5185\u5bb9\u3092\u5b9f\u8df5\u3059\u308b\u3053\u3068\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u52b9\u679c\u304c\u671f\u5f85\u3067\u304d\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u958b\u767a\u6642\u9593\u306e50%\u4ee5\u4e0a\u524a\u6e1b<\/li>\n\n\n\n<li>\u30b3\u30fc\u30c9\u306e\u4fdd\u5b88\u6027\u5411\u4e0a<\/li>\n\n\n\n<li>\u30c1\u30fc\u30e0\u5168\u4f53\u306e\u751f\u7523\u6027\u5411\u4e0a<\/li>\n\n\n\n<li>\u9ad8\u54c1\u8cea\u306a\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5c64\u306e\u5b9f\u73fe<\/li>\n<\/ul>\n\n\n\n<p>\u7279\u306b\u91cd\u8981\u306a\u306e\u306f\u3001\u5358\u306a\u308b\u6a5f\u80fd\u306e\u4f7f\u7528\u3060\u3051\u3067\u306a\u304f\u3001\u9069\u5207\u306a\u8a2d\u8a08\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u306e\u9069\u7528\u3067\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u9577\u671f\u7684\u306a\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u6027\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u4e21\u7acb\u304c\u53ef\u80fd\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u5f8c\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u3067\u3055\u3089\u306a\u308b\u6a5f\u80fd\u8ffd\u52a0\u304c\u671f\u5f85\u3055\u308c\u308b\u4e2d\u3001\u57fa\u672c\u7684\u306a\u6982\u5ff5\u3068\u8a2d\u8a08\u601d\u60f3\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001\u65b0\u6a5f\u80fd\u3082\u30b9\u30e0\u30fc\u30ba\u306b\u6d3b\u7528\u3067\u304d\u308b\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-60\">Quick Reference<\/h2>\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=\"\">\/\/ \u57fa\u672c\u5b9f\u88c5\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\n@Service\npublic class YourService extends ServiceImpl&lt;YourMapper, YourEntity&gt; {\n    \/\/ \u57fa\u672c\u7684\u306aCRUD\u64cd\u4f5c\n    public void basicOperations() {\n        \/\/ \u4fdd\u5b58\n        save(entity);\n\n        \/\/ \u691c\u7d22\n        getById(id);\n\n        \/\/ \u66f4\u65b0\n        updateById(entity);\n\n        \/\/ \u524a\u9664\n        removeById(id);\n    }\n\n    \/\/ \u5fdc\u7528\u64cd\u4f5c\n    public void advancedOperations() {\n        \/\/ \u6761\u4ef6\u691c\u7d22\n        list(new LambdaQueryWrapper&lt;YourEntity&gt;()\n            .eq(YourEntity::getField, value));\n\n        \/\/ \u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\n        page(new Page&lt;&gt;(1, 10));\n    }\n}<\/pre>\n\n\n\n<p>\u3053\u306e\u30b3\u30fc\u30c9\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u8d77\u70b9\u306b\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8981\u4ef6\u306b\u5fdc\u3058\u3066\u6a5f\u80fd\u3092\u62e1\u5f35\u3057\u3066\u3044\u304f\u3053\u3068\u3067\u3001\u52b9\u7387\u7684\u306a\u958b\u767a\u304c\u53ef\u80fd\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>MyBatis Plus\u306e\u5c0e\u5165\u306f\u3001\u30e2\u30c0\u30f3\u306aJava\u958b\u767a\u306b\u304a\u3051\u308b\u91cd\u8981\u306a\u4e00\u6b69\u3068\u306a\u308b\u3067\u3057\u3087\u3046\u3002\u672c\u8a18\u4e8b\u306e\u5185\u5bb9\u3092\u53c2\u8003\u306b\u3001\u305c\u3072\u5b9f\u8df5\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MyBatis Plus\u3068\u306f\uff1f\u521d\u5fc3\u8005\u3067\u3082\u308f\u304b\u308b\u57fa\u790e\u89e3\u8aac Warning: Undefined array key &#8220;is_admin&#8221; in \/home\/xs392991\/dexall.co.jp\/public_html &#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-535","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\/535","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=535"}],"version-history":[{"count":2,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/535\/revisions"}],"predecessor-version":[{"id":856,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/535\/revisions\/856"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}