不能在映射器文件中使用带参数的方法

Question

Java 1.7，Wildfly8，MyBatis 3.2.6，PostgreSQL 9.4。

我有原型，这是简单的系统借书。我用MyBatis作为ORM。一切都很好，直到我尝试过滤器。有一桌书。获取图书列表是在mapper中定义的，如下所示：

<select id="selectBooks" resultType="org.bookman.json.library.JsonBook">
  select id, created, inclusion_date as inclusionDate, title, author
  from bok_books
  <where>
    <if test="filter('title') != null">
      title ilike #{filter('title')}||'%'
    </if>
  </where>
  order by ${orderCols}
</select>

TableReqHnd bookHnd = new TableReqHnd();
... // among other things sets filter data
List<JsonBook> books = sqlSession.selectList("selectBooks", bookHnd, rowBounds);

public class TableReqHnd
{
  private Map<String, String> filters        = new HashMap<>();
  ...
  public String getOrderCols()
  {
    ...
  }
  ...
  public String filter(String fieldId)
  {
    if (!filters.containsKey(fieldId)) return null;
    return filters.get(fieldId);
  }
}

filter('title')

Answer 1

你试过吗

<select id="selectBooks" paramType="org.bookman.json.library.JsonBook">
  select id, created, inclusion_date as inclusionDate, title, author
  from bok_books
  <where>
    <if test="filter('title') != null">
      title ilike #{filter('title')}||'%'
    </if>
  </where>
  order by ${orderCols}
</select>