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=")">