{"id":534,"date":"2015-09-26T15:50:31","date_gmt":"2015-09-26T06:50:31","guid":{"rendered":"http:\/\/www.ois-yokohama.co.jp\/oisblog\/?p=534"},"modified":"2022-10-14T20:12:20","modified_gmt":"2022-10-14T11:12:20","slug":"spring-4-1-mybatis-3-2-postgresql-9-3-%e7%92%b0%e5%a2%83%e3%82%92%e4%bd%9c%e3%82%8b%ef%bc%88part-1%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/archives\/534","title":{"rendered":"Spring 4.1 + MyBatis 3.2 + PostgreSQL 9.3 \u74b0\u5883\u3092\u4f5c\u308b\uff08part 1\uff09"},"content":{"rendered":"
\"\"<\/div>\n

\u3053\u3093\u306b\u3061\u308f\u3001\u590f\u30d0\u30c6\u3082\u306a\u304f\u306a\u308a\u3001\u732b\u3068\u622f\u308c\u308b\u65e5\u3005\u3092\u904e\u3054\u3059\u307b\u3052PG\u3067\u3059\u3002\u4eca\u56de\u306f\u524d\u56de\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u6539\u826f\u3057\u3066DB\u64cd\u4f5c\u3092\u8ffd\u52a0\u3057\u3066\u3044\u304d\u307e\u3059\u3002\uff08\u307b\u3052\u30c3\uff09<\/p>\n

\uff11\u3001\u5404\u7a2e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n

PostGreSQL\u306f \u3053\u3053\uff08https:\/\/www.postgresql.jp\/download<\/a>\uff09\u304b\u30899.3\u3092\u843d\u3068\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n

\uff12\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210<\/h3>\n

pgAdmin III\uff08\u30be\u30a6\u3055\u3093\uff4e\u30a2\u30a4\u30b3\u30f3\uff09\u3092\u8d77\u52d5\u3059\u308b\u3002<\/p>\n

2-1\u3001\u30ed\u30fc\u30eb\u4f5c\u6210
\n\u65b0\u3057\u3044\u30ed\u30b0\u30a4\u30f3\u30ed\u30fc\u30eb\u3067\u53f3\u30af\u30ea\u30c3\u30af\uff1e\u65b0\u3057\u3044\u30ed\u30b0\u30a4\u30f3\u30ed\u30fc\u30eb\u3092\u9078\u629e
\n\"WS000000\"<\/a>
\n\u30d7\u30ed\u30d1\u30c6\u30a3\u30bf\u30d6\u3000\u30ed\u30fc\u30eb\u540d\uff1ahoge\u3001\u30b3\u30e1\u30f3\u30c8\uff1ahoge
\n\"WS000001\"<\/a>
\n\u5b9a\u7fa9\u30bf\u30d6\u3000\u30d1\u30b9\u30ef\u30fc\u30c9\uff1ahoge
\n\"WS000002\"<\/a><\/p>\n

\u30ed\u30fc\u30eb\u7279\u6a29\u30bf\u30d6\u3000\u5168\u90e8\u30c1\u30a7\u30c3\u30af<\/p>\n

\"WS000003\"<\/a>
\n\u3053\u308c\u3067OK\u30dc\u30bf\u30f3\u62bc\u4e0b\u3002<\/p>\n

2-2\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210
\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u53f3\u30af\u30ea\u30c3\u30af\uff1e\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u9078\u629e
\n\"WS000004\"<\/a>
\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u306bhogedb\u3001\u30aa\u30fc\u30ca\u30fc\u3092hoge\u306b\u8a2d\u5b9a\u3057\u3001OK\u62bc\u4e0b\u3002
\n\"WS000005\"<\/a>
\n\"WS000006\"<\/a><\/p>\n

\uff13\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210<\/h3>\n

\u4ee5\u4e0b\u306eSQL\u3092\u30af\u30a8\u30ea\u30fc\u30c4\u30fc\u30eb\u3088\u308a\u5b9f\u65bd\u3059\u308b\u3002<\/p>\n

DROP TABLE IF EXISTS tbl_hoge;\r\nCREATE TABLE tbl_hoge (\r\n\tid SERIAL NOT NULL,\r\n\tname VARCHAR(10) NOT NULL,\r\n\tcomment VARCHAR(999),\r\n\tupdated_at timestamp DEFAULT CURRENT_TIMESTAMP,\r\n\tPRIMARY KEY (id)\r\n);\r\n<\/pre>\n
\"WS000001\"<\/a><\/p>\n
\uff14\u3001\u524d\u56de\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u4fee\u6b63<\/h3>\n
pom.xml\u306e\u4f9d\u5b58\u95a2\u4fc2\u306b\u4ee5\u4e0b\u3092\u8ffd\u52a0\u3002<\/p>\n
<!-- DB -->\r\n<dependency>\r\n <groupId>org.mybatis<\/groupId>\r\n <artifactId>mybatis<\/artifactId>\r\n <version>3.2.7<\/version>\r\n<\/dependency>\r\n<dependency>\r\n <groupId>org.mybatis<\/groupId>\r\n <artifactId>mybatis-spring<\/artifactId>\r\n <version>1.2.2<\/version>\r\n<\/dependency>\r\n<dependency>\r\n <groupId>commons-dbcp<\/groupId>\r\n <artifactId>commons-dbcp<\/artifactId>\r\n <version>1.2.2<\/version>\r\n<\/dependency>\r\n<dependency>\r\n <groupId>org.postgresql<\/groupId>\r\n <artifactId>postgresql<\/artifactId>\r\n <version>9.3-1102-jdbc4<\/version>\r\n<\/dependency><\/pre>\n
spring-context.xml \u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u4fee\u6b63\u3002<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<beans xmlns=\"http:\/\/www.springframework.org\/schema\/beans\"\r\n xmlns:context=\"http:\/\/www.springframework.org\/schema\/context\"\r\n xmlns:mvc=\"http:\/\/www.springframework.org\/schema\/mvc\"\r\n xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n xmlns:p=\"http:\/\/www.springframework.org\/schema\/p\"\r\n xmlns:tx=\"http:\/\/www.springframework.org\/schema\/tx\"\r\n xmlns:task=\"http:\/\/www.springframework.org\/schema\/task\"\r\n xsi:schemaLocation=\"\r\n        http:\/\/www.springframework.org\/schema\/beans\r\n        http:\/\/www.springframework.org\/schema\/beans\/spring-beans-4.1.xsd\r\n        http:\/\/www.springframework.org\/schema\/context\r\n        http:\/\/www.springframework.org\/schema\/context\/spring-context-4.1.xsd\r\n        http:\/\/www.springframework.org\/schema\/mvc\r\n        http:\/\/www.springframework.org\/schema\/mvc\/spring-mvc-4.1.xsd\r\n        http:\/\/www.springframework.org\/schema\/tx\r\n        http:\/\/www.springframework.org\/schema\/tx\/spring-tx-4.1.xsd\">\r\n\t<context:component-scan base-package=\"jp.co.ois.hoge.sandbox\" \/>\r\n\t<mvc:annotation-driven \/>\r\n\t<bean\r\n\t\tclass=\"org.springframework.web.servlet.view.InternalResourceViewResolver\">\r\n\t\t<property name=\"prefix\" value=\"\/WEB-INF\/views\/\" \/>\r\n\t\t<property name=\"suffix\" value=\".jsp\" \/>\r\n\t<\/bean>\r\n\t<mvc:resources mapping=\"\/resources\/**\" location=\"\/resources\/\" \/>\r\n\t<!-- \u8a2d\u5b9a -->\r\n\t<bean id=\"system\"\r\n\t\tclass=\"org.springframework.beans.factory.config.PropertyPlaceholderConfigurer\">\r\n\t\t<property name=\"systemPropertiesModeName\" value=\"SYSTEM_PROPERTIES_MODE_OVERRIDE\"\/>\r\n\t\t<property name=\"searchSystemEnvironment\" value=\"true\"\/>\r\n\t\t<property name=\"locations\">\r\n\t\t\t<list>\r\n\t\t\t\t<value>classpath:system.properties<\/value>\r\n\t\t\t<\/list>\r\n\t\t<\/property>\r\n\t<\/bean>\r\n\t<!-- DB\u95a2\u9023 -->\r\n\t<bean id=\"dataSource\" class=\"org.apache.commons.dbcp.BasicDataSource\">\r\n\t\t<property name=\"driverClassName\" value=\"${jdbc.driverClassName}\" \/>\r\n\t\t<property name=\"url\" value=\"${jdbc.url}\" \/>\r\n\t\t<property name=\"username\" value=\"${jdbc.username}\" \/>\r\n\t\t<property name=\"password\" value=\"${jdbc.password}\" \/>\r\n\t\t<property name=\"defaultAutoCommit\" value=\"false\" \/>\r\n\t<\/bean>\r\n\t<!-- \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u7ba1\u7406 -->\r\n\t<bean id=\"transactionManager\" class=\"org.springframework.jdbc.datasource.DataSourceTransactionManager\">\r\n\t\t<property name=\"dataSource\" ref=\"dataSource\"\/>\r\n\t<\/bean>\r\n\t<!-- mybatis -->\r\n\t<bean id=\"sqlSessionFactory\" class=\"org.mybatis.spring.SqlSessionFactoryBean\">\r\n\t\t<property name=\"dataSource\" ref=\"dataSource\" \/>\r\n\t\t<property name=\"configLocation\" value=\"classpath:mybatis-config.xml\" \/>\r\n\t\t<property name=\"mapperLocations\" value=\"classpath*:sqlMap\/**\/*.xml\" \/>\r\n\t<\/bean>\r\n\t<bean id=\"sqlSession\" class=\"org.mybatis.spring.SqlSessionTemplate\">\r\n\t\t<constructor-arg index=\"0\" ref=\"sqlSessionFactory\" \/>\r\n\t<\/bean>\r\n\t<tx:annotation-driven \/>\r\n<\/beans><\/pre>\n
src\/java\/resources \u306e\u4e0b\u306bsystem.properties\u3092\u65b0\u898f\u4f5c\u6210\u3002\u5185\u5bb9\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3002<\/p>\n
jdbc.driverClassName=org.postgresql.Driver\r\njdbc.url=jdbc:postgresql:\/\/localhost:5432\/hogedb\r\njdbc.username=hoge\r\njdbc.password=hoge<\/pre>\n
mybatis \u7528\u306e\u5b9a\u7fa9\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3002
\nsrc\/java\/resources\/mybatis-config.xml<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<!DOCTYPE configuration\r\n  PUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\"\r\n  \"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\r\n<configuration>\r\n\t<settings>\r\n\t\t<setting name=\"logImpl\" value=\"LOG4J\"\/>\r\n\t<\/settings>\r\n\t<environments default=\"production\">\r\n\t\t<environment id=\"production\">\r\n\t\t\t<transactionManager type=\"JDBC\" \/>\r\n\t\t\t<dataSource type=\"POOLED\">\r\n\t\t\t\t<property name=\"driver.encoding\" value=\"utf8\" \/>\r\n\t\t\t<\/dataSource>\r\n\t\t<\/environment>\r\n\t<\/environments>\r\n<\/configuration><\/pre>\n
src\/java\/resources\/sqlMap\/hoge.xml<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<!DOCTYPE mapper\r\n  PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\r\n  \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\r\n\t<mapper namespace=\"jp.co.ois.hoge.sandbox.hoge\">\r\n\t<!-- \u307b\u3052\u7528 -->\r\n\t<select id=\"list\"\r\n\t\t\tresultType=\"jp.co.ois.hoge.sandbox.HogeForm\">\r\n\t\tSELECT\r\n\t\t\tid,\r\n\t\t\tname,\r\n\t\t\tcomment,\r\n\t\t\tupdated_at as \"updatedAt\"\r\n\t\tFROM tbl_hoge\r\n\t\tORDER BY updated_at DESC\r\n\t<\/select>\r\n\t<select id=\"select\"\r\n\t\t\tparameterType=\"int\"\r\n\t\t\tresultType=\"jp.co.ois.hoge.sandbox.HogeForm\">\r\n\t\tSELECT\r\n\t\t\tId,\r\n\t\t\tname,\r\n\t\t\tcomment,\r\n\t\t\tupdated_at as \"updatedAt\"\r\n\t\tFROM tbl_hoge\r\n\t\tWHERE id = #{Id}\r\n\t<\/select>\r\n\t<insert id=\"insert\"\r\n\t\t\tparameterType=\"jp.co.ois.hoge.sandbox.HogeForm\">\r\n\t\tINSERT INTO tbl_hoge (\r\n\t\t\tname,\r\n\t\t\tcomment,\r\n\t\t\tupdated_at\r\n\t\t)\r\n\t\tVALUES (\r\n\t\t\t#{name},\r\n\t\t\t#{comment},\r\n\t\t\tnow()\r\n\t\t)\r\n\t<\/insert>\r\n\t<update id=\"update\"\r\n\t\t\tparameterType=\"jp.co.ois.hoge.sandbox.HogeForm\">\r\n\t\tUPDATE tbl_hoge\r\n\t\tSET\tname = #{name}, comment = #{comment}, updated_at = now()\r\n\t\tWHERE id = #{id}\r\n\t<\/update>\r\n<\/mapper><\/pre>\n
 <\/p>\n
\uff15\u3001\u30b5\u30f3\u30d7\u30eb\u306e\u4f5c\u6210<\/h3>\n
\u30b5\u30f3\u30d7\u30eb\u306e\u69cb\u6210\u3092\u4ee5\u4e0b\u306b\u793a\u3059\u3002
\n\"\u30e1\u30e2\"<\/a>
\n\u88dc\u8db3\uff09
\n\u30fb\u65b0\u898f\u5165\u529b\uff5e\u633f\u5165\u307e\u3067\u306e\u6d41\u308c\u3067list\u306e\u3068\u3053\u308d\u306f\u753b\u9762\u306b\u4e00\u89a7\u3092\u8868\u793a\u3059\u308b\u305f\u3081\u306bselect\u3057\u3066\u3044\u308b\u3060\u3051\u3067\u3059\u3002
\n\u30fbmybatis\u3068\u306e\u3084\u308a\u53d6\u308a\u306fHogeController \u3067\u306f\u306a\u304fHogeLogic\u3068\u3044\u3046\u5225\u30af\u30e9\u30b9\u3067\u51e6\u7406\u3057\u3066\u3044\u307e\u3059\u3002
\n\u30fbjsp\u306f\u4e00\u3064\u306e\u5171\u901ajsp\u3067\u51e6\u7406\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
HogeController.java<\/p>\n
package jp.co.ois.hoge.sandbox;\r\nimport java.util.List;\r\nimport javax.validation.Valid;\r\nimport org.apache.commons.logging.Log;\r\nimport org.apache.commons.logging.LogFactory;\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.stereotype.Controller;\r\nimport org.springframework.transaction.annotation.Transactional;\r\nimport org.springframework.ui.Model;\r\nimport org.springframework.validation.BindingResult;\r\nimport org.springframework.web.bind.annotation.ModelAttribute;\r\nimport org.springframework.web.bind.annotation.RequestMapping;\r\nimport org.springframework.web.bind.annotation.RequestParam;\r\n@Controller\r\n@RequestMapping(\"\/hoge\")\r\npublic class HogeController {\r\n\tprivate static final Log log = LogFactory.getLog(HogeController.class);\r\n\t@Autowired\r\n\tHogeLogic logic;\r\n\t@ModelAttribute(\"hogeForm\")\r\n\tpublic HogeForm createForm() {\r\n\t\treturn new HogeForm();\r\n\t}\r\n\t@RequestMapping({\"\/\", \"\/index\"})\r\n\t@Transactional(readOnly=true)\r\n\tpublic String index(Model model) {\r\n\t\tlog.debug(\"called.\");\r\n\t\tList<HogeForm> list = logic.list();\r\n\t\tmodel.addAttribute(\"list\", list);\r\n\t\treturn \"hoge\";\r\n\t}\r\n\t@RequestMapping(\"\/update\")\r\n\t@Transactional(rollbackFor=Throwable.class)\r\n\tpublic String update(@Valid HogeForm form, BindingResult result, Model model) {\r\n\t\tlog.debug(\"called.\");\r\n\t\tif (result.hasErrors()) {\r\n\t        model.addAttribute(\"result\", \"error\");\r\n\t\t\treturn index(model);\r\n\t\t}\r\n\t\tlogic.update(form);\r\n        model.addAttribute(\"result\", \"success\");\r\n\t\treturn index(model);\r\n\t}\r\n\t@RequestMapping(\"\/select\")\r\n\t@Transactional(readOnly=true)\r\n\tpublic String select(@RequestParam int id, Model model) {\r\n\t\tlog.debug(\"called.\");\r\n\t\tHogeForm form = logic.select(id);\r\n\t\tmodel.addAttribute(form);\r\n\t\treturn index(model);\r\n\t}\r\n}<\/pre>\n
HogeLogic.java<\/p>\n
package jp.co.ois.hoge.sandbox;\r\nimport java.util.List;\r\nimport org.apache.commons.logging.Log;\r\nimport org.apache.commons.logging.LogFactory;\r\nimport org.apache.ibatis.session.SqlSession;\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.stereotype.Component;\r\n@Component\r\npublic class HogeLogic {\r\n\tprivate static final Log log = LogFactory.getLog(HogeLogic.class);\r\n\t@Autowired\r\n\tprivate SqlSession sqlSession;\r\n\tpublic void update(HogeForm form) {\r\n\t\tlog.debug(\"called. \"+ form);\r\n\t\tif (form.getId() > 0) {\r\n\t\t\tsqlSession.update(\"jp.co.ois.hoge.sandbox.hoge.update\", form);\r\n\t\t} else {\r\n\t\t\tsqlSession.insert(\"jp.co.ois.hoge.sandbox.hoge.insert\", form);\r\n\t\t}\r\n\t}\r\n\tpublic List<HogeForm> list() {\r\n\t\tlog.debug(\"called.\");\r\n\t\treturn sqlSession.selectList(\"jp.co.ois.hoge.sandbox.hoge.list\");\r\n\t}\r\n\tpublic HogeForm select(int id) {\r\n\t\tlog.debug(\"called. \"+ id);\r\n\t\treturn sqlSession.selectOne(\"jp.co.ois.hoge.sandbox.hoge.select\", id);\r\n\t}\r\n}<\/pre>\n
hoge.jsp<\/p>\n
<%@page contentType=\"text\/html; charset=utf-8\" %>\r\n<%@taglib uri=\"http:\/\/www.springframework.org\/tags\/form\" prefix=\"form\"%>\r\n<%@taglib uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" prefix=\"c\" %>\r\n<html>\r\n<head>\r\n\t<title>\u307b\u3052<\/title>\r\n<\/head>\r\n<body>\r\n\t<h1>\u307b\u3052<\/h1>\r\n\t<form:form modelAttribute=\"hogeForm\" servletRelativeAction=\"\/hoge\/update\" method=\"POST\">\r\n\t\t<form:hidden path=\"id\" \/>\r\n\t\t<br><br>\r\n\t\t\u540d\u524d\uff1a<form:input path=\"name\" \/>\r\n\t\t<form:errors path=\"name\" \/><br>\r\n\t\t\u30b3\u30e1\u30f3\u30c8\uff1a<form:input path=\"comment\" \/>\r\n\t\t<form:errors path=\"comment\" \/><br>\r\n\t\t<input type=\"submit\" value=\"\u66f4\u65b0\">\r\n\t<\/form:form>\r\n\t${result}<br>\r\n<hr>\r\n<table border=1>\r\n\t<tr>\r\n\t<th>id<\/th>\r\n\t<th>name<\/th>\r\n\t<th>comment<\/th>\r\n\t<th>updatedAt<\/th>\r\n\t<\/tr>\r\n<c:forEach var=\"hoge\" items=\"${list}\" varStatus=\"status\">\r\n\t<tr onclick=\"selectHoge(${hoge.id})\">\r\n\t<td><c:out value=\"${hoge.id}\"\/><\/td>\r\n\t<td><c:out value=\"${hoge.name}\"\/><\/td>\r\n\t<td><c:out value=\"${hoge.comment}\"\/><\/td>\r\n\t<td><c:out value=\"${hoge.updatedAtString}\"\/><\/td>\r\n\t<\/tr>\r\n<\/c:forEach>\r\n<\/table>\r\n<br>\r\n<input type=\"button\" value=\"\u65b0\u898f\" onclick=\"newForm()\">\r\n<script>\r\nfunction selectHoge(id) {\r\n\tlocation = \"<c:url value=\"\/hoge\/select\"\/>?id=\"+ id;\r\n}\r\nfunction newForm() {\r\n\tlocation = \"<c:url value=\"\/hoge\/\"\/>\";\r\n}\r\n<\/script>\r\n<\/body>\r\n<\/html><\/pre>\n
\u5b9f\u969b\u306b\u52d5\u304b\u3057\u3066\u307f\u308b\u3002
\n\u30d6\u30e9\u30a6\u30b6\u3067\u4ee5\u4e0b\u306b\u30a2\u30af\u30bb\u30b9
\nhttp:\/\/localhost:8080\/sandbox\/hoge\/
\n\"WS000002\"<\/a>
\n\"WS000003\"<\/a>
\n\"WS000004\"<\/a><\/p>\n
\u4eca\u56de\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u4e00\u5f0f\u306f\u4ee5\u4e0b\u306b\u7f6e\u304d\u307e\u3057\u305f\u3002
\nhttp:\/\/www.ois-yokohama.co.jp\/oisblog\/file\/sandbox2.zip<\/a><\/p>\n
\u3068\u308a\u3042\u3048\u305a\u3001\u4eca\u56de\u306f\u3053\u3053\u307e\u3067\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3053\u3093\u306b\u3061\u308f\u3001\u590f\u30d0\u30c6\u3082\u306a\u304f\u306a\u308a\u3001\u732b\u3068\u622f\u308c\u308b\u65e5\u3005\u3092\u904e\u3054\u3059\u307b\u3052PG\u3067\u3059\u3002\u4eca\u56de\u306f\u524d\u56de\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u6539\u826f\u3057\u3066DB\u64cd\u4f5c\u3092\u8ffd\u52a0\u3057\u3066\u3044\u304d\u307e\u3059\u3002\uff08\u307b\u3052\u30c3\uff09 \uff11\u3001\u5404\u7a2e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb PostGreSQL\u306f \u3053\u3053\uff08https:\/\/www.po […]<\/p>\n","protected":false},"author":1,"featured_media":5756,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"vkexunit_cta_each_option":"","footnotes":""},"categories":[6],"tags":[28,29,24],"class_list":["post-534","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-engineer","tag-hoge","tag-mybatis","tag-spring"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/posts\/534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/comments?post=534"}],"version-history":[{"count":3,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/posts\/534\/revisions"}],"predecessor-version":[{"id":5890,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/posts\/534\/revisions\/5890"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/media\/5756"}],"wp:attachment":[{"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/media?parent=534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/categories?post=534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/tags?post=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}