<insert id="insert" parameterType="com.atguigu.crud.bean.Employee" >
<selectKey keyProperty="serverId" order="BEFORE">
SELECT variable_value FROM performance_schema.global_variables WHERE variable_name = 'server_id'
</selectKey>
insert into tbl_emp (emp_id, emp_name, gender,
email, d_id, create_time,server_id
)
values (#{empId,jdbcType=INTEGER}, #{empName,jdbcType=VARCHAR}, #{gender,jdbcType=VARCHAR},
#{email,jdbcType=VARCHAR}, #{dId,jdbcType=INTEGER}, #{createTime,jdbcType=TIMESTAMP} ,#{serverId,jdbcType=INTEGER}
)
</insert>
mybatis中selectKey的使用
最新推荐文章于 2024-04-15 15:42:22 发布