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>