mybatis xml

delete from t_enterprise_output_value where output_id IN #{outputId}

批量插入
功能：单个或批量插入数据，若数据已存在，则忽略

<insert id="saveBatchIgnoreInto" parameterType="java.util.List">insert ignore into user(`user_Id`, `user_name`, `email`)values<foreach collection="userList" item="item" index="index"separator=",">(#{item.userId,jdbcType=VARCHAR},#{item.userName,jdbcType=VARCHAR},#{item.eEmail,jdbcType=VARCHAR})</foreach></insert>

查询用户表id的列表

<select id="queryIds" resultType="java.lang.String">SELECT idFROM user</select>