java.lang.StringIndexOutOfBoundsException: String index out of range: -1

问题：

java.lang.StringIndexOutOfBoundsException: String index out of range: -1
	at java.lang.String.substring(String.java:1967)
	at com.iwater.workbench.data.service.impl.UseWaterServiceImpl.getAreaUseWaterList(UseWaterServiceImpl.java:112)
	at sun.reflect.GeneratedMethodAccessor1427.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:282)
	at org.springframework.cloud.context.scope.GenericScope$LockedScopedProxyFactoryBean.invoke(GenericScope.java:499)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.iwater.workbench.data.service.impl.UseWaterServiceImpl$$EnhancerBySpringCGLIB$$5b3a8887.getAreaUseWaterList(<generated>)
	at com.iwater.workbench.data.controller.AreaController.getUseWaterList(AreaController.java:523)
	at com.iwater.workbench.data.controller.AreaController$$FastClassBySpringCGLIB$$cd04cab9.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

原因：

sql为空造成。

//通过小区id和表型号id查询水表
List<Watermeter> watermeterList = watermeterMapper.findWaterByAreaIdAndMeterModelId(param);
List<String> meterCodes = new ArrayList<>();
watermeterList.forEach(watermeter -> {
	meterCodes.add(watermeter.getMeterCode());
});
String sql="";
for (String meterCode : meterCodes) {
	sql=sql+"'"+meterCode+"'"+",";
}
params.put("meterCodes",sql.substring(0,sql.length()-1));

解决：

//通过小区id和表型号id查询水表
List<Watermeter> watermeterList = watermeterMapper.findWaterByAreaIdAndMeterModelId(param);
List<String> meterCodes = new ArrayList<>();
watermeterList.forEach(watermeter -> {
	meterCodes.add(watermeter.getMeterCode());
});
String sql="";
for (String meterCode : meterCodes) {
	sql=sql+"'"+meterCode+"'"+",";
}
if (StringUtils.isNotEmpty(sql)){
	params.put("meterCodes",sql.substring(0,sql.length()-1));
}