Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r26098 -r26100 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 26098) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 26100) @@ -8613,7 +8613,7 @@ } // 查询满足搜索条件的借物单 - String sql = "select i.tousseName, sum(i.amount) from invoiceplan p,tousseItem i where " + String sql = "select i.tousseName, sum(i.amount) amount from invoiceplan p,tousseItem i where " + "p.id = i.recyclingApplication_ID and p.submitTime between " + dateQueryAdapter.dateAdapter(startDay) + " and " + dateQueryAdapter.dateAdapter(endDay); @@ -8635,9 +8635,9 @@ try { // 遍历每一张借物单 while (rs.next()) { - String tousseName = rs.getString(1); + String tousseName = rs.getString("tousseName"); - int borrowingAmount = rs.getInt(2); + int borrowingAmount = rs.getInt("amount"); BorrowingRecordItemVo vo = new BorrowingRecordItemVo();