<insert id="insertSelectiveIsNotExist">
    <selectKey resultType="java.lang.Long" keyProperty="id" order="AFTER" >
        SELECT LAST_INSERT_ID()
    </selectKey>
    INSERT INTO account
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="id != null">
            id,
        </if>
        <if test="createTime != null">
            create_time,
        </if>
        <if test="status != null">
            status,
        </if>
        <if test="remark != null">
            remark,
        </if>
    </trim>
    <trim prefix="SELECT " suffix="" suffixOverrides=",">
        <if test="id != null">
            #{id,jdbcType=BIGINT},
        </if>
        <if test="createTime != null">
            #{createTime,jdbcType=TIMESTAMP},
        </if>
        <if test="updTime != null">
            #{updTime,jdbcType=TIMESTAMP},
        </if>
        <if test="status != null">
            #{status,jdbcType=CHAR},
        </if>
        <if test="remark != null">
            #{remark,jdbcType=VARCHAR},
        </if>
    </trim>
    FROM DUAL
        WHERE NOT EXISTS(
            SELECT count(*) FROM user WHERE id = #{userId,jdbcType=VARCHAR}
        ) LIMIT 1
</insert>

<insert id="batchSave" keyColumn="id" keyProperty="id" parameterType="com.aidijing.User" useGeneratedKeys="true">
    INSERT INTO `user`
        (`username`,`password`)
    VALUES
    <foreach collection="list" item="item" index="index" separator=",">
        (#{item.username},#{item.password})
    </foreach>
</insert>