开启自动递增后,就不用加 <if test="id!= null">id,</if> 了
<insert id="insertUser" parameterType="User" useGeneratedKeys="true" keyProperty="id"> insert into ic_iccard_change <trim prefix="(" suffix=")" suffixOverrides=","> <if test="id!= null">id,</if> <if test="gmtCreate != null">gmt_create,</if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="id!= null">#{id},</if> <if test="gmtCreate != null">#{gmtCreate},</if> </trim> </insert>