@Insert({"insert into sys_role(id,role_name,enabled,create_by,create_time)"+"values(#{id},#{roleName},#{enabled},#{createBy},#{createTime})"})voidinsert1(SysRole sysRole);
返回自增主键
@Insert({"insert into sys_role(role_name,enabled,create_by,create_time)"+"values(#{roleName},#{enabled},#{createBy},#{createTime})"})@Options(useGeneratedKeys=true,keyProperty="id")voidinsert2(SysRole sysRole);
返回非自增主键
@Insert({"insert into sys_role(role_name,enabled,create_by,create_time)"+"values(#{roleName},#{enabled},#{createBy},#{createTime})"})@SelectKey(statement ="select last_insert_id()",
keyProperty ="id",
resultType = Long.class,
before =false)voidinsert3(SysRole sysRole);