原数据库语句如下:
<insert id="addOrder">
insert into order (oid, sid, mid, cid, `number`, price)
values (#{oid}, #{sid}, #{mid}, #{cid}, #{number}, #{price})
</insert>
要注意,order在SQL中是关键字,所以需将代码修改如下:
<insert id="addOrder">
insert into `order` (oid, sid, mid, cid, `number`, price)
values (#{oid}, #{sid}, #{mid}, #{cid}, #{number}, #{price})
</insert>