mybatis获取主键
keyProperty="id"指定对应的主键
useGeneratedKeys="true"表明获取主键值
<insert id="saveItem" keyProperty="id" useGeneratedKeys="true">
insert into tb_item
(id, title, sell_point, price, num, barcode, image, cid, status, created, updated)
values (null, #{title}, #{sellPoint}, #{price}, #{num}, #{barcode}, #{image}, #{cid}, #{status}, #{created},
#{updated})
</insert>
<insert id="saveItemDesc">
insert into tb_item_desc (item_id, item_desc, created, updated)
values (#{itemId}, #{itemDesc}, #{created}, #{updated})
</insert>