You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘release
(expo_id,exhibitor_id,user_id,
contact_phone,contact_pe’ at line 1
insert into release
(expo_id,exhibitor_id,user_id,
contact_phone,contact_person,
company,content,`type`,create_time)
values (#{expoId,jdbcType=INTEGER},#{exhibitorId,jdbcType=INTEGER}
,#{userId,jdbcType=INTEGER},#{contactPhone,jdbcType=VARCHAR},#{contactPerson,jdbcType=VARCHAR}
,#{company,jdbcType=VARCHAR},#{content,jdbcType=VARCHAR},#{type,jdbcType=VARCHAR}
,#{createTime,jdbcType=TIMESTAMP})
改为
insert into `release`
(expo_id,exhibitor_id,user_id,
contact_phone,contact_person,
company,content,`type`,create_time)
values (#{expoId,jdbcType=INTEGER},#{exhibitorId,jdbcType=INTEGER}
,#{userId,jdbcType=INTEGER},#{contactPhone,jdbcType=VARCHAR},#{contactPerson,jdbcType=VARCHAR}
,#{company,jdbcType=VARCHAR},#{content,jdbcType=VARCHAR},#{type,jdbcType=VARCHAR}
,#{createTime,jdbcType=TIMESTAMP})
修改的地方
把release改为`release`
总结
数据库出现You have an error in your SQL syntax+server version for the right 这几个关键字可能就是mysql关键字报错,给相关字段加上`符号即可