20230712144908.png

application.properties

#Server
 server.port=8082
 server.servlet.session.timeout=360000
 
 #Spring MVC
 spring.mvc.view.prefix=/WEB-INF/views/
 spring.mvc.view.suffix=.jsp
 
 #Database config
 spring.datasource.url=jdbc:oracle:thin:@localhost:1521:XE
 spring.datasource.username=scott
 spring.datasource.password=tiger
 spring.datasource.driverClassName=oracle.jdbc.driver.OracleDriver
 
 #mybatis config
 mybatis.config-location=classpath:mybatis-config.xml

build.gradle

plugins {
	id 'java'
	id 'org.springframework.boot' version '2.7.13'
	id 'io.spring.dependency-management' version '1.0.15.RELEASE'
}

group = 'com.boot'
version = '0.0.1-SNAPSHOT'

java {
	sourceCompatibility = '1.8'
}

configurations {
	compileOnly {
		extendsFrom annotationProcessor
	}
}

repositories {
	mavenCentral()
}

dependencies {
	implementation 'org.springframework.boot:spring-boot-starter-web'
	implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.3.1'
	implementation 'org.springframework.boot:spring-boot-starter-jdbc'
	implementation 'org.apache.tomcat.embed:tomcat-embed-jasper'
	implementation 'javax.servlet:jstl:1.2'
	implementation fileTree(dir: 'libs', include: ['*.jar'])
    implementation files('libs/ojdbc6.jar')
	compileOnly 'org.projectlombok:lombok'
	annotationProcessor 'org.projectlombok:lombok'
	testImplementation 'org.springframework.boot:spring-boot-starter-test'
	testImplementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter-test:2.3.1'
}

tasks.named('test') {
	useJUnitPlatform()
}

ojdbc6.jar

프로젝트 폴더 ⇒ libs 폴더 생성 ⇒ ojdbc6.jar 파일 붙여넣기

mybatis-config.xml

20230712150438.png

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "<http://mybatis.org/dtd/mybatis-3-config.dtd>">
<configuration>
 <mappers>
<!--  SQL 저장파일(+경로) -->
 	<mapper resource = "mybatis/mappers/board.xml"/>
 </mappers>
</configuration>

20230712150841.png

게시판

board.xml