public static void main(String[] args) { DatabaseTransaction trans = new DatabaseTransaction(); DatabaseTransaction trans2 = new DatabaseTransaction(); RequestService requestService = new RequestServiceImpl(trans); RequestItemService requestItemService = new RequestItemServiceImpl(trans2); List<Request> updateReqList = new ArrayList<Request>(); logger.info("生成申请单数据"); for (int i = 1; i <= 250; i++) { Request obj = new Request(); Calendar fromDate = Calendar.getInstance(); fromDate.set(2016, 03, 01, 00, 00, 00); obj.setFromDate( DateUtil.parseStrToTimestamp( DateUtil.getDateTime(fromDate, "yyyy-MM-dd HH:mm:ss"), "yyyy-MM-dd HH:mm:ss")); Calendar endDate = Calendar.getInstance(); endDate.set(2016, 03, 01, 00, 00, 00); endDate.add(Calendar.DAY_OF_MONTH, i); obj.setEndDate( DateUtil.parseStrToTimestamp( DateUtil.getDateTime(endDate, "yyyy-MM-dd HH:mm:ss"), "yyyy-MM-dd HH:mm:ss")); obj.setStatus((short) 30); int requestHotelID = 101 + i; obj.setRequestHotelID(requestHotelID); obj.setRequestDate( DateUtil.parseStrToTimestamp( DateUtil.getDateTime(fromDate, "yyyy-MM-dd HH:mm:ss"), "yyyy-MM-dd HH:mm:ss")); obj.setDataChange_CreateTime( DateUtil.parseStrToTimestamp( DateUtil.getNowDateTime("yyyy-MM-dd HH:mm:ss"), "yyyy-MM-dd HH:mm:ss")); obj.setDataChange_LastTime( DateUtil.parseStrToTimestamp( DateUtil.getNowDateTime("yyyy-MM-dd HH:mm:ss"), "yyyy-MM-dd HH:mm:ss")); updateReqList.add(obj); } logger.info("生成数据量:" + updateReqList.size()); long sTime = System.currentTimeMillis(); requestService.insertList(updateReqList); trans.commit(); long eTime = System.currentTimeMillis(); long totalTime = eTime - sTime; logger.info("生成的申请单数据写入数据库完成,耗时:" + (totalTime / 1000 + "." + totalTime % 1000 + "秒")); String fromDate = "2016-03-01"; String endDate = "2016-03-03"; List<Request> dbReqList = requestService.readFromDB_ByModifies(fromDate, endDate); logger.info( "获取从" + fromDate + "到" + endDate + "Request数据,数据量:" + ((dbReqList != null && dbReqList.size() > 0) ? dbReqList.size() : 0)); trans.close(); logger.info("生产申请单详细数据"); List<RequestItem> reqItemList = new ArrayList<RequestItem>(); if (dbReqList != null && dbReqList.size() > 0) { for (Request item : dbReqList) { RequestItem reqItem = new RequestItem(); reqItem.setRuleRequestID(item.getRuleRequestID()); reqItem.setBalanceType("PP"); reqItem.setValueData(0.4); reqItem.setDataChange_CreateTime( DateUtil.parseStrToTimestamp( DateUtil.getNowDateTime("yyyy-MM-dd HH:mm:ss"), "yyyy-MM-dd HH:mm:ss")); reqItem.setDataChange_LastTime( DateUtil.parseStrToTimestamp( DateUtil.getNowDateTime("yyyy-MM-dd HH:mm:ss"), "yyyy-MM-dd HH:mm:ss")); reqItemList.add(reqItem); } } logger.info("生产的申请单详细数据量:" + reqItemList.size()); sTime = System.currentTimeMillis(); requestItemService.insertList(reqItemList); trans2.commit(); trans2.close(); eTime = System.currentTimeMillis(); logger.info("生成的申请单详细数据写入数据库完成,耗时:" + (totalTime / 1000 + "." + totalTime % 1000 + "秒")); }