### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{paramCategory}) AND t.usable = '0')
ORDER BY t.sort_no asc' at line 3
### The error may exist in com/yjzx/release/mapper/ParamConfigMapper.java (best guess)
### The error may involve com.yjzx.release.mapper.ParamConfigMapper.getParamConfigList-Inline
### The error occurred while setting parameters
### SQL: SELECT t.oid,t.code,t.data_source dataSource,t.name,t.oper_time operTime,t.param_type paramType, t.param_category paramCategory,t.sort_no sortNo,t.tran_flag tranFlag,t.usable,t.param_value paramValue FROM t_param_config t WHERE (t.param_type = ? AND t.param_category in (${paramCategory}) AND t.usable = ?) ORDER BY t.sort_no asc
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{paramCategory}) AND t.usable = '0')
ORDER BY t.sort_no asc' at line 3
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{paramCategory}) AND t.usable = '0')
ORDER BY t.sort_no asc' at line 3] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{paramCategory}) AND t.usable = '0')
ORDER BY t.sort_no asc' at line 3
这个错误的原因主要是使用mabatis的注解@SelectProvider,@InsertProvider,@UpdateProvider,@DeleteProvider
生成sql语句的时候使用 条件 in (${})
主要是mybatis的这种动态生成sql语句并不支持这样的条件查询
解决方式的话可以使用字符串拼接的方式 例如 String.format("in (%s) ",str)