<select id="SelectAllByNotsampleNo" resultMap="BaseResultMap" parameterType="java.lang.String">

     SELECT * FROM wshop_report1 a

     left join wshop_report_sms b on a.sampleno=b.sampleno

     where a.sampleno not in

     <foreach item="item" index="index" collection="list"

                         open="(" separator="," close=")">

                        #{item}

                </foreach>

  </select>

@Override

    public List<WshopReport1> SelectAllByNotsampleNo(List<String> sampleno) {

        return reportdao.SelectAllByNotsampleNo(sampleno);

    }