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

Question

public interface OrderMapper extends SqlMapper{@Select("select * from tbl_order where room like #{room} and mydate like #{mydate}")public List<Order> getbyroom(OrderPara op);}这样整个语句是写死的，必须有2个参数，在这种模式下，如何能实现根据room和mydate是否为空来动态的拼写sql语句比如当mydate=""Select("select * from tbl_order where room like #{room} ")public List<Order> getbyroom(OrderPara op);如果用xml来配置语句的话，可以用<when test="title != null">and mydate= #{mydate}</when>