[Zero-base] 7-3. MyBatis 설정 및 쿼리 구현

MyBatis 환경 설정

 

• New Project 생성

 

 

 

• Language: Java
• Type: Maven
• Project SDK: 1.8
• Java: 8
• Packaging: War

 

 

 

Dependency 추가

• MyBatis Framework

 

 

 

pom.xml (demo5)

• 데모프로젝트의 pom.xml 파일에서 mybatis dependency 복사

 

 

 

pom.xml (fastlms)

• fastlms프로젝트의 pom.xml 파일에 mybatis dependency 붙여넣기

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.2.2</version>
</dependency>

 

 

 

• Maven Load

 

 

 

application.yml

mybatis:
  mapper-locations: mybatis/**/*.xml
  configuration:
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

 

 

---

MyBatix 쿼리 실행

 

MemberMapper.java

인터페이스 추가

• MemberMapper.java

 

 

 

MemberMapper.java

• Mapper annotation (@Mapper) 추가

 

 

 

• XML Mapper Header 복사

 

 

MemberMapper.xml

<?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">
<mapper namespace="com.zerobase.fastlms.admin.mapper.MemberMapper">

    <select id="selectList" resultType="com.zerobase.fastlms.admin.dto.MemberDto">

        select *
        from member

    </select>

</mapper>

 

 

 

MemberDto.java

package com.zerobase.fastlms.admin.dto;
import lombok.Data;

import java.time.LocalDateTime;

@Data
public class MemberDto {

    String userId;
    String userName;
    String phone;
    String password;
    LocalDateTime regDt;

    boolean emailAuthYn;
    String emailAuthKey;
    LocalDateTime emailAuthDt;

    String resetPasswordKey;
    LocalDateTime resetPasswordLimitDt;

    boolean adminYn;
}

 

 

 

MemberServiceImpl.java

private final MemberMapper memberMapper;

 

MemberServiceImpl.java

    @Override
    public List<MemberDto> list() {

        MemberDto parameter = new MemberDto();

        return memberMapper.selectList(parameter);
    }

 

 

 

MemberService.java

List<MemberDto> list();

 

 

 

AdminMemberController.java

@RequiredArgsConstructor
@Controller
public class AdminMemberController {

    private final MemberService memberService;

    @GetMapping("/admin/member/list.do")
    public String list(Model model) {

        List<MemberDto> members = memberService.list();
        model.addAttribute("list", members);

        return "admin/member/list";
    }
}

 

 

 

localhost:8080/admin/member/list.do

• Whitelabel Error Page

 

 

MemberDto.java

• Getter, Setter 설정

 

 

 

localhost:8080/admin/member/list.do

• MyBatis 쿼리를 통한 리스트 구현

 

 

 

• 쿼리에 따라 불러온 내용

 

---