mybatis使用注解进行复杂查询

("<script>" +
            "select * from coagencies where" +
            "<if test='coagency.id!=null'>" +
            "id = #{coagency.id} and" +
            "</if>" +
            "<if test='reviewStatus!=null'>" +
            "review_state in <foreach collection='reviewStatus' item='item' open='(' separator=',' close=')'>#{item}</foreach>" +
            "</if>" +
            "<if test='partnershipStatus!=null'>" +
            " and partnership_state in <foreach collection='partnershipStatus' item='item' open='(' separator=',' close=')'>#{item}</foreach>" +
            "</if>" +
            "</script>")
    List<Coagency> (@Param("reviewStatus") List<String> reviewStatus,@Param("partnershipStatus") List<String> partnershipStatus, @Param("coagency") Coagency coagency);