ResultMap 을 이용한 mybatis

ResultMap은 DB 필드값과 DTO객체의 프라퍼티(변수)명이 다를 때 사용한다.

ResultMap id에 사용할 임의의 이름을 기술하고 type(type="Department")에는 DTO명을 적어준다.

<result column="department_id" property="deptId" />

column 에는 DB의 필드명을 적고 property에는 DTO 프라퍼티명을 적어준다.

department_config.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.spring.hr.model.DepartmentsMapper">

<resultMap id="departmentsResult" type="Department">

<result column="department_id" property="deptId" />

<result column="department_name" property="deptName" />

<result column="manager_id" property="deptMgr" />

<result column=location_id property="locationId" />

</resultMap>

  <select id="getDepartmentsInfo" resultMap="departmentsResult">

  select * from departments order by department_id

  </select>

</mapper>

package com.spring.hr.model;

public class Department {

private int deptId;

private String deptName;

private String deptMgr;

private String locaionId;

public int getDeptId() {

return deptId;

}

public void setDeptId(int deptId) {

this.deptId = deptId;

}

public String getDeptName() {

return deptName;

}

public void setDeptName(String deptName) {

this.deptName = deptName;

}

public String getDeptMgr() {

return deptMgr;

}

public void setDeptMgr(String deptMgr) {

this.deptMgr = deptMgr;

}

public String getLocaionId() {

return locaionId;

}

public void setLocaionId(String locaionId) {

this.locaionId = locaionId;

}

}