mybatis3.3@sqlprovider注解使用的一点点坑

最新推荐文章于 2024-08-21 23:39:15 发布

玊白

最新推荐文章于 2024-08-21 23:39:15 发布

阅读量1w

点赞数 5

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/a793297896/article/details/65934839

版权

mybatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

使用@selectprovider的时候，方法中传了两个参数，然后编译时报错。

经查看 Itype @cjm0000000大神的博客http://qurey.iteye.com/blog/1944785后才懂得，

原来mybatis3.3中selectprovider中type类的方法的参数只能小于2个（标红的部分）：

org.apache.ibatis.builder.annotation.ProviderSqlSource

public ProviderSqlSource(Configuration config, Object provider) {
    String providerMethodName = null;
    try {
      this.sqlSourceParser = new SqlSourceBuilder(config);
      this.providerType = (Class<?>) provider.getClass().getMethod("type").invoke(provider);
      providerMethodName = (String) provider.getClass().getMethod("method").invoke(provider);

      for (Method m : this.providerType.getMethods()) {
        if (providerMethodName.equals(m.getName())) {
          if (m.getParameterTypes().length < 2
              && m.getReturnType() == String.class) {
            this.providerMethod = m;
            this.providerTakesParameterObject = m.getParameterTypes().length == 1;
          }
        }
      }
    } catch (Exception e) {
      throw new BuilderException("Error creating SqlSource for SqlProvider.  Cause: " + e, e);
    }
    if (this.providerMethod == null) {
      throw new BuilderException("Error creating SqlSource for SqlProvider. Method '"
          + providerMethodName + "' not found in SqlProvider '" + this.providerType.getName() + "'.");
    }
  }

而mybatis3.4中的代码就取消了参数个数限制：

public ProviderSqlSource(Configuration config, Object provider) {
    String providerMethodName;
    try {
      this.sqlSourceParser = new SqlSourceBuilder(config);
      this.providerType = (Class<?>) provider.getClass().getMethod("type").invoke(provider);
      providerMethodName = (String) provider.getClass().getMethod("method").invoke(provider);

      for (Method m : this.providerType.getMethods()) {
        if (providerMethodName.equals(m.getName())) {
          if (m.getReturnType() == String.class) {
            if (providerMethod != null){
              throw new BuilderException("Error creating SqlSource for SqlProvider. Method '"
                      + providerMethodName + "' is found multiple in SqlProvider '" + this.providerType.getName()
                      + "'. Sql provider method can not overload.");
            }
            this.providerMethod = m;
            this.providerMethodArgumentNames = new ParamNameResolver(config, m).getNames();
          }
        }
      }
    } catch (BuilderException e) {
      throw e;
    } catch (Exception e) {
      throw new BuilderException("Error creating SqlSource for SqlProvider.  Cause: " + e, e);
    }
    if (this.providerMethod == null) {
      throw new BuilderException("Error creating SqlSource for SqlProvider. Method '"
          + providerMethodName + "' not found in SqlProvider '" + this.providerType.getName() + "'.");
    }
  }

所以，在mybatis3.3中使用@sqlprovider传多个参数时，要么直接用实体bean替换，要么用Map包装一下。

虽拾人牙慧，但自己再记一下有助自己提高。