实现MyBatisPlus自定义sql注入器

Posted on by hackdl

目标:新增mysql下的 插入更新的语法

INSERT INTO %s %s VALUES %s ON DUPLICATE KEY UPDATE %s

新增方法类，新增的方法名称为insertOrUpdate和insertOrUpdateBatch方法，但其mapper层的方法名为insertOrUpdate方法

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.core.injector.AbstractMethod;
import com.baomidou.mybatisplus.core.metadata.TableFieldInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfoHelper;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.core.toolkit.sql.SqlScriptUtils;
import org.apache.ibatis.executor.keygen.Jdbc3KeyGenerator;
import org.apache.ibatis.executor.keygen.KeyGenerator;
import org.apache.ibatis.executor.keygen.NoKeyGenerator;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.SqlSource;

import java.util.List;
import java.util.Objects;

import static java.util.stream.Collectors.joining;

public class InsertOrUpdate extends AbstractMethod {

    public InsertOrUpdate() {
        super(MyBatisPlusMethod.INSERT_OR_UPDATE.getMethod());
    }

    public InsertOrUpdate(String method) {
        super(method);
    }

    @Override
    public MappedStatement injectMappedStatement(Class> mapperClass, Class> modelClass, TableInfo tableInfo) {
        KeyGenerator keyGenerator = NoKeyGenerator.INSTANCE;
        MyBatisPlusMethod sqlMethod = MyBatisPlusMethod.INSERT_OR_UPDATE;
        String columnScript = SqlScriptUtils.convertTrim(tableInfo.getAllInsertSqlColumnMaybeIf(ENTITY_DOT),
                LEFT_BRACKET, RIGHT_BRACKET, null, COMMA);
        String valuesScript = SqlScriptUtils.convertTrim(tableInfo.getAllInsertSqlPropertyMaybeIf(ENTITY_DOT),
                LEFT_BRACKET, RIGHT_BRACKET, null, COMMA);
        String setScript = SqlScriptUtils.convertTrim(this.getUpdateValuePart(tableInfo, ENTITY_DOT),
                null, null, null, COMMA);
        String keyProperty = null;
        String keyColumn = null;
        // 表包含主键处理逻辑,如果不包含主键当普通字段处理
        if (StringUtils.isNotBlank(tableInfo.getKeyProperty())) {
            if (tableInfo.getIdType() == IdType.AUTO) {
                /* 自增主键 */
                keyGenerator = Jdbc3KeyGenerator.INSTANCE;
                keyProperty = tableInfo.getKeyProperty();
                keyColumn = tableInfo.getKeyColumn();
            } else if (null != tableInfo.getKeySequence()) {
                keyGenerator = TableInfoHelper.genKeyGenerator(this.methodName, tableInfo, builderAssistant);
                keyProperty = tableInfo.getKeyProperty();
                keyColumn 服务器托管网= tableInfo.getKeyColumn();
            }
        }
        String sql = String.format(sqlMethod.getSql(), tableInfo.getTableName(), columnScript, valuesScript, setScript);
        SqlSource sqlSource = languageDriver.createSqlSource(configuration, sql, modelClass);
        return this.addInsertMappedStatement(mapperClass, modelClass, getMethod(sqlMethod), sqlSource, keyGenerator, keyProperty, keyColumn);
    }

    protected String getMethod(MyBatisPlusMethod sqlMethod) {
        return StringUtils.isBlank(methodName) ? sqlMethod.getMethod() : this.methodName;
    }

    protected String getUpdateValuePart(TableInfo tableInfo, String prefix) {
        List fieldList = tableInfo.getFieldList();
        return fieldList.stream().map(i -> i.getSqlSet(false, prefix))
                .filter(Objects::nonNull).collect(joining(NEWLINE));
    }
}

新增该方法的枚举类

public enum MyBatisPlusMethod {
    /**
     * 插入
     */
    INSERT_OR_UPDATE("insertOrUpdate", "插入更新一条数据（选择字段插入）", "nINSERT INTO %s %s VALUES %s ON DUPLICATE KEY UPDATE %sn");

    private final String method;
    private final String desc;
    private final String sql;

    MyBatisPlusMethod(String method, String desc, String sql) {
        this.method = method;
        this.desc = desc;
        this.sql = sql;
    }

    public String getMethod() {
        return method;
    }

    public String getDesc() {
        return desc;
    }

