com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘use,contraindication,research,pinyin,image’.
反复检查了几次,不是配置文件的错误,也不是属性和数据库字段不匹配或者插入顺序不一致的错误,网上看了很多例子,看到很多人说是属性与mysql数据库关键字重合,然后试了试..............................还真的是真的错误,具体是哪个字段也没有去纠结了,全部在后面加了0
<property name="use" type="java.lang.String">
<column name="USE0" />
</property>
<property name="contraindication" type="java.lang.String">
<column name="CONTRAINDICATION0" />
</property>
<property name="research" type="java.lang.String">
<column name="RESEARCH0" />
</property>
<property name="pinyin" type="java.lang.String">
<column name="PINYIN0" />
</property>
<property name="image" type="java.lang.String">
<column name="IMAGE0" />
结果正确!