SELECT mac FROM t_sys_device WHERE valid_time='9999-12-31' and type=0 and collect_code in #{item} and find_in_set(#{collectCode},tl.label_code) or

批量插入

insert into t_person_code(name,id_type, id_no, house_region,house_address,key_person)
values

(
#{item.name},#{item.idType}, #{item.idNo}, #{item.houseRegion},#{item.houseAddress},#{item.keyPerson}
)