Mybatis中insert中返回主键ID的方法

Mybatis中insert中返回主键ID的方法

useGeneratedKeys=”true” keyProperty=”id”

/**
 * 这里插入后需返回id
 */
int insert(EmployeeBusiness record);
	
	
<insert id="insert" parameterType="org.sang.bean.EmployeeBusiness" useGeneratedKeys="true" keyProperty="id">
insert into employeebusiness (id, empId, createDate, 
  updateDate, imgs, note
  )
values (#{id,jdbcType=INTEGER}, #{empId,jdbcType=INTEGER}, #{createDate,jdbcType=TIMESTAMP}, 
  #{updateDate,jdbcType=TIMESTAMP}, #{imgs,jdbcType=VARCHAR}, #{note,jdbcType=LONGVARCHAR}
  )
</insert>