mybatis 实现传入List集合进行数据查询

sql 语句拼写

    <select id="findByCardBeaconNo" resultType="com.jxkj.arithmetic.entity.CardRecord">
		select cr.id, cr.worker_id,cr.entity_type,cr.car_id,car_.car_no as carNo,wor_.name as workerName,c.beacon_no as beaconNo
		from card_record cr left join card c on cr.card_id = c.id
		left join car_info car_ on car_.id = cr.car_id
		left join worker_info wor_ on wor_.id = cr.worker_id
		where c.beacon_no in
		<foreach item="item" index="index" collection="list" open="("  close=")" separator=",">
			#{item}	
		</foreach>
	</select>

dao层传入list集合

    List<CardRecord> findByCardBeaconNo(List<String> item);

最终判断需要查询的数据是否在list集合中，否则不返回！