{"id":39874,"date":"2023-06-25T04:51:39","date_gmt":"2023-05-02T17:49:04","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/"},"modified":"2024-04-30T10:34:11","modified_gmt":"2024-04-30T02:34:11","slug":"%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/","title":{"rendered":"\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684H2\u6570\u636e\u5e93"},"content":{"rendered":"<h1>\u6982\u62ec<\/h1>\n<p>\u6211\u6b63\u5728\u5f00\u53d1\u4e00\u4e2a\u7528\u4e8e\u7ba1\u7406\u72ec\u7acb\u97f3\u4e50\u6f14\u51fa\u6d3b\u52a8\u65e5\u671f\u548c\u8bbf\u5ba2\u6e05\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff0c\u4f7f\u7528Spring Boot\u3002<br \/>\n\u5728\u5b9e\u65bd\u5355\u5143\u6d4b\u8bd5\u65f6\uff0c\u6211\u4e3a\u4e86\u6d4b\u8bd5\u800c\u51c6\u5907\u4e86\u4e00\u4e2aH2\u5185\u5b58\u6570\u636e\u5e93\uff0c\u4f46\u5b83\u6839\u672c\u4e0d\u8bfb\u53d6\u4efb\u4f55\u6570\u636e\uff0c\u8ba9\u6211\u975e\u5e38\u56f0\u60d1\uff0c\u6240\u4ee5\u6211\u505a\u4e86\u4e00\u4e9b\u5907\u5fd8\u5f55\u3002<\/p>\n<h1>\u73af\u5883<\/h1>\n<p>\u64cd\u4f5c\u7cfb\u7edf Windows10<br \/>\n\u96c6\u6210\u5f00\u53d1\u73af\u5883 Eclipse \u7248\u672c\uff1a2020-06 (4.16.0)<br \/>\nJava 11<br \/>\nSpring Boot 2.4.0<\/p>\n<h1>\u6211\u505a\u8fc7\u7684\u4e8b\u60c5 (W\u01d2 zu\u00f2 gu\u00f2 de<\/h1>\n<p>\u5728Gradle\u7684dependencies\u4e2d\u6dfb\u52a0 &#8220;runtimeOnly &#8216;com.h2database:h2&#8242;&#8221;\u3002<\/p>\n<pre class=\"post-pre\"><code>\r\n<span class=\"k\">dependencies<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"n\">implementation<\/span> <span class=\"s1\">'org.springframework.boot:spring-boot-starter-thymeleaf'<\/span>\r\n    <span class=\"n\">implementation<\/span> <span class=\"s1\">'org.springframework.boot:spring-boot-starter-validation'<\/span>\r\n    <span class=\"n\">implementation<\/span> <span class=\"s1\">'org.springframework.boot:spring-boot-starter-web'<\/span>\r\n    <span class=\"n\">implementation<\/span> <span class=\"s1\">'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.1.4'<\/span>\r\n    <span class=\"n\">implementation<\/span> <span class=\"s1\">'org.thymeleaf.extras:thymeleaf-extras-springsecurity5'<\/span>\r\n    <span class=\"n\">implementation<\/span> <span class=\"s1\">'org.springframework.boot:spring-boot-starter-security'<\/span>\r\n    <span class=\"n\">compileOnly<\/span> <span class=\"s1\">'org.projectlombok:lombok'<\/span>\r\n    <span class=\"n\">runtimeOnly<\/span> <span class=\"s1\">'mysql:mysql-connector-java'<\/span>\r\n    <span class=\"n\">runtimeOnly<\/span> <span class=\"s1\">'com.h2database:h2'<\/span>\r\n    <span class=\"n\">developmentOnly<\/span> <span class=\"s1\">'org.springframework.boot:spring-boot-devtools'<\/span>\r\n    <span class=\"n\">annotationProcessor<\/span> <span class=\"s1\">'org.projectlombok:lombok'<\/span>\r\n    <span class=\"n\">testImplementation<\/span> <span class=\"s1\">'org.springframework.boot:spring-boot-starter-test'<\/span>\r\n    <span class=\"n\">testImplementation<\/span> <span class=\"s1\">'org.springframework.security:spring-security-test'<\/span>\r\n    <span class=\"n\">testImplementation<\/span> <span class=\"s1\">'org.mybatis.spring.boot:mybatis-spring-boot-starter-test:2.1.4'<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<p>\u4e3a\u4e86\u5b9e\u73b0\u5355\u5143\u6d4b\u8bd5\uff0c\u9700\u5728src\/test\/resources\u76ee\u5f55\u4e0b\u521b\u5efatest.properties\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"py\">spring.datasource.driverClassName<\/span><span class=\"p\">=<\/span><span class=\"s\">org.h2.Driver<\/span>\r\n<span class=\"py\">spring.datasource.url<\/span><span class=\"p\">=<\/span><span class=\"s\">jdbc:h2:mem:testdb;DB_CLOSE_ON_EXIT=TRUE;MODE=MySQL<\/span>\r\n<span class=\"py\">spring.datasource.username<\/span><span class=\"p\">=<\/span><span class=\"s\">sa<\/span>\r\n<span class=\"py\">spring.datasource.password<\/span><span class=\"p\">=<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u5728 src\/test\/resources \u76ee\u5f55\u4e0b\u6307\u5b9a\u8981\u5728\u6d4b\u8bd5\u542f\u52a8\u65f6\u521b\u5efa\u7684\u8868\u548c\u6570\u636e\u3002<\/p>\n<pre class=\"post-pre\"><code>CREATE TABLE IF NOT EXISTS live_list(\r\n        dateId INT(10) PRIMARY KEY NOT NULL,\r\n        place VARCHAR(100) NOT NULL ,\r\n        remarks VARCHAR(200)\r\n        );\r\n\r\nCREATE TABLE IF NOT EXISTS customers_list(\r\n        id INT(10) AUTO_INCREMENT PRIMARY KEY NOT NULL,\r\n        dateId INT(10) NOT NULL,\r\n        name VARCHAR(50) NOT NULL ,\r\n        number INT(5) NOT NULL ,\r\n        remarks VARCHAR(200)\r\n        );\r\n\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>INSERT INTO live_list VALUES(20201210, '\u30a2\u30e1\u30ea\u30ab\u6751', '\u30ad\u30e3\u30d110');\r\nINSERT INTO live_list VALUES(20210105, '\u6771\u4eac\u30a8\u30b8\u30d7\u30c8', '\u30ad\u30e3\u30d150');\r\n\r\nINSERT INTO customers_list VALUES(NULL, 20201210, '\u7530\u4e2d\u6a29\u8535', 1, '\u6700\u8fd1\u6765\u305f');\r\nINSERT INTO customers_list VALUES(NULL, 20210105, '\u5fa1\u624b\u6d17\u4fca\u4e94\u90ce', 3, '\u3044\u3064\u3082\u304f\u308b');\r\n\r\n<\/code><\/pre>\n<p>\u6211\u5df2\u7ecf\u51c6\u5907\u597d\u5230\u8fd9\u91cc\uff0c\u5e76\u5728Mapper\u7c7b\u4e2d\u5b9e\u73b0\u4e86\u7b80\u5355\u7684\u6d4b\u8bd5\u3002<br \/>\n\u786e\u8ba4\u8c03\u7528\u6570\u636e\u5e93\u4e2d\u51c6\u5907\u597d\u7684\u6570\u636e\u662f\u5426\u53ef\u7528\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"kn\">package<\/span> <span class=\"nn\">product.MapperTest<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">static<\/span> <span class=\"n\">org<\/span><span class=\"o\">.<\/span><span class=\"na\">assertj<\/span><span class=\"o\">.<\/span><span class=\"na\">core<\/span><span class=\"o\">.<\/span><span class=\"na\">api<\/span><span class=\"o\">.<\/span><span class=\"na\">Assertions<\/span><span class=\"o\">.*;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">java.util.List<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.junit.Test<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.junit.runner.RunWith<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.mybatis.spring.boot.test.autoconfigure.MybatisTest<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.beans.factory.annotation.Autowired<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.test.context.TestPropertySource<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.test.context.junit4.SpringRunner<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">product.domain.CustomerList<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">product.domain.LiveList<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">product.mapper.LiveListMapper<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@RunWith<\/span><span class=\"o\">(<\/span><span class=\"nc\">SpringRunner<\/span><span class=\"o\">.<\/span><span class=\"na\">class<\/span><span class=\"o\">)<\/span>\r\n<span class=\"nd\">@MybatisTest<\/span>\r\n<span class=\"nd\">@TestPropertySource<\/span><span class=\"o\">(<\/span><span class=\"n\">locations<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"classpath:test.properties\"<\/span><span class=\"o\">)<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">LiveListMapperTest<\/span> <span class=\"o\">{<\/span>\r\n\r\n    <span class=\"nd\">@Autowired<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">LiveListMapper<\/span> <span class=\"n\">mapperTest<\/span><span class=\"o\">;<\/span>\r\n\r\n    <span class=\"nd\">@Test<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"n\">\u516c\u6f14\u65e5\u30ea\u30b9\u30c8\u304c\u5168\u4ef6\u53d6\u5f97\u3067\u304d\u308b\u3053\u3068<\/span><span class=\"o\">()<\/span> <span class=\"kd\">throws<\/span> <span class=\"nc\">Exception<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">LiveList<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">acutual<\/span> <span class=\"o\">=<\/span> <span class=\"n\">mapperTest<\/span><span class=\"o\">.<\/span><span class=\"na\">liveFindAll<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">acutual<\/span><span class=\"o\">.<\/span><span class=\"na\">size<\/span><span class=\"o\">()).<\/span><span class=\"na\">isEqualTo<\/span><span class=\"o\">(<\/span><span class=\"mi\">2<\/span><span class=\"o\">);<\/span>\r\n    <span class=\"o\">}<\/span>\r\n\r\n    <span class=\"nd\">@Test<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"n\">\u6765\u5834\u5ba2\u30ea\u30b9\u30c8\u304c\u5168\u4ef6\u53d6\u5f97\u3067\u304d\u308b\u3053\u3068<\/span><span class=\"o\">()<\/span> <span class=\"kd\">throws<\/span> <span class=\"nc\">Exception<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">CustomerList<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">acutual<\/span> <span class=\"o\">=<\/span> <span class=\"n\">mapperTest<\/span><span class=\"o\">.<\/span><span class=\"na\">customerFindAll<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">assertThat<\/span><span class=\"o\">(<\/span><span class=\"n\">acutual<\/span><span class=\"o\">.<\/span><span class=\"na\">size<\/span><span class=\"o\">()).<\/span><span class=\"na\">isEqualTo<\/span><span class=\"o\">(<\/span><span class=\"mi\">2<\/span><span class=\"o\">);<\/span>\r\n    <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<p>\u6267\u884c\u540e\u51fa\u73b0\u4e86\u4ee5\u4e0b\u9519\u8bef\u3002<\/p>\n<pre class=\"post-pre\"><code>java.lang.IllegalStateException: Failed to load ApplicationContext\r\n    at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:132) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:123) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:118) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener.prepareTestInstance(SpringBootDependencyInjectionTestExecutionListener.java:43) ~[spring-boot-test-autoconfigure-2.4.0.jar:2.4.0]\r\n    at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:244) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:227) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:289) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) ~[org.junit_4.13.0.v20200204-1500.jar:4.13]\r\n    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:291) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:246) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) ~[org.junit_4.13.0.v20200204-1500.jar:4.13]\r\n    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) ~[org.junit_4.13.0.v20200204-1500.jar:4.13]\r\n    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) ~[org.junit_4.13.0.v20200204-1500.jar:4.13]\r\n    at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) ~[org.junit_4.13.0.v20200204-1500.jar:4.13]\r\n    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) ~[org.junit_4.13.0.v20200204-1500.jar:4.13]\r\n    at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) ~[org.junit_4.13.0.v20200204-1500.jar:4.13]\r\n    at org.junit.runners.ParentRunner.run(ParentRunner.java:413) ~[org.junit_4.13.0.v20200204-1500.jar:4.13]\r\n    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89) ~[.cp\/:na]\r\n    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41) ~[.cp\/:na]\r\n    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:542) ~[.cp\/:na]\r\n    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:770) ~[.cp\/:na]\r\n    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:464) ~[.cp\/:na]\r\n    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:210) ~[.cp\/:na]\r\nCaused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #3 of URL [file:\/C:\/Users\/keita\/Documents\/pleiades-2020-06-java-win-64bit-jre_20200702\/pleiades\/workspace\/TicketManegerTool\/bin\/default\/data.sql]: INSERT INTO customers_list VALUES(0, 20201210, '\u7530\u4e2d\u6a29\u8535', 1, '\u6700\u8fd1\u6765\u305f') INSERT INTO customers_list VALUES(0, 20210105, '\u5fa1\u624b\u6d17\u4fca\u4e94\u90ce', 3, '\u305f\u304f\u3055\u3093\u304f\u308b'); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: SQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306b\u6587\u6cd5\u30a8\u30e9\u30fc\u304c\u3042\u308a\u307e\u3059 \"INSERT INTO CUSTOMERS_LIST VALUES(0, 20201210, '\u7530\u4e2d\u6a29\u8535', 1, '\u6700\u8fd1\u6765\u305f') INSERT[*] INTO CUSTOMERS_LIST VALUES(0, 20210105, '\u5fa1\u624b\u6d17\u4fca\u4e94\u90ce', 3, '\u305f\u304f\u3055\u3093\u304f\u308b')\"\r\nSyntax error in SQL statement \"INSERT INTO CUSTOMERS_LIST VALUES(0, 20201210, '\u7530\u4e2d\u6a29\u8535', 1, '\u6700\u8fd1\u6765\u305f') INSERT[*] INTO CUSTOMERS_LIST VALUES(0, 20210105, '\u5fa1\u624b\u6d17\u4fca\u4e94\u90ce', 3, '\u305f\u304f\u3055\u3093\u304f\u308b')\"; SQL statement:\r\nINSERT INTO customers_list VALUES(0, 20201210, '\u7530\u4e2d\u6a29\u8535', 1, '\u6700\u8fd1\u6765\u305f') INSERT INTO customers_list VALUES(0, 20210105, '\u5fa1\u624b\u6d17\u4fca\u4e94\u90ce', 3, '\u305f\u304f\u3055\u3093\u304f\u308b') [42000-200]\r\n    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1788) ~[spring-beans-5.3.1.jar:5.3.1]\r\n    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:609) ~[spring-beans-5.3.1.jar:5.3.1]\r\n    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:531) ~[spring-beans-5.3.1.jar:5.3.1]\r\n    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.1.jar:5.3.1]\r\n    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.1.jar:5.3.1]\r\n    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.1.jar:5.3.1]\r\n    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.1.jar:5.3.1]\r\n    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:944) ~[spring-beans-5.3.1.jar:5.3.1]\r\n    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:925) ~[spring-context-5.3.1.jar:5.3.1]\r\n    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:588) ~[spring-context-5.3.1.jar:5.3.1]\r\n    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:767) ~[spring-boot-2.4.0.jar:2.4.0]\r\n    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) ~[spring-boot-2.4.0.jar:2.4.0]\r\n    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:426) ~[spring-boot-2.4.0.jar:2.4.0]\r\n    at org.springframework.boot.SpringApplication.run(SpringApplication.java:326) ~[spring-boot-2.4.0.jar:2.4.0]\r\n    at org.springframework.boot.test.context.SpringBootContextLoader.loadContext(SpringBootContextLoader.java:122) ~[spring-boot-test-2.4.0.jar:2.4.0]\r\n    at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:99) ~[spring-test-5.3.1.jar:5.3.1]\r\n    at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124) ~[spring-test-5.3.1.jar:5.3.1]\r\n    ... 27 common frames omitted\r\n<\/code><\/pre>\n<h1>The reason for something. (\u67d0\u4e8b\u7684\u539f\u56e0)<\/h1>\n<p>\u4ee5\u4e0a\u53ef\u4ee5\u5f97\u51fa\u7ed3\u8bba\uff0c\u5728test.properties\u6587\u4ef6\u4e2d\u672a\u6307\u5b9a\u8981\u521b\u5efa\u7684\u6570\u636e\u548c\u8868\u7684\u4fe1\u606f\u3002<br \/>\n\u53c2\u8003\u94fe\u63a5\uff1ahttps:\/\/qiita.com\/niwasawa\/items\/af6c5485c1c71d55d7dd<\/p>\n<p>\u5728test.properties\u6587\u4ef6\u4e2d<\/p>\n<pre class=\"post-pre\"><code>spring.datasource.schema=classpath:schema.sql\r\nspring.datasource.data=classpath:data.sql\r\n<\/code><\/pre>\n<p>\u901a\u8fc7\u6dfb\u52a0\uff0c\u6d4b\u8bd5\u73b0\u5728\u53ef\u4ee5\u6b63\u5e38\u8fd0\u884c\u3002<\/p>\n<p>\u6211\u82b1\u4e86\u5f88\u957f\u65f6\u95f4\uff0c\u56e0\u4e3a\u5728\u9605\u8bfb\u9519\u8bef\u4fe1\u606f\u65f6\u663e\u793a\u4e86SQL\u8bed\u6cd5\u9519\u8bef\uff0c\u6240\u4ee5\u6211\u4e00\u76f4\u5728\u52aa\u529b\u67e5\u627eSQL\u8bed\u53e5\u7684\u9519\u8bef\u3002<br \/>\n\u7b80\u800c\u8a00\u4e4b\uff0c\u8fd9\u662f\u56e0\u4e3a\u5728data.sql\u6587\u4ef6\u4e2d\uff0c\u5c1d\u8bd5\u8fdb\u884cINSERT\u64cd\u4f5c\u7684\u6570\u636e\u65e0\u6cd5\u786e\u5b9a\u5e94\u8be5\u63d2\u5165\u5230\u4f55\u5904\uff0c\u6240\u4ee5\u51fa\u73b0\u4e86\u9519\u8bef\u3002\u4f5c\u4e3a\u4ee5\u540e\u7684\u6559\u8bad\uff0c\u6211\u5c06\u4e0d\u518d\u4ec5\u4ec5\u76f8\u4fe1\u8bed\u6cd5\u9519\u8bef\uff0c\u5e76\u4e14\u4f1a\u8ba4\u771f\u68c0\u67e5\u8def\u5f84\u7684\u6307\u5b9a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u62ec \u6211\u6b63\u5728\u5f00\u53d1\u4e00\u4e2a\u7528\u4e8e\u7ba1\u7406\u72ec\u7acb\u97f3\u4e50\u6f14\u51fa\u6d3b\u52a8\u65e5\u671f\u548c\u8bbf\u5ba2\u6e05\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff0c\u4f7f\u7528Spring Boot\u3002 \u5728\u5b9e\u65bd\u5355\u5143 [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-39874","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684H2\u6570\u636e\u5e93 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684h2\u6570\u636e\u5e93\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684H2\u6570\u636e\u5e93\" \/>\n<meta property=\"og:description\" content=\"\u6982\u62ec \u6211\u6b63\u5728\u5f00\u53d1\u4e00\u4e2a\u7528\u4e8e\u7ba1\u7406\u72ec\u7acb\u97f3\u4e50\u6f14\u51fa\u6d3b\u52a8\u65e5\u671f\u548c\u8bbf\u5ba2\u6e05\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff0c\u4f7f\u7528Spring Boot\u3002 \u5728\u5b9e\u65bd\u5355\u5143 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684h2\u6570\u636e\u5e93\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-02T17:49:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T02:34:11+00:00\" \/>\n<meta name=\"author\" content=\"\u6587, \u7fd4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6587, \u7fd4\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/\",\"name\":\"\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684H2\u6570\u636e\u5e93 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-05-02T17:49:04+00:00\",\"dateModified\":\"2024-04-30T02:34:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684H2\u6570\u636e\u5e93\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\",\"name\":\"\u6587, \u7fd4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"caption\":\"\u6587, \u7fd4\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684H2\u6570\u636e\u5e93 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684h2\u6570\u636e\u5e93\/","og_locale":"zh_CN","og_type":"article","og_title":"\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684H2\u6570\u636e\u5e93","og_description":"\u6982\u62ec \u6211\u6b63\u5728\u5f00\u53d1\u4e00\u4e2a\u7528\u4e8e\u7ba1\u7406\u72ec\u7acb\u97f3\u4e50\u6f14\u51fa\u6d3b\u52a8\u65e5\u671f\u548c\u8bbf\u5ba2\u6e05\u5355\u7684\u5e94\u7528\u7a0b\u5e8f\uff0c\u4f7f\u7528Spring Boot\u3002 \u5728\u5b9e\u65bd\u5355\u5143 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684h2\u6570\u636e\u5e93\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-05-02T17:49:04+00:00","article_modified_time":"2024-04-30T02:34:11+00:00","author":"\u6587, \u7fd4","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6587, \u7fd4","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/","name":"\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684H2\u6570\u636e\u5e93 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-05-02T17:49:04+00:00","dateModified":"2024-04-30T02:34:11+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u52a0\u8f7d\u7528\u4e8e\u5355\u5143\u6d4b\u8bd5\u7684H2\u6570\u636e\u5e93"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c","name":"\u6587, \u7fd4","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","caption":"\u6587, \u7fd4"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%8a%a0%e8%bd%bd%e7%94%a8%e4%ba%8e%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95%e7%9a%84h2%e6%95%b0%e6%8d%ae%e5%ba%93\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/39874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=39874"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/39874\/revisions"}],"predecessor-version":[{"id":91385,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/39874\/revisions\/91385"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=39874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=39874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=39874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}