{"id":188,"date":"2019-06-25T10:29:00","date_gmt":"2019-06-25T01:29:00","guid":{"rendered":"http:\/\/2019se3.satoshis.jp\/?p=188"},"modified":"2019-06-25T12:44:44","modified_gmt":"2019-06-25T03:44:44","slug":"6%e6%9c%8825%e6%97%a5","status":"publish","type":"post","link":"https:\/\/2019se3.satoshis.jp\/?p=188","title":{"rendered":"6\u670825\u65e5"},"content":{"rendered":"

HSQLDB\u30b5\u30fc\u30d0\u30fc\u304c\u52d5\u3044\u305f\u3089\u3001MyBootApp\u3092\u8d77\u52d5\u3059\u308b\u3002
\n\u8d77\u52d5\u3059\u308b\u3068\u3001\u81ea\u52d5\u7684\u306b3\u3064\u306e\u30ec\u30b3\u30fc\u30c9\u304c\u66f8\u304d\u8fbc\u307e\u308c\u308b\u3002
\n\u8d77\u52d5\u3059\u308b\u305f\u3073\u306b\u30ec\u30b3\u30fc\u30c9\u304c\u66f8\u304d\u8fbc\u307e\u308c\u308b\u306e\u306f\u307e\u305a\u3044\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u524a\u9664\u3059\u308b\u3002<\/p>\n

MyDataController.java<\/p>\n

\r\n\t@PostConstruct\r\n\tpublic void init() {\r\n\t\tMyData d1 = new MyData();\r\n\t\td1.setName("tuyano");\r\n\t\td1.setAge(123);\r\n\t\td1.setMail("syoda@tuyano.com");\r\n\t\td1.setMemo("this is data!");\r\n\t\trepository.saveAndFlush(d1);\r\n\t\tMyData d2 = new MyData();\r\n\t\td2.setName("hanako");\r\n\t\td2.setAge(15);\r\n\t\td2.setMail("hanako@flower.com");\r\n\t\td2.setMemo("this is data!");\r\n\t\trepository.saveAndFlush(d2);\r\n\t\tMyData d3 = new MyData();\r\n\t\td3.setName("sachiko");\r\n\t\td3.setAge(37);\r\n\t\td3.setMail("sachiko@happy");\r\n\t\td3.setMemo("this is data!");\r\n\t\trepository.saveAndFlush(d3);\r\n\t}\r\n<\/pre>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30de\u30cd\u30fc\u30b8\u30e3\u3092\u8d77\u52d5\u3059\u308bBAT\u30d5\u30a1\u30a4\u30eb\u3082\u4f5c\u6210\u3059\u308b\u3002
\n\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u306bmanager.bat \u3092\u4f5c\u6210\u3059\u308b\u3002<\/p>\n
\r\ncd C:\\pleiades\\hsqldb-2.4.1\\hsqldb\\data\r\njava -classpath ..\\lib\\hsqldb.jar org.hsqldb.util.DatabaseManager\r\n<\/pre>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30de\u30cd\u30fc\u30b8\u30e3\u3092\u8d77\u52d5\u3059\u308b\u3068\u3001\u63a5\u7d9a\u5148\u8a2d\u5b9a\u306e\u753b\u9762\u304c\u51fa\u308b\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5165\u529b\u3059\u308b\u3002<\/p>\n
\"\"<\/p>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092\u6bce\u56de\u6d88\u3055\u306a\u3044\u3088\u3046\u306b\u3059\u308b\u305f\u3081\u306b\u3001application.properties \u306b\u8a2d\u5b9a\u30921\u884c\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n
\r\nspring.datasource.url=jdbc:hsqldb:hsql:\/\/localhost\/mydata\r\nspring.datasource.username=sa\r\nspring.datasource.password=\r\nspring.datasource.driver-class-name=org.hsqldb.jdbc.JDBCDriver\r\nspring.jpa.properties.hibernate.dialect=org.hibernate.dialect.HSQLDialect\r\nspring.jpa.hibernate.ddl-auto=update\r\n<\/pre>\n
DAO\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9<\/h3>\n
Spring Boot \u3067\u306f\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u4f7f\u3063\u3066\u5bb9\u6613\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3002
\nJava\u6a19\u6e96\u306eJAP\u3092\u4f7f\u3046\u5834\u5408\u306f\u3001\u4e00\u822c\u7684\u306bDAO\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9\u3092\u5b9f\u88c5\u3059\u308b\u3002<\/p>\n
\u307e\u305aDAO\u30a4\u30f3\u30bf\u30d5\u30a7\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b\u3002<\/p>\n
\r\npackage jp.abc;\r\n\r\nimport java.io.Serializable;\r\nimport java.util.List;\r\n\r\npublic interface MyDataDao <T> extends Serializable {\r\n\tpublic List<T> getAll();\r\n}\r\n<\/pre>\n
\u305d\u3057\u3066\u3001DAO\u306e\u5b9f\u88c5\u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3059\u308b\u3002<\/p>\n
\r\npackage jp.abc;\r\n\r\nimport java.util.List;\r\n\r\nimport javax.persistence.EntityManager;\r\nimport javax.persistence.Query;\r\n\r\nimport jp.abc.MyData;\r\nimport jp.abc.MyDataDao;\r\n\r\npublic class MyDataDaoImpl implements MyDataDao<MyData> {\r\n\r\n\tprivate EntityManager entityManager;\r\n\r\n\tpublic MyDataDaoImpl() {\r\n\t\tsuper();\r\n\t}\r\n\tpublic MyDataDaoImpl(EntityManager entityManager) {\r\n\t\tthis();\r\n\t\tthis.entityManager = entityManager;\r\n\t}\r\n\r\n\t@Override\r\n\tpublic List<MyData> getAll() {\r\n\t\tQuery query = entityManager.createQuery("from MyData");\r\n\t\tList<MyData> list = query.getResultList();\r\n\t\tentityManager.close();\r\n\t\treturn list;\r\n\t}\r\n\r\n}\r\n<\/pre>\n
\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b\u3002
\nURL: \/dao \u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u3068\u304d\u306b\u3001DAO\u7d4c\u7531\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9\u3092\u5b9f\u884c\u3059\u308b\u3002<\/p>\n
\r\n\t@PersistenceContext\r\n\tEntityManager entityManager;\r\n\r\n\tMyDataDao<MyData> dao;\r\n\r\n\t@PostConstruct\r\n\tpublic void init() {\r\n\t\tdao = new MyDataDaoImpl(entityManager);\r\n\t}\r\n\r\n\t@RequestMapping("\/dao")\r\n\tpublic ModelAndView dao(ModelAndView mav) {\r\n\t\tmav.setViewName("dao");\r\n\t\tmav.addObject("msg", "DAO\u3092\u4f7f\u3063\u305f\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002");\r\n\t\tList<MyData> list = dao.getAll();\r\n\t\tmav.addObject("datalist", list);\r\n\t\treturn mav;\r\n\t}\r\n<\/pre>\n
HTML\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092 dao.html \u3068\u3057\u3066\u7528\u610f\u3059\u308b\u3002<\/p>\n
\r\n<!DOCTYPE html>\r\n<html xmlns:th="http:\/\/www.thymeleaf.org">\r\n<head>\r\n<meta charset="UTF-8">\r\n<title>top page<\/title>\r\n<meta http-equiv="Content-type" content="text\/html; charset=UTF-8" \/>\r\n<style type="text\/css">\r\nh1 {\r\n  font-size: 18pt;\r\n  font-weight: bold;\r\n  color: gray;\r\n}\r\nbody {\r\n  font-size: 13pt;\r\n  color: gray;\r\n  margin: 5px 25px;\r\n}\r\npre {\r\n  border: solid 3px #ddd;\r\n  padding: 10px;\r\n}\r\ntr {\r\n  margin: 5px;\r\n}\r\nth {\r\n  padding: 5px;\r\n  color: white;\r\n  background: darkgray;\r\n}\r\ntd {\r\n  padding: 5px;\r\n  color: black;\r\n  background: #f0f0f0;\r\n}\r\n.err {\r\n  color: red;\r\n}\r\n<\/style>\r\n<\/head>\r\n<body>\r\n\r\n<h1>MyData page<\/h1>\r\n<p th:text="${msg}"><\/p>\r\n\r\n<hr \/>\r\n<table>\r\n  <tr>\r\n    <th>ID<\/th><th>\u540d\u524d<\/th><th>\u30e1\u30fc\u30eb<\/th><th>\u5e74\u9f62<\/th><th>\u30e1\u30e2<\/th>\r\n  <\/tr>\r\n  <tr th:each="obj : ${datalist}">\r\n    <td th:text="${obj.id}"><\/td>\r\n    <td th:text="${obj.name}"><\/td>\r\n    <td th:text="${obj.mail}"><\/td>\r\n    <td th:text="${obj.age}"><\/td>\r\n    <td th:text="${obj.memo}"><\/td>\r\n  <\/tr>\r\n<\/table>\r\n\r\n\r\n<\/body>\r\n<\/html>\r\n<\/pre>\n\n
<\/div>","protected":false},"excerpt":{"rendered":"
HSQLDB\u30b5\u30fc\u30d0\u30fc\u304c\u52d5\u3044\u305f\u3089\u3001MyBootApp\u3092\u8d77\u52d5\u3059\u308b\u3002 \u8d77\u52d5\u3059\u308b\u3068\u3001\u81ea\u52d5\u7684\u306b3\u3064\u306e\u30ec\u30b3\u30fc\u30c9\u304c\u66f8\u304d\u8fbc\u307e\u308c\u308b\u3002 \u8d77\u52d5\u3059\u308b\u305f\u3073\u306b\u30ec\u30b3\u30fc\u30c9\u304c\u66f8\u304d\u8fbc\u307e\u308c\u308b\u306e\u306f\u307e\u305a\u3044\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u524a\u9664\u3059\u308b\u3002 MyDataControl … “6\u670825\u65e5” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/posts\/188"}],"collection":[{"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=188"}],"version-history":[{"count":9,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/posts\/188\/revisions"}],"predecessor-version":[{"id":198,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/posts\/188\/revisions\/198"}],"wp:attachment":[{"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}