MyBatis

<insert id="insertsbxx" parameterType="string" >----------<update>
      	INSERT INTO PEAU08 
		<trim prefix="(" suffix=")" suffixOverrides="," >
			<if test="PEAU0811 != null and PEAU0811 != ''" >
			  PEAU0811,
			</if>
			<if test="createtime != null and createtime != ''" >
			  createtime,
			</if>
		</trim>
		<trim prefix=" values (" suffix=")" suffixOverrides="," >
			<if test="PEAU0811 != null and PEAU0811 != ''" >
			  #{PEAU0811},
			</if>
			<if test="createtime != null and createtime != ''" >
			  sysdate,
			</if>
		</trim>
    </insert> 

  

原文地址:https://www.cnblogs.com/hongwei2085/p/10808824.html