问题记录:
mybatis插入出现org.apache.ibatis.executor.ExecutorException: No setter found for the keyProperty 'xxx’异常的原因
解决方案:
确定有setter方法,问题其实是xml文件中,insert的自动填充返回主键的id写错了,keyProperty返回的主键ID一定要是数据库主键ID
<insert id="addOrderFoursshop">
<selectKey resultType="int" order="AFTER" keyProperty="orderID">
SELECT LAST_INSERT_ID()
</selectKey>
INSERT INTO order_foursshop
(orderoperator,orderquantity,foursID,ordername,classes ) VALUES (#{orderoperator},#{orderquantity},#{foursID},#{ordername},#{classes});
</insert>