\u6628\u5929\uff082018\/9\/21\uff09\uff0cSpring Data JDBC 1.0.0\u6b63\u5f0f\u53d1\u5e03\uff0c\u5bf9\u4e8eSpring Boot\u7684\u652f\u6301\u5c06\u4eceSpring Boot 2.1\u5f00\u59cb\u3002\u636e\u8bf4\u5df2\u7ecf\u5b8c\u6210\u4e86\u5bf9\u8be5\u7248\u672c\u7684\u9002\u914d\uff08\u8ba1\u5212\u57282.1.0.M4\u4e2d\u53d1\u5e03\uff09\uff0c\u6240\u4ee5\u6211\u4eec\u60f3\u5728\u672c\u7bc7\u6587\u7ae0\u4e2d\u5feb\u901f\u5c1d\u8bd5\u4e00\u4e0bSpring Boot 2.1.0.BUILD-SNAPSHOT\u3002<\/p>\n
\u8bf7\u53c2\u8003”Spring Data JDBC 1.0.0.BUILD-SNAPSHOT\uff08->1.0.0.RELEASE\uff09”\u76f8\u5173\u5185\u5bb9\u3002<\/p><\/blockquote>\n
\u9a8c\u8bc1\u7248\u672c<\/h1>\n
\n
- \n
Spring Data JDBC 1.0.0.RELEASE<\/ul>\n<\/li>\n<\/ul>\n
<\/p>\n
Spring Boot Starter Data JDBC 2.1.0.BUILD-SNAPSHOT (2018\/09\/22\u6642\u70b9)<\/ul>\n
\u9a8c\u8bc1\u9879\u76ee<\/h1>\n
\u5728SPRING INITIALIZR\u4e0a\uff0c<\/p>\n
\n
- \n
Spring Boot\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u300c2.1.0(SNAPSHOT)\u300d\u306b\u9078\u629e<\/ul>\n<\/li>\n<\/ul>\n
<\/p>\n
Dependencies\u306b\u300cH2\u300d\u300cJDBC\u300d\u3092\u8ffd\u52a0<\/ul>\n
\u6839\u636e\u9700\u8981\uff0c\u8fdb\u884c\u4e0b\u8f7d\u548c\u89e3\u538b\u7f29\uff08\u5fc5\u8981\u65f6\u5bfc\u5165IDE\uff09\u3002<\/p>\n
\u5f88\u9057\u61be\uff0c\u76ee\u524d\u5728\u7f16\u5199\u672c\u6761\u76ee\u65f6\u8fd8\u6ca1\u6709\u89e3\u51b3\u5bf9spring-boot-starter-data-jdbc\u7684\u4f9d\u8d56\u5173\u7cfb\uff0c\u6240\u4ee5\u5c06\u4f9d\u8d56\u4e8espring-boot-starter-jdbc\u7684\u90e8\u5206\u4fee\u6539\u4e3a\u4f9d\u8d56\u4e8espring-boot-starter-data-jdbc\uff08\u4e5f\u53ef\u4ee5\u8fdb\u884c\u6dfb\u52a0\uff09\u3002<\/p>\n
<dependency><\/span>\r\n <groupId><\/span>org.springframework.boot<\/groupId><\/span>\r\n <artifactId><\/span>spring-boot-starter-data-jdbc<\/artifactId><\/span>\r\n<\/dependency><\/span>\r\n<\/code><\/pre>\n\u6309\u7167\u8fd9\u6837\u7684\u65b9\u5f0f\uff0cspring-data-jdbc\u548cspring-jdbc\u5c06\u88ab\u6dfb\u52a0\u4e3a\u4f9d\u8d56\u9879\uff0c\u5e76\u6210\u4e3aAutoConfigure\u7684\u76ee\u6807\u3002<\/p>\n
https:\/\/github.com\/kazuki43zoo\/spring-data-jdbc-boot-demo<\/ul>\n
Spring Data JDBC\u7684\u81ea\u52a8\u914d\u7f6e<\/h1>\n
\u9996\u5148\uff0c\u6211\u4eec\u5c06\u5c1d\u8bd5\u4f7f\u7528Spring Data JDBC\u7684AutoConfigure\u529f\u80fd\uff08\u6ca1\u6709\u9700\u8981\u8fdb\u884c\u989d\u5916\u8bbe\u7f6e\u7684\u60c5\u51b5\u4e0b\uff09\uff0c\u6765\u8fd0\u884c\u4e00\u4e2a\u7b80\u5355\u7684\u7a0b\u5e8f\u3002<\/p>\n
\u684c\u5b50 (zhu\u014d zi)<\/h3>\n
\u6211\u8981\u5236\u4f5c\u4e00\u5f20\u684c\u5b50\u3002<\/p>\n
CREATE<\/span> TABLE<\/span> IF<\/span> NOT<\/span> EXISTS<\/span> todo<\/span> (<\/span>\r\n id<\/span> IDENTITY<\/span>\r\n ,<\/span>title<\/span> VARCHAR<\/span> NOT<\/span> NULL<\/span>\r\n ,<\/span>details<\/span> VARCHAR<\/span>\r\n ,<\/span>finished<\/span> BOOLEAN<\/span> NOT<\/span> NULL<\/span>\r\n);<\/span>\r\n<\/code><\/pre>\n\u9886\u57df\u5bf9\u8c61<\/h3>\n
\u521b\u5efa\u9886\u57df\u5bf9\u8c61\u3002<\/p>\n
package<\/span> com.example.demo.domain<\/span>;<\/span>\r\n\r\nimport<\/span> org.springframework.data.annotation.Id<\/span>;<\/span>\r\n\r\npublic<\/span> class<\/span> Todo<\/span> {<\/span>\r\n @Id<\/span>\r\n private<\/span> int<\/span> id<\/span>;<\/span>\r\n private<\/span> String<\/span> title<\/span>;<\/span>\r\n private<\/span> String<\/span> details<\/span>;<\/span>\r\n private<\/span> boolean<\/span> finished<\/span>;<\/span>\r\n\r\n public<\/span> int<\/span> getId<\/span>()<\/span> {<\/span>\r\n return<\/span> id<\/span>;<\/span>\r\n }<\/span>\r\n\r\n public<\/span> void<\/span> setId<\/span>(<\/span>int<\/span> id<\/span>)<\/span> {<\/span>\r\n this<\/span>.<\/span>id<\/span> =<\/span> id<\/span>;<\/span>\r\n }<\/span>\r\n\r\n public<\/span> String<\/span> getTitle<\/span>()<\/span> {<\/span>\r\n return<\/span> title<\/span>;<\/span>\r\n }<\/span>\r\n\r\n public<\/span> void<\/span> setTitle<\/span>(<\/span>String<\/span> title<\/span>)<\/span> {<\/span>\r\n this<\/span>.<\/span>title<\/span> =<\/span> title<\/span>;<\/span>\r\n }<\/span>\r\n\r\n public<\/span> String<\/span> getDetails<\/span>()<\/span> {<\/span>\r\n return<\/span> details<\/span>;<\/span>\r\n }<\/span>\r\n\r\n public<\/span> void<\/span> setDetails<\/span>(<\/span>String<\/span> details<\/span>)<\/span> {<\/span>\r\n this<\/span>.<\/span>details<\/span> =<\/span> details<\/span>;<\/span>\r\n }<\/span>\r\n\r\n public<\/span> boolean<\/span> isFinished<\/span>()<\/span> {<\/span>\r\n return<\/span> finished<\/span>;<\/span>\r\n }<\/span>\r\n\r\n public<\/span> void<\/span> setFinished<\/span>(<\/span>boolean<\/span> finished<\/span>)<\/span> {<\/span>\r\n this<\/span>.<\/span>finished<\/span> =<\/span> finished<\/span>;<\/span>\r\n }<\/span>\r\n\r\n}<\/span>\r\n<\/code><\/pre>\n\u4ed3\u5e93<\/h3>\n
\u6211\u4f1a\u521b\u5efa\u4e00\u4e2a\u63d0\u4f9b\u9886\u57df\u5bf9\u8c61\u7684CRUD\u64cd\u4f5c\u7684\u5b58\u50a8\u5e93\u3002<\/p>\n
package<\/span> com.example.demo.repository<\/span>;<\/span>\r\n\r\nimport<\/span> org.springframework.data.repository.CrudRepository<\/span>;<\/span>\r\n\r\nimport<\/span> com.example.demo.domain.Todo<\/span>;<\/span>\r\n\r\npublic<\/span> interface<\/span> TodoRepository<\/span> extends<\/span> CrudRepository<\/span><<\/span>Todo<\/span>,<\/span> Integer<\/span>><\/span> {<\/span>\r\n\r\n}<\/span>\r\n<\/code><\/pre>\n\u6f14\u793a\u5e94\u7528<\/h3>\n
\u4f7f\u7528\u5b58\u50a8\u5e93\u7684\u65b9\u6cd5\uff0c\u4fdd\u5b58\u9886\u57df\u5bf9\u8c61\u5e76\u5b9e\u73b0\u5f15\u7528\u4fdd\u5b58\u7684\u9886\u57df\u5bf9\u8c61\u7684\u5904\u7406\u3002<\/p>\n
package<\/span> com.example.demo<\/span>;<\/span>\r\n\r\nimport<\/span> com.example.demo.domain.Todo<\/span>;<\/span>\r\nimport<\/span> com.example.demo.repository.TodoRepository<\/span>;<\/span>\r\nimport<\/span> org.springframework.boot.CommandLineRunner<\/span>;<\/span>\r\nimport<\/span> org.springframework.boot.SpringApplication<\/span>;<\/span>\r\nimport<\/span> org.springframework.boot.autoconfigure.SpringBootApplication<\/span>;<\/span>\r\nimport<\/span> org.springframework.context.annotation.Bean<\/span>;<\/span>\r\n\r\nimport<\/span> java.util.Optional<\/span>;<\/span>\r\n\r\n@SpringBootApplication<\/span>\r\npublic<\/span> class<\/span> SpringDataJdbcBootDemoApplication<\/span> {<\/span>\r\n\r\n public<\/span> static<\/span> void<\/span> main<\/span>(<\/span>String<\/span>[]<\/span> args<\/span>)<\/span> {<\/span>\r\n SpringApplication<\/span>.<\/span>run<\/span>(<\/span>SpringDataJdbcBootDemoApplication<\/span>.<\/span>class<\/span>,<\/span> args<\/span>);<\/span>\r\n }<\/span>\r\n\r\n @Bean<\/span>\r\n CommandLineRunner<\/span> demo<\/span>(<\/span>TodoRepository<\/span> todoRepository<\/span>)<\/span> {<\/span> \/\/ \u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3<\/span>\r\n return<\/span> args<\/span> -><\/span>