Spring boot - MySQL 연동

Environment

• Mac OS X
• IntelliJ IDEA 
• Maven 3.3 
• Spring boot 2.1.6
• MySQL 8.0.16
  •  설치 참조 :: https://jum-dev.tistory.com/79

 

Spring boot 에서 MySQL 연동해보자. 

 

1. pom.xml 에 관련 dependency를 추가.

 <!-- MyBatis -->
<dependency>
	<groupId>org.mybatis.spring.boot</groupId>
	<artifactId>mybatis-spring-boot-starter</artifactId>
	<version>2.0.0</version>
</dependency>
<!-- MySQL -->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>8.0.15</version>
</dependency>

 

2. application.properties 파일에 DB connection 관련 정보를 추가해본다. 

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/testdb
spring.datasource.username=testuser
spring.datasource.password=testpwd