mysql数据库使用mybatis 插入数据时返回主键
为了体现题目,特指的是mysql,先贴上代码:
<insert id="saveBizProdOrderDetail" useGeneratedKeys="true" keyProperty="id" parameterType="com.xxx.insurance.entity.BizProdOrderDetail" > insert into biz_prod_order_detail (ORDERCODE, PRODCODE, COUNT, OPTDATE, OPTUSER ) values ( #{ordercode}, #{prodcode}, #{count}, now(), #{optuser} ) </insert>
下面这篇文章包含常用的MySQL和Oracle数据库的详细说明
https://www.cnblogs.com/0201zcr/p/4990610.html
其他参考:
https://www.cnblogs.com/zkjblogs/p/6830900.html
https://blog.csdn.net/jackie__gao/article/details/70598384
http://chenzhou123520.iteye.com/blog/1849881