根据list条件批量查询
<select id="getdeletepeojectidlist" resultType="String" parameterType="String">
SELECT id from projectinfo where
oldprojectid = #{oldprojectid} and year not in
<foreach collection="oldyearlist" item="item" index="index" open="(" separator="," close=")">
#{item}
</foreach>
</select>