how to write in select in mybatis

gistfile1.txt

    @Select({"<script>",
            SELECT_PRODUCTS,
            "WHERE desp_product.oid IN",
            "<foreach item='oidItem' index='index' collection='oids'",
            "open='(' separator=',' close=')'>",
            "#{oidItem}",
            "</foreach>",
            "</script>"})
    @ResultMap("noParrent")
    public  List<DespProduct>  getAllProductsIn(@Param("oids") List<Integer> oids) ;