MyBatis批量删除

    /**
     * 根据主键删除数据库的记录,cms_menu
     *
     * @param idList
     */
    int deleteByPrimaryKey(List<Long> idList);


    <!--根据主键删除-->  <!--这里必须要是 item="id" -->
    <delete id="deleteByPrimaryKey" parameterType="java.util.List">
      delete from cms_menu
        where id in
        <foreach item="id" collection="list" open="(" separator="," close=")"> 
            #{id,jdbcType=BIGINT}
        </foreach>
    </delete>