新增返回主键

MySql和SqlServer 支持主键自增长的数据库：

<insert id="add" parameterType="com.yweb.entity.User" keyProperty="id" useGeneratedKeys="true">  
    insert into (name,age) values ('zs',18)  
</insert>

 

Oracle不支持主键自增长的数据库：

<insert id="insert" parameterType="AltName">   
    <selectKey resultType="long" keyProperty="id">   
        SELECT SEQ_TEST.NEXTVAL FROM DUAL    
    </selectKey>   
    insert into altname(primaryName,alternateName,type)values(#{primaryName},#{alternateName},#{type})    
</insert>

 

转载于:https://www.cnblogs.com/yifanSJ/p/9096026.html