<script> <iftest="list != null and !list.isEmpty()"> UPDATE user_info SET name=case id <foreachcollection="list"item="et"> <choose> <whentest="et != null and et.name != null"> when #{et.id} then #{et.name,typeHandler=org.dromara.streamquery.stream.plugin.mybatisplus.JsonFieldHandlerTest$JsonFieldHandler} </when> <otherwise>when #{et.id} then name</otherwise> </choose> </foreach>end WHERE id IN (<foreachcollection="list"item="et"separator=","> #{et.id} </foreach>) </if> </script>
/* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package org.dromara.streamquery.stream.plugin.mybatisplus;