HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [ ]; SQL state [null]; error code [17004]; 无效的列类型; nested exception is java.sql.SQLException: 无效的列类型。
又了一个犯低级错误,把
Map<String, Object> mapList =
simpleJdbcTemplate.queryForMap(sql.toString(),param);
改成
Map<String, Object> mapList =
simpleJdbcTemplate.queryForMap(sql.toString(),param.toArray());
即可