一、指定插入值得jdbcType,将sql改成 insert into user(id,name) values(#{id,jdbcType=VARCHAR},#{name,jdbcType=VARCHAR})
二、在mybatis-config.xml配置文件中添加:
<configuration>
......
<settings>
<setting name="jdbcTypeForNull" value="NULL" />
</settings>
......
</configuration>