<!-- 根据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);