    public String getSql() {
        return sql;
    }
}

继承并实现MyBatisPlus的mapper、service层的方法

mapper

import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.chinacreator.c2.dao.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

public interface MyBatisPlusMapper extends BaseMapper {

    /**
     * 插入更新一条记录
     *
     * @param entity 实体对象
     * 服务器托管网@return
     */
    int insertOrUpdate(@Param(Constants.ENTITY) T entity);
}

service

package com.chinacreator.c2.chs.mp;

import com.baomidou.mybatisplus.extension.service.IService;
import org.springframework.transaction.annotation.Transactional;

import java.util.Collection;

public interface MyBatisPlusService extends IService {

    /**
     * 一句sql执行插入更新语句
     *
     * @param entityList 需要插入更新的实体
     * @return 是否成功
     */
    @Transactional(rollbackFor = Exception.class)
    default boolean insertOrUpdateBatch(Collection entityList) {
        return insertOrUpdateBatch(entityList, DEFAULT_BATCH_SIZE);
    }

    boolean insertOrUpdateBatch(Collection entityList, int batchSize);

    /**
     * 一句sql执行插入更新语句
     *
     * @param entity 需要插入更新的实体
     * @return 是否成功
     */
    boolean insertOrUpdate(T entity);

}

serviceImpl

import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.core.toolkit.StringPool;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.baomidou.mybatisplus.extension.toolkit.SqlHelper;
import org.apache.ibatis.binding.MapperMethod;
import org.springframework.transaction.annotation.Transactional;

import java.util.Collection;

public class MyBatisPlusServiceImpl, T> extends ServiceImpl implements MyBatisPlusService {
    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean insertOrUpdateBatch(Collection entityList, int batchSize) {
        String mapperStatementId = mapperClass.getName() + StringPool.DOT + MyBatisPlusMethod.INSERT_OR_UPDATE.getMethod();
        return SqlHelper.executeBatch(entityClass, log, entityList, batchSize, (sqlSession, entity) -> {
            MapperMethod.ParamMap param = new MapperMethod.ParamMap();
            param.put(Constants.ENTITY, entity);
            sqlSession.insert(mapperStatementId, param);
        });
    }

    @Override
    public boolean insertOrUpdate(T entity) {
        return SqlHelper.retBool(getBaseMapper().insertOrUpdate(entity));
    }
}

新增自定义的MyBatisPlus自定义注入器

import com.baomidou.mybatisplus.core.injector.AbstractMethod;
import com.baomidou.mybatisplus.core.injector.DefaultSqlInjector;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.chinacreator.c2.dao.mapper.InsertBatchMethod;

import java.util.List;

public class MyBatisPlusSqlInjector extends DefaultSqlInjector {

    /**
     * 如果只需增加方法，保留mybatis plus自带方法， 可以先获取super.getMethodList()，再添加add
     */
    @Override
    public List getMethodList(Class> mapperClass, TableInfo tableInfo) {
        List methodList = super.getMethodList(mapperClass, tableInfo);
        methodList.add(new InsertOrUpdate());
        return methodList;
    }
}

在MyBatisPlus的配置文件类上 创建该自定义注入器的bean对象

import com.chinacreator.c2.chs.mp.MyBatisPlusSqlInjector;
import lombok.extern.slf4j.Slf4j;
import org.springframework.context.annotation.Configuration;

@Slf4j
@Configuration
public class MyBatisPlusConfig {
    @Bean
    public MyBatisPlusSqlInjector customizedSqlInjector() {
        return new MyBatisPlusSqlInjector();
    }
}

对使用官方生成的mapper、service、serviceImpl文件的继承类上改为我这边新增的

最后再调用service或mapper下的insertOrUpdate方法或insertOrUpdateBatch方法

服务器托管，北京服务器托管，服务器租用 http://www.fwqtg.net
机房租用，北京机房租用，IDC机房托管， http://www.fwqtg.net

相关推荐: 【MySQL】数据库基础 ③✍临时表✍复制表✍元数据
✍处理重复数据✍SQL注入

 上一章： 【MySQL】数据库基础 ②                                                                                                   ✍临时表 说明： My…

服务器托管，北京服务器托管，服务器租用，机房机柜带宽租用

服务器托管

咨询：董先生

电话13051898268 QQ/微信93663045！

上一篇:
下一篇: