\u7a81\u7136\u60f3\u5230\u4e86\u80fd\u5426\u5c06\u5728Spring\u7684JdbcTemplate\uff08NamedParameterJdbcTemplate\uff09\u7b49\u4e2d\u6307\u5b9a\u7684SQL\u5b9a\u4e49\u4e3a2-way SQL~\uff0c\u867d\u7136\u6709\u5f88\u591a\u65b9\u6cd5\uff0c\u4f46\u8fd9\u6b21\u6211\u5c1d\u8bd5\u4f7f\u7528Thymeleaf\uff08\u6a21\u677f\u5f15\u64ce\uff09\u6765\u5c06SQL\u8f6c\u5316\u4e3a2-way SQL\u3002<\/p>\n
<\/p>\n
\u4f7f\u7528SPRING INITIALIZR\uff0c\u5728\u4f9d\u8d56\u9879\u4e2d\u9009\u62e9\u300cJDBC\u300d\u300cH2\u300d\u548c\u300cThymeleaf\u300d\uff0c\u521b\u5efa\u4e00\u4e2aMaven\u9879\u76ee\u3002<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?><\/span>\r\n<project<\/span> xmlns=<\/span>\"http:\/\/maven.apache.org\/POM\/4.0.0\"<\/span> xmlns:xsi=<\/span>\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"<\/span>\r\n xsi:schemaLocation=<\/span>\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\"<\/span>><\/span>\r\n <modelVersion><\/span>4.0.0<\/modelVersion><\/span>\r\n\r\n <groupId><\/span>com.example<\/groupId><\/span>\r\n <artifactId><\/span>demo<\/artifactId><\/span>\r\n <version><\/span>0.0.1-SNAPSHOT<\/version><\/span>\r\n <packaging><\/span>jar<\/packaging><\/span>\r\n\r\n <name><\/span>th-demo<\/name><\/span>\r\n <description><\/span>Demo project for Spring Boot<\/description><\/span>\r\n\r\n <parent><\/span>\r\n <groupId><\/span>org.springframework.boot<\/groupId><\/span>\r\n <artifactId><\/span>spring-boot-starter-parent<\/artifactId><\/span>\r\n <version><\/span>2.1.0.RELEASE<\/version><\/span>\r\n <relativePath\/><\/span> <!-- lookup parent from repository --><\/span>\r\n <\/parent><\/span>\r\n\r\n <properties><\/span>\r\n <project.build.sourceEncoding><\/span>UTF-8<\/project.build.sourceEncoding><\/span>\r\n <project.reporting.outputEncoding><\/span>UTF-8<\/project.reporting.outputEncoding><\/span>\r\n <java.version><\/span>1.8<\/java.version><\/span>\r\n <\/properties><\/span>\r\n\r\n <dependencies><\/span>\r\n <dependency><\/span>\r\n <groupId><\/span>org.springframework.boot<\/groupId><\/span>\r\n <artifactId><\/span>spring-boot-starter-jdbc<\/artifactId><\/span>\r\n <\/dependency><\/span>\r\n <dependency><\/span>\r\n <groupId><\/span>org.springframework.boot<\/groupId><\/span>\r\n <artifactId><\/span>spring-boot-starter-thymeleaf<\/artifactId><\/span>\r\n <\/dependency><\/span>\r\n\r\n <dependency><\/span>\r\n <groupId><\/span>com.h2database<\/groupId><\/span>\r\n <artifactId><\/span>h2<\/artifactId><\/span>\r\n <scope><\/span>runtime<\/scope><\/span>\r\n <\/dependency><\/span>\r\n <dependency><\/span>\r\n <groupId><\/span>org.springframework.boot<\/groupId><\/span>\r\n <artifactId><\/span>spring-boot-starter-test<\/artifactId><\/span>\r\n <scope><\/span>test<\/scope><\/span>\r\n <\/dependency><\/span>\r\n <\/dependencies><\/span>\r\n\r\n <build><\/span>\r\n <plugins><\/span>\r\n <plugin><\/span>\r\n <groupId><\/span>org.springframework.boot<\/groupId><\/span>\r\n <artifactId><\/span>spring-boot-maven-plugin<\/artifactId><\/span>\r\n <\/plugin><\/span>\r\n <\/plugins><\/span>\r\n <\/build><\/span>\r\n\r\n\r\n<\/project><\/span>\r\n<\/code><\/pre>\n\u6ce8\u610f\uff1a<\/p>\n
\u4f7f\u7528Spring Boot\u5e76\u975e\u5fc5\u987b\uff0c\u4f46\u7531\u4e8e\u53ef\u4ee5\u7b80\u5355\u5730\u4f7f\u7528Thymeleaf\u521b\u5efaSpring\u5e94\u7528\u7a0b\u5e8f\uff0c\u56e0\u6b64\u6211\u4eec\u9009\u62e9\u4e86\u4f7f\u7528Spring Boot\u3002<\/p><\/blockquote>\n
\u51c6\u5907SQL\u6587\u4ef6<\/h1>\n
2-way SQL\u662f\u4ee5SQL\u6587\u4ef6\u7684\u5f62\u5f0f\u8bb0\u5f55\u3002<\/p>\n
SELECT<\/span>\r\n id<\/span> ,<\/span>name<\/span>\r\nFROM<\/span>\r\n users<\/span>\r\nWHERE<\/span>\r\n 1<\/span> =<\/span> 1<\/span>\r\n \/*[# th:if=\"${name} != null\"]*\/<\/span>\r\n AND<\/span> name<\/span> =<\/span> \/*[(|:name|)]*\/<\/span> 'Kazuki'<\/span>\r\n \/*[\/]*\/<\/span>\r\nORDER<\/span> BY<\/span>\r\n id<\/span>\r\n<\/code><\/pre>\nSELECT<\/span>\r\n id<\/span> ,<\/span>name<\/span>\r\nFROM<\/span>\r\n users<\/span>\r\nWHERE<\/span>\r\n 1<\/span> =<\/span> 1<\/span>\r\n\r\n AND<\/span> name<\/span> =<\/span> :<\/span>name<\/span>\r\n\r\nORDER<\/span> BY<\/span>\r\n id<\/span>\r\n<\/code><\/pre>\nSELECT<\/span>\r\n id<\/span> ,<\/span>name<\/span>\r\nFROM<\/span>\r\n users<\/span>\r\nWHERE<\/span>\r\n 1<\/span> =<\/span> 1<\/span>\r\n\r\nORDER<\/span> BY<\/span>\r\n id<\/span>\r\n<\/code><\/pre>\nThymeleaf\u7684\u914d\u7f6e<\/h1>\n
\u5f88\u907a\u61be\uff0cThymeleaf\u7684\u6a21\u677f\u6a21\u5f0f\u4e2d\u6c92\u6709\u63d0\u4f9bSQL\u7684\u6a21\u5f0f\uff0c\u4f46\u662f\u6709\u8207JavaScript\u548cCSS\u76f8\u540c\u7684\u8a3b\u91cb\u683c\u5f0f\u7684\u6a21\u5f0f\u3002\u4f7f\u7528\u9019\u4e9b\u6a21\u5f0f\u53ef\u4ee5\u5be6\u73fe\u300c2-way JavaScript\u300d\u548c\u300c2-way CSS\u300d\u7684\u529f\u80fd\uff0c\u6240\u4ee5\u6211\u5011\u9078\u64c7\u4e86\u4f7f\u7528JavaScript\u7684\u6a21\u677f\u6a21\u5f0f\u3002\u6b64\u5916\uff0cSpring Boot\u7684\u9ed8\u8a8d\u8a2d\u5b9a\u4e2d\uff0c\u6a21\u677f\u6587\u4ef6\u7684\u5f8c\u7db4\uff08\u64f4\u5c55\u540d\u90e8\u5206\uff09\u662f\u8a2d\u5b9a\u70baHTML\uff08.html\uff09\uff0c\u6211\u5011\u5c07\u5176\u66f4\u6539\u70baSQL\u6587\u4ef6\u7684\u8a2d\u5b9a\uff08.sql\uff09\u3002<\/p>\n
spring.thymeleaf.mode<\/span>=<\/span>JAVASCRIPT<\/span>\r\nspring.thymeleaf.suffix<\/span>=<\/span>.sql<\/span>\r\n<\/code><\/pre>\n\u8bbe\u7f6e\u6570\u636e\u5e93<\/h1>\n
\u4e3a\u4e86\u9a8c\u8bc1\u76ee\u7684\uff0c\u8bbe\u7f6e\u6570\u636e\u5e93\uff08\u521b\u5efa\u8868\u683c+\u6dfb\u52a0\u6570\u636e\uff09\u3002<\/p>\n
\u521b\u5efa\u8868\u683c<\/h2>\nDROP<\/span> TABLE<\/span> IF<\/span> EXISTS<\/span> users<\/span>;<\/span>\r\nCREATE<\/span> TABLE<\/span> users<\/span>\r\n(<\/span>\r\n id<\/span> int<\/span>,<\/span>\r\n name<\/span> varchar<\/span>(<\/span>128<\/span>)<\/span>\r\n);<\/span>\r\n<\/code><\/pre>\n\u6570\u636e\u6ce8\u518c<\/h2>\nINSERT<\/span> INTO<\/span> users<\/span> VALUES<\/span>(<\/span>1<\/span>,<\/span> 'Kazuki'<\/span>);<\/span>\r\nINSERT<\/span> INTO<\/span> users<\/span> VALUES<\/span>(<\/span>2<\/span>,<\/span> 'Shimizu'<\/span>);<\/span>\r\n<\/code><\/pre>\n\u9a8c\u8bc1\u884c\u52a8<\/h1>\n
\u521b\u5efa\u4e00\u4e2aJUnit\u6d4b\u8bd5\u7528\u4f8b\uff0c\u9a8c\u8bc12-way SQL\u7684\u8fd0\u884c\u60c5\u51b5\u3002<\/p>\n
package<\/span> com.example.demo<\/span>;<\/span>\r\n\r\nimport<\/span> org.assertj.core.api.Assertions<\/span>;<\/span>\r\nimport<\/span> org.junit.Test<\/span>;<\/span>\r\nimport<\/span> org.junit.runner.RunWith<\/span>;<\/span>\r\nimport<\/span> org.springframework.beans.factory.annotation.Autowired<\/span>;<\/span>\r\nimport<\/span> org.springframework.boot.test.context.SpringBootTest<\/span>;<\/span>\r\nimport<\/span> org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations<\/span>;<\/span>\r\nimport<\/span> org.springframework.test.context.junit4.SpringRunner<\/span>;<\/span>\r\nimport<\/span> org.thymeleaf.ITemplateEngine<\/span>;<\/span>\r\nimport<\/span> org.thymeleaf.context.Context<\/span>;<\/span>\r\n\r\nimport<\/span> java.util.HashMap<\/span>;<\/span>\r\nimport<\/span> java.util.List<\/span>;<\/span>\r\nimport<\/span> java.util.Locale<\/span>;<\/span>\r\nimport<\/span> java.util.Map<\/span>;<\/span>\r\n\r\n@RunWith<\/span>(<\/span>SpringRunner<\/span>.<\/span>class<\/span>)<\/span>\r\n@SpringBootTest<\/span>\r\npublic<\/span> class<\/span> ThDemoApplicationTests<\/span> {<\/span>\r\n\r\n @Autowired<\/span>\r\n NamedParameterJdbcOperations<\/span>