\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u306f\u5727\u7e2e\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u4efb\u610f\u306e\u5834\u6240\u306b\u89e3\u51cd\u3057\u3066\u304a\u304d\u307e\u3059\u3002
<\/p>\n\n\n\n
\u305d\u3057\u3066\u3001SpringBoot\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3088\u308a\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u53f3\u30af\u30ea\u30c3\u30af\u2192\u30d7\u30ed\u30d1\u30c6\u30a3\u30fc\u2192\u30d3\u30eb\u30c9\u30d1\u30b9\u3092\u9078\u629e\u3057\u307e\u3059\u3002 \u89e3\u51cd\u3057\u3066\u51fa\u6765\u305f\u30d5\u30a9\u30eb\u30c0\u306b\u306fjavadoc\u3001sources\u306a\u3069\u540d\u524d\u304c\u3064\u3044\u3066\u3044\u308bjar\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u3053\u308c\u3089\u306e\u540d\u524d\u304c\u3064\u3044\u3066\u3044\u306a\u3044jar\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002 28\u884c\u76ee\u304cThymeleaf\u3092\u4f7f\u3046\u3053\u3068\u306e\u5ba3\u8a00\u300129\u884c\u76ee\u304cMicrosoft SQL Server\u306eJDBC\u30c9\u30e9\u30a4\u30d0\u3092\u4f7f\u3046\u3053\u3068\u306e\u5ba3\u8a00\u3067\u3059\u3002 JDBC\u30c9\u30e9\u30a4\u30d0\u306e\u53c2\u7167\u306e\u8a2d\u5b9a\u304c\u7d42\u308f\u308b\u3068\u3001\u5b9f\u969b\u306b\u753b\u9762\u3068\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5b9f\u88c5\u3057\u3066\u52d5\u4f5c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3059\u3002 \u3053\u306e\u753b\u9762\u3067\u306f\u3001\u30af\u30a8\u30ea\u53d6\u5f97\u7d50\u679c\u3092\u660e\u7d30\u90e8\u5206\u306b\u7e70\u308a\u8fd4\u3057\u66f8\u304f\u51e6\u7406\u309213\u884c\u76ee\u304b\u308918\u884c\u76ee\u306b\u304b\u3051\u3066\u884c\u3063\u3066\u3044\u307e\u3059\u3002 \u753b\u9762\u306b\u8868\u793a\u3059\u308bitemCode\u3001itemName\u306eget\u3001set\u30e1\u30bd\u30c3\u30c9\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002 \u63a5\u7d9a\u60c5\u5831\u306e\u8a18\u8f09\u3068\u30af\u30a8\u30ea\u3001JDBC\u3092\u4f7f\u3063\u3066Microsoft SQL Server\u306b\u63a5\u7d9a\u3057\u3066\u3001\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u753b\u9762\u306b\u8fd4\u3059\u51e6\u7406\u3092\u8a18\u8ff0\u3057\u3066\u3044\u307e\u3059\u3002 \u3067\u306f\u3001\u5b9f\u969b\u306e\u52d5\u4f5c\u3092\u898b\u3066\u307f\u307e\u3059\u3002 \u3059\u308b\u3068\u3001\u30dc\u30bf\u30f3\u3068\u3001\u660e\u7d30\u306e\u30bf\u30a4\u30c8\u30eb\u90e8\u5206\u3060\u3051\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u72b6\u614b\u3068\u306a\u308a\u307e\u3059\u3002 \u8868\u793a\u5bfe\u8c61\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u304c\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u305f\u3081\u3001\u6b63\u3057\u304f\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u8868\u793a\u304c\u51fa\u6765\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n \u4eca\u56de\u306f\u4ee5\u4e0b\u306e\u3053\u3068\u3092\u884c\u3044\u307e\u3057\u305f\u3002<\/p>\n\n\n\n \u4eca\u56de\u306f\u8aac\u660e\u7528\u306b\u306a\u308b\u3079\u304f\u5358\u7d14\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u304c\u3001\u5b9f\u969b\u306e\u958b\u767a\u3067\u306f\u30af\u30a8\u30ea\u3092\u5225\u30d5\u30a1\u30a4\u30eb\u306b\u5206\u3051\u308b\u3001\u63a5\u7d9a\u6587\u5b57\u5217\u306f\u30d7\u30ed\u30d1\u30c6\u30a3\u30d5\u30a1\u30a4\u30eb\u306b\u8a18\u8f09\u3057\u3066\u8aad\u307f\u8fbc\u3080\u3088\u3046\u306b\u3059\u308b\u306a\u3069\u3001\u5c11\u3057\u8907\u96d1\u306b\u306a\u308b\u3053\u3068\u304c\u591a\u3044\u3067\u3059\u3002 \u4eca\u56de\u306e\u8a18\u4e8b\u306f\u3053\u3053\u307e\u3067\u3068\u306a\u308a\u307e\u3059\u3002 \u4eca\u56de\u306f\u524d\u56de\u3068\u540c\u3058\u3088\u3046\u306a\u30c6\u30fc\u30de\u3067\u3059\u304c\u3001SpringBoot\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9\u3092\u3059\u308b\u3053\u3068\u3092\u3084\u3063\u3066\u307f\u307e\u3059\u3002 \u524d\u56de\u306f\u5916\u90e8\u306eURL\u3092\u53c2\u7167\u3057\u3066JDBC\u3092\u53c2\u7167\u3057\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u5916\u90e8\u306ejar\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3057\u3066\u5b9f\u88c5\u3092\u8a66\u307f\u307e\u3057<\/p>\n","protected":false},"author":2,"featured_media":160,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jin_ogp_image_url":"","_jin_last_featured_id":0,"footnotes":""},"categories":[9,5],"tags":[15,24,4],"class_list":["post-412","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-java","category-5","tag-java","tag-24","tag-4"],"_links":{"self":[{"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=\/wp\/v2\/posts\/412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=412"}],"version-history":[{"count":3,"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=\/wp\/v2\/posts\/412\/revisions"}],"predecessor-version":[{"id":429,"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=\/wp\/v2\/posts\/412\/revisions\/429"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=\/wp\/v2\/media\/160"}],"wp:attachment":[{"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/se-pg-toolbox.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\u30e9\u30a4\u30d6\u30e9\u30ea\u30fc\u30bf\u30d6\u306e\u30af\u30e9\u30b9\u30d1\u30b9\u3092\u9078\u629e\u3057\u3001\u300c\u5916\u90e8JAR\u306e\u8ffd\u52a0\u300d\u306e\u30dc\u30bf\u30f3\u304b\u3089\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u89e3\u51cd\u3057\u3066\u51fa\u6765\u305fjar\u30d5\u30a1\u30a4\u30eb\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n![\"\"](\"https:\/\/se-pg-toolbox.com\/wp-content\/uploads\/2025\/04\/article27-1-1024x308.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/se-pg-toolbox.com\/wp-content\/uploads\/2025\/04\/article27-2.png\")
<\/figure>\n\n\n\n
\u3053\u308c\u3060\u3051\u3067\u306f\u53c2\u7167\u304c\u3046\u307e\u304f\u884c\u304b\u306a\u3044\u306e\u3067\u3001build.gradle\u306b\u53c2\u7167\u306e\u8a18\u8ff0\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002
Microsoft SQL Server\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308bJDBC\u30c9\u30e9\u30a4\u30d0\u306e\u53c2\u7167\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3057\u307e\u3059\u3002
\u3064\u3044\u3067\u306bThymeleaf\u3092\u4f7f\u3046\u305f\u3081\u306e\u8a18\u8ff0\u3082\u884c\u3063\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\nplugins {\n\tid 'java'\n\tid 'org.springframework.boot' version '3.4.3'\n\tid 'io.spring.dependency-management' version '1.1.7'\n}\n\ngroup = 'com.example'\nversion = '0.0.1-SNAPSHOT'\n\njava {\n\ttoolchain {\n\t\tlanguageVersion = JavaLanguageVersion.of(17)\n\t}\n}\n\nconfigurations {\n\tcompileOnly {\n\t\textendsFrom annotationProcessor\n\t}\n}\n\nrepositories {\n\tmavenCentral()\n}\n\ndependencies {\n\timplementation 'org.springframework.boot:spring-boot-starter-web'\n\timplementation 'org.springframework.boot:spring-boot-starter-thymeleaf'\n\truntimeOnly 'com.microsoft.sqlserver:mssql-jdbc'\n\tcompileOnly 'org.projectlombok:lombok'\n\tdevelopmentOnly 'org.springframework.boot:spring-boot-devtools'\n\tannotationProcessor 'org.projectlombok:lombok'\n\ttestImplementation 'org.springframework.boot:spring-boot-starter-test'\n\ttestRuntimeOnly 'org.junit.platform:junit-platform-launcher'\n}\n\ntasks.named('test') {\n\tuseJUnitPlatform()\n}<\/code><\/pre><\/div>\n\n\n\n
\u3044\u305a\u308c\u3082dependencies\u306e\u4e2d\u306b\u5ba3\u8a00\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n\u5b9f\u969b\u306b\u753b\u9762\u3068\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u7d44\u3093\u3067\u307f\u308b<\/h2>\n\n\n\n
\u4eca\u56de\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30bd\u30fc\u30b9\u3092\u66f8\u3044\u3066\u307f\u307e\u3057\u305f\u3002
\u753b\u9762<\/strong><\/p>\n\n\n\n<!DOCTYPE html>\n<html xmlns:th="https:\/\/www.thymeleaf.org">\n <head>\n <meta http-equiv="Content-Type" content="text\/html; charset=UTF-8" \/>\n <title>\u30af\u30a8\u30ea\u306e\u5b9f\u884c\u7d50\u679c<\/title>\n <\/head>\n <body>\n <form action="#" th:action="@{\/do\/ExecuteSQL}" th:object="${frm}" method="post">\n <input type="submit" value="\u9001\u4fe1">\n\t <table>\n\t\t <th>\u5546\u54c1\u30b3\u30fc\u30c9<\/th>\n\t\t <th>\u5546\u54c1\u540d<\/th>\n <th:block th:each="data : ${retData}">\n\t\t\t <tr>\n\t\t\t\t <td th:text="${data.itemCode}"><\/td>\n\t\t\t\t <td th:text="${data.itemName}"><\/td>\n\t\t\t <\/tr>\n <\/th:block>\n <\/table>\n <\/form>\n <\/body>\n<\/html><\/code><\/pre><\/div>\n\n\n\n
\u9001\u4fe1\u30dc\u30bf\u30f3\u3092\u62bc\u3059\u3068\u3001\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3001\u5b9f\u884c\u7d50\u679c\u3092\u660e\u7d30\u306b\u8868\u793a\u3059\u308b\u4ed5\u7d44\u307f\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002
\u753b\u9762\u306b\u8868\u793a\u3059\u308b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8Frm\u30af\u30e9\u30b9\u306e\u5b9a\u7fa9<\/strong><\/p>\n\n\n\npackage com.example.demo;\n\npublic class Frm {\n\t\/\/private String youbi = "";\n\tprivate String itemCode = "";\n\t\n\tprivate String itemName = "";\n\t\n\tpublic String getItemCode() {\n\t\treturn this.itemCode;\n\t}\n\t\n\tpublic String getItemName() {\n\t\treturn this.itemName;\n\t}\n\t\n\tpublic void setItemCode(String itemCode) {\n\t\tthis.itemCode = itemCode;\n\t}\n\n\tpublic void setItemName(String itemName) {\n\t\tthis.itemName = itemName;\n\t}\n}\n<\/code><\/pre><\/div>\n\n\n\n
\u5b9f\u969b\u306e\u52d5\u4f5c\u3092\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u306b\u8a18\u8f09<\/strong><\/p>\n\n\n\npackage com.example.demo;\n\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\nimport java.sql.Statement;\nimport java.util.ArrayList;\nimport java.util.List;\n\nimport org.springframework.stereotype.Controller;\nimport org.springframework.ui.Model;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.PostMapping;\nimport org.springframework.web.bind.annotation.RequestMapping;\n@Controller\n@RequestMapping()\npublic class sampleController {\n\t@PostMapping("\/do\/ExecuteSQL")\n\tprivate static String ExecuteSQL(Frm form, Model model) {\n\t\t\n\t\t\/\/\u63a5\u7d9aURL\n\t\tString urlStr = "jdbc:sqlserver:\/\/TAKA:1433;databaseName=test;encript=true;trustServerCertificate=true";\n\t\t\/\/\u30e6\u30fc\u30b6\u30fc\u540d \n\t\tString userName="test";\n\t\t\/\/\u30d1\u30b9\u30ef\u30fc\u30c9\n\t\tString password ="test";\n\t\t\n\t\t\/\/SQL\u30af\u30a8\u30ea\n\t\tString query="SELECT item_code, item_name FROM item";\n\t\tList<Frm> fr = new ArrayList<Frm>();\n\t\t\/\/JDBC\u63a5\u7d9a\u3092\u884c\u3044\u3001\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\n\t\ttry(Connection con = DriverManager.getConnection(urlStr, userName, password);\n\t\t\tStatement state = con.createStatement();\n\t\t\tResultSet resSet = state.executeQuery(query)){\n\t\t\t\/\/\u53d6\u5f97\u3057\u305f\u884c\u306e\u672b\u7aef\u307e\u3067\u7d50\u679c\u3092\u8868\u793a\u3059\u308b\n\t\t\twhile(resSet.next()) {\n\t\t\t\t\/\/\u8868\u793a\u3059\u308b\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\n\t\t\t\tFrm pushData = new Frm();\n\t\t\t\tpushData.setItemCode(resSet.getString("item_code"));\n\t\t\t\tpushData.setItemName(resSet.getString("item_name"));\n\t\t\t\tfr.add(pushData);\n\t\t\t}\n\t\t\t\/\/\u30d5\u30a9\u30fc\u30e0\u306b\u8868\u793a\u3059\u308b\u60c5\u5831\u3092\u30bb\u30c3\u30c8\u3059\u308b\n\t\t\tmodel.addAttribute("retData", fr);\n\t\t} catch (SQLException e) {\n\t\t\te.printStackTrace();\n\t\t}\n\t\t\n\t\treturn "sample";\n\t}\n\t@GetMapping("\/index")\n\tpublic String index(Model model) {\n\t\tList<Frm> fr = new ArrayList<Frm>();\n\t\tmodel.addAttribute("retData", fr);\n\t\treturn "sample";\n\t}\n}<\/code><\/pre><\/div>\n\n\n\n
\u4e00\u756a\u4e0b\u306eindex\u30e1\u30bd\u30c3\u30c9\u306f\u753b\u9762\u521d\u671f\u8868\u793a\u306e\u305f\u3081\u306e\u30e1\u30bd\u30c3\u30c9\u3067\u3059\u3002<\/p>\n\n\n\n\u5b9f\u969b\u306e\u52d5\u4f5c<\/h2>\n\n\n\n
http:\/\/localhost:8080\/index<\/span>\u3068\u6253\u3061\u8fbc\u307f\u3001\u753b\u9762\u306e\u8868\u793a\u3092\u898b\u3066\u307f\u307e\u3059\uff08\u30ed\u30fc\u30ab\u30eb\u306e\u30dd\u30fc\u30c8\u756a\u53f7\u306fSpringBoot\u3067\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u30678080\u306b\u8a2d\u5b9a\u3055\u308c\u308b\u305f\u3081\u3001\u5909\u66f4\u3057\u305f\u5834\u5408\u306f\u5909\u66f4\u3057\u305f\u30dd\u30fc\u30c8\u756a\u53f7\u3092\u6307\u5b9a\u3057\u307e\u3059\uff09\u3002<\/p>\n\n\n\n![\"\"](\"https:\/\/se-pg-toolbox.com\/wp-content\/uploads\/2025\/04\/article27-3.png\")
<\/figure>\n\n\n\n
\u305d\u3057\u3066\u3001\u3053\u3053\u3067\u3001\u300c\u9001\u4fe1\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u307e\u3059\u3002
\u3059\u308b\u3068\u3001Microsoft SQL Server\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u8868\u793a\u3059\u308b\u52d5\u4f5c\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n![\"\"](\"https:\/\/se-pg-toolbox.com\/wp-content\/uploads\/2025\/04\/article27-4.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/se-pg-toolbox.com\/wp-content\/uploads\/2025\/04\/article27-5.png\")
<\/figure>\n\n\n\n\u307e\u3068\u3081<\/h2>\n\n\n\n
\n
\u3057\u304b\u3057\u3001\u57fa\u672c\u3055\u3048\u5206\u304b\u3063\u3066\u3044\u308c\u3070\u3001SpringBoot\u3068Thymeleaf\u3092\u7528\u3044\u3066\u958b\u767a\u3055\u308c\u305f\u30bd\u30fc\u30b9\u306f\u3069\u3053\u3067\u4f55\u3092\u884c\u3063\u3066\u3044\u308b\u304b\u306e\u628a\u63e1\u304c\u96e3\u3057\u304f\u306a\u3044\u306e\u3067\u3001\u3059\u3050\u306b\u4f55\u3092\u3069\u3053\u3067\u884c\u3046\u304b\u3092\u628a\u63e1\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u308b\u306f\u305a\u3067\u3059\u3002
\u4eca\u56de\u306f\u524d\u56de\u3068\u540c\u3058\u3088\u3046\u306a\u3053\u3068\u3092JDBC\u30c9\u30e9\u30a4\u30d0\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u3063\u3066\u5b9f\u73fe\u3057\u307e\u3057\u305f\u304c\u3001\u540c\u3058\u3088\u3046\u306b\u5916\u90e8\u306ejar\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u8aad\u307f\u8fbc\u3093\u3067\u958b\u767a\u3059\u308b\u3068\u3044\u3046\u3053\u3068\u3082\u5b9f\u969b\u306e\u696d\u52d9\u3067\u306f\u3042\u308a\u5f97\u308b\u306e\u3067\u3001\u524d\u56de\u306e\u8a18\u4e8b\u3068\u4eca\u56de\u306e\u8a18\u4e8b\u3001\u4e21\u65b9\u3068\u3082\u3057\u3063\u304b\u308a\u8aad\u3093\u3067\u7406\u89e3\u3057\u3066\u9802\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
\u307e\u305f\u6b21\u306e\u8a18\u4e8b\u3067\u304a\u4f1a\u3044\u3057\u307e\u3057\u3087\u3046\u3002<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"