TKMAPPER批量更新支持自定义主键的没有bug的写法

如果你正常喜欢到处COPY代码, 下面这个

public class BatchExampleProvider extends ExampleProvider {
   
    public BatchExampleProvider(Class<?> mapperClass, MapperHelper mapperHelper) {
   
        super(mapperClass, mapperHelper);
    }

    /**
     * 拼update sql, 使用case when方式，id为主键
     *
     *
     * update table_name
     * set
     *      col_1 = case
     *           when id_1 then col_1_value_1
     *           when id_2 then col_1_value_2
     *      end,
     *      col_2 = case
     *           when id_1 then col_2_value_1
     *           when id_2 then col_2_value_2
     *      end
     * WHERE id IN (id_1, id_2)
     *
     * @param ms
     * @return
     */
    public String updateBatchByPrimaryKeySelective(MappedStatement ms) {
   
        final Class<?> entityClass = getEntityClass(ms);
        //开始拼sql
        StringBuilder sql = new StringBuilder();
        sql.append(SqlHelper.updateTable(entityClass, tableName(entityClass)));
        sql.append("<trim prefix=\"set\" suffixOverrides=\",\">");

        //获取全部列
        Set<EntityColumn> columnList = EntityHelper.getColumns(entityClass);
        for (EntityColumn column : columnList) {
   
            if (!column.isId() && column.isUpdatable()) {
   
                sql.append("  <trim prefix=\"" + column.getColumn() + " =case\" suffix=\"end,\">");
                sql.append("    <foreach collection=\"list\" item=\"i\" index=\"index\">");
                sql.append("      <if test=\"i." + column.getEntityField().getName() + "!=null\">");
                sql.append("         when id=#{i.id} then #{i." + column.getEntityField().getName() +