<insert id="save" parameterType="com.bootdo.purchase.domain.PurchaseDO" useGeneratedKeys="true" keyProperty="id">
insert into <include refid="t_mzcc_purchase" />
(
`order_name`,
`order_number`,
`material_id`,
`material_name`,
`supplier_id`,
`supplier_name`,
`amount`,
`unit`,
`price`,
`price_total`,
`purchase_time`,
`status`,
`create_by`,
`create_at`,
`modify_by`,
`modify_at`,
`is_del`,
`remarks`
)
values
(
#{orderName},
#{orderNumber},
#{materialId},
#{materialName},
#{supplierId},
#{supplierName},
#{amount},
#{unit},
#{price},
#{priceTotal},
#{purchaseTime},
#{status},
#{createBy},
#{createAt},
#{modifyBy},
#{modifyAt},
#{isDel},
#{remarks}
)
</insert>
主要是useGeneratedKeys="true" keyProperty="id"
useGeneratedKeys表示自增长
keyProperty表示主键
dao层编写public int update(PurchaseDO purchase);
但是这样返回的int只是插入条数,主键ID的值会在参数对象purchase中,直接getId就可以获得。