[Spring] Query ( choose, when, if, where, foreach )

<?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="ArticleDAO">
 
    <select id="getNowSystemDate" resultType="string">
        SELECT    SYSDATE
        FROM    DUAL
    </select>
    
    <select id="getAllEmployeeInfo" parameterType="map" resultType="EmployeesVO">
        SELECT    /* [ArticleDAO.getAllEmployeeInfo] */
                EMPLOYEE_ID employeeId
                , FIRST_NAME firstName
                <choose>
                    <when test="employee.firstName!=null and employee.firstName!=''">
                        , LAST_NAME lastName
                        , EMAIL email
                        , SALARY salary
                        , COMMISSION_PCT commissionPct
                        , HIRE_DATE hireDate
                        , D.DEPARTMENT_NAME departmentName
                    </when>
                    <when test="employee.lastName != null and employee.lastName !=''">
                        , LAST_NAME lastName
                        , EMAIL email
                    </when>
                    <otherwise>
                        , LAST_NAME lastName
                        , EMAIL email
                        , SALARY salary
                        , COMMISSION_PCT commissionPct
                        , HIRE_DATE hireDate
                    </otherwise>
                </choose>
        FROM    EMPLOYEES
        <if test="employee.firstName != null and employee.firstName != ''">
                E , DEPARTMENTS D
        </if>
        <where>
            <if test="employee.lastName != null and employee.lastName !=''">
            LAST_NAME=#{lastName}        
            </if>
            <if test="employee.firstName != null and employee.firstName != ''">
            AND        E.DEPARTMENT_ID = D.DEPARTMENT_ID
            AND        FIRST_NAME=#{firstName}
            </if>
            <if test="managerIds != null">
            AND        MANAGER_ID IN
                <foreach collection="managerIds" item="managerId"
                            separator=", " open="(" close=")">
                    #{managerId}
                </foreach>
            </if>
        </where>
    </select>
    
 
</mapper>
 

@Override
    public List<EmployeesVO> getAllEmployeeInfo() {
        // String lastName = "King";
        
        Map<String, Object> parameters = new HashMap<String, Object>();
//        parameters.put("firstName", "Steven");
//        parameters.put("lastName", "King");
        // parameters.put("other", new EmployeesVO()); 이런것도 가능하다.
        
        EmployeesVO employee = new EmployeesVO();
        //employee.setFirstName("Steven");
        //employee.setLastName("King");
        
        List<Integer> managerId = new ArrayList<Integer>();
        managerId.add(100);
        managerId.add(101);
        managerId.add(102);
        managerId.add(103);
        
        parameters.put("employee", employee);
        parameters.put("managerIds", managerId);
        
        return getSqlSession().selectList("ArticleDAO.getAllEmployeeInfo", parameters);
    }