mysql:
<insert id="save" parameterType="chuKu">
<![CDATA[
INSERT INTO CHUKU(customerName,salesMan,publishNo,address,phone,createDate,auditorMan,financeOfficer,warehouse,consignee)
VALUES
(#{customerName},#{salesMan},#{publishNo},#{address},#{phone},sysdate(),#{auditorMan},#{financeOfficer},#{warehouse},#{consignee})
]]>
<selectKey resultType="int" keyProperty="id">
select @@IDENTITY as id
</selectKey>
</insert>
oracle:
<!-- 新增 -->
<insert id="save" parameterType="czNewsType">
<selectKey resultType="int" keyProperty="id">
select cxzy_squence_index.nextval from dual
</selectKey>
<![CDATA[
INSERT INTO CZNEWSTYPE(id,kfNewsTypeName,visibility,orderNumber)
VALUES
(cxzy_squence_index.nextval,#{kfNewsTypeName,jdbcType=VARCHAR},#{visibility,jdbcType=VARCHAR},#{orderNumber,jdbcType=DOUBLE})
]]>
</insert>
这样写了,当你调用保存方法后返回的object中的id已经有值了。