【mybatis】 org.apache.ibatis.builder.BuilderException

mybatis异常

Caused by: org.apache.ibatis.builder.BuilderException: Improper inline parameter map format.  Should be: #{propName,attr1=val1,attr2=val2}
  at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.parseParameterMapping(SqlSourceBuilder.java:144)
  at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.buildParameterMapping(SqlSourceBuilder.java:78)
  at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.handleToken(SqlSourceBuilder.java:73)
  at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:47)
  at org.apache.ibatis.builder.SqlSourceBuilder.parse(SqlSourceBuilder.java:54)
  at org.apache.ibatis.builder.xml.dynamic.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:40)
  at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:241)
  at org.apache.ibatis.executor.statement.BaseStatementHandler.<init>(BaseStatementHandler.java:61)
  at org.apache.ibatis.executor.statement.PreparedStatementHandler.<init>(PreparedStatementHandler.java:36)
  at org.apache.ibatis.executor.statement.RoutingStatementHandler.<init>(RoutingStatementHandler.java:42)
  at org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:348)
  at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:43)
  at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
  at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
  at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
  at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:597)
  at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:354)
  ... 70 more

 

mapper中的参数有问题

本实例异常原因：jdbcType=VARCHAR  等号两边加空格了

解决方法：

d.batch_code = #{batchCode,jdbcType=VARCHAR}，其中jdbcType=VARCHAR等号两边不能加空格