Mybatis设置自增主键

useGeneratedKeys="true" keyProperty="id"

方法1:
    <insert id="insert" parameterType="Person" useGeneratedKeys="true" keyProperty="id">
        insert into person(name,pswd) values(#{name},#{pswd})
    </insert>
 
方法2:
    <insert id="insert" parameterType="Person">
        <selectKey keyProperty="id" resultType="long">
            select LAST_INSERT_ID()
        </selectKey>
        insert into person(name,pswd) values(#{name},#{pswd})
    </insert>

 

posted on 2016-09-11 20:48  jis117  阅读(3354)  评论(0编辑  收藏  举报

导航