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> 

  

posted @ 2019-05-04 16:23  清-华-园  阅读(99)  评论(0编辑  收藏  举报