mybatis @Select注解中当参数为空则不添加该参数的判断

public interface OrderMapper extends SqlMapper{

@Select("select * from tbl_order where room like #{room} and mydate like #{mydate}")
public List<Order> getbyroom(OrderPara op);

}

Select("select * from tbl_order where room like #{room} ")
public List<Order> getbyroom(OrderPara op);

<when test="title != null">
and mydate= #{mydate}
</when>

@Select({"<script>",
    "SELECT * FROM tbl_order",
    "WHERE 1=1",
    "<when test='title!=null'>",
    "AND mydate = #{mydate}",
    "</when>",
    "</script>"})