<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="com.wap.mapper.CreditResultsMapper"> <select id="getList" resultType="com.wap.entity.CreditResults"> select * from vcyber_creditresults <where> gfApplyFromCode in <foreach collection="list" index="index" item="item" open="(" separator="," close=")"> #{item} </foreach> </where> </select> </mapper>