Java开发: Mybatis insert 插入记录后自动返回主键(Mybatis3.x)

来源:互联网 发布:阿里云待遇 编辑:程序博客网 时间:2024/05/02 01:30
<insert id="insertReceipt" parameterType="Receipt" useGeneratedKeys="true" keyProperty="id">insert into tb_receipt (name,from_storage_code,to_storage_code,description,type_id,code,batch_number) values ( #{name},#{fromStorageCode},#{toStorageCode},<choose><when test="description!=null">#{description}</when><otherwise>''</otherwise></choose>,<choose><when test="typeId!=null">#{typeId}</when><otherwise>0</otherwise></choose>,<choose><when test="code!=null">#{code}</when><otherwise>''</otherwise></choose>,#{batchNumber} )<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id" >      SELECT LAST_INSERT_ID()    </selectKey></insert>
在创建成功后会自动返回单据号,可以通过:receiptMapper.insertReceipt(receipt);   System.out.println("单据创建成功,单据号为:"+receipt.getId());//获取即可(Mybatis3.x适用,2.0的网上有很多讲解就不再赘述)

原创粉丝点击