【mybatis】mybatis映射文件，sql语句注释

Nikonikonikonkoniko

于 2024-07-17 11:50:10 发布

阅读量36

点赞数 1

分类专栏： mybatis 文章标签： mybatis sql 注释

本文链接：https://blog.csdn.net/princekin_even/article/details/140490833

版权

mybatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

【小记】今天学 mybatis 的时候，多种模糊查询语句，在注释的时候，执行报错，找了半天

【报错内容】而且日志也打印了注释的内容

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='username', 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 #2 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 #2 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 (2 > number of parameters, which is 1).
### The error may exist in com/atguigu/mybatis/mappers/ParameterMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: /*select * from t_user where username like '%N%'         select * from t_user where username like "%"?"%"*/         select * from t_user where username like concat("%", ?,"%")
### Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='username', 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 #2 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 #2 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 (2 > number of parameters, which is 1).

【解决方法】sql 注释不要用 -- 也不要用 /**/，用，日志也不打印注释内容