1 <insert id="insertUser" parameterType="cn.lisongyu.entity.User"> 2 <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer"> 3 SELECT LAST_INSERT_ID() 4 </selectKey> 5 insert into user (name,sex) values (#{name},#{sex}) 6 </insert>
1 <insert id="insertUser" parameterType="cn.lisongyu.entity.User"> 2 <selectKey keyProperty="id" order="BEFORE" resultType="String"> 3 select uuid() 4 </selectKey> 5 insert into user (id,name,sex) values (#{id},#{name},#{sex}) 6 </insert>
java -cp druid-1.0.27.jar com.alibaba.druid.filter.config.ConfigTools **your password**
原文:https://www.cnblogs.com/lisongyu/p/9865335.html