报错:
[iwater-d-s:192.168.0.62:3004] 2022-10-08 20:48:59.897 ERROR 2428 [] [http-nio-3004-exec-5] o.a.c.c.C.[.[.[/].[dispatcherServlet] Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.ClassCastException: java.lang.String cannot be cast to java.util.List] with root cause
java.lang.ClassCastException: java.lang.String cannot be cast to java.util.List
at com.iwater.data.service.dao.impl.UseWaterDetailDaoImpl.getAreaUseWaterListByAreaIa(UseWaterDetailDaoImpl.java:71)
at com.iwater.data.service.service.impl.UseWaterServiceImpl.getAreaUseWaterList(UseWaterServiceImpl.java:44)
at com.iwater.data.service.controller.UseWaterController.getAreaUseWaterList(UseWaterController.java:42)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
原因:
string强转list集合报错。
List<String> meterCodes = (List<String>) params.get("meterCodes");
解决:
用JsonUtil.toList来处理
if (null != params.get("meterCodes")){
List<String> meterCodes = JsonUtil.toList((String) params.get("meterCodes"),String.class);
String sql="";
for (String meterCode : meterCodes) {
sql=sql+meterCode+",";
}
sb.append(" and meterCode in("+sql.substring(0,sql.length()-1)+")");
}