{"id":290,"date":"2025-03-24T08:54:54","date_gmt":"2025-03-23T23:54:54","guid":{"rendered":"https:\/\/dexall.co.jp\/articles\/?p=290"},"modified":"2025-03-24T08:54:54","modified_gmt":"2025-03-23T23:54:54","slug":"%e3%80%902024%e5%b9%b4%e6%9c%80%e6%96%b0%e3%80%91spring-framework-jdbc%e3%83%9e%e3%82%b9%e3%82%bf%e3%83%bc%e3%82%ac%e3%82%a4%e3%83%89%ef%bc%9a%e5%8a%b9%e7%8e%87%e7%9a%84%e3%81%aa%e3%83%87%e3%83%bc","status":"publish","type":"post","link":"https:\/\/dexall.co.jp\/articles\/?p=290","title":{"rendered":"\u30102024\u5e74\u6700\u65b0\u3011Spring Framework JDBC\u30de\u30b9\u30bf\u30fc\u30ac\u30a4\u30c9\uff1a\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e7\u3064\u306e\u79d8\u8a23"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"i-0\">1. Spring Framework JDBC\u306e\u57fa\u790e\uff1a\u306a\u305c\u4eca\u3082\u91cd\u8981\u306a\u306e\u304b<\/h1>\n\n\n\n<p>Spring Framework JDBC\u306f\u3001Java Database Connectivity (JDBC) API\u3092\u62bd\u8c61\u5316\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u3092\u5927\u5e45\u306b\u7c21\u7d20\u5316\u3059\u308bSpring Framework\u306e\u91cd\u8981\u306a\u30e2\u30b8\u30e5\u30fc\u30eb\u3067\u3059\u30022024\u5e74\u306e\u73fe\u5728\u3067\u3082\u3001\u3053\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u304cJava\u958b\u767a\u8005\u306b\u3068\u3063\u3066\u91cd\u8981\u306a\u7406\u7531\u3092\u63a2\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/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\">Spring Framework JDBC\u306e\u4e3b\u306a\u7279\u5fb4<\/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><strong>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u306e\u7c21\u7d20\u5316<\/strong>: \u63a5\u7d9a\u7ba1\u7406\u3092\u81ea\u52d5\u5316\u3057\u3001\u958b\u767a\u8005\u306e\u8ca0\u62c5\u3092\u8efd\u6e1b<\/li>\n\n\n\n<li><strong>\u4f8b\u5916\u51e6\u7406\u306e\u6539\u5584<\/strong>: \u30c1\u30a7\u30c3\u30af\u4f8b\u5916\u3092\u5b9f\u884c\u6642\u4f8b\u5916\u306b\u5909\u63db\u3057\u3001\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u3092\u5bb9\u6613\u306b<\/li>\n\n\n\n<li><strong>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u7c21\u6613\u5316<\/strong>: \u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e\u5ba3\u8a00\u7684\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u3092\u63d0\u4f9b<\/li>\n\n\n\n<li><strong>JDBC\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u63d0\u4f9b<\/strong>: \u5197\u9577\u306aJDBC\u30b3\u30fc\u30c9\u3092\u524a\u6e1b\u3057\u3001\u30af\u30ea\u30fc\u30f3\u3067\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u3092\u5b9f\u73fe<\/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\">\u306a\u305cSpring Framework JDBC\u306f\u4eca\u3082\u91cd\u8981\u306a\u306e\u304b<\/div><\/div><div class=\"sng-box-msg__contents\">\n<ol class=\"wp-block-list\">\n<li><strong>\u30b3\u30fc\u30c9\u91cf\u306e\u524a\u6e1b<\/strong>: JDBC\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306b\u3088\u308a\u3001\u7d0460%\u306e\u30b3\u30fc\u30c9\u91cf\u524a\u6e1b\u304c\u53ef\u80fd<\/li>\n\n\n\n<li><strong>\u30a8\u30e9\u30fc\u51e6\u7406\u306e\u6539\u5584<\/strong>: SQLException\u306e\u9069\u5207\u306a\u51e6\u7406\u306b\u3088\u308a\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u5805\u7262\u6027\u304c\u5411\u4e0a<\/li>\n\n\n\n<li><strong>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316<\/strong>: \u63a5\u7d9a\u30d7\u30fc\u30eb\u3084\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u6700\u9069\u5316\u6a5f\u80fd\u3092\u63d0\u4f9b<\/li>\n\n\n\n<li><strong>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u5411\u4e0a<\/strong>: SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56\u306a\u3069\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u6a5f\u80fd\u3092\u6a19\u6e96\u88c5\u5099<\/li>\n<\/ol>\n<\/div><\/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\">    <a href=\"#i-0\">1. Spring Framework JDBC\u306e\u57fa\u790e\uff1a\u306a\u305c\u4eca\u3082\u91cd\u8981\u306a\u306e\u304b<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">\u73fe\u4ee3\u306e\u958b\u767a\u306b\u304a\u3051\u308bSpring Framework JDBC\u306e\u5f79\u5272<\/a>      <\/li>      <li>        <a href=\"#i-2\">1.1 JDBC\u3068Spring Framework\u306e\u95a2\u4fc2\u6027<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-5\">1.2 Spring JDBC\u306e\u5229\u70b9\u3068\u4f7f\u7528\u30b7\u30fc\u30f3<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-9\">2. JdbcTemplate\u30af\u30e9\u30b9\uff1aSpring JDBC\u306e\u4e2d\u6838\u6280\u8853<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-10\">JdbcTemplate\u306e\u4e3b\u8981\u6a5f\u80fd\u3068\u7279\u5fb4<\/a>      <\/li>      <li>        <a href=\"#i-11\">JdbcTemplate\u3092\u4f7f\u7528\u3059\u308b\u5229\u70b9<\/a>      <\/li>      <li>        <a href=\"#i-12\">JdbcTemplate\u306e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/a>      <\/li>      <li>        <a href=\"#i-13\">Spring JDBC\u306b\u304a\u3051\u308bJdbcTemplate\u306e\u4f4d\u7f6e\u3065\u3051<\/a>      <\/li>      <li>        <a href=\"#i-14\">2.1 JdbcTemplate\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-21\">2.2 \u30af\u30a8\u30ea\u5b9f\u884c\u3068\u30c7\u30fc\u30bf\u53d6\u5f97\u306e\u52b9\u7387\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-28\">3. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2460\uff1a\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u6700\u9069\u5316<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-29\">\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u91cd\u8981\u6027<\/a>      <\/li>      <li>        <a href=\"#i-30\">Spring Boot\u306e\u30c7\u30d5\u30a9\u30eb\u30c8HikariCP\u8a2d\u5b9a<\/a>      <\/li>      <li>        <a href=\"#i-31\">\u63a5\u7d9a\u30d7\u30fc\u30eb\u6700\u9069\u5316\u306e\u5fc5\u8981\u6027<\/a>      <\/li>      <li>        <a href=\"#i-32\">\u6700\u9069\u5316\u306e\u4e00\u822c\u7684\u30a2\u30d7\u30ed\u30fc\u30c1<\/a>      <\/li>      <li>        <a href=\"#i-33\">HikariCP\u306e\u7279\u5fb4\u3068\u5229\u70b9<\/a>      <\/li>      <li>        <a href=\"#i-34\">3.1 HikariCP\u3092\u4f7f\u7528\u3057\u305f\u9ad8\u901f\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u8a2d\u5b9a<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-37\">3.2 \u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-41\">4. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2461\uff1a\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u6d3b\u7528<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-42\">\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u91cd\u8981\u6027<\/a>      <\/li>      <li>        <a href=\"#i-43\">Spring JDBC\u306b\u304a\u3051\u308b\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u5229\u70b9<\/a>      <\/li>      <li>        <a href=\"#i-44\">\u52b9\u679c\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-45\">\u57fa\u672c\u7684\u306a\u5b9f\u88c5\u65b9\u6cd5<\/a>      <\/li>      <li>        <a href=\"#i-46\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u8981\u56e0<\/a>      <\/li>      <li>        <a href=\"#i-47\">\u6ce8\u610f\u70b9\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-48\">4.1 BatchPreparedStatementSetter\u306e\u4f7f\u7528\u65b9\u6cd5<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-52\">4.2 \u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306e\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u6700\u9069\u5316<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-57\">5. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2462\uff1a\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u6700\u9069\u5316<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-58\">\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u91cd\u8981\u6027<\/a>      <\/li>      <li>        <a href=\"#i-59\">Spring Framework\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u7279\u5fb4<\/a>      <\/li>      <li>        <a href=\"#i-60\">\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u6700\u9069\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-61\">\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u8996\u899a\u5316<\/a>      <\/li>      <li>        <a href=\"#i-62\">5.1 @Transactional\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306e\u6b63\u3057\u3044\u4f7f\u3044\u65b9<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-66\">5.2 \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5206\u96e2\u30ec\u30d9\u30eb\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-70\">6. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2463\uff1aSQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-71\">SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u306e\u5371\u967a\u6027<\/a>      <\/li>      <li>        <a href=\"#i-72\">Spring JDBC\u306b\u304a\u3051\u308b\u5bfe\u7b56<\/a>      <\/li>      <li>        <a href=\"#i-73\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-74\">\u5b89\u5168\u306a\u30af\u30a8\u30ea\u4f5c\u6210\u4f8b<\/a>      <\/li>      <li>        <a href=\"#i-75\">6.1 PreparedStatement\u306e\u6d3b\u7528\u3068\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u306e\u4f7f\u7528<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-79\">6.2 Spring JDBC\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u6a5f\u80fd\u306e\u6d3b\u7528<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-84\">7. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2464\uff1a\u30af\u30a8\u30ea\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-85\">Spring JDBC\u306b\u304a\u3051\u308b\u4e3b\u8981\u306a\u30af\u30a8\u30ea\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/a>      <\/li>      <li>        <a href=\"#i-86\">\u30af\u30a8\u30ea\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u8981\u56e0<\/a>      <\/li>      <li>        <a href=\"#i-87\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-88\">\u30af\u30a8\u30ea\u6700\u9069\u5316\u306e\u4f8b<\/a>      <\/li>      <li>        <a href=\"#i-89\">\u30af\u30a8\u30ea\u6700\u9069\u5316\u306e\u8996\u8991\u5316<\/a>      <\/li>      <li>        <a href=\"#i-90\">7.1 \u5b9f\u884c\u8a08\u753b\u306e\u5206\u6790\u3068\u7d22\u5f15\u306e\u9069\u5207\u306a\u4f7f\u7528<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-95\">7.2 \u30cd\u30a4\u30c6\u30a3\u30d6SQL\u3068JPQL\u306e\u4f7f\u3044\u5206\u3051<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-99\">8. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2465\uff1a\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u5c0e\u5165<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-100\">\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u91cd\u8981\u6027<\/a>      <\/li>      <li>        <a href=\"#i-101\">Spring Framework\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u6a5f\u80fd<\/a>      <\/li>      <li>        <a href=\"#i-102\">\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u5c0e\u5165\u6642\u306e\u8003\u616e\u70b9<\/a>      <\/li>      <li>        <a href=\"#i-103\">\u4e00\u822c\u7684\u306a\u8ab2\u984c\u3068\u89e3\u6c7a\u7b56<\/a>      <\/li>      <li>        <a href=\"#i-104\">\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u8996\u899a\u5316<\/a>      <\/li>      <li>        <a href=\"#i-105\">8.1 Spring Cache\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u30ad\u30e3\u30c3\u30b7\u30f3\u30b0<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-109\">8.2 \u30ad\u30e3\u30c3\u30b7\u30e5\u7121\u52b9\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-112\">9. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2466\uff1a\u30c6\u30b9\u30c8\u99c6\u52d5\u958b\u767a\uff08TDD\uff09\u306e\u5b9f\u8df5<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-113\">TDD\u306e\u91cd\u8981\u6027<\/a>      <\/li>      <li>        <a href=\"#i-114\">TDD\u306e\u57fa\u672c\u30d7\u30ed\u30bb\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-115\">Spring Framework\u3067\u306eTDD\u30a2\u30d7\u30ed\u30fc\u30c1<\/a>      <\/li>      <li>        <a href=\"#i-116\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306b\u304a\u3051\u308bTDD\u306e\u5229\u70b9<\/a>      <\/li>      <li>        <a href=\"#i-117\">TDD\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/a>      <\/li>      <li>        <a href=\"#i-118\">9.1 Spring Test DBUnit\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30b9\u30c8<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-122\">9.2 \u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6d3b\u7528\u3057\u305f\u5358\u4f53\u30c6\u30b9\u30c8\u6226\u7565<\/a>      <\/li>    <\/ul>  <\/li>  <li class=\"last\">    <a href=\"#i-126\">10. Spring JDBC\u306e\u672a\u6765\uff1a\u6700\u65b0\u306e\u30c8\u30ec\u30f3\u30c9\u3068\u767a\u5c55\u306e\u65b9\u5411\u6027<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-127\">\u73fe\u72b6\u3068\u6700\u65b0\u30c8\u30ec\u30f3\u30c9<\/a>      <\/li>      <li>        <a href=\"#i-128\">\u767a\u5c55\u306e\u65b9\u5411\u6027<\/a>      <\/li>      <li>        <a href=\"#i-129\">\u9577\u671f\u7684\u306a\u5b58\u5728\u610f\u7fa9\u3068\u5f79\u5272<\/a>      <\/li>      <li>        <a href=\"#i-130\">10.1 Spring Data JDBC\u3068\u306e\u6bd4\u8f03\u3068\u4f7f\u3044\u5206\u3051<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-133\">10.2 \u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306b\u304a\u3051\u308bSpring JDBC\u306e\u5f79\u5272<\/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\">\u73fe\u4ee3\u306e\u958b\u767a\u306b\u304a\u3051\u308bSpring Framework JDBC\u306e\u5f79\u5272<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u30ec\u30ac\u30b7\u30fc\u30b7\u30b9\u30c6\u30e0\u3068\u306e\u7d71\u5408<\/strong>: \u65e2\u5b58\u306eJDBC\u30d9\u30fc\u30b9\u306e\u30b7\u30b9\u30c6\u30e0\u3068\u306e\u4e92\u63db\u6027\u3092\u7dad\u6301<\/li>\n\n\n\n<li><strong>\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3<\/strong>: \u8efd\u91cf\u3067\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5c64\u3092\u63d0\u4f9b<\/li>\n\n\n\n<li><strong>\u9ad8\u5ea6\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c<\/strong>: \u8907\u96d1\u306a\u30af\u30a8\u30ea\u3084\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u306b\u3082\u5bfe\u5fdc<\/li>\n<\/ul>\n\n\n\n<p>Spring Framework JDBC\u306f\u3001\u305d\u306e\u67d4\u8edf\u6027\u3068\u5f37\u529b\u306a\u6a5f\u80fd\u30bb\u30c3\u30c8\u306b\u3088\u308a\u3001\u73fe\u4ee3\u306eJava\u958b\u767a\u306b\u304a\u3044\u3066\u4f9d\u7136\u3068\u3057\u3066\u91cd\u8981\u306a\u5f79\u5272\u3092\u679c\u305f\u3057\u3066\u3044\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001JDBC\u3068Spring Framework\u306e\u95a2\u4fc2\u6027\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-2\">1.1 JDBC\u3068Spring Framework\u306e\u95a2\u4fc2\u6027<\/h2>\n\n\n\n<p>JDBC\u3068Spring Framework\u306e\u95a2\u4fc2\u6027\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u306f\u3001\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u3092\u884c\u3046\u4e0a\u3067\u975e\u5e38\u306b\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-3\">JDBC\u3068\u306f<\/h3>\n\n\n\n<p>JDBC\uff08Java Database Connectivity\uff09\u306f\u3001Java\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304b\u3089\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u305f\u3081\u306e\u6a19\u6e96API\u3067\u3059\u3002\u3057\u304b\u3057\u3001JDBC\u306f\u4f4e\u30ec\u30d9\u30eb\u306aAPI\u3067\u3042\u308b\u305f\u3081\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8ab2\u984c\u304c\u3042\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5197\u9577\u306a\u30b3\u30fc\u30c9\u304c\u5fc5\u8981<\/li>\n\n\n\n<li>\u4f8b\u5916\u51e6\u7406\u304c\u8907\u96d1<\/li>\n\n\n\n<li>\u63a5\u7d9a\u7ba1\u7406\u304c\u958b\u767a\u8005\u306e\u8cac\u4efb<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-4\">Spring Framework\u306b\u3088\u308bJDBC\u306e\u62e1\u5f35<\/h3>\n\n\n\n<p>Spring Framework\u306fJDBC\u3092\u62bd\u8c61\u5316\u3057\u3001\u3053\u308c\u3089\u306e\u8ab2\u984c\u3092\u89e3\u6c7a\u3057\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>JdbcTemplate<\/strong>: \u30dc\u30a4\u30e9\u30fc\u30d7\u30ec\u30fc\u30c8\u30b3\u30fc\u30c9\u3092\u524a\u6e1b<\/li>\n\n\n\n<li><strong>\u7d71\u4e00\u3055\u308c\u305f\u4f8b\u5916\u968e\u5c64<\/strong>: \u4f8b\u5916\u51e6\u7406\u3092\u7c21\u7d20\u5316<\/li>\n\n\n\n<li><strong>\u5ba3\u8a00\u7684\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406<\/strong>: <code>@Transactional<\/code>\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u3067\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u5bb9\u6613\u306b\u7ba1\u7406<\/li>\n\n\n\n<li><strong>\u63a5\u7d9a\u30d7\u30fc\u30eb<\/strong>: \u52b9\u7387\u7684\u306a\u63a5\u7d9a\u7ba1\u7406\u3092\u81ea\u52d5\u5316<\/li>\n<\/ol>\n\n\n\n<p>\u4ee5\u4e0b\u306e\u56f3\u306f\u3001JDBC\u3068Spring JDBC\u306e\u95a2\u4fc2\u6027\u3092\u793a\u3057\u3066\u3044\u307e\u3059\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=\"\">graph TD\n    A[Java Application] --&gt; B[Spring JDBC]\n    B --&gt; C[JDBC API]\n    C --&gt; D[Database]\n    style B fill:#f9f,stroke:#333,stroke-width:4px<\/pre>\n\n\n\n<p>Spring JDBC\u306f\u3001\u958b\u767a\u8005\u3068JDBC API\u306e\u9593\u306b\u4f4d\u7f6e\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u3092\u5927\u5e45\u306b\u7c21\u7d20\u5316\u3057\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001Spring JDBC\u306e\u5177\u4f53\u7684\u306a\u5229\u70b9\u3068\u4f7f\u7528\u30b7\u30fc\u30f3\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-5\">1.2 Spring JDBC\u306e\u5229\u70b9\u3068\u4f7f\u7528\u30b7\u30fc\u30f3<\/h2>\n\n\n\n<p>Spring JDBC\u306f\u3001\u5f93\u6765\u306eJDBC\u306b\u6bd4\u3079\u3066\u591a\u304f\u306e\u5229\u70b9\u3092\u63d0\u4f9b\u3057\u3001\u69d8\u3005\u306a\u5834\u9762\u3067\u6d3b\u7528\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-6\">\u4e3b\u306a\u5229\u70b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30b3\u30fc\u30c9\u91cf\u306e\u524a\u6e1b<\/strong>: JDBC\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306b\u3088\u308a\u3001\u7d0460-70%\u306e\u30b3\u30fc\u30c9\u91cf\u524a\u6e1b\u304c\u53ef\u80fd\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>\u4f8b\u5916\u51e6\u7406\u306e\u7c21\u7d20\u5316<\/strong>: \u30c1\u30a7\u30c3\u30af\u4f8b\u5916\u304c\u5b9f\u884c\u6642\u4f8b\u5916\u306b\u5909\u63db\u3055\u308c\u3001try-catch\u30d6\u30ed\u30c3\u30af\u304c\u6e1b\u5c11\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u6539\u5584<\/strong>: <code>@Transactional<\/code>\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306b\u3088\u308b\u5ba3\u8a00\u7684\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u304c\u53ef\u80fd\u3067\u3059\u3002<\/li>\n\n\n\n<li><strong>\u63a5\u7d9a\u7ba1\u7406\u306e\u81ea\u52d5\u5316<\/strong>: \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u901a\u3058\u305f\u52b9\u7387\u7684\u306a\u63a5\u7d9a\u30d7\u30fc\u30eb\u7ba1\u7406\u304c\u5b9f\u73fe\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-7\">\u4f7f\u7528\u30b7\u30fc\u30f3<\/h3>\n\n\n\n<p>Spring JDBC\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u5834\u9762\u3067\u7279\u306b\u52b9\u679c\u3092\u767a\u63ee\u3057\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30a8\u30f3\u30bf\u30fc\u30d7\u30e9\u30a4\u30ba\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5c64<\/li>\n\n\n\n<li>\u30ec\u30ac\u30b7\u30fc\u30b7\u30b9\u30c6\u30e0\u306e\u8fd1\u4ee3\u5316\u30d7\u30ed\u30b8\u30a7\u30af\u30c8<\/li>\n\n\n\n<li>\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306b\u304a\u3051\u308b\u30c7\u30fc\u30bf\u30b5\u30fc\u30d3\u30b9<\/li>\n\n\n\n<li>\u30d0\u30c3\u30c1\u51e6\u7406\u3084\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u5fc5\u8981\u3068\u3059\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-8\">\u6210\u529f\u4e8b\u4f8b<\/h3>\n\n\n<div id=\"id-ea87e4e0-88d9-45a9-a951-2122258b5e11\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u696d\u754c<\/th><th>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8<\/th><th>\u7d50\u679c<\/th><\/tr><\/thead><tbody><tr><td>\u91d1\u878d<\/td><td>\u30ec\u30ac\u30b7\u30fc\u30d0\u30f3\u30ad\u30f3\u30b0\u30b7\u30b9\u30c6\u30e0\u5237\u65b0<\/td><td>DB\u51e6\u7406\u6027\u80fd30%\u5411\u4e0a\u3001\u958b\u767a\u671f\u959320%\u77ed\u7e2e<\/td><\/tr><tr><td>E\u30b3\u30de\u30fc\u30b9<\/td><td>\u6ce8\u6587\u51e6\u7406\u30b7\u30b9\u30c6\u30e0\u6700\u9069\u5316<\/td><td>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406\u901f\u5ea650%\u5411\u4e0a\u3001\u5b89\u5b9a\u6027\u6539\u5584<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<p>\u3053\u308c\u3089\u306e\u5229\u70b9\u306b\u3088\u308a\u3001Spring JDBC\u306f\u591a\u304f\u306e\u4f01\u696d\u3067\u63a1\u7528\u3055\u308c\u3001\u30b7\u30b9\u30c6\u30e0\u306e\u52b9\u7387\u5316\u3068\u958b\u767a\u751f\u7523\u6027\u306e\u5411\u4e0a\u306b\u8ca2\u732e\u3057\u3066\u3044\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001Spring JDBC\u306e\u4e2d\u6838\u6280\u8853\u3067\u3042\u308bJdbcTemplate\u30af\u30e9\u30b9\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-9\">2. JdbcTemplate\u30af\u30e9\u30b9\uff1aSpring JDBC\u306e\u4e2d\u6838\u6280\u8853<\/h1>\n\n\n\n<p>JdbcTemplate\u30af\u30e9\u30b9\u306f\u3001Spring JDBC\u306e\u4e2d\u6838\u3068\u306a\u308b\u6280\u8853\u3067\u3042\u308a\u3001JDBC\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u3092\u5927\u5e45\u306b\u7c21\u7d20\u5316\u3057\u307e\u3059\u3002\u3053\u306e\u30af\u30e9\u30b9\u306f\u3001\u958b\u767a\u8005\u304c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u3092\u52b9\u7387\u7684\u304b\u3064\u5b89\u5168\u306b\u884c\u3046\u305f\u3081\u306e\u5f37\u529b\u306a\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-10\">JdbcTemplate\u306e\u4e3b\u8981\u6a5f\u80fd\u3068\u7279\u5fb4<\/h2>\n\n\n\n<p>JdbcTemplate\u306f\u4ee5\u4e0b\u306e\u4e3b\u8981\u306a\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u306e\u5b9f\u884c<\/li>\n\n\n\n<li>\u66f4\u65b0\u64cd\u4f5c\u306e\u5b9f\u884c<\/li>\n\n\n\n<li>\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u547c\u3073\u51fa\u3057<\/li>\n\n\n\n<li>\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u51e6\u7406<\/li>\n\n\n\n<li>\u4f8b\u5916\u306e\u5909\u63db<\/li>\n<\/ol>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u6a5f\u80fd\u306f\u3001\u4ee5\u4e0b\u306e\u7279\u5fb4\u306b\u3088\u3063\u3066\u652f\u3048\u3089\u308c\u3066\u3044\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u30b9\u30ec\u30c3\u30c9\u30bb\u30fc\u30d5<\/strong>: \u8907\u6570\u306e\u30b9\u30ec\u30c3\u30c9\u304b\u3089\u5b89\u5168\u306b\u4f7f\u7528\u53ef\u80fd<\/li>\n\n\n\n<li><strong>\u518d\u5229\u7528\u53ef\u80fd<\/strong>: \u4e00\u5ea6\u521d\u671f\u5316\u3059\u308c\u3070\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u5168\u4f53\u3067\u518d\u5229\u7528\u53ef\u80fd<\/li>\n\n\n\n<li><strong>\u8a2d\u5b9a\u304c\u7c21\u5358<\/strong>: \u6700\u5c0f\u9650\u306e\u8a2d\u5b9a\u3067\u4f7f\u7528\u958b\u59cb\u53ef\u80fd<\/li>\n\n\n\n<li><strong>\u30b3\u30fc\u30eb\u30d0\u30c3\u30af\u30d9\u30fc\u30b9\u306eAPI<\/strong>: \u67d4\u8edf\u306a\u30c7\u30fc\u30bf\u51e6\u7406\u304c\u53ef\u80fd<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-11\">JdbcTemplate\u3092\u4f7f\u7528\u3059\u308b\u5229\u70b9<\/h2>\n\n\n\n<p>JdbcTemplate\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u5229\u70b9\u304c\u5f97\u3089\u308c\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>: \u7e70\u308a\u8fd4\u3057\u884c\u308f\u308c\u308bJDBC\u64cd\u4f5c\u3092\u81ea\u52d5\u5316<\/li>\n\n\n\n<li><strong>\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u306e\u7c21\u7d20\u5316<\/strong>: SQLException\u3092\u5b9f\u884c\u6642\u4f8b\u5916\u306b\u5909\u63db<\/li>\n\n\n\n<li><strong>\u30ea\u30bd\u30fc\u30b9\u7ba1\u7406\u306e\u81ea\u52d5\u5316<\/strong>: \u63a5\u7d9a\u3001\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3001\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u81ea\u52d5\u30af\u30ed\u30fc\u30ba<\/li>\n\n\n\n<li><strong>\u578b\u5b89\u5168\u306a\u30af\u30a8\u30ea\u5b9f\u884c<\/strong>: \u30d1\u30e9\u30e1\u30fc\u30bf\u5316\u3055\u308c\u305f\u30af\u30a8\u30ea\u306e\u5b89\u5168\u306a\u5b9f\u884c<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-12\">JdbcTemplate\u306e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/h2>\n\n\n\n<p>\u4ee5\u4e0b\u306f\u3001JdbcTemplate\u3092\u4f7f\u7528\u3057\u3066\u7c21\u5358\u306a\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u4f8b\u3067\u3059\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=\"\">JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);\nint count = jdbcTemplate.queryForObject(\"SELECT COUNT(*) FROM users\", Integer.class);<\/pre>\n\n\n\n<p>\u3053\u306e\u4f8b\u3067\u306f\u3001\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u4f7f\u7528\u3057\u3066JdbcTemplate\u3092\u521d\u671f\u5316\u3057\u3001users\u30c6\u30fc\u30d6\u30eb\u306e\u7dcf\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-13\">Spring JDBC\u306b\u304a\u3051\u308bJdbcTemplate\u306e\u4f4d\u7f6e\u3065\u3051<\/h2>\n\n\n\n<p>JdbcTemplate\u306f\u3001Spring JDBC\u306e\u30d5\u30a1\u30b5\u30fc\u30c9\u3068\u3057\u3066\u6a5f\u80fd\u3057\u3001\u4ed6\u306e\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\uff08NamedParameterJdbcTemplate\u3001SimpleJdbcInsert\u306a\u3069\uff09\u306e\u57fa\u76e4\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u56f3\u306f\u3001JdbcTemplate\u306e\u4f4d\u7f6e\u3065\u3051\u3092\u793a\u3057\u3066\u3044\u307e\u3059\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=\"\">graph TD\n    A[Spring Application] --&gt; B[JdbcTemplate]\n    B --&gt; C[NamedParameterJdbcTemplate]\n    B --&gt; D[SimpleJdbcInsert]\n    B --&gt; E[SimpleJdbcCall]\n    B --&gt; F[JDBC API]\n    F --&gt; G[Database]<\/pre>\n\n\n\n<p>\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001JdbcTemplate\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u65b9\u6cd5\u3084\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u65b9\u6cd5\u306a\u3069\u3001\u5b9f\u8df5\u7684\u306a\u4f8b\u3092\u4ea4\u3048\u3066\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-14\">2.1 JdbcTemplate\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9<\/h2>\n\n\n\n<p>JdbcTemplate\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u306e\u57fa\u672c\u7684\u306a\u30b9\u30c6\u30c3\u30d7\u3068\u3001\u4e3b\u8981\u306a\u64cd\u4f5c\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-15\">\u521d\u671f\u5316<\/h3>\n\n\n\n<p>JdbcTemplate\u306f\u3001DataSource\u3092\u4f7f\u7528\u3057\u3066\u521d\u671f\u5316\u3057\u307e\u3059\u3002<\/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=\"\">JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-16\">\u57fa\u672c\u7684\u306aCRUD\u64cd\u4f5c<\/h3>\n\n\n\n<p>JdbcTemplate\u3092\u4f7f\u7528\u3057\u305f\u57fa\u672c\u7684\u306aCRUD\u64cd\u4f5c\u306e\u4f8b\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Create (\u633f\u5165)<\/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=\"\">jdbcTemplate.update(\"INSERT INTO users (name, email) VALUES (?, ?)\", \"John Doe\", \"john@example.com\");<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Read (\u8aad\u307f\u53d6\u308a)<\/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=\"\">User user = jdbcTemplate.queryForObject(\n    \"SELECT * FROM users WHERE id = ?\", \n    new Object[]{id}, \n    new UserRowMapper()\n);<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Update (\u66f4\u65b0)<\/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=\"\">jdbcTemplate.update(\"UPDATE users SET name = ? WHERE id = ?\", \"Jane Doe\", 1);<\/pre>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Delete (\u524a\u9664)<\/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=\"\">jdbcTemplate.update(\"DELETE FROM users WHERE id = ?\", 1);<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-17\">\u30d1\u30e9\u30e1\u30fc\u30bf\u5316\u3055\u308c\u305f\u30af\u30a8\u30ea<\/h3>\n\n\n\n<p>SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u9632\u6b62\u306e\u305f\u3081\u3001\u30d7\u30ec\u30fc\u30b9\u30db\u30eb\u30c0\uff08?\uff09\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/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=\"\">String sql = \"SELECT * FROM users WHERE name = ? AND age &gt; ?\";\nList&lt;User&gt; users = jdbcTemplate.query(sql, new Object[]{\"John\", 25}, new UserRowMapper());<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-18\">\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u51e6\u7406<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5358\u4e00\u306e\u5024\u306e\u53d6\u5f97<\/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=\"\">int count = jdbcTemplate.queryForObject(\"SELECT COUNT(*) FROM users\", Integer.class);<\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u8907\u6570\u306e\u884c\u306e\u53d6\u5f97<\/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=\"\">List&lt;User&gt; users = jdbcTemplate.query(\"SELECT * FROM users\", new UserRowMapper());<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-19\">\u4f8b\u5916\u51e6\u7406<\/h3>\n\n\n\n<p>Spring JDBC\u306f\u3001SQLException\u3092DataAccessException\u306b\u5909\u63db\u3057\u307e\u3059\u3002<\/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=\"\">try {\n    \/\/ JdbcTemplate operations\n} catch (DataAccessException e) {\n    \/\/ Handle exception\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-20\">Best Practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5e38\u306b\u30d1\u30e9\u30e1\u30fc\u30bf\u5316\u3055\u308c\u305f\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30c7\u30fc\u30bf\u578b\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5834\u5408\u306f\u30d0\u30c3\u30c1\u51e6\u7406\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u3092\u9069\u5207\u306b\u884c\u3046<\/li>\n<\/ul>\n\n\n\n<p>\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u57fa\u672c\u7684\u306a\u64cd\u4f5c\u3092\u30d9\u30fc\u30b9\u306b\u3001\u3088\u308a\u52b9\u7387\u7684\u306a\u30af\u30a8\u30ea\u5b9f\u884c\u3068\u30c7\u30fc\u30bf\u53d6\u5f97\u306e\u30c6\u30af\u30cb\u30c3\u30af\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-21\">2.2 \u30af\u30a8\u30ea\u5b9f\u884c\u3068\u30c7\u30fc\u30bf\u53d6\u5f97\u306e\u52b9\u7387\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/h2>\n\n\n\n<p>Spring JDBC\u3092\u4f7f\u7528\u3059\u308b\u969b\u3001\u30af\u30a8\u30ea\u5b9f\u884c\u3068\u30c7\u30fc\u30bf\u53d6\u5f97\u306e\u52b9\u7387\u5316\u306f\u975e\u5e38\u306b\u91cd\u8981\u3067\u3059\u3002\u4ee5\u4e0b\u306b\u3001\u4e3b\u8981\u306a\u52b9\u7387\u5316\u30c6\u30af\u30cb\u30c3\u30af\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-22\">1. \u30d0\u30c3\u30c1\u51e6\u7406<\/h3>\n\n\n\n<p>\u8907\u6570\u306eSQL\u64cd\u4f5c\u3092\u4e00\u62ec\u3067\u5b9f\u884c\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u30e9\u30a6\u30f3\u30c9\u30c8\u30ea\u30c3\u30d7\u3092\u6e1b\u3089\u3057\u307e\u3059\u3002<\/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=\"\">jdbcTemplate.batchUpdate(\"INSERT INTO users (name, email) VALUES (?, ?)\",\n    new BatchPreparedStatementSetter() {\n        public void setValues(PreparedStatement ps, int i) throws SQLException {\n            ps.setString(1, users.get(i).getName());\n            ps.setString(2, users.get(i).getEmail());\n        }\n        public int getBatchSize() {\n            return users.size();\n        }\n    });<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-23\">2. NamedParameterJdbcTemplate<\/h3>\n\n\n\n<p>\u540d\u524d\u4ed8\u304d\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u4f7f\u7528\u3057\u3066SQL\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3057\u3001\u53ef\u8aad\u6027\u3068\u4fdd\u5b88\u6027\u3092\u5411\u4e0a\u3055\u305b\u307e\u3059\u3002<\/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=\"\">MapSqlParameterSource params = new MapSqlParameterSource();\nparams.addValue(\"name\", \"John\");\nparams.addValue(\"age\", 30);\nList&lt;User&gt; users = namedParameterJdbcTemplate.query(\n    \"SELECT * FROM users WHERE name = :name AND age &gt; :age\",\n    params,\n    new UserRowMapper());<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-24\">3. RowMapper\u3068ResultSetExtractor<\/h3>\n\n\n\n<p>ResultSet\u3092\u52b9\u7387\u7684\u306b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30de\u30c3\u30d4\u30f3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>RowMapper: \u5404\u884c\u3092\u500b\u5225\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30de\u30c3\u30d4\u30f3\u30b0<\/li>\n\n\n\n<li>ResultSetExtractor: \u7d50\u679c\u30bb\u30c3\u30c8\u5168\u4f53\u3092\u8907\u96d1\u306a\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u69cb\u9020\u306b\u30de\u30c3\u30d4\u30f3\u30b0<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-25\">4. \u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3<\/h3>\n\n\n\n<p>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u5c0f\u5206\u3051\u306b\u3057\u3066\u53d6\u5f97\u3057\u3001\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u6291\u5236\u3057\u307e\u3059\u3002<\/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=\"\">public List&lt;User&gt; getUsersWithPagination(int page, int pageSize) {\n    int offset = (page - 1) * pageSize;\n    return jdbcTemplate.query(\n        \"SELECT * FROM users LIMIT ? OFFSET ?\",\n        new Object[]{pageSize, offset},\n        new UserRowMapper()\n    );\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-26\">5. \u30af\u30a8\u30ea\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u5316<\/h3>\n\n\n\n<p>\u983b\u7e41\u306b\u5b9f\u884c\u3055\u308c\u308b\u30af\u30a8\u30ea\u306e\u7d50\u679c\u3092\u30ad\u30e3\u30c3\u30b7\u30e5\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u30a2\u30af\u30bb\u30b9\u3092\u6e1b\u3089\u3057\u307e\u3059\u3002<\/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=\"\">@Cacheable(\"users\")\npublic User getUserById(Long id) {\n    return jdbcTemplate.queryForObject(\n        \"SELECT * FROM users WHERE id = ?\",\n        new Object[]{id},\n        new UserRowMapper()\n    );\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-27\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u5411\u4e0a\u306e\u305f\u3081\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u9069\u5207\u306b\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u4e0d\u8981\u306a\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3092\u907f\u3051\u308b<\/li>\n\n\n\n<li>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5834\u5408\u306f\u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u3092\u691c\u8a0e\u3059\u308b<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5b9a\u671f\u7684\u306b\u76e3\u8996\u3057\u6700\u9069\u5316\u3059\u308b<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30d5\u30a7\u30c3\u30c1\u30b5\u30a4\u30ba\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<p>\u3053\u308c\u3089\u306e\u30c6\u30af\u30cb\u30c3\u30af\u3092\u9069\u5207\u306b\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001Spring JDBC\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u30c6\u30af\u30cb\u30c3\u30af\u3092\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u3069\u306e\u3088\u3046\u306b\u9069\u7528\u3059\u308b\u304b\u306b\u3064\u3044\u3066\u3001\u3088\u308a\u8a73\u7d30\u306b\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-28\">3. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2460\uff1a\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u6700\u9069\u5316<\/h1>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u30d7\u30fc\u30eb\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u52b9\u7387\u6027\u3092\u5927\u304d\u304f\u5de6\u53f3\u3059\u308b\u91cd\u8981\u306a\u8981\u7d20\u3067\u3059\u3002\u63a5\u7d9a\u30d7\u30fc\u30eb\u3068\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u3092\u4e8b\u524d\u306b\u4f5c\u6210\u3057\u3001\u518d\u5229\u7528\u53ef\u80fd\u306a\u72b6\u614b\u3067\u7ba1\u7406\u3059\u308b\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-29\">\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u91cd\u8981\u6027<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u63a5\u7d9a\u306e\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u524a\u6e1b<\/strong>: \u63a5\u7d9a\u306e\u4f5c\u6210\u30fb\u7834\u68c4\u306b\u304b\u304b\u308b\u6642\u9593\u3068\u30ea\u30bd\u30fc\u30b9\u3092\u7bc0\u7d04<\/li>\n\n\n\n<li><strong>\u30ec\u30b9\u30dd\u30f3\u30b9\u6642\u9593\u306e\u6539\u5584<\/strong>: \u65e2\u5b58\u306e\u63a5\u7d9a\u3092\u518d\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30af\u30a8\u30ea\u5b9f\u884c\u307e\u3067\u306e\u6642\u9593\u3092\u77ed\u7e2e<\/li>\n\n\n\n<li><strong>\u30ea\u30bd\u30fc\u30b9\u306e\u52b9\u7387\u7684\u5229\u7528<\/strong>: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u540c\u6642\u63a5\u7d9a\u6570\u3092\u5236\u5fa1\u3057\u3001\u30ea\u30bd\u30fc\u30b9\u3092\u6700\u9069\u5316<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-30\">Spring Boot\u306e\u30c7\u30d5\u30a9\u30eb\u30c8HikariCP\u8a2d\u5b9a<\/h2>\n\n\n\n<p>Spring Boot\u306f\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u3067HikariCP\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002\u4e3b\u306a\u8a2d\u5b9a\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6700\u5927\u30d7\u30fc\u30eb\u30b5\u30a4\u30ba: 10<\/li>\n\n\n\n<li>\u6700\u5c0f\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u6570: 10<\/li>\n\n\n\n<li>\u63a5\u7d9a\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8: 30\u79d2<\/li>\n\n\n\n<li>\u30a2\u30a4\u30c9\u30eb\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8: 600\u79d2 (10\u5206)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-31\">\u63a5\u7d9a\u30d7\u30fc\u30eb\u6700\u9069\u5316\u306e\u5fc5\u8981\u6027<\/h2>\n\n\n\n<p>\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u72b6\u6cc1\u3067\u306f\u3001\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u6700\u9069\u5316\u304c\u5fc5\u8981\u3068\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u5fdc\u7b54\u6642\u9593\u304c\u9045\u3044<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u30a8\u30e9\u30fc\u304c\u983b\u767a\u3059\u308b<\/li>\n\n\n\n<li>\u30b5\u30fc\u30d0\u30fc\u30ea\u30bd\u30fc\u30b9\u306e\u4f7f\u7528\u7387\u304c\u9ad8\u3044<\/li>\n\n\n\n<li>\u540c\u6642\u30e6\u30fc\u30b6\u30fc\u6570\u304c\u5897\u52a0\u3057\u3066\u3044\u308b<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-32\">\u6700\u9069\u5316\u306e\u4e00\u822c\u7684\u30a2\u30d7\u30ed\u30fc\u30c1<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u9069\u5207\u306a\u30d7\u30fc\u30eb\u30b5\u30a4\u30ba\u306e\u8a2d\u5b9a<\/strong>: \u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306b\u5fdc\u3058\u3066\u6700\u9069\u306a\u30d7\u30fc\u30eb\u30b5\u30a4\u30ba\u3092\u6c7a\u5b9a<\/li>\n\n\n\n<li><strong>\u63a5\u7d9a\u306e\u30e9\u30a4\u30d5\u30b5\u30a4\u30af\u30eb\u7ba1\u7406<\/strong>: \u9577\u6642\u9593\u4f7f\u7528\u3055\u308c\u3066\u3044\u306a\u3044\u63a5\u7d9a\u3092\u9069\u5207\u306b\u7834\u68c4<\/li>\n\n\n\n<li><strong>\u63a5\u7d9a\u306e\u691c\u8a3c\u3068\u518d\u63a5\u7d9a<\/strong>: \u7121\u52b9\u306b\u306a\u3063\u305f\u63a5\u7d9a\u3092\u691c\u51fa\u3057\u3001\u81ea\u52d5\u7684\u306b\u518d\u63a5\u7d9a<\/li>\n\n\n\n<li><strong>\u7d71\u8a08\u60c5\u5831\u306e\u76e3\u8996<\/strong>: \u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u4f7f\u7528\u72b6\u6cc1\u3092\u7d99\u7d9a\u7684\u306b\u76e3\u8996\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u8abf\u6574<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-33\">HikariCP\u306e\u7279\u5fb4\u3068\u5229\u70b9<\/h2>\n\n\n\n<p>HikariCP\u306f\u3001\u305d\u306e\u9ad8\u901f\u6027\u3068\u8efd\u91cf\u3055\u304b\u3089\u5e83\u304f\u63a1\u7528\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u4e3b\u306a\u7279\u5fb4\u306f\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9ad8\u901f\u3067\u52b9\u7387\u7684\u306a\u63a5\u7d9a\u7ba1\u7406<\/li>\n\n\n\n<li>\u7c21\u5358\u306a\u8a2d\u5b9a\u3068\u8c4a\u5bcc\u306a\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u30aa\u30d7\u30b7\u30e7\u30f3<\/li>\n\n\n\n<li>\u8a73\u7d30\u306a\u76e3\u8996\u3068\u30e1\u30c8\u30ea\u30af\u30b9\u63d0\u4f9b<\/li>\n\n\n\n<li>\u30b9\u30ec\u30c3\u30c9\u30bb\u30fc\u30d5\u306a\u5b9f\u88c5<\/li>\n<\/ul>\n\n\n\n<p>\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001HikariCP\u3092\u4f7f\u7528\u3057\u305f\u9ad8\u901f\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u5177\u4f53\u7684\u306a\u8a2d\u5b9a\u65b9\u6cd5\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-34\">3.1 HikariCP\u3092\u4f7f\u7528\u3057\u305f\u9ad8\u901f\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u8a2d\u5b9a<\/h2>\n\n\n\n<p>HikariCP\u306f\u3001\u305d\u306e\u9ad8\u6027\u80fd\u3068\u7c21\u5358\u306a\u8a2d\u5b9a\u3067\u77e5\u3089\u308c\u308b\u8efd\u91cf\u306aJDBC\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u30d7\u30fc\u30eb\u30e9\u30a4\u30d6\u30e9\u30ea\u3067\u3059\u3002Spring Boot\u3067\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u7c21\u5358\u306b\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-35\">\u4e3b\u8981\u8a2d\u5b9a\u30d1\u30e9\u30e1\u30fc\u30bf<\/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=\"\">spring.datasource.hikari.maximum-pool-size=10\nspring.datasource.hikari.minimum-idle=5\nspring.datasource.hikari.connection-timeout=20000\nspring.datasource.hikari.idle-timeout=300000\nspring.datasource.hikari.max-lifetime=1200000<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>maximum-pool-size<\/code>: \u30d7\u30fc\u30eb\u5185\u306e\u6700\u5927\u63a5\u7d9a\u6570<\/li>\n\n\n\n<li><code>minimum-idle<\/code>: \u30d7\u30fc\u30eb\u5185\u306e\u6700\u5c0f\u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u6570<\/li>\n\n\n\n<li><code>connection-timeout<\/code>: \u63a5\u7d9a\u53d6\u5f97\u306e\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u6642\u9593\uff08\u30df\u30ea\u79d2\uff09<\/li>\n\n\n\n<li><code>idle-timeout<\/code>: \u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u306e\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u6642\u9593\uff08\u30df\u30ea\u79d2\uff09<\/li>\n\n\n\n<li><code>max-lifetime<\/code>: \u63a5\u7d9a\u306e\u6700\u5927\u751f\u5b58\u6642\u9593\uff08\u30df\u30ea\u79d2\uff09<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-36\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30d7\u30fc\u30eb\u30b5\u30a4\u30ba\u306f <code>CPU \u30b3\u30a2\u6570 * 2 + \u52b9\u679c\u7684\u306a\u30c7\u30a3\u30b9\u30af\u6570<\/code> \u3092\u76ee\u5b89\u306b\u8a2d\u5b9a<\/li>\n\n\n\n<li><code>connection-timeout<\/code> \u3092\u9069\u5207\u306b\u8a2d\u5b9a\u3057\u3001\u9577\u6642\u9593\u306e\u30d6\u30ed\u30c3\u30ad\u30f3\u30b0\u3092\u9632\u3050<\/li>\n\n\n\n<li><code>idle-timeout<\/code> \u3068 <code>max-lifetime<\/code> \u3092\u8a2d\u5b9a\u3057\u3066\u3001\u30ea\u30bd\u30fc\u30b9\u306e\u30ea\u30fc\u30af\u3092\u9632\u3050<\/li>\n\n\n\n<li>\u30e1\u30c8\u30ea\u30af\u30b9\u3092\u76e3\u8996\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u8a2d\u5b9a\u3092\u8abf\u6574\u3059\u308b<\/li>\n<\/ol>\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\">\u6ce8\u610f\u70b9<\/div><\/div><div class=\"sng-box-msg__contents\">\n<ul class=\"wp-block-list\">\n<li>\u30d7\u30fc\u30eb\u30b5\u30a4\u30ba\u3092\u5927\u304d\u304f\u3057\u3059\u304e\u306a\u3044\u3053\u3068<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc\u306e\u6700\u5927\u63a5\u7d9a\u6570\u5236\u9650\u3092\u8003\u616e\u3059\u308b\u3053\u3068<\/li>\n\n\n\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u7279\u6027\u306b\u5408\u308f\u305b\u3066\u8a2d\u5b9a\u3092\u8abf\u6574\u3059\u308b\u3053\u3068<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n\n\n\n<p>\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u3053\u308c\u3089\u306e\u8a2d\u5b9a\u3092\u3055\u3089\u306b\u6700\u9069\u5316\u3059\u308b\u305f\u3081\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u624b\u6cd5\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-37\">3.2 \u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0<\/h2>\n\n\n\n<p>\u63a5\u7d9a\u30d7\u30fc\u30eb\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u5fdc\u7b54\u6027\u5411\u4e0a\u3068\u30ea\u30bd\u30fc\u30b9\u4f7f\u7528\u52b9\u7387\u306e\u6700\u9069\u5316\u306b\u4e0d\u53ef\u6b20\u3067\u3059\u3002\u4ee5\u4e0b\u306b\u4e3b\u8981\u306a\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u30dd\u30a4\u30f3\u30c8\u3068\u65b9\u6cd5\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-38\">\u4e3b\u8981\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u30dd\u30a4\u30f3\u30c8<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30d7\u30fc\u30eb\u30b5\u30a4\u30ba\u306e\u6700\u9069\u5316<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>maximum-pool-size<\/code>: \u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u306b\u57fa\u3065\u3044\u3066\u8abf\u6574<\/li>\n\n\n\n<li><code>minimum-idle<\/code>: \u30ea\u30bd\u30fc\u30b9\u4f7f\u7528\u3092\u6700\u5c0f\u5316<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u63a5\u7d9a\u53d6\u5f97\u6642\u9593\u306e\u77ed\u7e2e<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>connection-timeout<\/code>: \u9069\u5207\u306a\u5f85\u6a5f\u6642\u9593\u3092\u8a2d\u5b9a<\/li>\n\n\n\n<li><code>validation-timeout<\/code>: \u63a5\u7d9a\u691c\u8a3c\u3092\u6700\u9069\u5316<\/li>\n\n\n\n<li><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u63a5\u7d9a\u306e\u518d\u5229\u7528\u52b9\u7387\u5411\u4e0a<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>max-lifetime<\/code>: \u53e4\u3044\u63a5\u7d9a\u3092\u5b9a\u671f\u7684\u306b\u66f4\u65b0<\/li>\n\n\n\n<li><code>idle-timeout<\/code>: \u30a2\u30a4\u30c9\u30eb\u63a5\u7d9a\u3092\u9069\u5207\u306b\u7ba1\u7406<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u30ea\u30bd\u30fc\u30b9\u30ea\u30fc\u30af\u306e\u9632\u6b62<\/strong>\n<ul class=\"wp-block-list\">\n<li><code>leak-detection-threshold<\/code>: \u63a5\u7d9a\u30ea\u30fc\u30af\u3092\u691c\u51fa<\/li>\n\n\n\n<li><code>auto-commit<\/code>: \u660e\u793a\u7684\u306a\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u3092\u4fc3\u9032<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-39\">\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\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=\"\">spring.datasource.hikari.maximum-pool-size=20\nspring.datasource.hikari.minimum-idle=10\nspring.datasource.hikari.connection-timeout=10000\nspring.datasource.hikari.idle-timeout=600000\nspring.datasource.hikari.max-lifetime=1800000\nspring.datasource.hikari.leak-detection-threshold=60000\nspring.datasource.hikari.auto-commit=false<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-40\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/h3>\n\n\n\n<p>\u7d99\u7d9a\u7684\u306a\u6700\u9069\u5316\u306e\u305f\u3081\u3001\u4ee5\u4e0b\u306e\u65b9\u6cd5\u3067\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u3092\u884c\u3044\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>HikariCP\u306e\u7d44\u307f\u8fbc\u307f\u30e1\u30c8\u30ea\u30af\u30b9\u4f7f\u7528<\/li>\n\n\n\n<li>JMX\u3092\u901a\u3058\u305f\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30ed\u30b0\u306e\u5206\u6790<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc\u5074\u306e\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/li>\n<\/ul>\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\">\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306e\u6ce8\u610f\u70b9<\/div><\/div><div class=\"sng-box-msg__contents\">\n<ul class=\"wp-block-list\">\n<li>\u904e\u5ea6\u306a\u6700\u9069\u5316\u3092\u907f\u3051\u308b<\/li>\n\n\n\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u7279\u6027\u3092\u8003\u616e\u3059\u308b<\/li>\n\n\n\n<li>\u6bb5\u968e\u7684\u306b\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3057\u3001\u5404\u6bb5\u968e\u3067\u52b9\u679c\u3092\u6e2c\u5b9a\u3059\u308b<\/li>\n\n\n\n<li>\u672c\u756a\u74b0\u5883\u306b\u8fd1\u3044\u6761\u4ef6\u3067\u30c6\u30b9\u30c8\u3059\u308b<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n\n\n\n<p>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306f\u7d99\u7d9a\u7684\u306a\u30d7\u30ed\u30bb\u30b9\u3067\u3059\u3002\u5b9a\u671f\u7684\u306b\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u3092\u884c\u3044\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u6210\u9577\u306b\u5408\u308f\u305b\u3066\u8a2d\u5b9a\u3092\u8abf\u6574\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-41\">4. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2461\uff1a\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u6d3b\u7528<\/h1>\n\n\n\n<p>\u30d0\u30c3\u30c1\u51e6\u7406\u306f\u3001\u8907\u6570\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3066\u4e00\u62ec\u3067\u5b9f\u884c\u3059\u308b\u6280\u8853\u3067\u3059\u3002Spring JDBC\u306b\u304a\u3051\u308b\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u6d3b\u7528\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u308b\u91cd\u8981\u306a\u624b\u6cd5\u306e\u4e00\u3064\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-42\">\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u91cd\u8981\u6027<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30e9\u30a6\u30f3\u30c9\u30c8\u30ea\u30c3\u30d7\u306e\u524a\u6e1b<\/li>\n\n\n\n<li>\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u306e\u6700\u5c0f\u5316<\/li>\n\n\n\n<li>\u5168\u4f53\u7684\u306a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u5411\u4e0a<\/li>\n\n\n\n<li>\u30ea\u30bd\u30fc\u30b9\u4f7f\u7528\u52b9\u7387\u306e\u6539\u5584<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-43\">Spring JDBC\u306b\u304a\u3051\u308b\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u5229\u70b9<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30b3\u30fc\u30c9\u306e\u7c21\u7d20\u5316<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316<\/li>\n\n\n\n<li>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u524a\u6e1b<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u5bb9\u6613\u3055<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-44\">\u52b9\u679c\u7684\u306a\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5927\u91cf\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\/\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/li>\n\n\n\n<li>\u5b9a\u671f\u7684\u306a\u30c7\u30fc\u30bf\u66f4\u65b0\u51e6\u7406<\/li>\n\n\n\n<li>\u8907\u6570\u30ec\u30b3\u30fc\u30c9\u306e\u540c\u6642\u633f\u5165\/\u66f4\u65b0\/\u524a\u9664<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-45\">\u57fa\u672c\u7684\u306a\u5b9f\u88c5\u65b9\u6cd5<\/h2>\n\n\n\n<p>Spring JDBC\u306f\u3001\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u305f\u3081\u306e\u8907\u6570\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u6700\u3082\u4e00\u822c\u7684\u306b\u4f7f\u7528\u3055\u308c\u308b<code>JdbcTemplate.batchUpdate()<\/code>\u30e1\u30bd\u30c3\u30c9\u306e\u4f8b\u3092\u4ee5\u4e0b\u306b\u793a\u3057\u307e\u3059\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=\"\">jdbcTemplate.batchUpdate(\"INSERT INTO users (name, email) VALUES (?, ?)\",\n    new BatchPreparedStatementSetter() {\n        public void setValues(PreparedStatement ps, int i) throws SQLException {\n            ps.setString(1, users.get(i).getName());\n            ps.setString(2, users.get(i).getEmail());\n        }\n        public int getBatchSize() {\n            return users.size();\n        }\n    });<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-46\">\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u8981\u56e0<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7279\u6027<\/li>\n\n\n\n<li>\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u9045\u5ef6<\/li>\n\n\n\n<li>\u30cf\u30fc\u30c9\u30a6\u30a7\u30a2\u30ea\u30bd\u30fc\u30b9\uff08CPU\u3001\u30e1\u30e2\u30ea\u3001\u30c7\u30a3\u30b9\u30afI\/O\uff09<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-47\">\u6ce8\u610f\u70b9\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u9069\u5207\u306a\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u306e\u9078\u629e<\/li>\n\n\n\n<li>\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u306e\u5b9f\u88c5<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5883\u754c\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5074\u306e\u8a2d\u5b9a\u6700\u9069\u5316<\/li>\n<\/ol>\n\n\n\n<p>\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u52b9\u679c\u3092\u8996\u899a\u5316\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\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=\"\">graph LR\n    A[\u5358\u4e00\u64cd\u4f5c] --&gt; B((\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9))\n    A --&gt; B\n    A --&gt; B\n    A --&gt; B\n    C[\u30d0\u30c3\u30c1\u51e6\u7406] --&gt; D{\u30b0\u30eb\u30fc\u30d7\u5316}\n    D --&gt; B<\/pre>\n\n\n\n<p>\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u5177\u4f53\u7684\u306a\u5b9f\u88c5\u65b9\u6cd5\u3068\u3057\u3066\u3001BatchPreparedStatementSetter\u306e\u4f7f\u7528\u65b9\u6cd5\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-48\">4.1 BatchPreparedStatementSetter\u306e\u4f7f\u7528\u65b9\u6cd5<\/h2>\n\n\n\n<p>BatchPreparedStatementSetter\u306f\u3001Spring JDBC\u3067\u30d0\u30c3\u30c1\u64cd\u4f5c\u3092\u52b9\u7387\u7684\u306b\u884c\u3046\u305f\u3081\u306e\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3067\u3059\u3002\u3053\u306e\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u4e00\u62ec\u3067\u51e6\u7406\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u6700\u9069\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-49\">\u57fa\u672c\u7684\u306a\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=\"\">List&lt;User&gt; users = Arrays.asList(new User(\"John\", \"john@example.com\"), new User(\"Jane\", \"jane@example.com\"));\njdbcTemplate.batchUpdate(\"INSERT INTO users (name, email) VALUES (?, ?)\",\n    new BatchPreparedStatementSetter() {\n        @Override\n        public void setValues(PreparedStatement ps, int i) throws SQLException {\n            User user = users.get(i);\n            ps.setString(1, user.getName());\n            ps.setString(2, user.getEmail());\n        }\n        @Override\n        public int getBatchSize() {\n            return users.size();\n        }\n    });<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-50\">\u4e3b\u306a\u5229\u70b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u52b9\u7387\u7684\u306b\u51e6\u7406<\/li>\n\n\n\n<li>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u306e\u6700\u9069\u5316<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30e9\u30a6\u30f3\u30c9\u30c8\u30ea\u30c3\u30d7\u306e\u524a\u6e1b<\/li>\n\n\n\n<li>\u30b3\u30fc\u30c9\u306e\u53ef\u8aad\u6027\u3068\u4fdd\u5b88\u6027\u306e\u5411\u4e0a<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-51\">\u6ce8\u610f\u70b9\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9069\u5207\u306a\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u306e\u9078\u629e\uff08\u901a\u5e38100-1000\u7a0b\u5ea6\uff09<\/li>\n\n\n\n<li>\u4f8b\u5916\u51e6\u7406\u306e\u9069\u5207\u306a\u5b9f\u88c5<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u8003\u616e<\/li>\n\n\n\n<li>\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u30c7\u30fc\u30bf\u578b\u306e\u4e00\u81f4\u78ba\u8a8d<\/li>\n<\/ul>\n\n\n\n<p>BatchPreparedStatementSetter\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u51e6\u7406\u64cd\u4f5c\u3092\u52b9\u7387\u7684\u306b\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u306e\u6700\u9069\u5316\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-52\">4.2 \u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306e\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u6700\u9069\u5316<\/h2>\n\n\n\n<p>\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u306e\u6700\u9069\u5316\u306f\u3001\u5927\u91cf\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u304d\u304f\u5de6\u53f3\u3057\u307e\u3059\u3002\u9069\u5207\u306a\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u306f\u51e6\u7406\u901f\u5ea6\u3092\u5411\u4e0a\u3055\u305b\u3001\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u6700\u9069\u5316\u3057\u3001\u5168\u4f53\u7684\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5411\u4e0a\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-53\">\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u6c7a\u5b9a\u306e\u4e3b\u8981\u56e0\u5b50<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5229\u7528\u53ef\u80fd\u306a\u30e1\u30e2\u30ea\u91cf<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6027\u80fd\u3068\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u901f\u5ea6\u3068\u5b89\u5b9a\u6027<\/li>\n\n\n\n<li>\u51e6\u7406\u3059\u308b\u30c7\u30fc\u30bf\u306e\u7279\u6027\uff08\u30b5\u30a4\u30ba\u3001\u8907\u96d1\u3055\uff09<\/li>\n\n\n\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u8981\u4ef6\uff08\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u6027\u306a\u3069\uff09<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-54\">\u6700\u9069\u5316\u306e\u30ac\u30a4\u30c9\u30e9\u30a4\u30f3<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u958b\u59cb\u70b9\u3068\u3057\u3066100-1000\u306e\u7bc4\u56f2\u3092\u691c\u8a0e<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30b5\u30a4\u30ba\u306b\u5fdc\u3058\u3066\u8abf\u6574\uff08\u5c0f\u3055\u3044\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306a\u3089\u5c0f\u3055\u3081\u3001\u5927\u304d\u3044\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306a\u3089\u5927\u304d\u3081\uff09<\/li>\n\n\n\n<li>\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3068CPU\u4f7f\u7528\u7387\u3092\u76e3\u8996\u3057\u306a\u304c\u3089\u8abf\u6574<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e<code>max_allowed_packet<\/code>\u8a2d\u5b9a\u3092\u8003\u616e<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-55\">\u52d5\u7684\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u8abf\u6574\u306e\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=\"\">int optimalBatchSize = 1000;\nlong startTime = System.currentTimeMillis();\n\/\/ \u30d0\u30c3\u30c1\u51e6\u7406\u5b9f\u884c\nlong endTime = System.currentTimeMillis();\nlong processingTime = endTime - startTime;\nif (processingTime &gt; THRESHOLD) {\n    optimalBatchSize = optimalBatchSize \/ 2;\n} else if (processingTime &lt; THRESHOLD \/ 2) {\n    optimalBatchSize = optimalBatchSize * 2;\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-56\">\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u95a2\u4fc2<\/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=\"\">graph LR\n    A[\u5c0f\u3055\u3059\u304e\u308b\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba] --&gt;|\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9\u5897\u52a0| B((\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9))\n    C[\u6700\u9069\u306a\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba] --&gt;|\u30d0\u30e9\u30f3\u30b9| B\n    D[\u5927\u304d\u3059\u304e\u308b\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba] --&gt;|\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u5897\u52a0| B<\/pre>\n\n\n\n<p>\u9069\u5207\u306a\u30d0\u30c3\u30c1\u30b5\u30a4\u30ba\u306f\u3001\u51e6\u7406\u3059\u308b\u30c7\u30fc\u30bf\u3084\u30b7\u30b9\u30c6\u30e0\u30ea\u30bd\u30fc\u30b9\u306b\u5fdc\u3058\u3066\u5909\u52d5\u3057\u307e\u3059\u3002\u5b9a\u671f\u7684\u306a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30c6\u30b9\u30c8\u3068\u6700\u9069\u5316\u3092\u884c\u3046\u3053\u3068\u3067\u3001\u5e38\u306b\u6700\u9069\u306a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u7dad\u6301\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-57\">5. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2462\uff1a\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u6700\u9069\u5316<\/h1>\n\n\n\n<p>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u4e00\u8cab\u6027\u3068\u6574\u5408\u6027\u3092\u4fdd\u8a3c\u3059\u308b\u91cd\u8981\u306a\u8981\u7d20\u3067\u3059\u3002Spring Framework\u306f\u3001\u5f37\u529b\u304b\u3064\u67d4\u8edf\u306a\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u304a\u308a\u3001\u3053\u308c\u3092\u6700\u9069\u5316\u3059\u308b\u3053\u3068\u3067\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u4fe1\u983c\u6027\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-58\">\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u91cd\u8981\u6027<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u306e\u6574\u5408\u6027\u7dad\u6301<\/li>\n\n\n\n<li>\u4e26\u884c\u51e6\u7406\u306e\u5236\u5fa1<\/li>\n\n\n\n<li>\u30a8\u30e9\u30fc\u6642\u306e\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u6a5f\u80fd<\/li>\n\n\n\n<li>\u30b7\u30b9\u30c6\u30e0\u306e\u4fe1\u983c\u6027\u5411\u4e0a<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-59\">Spring Framework\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u7279\u5fb4<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5ba3\u8a00\u7684\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\uff08@Transactional\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\uff09<\/li>\n\n\n\n<li>\u30d7\u30ed\u30b0\u30e9\u30de\u30c6\u30a3\u30c3\u30af\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\uff08TransactionTemplate\uff09<\/li>\n\n\n\n<li>AOP\uff08\u30a2\u30b9\u30da\u30af\u30c8\u6307\u5411\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\uff09\u306e\u6d3b\u7528<\/li>\n\n\n\n<li>\u8907\u6570\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u30de\u30cd\u30fc\u30b8\u30e3\u306e\u30b5\u30dd\u30fc\u30c8<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-60\">\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u6700\u9069\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5883\u754c\u3092\u5fc5\u8981\u6700\u5c0f\u9650\u306b\u4fdd\u3064<\/li>\n\n\n\n<li>\u8aad\u307f\u53d6\u308a\u5c02\u7528\u64cd\u4f5c\u306b\u306f<code>@Transactional(readOnly = true)<\/code>\u3092\u4f7f\u7528<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u4f8b\u5916\u51e6\u7406\u3068\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u4f1d\u64ad\u8a2d\u5b9a\u306e\u9069\u5207\u306a\u4f7f\u7528<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5185\u3067\u306eI\/O\u64cd\u4f5c\u3084\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u547c\u3073\u51fa\u3057\u3092\u6700\u5c0f\u9650\u306b\u6291\u3048\u308b<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-61\">\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u8996\u899a\u5316<\/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=\"\">graph TD\n    A[\u958b\u59cb] --&gt; B{\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u958b\u59cb}\n    B --&gt; C[\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c1]\n    C --&gt; D[\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c2]\n    D --&gt; E{\u30a8\u30e9\u30fc\u767a\u751f?}\n    E --&gt;|Yes| F[\u30ed\u30fc\u30eb\u30d0\u30c3\u30af]\n    E --&gt;|No| G[\u30b3\u30df\u30c3\u30c8]\n    F --&gt; H[\u7d42\u4e86]\n    G --&gt; H<\/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\">\u6ce8\u610f\u70b9<\/div><\/div><div class=\"sng-box-msg__contents\">\n<ul class=\"wp-block-list\">\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u7bc4\u56f2\u3092\u9069\u5207\u306b\u8a2d\u5b9a\uff08\u5927\u304d\u3059\u304e\u305a\u3001\u5c0f\u3055\u3059\u304e\u305a\uff09<\/li>\n\n\n\n<li>\u30cd\u30b9\u30c8\u3057\u305f\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u53d6\u308a\u6271\u3044\u306b\u6ce8\u610f<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5185\u3067\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u306e\u7279\u5b9a\u3068\u89e3\u6d88<\/li>\n\n\n\n<li>\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306e\u53ef\u80fd\u6027\u3092\u8003\u616e\u3057\u305f\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u8a2d\u8a08<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n\n\n\n<p>\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001@Transactional\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306e\u6b63\u3057\u3044\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002\u3053\u306e\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306f\u3001Spring Framework\u3067\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u3092\u884c\u3046\u969b\u306e\u4e2d\u5fc3\u7684\u306a\u6a5f\u80fd\u3067\u3042\u308a\u3001\u305d\u306e\u9069\u5207\u306a\u4f7f\u7528\u6cd5\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-62\">5.1 @Transactional\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306e\u6b63\u3057\u3044\u4f7f\u3044\u65b9<\/h2>\n\n\n\n<p>@Transactional\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306f\u3001Spring Framework\u3067\u5ba3\u8a00\u7684\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u3092\u5b9f\u73fe\u3059\u308b\u305f\u3081\u306e\u5f37\u529b\u306a\u30c4\u30fc\u30eb\u3067\u3059\u3002\u3053\u306e\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u6b63\u3057\u304f\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u6574\u5408\u6027\u3092\u4fdd\u3061\u306a\u304c\u3089\u52b9\u7387\u7684\u306a\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-63\">\u57fa\u672c\u7684\u306a\u4f7f\u7528\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=\"\">@Service\npublic class BankService {\n    @Autowired\n    private AccountRepository accountRepository;\n\n    @Transactional(isolation = Isolation.SERIALIZABLE, timeout = 30)\n    public void transfer(String fromAccountId, String toAccountId, BigDecimal amount) {\n        Account fromAccount = accountRepository.findById(fromAccountId).orElseThrow();\n        Account toAccount = accountRepository.findById(toAccountId).orElseThrow();\n\n        fromAccount.debit(amount);\n        toAccount.credit(amount);\n\n        accountRepository.save(fromAccount);\n        accountRepository.save(toAccount);\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-64\">\u4e3b\u8981\u306a\u5c5e\u6027<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>propagation<\/code>: \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u4f1d\u64ad\u65b9\u5f0f<\/li>\n\n\n\n<li><code>isolation<\/code>: \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u5206\u96e2\u30ec\u30d9\u30eb<\/li>\n\n\n\n<li><code>timeout<\/code>: \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u6642\u9593<\/li>\n\n\n\n<li><code>readOnly<\/code>: \u8aad\u307f\u53d6\u308a\u5c02\u7528\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u8a2d\u5b9a<\/li>\n\n\n\n<li><code>rollbackFor<\/code>: \u6307\u5b9a\u3057\u305f\u4f8b\u5916\u3067\u30ed\u30fc\u30eb\u30d0\u30c3\u30af<\/li>\n\n\n\n<li><code>noRollbackFor<\/code>: \u6307\u5b9a\u3057\u305f\u4f8b\u5916\u3067\u306f\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u3057\u306a\u3044<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-65\">\u6ce8\u610f\u70b9\u3068\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>public\u30e1\u30bd\u30c3\u30c9\u306b\u306e\u307f\u9069\u7528\u3059\u308b<\/li>\n\n\n\n<li>self-invocation\uff08\u540c\u30af\u30e9\u30b9\u5185\u306e\u30e1\u30bd\u30c3\u30c9\u547c\u3073\u51fa\u3057\uff09\u306b\u6ce8\u610f<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u4f8b\u5916\u51e6\u7406\u3092\u884c\u3044\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066rollbackFor\u3092\u6307\u5b9a<\/li>\n\n\n\n<li>\u8aad\u307f\u53d6\u308a\u5c02\u7528\u64cd\u4f5c\u306b\u306freadOnly=true\u3092\u6307\u5b9a<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5883\u754c\u3092\u9069\u5207\u306b\u8a2d\u5b9a\u3057\u3001\u9577\u6642\u9593\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u907f\u3051\u308b<\/li>\n<\/ol>\n\n\n\n<p>@Transactional\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u6b63\u3057\u304f\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30b3\u30fc\u30c9\u306e\u53ef\u8aad\u6027\u304c\u5411\u4e0a\u3057\u3001\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406\u306e\u8907\u96d1\u3055\u3092\u8efd\u6e1b\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5206\u96e2\u30ec\u30d9\u30eb\u306e\u9069\u5207\u306a\u8a2d\u5b9a\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-66\">5.2 \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5206\u96e2\u30ec\u30d9\u30eb\u306e\u9069\u5207\u306a\u8a2d\u5b9a<\/h2>\n\n\n\n<p>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5206\u96e2\u30ec\u30d9\u30eb\u306f\u3001\u4e26\u884c\u3057\u3066\u5b9f\u884c\u3055\u308c\u308b\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u9593\u306e\u30c7\u30fc\u30bf\u306e\u53ef\u8996\u6027\u3068\u4e00\u8cab\u6027\u3092\u5236\u5fa1\u3057\u307e\u3059\u3002\u9069\u5207\u306a\u5206\u96e2\u30ec\u30d9\u30eb\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u6574\u5408\u6027\u3092\u4fdd\u3061\u306a\u304c\u3089\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u6700\u9069\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-67\">\u5206\u96e2\u30ec\u30d9\u30eb\u306e\u7a2e\u985e\u3068\u7279\u5fb4<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>READ UNCOMMITTED: \u6700\u3082\u4f4e\u3044\u5206\u96e2\u30ec\u30d9\u30eb\u3002\u30c0\u30fc\u30c6\u30a3\u30ea\u30fc\u30c9\u304c\u767a\u751f\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u3002<\/li>\n\n\n\n<li>READ COMMITTED: \u30b3\u30df\u30c3\u30c8\u3055\u308c\u305f\u30c7\u30fc\u30bf\u306e\u307f\u8aad\u307f\u53d6\u308a\u53ef\u80fd\u3002\u591a\u304f\u306eDBMS\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u8a2d\u5b9a\u3002<\/li>\n\n\n\n<li>REPEATABLE READ: \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u4e2d\u306e\u8aad\u307f\u53d6\u308a\u304c\u4e00\u8cab\u3002\u30d5\u30a1\u30f3\u30c8\u30e0\u30ea\u30fc\u30c9\u306e\u53ef\u80fd\u6027\u3042\u308a\u3002<\/li>\n\n\n\n<li>SERIALIZABLE: \u6700\u3082\u53b3\u683c\u306a\u5206\u96e2\u30ec\u30d9\u30eb\u3002\u5b8c\u5168\u306a\u5206\u96e2\u3092\u63d0\u4f9b\u3059\u308b\u304c\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u5f71\u97ff\u3059\u308b\u3002<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-68\">Spring Framework\u3067\u306e\u8a2d\u5b9a\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=\"\">@Transactional(isolation = Isolation.REPEATABLE_READ)\npublic void someMethod() {\n    \/\/ \u30e1\u30bd\u30c3\u30c9\u672c\u4f53\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-69\">\u5206\u96e2\u30ec\u30d9\u30eb\u306e\u9078\u629e\u57fa\u6e96<\/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=\"\">graph TD\n    A[\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8981\u4ef6] --&gt; B{\u30c7\u30fc\u30bf\u6574\u5408\u6027vs\u6027\u80fd}\n    B --&gt;|\u9ad8\u6574\u5408\u6027\u5fc5\u8981| C[SERIALIZABLE]\n    B --&gt;|\u30d0\u30e9\u30f3\u30b9| D[REPEATABLE READ]\n    B --&gt;|\u4e00\u822c\u7684\u7528\u9014| E[READ COMMITTED]\n    B --&gt;|\u9ad8\u6027\u80fd\u5fc5\u8981| F[READ UNCOMMITTED]<\/pre>\n\n\n\n<p>\u9069\u5207\u306a\u5206\u96e2\u30ec\u30d9\u30eb\u306e\u9078\u629e\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u8981\u4ef6\u3001\u30c7\u30fc\u30bf\u306e\u6027\u8cea\u3001\u305d\u3057\u3066\u671f\u5f85\u3055\u308c\u308b\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u57fa\u3065\u3044\u3066\u884c\u3044\u307e\u3059\u3002\u4e00\u822c\u7684\u306b\u306f\u3001READ COMMITTED\u304c\u30d0\u30e9\u30f3\u30b9\u306e\u53d6\u308c\u305f\u9078\u629e\u80a2\u3067\u3059\u304c\u3001\u7279\u5b9a\u306e\u64cd\u4f5c\u306b\u306f\u7570\u306a\u308b\u30ec\u30d9\u30eb\u304c\u5fc5\u8981\u306a\u5834\u5408\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-70\">6. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2463\uff1aSQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56<\/h1>\n\n\n\n<p>SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u306f\u3001\u60aa\u610f\u306e\u3042\u308bSQL\u30b3\u30fc\u30c9\u3092\u6b63\u898f\u306e\u30af\u30a8\u30ea\u306b\u633f\u5165\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4e0d\u6b63\u306b\u64cd\u4f5c\u3059\u308b\u653b\u6483\u624b\u6cd5\u3067\u3059\u3002\u3053\u306e\u8106\u5f31\u6027\u306f\u3001\u30c7\u30fc\u30bf\u306e\u6f0f\u6d29\u3001\u6539\u3056\u3093\u3001\u524a\u9664\u3001\u3055\u3089\u306b\u306f\u8a8d\u8a3c\u306e\u30d0\u30a4\u30d1\u30b9\u306a\u3069\u3001\u6df1\u523b\u306a\u7d50\u679c\u3092\u3082\u305f\u3089\u3059\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-71\">SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u306e\u5371\u967a\u6027<\/h2>\n\n\n\n<p>\u4ee5\u4e0b\u306f\u3001SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u653b\u6483\u306e\u7c21\u5358\u306a\u4f8b\u3067\u3059\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=\"\">\/\/ \u8106\u5f31\u306a\u30af\u30a8\u30ea\nString query = \"SELECT * FROM users WHERE username = '\" + username + \"' AND password = '\" + password + \"'\";\n\n\/\/ \u60aa\u610f\u306e\u3042\u308b\u5165\u529b\nString maliciousInput = \"' OR '1'='1\";<\/pre>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306a\u5165\u529b\u306b\u3088\u308a\u3001\u5168\u30e6\u30fc\u30b6\u30fc\u306e\u60c5\u5831\u304c\u53d6\u5f97\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-72\">Spring JDBC\u306b\u304a\u3051\u308b\u5bfe\u7b56<\/h2>\n\n\n\n<p>Spring JDBC\u306f\u3001SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56\u306e\u305f\u3081\u306e\u5f37\u529b\u306a\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>PreparedStatement<\/strong>: \u30d1\u30e9\u30e1\u30fc\u30bf\u5316\u3055\u308c\u305f\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u3001SQL\u3068\u30c7\u30fc\u30bf\u3092\u5206\u96e2\u3057\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30d0\u30a4\u30f3\u30c9\u5909\u6570<\/strong>: \u30af\u30a8\u30ea\u5185\u306e\u30d7\u30ec\u30fc\u30b9\u30db\u30eb\u30c0\u306b\u5024\u3092\u5b89\u5168\u306b\u30d0\u30a4\u30f3\u30c9\u3057\u307e\u3059\u3002<\/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=\"\">jdbcTemplate.query(\"SELECT * FROM users WHERE id = ?\", \n    new Object[]{userId}, new UserRowMapper());<\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u81ea\u52d5\u7684\u306a\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406<\/strong><\/li>\n\n\n\n<li><strong>\u578b\u5b89\u5168\u306a\u30af\u30a8\u30ea\u69cb\u7bc9\u306e\u30b5\u30dd\u30fc\u30c8<\/strong><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-73\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5e38\u306bPreparedStatement\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u30e6\u30fc\u30b6\u30fc\u5165\u529b\u3092\u76f4\u63a5SQL\u30af\u30a8\u30ea\u306b\u7d44\u307f\u8fbc\u307e\u306a\u3044<\/li>\n\n\n\n<li>\u5165\u529b\u5024\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u65bd\u3059\u308b<\/li>\n\n\n\n<li>\u6700\u5c0f\u6a29\u9650\u306e\u539f\u5247\u306b\u5f93\u3063\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9\u3092\u5236\u9650\u3059\u308b<\/li>\n\n\n\n<li>\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u8a73\u7d30\u306a\u60c5\u5831\u3092\u958b\u793a\u3057\u306a\u3044<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-74\">\u5b89\u5168\u306a\u30af\u30a8\u30ea\u4f5c\u6210\u4f8b<\/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=\"\">MapSqlParameterSource params = new MapSqlParameterSource();\nparams.addValue(\"username\", username);\nparams.addValue(\"password\", password);\nreturn namedParameterJdbcTemplate.query(\n    \"SELECT * FROM users WHERE username = :username AND password = :password\",\n    params,\n    new UserRowMapper()\n);<\/pre>\n\n\n\n<p>SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u5bfe\u7b56\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306b\u3068\u3063\u3066\u4e0d\u53ef\u6b20\u3067\u3059\u3002\u9069\u5207\u306a\u5bfe\u7b56\u3092\u8b1b\u3058\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u4fdd\u8b77\u3060\u3051\u3067\u306a\u304f\u3001\u30af\u30a8\u30ea\u306e\u518d\u5229\u7528\u306b\u3088\u308b\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u5411\u4e0a\u3082\u671f\u5f85\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001PreparedStatement\u306e\u6d3b\u7528\u3068\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u306e\u4f7f\u7528\u306b\u3064\u3044\u3066\u3001\u3088\u308a\u8a73\u7d30\u306b\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-75\">6.1 PreparedStatement\u306e\u6d3b\u7528\u3068\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u306e\u4f7f\u7528<\/h2>\n\n\n\n<p>PreparedStatement\u306f\u3001SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u653b\u6483\u3092\u9632\u304e\u3001\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5411\u4e0a\u3055\u305b\u308b\u5f37\u529b\u306a\u30c4\u30fc\u30eb\u3067\u3059\u3002\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u5b89\u5168\u3067\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-76\">PreparedStatement\u306e\u4e3b\u306a\u5229\u70b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u653b\u6483\u306e\u9632\u6b62<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u306e\u518d\u5229\u7528\u306b\u3088\u308b\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u5411\u4e0a<\/li>\n\n\n\n<li>\u81ea\u52d5\u7684\u306a\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406<\/li>\n\n\n\n<li>\u578b\u5b89\u5168\u6027\u306e\u63d0\u4f9b<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-77\">\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=\"\">\/\/ JDBC\nPreparedStatement pstmt = conn.prepareStatement(\"SELECT * FROM users WHERE id = ?\");\npstmt.setInt(1, userId);\nResultSet rs = pstmt.executeQuery();\n\n\/\/ Spring JDBC\njdbcTemplate.query(\"SELECT * FROM users WHERE id = ?\", \n    new Object[]{userId}, new UserRowMapper());\n\n\/\/ NamedParameterJdbcTemplate\nMapSqlParameterSource params = new MapSqlParameterSource();\nparams.addValue(\"id\", userId);\nreturn namedParameterJdbcTemplate.query(\n    \"SELECT * FROM users WHERE id = :id\",\n    params,\n    new UserRowMapper()\n);<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-78\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5e38\u306bPreparedStatement\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u52d5\u7684SQL\u306e\u751f\u6210\u3092\u907f\u3051\u3001\u9759\u7684SQL\u3068\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b<\/li>\n\n\n\n<li>IN\u53e5\u4f7f\u7528\u6642\u306f\u500b\u5225\u306e\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u3092\u4f7f\u7528\u3059\u308b\u304b\u3001\u9069\u5207\u306a\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3\u3092\u5229\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u30d0\u30c3\u30c1\u51e6\u7406\u306b\u306faddBatch()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u518d\u5229\u7528\u53ef\u80fd\u306aPreparedStatement\u306f\u30ad\u30e3\u30c3\u30b7\u30e5\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<p>PreparedStatement\u3068\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u3092\u9069\u5207\u306b\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u4e21\u9762\u3067\u5927\u304d\u306a\u5229\u70b9\u304c\u5f97\u3089\u308c\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001Spring JDBC\u304c\u63d0\u4f9b\u3059\u308b\u8ffd\u52a0\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u6a5f\u80fd\u306b\u3064\u3044\u3066\u63a2\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-79\">6.2 Spring JDBC\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u6a5f\u80fd\u306e\u6d3b\u7528<\/h2>\n\n\n\n<p>Spring JDBC\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u5411\u4e0a\u3055\u305b\u308b\u305f\u3081\u306e\u591a\u304f\u306e\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u6a5f\u80fd\u3092\u9069\u5207\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u653b\u6483\u306a\u3069\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30ea\u30b9\u30af\u3092\u5927\u5e45\u306b\u8efd\u6e1b\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-80\">\u4e3b\u8981\u306a\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u6a5f\u80fd<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u81ea\u52d5\u7684\u306a\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406<\/li>\n\n\n\n<li>\u578b\u5b89\u5168\u306a\u30af\u30a8\u30ea\u69cb\u7bc9<\/li>\n\n\n\n<li>SQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3\u653b\u6483\u306e\u9632\u5fa1<\/li>\n\n\n\n<li>\u30bb\u30ad\u30e5\u30a2\u306a\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-81\">JdbcTemplate\u306e\u5b89\u5168\u306a\u30af\u30a8\u30ea\u5b9f\u884c<\/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=\"\">jdbcTemplate.update(\"INSERT INTO users (name, email) VALUES (?, ?)\", \n    new Object[]{\"John Doe\", \"john@example.com\"});<\/pre>\n\n\n\n<p>JdbcTemplate\u306f\u5185\u90e8\u3067PreparedStatement\u3092\u4f7f\u7528\u3057\u3001\u81ea\u52d5\u7684\u306b\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u30a8\u30b9\u30b1\u30fc\u30d7\u51e6\u7406\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-82\">NamedParameterJdbcTemplate\u306e\u5229\u70b9<\/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=\"\">MapSqlParameterSource params = new MapSqlParameterSource();\nparams.addValue(\"name\", \"John Doe\");\nparams.addValue(\"email\", \"john@example.com\");\nnamedParameterJdbcTemplate.update(\n    \"INSERT INTO users (name, email) VALUES (:name, :email)\", \n    params);<\/pre>\n\n\n\n<p>\u540d\u524d\u4ed8\u304d\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u53ef\u8aad\u6027\u304c\u5411\u4e0a\u3057\u3001\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u8aa4\u7528\u3092\u9632\u6b62\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-83\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5e38\u306bJdbcTemplate\u307e\u305f\u306fNamedParameterJdbcTemplate\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u52d5\u7684SQL\u306e\u751f\u6210\u3092\u907f\u3051\u3001\u9759\u7684SQL\u3068\u30d0\u30a4\u30f3\u30c9\u5909\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u4f8b\u5916\u51e6\u7406\u3092\u5b9f\u88c5\u3057\u3001\u30bb\u30f3\u30b7\u30c6\u30a3\u30d6\u306a\u60c5\u5831\u3092\u96a0\u853d\u3059\u308b<\/li>\n\n\n\n<li>\u6700\u5c0f\u6a29\u9650\u306e\u539f\u5247\u306b\u57fa\u3065\u3044\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<p>Spring JDBC\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u6a5f\u80fd\u3092\u9069\u5207\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u5b89\u5168\u3067\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u3092\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u6a5f\u80fd\u306f\u3001\u9069\u5207\u306b\u4f7f\u7528\u3059\u308c\u3070\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3078\u306e\u5f71\u97ff\u3082\u6700\u5c0f\u9650\u306b\u6291\u3048\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-84\">7. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2464\uff1a\u30af\u30a8\u30ea\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/h1>\n\n\n\n<p>\u30af\u30a8\u30ea\u6700\u9069\u5316\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5411\u4e0a\u3055\u305b\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u5fdc\u7b54\u6642\u9593\u3092\u77ed\u7e2e\u3059\u308b\u305f\u3081\u306e\u91cd\u8981\u306a\u6280\u8853\u3067\u3059\u3002\u9069\u5207\u306a\u30af\u30a8\u30ea\u6700\u9069\u5316\u306b\u3088\u308a\u3001\u30b7\u30b9\u30c6\u30e0\u30ea\u30bd\u30fc\u30b9\u3092\u52b9\u7387\u7684\u306b\u4f7f\u7528\u3057\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u3092\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-85\">Spring JDBC\u306b\u304a\u3051\u308b\u4e3b\u8981\u306a\u30af\u30a8\u30ea\u6700\u9069\u5316\u30c6\u30af\u30cb\u30c3\u30af<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>PreparedStatement\u306e\u4f7f\u7528<\/li>\n\n\n\n<li>\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u6d3b\u7528<\/li>\n\n\n\n<li>\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u306e\u5b9f\u88c5<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30d5\u30a7\u30c3\u30c1\u30b5\u30a4\u30ba\u306e\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u5fc5\u8981\u306b\u5fdc\u3058\u305f\u30cd\u30a4\u30c6\u30a3\u30d6SQL\u306e\u4f7f\u7528<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-86\">\u30af\u30a8\u30ea\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u8981\u56e0<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30c6\u30fc\u30d6\u30eb\u306e\u30b5\u30a4\u30ba\u3068\u30c7\u30fc\u30bf\u91cf<\/li>\n\n\n\n<li>\u7d22\u5f15\u306e\u6709\u7121\u3068\u7a2e\u985e<\/li>\n\n\n\n<li>\u30b8\u30e7\u30a4\u30f3\u306e\u8907\u96d1\u3055<\/li>\n\n\n\n<li>WHERE\u53e5\u306e\u6761\u4ef6<\/li>\n\n\n\n<li>\u30b5\u30d6\u30af\u30a8\u30ea\u306e\u4f7f\u7528<\/li>\n\n\n\n<li>\u30bd\u30fc\u30c8\u64cd\u4f5c\uff08ORDER BY\uff09\u306e\u6709\u7121<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-87\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30c7\u30fc\u30bf\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b<\/li>\n\n\n\n<li>\u9069\u5207\u306aWHERE\u53e5\u3067\u30c7\u30fc\u30bf\u3092\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3059\u308b<\/li>\n\n\n\n<li>\u5927\u91cf\u30c7\u30fc\u30bf\u53d6\u5f97\u6642\u306f\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u88c5\u3059\u308b<\/li>\n\n\n\n<li>\u983b\u7e41\u306b\u4f7f\u7528\u3055\u308c\u308b\u30af\u30a8\u30ea\u306b\u306f\u9069\u5207\u306a\u7d22\u5f15\u3092\u4f5c\u6210\u3059\u308b<\/li>\n\n\n\n<li>\u4e0d\u8981\u306a\u30b8\u30e7\u30a4\u30f3\u3092\u907f\u3051\u308b<\/li>\n\n\n\n<li>\u30b5\u30d6\u30af\u30a8\u30ea\u306e\u4f7f\u7528\u3092\u6700\u5c0f\u9650\u306b\u6291\u3048\u308b<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u6d3b\u7528\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-88\">\u30af\u30a8\u30ea\u6700\u9069\u5316\u306e\u4f8b<\/h2>\n\n\n\n<p>\u6700\u9069\u5316\u524d:<\/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=\"\">SELECT * FROM users WHERE name LIKE '%John%'<\/pre>\n\n\n\n<p>\u6700\u9069\u5316\u5f8c:<\/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=\"\">SELECT id, name, email FROM users WHERE name LIKE 'John%'<\/pre>\n\n\n\n<p>\u3053\u306e\u6700\u9069\u5316\u306b\u3088\u308a\u3001\u5fc5\u8981\u306a\u5217\u306e\u307f\u3092\u53d6\u5f97\u3057\u3001LIKE\u6f14\u7b97\u5b50\u306e\u4f7f\u7528\u3092\u6700\u9069\u5316\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-89\">\u30af\u30a8\u30ea\u6700\u9069\u5316\u306e\u8996\u8991\u5316<\/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=\"\">graph TD\n    A[\u30af\u30a8\u30ea\u5206\u6790] --&gt; B[\u5b9f\u884c\u8a08\u753b\u306e\u78ba\u8a8d]\n    B --&gt; C{\u6700\u9069\u5316\u304c\u5fc5\u8981?}\n    C --&gt;|Yes| D[\u7d22\u5f15\u306e\u8ffd\u52a0\/\u4fee\u6b63]\n    C --&gt;|Yes| E[\u30af\u30a8\u30ea\u306e\u66f8\u304d\u63db\u3048]\n    C --&gt;|Yes| F[\u30c7\u30fc\u30bf\u69cb\u9020\u306e\u898b\u76f4\u3057]\n    C --&gt;|No| G[\u5b8c\u4e86]\n    D --&gt; H[\u518d\u30c6\u30b9\u30c8]\n    E --&gt; H\n    F --&gt; H\n    H --&gt; C<\/pre>\n\n\n\n<p>\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u5b9f\u884c\u8a08\u753b\u306e\u5206\u6790\u3068\u7d22\u5f15\u306e\u9069\u5207\u306a\u4f7f\u7528\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u6280\u8853\u306f\u3001\u30af\u30a8\u30ea\u6700\u9069\u5316\u306b\u304a\u3044\u3066\u975e\u5e38\u306b\u91cd\u8981\u306a\u5f79\u5272\u3092\u679c\u305f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-90\">7.1 \u5b9f\u884c\u8a08\u753b\u306e\u5206\u6790\u3068\u7d22\u5f15\u306e\u9069\u5207\u306a\u4f7f\u7528<\/h2>\n\n\n\n<p>\u5b9f\u884c\u8a08\u753b\u306e\u5206\u6790\u3068\u7d22\u5f15\u306e\u9069\u5207\u306a\u4f7f\u7528\u306f\u3001\u30af\u30a8\u30ea\u6700\u9069\u5316\u306e\u8981\u3068\u306a\u308a\u307e\u3059\u3002\u5b9f\u884c\u8a08\u753b\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u65b9\u6cd5\u3092\u793a\u3057\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u3092\u7279\u5b9a\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-91\">\u5b9f\u884c\u8a08\u753b\u306e\u53d6\u5f97\uff08Spring JDBC\uff09<\/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=\"\">String explainSql = \"EXPLAIN \" + yourSql;\nList&lt;Map&lt;String, Object&gt;&gt; explainResult = jdbcTemplate.queryForList(explainSql);<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-92\">\u7d22\u5f15\u306e\u91cd\u8981\u6027<\/h3>\n\n\n\n<p>\u7d22\u5f15\u306f\u7279\u5b9a\u306e\u5217\u306b\u5bfe\u3059\u308b\u691c\u7d22\u3092\u9ad8\u901f\u5316\u3057\u307e\u3059\u304c\u3001\u904e\u5ea6\u306e\u4f7f\u7528\u306f\u633f\u5165\u30fb\u66f4\u65b0\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-93\">\u6700\u9069\u5316\u4f8b<\/h3>\n\n\n\n<p>\u5143\u306e\u30af\u30a8\u30ea:<\/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=\"\">SELECT * FROM orders WHERE customer_id = 123 AND order_date &gt; '2023-01-01'<\/pre>\n\n\n\n<p>\u7d22\u5f15\u306e\u8ffd\u52a0:<\/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=\"\">CREATE INDEX idx_customer_date ON orders (customer_id, order_date)<\/pre>\n\n\n\n<p>\u3053\u306e\u6700\u9069\u5316\u306b\u3088\u308a\u3001\u30d5\u30eb\u30c6\u30fc\u30d6\u30eb\u30b9\u30ad\u30e3\u30f3\u304b\u3089\u52b9\u7387\u7684\u306a\u7d22\u5f15\u30b9\u30ad\u30e3\u30f3\u306b\u5b9f\u884c\u8a08\u753b\u304c\u5909\u66f4\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-94\">\u7d22\u5f15\u8a2d\u8a08\u306e\u30ac\u30a4\u30c9\u30e9\u30a4\u30f3<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u983b\u7e41\u306b\u691c\u7d22\u3055\u308c\u308b\u5217\u306b\u7d22\u5f15\u3092\u4f5c\u6210<\/li>\n\n\n\n<li>\u30ab\u30fc\u30c7\u30a3\u30ca\u30ea\u30c6\u30a3\u306e\u9ad8\u3044\u5217\u3092\u9078\u629e<\/li>\n\n\n\n<li>\u8907\u5408\u7d22\u5f15\u306e\u5217\u9806\u5e8f\u3092\u9069\u5207\u306b\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u904e\u5ea6\u306e\u7d22\u5f15\u4f5c\u6210\u3092\u907f\u3051\u308b<\/li>\n<\/ol>\n\n\n\n<p>\u5b9f\u884c\u8a08\u753b\u306e\u5b9a\u671f\u7684\u306a\u5206\u6790\u3068\u9069\u5207\u306a\u7d22\u5f15\u8a2d\u8a08\u306b\u3088\u308a\u3001\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-95\">7.2 \u30cd\u30a4\u30c6\u30a3\u30d6SQL\u3068JPQL\u306e\u4f7f\u3044\u5206\u3051<\/h2>\n\n\n\n<p>\u30cd\u30a4\u30c6\u30a3\u30d6SQL\u3068JPQL\uff08Java Persistence Query Language\uff09\u306f\u3001\u305d\u308c\u305e\u308c\u7570\u306a\u308b\u7279\u5fb4\u3068\u5229\u70b9\u3092\u6301\u3063\u3066\u304a\u308a\u3001\u9069\u5207\u306a\u4f7f\u3044\u5206\u3051\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-96\">\u30cd\u30a4\u30c6\u30a3\u30d6SQL<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7279\u5fb4: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u56fa\u6709\u306e\u6700\u9069\u5316\u3084\u6a5f\u80fd\u3092\u5229\u7528\u53ef\u80fd<\/li>\n\n\n\n<li>\u5229\u70b9: \u9ad8\u5ea6\u306a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u3001\u8907\u96d1\u306a\u30af\u30a8\u30ea\u306b\u9069\u3057\u3066\u3044\u308b<\/li>\n\n\n\n<li>\u6b20\u70b9: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f9d\u5b58\u5ea6\u304c\u9ad8\u304f\u3001\u79fb\u690d\u6027\u304c\u4f4e\u3044<\/li>\n<\/ul>\n\n\n\n<p>\u4f8b\uff08Spring JDBC\uff09:<\/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=\"\">String sql = \"SELECT * FROM users WHERE id = ?\";\nUser user = jdbcTemplate.queryForObject(sql, new Object[]{id}, new UserRowMapper());<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-97\">JPQL<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7279\u5fb4: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u975e\u4f9d\u5b58\u3001\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u6307\u5411<\/li>\n\n\n\n<li>\u5229\u70b9: \u9ad8\u3044\u79fb\u690d\u6027\u3001\u578b\u5b89\u5168\u6027\u3001\u81ea\u52d5\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30de\u30c3\u30d4\u30f3\u30b0<\/li>\n\n\n\n<li>\u6b20\u70b9: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u56fa\u6709\u306e\u6700\u9069\u5316\u304c\u96e3\u3057\u3044<\/li>\n<\/ul>\n\n\n\n<p>\u4f8b\uff08Spring Data JPA\uff09:<\/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=\"\">@Query(\"SELECT u FROM User u WHERE u.email = :email\")\nUser findByEmail(@Param(\"email\") String email);<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-98\">\u4f7f\u3044\u5206\u3051\u306e\u57fa\u6e96<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u306e\u8907\u96d1\u3055: \u8907\u96d1\u306a\u30af\u30a8\u30ea \u2192 \u30cd\u30a4\u30c6\u30a3\u30d6SQL<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8981\u4ef6: \u6975\u5ea6\u306e\u6700\u9069\u5316\u304c\u5fc5\u8981 \u2192 \u30cd\u30a4\u30c6\u30a3\u30d6SQL<\/li>\n\n\n\n<li>\u79fb\u690d\u6027: \u9ad8\u3044\u79fb\u690d\u6027\u304c\u5fc5\u8981 \u2192 JPQL<\/li>\n\n\n\n<li>\u4fdd\u5b88\u6027: \u9577\u671f\u7684\u306a\u4fdd\u5b88\u3092\u8003\u616e \u2192 JPQL<\/li>\n<\/ol>\n\n\n\n<p>\u9069\u5207\u306a\u4f7f\u3044\u5206\u3051\u306b\u3088\u308a\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u4fdd\u5b88\u6027\u306e\u30d0\u30e9\u30f3\u30b9\u3092\u6700\u9069\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-99\">8. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2465\uff1a\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u5c0e\u5165<\/h1>\n\n\n\n<p>\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306f\u3001\u983b\u7e41\u306b\u30a2\u30af\u30bb\u30b9\u3055\u308c\u308b\u30c7\u30fc\u30bf\u3092\u9ad8\u901f\u306a\u30b9\u30c8\u30ec\u30fc\u30b8\u306b\u4e00\u6642\u7684\u306b\u4fdd\u5b58\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u30a2\u30af\u30bb\u30b9\u3092\u6e1b\u3089\u3059\u6280\u8853\u3067\u3059\u3002\u9069\u5207\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u5c0e\u5165\u306b\u3088\u308a\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-100\">\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u91cd\u8981\u6027<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8ca0\u8377\u8efd\u6e1b<\/li>\n\n\n\n<li>\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30ec\u30b9\u30dd\u30f3\u30b9\u6642\u9593\u77ed\u7e2e<\/li>\n\n\n\n<li>\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u5411\u4e0a<\/li>\n\n\n\n<li>\u30b3\u30b9\u30c8\u524a\u6e1b<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-101\">Spring Framework\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u6a5f\u80fd<\/h2>\n\n\n\n<p>Spring Framework\u306f\u3001\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u30d9\u30fc\u30b9\u306e\u5ba3\u8a00\u7684\u30ad\u30e3\u30c3\u30b7\u30e5\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u4e3b\u8981\u306a\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u306b\u306f\u4ee5\u4e0b\u304c\u3042\u308a\u307e\u3059\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>CacheManager: \u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u7ba1\u7406<\/li>\n\n\n\n<li>Cache: \u5b9f\u969b\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u30c7\u30fc\u30bf\u3092\u4fdd\u6301<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3: @Cacheable, @CachePut, @CacheEvict<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-102\">\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u5c0e\u5165\u6642\u306e\u8003\u616e\u70b9<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u5bfe\u8c61\u30c7\u30fc\u30bf\u306e\u9078\u5b9a<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u7c92\u5ea6\uff08\u30e1\u30bd\u30c3\u30c9\u3001\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3001\u30af\u30a8\u30ea\u7d50\u679c\u306a\u3069\uff09<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u6709\u52b9\u671f\u9650\u8a2d\u5b9a<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u30b5\u30a4\u30ba\u306e\u7ba1\u7406<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u306e\u4e00\u8cab\u6027\u306e\u4fdd\u8a3c<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-103\">\u4e00\u822c\u7684\u306a\u8ab2\u984c\u3068\u89e3\u6c7a\u7b56<\/h2>\n\n\n<div id=\"id-a1d5cd51-548e-4bdc-9574-916c620e04b9\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u8ab2\u984c<\/th><th>\u89e3\u6c7a\u7b56<\/th><\/tr><\/thead><tbody><tr><td>\u30c7\u30fc\u30bf\u306e\u4e00\u8cab\u6027<\/td><td>\u9069\u5207\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u7121\u52b9\u5316\u6226\u7565\u306e\u5b9f\u88c5<\/td><\/tr><tr><td>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u7206\u767a<\/td><td>\u9069\u5207\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u30b5\u30a4\u30ba\u5236\u9650\u3068\u30a8\u30d3\u30af\u30b7\u30e7\u30f3\u30dd\u30ea\u30b7\u30fc\u306e\u8a2d\u5b9a<\/td><\/tr><tr><td>\u30b3\u30fc\u30eb\u30c9\u30b9\u30bf\u30fc\u30c8\u554f\u984c<\/td><td>\u4e8b\u524d\u30a6\u30a9\u30fc\u30df\u30f3\u30b0\u6226\u7565\u306e\u5c0e\u5165<\/td><\/tr><tr><td>\u30ad\u30e3\u30c3\u30b7\u30e5\u6c5a\u67d3<\/td><td>\u9069\u5207\u306a\u30ad\u30fc\u306e\u8a2d\u8a08\u3068\u30ad\u30e3\u30c3\u30b7\u30e5\u30af\u30ea\u30fc\u30cb\u30f3\u30b0<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"i-104\">\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u8996\u899a\u5316<\/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=\"\">graph TD\n    A[\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3] --&gt;|1. \u30c7\u30fc\u30bf\u8981\u6c42| B{\u30ad\u30e3\u30c3\u30b7\u30e5}\n    B --&gt;|2. \u30ad\u30e3\u30c3\u30b7\u30e5\u30d2\u30c3\u30c8| A\n    B --&gt;|3. \u30ad\u30e3\u30c3\u30b7\u30e5\u30df\u30b9| C[\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9]\n    C --&gt;|4. \u30c7\u30fc\u30bf\u53d6\u5f97| B\n    B --&gt;|5. \u30ad\u30e3\u30c3\u30b7\u30e5\u66f4\u65b0| B\n    B --&gt;|6. \u30c7\u30fc\u30bf\u8fd4\u5374| A<\/pre>\n\n\n\n<p>\u30ad\u30e3\u30c3\u30b7\u30e5\u6226\u7565\u306e\u9069\u5207\u306a\u5b9f\u88c5\u306b\u3088\u308a\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001Spring Cache\u3092\u4f7f\u7528\u3057\u305f\u5177\u4f53\u7684\u306a\u30c7\u30fc\u30bf\u30ad\u30e3\u30c3\u30b7\u30f3\u30b0\u624b\u6cd5\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-105\">8.1 Spring Cache\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u30ad\u30e3\u30c3\u30b7\u30f3\u30b0<\/h2>\n\n\n\n<p>Spring Cache\u306f\u3001\u5ba3\u8a00\u7684\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u62bd\u8c61\u5316\u5c64\u3092\u63d0\u4f9b\u3057\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u5411\u4e0a\u3055\u305b\u307e\u3059\u3002\u4e3b\u8981\u306a\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306b\u306f@Cacheable\u3001@CachePut\u3001@CacheEvict\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-106\">\u57fa\u672c\u7684\u306a\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=\"\">@Service\npublic class UserService {\n    @Cacheable(\"users\")\n    public User getUserById(Long id) {\n        \/\/ \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u30e6\u30fc\u30b6\u30fc\u3092\u53d6\u5f97\u3059\u308b\u51e6\u7406\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-107\">\u30ad\u30e3\u30c3\u30b7\u30e5\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=\"\">@EnableCaching\n@Configuration\npublic class CacheConfig {\n    @Bean\n    public CacheManager cacheManager() {\n        return new ConcurrentMapCacheManager(\"users\");\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-108\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u9069\u5207\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u7c92\u5ea6\u3092\u9078\u629e\u3059\u308b<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u30ad\u30fc\u3092\u614e\u91cd\u306b\u8a2d\u8a08\u3059\u308b<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u6709\u52b9\u671f\u9650\u3092\u9069\u5207\u306b\u8a2d\u5b9a\u3059\u308b<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u30b5\u30a4\u30ba\u3092\u76e3\u8996\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u8abf\u6574\u3059\u308b<\/li>\n\n\n\n<li>@CachePut\u3068@CacheEvict\u3092\u9069\u5207\u306b\u4f7f\u7528\u3057\u3066\u4e00\u8cab\u6027\u3092\u7dad\u6301\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<p>Spring Cache\u3092\u52b9\u679c\u7684\u306b\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9\u3092\u524a\u6e1b\u3057\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30ec\u30b9\u30dd\u30f3\u30b9\u6642\u9593\u3092\u5927\u5e45\u306b\u77ed\u7e2e\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u30ad\u30e3\u30c3\u30b7\u30e5\u7121\u52b9\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-109\">8.2 \u30ad\u30e3\u30c3\u30b7\u30e5\u7121\u52b9\u5316\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<p>\u30ad\u30e3\u30c3\u30b7\u30e5\u7121\u52b9\u5316\u306f\u3001\u30c7\u30fc\u30bf\u306e\u4e00\u8cab\u6027\u3092\u7dad\u6301\u3057\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u6b63\u78ba\u6027\u3092\u78ba\u4fdd\u3059\u308b\u305f\u3081\u306b\u91cd\u8981\u3067\u3059\u3002Spring Cache\u3067\u306f\u3001\u4e3b\u306b@CacheEvict\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u7121\u52b9\u5316\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-110\">\u30ad\u30e3\u30c3\u30b7\u30e5\u7121\u52b9\u5316\u306e\u4e3b\u8981\u306a\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=\"\">@Service\npublic class UserService {\n    @CacheEvict(value = \"users\", key = \"#user.id\")\n    @Transactional\n    public void updateUser(User user) {\n        \/\/ \u30e6\u30fc\u30b6\u30fc\u66f4\u65b0\u51e6\u7406\n    }\n\n    @CacheEvict(value = \"users\", allEntries = true)\n    @Scheduled(fixedRate = 86400000) \/\/ 24\u6642\u9593\u3054\u3068\n    public void clearUserCache() {\n        \/\/ \u5168\u30e6\u30fc\u30b6\u30fc\u30ad\u30e3\u30c3\u30b7\u30e5\u30af\u30ea\u30a2\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-111\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u30a8\u30f3\u30c8\u30ea\u306e\u307f\u3092\u7121\u52b9\u5316\u3059\u308b<\/li>\n\n\n\n<li>\u9069\u5207\u306a\u30bf\u30a4\u30df\u30f3\u30b0\u3067\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u7121\u52b9\u5316\u3059\u308b\uff08\u4f8b\uff1a\u30c7\u30fc\u30bf\u66f4\u65b0\u6642\uff09<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5883\u754c\u3092\u8003\u616e\u3057\u3066\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u7121\u52b9\u5316\u3059\u308b<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u7121\u52b9\u5316\u306e\u30ed\u30b0\u3092\u8a18\u9332\u3057\u3001\u76e3\u8996\u3059\u308b<\/li>\n\n\n\n<li>\u30ad\u30e3\u30c3\u30b7\u30e5\u7121\u52b9\u5316\u306e\u7c92\u5ea6\u3092\u9069\u5207\u306b\u8a2d\u8a08\u3059\u308b<\/li>\n<\/ol>\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\">\u6ce8\u610f\u70b9<\/div><\/div><div class=\"sng-box-msg__contents\">\n<ul class=\"wp-block-list\">\n<li>\u904e\u5270\u306a\u7121\u52b9\u5316\u306f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u4f4e\u4e0b\u3055\u305b\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b<\/li>\n\n\n\n<li>\u5206\u6563\u74b0\u5883\u3067\u306f\u3001\u30ce\u30fc\u30c9\u9593\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u4e00\u8cab\u6027\u306b\u6ce8\u610f\u304c\u5fc5\u8981<\/li>\n\n\n\n<li>\u8907\u96d1\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u4f9d\u5b58\u95a2\u4fc2\u306b\u3088\u308b\u7121\u52b9\u5316\u6f0f\u308c\u306b\u6ce8\u610f<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n\n\n\n<p>\u9069\u5207\u306a\u30ad\u30e3\u30c3\u30b7\u30e5\u7121\u52b9\u5316\u6226\u7565\u3092\u5b9f\u88c5\u3059\u308b\u3053\u3068\u3067\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u4fe1\u983c\u6027\u3092\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-112\">9. \u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u79d8\u8a23\u2466\uff1a\u30c6\u30b9\u30c8\u99c6\u52d5\u958b\u767a\uff08TDD\uff09\u306e\u5b9f\u8df5<\/h1>\n\n\n\n<p>\u30c6\u30b9\u30c8\u99c6\u52d5\u958b\u767a\uff08TDD\uff09\u306f\u3001\u30c6\u30b9\u30c8\u3092\u5148\u306b\u66f8\u3044\u3066\u304b\u3089\u5b9f\u88c5\u3092\u884c\u3046\u958b\u767a\u624b\u6cd5\u3067\u3059\u3002\u3053\u306e\u624b\u6cd5\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u52b9\u7387\u5316\u3068\u4fe1\u983c\u6027\u5411\u4e0a\u306b\u5927\u304d\u304f\u8ca2\u732e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-113\">TDD\u306e\u91cd\u8981\u6027<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30b3\u30fc\u30c9\u306e\u54c1\u8cea\u5411\u4e0a<\/li>\n\n\n\n<li>\u8a2d\u8a08\u306e\u6539\u5584<\/li>\n\n\n\n<li>\u30d0\u30b0\u306e\u65e9\u671f\u767a\u898b\u3068\u4fee\u6b63<\/li>\n\n\n\n<li>\u30ea\u30d5\u30a1\u30af\u30bf\u30ea\u30f3\u30b0\u306e\u5bb9\u6613\u5316<\/li>\n\n\n\n<li>\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3068\u3057\u3066\u306e\u5f79\u5272<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-114\">TDD\u306e\u57fa\u672c\u30d7\u30ed\u30bb\u30b9<\/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=\"\">graph TD\n    A[1. \u5931\u6557\u3059\u308b\u30c6\u30b9\u30c8\u3092\u66f8\u304f] --&gt;|Red| B[2. \u30c6\u30b9\u30c8\u3092\u901a\u3059\u6700\u5c0f\u9650\u306e\u5b9f\u88c5]\n    B --&gt;|Green| C[3. \u30ea\u30d5\u30a1\u30af\u30bf\u30ea\u30f3\u30b0]\n    C --&gt;|Refactor| A<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-115\">Spring Framework\u3067\u306eTDD\u30a2\u30d7\u30ed\u30fc\u30c1<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Spring TestContext\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u306e\u6d3b\u7528<\/li>\n\n\n\n<li>@DataJpaTest\u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u305f\u30ea\u30dd\u30b8\u30c8\u30ea\u306e\u30c6\u30b9\u30c8<\/li>\n\n\n\n<li>MockMvc\u3092\u4f7f\u7528\u3057\u305f\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u306e\u30c6\u30b9\u30c8<\/li>\n\n\n\n<li>Spring Test DBUnit\u3092\u7528\u3044\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30b9\u30c8<\/li>\n\n\n\n<li>@MockBean\u3092\u4f7f\u7528\u3057\u305f\u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u6ce8\u5165<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-116\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306b\u304a\u3051\u308bTDD\u306e\u5229\u70b9<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5c64\u306e\u8a2d\u8a08\u6539\u5584<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u306e\u6700\u9069\u5316<\/li>\n\n\n\n<li>\u30a8\u30c3\u30b8\u30b1\u30fc\u30b9\u306e\u65e9\u671f\u767a\u898b<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u306e\u6574\u5408\u6027\u78ba\u4fdd<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u554f\u984c\u306e\u65e9\u671f\u691c\u51fa<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-117\">TDD\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5c0f\u3055\u306a\u5358\u4f4d\u3067\u30c6\u30b9\u30c8\u3092\u66f8\u304f<\/li>\n\n\n\n<li>\u30c6\u30b9\u30c8\u30b1\u30fc\u30b9\u306e\u72ec\u7acb\u6027\u3092\u4fdd\u3064<\/li>\n\n\n\n<li>\u30c6\u30b9\u30c8\u306e\u53ef\u8aad\u6027\u3092\u91cd\u8996\u3059\u308b<\/li>\n\n\n\n<li>\u5883\u754c\u5024\u3068\u7570\u5e38\u7cfb\u306e\u30c6\u30b9\u30c8\u3092\u5fd8\u308c\u306a\u3044<\/li>\n\n\n\n<li>\u30c6\u30b9\u30c8\u30ab\u30d0\u30ec\u30c3\u30b8\u3092\u76e3\u8996\u3059\u308b<\/li>\n\n\n\n<li>\u7d99\u7d9a\u7684\u306b\u30ea\u30d5\u30a1\u30af\u30bf\u30ea\u30f3\u30b0\u3092\u884c\u3046<\/li>\n<\/ol>\n\n\n\n<p>TDD\u3092\u5b9f\u8df5\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u54c1\u8cea\u3068\u52b9\u7387\u6027\u304c\u5411\u4e0a\u3057\u3001\u9577\u671f\u7684\u306a\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u6027\u3082\u6539\u5584\u3055\u308c\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001Spring Test DBUnit\u3092\u4f7f\u7528\u3057\u305f\u5177\u4f53\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30b9\u30c8\u624b\u6cd5\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-118\">9.1 Spring Test DBUnit\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30b9\u30c8<\/h2>\n\n\n\n<p>Spring Test DBUnit\u306f\u3001Spring Framework\u3068DBUnit\u3092\u7d71\u5408\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30b9\u30c8\u3092\u5bb9\u6613\u306b\u3059\u308b\u30e9\u30a4\u30d6\u30e9\u30ea\u3067\u3059\u3002\u4e3b\u306a\u7279\u5fb4\u3068\u3057\u3066\u3001\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u306eXML\u7ba1\u7406\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u72b6\u614b\u306e\u5236\u5fa1\u3001\u7d50\u679c\u306e\u81ea\u52d5\u6bd4\u8f03\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-119\">\u8a2d\u5b9a\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=\"\">@RunWith(SpringRunner.class)\n@SpringBootTest\n@TestExecutionListeners({\n    DependencyInjectionTestExecutionListener.class,\n    DirtiesContextTestExecutionListener.class,\n    TransactionalTestExecutionListener.class,\n    DbUnitTestExecutionListener.class\n})\npublic class UserRepositoryTest {\n    \/\/ \u30c6\u30b9\u30c8\u30e1\u30bd\u30c3\u30c9\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-120\">\u57fa\u672c\u7684\u306a\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=\"\">@Test\n@DatabaseSetup(\"\/testdata\/sample-data.xml\")\n@ExpectedDatabase(\"\/testdata\/expected-data.xml\")\npublic void testUpdateUser() {\n    User user = userRepository.findById(1L).orElseThrow();\n    user.setName(\"Updated Name\");\n    userRepository.save(user);\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-121\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3092\u6700\u5c0f\u9650\u306b\u4fdd\u3064<\/li>\n\n\n\n<li>\u30c6\u30b9\u30c8\u30e1\u30bd\u30c3\u30c9\u9593\u3067\u30c7\u30fc\u30bf\u306e\u72ec\u7acb\u6027\u3092\u78ba\u4fdd\u3059\u308b<\/li>\n\n\n\n<li>@ExpectedDatabase\u3092\u7a4d\u6975\u7684\u306b\u4f7f\u7528\u3057\u3066\u7d50\u679c\u3092\u691c\u8a3c\u3059\u308b<\/li>\n\n\n\n<li>\u5927\u898f\u6a21\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u306f\u5206\u5272\u6226\u7565\u3092\u9069\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u7ba1\u7406\u3092\u884c\u3046<\/li>\n<\/ol>\n\n\n\n<p>Spring Test DBUnit\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u306e\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30c6\u30b9\u30c8\u3092\u52b9\u7387\u7684\u306b\u5b9f\u65bd\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-122\">9.2 \u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6d3b\u7528\u3057\u305f\u5358\u4f53\u30c6\u30b9\u30c8\u6226\u7565<\/h2>\n\n\n\n<p>\u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f\u3001\u30c6\u30b9\u30c8\u5bfe\u8c61\u30b3\u30fc\u30c9\u306e\u4f9d\u5b58\u95a2\u4fc2\u3092\u6a21\u5023\u3057\u3001\u7279\u5b9a\u306e\u52d5\u4f5c\u3092\u30b7\u30df\u30e5\u30ec\u30fc\u30c8\u3059\u308b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u5916\u90e8\u4f9d\u5b58\u6027\u3092\u5206\u96e2\u3057\u3001\u30c6\u30b9\u30c8\u3092\u9ad8\u901f\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-123\">Spring Framework\u3067\u306e\u30e2\u30c3\u30af\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=\"\">@SpringBootTest\npublic class UserServiceTest {\n    @MockBean\n    private UserRepository userRepository;\n\n    @Autowired\n    private UserService userService;\n\n    @Test\n    public void testGetUser() {\n        when(userRepository.findById(1L)).thenReturn(Optional.of(new User(1L, \"John\")));\n        User user = userService.getUser(1L);\n        assertEquals(\"John\", user.getName());\n    }\n}<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-124\">\u5358\u4f53\u30c6\u30b9\u30c8\u306e\u57fa\u672c\u69cb\u9020<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30c6\u30b9\u30c8\u5bfe\u8c61\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7<\/li>\n\n\n\n<li>\u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u52d5\u4f5c\u5b9a\u7fa9<\/li>\n\n\n\n<li>\u30c6\u30b9\u30c8\u5bfe\u8c61\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u884c<\/li>\n\n\n\n<li>\u7d50\u679c\u306e\u691c\u8a3c<\/li>\n\n\n\n<li>\u30e2\u30c3\u30af\u306e\u547c\u3073\u51fa\u3057\u691c\u8a3c\uff08\u5fc5\u8981\u306b\u5fdc\u3058\u3066\uff09<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-125\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30e2\u30c3\u30af\u3092\u4f7f\u7528\u3059\u308b<\/li>\n\n\n\n<li>\u30e2\u30c3\u30af\u306e\u52d5\u4f5c\u3092\u660e\u78ba\u306b\u5b9a\u7fa9\u3059\u308b<\/li>\n\n\n\n<li>\u904e\u5ea6\u306b\u5177\u4f53\u7684\u306a\u30e2\u30c3\u30af\u3092\u907f\u3051\u308b<\/li>\n\n\n\n<li>\u30e2\u30c3\u30af\u3068\u30b9\u30bf\u30d6\u3092\u9069\u5207\u306b\u4f7f\u3044\u5206\u3051\u308b<\/li>\n\n\n\n<li>\u30c6\u30b9\u30c8\u306e\u53ef\u8aad\u6027\u3092\u7dad\u6301\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<p>\u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u9069\u5207\u306b\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u5358\u4f53\u30c6\u30b9\u30c8\u3092\u52b9\u7387\u7684\u306b\u5b9f\u65bd\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"i-126\">10. Spring JDBC\u306e\u672a\u6765\uff1a\u6700\u65b0\u306e\u30c8\u30ec\u30f3\u30c9\u3068\u767a\u5c55\u306e\u65b9\u5411\u6027<\/h1>\n\n\n\n<p>Spring JDBC\u306f\u3001\u305d\u306e\u76f4\u63a5\u7684\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5236\u5fa1\u3068\u30b7\u30f3\u30d7\u30eb\u3055\u3092\u7dad\u6301\u3057\u3064\u3064\u3001\u30e2\u30c0\u30f3\u306a\u958b\u767a\u74b0\u5883\u306b\u9069\u5fdc\u3057\u7d9a\u3051\u3066\u3044\u307e\u3059\u3002\u6700\u65b0\u306e\u30c8\u30ec\u30f3\u30c9\u3068\u4eca\u5f8c\u306e\u767a\u5c55\u65b9\u5411\u3092\u63a2\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-127\">\u73fe\u72b6\u3068\u6700\u65b0\u30c8\u30ec\u30f3\u30c9<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316\u306e\u7d99\u7d9a\u7684\u306a\u6539\u5584<\/li>\n\n\n\n<li>\u3088\u308a\u30e2\u30c0\u30f3\u306aAPI\u30c7\u30b6\u30a4\u30f3\u306e\u63a1\u7528<\/li>\n\n\n\n<li>\u975e\u540c\u671f\u51e6\u7406\u306e\u30b5\u30dd\u30fc\u30c8\u5f37\u5316<\/li>\n\n\n\n<li>\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u74b0\u5883\u3068\u306e\u7d71\u5408<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-128\">\u767a\u5c55\u306e\u65b9\u5411\u6027<\/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=\"\">graph TD\n    A[Spring JDBC] --&gt; B[\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u5bfe\u5fdc]\n    A --&gt; C[\u30ea\u30a2\u30af\u30c6\u30a3\u30d6\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0]\n    A --&gt; D[\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u9069\u5fdc]\n    A --&gt; E[\u65b0\u4e16\u4ee3DB\u5bfe\u5fdc]<\/pre>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u74b0\u5883\u3078\u306e\u9069\u5fdc<\/strong>: \u30b3\u30f3\u30c6\u30ca\u5316\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u306e\u4f7f\u7528\u6700\u9069\u5316\u3084\u30af\u30e9\u30a6\u30c9\u30b5\u30fc\u30d3\u30b9\u3068\u306e\u7d71\u5408\u5f37\u5316\u304c\u9032\u3080\u3067\u3057\u3087\u3046\u3002<\/li>\n\n\n\n<li><strong>\u30ea\u30a2\u30af\u30c6\u30a3\u30d6\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30e2\u30c7\u30eb\u306e\u63a1\u7528<\/strong>: \u975e\u540c\u671f\u51e6\u7406\u306b\u3088\u308b\u9ad8\u30b9\u30eb\u30fc\u30d7\u30c3\u30c8\u306e\u5b9f\u73fe\u304c\u671f\u5f85\u3055\u308c\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3078\u306e\u5bfe\u5fdc<\/strong>: \u30b5\u30fc\u30d3\u30b9\u9593\u306e\u30c7\u30fc\u30bf\u4e00\u8cab\u6027\u78ba\u4fdd\u3084\u8efd\u91cf\u306a\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5c64\u3068\u3057\u3066\u306e\u5f79\u5272\u304c\u91cd\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/li>\n\n\n\n<li><strong>\u65b0\u4e16\u4ee3\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u5bfe\u5fdc<\/strong>: NewSQL\u3001\u5206\u6563\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3001\u30a4\u30f3\u30e1\u30e2\u30ea\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306a\u3069\u3001\u591a\u69d8\u306a\u30c7\u30fc\u30bf\u30b9\u30c8\u30a2\u3068\u306e\u9023\u643a\u304c\u9032\u3080\u3067\u3057\u3087\u3046\u3002<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-129\">\u9577\u671f\u7684\u306a\u5b58\u5728\u610f\u7fa9\u3068\u5f79\u5272<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4f4e\u30ec\u30d9\u30eb\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5236\u5fa1\u306e\u5fc5\u8981\u6027\u306f\u7d99\u7d9a<\/li>\n\n\n\n<li>\u9ad8\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u8981\u6c42\u3055\u308c\u308b\u30b7\u30b9\u30c6\u30e0\u3067\u306e\u4e2d\u6838\u7684\u5f79\u5272<\/li>\n\n\n\n<li>\u30ec\u30ac\u30b7\u30fc\u30b7\u30b9\u30c6\u30e0\u3068\u30e2\u30c0\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306e\u6a4b\u6e21\u3057<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7279\u5316\u578b\u6700\u9069\u5316\u306e\u63d0\u4f9b<\/li>\n<\/ul>\n\n\n\n<p>Spring JDBC\u306f\u3001\u30b7\u30f3\u30d7\u30eb\u3055\u3068\u76f4\u63a5\u7684\u306a\u5236\u5fa1\u3092\u63d0\u4f9b\u3059\u308b\u4e00\u65b9\u3067\u3001\u30e2\u30c0\u30f3\u306a\u958b\u767a\u30cb\u30fc\u30ba\u306b\u9069\u5fdc\u3057\u7d9a\u3051\u308b\u3053\u3068\u3067\u3001\u305d\u306e\u91cd\u8981\u6027\u3092\u7dad\u6301\u3057\u3066\u3044\u304f\u3067\u3057\u3087\u3046\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001Spring Data JDBC\u3068\u306e\u6bd4\u8f03\u3068\u4f7f\u3044\u5206\u3051\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-130\">10.1 Spring Data JDBC\u3068\u306e\u6bd4\u8f03\u3068\u4f7f\u3044\u5206\u3051<\/h2>\n\n\n\n<p>Spring JDBC\u3068Spring Data JDBC\u306f\u3001\u7570\u306a\u308b\u30a2\u30d7\u30ed\u30fc\u30c1\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306b\u4e3b\u8981\u306a\u9055\u3044\u3068\u4f7f\u3044\u5206\u3051\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-131\">\u4e3b\u306a\u7279\u5fb4\u6bd4\u8f03<\/h3>\n\n\n<div id=\"id-05752fde-841b-4d78-8739-1ced20975c83\">\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u7279\u5fb4<\/th><th>Spring JDBC<\/th><th>Spring Data JDBC<\/th><\/tr><\/thead><tbody><tr><td>\u62bd\u8c61\u5316\u30ec\u30d9\u30eb<\/td><td>\u4f4e\u30ec\u30d9\u30eb<\/td><td>\u9ad8\u30ec\u30d9\u30eb<\/td><\/tr><tr><td>SQL\u5236\u5fa1<\/td><td>\u5b8c\u5168<\/td><td>\u9650\u5b9a\u7684<\/td><\/tr><tr><td>ORM<\/td><td>\u624b\u52d5<\/td><td>\u7c21\u6613\u81ea\u52d5<\/td><\/tr><tr><td>CRUD\u64cd\u4f5c<\/td><td>\u624b\u52d5\u5b9f\u88c5<\/td><td>\u81ea\u52d5\u751f\u6210<\/td><\/tr><tr><td>\u5b66\u7fd2\u66f2\u7dda<\/td><td>\u3088\u308a\u6025<\/td><td>\u3088\u308a\u7de9\u3084\u304b<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"i-132\">\u9069\u3057\u305f\u30b7\u30ca\u30ea\u30aa<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Spring JDBC:<\/li>\n\n\n\n<li>\u8907\u96d1\u306aSQL\u30af\u30a8\u30ea\u304c\u5fc5\u8981<\/li>\n\n\n\n<li>\u5b8c\u5168\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5236\u5fa1\u304c\u91cd\u8981<\/li>\n\n\n\n<li>\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6975\u5ea6\u306e\u6700\u9069\u5316\u304c\u5fc5\u8981<\/li>\n\n\n\n<li>Spring Data JDBC:<\/li>\n\n\n\n<li>\u30b7\u30f3\u30d7\u30eb\u306aCRUD\u64cd\u4f5c\u304c\u4e3b<\/li>\n\n\n\n<li>\u8fc5\u901f\u306a\u958b\u767a\u304c\u512a\u5148<\/li>\n\n\n\n<li>\u30c9\u30e1\u30a4\u30f3\u30c9\u30ea\u30d6\u30f3\u8a2d\u8a08\u3092\u63a1\u7528<\/li>\n<\/ul>\n\n\n\n<p>\u9078\u629e\u306f\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8981\u4ef6\u3001\u958b\u767a\u8005\u306e\u30b9\u30ad\u30eb\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u8981\u6c42\u306b\u57fa\u3065\u3044\u3066\u884c\u3046\u3079\u304d\u3067\u3059\u3002Spring JDBC\u306f\u3088\u308a\u5927\u304d\u306a\u67d4\u8edf\u6027\u3092\u63d0\u4f9b\u3057\u3001Spring Data JDBC\u306f\u958b\u767a\u306e\u7c21\u7d20\u5316\u3092\u5b9f\u73fe\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-133\">10.2 \u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306b\u304a\u3051\u308bSpring JDBC\u306e\u5f79\u5272<\/h2>\n\n\n\n<p>\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306b\u304a\u3044\u3066\u3001Spring JDBC\u306f\u8efd\u91cf\u3067\u67d4\u8edf\u306a\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u5c64\u3092\u63d0\u4f9b\u3057\u3001\u91cd\u8981\u306a\u5f79\u5272\u3092\u679c\u305f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-134\">Spring JDBC\u306e\u9069\u5408\u6027<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u8efd\u91cf\u3067\u67d4\u8edf\u306a\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9<\/li>\n\n\n\n<li>\u76f4\u63a5\u7684\u306aSQL\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb<\/li>\n\n\n\n<li>\u30b5\u30fc\u30d3\u30b9\u306e\u72ec\u7acb\u6027\u306b\u9069\u3057\u305f\u30b7\u30f3\u30d7\u30eb\u3055<\/li>\n\n\n\n<li>\u9ad8\u3044\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u4f4e\u3044\u30aa\u30fc\u30d0\u30fc\u30d8\u30c3\u30c9<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-135\">\u5177\u4f53\u7684\u306a\u4f7f\u7528\u4f8b<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u9867\u5ba2\u30c7\u30fc\u30bf\u7ba1\u7406\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9<\/li>\n\n\n\n<li>\u6ce8\u6587\u51e6\u7406\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9<\/li>\n\n\n\n<li>\u5728\u5eab\u7ba1\u7406\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-136\">\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30b5\u30fc\u30d3\u30b9\u3054\u3068\u306b\u5c02\u7528\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u4f7f\u7528<\/li>\n\n\n\n<li>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u7bc4\u56f2\u3092\u30b5\u30fc\u30d3\u30b9\u5185\u306b\u9650\u5b9a<\/li>\n\n\n\n<li>\u975e\u540c\u671f\u901a\u4fe1\u3092\u6d3b\u7528\u3057\u3066\u30b5\u30fc\u30d3\u30b9\u9593\u306e\u7d50\u5408\u5ea6\u3092\u4e0b\u3052\u308b<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u30b3\u30fc\u30c9\u306e\u9069\u5207\u306a\u62bd\u8c61\u5316<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-137\">\u8ab2\u984c\u3068\u89e3\u6c7a\u7b56<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5206\u6563\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 \u2192 Saga\u30d1\u30bf\u30fc\u30f3\u306e\u5b9f\u88c5<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u306e\u4e00\u8cab\u6027 \u2192 \u6700\u7d42\u7684\u4e00\u8cab\u6027\u30e2\u30c7\u30eb\u306e\u63a1\u7528<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u306e\u8907\u96d1\u3055 \u2192 CQRS\u30d1\u30bf\u30fc\u30f3\u306e\u9069\u7528<\/li>\n<\/ul>\n\n\n\n<p>Spring JDBC\u306f\u3001\u305d\u306e\u8efd\u91cf\u6027\u3068\u67d4\u8edf\u6027\u306b\u3088\u308a\u3001\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306b\u304a\u3051\u308b\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u7ba1\u7406\u3092\u53ef\u80fd\u306b\u3057\u3001\u30b9\u30b1\u30fc\u30e9\u30d6\u30eb\u3067\u4fdd\u5b88\u6027\u306e\u9ad8\u3044\u30b7\u30b9\u30c6\u30e0\u69cb\u7bc9\u3092\u652f\u63f4\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Spring Framework JDBC\u306e\u57fa\u790e\uff1a\u306a\u305c\u4eca\u3082\u91cd\u8981\u306a\u306e\u304b Spring Framework JDBC\u306f\u3001Java Database Connectivity (JDBC) API\u3092\u62bd\u8c61\u5316\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 &#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-290","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\/290","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=290"}],"version-history":[{"count":3,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/290\/revisions"}],"predecessor-version":[{"id":296,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=\/wp\/v2\/posts\/290\/revisions\/296"}],"wp:attachment":[{"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dexall.co.jp\/articles\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}