spring boot - 4. mysql 연동(mybatis)

라이브러리 추가

jdbc
compile('org.springframework.boot:spring-boot-starter-jdbc')
compile('mysql:mysql-connector-java')

mybatis
compile("org.mybatis.spring.boot:mybatis-spring-boot-starter:1.1.1")
compile("org.mybatis:mybatis-spring")
compile("org.mybatis:mybatis")

 

 

/dashboard/src/main/resources/application.properties
------------------------------------------------------------------
spring.datasource.driver-class-name= com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/db명
spring.datasource.username=아이디
spring.datasource.password=비밀번호
------------------------------------------------------------------

 

 

VO 생성 : /dashboard/src/main/java/com/lin/dashboard/vo/SearchVO.java

 

mapper.java 생성 : /dashboard/src/main/java/com/lin/dashboard/mapper/DashboardMapper.java

 

mapper.xml 생성 : /dashboard/src/main/resources/mapper/DashboardMapper.xml

 

DashboardApplication.java 수정 : /dashboard/src/main/java/com/lin/dashboard/DashboardApplication.java

 

DashboardController.java 수정 : /dashboard/src/main/java/com/lin/dashboard/controller/DashboardController.java

 

main.jsp 수정 : /dashboard/src/main/webapp/WEB-INF/view/main.jsp

 

 

테스트

 

 

끝