mybatis直接取到Insert语句插入的自增长主键

将useGeneratedKeys和keyProperty两个属性添加到insert标签中，即可得到该插入记录的自增长主键

<insert id="addOrder" useGeneratedKeys="true" keyProperty="oid" parameterType="com.ouyin.domain.NormalOrder">
	INSERT INTO tb_order
	(uid,sid,receive_aid,message,total_price)
	VALUES
	(#{uid},#{sid},#{receive_aid},#{message},#{total_price})
</insert>

 在service层可调用getId方法即可获取

public int test() {
	sd.addOrder(order);
	return order.getOid();
}