报错如下:
org.springframework.jdbc.UncategorizedSQLException:
### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'?',expect QUES, actual QUES null : ?
### The error may exist in file [C:\Users\zx\workSpace\report_management\target\classes\mybatis\DataModelMapper.xml]
### The error may involve ctyun.visl.bddvl.mapper.DataModelMapper.getTableDataBySQL
### The error occurred while executing a query
### SQL: ?
### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'?',expect QUES, actual QUES null : ?;
uncategorized SQLException for SQL [];
SQL state [null]; error code [0];
sql injection violation, syntax error: syntax error, error in :'?',expect QUES, actual QUES null : ?;
nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'?',expect QUES, actual QUES null : ?
解决方法:
原来的参数写法:
#{_parameter}
修正过后的参数写法:
${_parameter}