Springboot中配置动态sql查询出现的错误syntax error, expect ‘)‘

在springboot中利用mybatis实现动态查询出现了错误

syntax error, expect ')'

源码

    <insert id="insertEmploy" parameterType="com.example.springboot06mybatis.bean.Employee">
        insert into employee
        <trim prefix="(" suffixOverrides="," suffix=")">
            <if test="emp_lastName != null">
                lastName,
            </if>
            <if test="email != null">
                email,
            </if>
            <if test="gender != null">
                gender,
            </if>
            <if test="dId != null">
                d_id,
            </if>
        </trim>
        <trim prefix="values=(" suffixOverrides="," suffix=")">
            <if test="emp_lastName != null">
                #{emp_lastName},
            </if>
            <if test="email != null">
                #{email},
            </if>
            <if test="gender != null">
                #{gender},
            </if>
            <if test="dId != null">
                #{dId},
            </if>
        </trim>
    </insert>

之所以会出现错误，是因为下面这行语句写出了"values=("

 <trim prefix="values=(" suffixOverrides="," suffix=")">

只需要将上面修改为如下便可

<trim prefix="values(" suffixOverrides="," suffix=")">