博客

<!-- 根据reportType和proCode查询报表信息-->
 <select id="getReportList" resultMap="fileReportMap" parameterType="java.util.List">
     select * from t_ams_report where fpro_code=#{proCode}   and  freport_type in
     <foreach collection="list" item="item" index="index" open="(" separator="," close=")">
         #{item}
     </foreach>

 </select>

mapper:

List<String> reportTypeList=new ArrayList<String>();
reportTypeList=productMapper.getReportTypeByCode(lifeCode);