MyBatis

📦 spring-mybatis │ └───📂java │ └───📂com.aloha.springmybatis │ │ │ ├───📂controller │ │ └───📄BoardController.java │ │ │ ├───📂dto │ │ └───📄Board.java │ │ │ ├───📂service │ │ │ │ │ ├───📄BoardService.java │ │ └───📄BoardServiceImpl.java │ │ │ └───📂mapper │ └───📄BoardMapper.java │ └───📂resources │ 📄application.properties │ 📄mybatis-config.xml │ └───📂com.aloha.springmybatis.mapper └────📄BoardMapper.xml

runtimeOnly 'com.mysql:mysql-connector-j'

implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:3.0.3' testImplementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter-test:3.0.3'

plugins { id 'java' id 'war' id 'org.springframework.boot' version '3.3.5' id 'io.spring.dependency-management' version '1.1.6' } group = 'com.aloha' version = '0.0.1-SNAPSHOT' java { toolchain { languageVersion = JavaLanguageVersion.of(17) } } configurations { compileOnly { extendsFrom annotationProcessor } } repositories { mavenCentral() } dependencies { implementation 'org.springframework.boot:spring-boot-starter-thymeleaf' implementation 'org.springframework.boot:spring-boot-starter-web' implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:3.0.3' compileOnly 'org.projectlombok:lombok' developmentOnly 'org.springframework.boot:spring-boot-devtools' runtimeOnly 'com.mysql:mysql-connector-j' annotationProcessor 'org.projectlombok:lombok' providedRuntime 'org.springframework.boot:spring-boot-starter-tomcat' testImplementation 'org.springframework.boot:spring-boot-starter-test' testImplementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter-test:3.0.3' testRuntimeOnly 'org.junit.platform:junit-platform-launcher' } tasks.named('test') { useJUnitPlatform() }

<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.27</version> <scope>runtime</scope> </dependency>

<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>3.0.3</version> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter-test</artifactId> <version>3.0.3</version> <scope>test</scope> </dependency>

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>3.3.5</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.example</groupId> <artifactId>demo</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>war</packaging> <name>mybatis</name> <description>Demo project for Spring Boot</description> <url/> <licenses> <license/> </licenses> <developers> <developer/> </developers> <scm> <connection/> <developerConnection/> <tag/> <url/> </scm> <properties> <java.version>17</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>3.0.3</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> <scope>runtime</scope> <optional>true</optional> </dependency> <dependency> <groupId>com.mysql</groupId> <artifactId>mysql-connector-j</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-tomcat</artifactId> <scope>provided</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter-test</artifactId> <version>3.0.3</version> <scope>test</scope> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <configuration> <excludes> <exclude> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </exclude> </excludes> </configuration> </plugin> </plugins> </build> </project>

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "https://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <!-- 설정 --> <settings> <!-- 언더스코어 케이스인 컬럼을 카멜 케이스로 변환하는 설정 --> <!-- board_no - boardNo --> <setting name="mapUnderscoreToCamelCase" value="true"/> </settings> <!-- 타입 별칭 설정 --> <typeAliases> <!-- 테이블과 매핑할 DTO가 있는 패키지 경로 지정 --> <package name="com.aloha.mybatis.dto"/> </typeAliases> </configuration>

<settings> <!-- 언더스코어 케이스인 컬럼을 카멜 케이스로 변환하는 설정 --> <!-- board_no - boardNo --> <setting name="mapUnderscoreToCamelCase" value="true"/> </settings>

<typeAliases> <!-- 테이블과 매핑할 DTO가 있는 패키지 경로 지정 --> <package name="com.aloha.mybatis.dto"/> </typeAliases>

<!-- 게시글 조회 --> <select id="select" resultType="com.aloha.mybatis.dto.Board">

<!-- 게시글 조회 --> <select id="select" resultType="Board">

# 데이터 소스 - MySQL spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://127.0.0.1:3306/aloha?serverTimezone=Asia/Seoul&allowPublicKeyRetrieval=true&useSSL=false&autoReconnection=true&autoReconnection=true spring.datasource.username=aloha spring.datasource.password=123456

# Mybatis 설정 # Mybatis 설정 경로 : ~/resources/mybatis-config.xml mybatis.config-location=classpath:mybatis-config.xml # Mybatis 매퍼 파일 경로 : ~/메인패키지/mapper/**Mapper.xml mybatis.mapper-locations=classpath:mybatis/mapper/**/**.xml

# 컬럼명을 변수명으로 자동매핑 : board_no ➡ boardNo mybatis.configuration.map-underscore-to-camel-case=true # resultType 속성에서 dto 객체 (패키지.클래스명) ➡ (클래스명) mybatis.type-aliases-package=com.aloha.mybatis.dto # Mybatis 매퍼 파일 경로 : ~/메인패키지/mapper/**Mapper.xml mybatis.mapper-locations=classpath:mybatis/mapper/**/**.xml

