Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r14460 -r14461 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 14460) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 14461) @@ -9232,6 +9232,7 @@ while (rs.next()) { amount = rs.getInt(1); } + DatabaseUtil.closeResultSetAndStatement(rs); if(isMorrowSend){ sql = "select i.sendTime,rr.recyclingTime from RecyclingRecord rr,invoicePlan ip,invoice i " @@ -9244,6 +9245,7 @@ sendTimeStr = rs1.getString(1); recyclingTimeStr = rs1.getString(2); } + DatabaseUtil.closeResultSetAndStatement(rs1); if( StringUtils.isNotBlank(sendTimeStr) && StringUtils.isNotBlank(recyclingTimeStr) ){ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); sendTimeStr = sendTimeStr.substring(0,10);