• 动态insert mybatis与ibatis


    mybatis:

    <insert id="insert" parameterType="hashMap">
        INSERT INTO item
        <trim prefix="(" suffix=")" suffixOverrides=",">
          <if test="id != null">
            id,
          </if>
          ...
          </if>
          <if test="created != null">
            created,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
          <if test="id != null">
            #{id,jdbcType=BIGINT},
          </if>
          ...
          <if test="created != null">
            #{created,jdbcType=TIMESTAMP},
          </if>
        </trim>
      </insert>

    ibatis:

    <insert id="insert" parameterClass="hashMap">
            INSERT INTO item
            <dynamic prepend="(" close=")">
                <isNotNull prepend="," property="obj.id">
                    id
                </isNotNull>
                ...
                ,created
            </dynamic>
            VALUES
            <dynamic prepend="(" close=")">
                <isNotNull prepend="," property="obj.id">
                    #obj.id#
                </isNotNull>
                 ...
                ,now()
            </dynamic>
            <selectKey resultClass="long" keyProperty="id">
                SELECT LAST_INSERT_ID() AS ID
            </selectKey>
     </insert>
  • 相关阅读:
    123
    p1216
    离线可持久化动态树
    线段树合并
    p2024
    树的dfs序,p1539,p1651,,2018/11/08模拟赛T3
    p1460
    CDQ分治,二维数点与三维数点,p1357与p2026与p2027与p2028与p2029
    自动AC机
    平衡二叉树之splay p1998
  • 原文地址:https://www.cnblogs.com/kingsonfu/p/9273347.html
Copyright © 2020-2023  润新知