Mybatis Plus动态表名及动态参数(binlog同步等可用)

SyncData操作接口设计

最新推荐文章于 2025-09-12 13:57:46 发布

原创最新推荐文章于 2025-09-12 13:57:46 发布 · 1.9k 阅读

3 ·

CC 4.0 BY-SA版权

Mybatis 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一个名为SyncData的Java类及其对应的MyBatis Plus Mapper接口。SyncData用于表示需要同步的数据对象，包括表名、列及值等属性。Mapper接口提供了插入、更新和查询数据的方法，使用XML脚本方式动态生成SQL语句，支持按条件更新和查询。

//桥接对象，不对应数据库任何表
@Data
public class SyncData implements Serializable {

    private String tableName;

    private List<SyncDataColumn> columns;

    //当前暂时不支持多个，后续可以考虑多个group by查询情况
    private Pair<String, String> group;


    @Data
    @AllArgsConstructor
    public static class SyncDataColumn{
        private String column;

        private String value;
    }
}

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;
import java.util.Map;

public interface SyncDataMapper extends BaseMapper<SyncData> {

    @Insert({
            "<script>",
            "INSERT INTO ${tableName} ",
            "<foreach collection='columns' item='item' separator=',' open='(' close=')' index='index'> ",
            "${item.column}",
            " </foreach> ",
            " values ",
            "<foreach collection='columns' item='item' separator=',' open='(' close=')' index='index'> ",
            "<choose>",
            "  <when test='item.value != null'>",
            "'${item.value}'",
            "  </when>",
            "  <otherwise>",
            "null",
            "  </otherwise>",
            "</choose>",
            " </foreach> ",
            " ON DUPLICATE KEY UPDATE ",
            "<foreach collection='columns' item='item' separator=',' index='index'> ",
            "<choose>",
            "  <when test='item.value != null'>",
            "${item.column} = '${item.value}'",
            "  </when>",
            "  <otherwise>",
            "${item.column} = null",
            "  </otherwise>",
            "</choose>",
            " </foreach> ",
            "</script>"
    })
    int insert(SyncData data);

    @Update({
            "<script>",
            "update ${tableName} set ",
            "<foreach collection='columns' item='item' separator=',' index='index'> ",
            "<choose>",
            "  <when test='item.value != null'>",
            "${item.column} = '${item.value}'",
            "  </when>",
            "  <otherwise>",
            "${item.column} = null",
            "  </otherwise>",
            "</choose>",
            " </foreach> ",
            " where ",
            "${group.left} = '${group.right}'",
            "</script>"
    })
    int updateByGroup(SyncData data);

    @Select({
            "<script>",
            "select t.* from ${tableName} t where ",
            "<foreach collection='columns' item='item' separator=' and '  index='index'> ",
            " ${item.column} = '${item.value}' ",
            " </foreach> ",
            "</script>"
    })
    List<Map<String, Object>> select(SyncData data);

    @Select({
            "<script>",
            "select t.* from ${tableName} t where ",
            " ${group.key} = '${group.value}' ",
            "</script>"
    })
    List<Map<String, Object>> selectByGroup(SyncData data);


}