{"id":40327,"date":"2023-06-07T10:17:31","date_gmt":"2023-06-30T09:54:57","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/"},"modified":"2024-04-30T07:43:09","modified_gmt":"2024-04-29T23:43:09","slug":"%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/","title":{"rendered":"\u3010Spring Boot\u3011\u4f7f\u7528JUnit\u00d7DBUnit\u8fdb\u884cController\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u6d4b\u8bd5"},"content":{"rendered":"<p>\u8fd9\u662f\u4f7f\u7528JUnit\u548cDBUnit\u6765\u6d4b\u8bd5Spring Boot\u7684Controller\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u793a\u4f8b\u4ee3\u7801\u3002<\/p>\n<h2>\u73af\u5883<\/h2>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">OS\uff1aWindows10<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">IDE\uff1aEclipse2020-03<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Java\uff1a8<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">MySQL\uff1a5.7<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Spring Boot\uff1a2.3.0<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">JUnit\uff1a5<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">DBUnit\uff1a2.7.0<\/ul>\n<h2>\u5c42\u6b21\u7ed3\u6784<\/h2>\n<pre class=\"post-pre\"><code>spring_boot_test_item\r\n     |\r\n    src\/main\/java\r\n     |----jp.co.test_item\r\n     |               |----app\r\n     |               |     |---- controller\r\n     |               |     |---- response\r\n     |               |\r\n     |               |----domain\r\n     |                      |---- service\r\n     |                      |---- repository\r\n     |                      |---- model\r\n     |\r\n    src\/main\/resources\r\n     |----application.yml\r\n     |\r\n     |\r\n    src\/main\/test(\u203b)\r\n\r\n<\/code><\/pre>\n<p>\u57fa\u672c\u4e0a\uff0c\u4f4d\u4e8esrc\/main\/test\u76ee\u5f55\u4e0b\u7684\u6587\u4ef6\u4e0esrc\/main\/java\u76ee\u5f55\u4e0b\u7684\u6587\u4ef6\u5177\u6709\u76f8\u540c\u7684\u7ed3\u6784\uff0c\u6240\u4ee5\u53ef\u4ee5\u7701\u7565\u4e0d\u63d0\u3002<\/p>\n<h2>\u521b\u5efa\u8868<\/h2>\n<pre class=\"post-pre\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"nv\">`items`<\/span> <span class=\"p\">(<\/span>\r\n  <span class=\"nv\">`item_id`<\/span> <span class=\"nb\">int<\/span><span class=\"p\">(<\/span><span class=\"mi\">11<\/span><span class=\"p\">)<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span> <span class=\"n\">AUTO_INCREMENT<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"nv\">`item_name`<\/span> <span class=\"nb\">varchar<\/span><span class=\"p\">(<\/span><span class=\"mi\">20<\/span><span class=\"p\">)<\/span> <span class=\"k\">COLLATE<\/span> <span class=\"n\">utf8mb4_bin<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"nv\">`item_explanation`<\/span> <span class=\"nb\">varchar<\/span><span class=\"p\">(<\/span><span class=\"mi\">100<\/span><span class=\"p\">)<\/span> <span class=\"k\">COLLATE<\/span> <span class=\"n\">utf8mb4_bin<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"nv\">`category_id`<\/span> <span class=\"nb\">int<\/span><span class=\"p\">(<\/span><span class=\"mi\">11<\/span><span class=\"p\">)<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"s1\">'1'<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span> <span class=\"p\">(<\/span><span class=\"nv\">`item_id`<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">)<\/span> <span class=\"n\">ENGINE<\/span><span class=\"o\">=<\/span><span class=\"n\">InnoDB<\/span> <span class=\"n\">AUTO_INCREMENT<\/span><span class=\"o\">=<\/span><span class=\"mi\">8<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"n\">CHARSET<\/span><span class=\"o\">=<\/span><span class=\"n\">utf8mb4<\/span> <span class=\"k\">COLLATE<\/span><span class=\"o\">=<\/span><span class=\"n\">utf8mb4_bin<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<p>\u6267\u884c\u4ee5\u4e0a\u7684DDL\u8bed\u53e5\uff0c\u521b\u5efa\u8868\u3002<\/p>\n<h2>\u5e94\u7528\u7a0b\u5e8f\u914d\u7f6e\u6587\u4ef6<\/h2>\n<pre class=\"post-pre\"><code>\r\n<span class=\"na\">spring<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">datasource<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">driver-class-name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">com.mysql.cj.jdbc.Driver<\/span>\r\n    <span class=\"na\">url<\/span><span class=\"pi\">:<\/span> <span class=\"s\">jdbc:mysql:\/\/\u63a5\u7d9a\u5148\u540d\/DB\u540d?serverTimezone=JST&amp;nullCatalogMeansCurrent=true<\/span>\r\n    <span class=\"na\">username<\/span><span class=\"pi\">:<\/span> <span class=\"s\">\u30e6\u30fc\u30b6\u30fc\u540d<\/span>\r\n    <span class=\"na\">password<\/span><span class=\"pi\">:<\/span> <span class=\"s\">\u30d1\u30b9\u30ef\u30fc\u30c9<\/span>\r\n  <span class=\"na\">jpa<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">database<\/span><span class=\"pi\">:<\/span> <span class=\"s\">MYSQL<\/span>\r\n    <span class=\"s\">hibernate.ddl-auto<\/span><span class=\"pi\">:<\/span> <span class=\"s\">update<\/span>\r\n\r\n  <span class=\"na\">main<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">allow-bean-definition-overriding<\/span><span class=\"pi\">:<\/span> <span class=\"no\">true<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u5728\u6b64\u4e2d\u5199\u4e0b\u8fde\u63a5\u5230MySQL\u7684\u4fe1\u606f\u3002<br \/>\n\u91cd\u70b9\u6709\u4ee5\u4e0b\u4e24\u70b9\u3002<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u901a\u8fc7\u5c06&#8221;nullCatalogMeansCurrent=true&#8221;\u8bbe\u7f6e\u4e3a\u771f\u6765\u907f\u514d\u5728\u540c\u4e00DB\u5b9e\u4f8b\u7684\u5176\u4ed6\u6570\u636e\u5e93\u4e2d\u5b58\u5728\u540c\u540d\u8868\u65f6\u4ea7\u751f\u9519\u8bef\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\u901a\u8fc7\u5c06&#8221;allow-bean-definition-overriding: true&#8221;\uff08\u8fd8\u8981\u8bb0\u5f97\u52a0\u4e0a\u4e0a\u9762\u7684&#8221;main:&#8221;\uff09\u6765\u5141\u8bb8bean\u7684\u91cd\u5199\u3002<\/ol>\n<h2>build.gradle\u7684\u914d\u7f6e<\/h2>\n<pre class=\"post-pre\"><code><span class=\"n\">plugins<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"n\">id<\/span> <span class=\"s1\">'org.springframework.boot'<\/span> <span class=\"n\">version<\/span> <span class=\"s1\">'2.3.0.RELEASE'<\/span>\r\n    <span class=\"n\">id<\/span> <span class=\"s1\">'io.spring.dependency-management'<\/span> <span class=\"n\">version<\/span> <span class=\"s1\">'1.0.9.RELEASE'<\/span>\r\n    <span class=\"n\">id<\/span> <span class=\"s1\">'java'<\/span>\r\n<span class=\"o\">}<\/span>\r\n\r\n<span class=\"n\">group<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'jp.co.test_item'<\/span>\r\n<span class=\"n\">version<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'0.0.1-SNAPSHOT'<\/span>\r\n<span class=\"n\">sourceCompatibility<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'1.8'<\/span>\r\n\r\n<span class=\"n\">configurations<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"n\">compileOnly<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"n\">extendsFrom<\/span> <span class=\"n\">annotationProcessor<\/span>\r\n    <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n\r\n<span class=\"n\">dependencyManagement<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"n\">imports<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"n\">mavenBom<\/span> <span class=\"s2\">\"org.junit:junit-bom:5.6.2\"<\/span><span class=\"c1\">\/\/BOM\u306e\u30a4\u30f3\u30dd\u30fc\u30c8<\/span>\r\n    <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n\r\n<span class=\"k\">repositories<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"n\">mavenCentral<\/span><span class=\"o\">()<\/span>\r\n<span class=\"o\">}<\/span>\r\n\r\n<span class=\"k\">dependencies<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"n\">implementation<\/span> <span class=\"s1\">'org.springframework.boot:spring-boot-starter-data-jpa'<\/span>\r\n    <span class=\"n\">implementation<\/span> <span class=\"s1\">'org.springframework.boot:spring-boot-starter-web'<\/span>\r\n    <span class=\"n\">compileOnly<\/span> <span class=\"s1\">'org.projectlombok:lombok'<\/span>\r\n    <span class=\"n\">compile<\/span> <span class=\"nl\">group:<\/span> <span class=\"s1\">'javax.xml.bind'<\/span><span class=\"o\">,<\/span> <span class=\"nl\">name:<\/span> <span class=\"s1\">'jaxb-api'<\/span><span class=\"o\">,<\/span> <span class=\"nl\">version:<\/span> <span class=\"s1\">'2.2.4'<\/span>\r\n    <span class=\"n\">runtimeOnly<\/span> <span class=\"s1\">'mysql:mysql-connector-java'<\/span>\r\n    <span class=\"n\">annotationProcessor<\/span> <span class=\"s1\">'org.projectlombok:lombok'<\/span>\r\n    <span class=\"n\">testImplementation<\/span><span class=\"o\">(<\/span><span class=\"s1\">'org.springframework.boot:spring-boot-starter-test'<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"n\">exclude<\/span> <span class=\"nl\">group:<\/span> <span class=\"s1\">'org.junit.vintage'<\/span><span class=\"o\">,<\/span> <span class=\"nl\">module:<\/span> <span class=\"s1\">'junit-vintage-engine'<\/span>\r\n    <span class=\"o\">}<\/span>\r\n    <span class=\"n\">testImplementation<\/span> <span class=\"s1\">'org.junit.jupiter:junit-jupiter'<\/span><span class=\"c1\">\/\/JUnit5\u306b\u5bfe\u5fdc<\/span>\r\n    <span class=\"n\">testRuntimeOnly<\/span> <span class=\"s1\">'org.junit.platform:junit-platform-launcher'<\/span><span class=\"c1\">\/\/IDE\u306a\u3069\u306e\u30b5\u30dd\u30fc\u30c8\u7528<\/span>\r\n    <span class=\"n\">testCompile<\/span> <span class=\"nl\">group:<\/span> <span class=\"s1\">'com.github.springtestdbunit'<\/span><span class=\"o\">,<\/span> <span class=\"nl\">name:<\/span> <span class=\"s1\">'spring-test-dbunit'<\/span><span class=\"o\">,<\/span> <span class=\"nl\">version:<\/span> <span class=\"s1\">'1.3.0'<\/span> <span class=\"c1\">\/\/ Spring\u3067DBUnit\u3092\u7528\u3044\u308b\u969b\u306b\u5fc5\u8981<\/span>\r\n    <span class=\"n\">testCompile<\/span> <span class=\"nl\">group:<\/span> <span class=\"s1\">'org.dbunit'<\/span><span class=\"o\">,<\/span> <span class=\"nl\">name:<\/span> <span class=\"s1\">'dbunit'<\/span><span class=\"o\">,<\/span> <span class=\"nl\">version:<\/span> <span class=\"s1\">'2.7.0'<\/span> <span class=\"c1\">\/\/ DBUnit\u306eAPI<\/span>\r\n<span class=\"o\">}<\/span>\r\n\r\n<span class=\"n\">test<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"n\">useJUnitPlatform<\/span><span class=\"o\">()<\/span>\r\n<span class=\"o\">}<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u8fd9\u6b21\u7684\u91cd\u70b9\u5728\u4e8e\u8bc4\u8bba\u7684\u90e8\u5206\u3002<\/p>\n<h2>\u8003\u5bdf\u7684\u5b9e\u9645\u5b9e\u73b0<\/h2>\n<p>\u7f16\u5199\u5b9e\u73b0\u76ee\u6807\u7c7b\u7fa4\u7684\u4ee3\u7801\u3002<\/p>\n<h3>1. \u63a7\u5236\u5668\u7c7b<\/h3>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.app.controller<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.sql.SQLException<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.List<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.http.HttpStatus<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.http.ResponseEntity<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.validation.BindingResult<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.validation.annotation.Validated<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.DeleteMapping<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.GetMapping<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.PathVariable<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.PostMapping<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.PutMapping<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.RequestBody<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.RestController<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.app.request.ItemPostRequest<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.app.response.ItemResponse<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.app.response.ItemsResponse<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.model.Item<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.service.ItemService<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">lombok.RequiredArgsConstructor<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@RestController<\/span>\r\n<span class=\"nd\">@RequiredArgsConstructor<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">ItemController<\/span> <span class=\"o\">{<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"kd\">final<\/span> <span class=\"nc\">ItemService<\/span> <span class=\"n\">itemService<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@GetMapping<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\/item\/{itemId}\"<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">ResponseEntity<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">ItemResponse<\/span><span class=\"o\">&gt;<\/span> <span class=\"nf\">getItemsByGet<\/span><span class=\"o\">(<\/span><span class=\"nd\">@PathVariable<\/span> <span class=\"kt\">int<\/span> <span class=\"n\">itemId<\/span><span class=\"o\">){<\/span>\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemService<\/span><span class=\"o\">.<\/span><span class=\"na\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"n\">itemId<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"nc\">ItemResponse<\/span> <span class=\"n\">itemResponse<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">ItemResponse<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">().<\/span><span class=\"na\">item<\/span><span class=\"o\">(<\/span><span class=\"n\">item<\/span><span class=\"o\">).<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">ResponseEntity<\/span><span class=\"o\">&lt;&gt;(<\/span><span class=\"n\">itemResponse<\/span><span class=\"o\">,<\/span> <span class=\"nc\">HttpStatus<\/span><span class=\"o\">.<\/span><span class=\"na\">OK<\/span><span class=\"o\">);<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@PostMapping<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\/items\"<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">ResponseEntity<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">ItemsResponse<\/span><span class=\"o\">&gt;<\/span> <span class=\"nf\">getItemsByPost<\/span><span class=\"o\">(<\/span><span class=\"nd\">@Validated<\/span> <span class=\"nd\">@RequestBody<\/span> <span class=\"nc\">ItemPostRequest<\/span> <span class=\"n\">request<\/span><span class=\"o\">){<\/span>\r\n        <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">items<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemService<\/span><span class=\"o\">.<\/span><span class=\"na\">findByCategoryId<\/span><span class=\"o\">(<\/span><span class=\"n\">request<\/span><span class=\"o\">.<\/span><span class=\"na\">getCategoryId<\/span><span class=\"o\">());<\/span>\r\n        <span class=\"nc\">ItemsResponse<\/span> <span class=\"n\">itemResponse<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">ItemsResponse<\/span><span class=\"o\">.<\/span><span class=\"na\">builder<\/span><span class=\"o\">().<\/span><span class=\"na\">items<\/span><span class=\"o\">(<\/span><span class=\"n\">items<\/span><span class=\"o\">).<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">ResponseEntity<\/span><span class=\"o\">&lt;&gt;(<\/span><span class=\"n\">itemResponse<\/span><span class=\"o\">,<\/span> <span class=\"nc\">HttpStatus<\/span><span class=\"o\">.<\/span><span class=\"na\">OK<\/span><span class=\"o\">);<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n<span class=\"o\">}<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u672c\u6b21\u6d4b\u8bd5\u7684\u76ee\u6807\u662f\u5e26\u6709@GetMapping\u548c@PostMapping\u6ce8\u89e3\u7684\u4e24\u4e2a\u65b9\u6cd5\u3002<\/p>\n<h3>2. \u8bf7\u6c42\uff08Request\uff09\u7c7b<\/h3>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.app.request<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">lombok.Getter<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">lombok.Setter<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@Getter<\/span>\r\n<span class=\"nd\">@Setter<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">ItemPostRequest<\/span> <span class=\"o\">{<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">Integer<\/span> <span class=\"n\">categoryId<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"o\">}<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u8fd9\u4e2a\u65b9\u6cd5\u7528\u4e8e\u83b7\u53d6\u4f7f\u7528@PostMapping\u6ce8\u89e3\u4fee\u9970\u7684Controller\u7c7b\u4e2d\u7684RequestBody\u5185\u5bb9\u3002<\/p>\n<h3>3. Response \u7c7b<\/h3>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.app.response<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.List<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.model.Item<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">lombok.Builder<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">lombok.Getter<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@Getter<\/span>\r\n<span class=\"nd\">@Builder<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">ItemResponse<\/span> <span class=\"o\">{<\/span>\r\n\r\n    <span class=\"c1\">\/\/ Item\u8fd4\u5374\u7528<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">Item<\/span> <span class=\"n\">item<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"c1\">\/\/ List&lt;Item&gt;\u8fd4\u5374\u7528<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">items<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"o\">}<\/span>\r\n\r\n\r\n<\/code><\/pre>\n<p>\u4e3a\u4e86\u5728Controller\u7c7b\u7684\u54cd\u5e94\u65f6\u8fdb\u884c\u683c\u5f0f\u8c03\u6574\u65f6\u4f7f\u7528\u3002<\/p>\n<h3>4. \u670d\u52a1\u7c7b (Service class)<\/h3>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.service<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.List<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.stereotype.Service<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.transaction.annotation.Transactional<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.model.Item<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.repository.ItemRepository<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">lombok.RequiredArgsConstructor<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@Service<\/span>\r\n<span class=\"nd\">@RequiredArgsConstructor<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">ItemService<\/span> <span class=\"o\">{<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"kd\">final<\/span> <span class=\"nc\">ItemRepository<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@Transactional<\/span><span class=\"o\">(<\/span><span class=\"n\">readOnly<\/span> <span class=\"o\">=<\/span> <span class=\"kc\">true<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">Item<\/span> <span class=\"nf\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"kt\">int<\/span> <span class=\"n\">itemId<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"n\">itemId<\/span><span class=\"o\">);<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Transactional<\/span><span class=\"o\">(<\/span><span class=\"n\">readOnly<\/span> <span class=\"o\">=<\/span> <span class=\"kc\">true<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"nf\">findByCategoryId<\/span><span class=\"o\">(<\/span><span class=\"kt\">int<\/span> <span class=\"n\">categoryId<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByCategoryId<\/span><span class=\"o\">(<\/span><span class=\"n\">categoryId<\/span><span class=\"o\">);<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<p>\u8fd9\u662f\u4e00\u4e2aService\u7c7b\u3002<br \/>\n\u4ec5\u8fdb\u884c\u6570\u636e\u8bfb\u53d6\u64cd\u4f5c\uff0c\u6211\u4eec\u5c06\u5176\u6807\u8bb0\u4e3a@Transactional(readOnly=true)\uff08\u9ed8\u8ba4\u503c\u4e3afalse\uff09\u3002<br \/>\n\u901a\u8fc7\u8fd9\u6837\u505a\uff0c\u5373\u4f7f\u5c1d\u8bd5\u8fdb\u884c\u6570\u636e\u64cd\u4f5c\uff08\u4f8b\u5982\u6ce8\u518c\u3001\u66f4\u65b0\u3001\u5220\u9664\uff09\uff0c\u4e5f\u4e0d\u4f1a\u6267\u884c\u4efb\u4f55\u5904\u7406\uff0c\u4e5f\u4e0d\u4f1a\u53d1\u751f\u9519\u8bef\u3002<br \/>\n\uff08\u5b9e\u9645\u4e0a\u6211\u4eec\u6839\u672c\u6ca1\u6709\u8fd9\u6837\u7684\u63cf\u8ff0\uff0c\u4f46\u662f&#8230;\uff09<\/p>\n<h3>5. \u5546\u54c1\u4ed3\u5e93.java<\/h3>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.repository<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.List<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.data.jpa.repository.JpaRepository<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.stereotype.Repository<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.test_item.domain.model.Item<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@Repository<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">interface<\/span> <span class=\"nc\">ItemRepository<\/span> <span class=\"kd\">extends<\/span> <span class=\"nc\">JpaRepository<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">,<\/span> <span class=\"nc\">Integer<\/span><span class=\"o\">&gt;{<\/span>\r\n\r\n    <span class=\"c1\">\/\/ \u300cselect * from items where item_id = itemId\uff08\u5f15\u6570\u3068\u3057\u3066\u308f\u305f\u3063\u3066\u304f\u308b\u5909\u6570\uff09;\u300d\u3068\u540c\u7fa9<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">Item<\/span> <span class=\"nf\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"kt\">int<\/span> <span class=\"n\">itemId<\/span><span class=\"o\">);<\/span>\r\n\r\n    <span class=\"c1\">\/\/ \u300cselect * from items where category_id = categoryId\uff08\u5f15\u6570\u3068\u3057\u3066\u308f\u305f\u3063\u3066\u304f\u308b\u5909\u6570\uff09;\u300d\u3068\u540c\u7fa9<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"nf\">findByCategoryId<\/span><span class=\"o\">(<\/span><span class=\"kt\">int<\/span> <span class=\"n\">categoryId<\/span><span class=\"o\">);<\/span>\r\n\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<p>\u8fd9\u662f\u4e00\u4e2aRepository\u7c7b\u3002<br \/>\n\u901a\u8fc7\u9075\u5faaSpring Data JPA\u7684\u547d\u540d\u89c4\u5219\u6765\u5b9a\u4e49\u65b9\u6cd5\uff0c\u5b83\u80fd\u591f\u81ea\u52a8\u751f\u6210\u67e5\u8be2\u3002<\/p>\n<h3>6. \u5b9e\u4f53\u7c7b<\/h3>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.model<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.io.Serializable<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.Column<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.Entity<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.GeneratedValue<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.GenerationType<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.Id<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.NamedQuery<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.Table<\/span><span class=\"o\">;<\/span>\r\n\r\n\r\n<span class=\"cm\">\/**\r\n * The persistent class for the items database table.\r\n *\r\n *\/<\/span>\r\n<span class=\"nd\">@Entity<\/span>\r\n<span class=\"nd\">@Table<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span><span class=\"o\">=<\/span><span class=\"s\">\"items\"<\/span><span class=\"o\">)<\/span>\r\n<span class=\"nd\">@NamedQuery<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span><span class=\"o\">=<\/span><span class=\"s\">\"Item.findAll\"<\/span><span class=\"o\">,<\/span> <span class=\"n\">query<\/span><span class=\"o\">=<\/span><span class=\"s\">\"SELECT i FROM Item i\"<\/span><span class=\"o\">)<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">Item<\/span> <span class=\"kd\">implements<\/span> <span class=\"nc\">Serializable<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"kd\">static<\/span> <span class=\"kd\">final<\/span> <span class=\"kt\">long<\/span> <span class=\"n\">serialVersionUID<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1L<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@Id<\/span>\r\n    <span class=\"nd\">@GeneratedValue<\/span><span class=\"o\">(<\/span><span class=\"n\">strategy<\/span><span class=\"o\">=<\/span><span class=\"nc\">GenerationType<\/span><span class=\"o\">.<\/span><span class=\"na\">IDENTITY<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"nd\">@Column<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span><span class=\"o\">=<\/span><span class=\"s\">\"item_id\"<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"kt\">int<\/span> <span class=\"n\">itemId<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@Column<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span><span class=\"o\">=<\/span><span class=\"s\">\"category_id\"<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"kt\">int<\/span> <span class=\"n\">categoryId<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@Column<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span><span class=\"o\">=<\/span><span class=\"s\">\"item_explanation\"<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">String<\/span> <span class=\"n\">itemExplanation<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@Column<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span><span class=\"o\">=<\/span><span class=\"s\">\"item_name\"<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">String<\/span> <span class=\"n\">itemName<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nf\">Item<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">int<\/span> <span class=\"nf\">getItemId<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">itemId<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"kt\">int<\/span> <span class=\"n\">itemId<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">itemId<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemId<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">int<\/span> <span class=\"nf\">getCategoryId<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">categoryId<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"kt\">int<\/span> <span class=\"n\">categoryId<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">categoryId<\/span> <span class=\"o\">=<\/span> <span class=\"n\">categoryId<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">String<\/span> <span class=\"nf\">getItemExplanation<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">itemExplanation<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"nc\">String<\/span> <span class=\"n\">itemExplanation<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">itemExplanation<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemExplanation<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">String<\/span> <span class=\"nf\">getItemName<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">itemName<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"nc\">String<\/span> <span class=\"n\">itemName<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">itemName<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemName<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<p>\u8fd9\u662f\u4e00\u4e2a\u5b9e\u4f53\u7c7b\u3002<br \/>\n\u8fd9\u6b21\u6211\u4eec\u4f7f\u7528Hibernate ORM\u57fa\u4e8e\u6570\u636e\u5e93\u8868\u5b9a\u4e49\u6765\u751f\u6210\u5b83\u3002<\/p>\n<h2>\u6d4b\u8bd5\u7c7b\u7684\u5b9e\u73b0<\/h2>\n<h3>1. \u9879\u76ee\u63a7\u5236\u5668\u6d4b\u8bd5.java<\/h3>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.app.controller<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">hamcrest<\/span><span class=\"o\">.<\/span><span class=\"na\">Matchers<\/span><span class=\"o\">.*;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">mockito<\/span><span class=\"o\">.<\/span><span class=\"na\">Mockito<\/span><span class=\"o\">.*;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">springframework<\/span><span class=\"o\">.<\/span><span class=\"na\">test<\/span><span class=\"o\">.<\/span><span class=\"na\">web<\/span><span class=\"o\">.<\/span><span class=\"na\">servlet<\/span><span class=\"o\">.<\/span><span class=\"na\">request<\/span><span class=\"o\">.<\/span><span class=\"na\">MockMvcRequestBuilders<\/span><span class=\"o\">.*;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">springframework<\/span><span class=\"o\">.<\/span><span class=\"na\">test<\/span><span class=\"o\">.<\/span><span class=\"na\">web<\/span><span class=\"o\">.<\/span><span class=\"na\">servlet<\/span><span class=\"o\">.<\/span><span class=\"na\">result<\/span><span class=\"o\">.<\/span><span class=\"na\">MockMvcResultMatchers<\/span><span class=\"o\">.*;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.ArrayList<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.List<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.junit.jupiter.api.BeforeEach<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.junit.jupiter.api.Test<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.mockito.InjectMocks<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.mockito.Mock<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.mockito.MockitoAnnotations<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.http.MediaType<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.test.web.servlet.MockMvc<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.test.web.servlet.setup.MockMvcBuilders<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.RestController<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.model.Item<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.service.ItemService<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">lombok.RequiredArgsConstructor<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@RestController<\/span>\r\n<span class=\"nd\">@RequiredArgsConstructor<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">ItemControllerTest<\/span> <span class=\"o\">{<\/span>\r\n\r\n    <span class=\"nc\">MockMvc<\/span> <span class=\"n\">mockMvc<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@Mock<\/span> <span class=\"c1\">\/\/ \u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b\u3053\u3068\u3092\u5ba3\u8a00<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">ItemService<\/span> <span class=\"n\">itemService<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@InjectMocks<\/span> <span class=\"c1\">\/\/ \u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u6ce8\u5165<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">ItemController<\/span> <span class=\"n\">itemController<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@BeforeEach<\/span> <span class=\"c1\">\/\/ \u30c6\u30b9\u30c8\u30e1\u30bd\u30c3\u30c9\uff08@Test\u3092\u3064\u3051\u305f\u30e1\u30bd\u30c3\u30c9\uff09\u5b9f\u884c\u524d\u306b\u90fd\u5ea6\u5b9f\u65bd<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">initmocks<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"nc\">MockitoAnnotations<\/span><span class=\"o\">.<\/span><span class=\"na\">initMocks<\/span><span class=\"o\">(<\/span><span class=\"k\">this<\/span><span class=\"o\">);<\/span> <span class=\"c1\">\/\/ \u30a2\u30ce\u30c6\u30fc\u30b7\u30e7\u30f3\u306e\u6709\u52b9\u5316<\/span>\r\n        <span class=\"n\">mockMvc<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">MockMvcBuilders<\/span><span class=\"o\">.<\/span><span class=\"na\">standaloneSetup<\/span><span class=\"o\">(<\/span><span class=\"n\">itemController<\/span><span class=\"o\">).<\/span><span class=\"na\">build<\/span><span class=\"o\">();<\/span> <span class=\"c1\">\/\/ MockMvc\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Test<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">test_getItemsByGet<\/span><span class=\"o\">()<\/span> <span class=\"kd\">throws<\/span> <span class=\"nc\">Exception<\/span> <span class=\"o\">{<\/span>\r\n\r\n        <span class=\"n\">when<\/span><span class=\"o\">(<\/span><span class=\"n\">itemService<\/span><span class=\"o\">.<\/span><span class=\"na\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">)).<\/span><span class=\"na\">thenReturn<\/span><span class=\"o\">(<\/span><span class=\"n\">getItemIdOfItemId1<\/span><span class=\"o\">());<\/span> <span class=\"c1\">\/\/ itemService.findByItemId(1)\u5b9f\u884c\u6642\u306bgetItemIdOfItemId1()\u306e\u7d50\u679c\u304c\u8fd4\u308b\u3053\u3068\u3092\u5b9a\u7fa9<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">mockMvc<\/span><span class=\"o\">.<\/span><span class=\"na\">perform<\/span><span class=\"o\">(<\/span><span class=\"n\">get<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\/item\/{itemId}\"<\/span><span class=\"o\">,<\/span> <span class=\"mi\">1<\/span><span class=\"o\">))<\/span> <span class=\"c1\">\/\/ @GetMapping(\"\/item\/{itemId}\")\u306e\u30e1\u30bd\u30c3\u30c9\u306e\u5b9f\u884c\u3068\u7d50\u679c\u78ba\u8a8d<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">status<\/span><span class=\"o\">().<\/span><span class=\"na\">isOk<\/span><span class=\"o\">())<\/span> <span class=\"c1\">\/\/ \u4ee5\u4e0b\u3001\u7d50\u679c\u78ba\u8a8d<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.item.itemId\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.item.itemName\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.item.itemExplanation\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb1\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.item.categoryId\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">));<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Test<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">test_getItemsByPost<\/span><span class=\"o\">()<\/span> <span class=\"kd\">throws<\/span> <span class=\"nc\">Exception<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"n\">when<\/span><span class=\"o\">(<\/span><span class=\"n\">itemService<\/span><span class=\"o\">.<\/span><span class=\"na\">findByCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">)).<\/span><span class=\"na\">thenReturn<\/span><span class=\"o\">(<\/span><span class=\"n\">getItemIdOfCategory1<\/span><span class=\"o\">());<\/span> <span class=\"c1\">\/\/ findByCategoryId(1)\u5b9f\u884c\u6642\u306bgetItemIdOfCategory1()\u306e\u7d50\u679c\u304c\u8fd4\u308b\u3053\u3068\u3092\u5b9a\u7fa9<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">mockMvc<\/span><span class=\"o\">.<\/span><span class=\"na\">perform<\/span><span class=\"o\">(<\/span><span class=\"n\">post<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\/items\"<\/span><span class=\"o\">).<\/span><span class=\"na\">contentType<\/span><span class=\"o\">(<\/span><span class=\"nc\">MediaType<\/span><span class=\"o\">.<\/span><span class=\"na\">APPLICATION_JSON<\/span><span class=\"o\">).<\/span><span class=\"na\">content<\/span><span class=\"o\">(<\/span><span class=\"s\">\"{\\\"categoryId\\\":\\\"1\\\"}\"<\/span><span class=\"o\">))<\/span> <span class=\"c1\">\/\/ RequestBody\u306e\u8981\u7d20\u306e\u578b\u3068\u5024\u3092\u8a2d\u5b9a<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.items\"<\/span><span class=\"o\">,<\/span> <span class=\"n\">hasSize<\/span><span class=\"o\">(<\/span><span class=\"mi\">2<\/span><span class=\"o\">)))<\/span> <span class=\"c1\">\/\/ \u4ee5\u4e0b\u3001\u7d50\u679c\u78ba\u8a8d<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">status<\/span><span class=\"o\">().<\/span><span class=\"na\">isOk<\/span><span class=\"o\">())<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.items[0].itemId\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.items[0].itemName\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.items[0].itemExplanation\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb1\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.items[0].categoryId\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.items[1].itemId\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"mi\">2<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.items[1].itemName\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30aa\u30dc\u30f3\u306e\u307f\"<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.items[1].itemExplanation\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"s\">\"HP\u3092\u3059\u3053\u3057\u3060\u3051\u304b\u3044\u3075\u304f\u3059\u308b\u3002\"<\/span><span class=\"o\">))<\/span>\r\n                <span class=\"o\">.<\/span><span class=\"na\">andExpect<\/span><span class=\"o\">(<\/span><span class=\"n\">jsonPath<\/span><span class=\"o\">(<\/span><span class=\"s\">\"$.items[1].categoryId\"<\/span><span class=\"o\">).<\/span><span class=\"na\">value<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">));<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">Item<\/span> <span class=\"nf\">getItemIdOfItemId1<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n\r\n        <span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb1\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"k\">return<\/span> <span class=\"n\">item<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"nf\">getItemIdOfCategory1<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n\r\n        <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">items<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">ArrayList<\/span><span class=\"o\">&lt;&gt;();<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item1<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb1\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item2<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">2<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30aa\u30dc\u30f3\u306e\u307f\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"HP\u3092\u3059\u3053\u3057\u3060\u3051\u304b\u3044\u3075\u304f\u3059\u308b\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">add<\/span><span class=\"o\">(<\/span><span class=\"n\">item1<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">add<\/span><span class=\"o\">(<\/span><span class=\"n\">item2<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"k\">return<\/span> <span class=\"n\">items<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"o\">}<\/span>\r\n\r\n<span class=\"o\">}<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0b\u662fController\u7c7b\u7684\u6d4b\u8bd5\u3002<br \/>\n\u7531\u4e8e\u4f7f\u7528\u4e86@RestController\u6ce8\u89e3\uff0c\u6240\u4ee5\u91cd\u70b9\u662f\u4ee5JSON\u683c\u5f0f\u8fdb\u884c\u4ea4\u4e92\u3002<br \/>\n\u6d4b\u8bd5\u4ee3\u7801\u672c\u8eab\u4e5f\u9700\u8981\u4e0e\u76f8\u5e94\u7684\u5185\u5bb9\u76f8\u5339\u914d\u3002<\/p>\n<h3>2. ItemServiceTest.java\u6587\u4ef6<\/h3>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.service<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">hamcrest<\/span><span class=\"o\">.<\/span><span class=\"na\">MatcherAssert<\/span><span class=\"o\">.*;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">hamcrest<\/span><span class=\"o\">.<\/span><span class=\"na\">Matchers<\/span><span class=\"o\">.*;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">mockito<\/span><span class=\"o\">.<\/span><span class=\"na\">Mockito<\/span><span class=\"o\">.*;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.ArrayList<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.List<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.junit.jupiter.api.BeforeEach<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.junit.jupiter.api.Test<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.mockito.InjectMocks<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.mockito.Mock<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.mockito.MockitoAnnotations<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.model.Item<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.repository.ItemRepository<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">ItemServiceTest<\/span> <span class=\"o\">{<\/span>\r\n\r\n    <span class=\"nd\">@Mock<\/span>   <span class=\"c1\">\/\/ \u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b\u3053\u3068\u3092\u5ba3\u8a00<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">ItemRepository<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@InjectMocks<\/span>    <span class=\"c1\">\/\/ \u30e2\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u6ce8\u5165<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">ItemService<\/span> <span class=\"n\">itemService<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@BeforeEach<\/span> <span class=\"c1\">\/\/ \u30c6\u30b9\u30c8\u30e1\u30bd\u30c3\u30c9\uff08@Test\u3092\u3064\u3051\u305f\u30e1\u30bd\u30c3\u30c9\uff09\u5b9f\u884c\u524d\u306b\u90fd\u5ea6\u5b9f\u65bd<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">initmocks<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"nc\">MockitoAnnotations<\/span><span class=\"o\">.<\/span><span class=\"na\">initMocks<\/span><span class=\"o\">(<\/span><span class=\"k\">this<\/span><span class=\"o\">);<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Test<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">test_findByItemId<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n\r\n        <span class=\"n\">when<\/span><span class=\"o\">(<\/span><span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">100<\/span><span class=\"o\">)).<\/span><span class=\"na\">thenReturn<\/span><span class=\"o\">(<\/span><span class=\"n\">getItemId100<\/span><span class=\"o\">());<\/span> <span class=\"c1\">\/\/ itemRepository.findByItemId(100)\u5b9f\u884c\u6642\u306bgetItemId100()\u306e\u7d50\u679c\u304c\u8fd4\u308b\u3053\u3068\u3092\u5b9a\u7fa9<\/span>\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">100<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"c1\">\/\/ \u4ee5\u4e0b\u3001\u7d50\u679c\u78ba\u8a8d<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">100<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemName<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u8d85\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemExplanation<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb100\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">getCategoryId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">));<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Test<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">test_findByCategoryId<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n\r\n        <span class=\"n\">when<\/span><span class=\"o\">(<\/span><span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">10<\/span><span class=\"o\">)).<\/span><span class=\"na\">thenReturn<\/span><span class=\"o\">(<\/span><span class=\"n\">getItemIdOfCategory10<\/span><span class=\"o\">());<\/span>  <span class=\"c1\">\/\/ itemRepository.findByCategoryId(10)\u5b9f\u884c\u6642\u306bgetItemIdOfCategory10()\u306e\u7d50\u679c\u304c\u8fd4\u308b\u3053\u3068\u3092\u5b9a\u7fa9<\/span>\r\n        <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">items<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">10<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"c1\">\/\/ \u4ee5\u4e0b\u3001\u7d50\u679c\u78ba\u8a8d<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">0<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">0<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemName<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">0<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemExplanation<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb1\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">0<\/span><span class=\"o\">).<\/span><span class=\"na\">getCategoryId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">));<\/span>\r\n\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">2<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemName<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30aa\u30dc\u30f3\u306e\u307f\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemExplanation<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"HP\u3092\u3059\u3053\u3057\u3060\u3051\u304b\u3044\u3075\u304f\u3059\u308b\u3002\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">).<\/span><span class=\"na\">getCategoryId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">));<\/span>\r\n\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">Item<\/span> <span class=\"nf\">getItemId100<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">100<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u8d85\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb100\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"k\">return<\/span> <span class=\"n\">item<\/span><span class=\"o\">;<\/span>\r\n\r\n\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"nf\">getItemIdOfCategory10<\/span><span class=\"o\">(){<\/span>\r\n\r\n\r\n        <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">items<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">ArrayList<\/span><span class=\"o\">&lt;&gt;();<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item1<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb1\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item2<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">2<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30aa\u30dc\u30f3\u306e\u307f\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"HP\u3092\u3059\u3053\u3057\u3060\u3051\u304b\u3044\u3075\u304f\u3059\u308b\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">add<\/span><span class=\"o\">(<\/span><span class=\"n\">item1<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">items<\/span><span class=\"o\">.<\/span><span class=\"na\">add<\/span><span class=\"o\">(<\/span><span class=\"n\">item2<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"k\">return<\/span> <span class=\"n\">items<\/span><span class=\"o\">;<\/span>\r\n\r\n\r\n    <span class=\"o\">}<\/span>\r\n\r\n<span class=\"o\">}<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u5728Controller\u7c7b\u7684\u6d4b\u8bd5\u4e2d\u4e5f\u4f7f\u7528\u4e86Mockito\uff0c\u4f7f\u7528Mockito\u6765\u5b9a\u4e49\u4e0b\u5c42\u7684Repository\u7c7b\u7684\u8fd4\u56de\u503c\u662f\u91cd\u70b9\u3002<\/p>\n<h3>3. ItemRepositoryTest.java\u6d4b\u8bd5\u6587\u4ef6<\/h3>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.repository<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">hamcrest<\/span><span class=\"o\">.<\/span><span class=\"na\">MatcherAssert<\/span><span class=\"o\">.*;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">hamcrest<\/span><span class=\"o\">.<\/span><span class=\"na\">Matchers<\/span><span class=\"o\">.*;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.io.File<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.io.FileInputStream<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.io.FileOutputStream<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.sql.Connection<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.sql.PreparedStatement<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.sql.ResultSet<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.ArrayList<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.List<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.dbunit.database.DatabaseConnection<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.dbunit.database.IDatabaseConnection<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.dbunit.database.QueryDataSet<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.dbunit.dataset.IDataSet<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.dbunit.dataset.excel.XlsDataSet<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.dbunit.dataset.xml.FlatXmlDataSet<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.dbunit.dataset.xml.FlatXmlDataSetBuilder<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.dbunit.operation.DatabaseOperation<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.junit.jupiter.api.Test<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.beans.factory.annotation.Autowired<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.boot.test.context.SpringBootTest<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.jdbc.core.JdbcTemplate<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.test.context.transaction.AfterTransaction<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.test.context.transaction.BeforeTransaction<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.transaction.annotation.Transactional<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">jp.co.spring_boot_test_item.domain.model.Item<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@SpringBootTest<\/span>\r\n<span class=\"nd\">@Transactional<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">ItemRepositoryTest<\/span> <span class=\"o\">{<\/span>\r\n\r\n\r\n    <span class=\"nd\">@Autowired<\/span>\r\n    <span class=\"nc\">JdbcTemplate<\/span> <span class=\"n\">jdbctemplate<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@Autowired<\/span>\r\n    <span class=\"nc\">ItemRepository<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nc\">String<\/span> <span class=\"n\">item_id_str<\/span> <span class=\"o\">=<\/span> <span class=\"kc\">null<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nc\">Integer<\/span> <span class=\"n\">item_id_num<\/span> <span class=\"o\">=<\/span> <span class=\"kc\">null<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">File<\/span> <span class=\"n\">file<\/span> <span class=\"o\">=<\/span> <span class=\"kc\">null<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">FileOutputStream<\/span> <span class=\"n\">out<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">FileInputStream<\/span> <span class=\"n\">in<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nc\">File<\/span> <span class=\"n\">tempDir<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">File<\/span><span class=\"o\">(<\/span><span class=\"s\">\"src\/test\/java\/jp\/co\/spring_boot_test_item\/domain\/repository\"<\/span><span class=\"o\">);<\/span>\r\n\r\n    <span class=\"nd\">@BeforeTransaction<\/span> <span class=\"c1\">\/\/ \u5404@Transactional\u5b9f\u884c\u524d\u306b\u90fd\u5ea6\u5b9f\u65bd<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">initdb<\/span><span class=\"o\">()<\/span> <span class=\"kd\">throws<\/span> <span class=\"nc\">Exception<\/span><span class=\"o\">{<\/span>\r\n        <span class=\"nc\">Connection<\/span> <span class=\"n\">connection<\/span> <span class=\"o\">=<\/span> <span class=\"n\">jdbctemplate<\/span><span class=\"o\">.<\/span><span class=\"na\">getDataSource<\/span><span class=\"o\">().<\/span><span class=\"na\">getConnection<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"nc\">IDatabaseConnection<\/span> <span class=\"n\">dbconnection<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">DatabaseConnection<\/span><span class=\"o\">(<\/span><span class=\"n\">connection<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"k\">try<\/span> <span class=\"o\">{<\/span>\r\n\r\n            <span class=\"c1\">\/\/ AUTO_INCREMENT\u306e\u73fe\u5728\u5024\u3092\u53d6\u5f97<\/span>\r\n            <span class=\"nc\">String<\/span> <span class=\"n\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"SHOW TABLE STATUS where  name = 'items'\"<\/span><span class=\"o\">;<\/span>\r\n            <span class=\"nc\">PreparedStatement<\/span> <span class=\"n\">statement<\/span> <span class=\"o\">=<\/span> <span class=\"n\">connection<\/span><span class=\"o\">.<\/span><span class=\"na\">prepareStatement<\/span><span class=\"o\">(<\/span><span class=\"n\">sql<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"nc\">ResultSet<\/span> <span class=\"n\">result<\/span> <span class=\"o\">=<\/span> <span class=\"n\">statement<\/span><span class=\"o\">.<\/span><span class=\"na\">executeQuery<\/span><span class=\"o\">();<\/span>\r\n            <span class=\"k\">while<\/span> <span class=\"o\">(<\/span><span class=\"n\">result<\/span><span class=\"o\">.<\/span><span class=\"na\">next<\/span><span class=\"o\">())<\/span> <span class=\"o\">{<\/span>\r\n                <span class=\"n\">item_id_str<\/span> <span class=\"o\">=<\/span> <span class=\"n\">result<\/span><span class=\"o\">.<\/span><span class=\"na\">getString<\/span><span class=\"o\">(<\/span><span class=\"s\">\"Auto_increment\"<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"o\">}<\/span>\r\n\r\n            <span class=\"c1\">\/\/ items\u30c6\u30fc\u30d6\u30eb\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u53d6\u5f97<\/span>\r\n            <span class=\"nc\">QueryDataSet<\/span> <span class=\"n\">partialDataSet<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">QueryDataSet<\/span><span class=\"o\">(<\/span><span class=\"n\">dbconnection<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"n\">partialDataSet<\/span><span class=\"o\">.<\/span><span class=\"na\">addTable<\/span><span class=\"o\">(<\/span><span class=\"s\">\"items\"<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"n\">file<\/span><span class=\"o\">=<\/span><span class=\"nc\">File<\/span><span class=\"o\">.<\/span><span class=\"na\">createTempFile<\/span><span class=\"o\">(<\/span><span class=\"s\">\"items\"<\/span><span class=\"o\">,<\/span><span class=\"s\">\".xml\"<\/span><span class=\"o\">,<\/span> <span class=\"n\">tempDir<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"n\">out<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">FileOutputStream<\/span><span class=\"o\">(<\/span><span class=\"n\">file<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"nc\">FlatXmlDataSet<\/span><span class=\"o\">.<\/span><span class=\"na\">write<\/span><span class=\"o\">(<\/span><span class=\"n\">partialDataSet<\/span><span class=\"o\">,<\/span> <span class=\"n\">out<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"n\">out<\/span><span class=\"o\">.<\/span><span class=\"na\">flush<\/span><span class=\"o\">();<\/span>\r\n            <span class=\"n\">out<\/span><span class=\"o\">.<\/span><span class=\"na\">close<\/span><span class=\"o\">();<\/span>\r\n\r\n            <span class=\"c1\">\/\/ DB\u306e\u5024\u3092\u524a\u9664\u3057\u3001\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3092\u6295\u5165\u3059\u308b\uff08Excel\u30d5\u30a1\u30a4\u30eb\u306e\u30d1\u30b9\u306fItemRepositoryTest.java\u3068\u540c\u968e\u5c64\uff09<\/span>\r\n            <span class=\"nc\">IDataSet<\/span> <span class=\"n\">dataset<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">XlsDataSet<\/span><span class=\"o\">(<\/span><span class=\"k\">new<\/span> <span class=\"nc\">File<\/span><span class=\"o\">(<\/span><span class=\"s\">\"src\/test\/java\/jp\/co\/spring_boot_test_item\/domain\/repository\/ItemRepositoryTest.xlsx\"<\/span><span class=\"o\">));<\/span>\r\n            <span class=\"nc\">DatabaseOperation<\/span><span class=\"o\">.<\/span><span class=\"na\">CLEAN_INSERT<\/span><span class=\"o\">.<\/span><span class=\"na\">execute<\/span><span class=\"o\">(<\/span><span class=\"n\">dbconnection<\/span><span class=\"o\">,<\/span> <span class=\"n\">dataset<\/span><span class=\"o\">);<\/span>      \r\n\r\n        <span class=\"o\">}<\/span><span class=\"k\">catch<\/span><span class=\"o\">(<\/span><span class=\"nc\">Exception<\/span> <span class=\"n\">e<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n            <span class=\"n\">e<\/span><span class=\"o\">.<\/span><span class=\"na\">printStackTrace<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"o\">}<\/span><span class=\"k\">finally<\/span> <span class=\"o\">{<\/span>\r\n\r\n            <span class=\"n\">connection<\/span><span class=\"o\">.<\/span><span class=\"na\">close<\/span><span class=\"o\">();<\/span>\r\n            <span class=\"n\">dbconnection<\/span><span class=\"o\">.<\/span><span class=\"na\">close<\/span><span class=\"o\">();<\/span>\r\n\r\n        <span class=\"o\">}<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n\r\n    <span class=\"nd\">@AfterTransaction<\/span>   <span class=\"c1\">\/\/ \u5404@Transactional\u5b9f\u884c\u5f8c\u306b\u90fd\u5ea6\u5b9f\u65bd<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">teardown<\/span><span class=\"o\">()<\/span> <span class=\"kd\">throws<\/span> <span class=\"nc\">Exception<\/span><span class=\"o\">{<\/span>\r\n        <span class=\"nc\">Connection<\/span> <span class=\"n\">connection<\/span> <span class=\"o\">=<\/span> <span class=\"n\">jdbctemplate<\/span><span class=\"o\">.<\/span><span class=\"na\">getDataSource<\/span><span class=\"o\">().<\/span><span class=\"na\">getConnection<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"nc\">IDatabaseConnection<\/span> <span class=\"n\">dbconnection<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">DatabaseConnection<\/span><span class=\"o\">(<\/span><span class=\"n\">connection<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"k\">try<\/span> <span class=\"o\">{<\/span>\r\n\r\n            <span class=\"c1\">\/\/ \u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u306e\u5185\u5bb9\u3092\u623b\u3059<\/span>\r\n            <span class=\"n\">in<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">FileInputStream<\/span><span class=\"o\">(<\/span><span class=\"n\">file<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"nc\">IDataSet<\/span> <span class=\"n\">dataSet<\/span><span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">FlatXmlDataSetBuilder<\/span><span class=\"o\">().<\/span><span class=\"na\">build<\/span><span class=\"o\">(<\/span><span class=\"n\">in<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"nc\">DatabaseOperation<\/span><span class=\"o\">.<\/span><span class=\"na\">CLEAN_INSERT<\/span><span class=\"o\">.<\/span><span class=\"na\">execute<\/span><span class=\"o\">(<\/span><span class=\"n\">dbconnection<\/span><span class=\"o\">,<\/span><span class=\"n\">dataSet<\/span><span class=\"o\">);<\/span>\r\n\r\n            <span class=\"c1\">\/\/ AUTO_INCREMENT\u3092\u30c6\u30b9\u30c8\u5b9f\u884c\u524d\u306e\u5024\u306b\u623b\u3059<\/span>\r\n            <span class=\"nc\">String<\/span> <span class=\"n\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">StringBuilder<\/span><span class=\"o\">(<\/span><span class=\"s\">\"ALTER TABLE items AUTO_INCREMENT=\"<\/span><span class=\"o\">).<\/span><span class=\"na\">append<\/span><span class=\"o\">(<\/span><span class=\"n\">item_id_str<\/span><span class=\"o\">).<\/span><span class=\"na\">toString<\/span><span class=\"o\">();<\/span>\r\n            <span class=\"nc\">PreparedStatement<\/span> <span class=\"n\">statement<\/span> <span class=\"o\">=<\/span> <span class=\"n\">connection<\/span><span class=\"o\">.<\/span><span class=\"na\">prepareStatement<\/span><span class=\"o\">(<\/span><span class=\"n\">sql<\/span><span class=\"o\">);<\/span>\r\n            <span class=\"n\">statement<\/span><span class=\"o\">.<\/span><span class=\"na\">executeUpdate<\/span><span class=\"o\">();<\/span>\r\n\r\n        <span class=\"o\">}<\/span><span class=\"k\">catch<\/span><span class=\"o\">(<\/span><span class=\"nc\">Exception<\/span> <span class=\"n\">e<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n            <span class=\"n\">e<\/span><span class=\"o\">.<\/span><span class=\"na\">printStackTrace<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"o\">}<\/span><span class=\"k\">finally<\/span> <span class=\"o\">{<\/span>\r\n            <span class=\"n\">connection<\/span><span class=\"o\">.<\/span><span class=\"na\">close<\/span><span class=\"o\">();<\/span>\r\n            <span class=\"n\">dbconnection<\/span><span class=\"o\">.<\/span><span class=\"na\">close<\/span><span class=\"o\">();<\/span>\r\n            <span class=\"n\">file<\/span><span class=\"o\">.<\/span><span class=\"na\">deleteOnExit<\/span><span class=\"o\">();<\/span>    <span class=\"c1\">\/\/ DB\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u306e\u524a\u9664<\/span>\r\n        <span class=\"o\">}<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Test<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">test_findByItemId<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">expectedItem<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">actualItem<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">actualItem<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">actualItem<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemName<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">actualItem<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemExplanation<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb1\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">actualItem<\/span><span class=\"o\">.<\/span><span class=\"na\">getCategoryId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">));<\/span>\r\n\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Test<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">test_findByCategoryId<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item1<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3057\u304e\u306a\u30a2\u30e1\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"o\">;<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30ec\u30d9\u30eb1\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item2<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">4<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30aa\u30dc\u30f3\u306e\u307f\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"HP\u3092\u3059\u3053\u3057\u3060\u3051\u304b\u3044\u3075\u304f\u3059\u308b\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">expectedItems<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">ArrayList<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;();<\/span>\r\n        <span class=\"n\">expectedItems<\/span><span class=\"o\">.<\/span><span class=\"na\">add<\/span><span class=\"o\">(<\/span><span class=\"n\">item1<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">expectedItems<\/span><span class=\"o\">.<\/span><span class=\"na\">add<\/span><span class=\"o\">(<\/span><span class=\"n\">item2<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Item<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">actualItems<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">actualItems<\/span><span class=\"o\">,<\/span> <span class=\"n\">hasSize<\/span><span class=\"o\">(<\/span><span class=\"mi\">2<\/span><span class=\"o\">));<\/span>\r\n\r\n        <span class=\"k\">for<\/span> <span class=\"o\">(<\/span><span class=\"kt\">int<\/span> <span class=\"n\">i<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span><span class=\"o\">;<\/span> <span class=\"n\">i<\/span> <span class=\"o\">&lt;<\/span> <span class=\"n\">actualItems<\/span><span class=\"o\">.<\/span><span class=\"na\">size<\/span><span class=\"o\">();<\/span> <span class=\"n\">i<\/span><span class=\"o\">++)<\/span> <span class=\"o\">{<\/span>\r\n            <span class=\"k\">for<\/span> <span class=\"o\">(<\/span><span class=\"kt\">int<\/span> <span class=\"n\">j<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span><span class=\"o\">;<\/span> <span class=\"n\">j<\/span> <span class=\"o\">&lt;<\/span> <span class=\"n\">expectedItems<\/span><span class=\"o\">.<\/span><span class=\"na\">size<\/span><span class=\"o\">();<\/span> <span class=\"n\">j<\/span><span class=\"o\">++)<\/span> <span class=\"o\">{<\/span>\r\n                <span class=\"k\">if<\/span> <span class=\"o\">(<\/span><span class=\"n\">actualItems<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"n\">i<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemId<\/span><span class=\"o\">()<\/span> <span class=\"o\">==<\/span> <span class=\"n\">expectedItems<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"n\">j<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemId<\/span><span class=\"o\">())<\/span> <span class=\"o\">{<\/span>\r\n                    <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">actualItems<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"n\">i<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemName<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"n\">expectedItems<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"n\">j<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemName<\/span><span class=\"o\">()));<\/span>\r\n                    <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">actualItems<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"n\">i<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemExplanation<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"n\">expectedItems<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"n\">j<\/span><span class=\"o\">).<\/span><span class=\"na\">getItemExplanation<\/span><span class=\"o\">()));<\/span>\r\n                    <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">actualItems<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"n\">i<\/span><span class=\"o\">).<\/span><span class=\"na\">getCategoryId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"n\">expectedItems<\/span><span class=\"o\">.<\/span><span class=\"na\">get<\/span><span class=\"o\">(<\/span><span class=\"n\">j<\/span><span class=\"o\">).<\/span><span class=\"na\">getCategoryId<\/span><span class=\"o\">()));<\/span>\r\n                    <span class=\"k\">break<\/span><span class=\"o\">;<\/span>\r\n                <span class=\"o\">}<\/span>\r\n            <span class=\"o\">}<\/span>\r\n        <span class=\"o\">}<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Test<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">test_save<\/span><span class=\"o\">()<\/span>  <span class=\"kd\">throws<\/span> <span class=\"nc\">Exception<\/span><span class=\"o\">{<\/span>\r\n\r\n        <span class=\"c1\">\/\/ \u66f4\u65b0<\/span>\r\n        <span class=\"nc\">Item<\/span> <span class=\"nc\">Item1<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"nc\">Item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"nc\">Item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3064\u3046\u306e\u30a2\u30e1\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"nc\">Item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"20kcal\u6442\u53d6\u3067\u304d\u307e\u3059\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"nc\">Item1<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">3<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">save<\/span><span class=\"o\">(<\/span><span class=\"nc\">Item1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"c1\">\/\/ \u8ffd\u52a0<\/span>\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">item2<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Item<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemName<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30da\u30ed\u30da\u30ed\u30ad\u30e3\u30f3\u30c7\u30a3\u30fc\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setItemExplanation<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u5b50\u3069\u3082\u306b\u3042\u3052\u308b\u3068\u559c\u3070\u308c\u307e\u3059\uff08\u305f\u3076\u3093\uff09\u3002\"<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"n\">item2<\/span><span class=\"o\">.<\/span><span class=\"na\">setCategoryId<\/span><span class=\"o\">(<\/span><span class=\"mi\">3<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">save<\/span><span class=\"o\">(<\/span><span class=\"n\">item2<\/span><span class=\"o\">);<\/span>\r\n\r\n\r\n         <span class=\"c1\">\/\/ DB\u306e\u5024\u306e\u78ba\u8a8d\uff08\u66f4\u65b0\u5206\uff09<\/span>\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">dbItem1<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">dbItem1<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">1<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">dbItem1<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemName<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u3075\u3064\u3046\u306e\u30a2\u30e1\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">dbItem1<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemExplanation<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"20kcal\u6442\u53d6\u3067\u304d\u307e\u3059\u3002\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">dbItem1<\/span><span class=\"o\">.<\/span><span class=\"na\">getCategoryId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">3<\/span><span class=\"o\">));<\/span>\r\n\r\n        <span class=\"c1\">\/\/ DB\u306e\u5024\u306e\u78ba\u8a8d\uff08\u8ffd\u52a0\u5206\uff09<\/span>\r\n        <span class=\"n\">item_id_num<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">Integer<\/span><span class=\"o\">.<\/span><span class=\"na\">valueOf<\/span><span class=\"o\">(<\/span><span class=\"n\">item_id_str<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"nc\">Item<\/span> <span class=\"n\">dbItem2<\/span> <span class=\"o\">=<\/span> <span class=\"n\">itemRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findByItemId<\/span><span class=\"o\">(<\/span><span class=\"n\">item_id_num<\/span><span class=\"o\">);<\/span>\r\n\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">dbItem2<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"n\">item_id_num<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">dbItem2<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemName<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u30da\u30ed\u30da\u30ed\u30ad\u30e3\u30f3\u30c7\u30a3\u30fc\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">dbItem2<\/span><span class=\"o\">.<\/span><span class=\"na\">getItemExplanation<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\u5b50\u3069\u3082\u306b\u3042\u3052\u308b\u3068\u559c\u3070\u308c\u307e\u3059\uff08\u305f\u3076\u3093\uff09\u3002\"<\/span><span class=\"o\">));<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">dbItem2<\/span><span class=\"o\">.<\/span><span class=\"na\">getCategoryId<\/span><span class=\"o\">(),<\/span> <span class=\"n\">is<\/span><span class=\"o\">(<\/span><span class=\"mi\">3<\/span><span class=\"o\">));<\/span>\r\n\r\n    <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u8fd9\u662f\u4e00\u4e2a Repository \u7c7b\u7684\u6d4b\u8bd5\u3002<br \/>\n\u91cd\u70b9\u6709\u4ee5\u4e0b\u4e24\u4e2a\u3002<br \/>\n1. \u66ff\u4ee3\u4f7f\u7528 @Mock\uff0c\u800c\u662f\u5728\u7c7b\u4e0a\u6dfb\u52a0 @SpringBootTest \u6ce8\u89e3\u3002<br \/>\n\u901a\u8fc7 DBUnit \u7684\u529f\u80fd\uff0c\u5728\u6d4b\u8bd5\u65b9\u6cd5\u6267\u884c\u524d\u540e\uff0c\u4f1a\u8fdb\u884c\u6d4b\u8bd5\u6570\u636e\u548c\u6570\u636e\u5e93\u6570\u636e\u7684\u4e92\u6362\u3002<br \/>\n2. \u7531\u4e8e\u662f\u4f7f\u7528 @Transactional \u8fdb\u884c\u7684\u6d4b\u8bd5\uff0c\u6240\u4ee5\u5728\u6d4b\u8bd5\u6267\u884c\u524d\u540e\uff0c\u4f7f\u7528 @BeforeTransaction\/@AfterTransaction\uff0c\u800c\u4e0d\u662f @BeforeEach\/@AfterEach\uff08\u5426\u5219\u5728\u7279\u5b9a\u7684 CUD \u7c7b\u578b\u64cd\u4f5c\u65f6\uff0c\u53ef\u80fd\u4f1a\u51fa\u73b0\u4e8b\u52a1\u9501\u7684\u53ef\u80fd\u6027\uff09\u3002<\/p>\n<p>\u8fd9\u6b21\uff0c\u6211\u5728\u4e0a\u4e00\u5c42\u6ca1\u6709\u4f7f\u7528\uff0c\u4f46\u662f\u6211\u4e5f\u5199\u4e86\u63d2\u5165\u548c\u66f4\u65b0\uff08insert, update\uff09\u76f8\u5173\u7684\u4ee3\u7801\uff0c\u5e76\u5728\u6d4b\u8bd5\u540e\u52a0\u5165\u4e86\u5c06\u6570\u636e\u5e93\u7684AUTO_INCREMENT\u8bbe\u7f6e\u56de\u4e4b\u524d\u72b6\u6001\u7684\u63cf\u8ff0\u3002<\/p>\n<h2>\u9879\u76ee\u4ed3\u5e93\u6d4b\u8bd5.xlsx<\/h2>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc737434c4406c8ff84\/48-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u8fd9\u662f\u7528\u4e8eRepository\u7c7b\u7684\u6d4b\u8bd5\u6570\u636e\u3002<br \/>\n\u8fd9\u6b21\uff0c\u6211\u4eec\u628a\u5b83\u653e\u5728ItemRepositoryTest.java\u7684\u540c\u7ea7\u76ee\u5f55\u4e0b\u6765\u4f7f\u7528\u3002<\/p>\n<p>\u5173\u952e\u662f\uff1a<br \/>\n1. \u5728\u7b2c\u4e00\u884c\u4e0a\u5199\u4e0b\u5217\u540d<br \/>\n2. \u5de5\u4f5c\u8868\u540d\u5e94\u4e0e\u8868\u540d\u76f8\u540c\uff08\u672c\u6b21\u4f7f\u7528&#8221;items&#8221;\uff09<\/p>\n<h2>\u8865\u5145\u8bf4\u660e<\/h2>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728Controller\u7c7b\u4e2d\uff0c\u6211\u4eec\u4f7f\u7528\u7684\u662f@RestController\uff0c\u800c\u4e0d\u662f\u5e26\u6709\u9875\u9762\u8f6c\u6362\u7684@Controller\uff0c\u5b83\u4e3b\u8981\u7528\u4e8eWebAPI\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\u7531\u4e8e\u6211\u4eec\u5728\u8fd9\u6b21\u91cd\u70b9\u5173\u6ce8\u5404\u4e2a\u7c7b\u7684\u5199\u6cd5\uff0c\u6240\u4ee5\u7701\u7565\u4e86\u5f02\u5e38\u548c\u9519\u8bef\u6d4b\u8bd5\u3002<\/ol>\n<h2>\u672c\u6587\u66f4\u65b0\u7eaa\u5f55<\/h2>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>2020\u5e746\u670813\u65e5\uff1a<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728GitHub\u4e0a\u6dfb\u52a0\u4e86\u4ee3\u7801 spring-boot-test-sample\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>2020\u5e746\u670815\u65e5\uff1a\u589e\u52a0\u4e86\u6709\u5173\u5b9e\u4f53\u7c7b\u548c\u670d\u52a1\u7c7b\u7684\u4e8b\u52a1\u63a7\u5236\u7684\u63cf\u8ff0\u3002<\/p>\n<h2>\u8bf7\u53c2\u8003\u6211\u4ee5\u4e0b\u6240\u63d0\u4f9b\u7684\u9009\u9879\u3002<\/h2>\n<h3>\u25a0JUnit (Java\u5355\u5143\u6d4b\u8bd5\u6846\u67b6)<\/h3>\n<h4>JUnit\u7684\u6982\u5ff5\u5168\u9762\u3002<br \/>\nor<br \/>\nJUnit\u7684\u8303\u56f4\u5f88\u5e7f\u3002<\/h4>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">JUnit5 | junit.org<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">JUnit5\u30e6\u30fc\u30b6\u30fc\u30ac\u30a4\u30c9<\/ul>\n<h4>\u5e94\u7528\u7a0b\u5e8f.yml\u6587\u4ef6\u7684\u914d\u7f6e<\/h4>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Spring Boot 1.5\u21922.1 \u306b\u79fb\u884c\u3057\u305f\u3068\u304d\u306e\u304a\u8a71 | Qiita<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Spring Boot 2.1 \u3067\u30c6\u30b9\u30c8\u6642 @Bean \u3092\u633f\u3052\u66ff\u3048\u305f\u304b\u3063\u305f | Qiita<\/ul>\n<h4>build.gradle\u6587\u4ef6\u7684\u914d\u7f6e<\/h4>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Testing in Java &amp; JVM projects | Gradle6.4.1<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Gradle\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067spring-boot-starter-test\u306bJUnit5\u3092\u5c0e\u5165\u3059\u308b\u3068\u304d\u306e\u7af6\u5408\u3092\u89e3\u6c7a\u3059\u308b | Qiita<\/ul>\n<h4>\u8fdb\u884c\u6807\u6ce8<\/h4>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">JUnit 4\u304b\u3089JUnit 5\u306b\u79fb\u884c\u3059\u308b | Qiita<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Eclipse \u3092\u4f7f\u3063\u3066 JUnit5 \u3092\u5c0e\u5165\u3057\u305f\u3068\u304d\u306e\u30e1\u30e2 | Qiita<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30c6\u30b9\u30c8 | Spring<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">springboot\u306e\u30c6\u30b9\u30c8\u306b\u3064\u3044\u3066-\u5099\u5fd8\u9332- | \u5fd8\u308c\u3063\u307d\u3044\u30a8\u30f3\u30b8\u30cb\u30a2\u306e\u5099\u5fd8\u9332<\/ul>\n<h4>\u65ad\u8a00<\/h4>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">JUnit4\u3068JUnit5\u306e\u30a2\u30b5\u30fc\u30b7\u30e7\u30f3 | DMCA<\/ul>\n<\/li>\n<\/ul>\n<p>Class Assertions | junit.org<br \/>\n\u2192 JUnit5<\/p>\n<p>Class Assert | junit.org<br \/>\n\u2192 JUnit4<\/p>\n<h4>\u8003\u8bd5\u5b9e\u65bd<\/h4>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">10.2.2. \u30ec\u30a4\u30e4\u3054\u3068\u306e\u30c6\u30b9\u30c8\u5b9f\u88c5 | TERASOLUNA<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Spring Boot\u3067\u30c6\u30b9\u30c8\u3092\u66f8\u304f\u3068\u304d\u306e\u3084\u308a\u304b\u305f\u307e\u3068\u3081 | Qiita<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Spring\u3067\u5916\u90e8API\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u3059\u308b\u5834\u5408\u306e\u30c6\u30b9\u30c8 | \u58c1\u306b\u3067\u3082\u8a71\u3057\u3066\u308d<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Testing your REST controllers and clients with Spring | DIMITR.IM<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Spring Test \u2013 How to test a JSON Array in jsonPath | Mkyong.com<\/ul>\n<h3>\u25a0Mockito \u6a21\u62df\u5668<\/h3>\n<h4>\u83ab\u57fa\u6258\u7684\u4e00\u822c\u4f7f\u7528<\/h4>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">mockito.org<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u3010Java\u3011Mockito\u306e\u98f2\u307f\u65b9\uff08\u5165\u9580\uff09 | Orizuru<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Spring Boot\u3067mockito\u3092\u4f7f\u3063\u3066\u30c6\u30b9\u30c8\u3059\u308b | \u682a\u5f0f\u4f1a\u793eCONFRAGE IT\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u4e8b\u696d\u90e8<\/ul>\n<h4>MockMvc<\/h4>\n<p>\u6a21\u62dfMVC (MockMvc)<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">10.2.4.2. MockMvc | TERASOLUNA<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Spring Boot MockMvc not working test with @PathVariable [duplicate] | stack overflow<\/ul>\n<h3>\u25a0 DBUnit \u6570\u636e\u5e93\u5355\u5143\u6d4b\u8bd5\u6846\u67b6<\/h3>\n<h4>DBUnit\u5e38\u89c4<\/h4>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">DBUnit | TECHSCORE<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u3010\u8d85\u521d\u5fc3\u8005\u5411\u3051\u3011DBUnit\u8d85\u5165\u9580 | Qiita<\/ul>\n<h3>\u5176\u4ed6<\/h3>\n<h4>\u6625\u5929<\/h4>\n<ul class=\"post-ul\">Spring\u306e@Transactional(readOnly=true)\u3067\u8aad\u307f\u53d6\u308a\u5c02\u7528\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306b\u3059\u308b | \u682a\u5f0f\u4f1a\u793eCONFRAGE IT\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u4e8b\u696d\u90e8<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u8fd9\u662f\u4f7f\u7528JUnit\u548cDBUnit\u6765\u6d4b\u8bd5Spring Boot\u7684Controller\u7c7b\u3001Service\u7c7b\u548cRep [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-40327","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u3010Spring Boot\u3011\u4f7f\u7528JUnit\u00d7DBUnit\u8fdb\u884cController\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u6d4b\u8bd5 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u3010spring-boot\u3011\u4f7f\u7528junitxdbunit\u8fdb\u884ccontroller\u7c7b\u3001service\u7c7b\u548crepository\u7c7b\u7684\u6d4b\u8bd5\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010Spring Boot\u3011\u4f7f\u7528JUnit\u00d7DBUnit\u8fdb\u884cController\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u6d4b\u8bd5\" \/>\n<meta property=\"og:description\" content=\"\u8fd9\u662f\u4f7f\u7528JUnit\u548cDBUnit\u6765\u6d4b\u8bd5Spring Boot\u7684Controller\u7c7b\u3001Service\u7c7b\u548cRep [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u3010spring-boot\u3011\u4f7f\u7528junitxdbunit\u8fdb\u884ccontroller\u7c7b\u3001service\u7c7b\u548crepository\u7c7b\u7684\u6d4b\u8bd5\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-30T09:54:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T23:43:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc737434c4406c8ff84\/48-0.png\" \/>\n<meta name=\"author\" content=\"\u5b87, \u534e\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5b87, \u534e\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/\",\"name\":\"\u3010Spring Boot\u3011\u4f7f\u7528JUnit\u00d7DBUnit\u8fdb\u884cController\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u6d4b\u8bd5 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-06-30T09:54:57+00:00\",\"dateModified\":\"2024-04-29T23:43:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010Spring Boot\u3011\u4f7f\u7528JUnit\u00d7DBUnit\u8fdb\u884cController\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u6d4b\u8bd5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\",\"name\":\"\u5b87, \u534e\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"caption\":\"\u5b87, \u534e\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u3010Spring Boot\u3011\u4f7f\u7528JUnit\u00d7DBUnit\u8fdb\u884cController\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u6d4b\u8bd5 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u3010spring-boot\u3011\u4f7f\u7528junitxdbunit\u8fdb\u884ccontroller\u7c7b\u3001service\u7c7b\u548crepository\u7c7b\u7684\u6d4b\u8bd5\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u3010Spring Boot\u3011\u4f7f\u7528JUnit\u00d7DBUnit\u8fdb\u884cController\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u6d4b\u8bd5","og_description":"\u8fd9\u662f\u4f7f\u7528JUnit\u548cDBUnit\u6765\u6d4b\u8bd5Spring Boot\u7684Controller\u7c7b\u3001Service\u7c7b\u548cRep [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u3010spring-boot\u3011\u4f7f\u7528junitxdbunit\u8fdb\u884ccontroller\u7c7b\u3001service\u7c7b\u548crepository\u7c7b\u7684\u6d4b\u8bd5\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-06-30T09:54:57+00:00","article_modified_time":"2024-04-29T23:43:09+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fc737434c4406c8ff84\/48-0.png"}],"author":"\u5b87, \u534e","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u5b87, \u534e","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"11 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/","name":"\u3010Spring Boot\u3011\u4f7f\u7528JUnit\u00d7DBUnit\u8fdb\u884cController\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u6d4b\u8bd5 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-06-30T09:54:57+00:00","dateModified":"2024-04-29T23:43:09+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u3010Spring Boot\u3011\u4f7f\u7528JUnit\u00d7DBUnit\u8fdb\u884cController\u7c7b\u3001Service\u7c7b\u548cRepository\u7c7b\u7684\u6d4b\u8bd5"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458","name":"\u5b87, \u534e","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","caption":"\u5b87, \u534e"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90spring-boot%e3%80%91%e4%bd%bf%e7%94%a8junitxdbunit%e8%bf%9b%e8%a1%8ccontroller%e7%b1%bb%e3%80%81service%e7%b1%bb%e5%92%8crepository%e7%b1%bb%e7%9a%84%e6%b5%8b%e8%af%95%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=40327"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40327\/revisions"}],"predecessor-version":[{"id":90602,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40327\/revisions\/90602"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=40327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=40327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=40327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}