在mapper.xml文件中的insert中增加以下标红的代码实现id采用自增方式写入数据库，并且写入一个uuid字符

最新推荐文章于 2024-06-18 14:51:15 发布

原创最新推荐文章于 2024-06-18 14:51:15 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

mybatis 专栏收录该内容

4 篇文章

订阅专栏

本文探讨了在MyBatis中使用UUID作为主键的批量插入策略，通过XML映射文件展示了如何在插入前生成UUID，并利用trim元素实现字段的按需插入，适用于Depart实体类的插入操作。

<insert id="insert" parameterType="ssm.item.admin.bean.Depart" useGeneratedKeys="true" 
//开始添加
keyProperty="departId">
      <selectKey keyProperty="departId" resultType="java.lang.String"
    order="BEFORE">
    select replace(uuid(),'-','') from dual
    </selectKey>
//结束添加
    insert into depart (depart_id, depart_name, depart_code
      )
    values (#{departId,jdbcType=VARCHAR}, #{departName,jdbcType=VARCHAR}, #{departCode,jdbcType=VARCHAR}
      )
  </insert>
  <insert id="insertSelective" parameterType="ssm.item.admin.bean.Depart" useGeneratedKeys="true" keyProperty="departId">
      <selectKey keyProperty="departId" resultType="java.lang.String"
    order="BEFORE">
    select replace(uuid(),'-','') from dual
    </selectKey>
    insert into depart
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="departId != null">
        depart_id,
      </if>
      <if test="departName != null">
        depart_name,
      </if>
      <if test="departCode != null">
        depart_code,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="departId != null">
        #{departId,jdbcType=VARCHAR},
      </if>
      <if test="departName != null">
        #{departName,jdbcType=VARCHAR},
      </if>
      <if test="departCode != null">
        #{departCode,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>