@Mapper
public interface TerminalMapper {
Integer validateRecord(List<TerminalVO> list);
}
<select id="validateRecord" resultType="integer" parameterType="com.vo.TerminalVO">
SELECT COUNT(*) FROM terminal
WHERE (product_code,sales_area_code) IN
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
(#{item.productCode},#{item.salesAreaCode})
</foreach>
</select>