Mybatis传入参数字符串分割成数组作为条件遍历不用in不用in

<if test="typeIds != null and typeIds != ''">
        and
            <foreach collection="typeIds.split(',')" item="id" open="type_ids like concat(" separator=" and type_ids like concat(">
                '%', #{id}, '%')
            </foreach>
        </if>

<insert id="insertBatch">
    INSERT INTO tb_student (name, age, phone, address, class_id) VALUES
    <foreach collection="list" separator="," item="item">
        (#{item.name},#{item.age},#{item.phone},#{item.address},#{item.classId})
    </foreach>
  </insert>

    <update id="deleteNoticeById">
        update t_w_send_notice
        set
        is_deleted = 1
        where id in
        <foreach collection="idlist" item="item" index="index" 
        open="(" separator="," close=")">
            #{item}
        </foreach>
    </update>

    <select id="selectByIdList" resultType="com.ruoyi.project.wxb.entity.po.Notice">
        select t.id,t.user_id,t.start_time,t.content from t_w_send_notice t
        where is_deleted=0 and id in
        <foreach collection="list" item="item" index="index" 
        open="(" separator="," close=")">
            #{item}
        </foreach>
    </select>

 <select id="totalCount"  resultType="java.lang.Integer">
        select * from xxxx
        <where>
            <if test="bedNo!=null and bedNo!='' ">
                and  bed_no like  '%${bedNo}%'
            </if>
            <if test="bedRoomId!=null and bedRoomId!=''">
                and  bed_roomId like  '%${bedRoomId}%'
            </if>
        </where>
    </select>