MyBatis 执行Insert操作，返回实体对象的主键

ゝ一世哀愁。 2023-10-17 23:21 12阅读 0赞

1、dao 层定义和Mapper 实现

dao层定义：

int insertSelective(RoleInfo record);

Mapper实现：

<insert id="insertSelective" keyProperty="sid" parameterType="com.digipower.erms.domain.RoleInfo">  
<selectKey keyProperty="sid" order="BEFORE" resultType="java.lang.Long">  
SELECT erms\_s\_auth\_role.nextval FROM DUAL  
</selectKey>  
insert into ERMS\_AUTH\_ROLE  
<trim prefix="(" suffix=")" suffixOverrides=",">  
SID,  
<if test="roleName != null">  
ROLE\_NAME,  
</if>  
<if test="roleCode != null">  
ROLE\_CODE,  
</if>  
<if test="roleDescription != null">  
ROLE\_DESCRIPTION,  
</if>  
<if test="state != null">  
STATE,  
</if>  
<if test="createdBy != null">  
CREATED\_BY,  
</if>  
CREATED\_DT,  
<if test="version != null">  
VERSION,  
</if>  
<if test="updatedBy != null">  
UPDATED\_BY,  
</if>  
<if test="updatedDt != null">  
UPDATED\_DT,  
</if>  
<if test="zoneOrgCode != null">  
ZONE\_ORG\_CODE,  
</if>  
<if test="value1 != null">  
VALUE1,  
</if>  
<if test="value2 != null">  
VALUE2,  
</if>  
<if test="value3 != null">  
VALUE3,  
</if>  
<if test="deleteFlag != null">  
DELETE\_FLAG,  
</if>  
</trim>  
<trim prefix="values (" suffix=")" suffixOverrides=",">  
\#\{sid,jdbcType=DECIMAL\},  
<if test="roleName != null">  
\#\{roleName,jdbcType=VARCHAR\},  
</if>  
<if test="roleCode != null">  
\#\{roleCode,jdbcType=VARCHAR\},  
</if>  
<if test="roleDescription != null">  
\#\{roleDescription,jdbcType=VARCHAR\},  
</if>  
<if test="state != null">  
\#\{state,jdbcType=VARCHAR\},  
</if>  
<if test="createdBy != null">  
\#\{createdBy,jdbcType=VARCHAR\},  
</if>  
sysdate,  
<if test="version != null">  
\#\{version,jdbcType=VARCHAR\},  
</if>  
<if test="updatedBy != null">  
\#\{updatedBy,jdbcType=VARCHAR\},  
</if>  
<if test="updatedDt != null">  
\#\{updatedDt,jdbcType=DATE\},  
</if>  
<if test="zoneOrgCode != null">  
\#\{zoneOrgCode,jdbcType=VARCHAR\},  
</if>  
<if test="value1 != null">  
\#\{value1,jdbcType=VARCHAR\},  
</if>  
<if test="value2 != null">  
\#\{value2,jdbcType=VARCHAR\},  
</if>  
<if test="value3 != null">  
\#\{value3,jdbcType=VARCHAR\},  
</if>  
<if test="deleteFlag != null">  
\#\{deleteFlag,jdbcType=DECIMAL\},  
</if>  
</trim>  
</insert>

2、service层定义和service 实现

service层定义：

Long insert(E entity);

service实现：

@Override  
public Long insert(RoleInfo entity) \{  
// TODO Auto-generated method stub  
mapper.insertSelective(entity);  
return entity.getSid();  
\}

说明：插入实体对象，返回实体对象主键，主要通过配置：keyProperty属性，并且指定返回字段名称。