mybatis 按照 map 动态进行 insert 和 update

最新推荐文章于 2024-07-02 22:52:47 发布

原创最新推荐文章于 2024-07-02 22:52:47 发布 · 1.6k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #java

Java 专栏收录该内容

16 篇文章

订阅专栏

本文介绍了一个使用MyBatis框架实现动态SQL的示例，包括如何在插入和更新操作中利用Map集合动态生成SQL字段。通过参数类型为com.Data的实体类，实现了根据Map中的键值对动态构建SQL语句，适用于需要灵活处理数据库字段的场景。

按照 map 动态进行 insert 和 update

<!--更新用户数据-->
    <update id="update" parameterType="com.Data">
        update loy_data
        <set>
            <if test="deleteFlg != null">
                DELETE_FLG = #{deleteFlg},
            </if>
            UPDATED_AT = #{updatedAt},
            UPDATED_BY = #{updatedBy}
            <foreach collection="fields" index="key" item="value">
                , ${key} = #{value}
            </foreach>
        </set>
        where id = #{id}
    </update>

    <!--新增用户数据-->
    <insert id="insert" parameterType="com.Data" keyProperty="id" useGeneratedKeys="true">
        insert into loy_data(id, DELETE_FLG, CREATED_AT, CREATED_BY, UPDATED_AT, UPDATED_BY
        <foreach collection="fields.keys" index="index" item="key">
            , ${key}
        </foreach>
        )
        VALUES
        (#{id}, #{deleteFlg}, #{createdAt}, #{createdBy}, #{updatedAt}, #{updatedBy}
        <foreach collection="fields.values" index="index" item="value">
            , #{value}
        </foreach>
        )
    </insert>

/**
 * (LoyData)实体类
 *
 * @author wanghang
 * @since 2020-05-14 17:49:31
 */
@SequenceId(property = "id")
public class LoyData implements Serializable {

    private static final long serialVersionUID = 238203000278523870L;

    /**
     * 数据ID
     */
    private Long id;
    /**
     * 删除标志 1：删除 0：不删除
     */
    private Integer deleteFlg;
    /**
     * 创建时间
     */
    private Long createdAt;
    /**
     * 创建人
     */
    private Long createdBy;
    /**
     * 最近更新时间
     */
    private Long updatedAt;
    /**
     * 最近更新人
     */
    private Long updatedBy;
    /**
     * 动态列
     */
    private Map<String, Object> fields;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Integer getDeleteFlg() {
        return deleteFlg;
    }

    public void setDeleteFlg(Integer deleteFlg) {
        this.deleteFlg = deleteFlg;
    }

    public Long getCreatedAt() {
        return createdAt;
    }

    public void setCreatedAt(Long createdAt) {
        this.createdAt = createdAt;
    }

    public Long getCreatedBy() {
        return createdBy;
    }

    public void setCreatedBy(Long createdBy) {
        this.createdBy = createdBy;
    }

    public Long getUpdatedAt() {
        return updatedAt;
    }

    public void setUpdatedAt(Long updatedAt) {
        this.updatedAt = updatedAt;
    }

    public Long getUpdatedBy() {
        return updatedBy;
    }

    public void setUpdatedBy(Long updatedBy) {
        this.updatedBy = updatedBy;
    }

    public Map<String, Object> getFields() {
        return fields;
    }

    public void setFields(Map<String, Object> fields) {
        this.fields = fields;
    }

    @Override
    public String toString() {
        return "LoyaltyData{" +
                "id=" + id +
                ", deleteFlg=" + deleteFlg +
                ", createdAt=" + createdAt +
                ", createdBy=" + createdBy +
                ", updatedAt=" + updatedAt +
                ", updatedBy=" + updatedBy +
                ", fields=" + fields +
                '}';
    }
}