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 추가

application.properties

#Server
 server.port=8083
 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

mybatis.config

<?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/mapper/item.xml"/>
 </mappers>
</configuration>

src/main/resources 에 mybatis.mappers추가

item.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "<https://mybatis.org/dtd/mybatis-3-mapper.dtd>">

<mapper namespace="com.boot.dao.ItemDao">

	<select id="list" resultType="com.boot.dto.ItemDto">
		select * from item
	</select>
	
	<insert id="write" parameterType="hashmap">
		insert into
		item(name,price,description) values
		(#{name}, #{price}, #{description})
	</insert>

</mapper>

DTO

package com.boot.dto;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class ItemDto {
	private String name;
	private String price;
	private String description;
}

DAO

package com.boot.dao;

import java.util.ArrayList;
import java.util.HashMap;

import org.apache.ibatis.annotations.Mapper;

import com.boot.dto.ItemDto;

@Mapper
public interface ItemDao {
	public ArrayList<ItemDto> list();
	public void write(HashMap<String, String> param);
}