转载:http://blog.csdn.net/yicong406880638/article/details/51443626
首先感谢上作者提供的解答,
今天用mybatis时需要获取insert后的主键,方法如下:
public Integer genBizOrder(Map m);
- <insert id="genBizOrder" parameterType="java.util.Map">
- <selectKey resultType="java.lang.Integer" order="BEFORE" keyProperty="id">
- select seq_tab.nextval as id from dual
- </selectKey>
- insert into t_test t values(#{id}, #{custId}, #{seatSubmitTime}, '')
- </insert>