关于mybatis在mysql实践中针对自增主键的配置

最新推荐文章于 2020-07-10 17:31:14 发布

dimmer_sunny

最新推荐文章于 2020-07-10 17:31:14 发布

阅读量419

点赞数

分类专栏： JavaTech

本文链接：https://blog.csdn.net/dimmer_sunny/article/details/37742271

版权

JavaTech 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

近期需要搭建个基于spring4+mybatis3+mysql的框架.在搭建过程中遇到一些问题.现记录如下:

mysql的自增主键问题.

mapper有两种配置方式:

主键交由mysql自己生成:    <insert id="insert" parameterType="User" useGeneratedKeys="true" keyProperty="id">
       insert into user
        <trim prefix="(" suffix=")" suffixOverrides=",">
          <if test="state != null">
            STATE,
          </if>
          <if test="name != null">
            NAME,
          </if>
          <if test="loginName != null">
            LOGIN_NAME,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
          <if test="state != null">
            #{state,jdbcType=VARCHAR},
          </if>
          <if test="name != null">
            #{name,jdbcType=VARCHAR},
          </if>
          <if test="loginName != null">
            #{loginName,jdbcType=VARCHAR},
          </if>
        </trim>
   </insert>
直接把主键写到配置文件中    <insert id="insert" parameterType="User" >
       <selectKey keyProperty="id" resultType="int" order="BEFORE">
           SELECT LAST_INSERT_ID()
       </selectKey>
       insert into user
        <trim prefix="(" suffix=")" suffixOverrides=",">
           ID,
          <if test="state != null">
            STATE,
          </if>
          <if test="name != null">
            NAME,
          </if>
          <if test="loginName != null">
            LOGIN_NAME,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
           #{id},
          <if test="state != null">
            #{state,jdbcType=VARCHAR},
          </if>
          <if test="name != null">
            #{name,jdbcType=VARCHAR},
          </if>
          <if test="loginName != null">
            #{loginName,jdbcType=VARCHAR},
          </if>
        </trim>
   </insert>