spring.application.name=spring-mybatis # 데이터 소스 - MySQL spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://127.0.0.1:3306/aloha?serverTimezone=Asia/Seoul&allowPublicKeyRetrieval=true&useSSL=false&autoReconnection=true&autoReconnection=true spring.datasource.username=aloha spring.datasource.password=123456 # Mybatis 설정 # Mybatis 설정 경로 : ~/resources/mybatis-config.xml # mybatis.config-location=classpath:mybatis-config.xml # 컬럼명을 변수명으로 자동매핑 : board_no ➡ boardNo mybatis.configuration.map-underscore-to-camel-case=true # resultType 속성에서 dto 객체 (패키지.클래스명) ➡ (클래스명) mybatis.type-aliases-package=com.aloha.mybatis.dto # Mybatis 매퍼 파일 경로 : ~/메인패키지/mapper/**Mapper.xml mybatis.mapper-locations=classpath:mybatis/mapper/**/**.xml

CREATE TABLE `board` ( `no` int NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `writer` varchar(100) NOT NULL, `content` text, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `views` int NOT NULL DEFAULT '0', PRIMARY KEY (`no`) ) COMMENT='게시판';

/** * Board * - 게시글 정보 */ @Data public class Board { private int no; private String title; private String writer; private String content; private Date createdAt; private Date updatedAt; private int views; }

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!-- namespace="매퍼 인터페이스 경로" --> <mapper namespace="com.aloha.mybatis.mapper.XXXMapper"> </mapper>

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!-- namespace="매퍼 인터페이스 경로" --> <mapper namespace="com.aloha.mybatis.mapper.BaseMapper"> <!-- 기본 등록 --> <insert id="insert"> INSERT INTO base( base_id, base_name ) VALUES ( #{baseId}, #{baseName} ) </insert> <!-- 기본 조회 --> <select id="select" resultType="base"> SELECT * FROM base WHERE base_no = #{baseNo} </select> <!-- 기본 수정 --> <update id="update"> UPDATE base SET base_id = #{baseId} ,base_name = #{baseName} WHERE base_no = #{baseNo} </update> <!-- 기본 수정 --> <delete id="delete"> DELETE FROM base WHERE base_no = #{baseNo} </delete> </mapper>

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!-- namespace="매퍼 인터페이스 경로" --> <mapper namespace="com.aloha.mybatis.mapper.BoardMapper"> <!-- 게시글 목록 --> <select id="list" resultType="Board"> SELECT * FROM board ORDER BY created_at DESC </select> <!-- 게시글 조회 --> <select id="select" resultType="Board"> SELECT * FROM board WHERE no = #{no} </select> <!-- 게시글 등록 --> <insert id="insert"> INSERT INTO board( title, writer, content) VALUES ( #{title}, #{writer}, #{content} ) </insert> <!-- 게시글 수정 --> <update id="update"> UPDATE board SET title = #{title} ,writer = #{writer} ,content = #{content} WHERE no = #{no} </update> <!-- 게시글 삭제 --> <delete id="delete"> DELETE FROM board WHERE no = #{no} </delete> <!-- 게시글 번호 최댓값 --> <select id="maxPk" resultType="int"> SELECT MAX(no) FROM board </select> </mapper>

@Mapper public interface BoardMapper { // 게시글 목록 public List<Board> list() throws Exception; // 게시글 조회 public Board select(int no) throws Exception; // 게시글 등록 public int insert(Board board) throws Exception; // 게시글 수정 public int update(Board board) throws Exception; // 게시글 삭제 public int delete(int no) throws Exception; // 게시글 번호(기본키) 최댓값 public int maxPk() throws Exception; }

public interface BoardService { // 게시글 목록 public List<Board> list() throws Exception; // 게시글 조회 public Board select(int no) throws Exception; // 게시글 등록 public int insert(Board board) throws Exception; // 게시글 수정 public int update(Board board) throws Exception; // 게시글 삭제 public int delete(int no) throws Exception; }

@Service // 서비스 역할의 스프링 빈 public class BoardServiceImpl implements BoardService { @Autowired private BoardMapper boardMapper; /** * 게시글 목록 조회 */ @Override public List<Board> list() throws Exception { // TODO : boardMapper 로 list() 호출 /* * ➡ List<Board> boardList 로 받아옴 * ➡ return boardList */ List<Board> boardList = boardMapper.list(); return boardList; } /** * 게시글 조회 * - no 매개변수로 게시글 번호를 전달받아서 * 데이터베이스에 조회 요청 */ @Override public Board select(int no) throws Exception { // TODO : boardMapper 로 select(no) 호출 /* * ➡ Board board 로 받아옴 * ➡ return board */ Board board = boardMapper.select(no); return board; } /** * 게시글 등록 */ @Override public int insert(Board board) throws Exception { // TODO : boardMapper 로 insert(Board) 호출 /* * ➡ int result 로 데이터 처리 행(개수) 받아옴 * ➡ return result */ int result = boardMapper.insert(board); return result; } /** * 게시글 수정 */ @Override public int update(Board board) throws Exception { // TODO : boardMapper 로 update(Board) 호출 /* * ➡ int result 로 데이터 처리 행(개수) 받아옴 * ➡ return result */ int result = boardMapper.update(board); return result; } /** * 게시글 삭제 */ @Override public int delete(int no) throws Exception { // TODO : boardMapper 로 delete(no) 호출 /* * ➡ int result 로 데이터 처리 행(개수) 받아옴 * ➡ return result */ int result = boardMapper.delete(no); return result; } }

package com.aloha.mybatis.controller; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import com.aloha.springmybatis.dto.Board; import com.aloha.springmybatis.service.BoardService; import lombok.extern.slf4j.Slf4j; import org.springframework.web.bind.annotation.RequestBody; /** * /board 경로로 요청 왔을 때 처리 * [GET] - /board/list : 게시글 목록 화면 * [GET] - /board/read : 게시글 조회 화면 * [GET] - /board/insert : 게시글 등록 화면 * [POST] - /board/insert : 게시글 등록 처리 * [GET] - /board/update : 게시글 수정 화면 * [POST] - /board/update : 게시글 수정 처리 * [POST] - /board/delete : 게시글 삭제 처리 */ @Slf4j // 로그 어노테이션 @Controller // 컨트롤러 스프링 빈으로 등록 @RequestMapping("/board") // 클레스 레벨 요청 경로 매핑 // - /board/~ 경로의 요청은 이 컨트롤러에서 처리 public class BoardController { // ⭐데이터 요청과 화면 출력 // Controller --> Service (데이터 요청) // Controller <-- Service (데이터 전달) // Controller --> Model (모델 등록) // View <-- Model (데이터 출력) @Autowired // 의존성 자동 주입 private BoardService boardService; // @Service를 --Impl 에 등록 /** * 게시글 목록 조회 화면 * @return * @throws Exception */ @GetMapping("/list") public String list(Model model) throws Exception { // 데이터 요청 List<Board> boardList = boardService.list(); // 모델 등록 model.addAttribute("boardList", boardList); // 뷰 페이지 지정 return "/board/list"; // resources/templates/board/list.html } /** * 게시글 조회 화면 * - /board/read?no=💎 * @param no * @return * @throws Exception */ // @RequestParam("파라미터명") // - 스프링 부트 3.2버전 이하, 생략해도 자동 매핑된다. // - 스프링 부트 3.2버전 이상, 필수로 명시해야 매핑된다. @GetMapping("/read") public String read(@RequestParam("no") int no, Model model) throws Exception { // 데이터 요청 Board board = boardService.select(no); // 모델 등록 model.addAttribute("board", board); // 뷰페이지 지정 return "/board/read"; } /** * 게시글 등록 화면 * @return */ @GetMapping("/insert") public String insert() { return "/board/insert"; } /** * 게시글 등록 처리 * @param board * @return * @throws Exception */ @PostMapping("/insert") public String insertPro(Board board) throws Exception { // 데이터 요청 int result = boardService.insert(board); // 리다이렉트 // ⭕ 데이터 처리 성공 if( result > 0 ) { return "redirect:/board/list"; } // ❌ 데이터 처리 실패 return "redirect:/board/insert?error"; } /** * 게시글 수정 화면 * @param no * @param model * @return * @throws Exception */ @GetMapping("/update") public String update(@RequestParam("no") int no, Model model) throws Exception { Board board = boardService.select(no); model.addAttribute("board", board); return "/board/update"; } /** * 게시글 수정 처리 * @param board * @return * @throws Exception */ @PostMapping("/update") public String updatePro(Board board) throws Exception { int result = boardService.update(board); if( result > 0 ) { return "redirect:/board/list"; } int no = board.getNo(); return "redirect:/board/update?no="+ no + "&error"; } /** * 게시글 삭제 처리 * @param no * @return * @throws Exception */ @PostMapping("/delete") public String delete(@RequestParam("no") int no) throws Exception { int result = boardService.delete(no); if( result > 0 ) { return "redirect:/board/list"; } return "redirect:/board/update?no=" + no + "&error"; } }

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>메인 화면</title> </head> <body> <h1>SpringBoot x MyBatis</h1> <h3>게시판 프로젝트</h3> <ul> <li>Spring Boot 3.x</li> <li>Thymeleaf</li> <li>MySQL 8.x</li> <li>MyBatis 3.0</li> </ul> <div> <a href="/board/list">게시판</a> </div> </body> </html>