Caused by: org.xml.sax.SAXParseException; lineNumber: 19; columnNumber: 65; 必須為元素類型 "insert" 聲明屬性 "useGeneratedkeys"。
Caused by: org.xml.sax.SAXParseException; lineNumber: 19; columnNumber: 65; 必須為元素類型 "insert" 聲明屬性 "useGeneratedkeys"。
<mapper>文件
<insert?id="insertCommodity"?useGeneratedkeys="true"?keyProperty="commodityId"?keyColum="commodity_id"
????????parameteerType="com.seer.demoshop.entity.Commodity">
????INSERT?INTO
????commodity(commodity_id,commodity_name,commodity_sales,create_time,last_edit_time)
????VALUE
????(#{commodityId},#{commodityName},#{commoditySales},#{createTime},#{lastEditTime})
</insert>
<update?id="updateCommodityId"?resultType="com.seer.demoshop.entity.Commodity">
????UPDATE?commodity
????<set>
????????<if?test="commodityName!=null">commodity_name=#{commodityName},</if>
????????<if?test="commoditySales!=null">commodity_sales=#{commoditySales},</if>
????????<if?test="lastEditTime!=null">last_edit_time=#{lastEditTime}</if>
????</set>
????WHERE?commodity_id=#{commodityId}
</update>
<delete?id="deleteCommodity">
????DELETE?FROM
????commodity
????WHERE?commodity_id=#{commodityId}
</delete>
2019-10-16
同學好,請仔細區分大小寫,是useGeneratedKeys 而非?