mybatis sql 模糊查询类型错误

2020-10-09 14:39:28 [http-nio-6143-exec-10] WARN  org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver - Resolved [org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='firmName', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).]

错误sql

select tu.firm_name,tp.proj_name,tp.proj_code
        from tcm_user tu
        left join tcm_project tp
        on tu.id=tp.user_id
        where tu.firm_name like '%#{firmName}%' or tp.proj_name like '%#{projName}%'

解决
将#号改为$

 select tu.firm_name,tp.proj_name,tp.proj_code
        from tcm_user tu
        left join tcm_project tp
        on tu.id=tp.user_id
        where tu.firm_name like '%${firmName}%' or tp.proj_name like '%${projName}%'