\u3053\u3093\u306b\u3061\u306f\u3001\u9234\u6728\u3067\u3059\u3002<\/p>\n
<\/p>\n
Spring4 \u306e JdbcTemplate \u3067 INSERT \u3057\u305f\u3068\u304d\u306b\u3001DB \u5074\u3067\u81ea\u52d5\u751f\u6210\u3055\u308c\u305f\u5024\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5\u3092\u8abf\u3079\u307e\u3057\u305f\u3002<\/p>\n
\u4e3b\u30ad\u30fc\u3092 SERIAL \u578b\u306b\u3057\u3066\u304a\u3044\u3066 INSERT \u6642\u306b\u5024\u3092\u81ea\u52d5\u751f\u6210\u3055\u305b\u305f\u308a\u3001\u30ec\u30b3\u30fc\u30c9\u306e\u4f5c\u6210\u65e5\u6642\u3092\u4fdd\u6301\u3059\u308b\u30ab\u30e9\u30e0\u306b\u300cDEFAULT CURRENT_TIMESTAMP\u300d\u306a\u3069\u3068\u6307\u5b9a\u3059\u308b\u3053\u3068\u306f\u3042\u308b\u306e\u3067\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002\u305d\u306e\u3088\u3046\u306a INSERT \u6642\u306b\u81ea\u52d5\u751f\u6210\u3055\u308c\u305f\u5024\u3092\u53d6\u5f97\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n
RDBMS \u3054\u3068\u306b\u3084\u308a\u65b9\u306f\u7570\u306a\u308b\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u4eca\u56de\u306f PostgreSQL \u306e\u5834\u5408\u3067\u3059\u3002<\/p>\n
<\/p>\n
\u307e\u305a\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u308a\u307e\u3059\u3002<\/p>\n
createdb spring4_sample<\/pre>\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u3067\u304d\u305f\u3089 psql \u30b3\u30de\u30f3\u30c9\u3067\u63a5\u7d9a\u3067\u304d\u308b\u306f\u305a\u3067\u3059\u3002<\/p>\n
psql spring4_sample<\/pre>\n\u6b21\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u308a\u307e\u3059\u3002\u4f55\u3067\u3082\u3088\u3044\u306e\u3067\u3059\u304c\u3001users \u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u3063\u3066\u307f\u307e\u3059\u3002<\/p>\n
CREATE TABLE users (\r\n -- \u4e3b\u30ad\u30fc.\r\n id SERIAL PRIMARY KEY,\r\n\r\n -- \u540d\u524d.\r\n name VARCHAR(20) NOT NULL,\r\n\r\n -- \u5e74\u9f62.\r\n age INTEGER NOT NULL\r\n);<\/pre>\nid \u30ab\u30e9\u30e0\u306f SERIAL \u578b\u306b\u3057\u3066\u3001\u5024\u304c\u81ea\u52d5\u751f\u6210\u3055\u308c\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
\u4ed6\u306e\u30ab\u30e9\u30e0\u306f\u4f55\u3067\u3082\u3088\u3044\u306e\u3067\u3059\u304c\u3001\u540d\u524d\u3068\u5e74\u9f62\u3092\u4fdd\u6301\u3059\u308b\u30ab\u30e9\u30e0\u3092\u4f5c\u3063\u3066\u304a\u304d\u307e\u3057\u305f\u3002<\/p>\n
<\/p>\n
Maven \u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u308b<\/h2>\n
maven \u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u308a\u307e\u3059\u3002<\/p>\n
mvn archetype:create -DgroupId=com.example.spring4.hello -DartifactId=hello<\/pre>\npom.xml \u3092\u7de8\u96c6\u3057\u307e\u3059\u3002\u300c\u8ffd\u52a0 - \u3053\u3053\u304b\u3089\u300d\u300c\u8ffd\u52a0 - \u3053\u3053\u307e\u3067\u300d\u306e\u9593\u304c\u8ffd\u52a0\u3057\u305f\u90e8\u5206\u3067\u3059\u3002<\/p>\n
<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\r\n <modelVersion>4.0.0<\/modelVersion>\r\n\r\n <groupId>com.example.spring4.hello<\/groupId>\r\n <artifactId>hello<\/artifactId>\r\n <version>1.0-SNAPSHOT<\/version>\r\n <packaging>jar<\/packaging>\r\n\r\n <name>hello<\/name>\r\n <url>http:\/\/maven.apache.org<\/url>\r\n\r\n <properties>\r\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\r\n <\/properties>\r\n\r\n <dependencies>\r\n <dependency>\r\n <groupId>junit<\/groupId>\r\n <artifactId>junit<\/artifactId>\r\n <version>3.8.1<\/version>\r\n <scope>test<\/scope>\r\n <\/dependency>\r\n <!-- \u8ffd\u52a0 - \u3053\u3053\u304b\u3089 -->\r\n <dependency>\r\n <groupId>postgresql<\/groupId>\r\n <artifactId>postgresql<\/artifactId>\r\n <version>9.1-901-1.jdbc4<\/version>\r\n <\/dependency>\r\n <dependency>\r\n <groupId>org.springframework<\/groupId>\r\n <artifactId>spring-context<\/artifactId>\r\n <version>4.0.0.RELEASE<\/version>\r\n <\/dependency>\r\n <dependency>\r\n <groupId>org.springframework<\/groupId>\r\n <artifactId>spring-jdbc<\/artifactId>\r\n <version>4.0.0.RELEASE<\/version>\r\n <\/dependency>\r\n <!-- \u8ffd\u52a0 - \u3053\u3053\u307e\u3067 -->\r\n <\/dependencies>\r\n<\/project><\/pre>\n<\/p>\n
\u3068\u308a\u3042\u3048\u305a INSERT \u3059\u308b\u30b3\u30fc\u30c9<\/h2>\n
\u672c\u984c\u3068\u306f\u95a2\u4fc2\u7121\u3044\u30b3\u30fc\u30c9\u304c\u591a\u304f\u306a\u3063\u3066\u3057\u307e\u3046\u306e\u3067\u3001\u3068\u308a\u3042\u3048\u305a INSERT \u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f8\u304d\u3001\u305d\u306e\u5f8c\u3067\u5fc5\u8981\u306a\u7b87\u6240\u3092\u30d4\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002<\/p>\n
package com.example.spring4.hello;\r\n\r\nimport javax.sql.DataSource;\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.context.ApplicationContext;\r\nimport org.springframework.context.annotation.AnnotationConfigApplicationContext;\r\nimport org.springframework.context.annotation.Bean;\r\nimport org.springframework.context.annotation.ComponentScan;\r\nimport org.springframework.context.annotation.Configuration;\r\nimport org.springframework.jdbc.core.JdbcTemplate;\r\nimport org.springframework.jdbc.datasource.DataSourceTransactionManager;\r\nimport org.springframework.jdbc.datasource.SimpleDriverDataSource;\r\nimport org.springframework.stereotype.Component;\r\nimport org.springframework.transaction.PlatformTransactionManager;\r\nimport org.springframework.transaction.annotation.EnableTransactionManagement;\r\nimport org.springframework.transaction.annotation.Transactional;\r\n\r\n@Component\r\n@Configuration\r\n@ComponentScan\r\n@EnableTransactionManagement\r\npublic class App {\r\n\r\n public static void main(String[] args) {\r\n ApplicationContext context = new AnnotationConfigApplicationContext(App.class);\r\n context.getBean(App.class).run();\r\n }\r\n\r\n @Autowired\r\n private DataSource dataSource;\r\n\r\n @Transactional\r\n public void run() {\r\n final String name = \"\u305f\u308d\u3046\";\r\n final Integer age = 20;\r\n JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);\r\n\r\n jdbcTemplate.update(\"INSERT INTO users (name, age) VALUES (?, ?)\", name, age);\r\n \/\/ TODO \u3053\u3053\u3067\u81ea\u52d5\u751f\u6210\u3055\u308c\u305f id \u306e\u5024\u3092\u53d6\u5f97\u3059\u308b\r\n }\r\n\r\n @Bean\r\n protected DataSource createDataSource() {\r\n SimpleDriverDataSource dataSource = new SimpleDriverDataSource();\r\n dataSource.setDriverClass(org.postgresql.Driver.class);\r\n dataSource.setUrl(\"jdbc:postgresql:\/\/localhost\/spring4_sample\");\r\n\r\n \/\/ \u63a5\u7d9a\u30e6\u30fc\u30b6\u3084\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046.\r\n \/\/ dataSource.setUsername(\"\");\r\n \/\/ dataSource.setPassword(\"\");\r\n\r\n return dataSource;\r\n }\r\n\r\n @Bean\r\n @Autowired\r\n protected PlatformTransactionManager createTransactionManager(DataSource dataSource) {\r\n return new DataSourceTransactionManager(dataSource);\r\n }\r\n\r\n}<\/pre>\nApp#run \u30e1\u30bd\u30c3\u30c9\u306e\u4e2d\u304c\u3001\u3068\u308a\u3042\u3048\u305a INSERT \u3059\u308b\u30b3\u30fc\u30c9\u3067\u3059\u3002<\/p>\n
INSERT \u3059\u308b\u305f\u3081\u306b JdbcTemplate#update \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002JdbcTemplate#update \u306f INSERT \u3084 UPDATE, DELETE \u3059\u308b\u3068\u304d\u306b\u4f7f\u3048\u308b\u5272\u3068\u6c4e\u7528\u7684\u306a\u30e1\u30bd\u30c3\u30c9\u3067\u3001\u5f71\u97ff\u306e\u3042\u3063\u305f\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u8fd4\u3057\u307e\u3059\u3002\u3064\u307e\u308a\u3001JdbcTemplate#update \u30e1\u30bd\u30c3\u30c9\u3067\u306f\u81ea\u52d5\u751f\u6210\u3055\u308c\u305f id \u306e\u5024\u3092\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n
\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u3069\u3046\u3057\u307e\u3057\u3087\u3046\u30fb\u30fb\u3002<\/p>\n
<\/p>\n
lastval \u95a2\u6570\u3092\u4f7f\u3046\u65b9\u6cd5<\/h2>\n
PostgreSQL \u306b\u306f lastval \u3068\u3044\u3046\u95a2\u6570\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u3092\u4f7f\u3046\u3053\u3068\u3067\u73fe\u5728\u306e\u30bb\u30c3\u30b7\u30e7\u30f3\u3067\u6700\u5f8c\u306b\u751f\u6210\u3055\u308c\u305f\u5024\uff08\u6b63\u78ba\u306b\u306f nextval \u3067\u53d6\u5f97\u3055\u308c\u305f\u5024\uff09\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n
\u30b3\u30fc\u30c9\u3092\u66f8\u304f\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
@Transactional\r\n public void run() {\r\n final String name = \"\u305f\u308d\u3046\";\r\n final Integer age = 20;\r\n JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);\r\n\r\n jdbcTemplate.update(\"INSERT INTO users (name, age) VALUES (?, ?)\", name, age);\r\n Integer id = jdbcTemplate.queryForObject(\"SELECT lastval()\", Integer.class);\r\n System.out.println(id);\r\n }<\/pre>\n\u3061\u306a\u307f\u306b lastval \u306b\u4f3c\u3066\u3044\u308b currval \u3068\u3044\u3046\u95a2\u6570\u3082\u3042\u308a\u307e\u3059\u3002currval \u306f\u5f15\u6570\u3067\u6307\u5b9a\u3057\u305f\u30b7\u30fc\u30b1\u30f3\u30b9\u306e\u6700\u5f8c\u306e\u5024\u3092\u8fd4\u3057\u307e\u3059\u304c\u3001lastval \u306f\u6700\u5f8c\u306b nextval \u3055\u308c\u305f\u30b7\u30fc\u30b1\u30f3\u30b9\u306e\u6700\u5f8c\u306e\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002currval \u3060\u3068\u30b7\u30fc\u30b1\u30f3\u30b9\u540d\u3092\u6307\u5b9a\u3059\u308b\u624b\u9593\u304c\u3042\u308b\u306e\u3067\u3001lastval \u3092\u4f7f\u3046\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n
<\/p>\n
RETURNING \u53e5\u3092\u4f7f\u3046\u65b9\u6cd5<\/h2>\n
\u5225\u306e\u65b9\u6cd5\u3068\u3057\u3066 INSERT \u6587\u306e\u6700\u5f8c\u306b\u300cRETURNING id\u300d\u3092\u52a0\u3048\u305f SQL \u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u3001INSERT \u3057\u3064\u3064\u81ea\u52d5\u751f\u6210\u3055\u308c\u305f id \u306e\u5024\u3092\u8fd4\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n
\u30b3\u30fc\u30c9\u306b\u3059\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
@Transactional\r\n public void run() {\r\n final String name = \"\u305f\u308d\u3046\";\r\n final Integer age = 20;\r\n JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);\r\n\r\n Integer id = jdbcTemplate.queryForObject(\"INSERT INTO users (name, age) VALUES (?, ?) RETURNING id\", Integer.class, name, age);\r\n System.out.println(id);\r\n }<\/pre>\nlastval \u3092\u4f7f\u3046\u65b9\u6cd5\u3067\u306f INSERT \u3059\u308b SQL \u3068 lastval \u3092\u5b9f\u884c\u3059\u308b SQL \u3092\u5206\u3051\u3066\u5b9f\u884c\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3057\u305f\u304c\u3001\u3053\u306e\u65b9\u6cd5\u3067\u306f 1 \u56de\u306e SQL \u3067\u5b8c\u7d50\u3057\u307e\u3059\u3002<\/p>\n
<\/p>\n
\u6bd4\u8f03\u3059\u308b<\/h2>\n
\u3069\u3061\u3089\u306e\u65b9\u6cd5\u304c\u826f\u3044\u304b\u6bd4\u8f03\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n
lastval \u95a2\u6570\u3092\u4f7f\u3046\u65b9\u6cd5<\/h3>\n
\n
- lastval \u306f PostgreSQL8.1 \u304b\u3089\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u3002
\n\uff08see \u300cPostgreSQL 8.1.9\u6587\u66f8 - 9.12. \u30b7\u30fc\u30b1\u30f3\u30b9\u64cd\u4f5c\u95a2\u6570<\/a>\u300d\uff09<\/li>\n- SQL \u306e\u5b9f\u884c\u56de\u6570\u304c\u5897\u3048\u3066\u3057\u307e\u3046\u3002<\/li>\n
- \u30ab\u30e9\u30e0\u306e\u540d\u524d\u3092\u6c17\u306b\u3057\u306a\u304f\u3066\u826f\u3044\u3002<\/li>\n<\/ul>\n
RETURNING \u53e5\u3092\u4f7f\u3046\u65b9\u6cd5<\/h3>\n
\n
- RETURNING \u53e5\u306f PostgreSQL 8.2 \u304b\u3089\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u3002
\n\uff08see \u300cPostgreSQL 8.2.6\u6587\u66f8 - INSERT<\/a>\u300d\uff09<\/li>\n- SQL \u306e\u5b9f\u884c\u56de\u6570\u306f\u5897\u3048\u306a\u3044\u3002<\/li>\n
- \u30ab\u30e9\u30e0\u306e\u540d\u524d\u3092\u6c17\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002\uff08\u30ab\u30e9\u30e0\u540d\u304c piyo \u306a\u3089\u300cRETURNING piyo\u300d\uff09<\/li>\n<\/ul>\n
\u307e\u3068\u3081<\/h3>\n
\u307e\u3068\u3081\u308b\u3068\u3001<\/p>\n
\n
- RETURNING \u53e5\u3092\u4f7f\u3046\u65b9\u6cd5\u304c\u826f\u3044\uff08\u5b9f\u884c\u3059\u308b SQL \u304c\u5897\u3048\u306a\u3044\u306e\u3067\uff09\u3002<\/li>\n
- PostgreSQL \u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c 8.2 \u672a\u6e80\u306e\u5834\u5408\u306f lastval \u3092\u4f7f\u3046\u65b9\u6cd5\u3002<\/li>\n
- SQL \u306e\u5b9f\u884c\u56de\u6570\u304c\u5897\u3048\u3066\u3082\u554f\u984c\u306b\u306a\u3089\u306a\u3044\u5834\u5408\u306f lastval \u306e\u65b9\u6cd5\u304c\u697d\uff08\u30ab\u30e9\u30e0\u540d\u3092\u6c17\u306b\u3057\u306a\u304f\u3066\u826f\u3044\u306e\u3067\uff09\u3002<\/li>\n<\/ul>\n
\u3060\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3053\u3093\u306b\u3061\u306f\u3001\u9234\u6728\u3067\u3059\u3002<\/p>\n
<\/p>\n
Spring4 \u306e JdbcTemplate \u3067 INSERT \u3057\u305f\u3068\u304d\u306b\u3001DB \u5074\u3067\u81ea\u52d5\u751f\u6210\u3055\u308c\u305f\u5024\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5\u3092\u8abf\u3079\u307e\u3057\u305f\u3002
\u7d9a\u304d\u3092\u8aad\u3080...<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18],"tags":[57,124,206,122],"_links":{"self":[{"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/posts\/3796"}],"collection":[{"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/comments?post=3796"}],"version-history":[{"count":1,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/posts\/3796\/revisions"}],"predecessor-version":[{"id":17885,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/posts\/3796\/revisions\/17885"}],"wp:attachment":[{"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/media?parent=3796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/categories?post=3796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techscore.com\/blog\/wp-json\/wp\/v2\/tags?post=3796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}