인프런 커뮤니티 질문&답변

@PostMapping("/order_search")
public String doSearch( @RequestParam("start_date") String strStartDate,
                        @RequestParam("end_date") String strEndDate,
                        @RequestParam(value = "coffee", defaultValue = "ALL") String strCoffee,
                        @RequestParam("name") String strName,
                        Model model

){

    log.info("strStartDate :"+strStartDate);

    List<Order_list> list = orderSvcV2.doSearch(strStartDate,strEndDate, strCoffee,strName );

    model.addAttribute("list", list);

    return "/v2/order/order";
}

/* 조회하기 */
public List<Order_list> doSearch(String strStartDate, String strEndDate, String strCoffee, String strName) {
    List<Order_list> list = orderDao.doSearch(strStartDate,strEndDate, strCoffee,strName );
    return list;
}

package hello.sailing.v2.dao;

import hello.sailing.v2.vo.Order_list;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;

@Mapper
public interface OrderDaoV2 {
    List<Order_list> doList();

    List<Order_list> doSearch(String strStartDate, String strEndDate, String strCoffee, String strName);
}

package hello.sailing.v2.vo;

import lombok.Data;

@Data
public class Order_list {
    private String no;
    private String coffee_no;
    private String coffee;
    private String price;
    private String cust_id;
    private String name;
    private String reg_day;

}

<!-- 검색에 의한 쿼리 -->
<select id="doSearch" resultType="hello.sailing.v2.vo.Order_list">
    SELECT no, coffee_no, coffee, price, cust_id, name,
    DATE_FORMAT(reg_day,'%Y.%m.%d') AS reg_day
    FROM order_list
    WHERE 1=1
    AND reg_day >= DATE_FORMAT( #{strStartDate},'%Y%m%d')
    AND reg_day &lt; DATE_ADD(DATE_FORMAT(#{strEndDate},'%Y%m%d'), INTERVAL +1 DAY)
    <if test="strCoffee != 'ALL'">
        AND coffee like CONCAT(#{strCoffee},'%')
    </if>
    <if test="strName != 'ALL'">
        AND name like CONCAT(#{strName},'%')
    </if>
</select>

화면에서는 조회버튼을 누르면 검색이 안됩니다...코드는 틀린게 없는데 왜 그런거죠?