Java Spring MVC项目异常解决

[DEBUG] 2024-04-17 10:28:36,056 org.springframework.jdbc.datasource.DataSourceTransactionManager - Initiating transaction rollback
[DEBUG] 2024-04-17 10:28:36,056 org.springframework.jdbc.datasource.DataSourceTransactionManager - Rolling back JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@72a8b18e]
[DEBUG] 2024-04-17 10:28:36,057 org.springframework.jdbc.datasource.DataSourceTransactionManager - Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@72a8b18e] after transaction
[DEBUG] 2024-04-17 10:28:36,057 org.springframework.web.servlet.DispatcherServlet - Failed to complete request: java.lang.RuntimeException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='delId', mode=IN, javaType=class java.lang.Integer, 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: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer

源码：

 异常修复：
 

1. 检查 MyBatis 的映射文件，确保参数的类型与数据库列的类型匹配。
2. 确保传入参数的类型与映射文件中定义的类型一致，如果需要，可以进行相应的类型转换。
3. 尝试指定参数的 jdbc 类型，避免null 

改后：