Mybatis 로 Spring-Boot 와 H2DB 를 연동하기

메이븐 pom.xml 사용할때

 

<dependency>
           <groupId>org.springframework.boot</groupId>
           <artifactId>spring-boot-devtools</artifactId>
          <scope>runtime</scope>
        </dependency>
        <dependency>
           <groupId>org.projectlombok</groupId>
          <artifactId>lombok</artifactId>
          <scope>annotationProcessor</scope>
        </dependency>
        <dependency>
           <groupId>org.springframework.boot</groupId>
           <artifactId>spring-boot-starter-web-services</artifactId>
          <scope>compile</scope>
        </dependency>
       <!--  https://mvnrepository.com/artifact/com.h2database/h2 -->
       <dependency>
            <groupId>com.h2database</groupId>
           <artifactId>h2</artifactId>
            <version>1.4.200</version><!--$NO-MVN-MAN-VER$-->
           <scope>test</scope>
       </dependency>
       <!--  https://mvnrepository.com/artifact/org.apache.tomcat.embed/tomcat-embed-core -->
       <dependency>
            <groupId>org.apache.tomcat.embed</groupId>
            <artifactId>tomcat-embed-core</artifactId>
            <version>9.0.29</version><!--$NO-MVN-MAN-VER$-->
       </dependency>
       <!--  https://mvnrepository.com/artifact/org.eclipse.persistence/javax.persistence -->
       <dependency>
            <groupId>org.eclipse.persistence</groupId>
            <artifactId>javax.persistence</artifactId>
           <version>2.2.1</version>
       </dependency>
        <dependency>
           <groupId>org.mariadb.jdbc</groupId>
           <artifactId>mariadb-java-client</artifactId>
        </dependency>
    </dependencies>

 

 

 

DatabaseConfig.java

 

package com.bitcamp.web;
import org.h2.server.web.WebServlet;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
 
 
/**
* DatabaseConfig
*/
@Configuration
public class DatabaseConfig {
 
 
    @Bean
    public ServletRegistrationBean h2servletRegistration() {
        ServletRegistrationBean registration = new ServletRegistrationBean(new WebServlet());
        registration.addUrlMappings("/console/*");
        return registration;
    }
}
 

 

application.properties

 

spring.mvc.view.prefix=/
spring.mvc.view.suffix=.html

 

application.yml

 

spring:
    datasource:
        url: jdbc:h2:mem:testdb;
        driverClassName: org.h2.Driver
        username: sa
        password:
    jpa:
        database-platform: org.hibernate.dialect.H2Dialect

 

data.sql

 

DROP TABLE IF EXISTS customers;
CREATE TABLE customers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  customer_id VARCHAR(15) UNIQUE NOT NULL,
  customer_name VARCHAR(15) NOT NULL,
  pwd VARCHAR(50) NOT NULL,
  ssn VARCHAR(50) UNIQUE NOT NULL,
  phone VARCHAR(50) NOT NULL,
  city VARCHAR(110) NOT NULL,
  addr VARCHAR(110) NOT NULL,
  postalcode VARCHAR(50) NOT NULL,
  photo VARCHAR(50) DEFAULT 'defaut_photo'
)DEFAULT CHARSET=utf8;
commit;