Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java =================================================================== diff -u -r36551 -r36560 --- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java (.../RecyclingRecordManagerImpl.java) (revision 36551) +++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java (.../RecyclingRecordManagerImpl.java) (revision 36560) @@ -525,7 +525,7 @@ sbf.append(BarcodeDevice.class.getSimpleName()); sbf.append(" bd where "); sbf.append(barcodeSql); - sbf.append(");");*/ + sbf.append(")");*/ sbf.append("update "); sbf.append(TousseInstance.class.getSimpleName()); sbf.append(" set recyclingItemId="); @@ -540,7 +540,7 @@ sbf.append(barcodeSql); sbf.append(") and tousseDefinition_id in(select id from "); sbf.append(TousseDefinition.class.getSimpleName()); - sbf.append(" where isRecycling='是');"); + sbf.append(" where isRecycling='是')"); } jdbcTemplate.execute(sbf.toString()); sbf.setLength(0); @@ -564,7 +564,6 @@ sbf.append(BarcodeDevice.class.getSimpleName()); sbf.append(" bd on bd.id=ii.id where td.isRecycling='是' and ti.useRecord_id is not null and "); sbf.append(totalBarcodeSql); - sbf.append(";"); useRecordIds.addAll(objectDao.getLongSet(sbf.toString())); } } @@ -663,7 +662,7 @@ sql.append(RecyclingItem.class.getSimpleName()); sql.append(" ri inner join "); sql.append(RecyclingRecord.class.getSimpleName()); - sql.append(" rr on ri.recyclingRecord_id=rr.id where ri.id=?) and tousseDefinitionId =?;"); + sql.append(" rr on ri.recyclingRecord_id=rr.id where ri.id=?) and tousseDefinitionId =?"); jdbcTemplate.batchUpdate(sql.toString(), new BatchPreparedStatementSetter() { @Override @@ -9973,7 +9972,7 @@ } } if(basketSizeList.size() > 0){ - String sql = "update " + ClassifyBasket.class.getSimpleName()+" set basketSize=? where id=?;"; + String sql = "update " + ClassifyBasket.class.getSimpleName()+" set basketSize=? where id=?"; jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() { @Override @@ -10016,7 +10015,7 @@ sbf.append(TousseInstance.class.getSimpleName()); sbf.append(" set recyclingItemId=? where recyclingItemId is null and tousseItemId in (select id from "); sbf.append(TousseItem.class.getSimpleName()); - sbf.append(" ti where ti.recyclingApplication_id=? ) and tousseDefinition_id=?;"); + sbf.append(" ti where ti.recyclingApplication_id=? ) and tousseDefinition_id=?"); jdbcTemplate.batchUpdate(sbf.toString(), new BatchPreparedStatementSetter() { @Override