//id为空的时候,mybatis会自动查询一个id赋值给sysrole
<insert id="insertRole" parameterType="sysRole" >
<selectKey resultType="string" order="BEFORE" keyProperty="id">
SELECT replace(uuid(),'-','')
</selectKey>
INSERT INTO sys_role (id,name,role,remarks,create_by,create_date,update_by,update_date,del_flag)
VALUES (#{id},#{name},#{role},#{remarks},#{createBy},#{createDate},#{updateBy},#{updateDate},#{delFlag})
</insert>
转载于:https://my.oschina.net/u/2256193/blog/646369