/**
  * 采用批方式插入多条数据
  *
  * @param collection collection
  * @throws Exception
  */
 public void insertAll(Collection collection) throws Exception {
   StringBuffer buffer = new StringBuffer(200);
   buffer.append("INSERT INTO LwWholeSalePrice (");
   buffer.append("PowerClass,");
   buffer.append("SaleArea,");
   buffer.append("VoltageBegin,");
   buffer.append("VoltageEnd,");
   buffer.append("Price,");
   buffer.append("ValidStatus,");
   buffer.append("Flag,");
   buffer.append("Remark ");
   buffer.append(") ");
   buffer.append("VALUES(?,?,?,?,?,?,?,?)");
   if (logger.isDebugEnabled()) {
     logger.debug(buffer.toString());
   }
   dbManager.prepareStatement(buffer.toString());
   for (Iterator i = collection.iterator(); i.hasNext(); ) {
     LwWholeSalePriceDto lwWholeSalePriceDto = (LwWholeSalePriceDto) i.next();
     dbManager.setString(1, lwWholeSalePriceDto.getPowerClass());
     dbManager.setString(2, lwWholeSalePriceDto.getSaleArea());
     dbManager.setDouble(3, lwWholeSalePriceDto.getVoltageBegin());
     dbManager.setDouble(4, lwWholeSalePriceDto.getVoltageEnd());
     dbManager.setDouble(5, lwWholeSalePriceDto.getPrice());
     dbManager.setString(6, lwWholeSalePriceDto.getValidStatus());
     dbManager.setString(7, lwWholeSalePriceDto.getFlag());
     dbManager.setString(8, lwWholeSalePriceDto.getRemark());
     dbManager.addBatch();
   }
   dbManager.executePreparedUpdateBatch();
 }
Example #2
0
 /**
  * 采用批方式插入多条数据
  *
  * @param collection collection
  * @throws Exception
  */
 public void insertAll(Collection collection) throws Exception {
   StringBuffer buffer = new StringBuffer(200);
   buffer.append("INSERT INTO LineLoss (");
   buffer.append("LineCode,");
   buffer.append("R,");
   buffer.append("LineLong,");
   buffer.append("Volt,");
   buffer.append("T,");
   buffer.append("ValidStatus,");
   buffer.append("Flag,");
   buffer.append("Remark ");
   buffer.append(") ");
   buffer.append("VALUES(?,?,?,?,?,?,?,?)");
   if (logger.isDebugEnabled()) {
     logger.debug(buffer.toString());
   }
   dbManager.prepareStatement(buffer.toString());
   for (Iterator i = collection.iterator(); i.hasNext(); ) {
     LineLossDto lineLossDto = (LineLossDto) i.next();
     dbManager.setString(1, lineLossDto.getLineCode());
     dbManager.setDouble(2, lineLossDto.getR());
     dbManager.setDouble(3, lineLossDto.getLineLong());
     dbManager.setDouble(4, lineLossDto.getVolt());
     dbManager.setDouble(5, lineLossDto.getT());
     dbManager.setString(6, lineLossDto.getValidStatus());
     dbManager.setString(7, lineLossDto.getFlag());
     dbManager.setString(8, lineLossDto.getRemark());
     dbManager.addBatch();
   }
   dbManager.executePreparedUpdateBatch();
 }
 /**
  * 采用批方式插入多条数据
  *
  * @param collection collection
  * @throws Exception
  */
 public void insertAll(Collection collection) throws Exception {
   StringBuffer buffer = new StringBuffer(200);
   buffer.append("INSERT INTO LwWholeSaleSummary (");
   buffer.append("LineCode,");
   buffer.append("StatMonth,");
   buffer.append("PowerClass,");
   buffer.append("ElectricQuantity,");
   buffer.append("PointerQuantity,");
   buffer.append("SanXiaFee,");
   buffer.append("Surcharge,");
   buffer.append("SumFee,");
   buffer.append("ValidStatus,");
   buffer.append("Flag,");
   buffer.append("Remark,");
   buffer.append("TransLoss,");
   buffer.append("LineLoss,");
   buffer.append("UnPointerQuantity,");
   buffer.append("RateCode,");
   buffer.append("AdjustRate,");
   buffer.append("FarmUseScale,");
   buffer.append("FarmUsePrice,");
   buffer.append("FarmUseQuantity,");
   buffer.append("FarmUseFee,");
   buffer.append("ProductScale,");
   buffer.append("ProductPrice,");
   buffer.append("ProductQuantity,");
   buffer.append("ProductFee,");
   buffer.append("DenizenScale,");
   buffer.append("DenizenPrice,");
   buffer.append("DenizenQuantity,");
   buffer.append("DenizenFee,");
   buffer.append("UnDenizenScale,");
   buffer.append("UnDenizenPrice,");
   buffer.append("UnDenizenQuantity,");
   buffer.append("UnDenizenFee,");
   buffer.append("IndustryScale,");
   buffer.append("IndustryPrice,");
   buffer.append("IndustryQuantity,");
   buffer.append("IndustryFee,");
   buffer.append("BizScale,");
   buffer.append("BizPrice,");
   buffer.append("BizQuantity,");
   buffer.append("BizFee,");
   buffer.append("PowerRateFee,");
   buffer.append("UpCompany,");
   buffer.append("PowerFee,");
   buffer.append("InputDate,");
   buffer.append("Kv,");
   buffer.append("Wholesaletype,");
   buffer.append("WorkNum,");
   buffer.append("UnWorkNum,");
   buffer.append("OtherSurcharge,");
   buffer.append("DifferenceQuantity,");
   buffer.append("UnTransLoss,");
   buffer.append("UnLineLoss ");
   buffer.append(") ");
   buffer.append(
       "VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
   if (logger.isDebugEnabled()) {
     logger.debug(buffer.toString());
   }
   dbManager.prepareStatement(buffer.toString());
   for (Iterator i = collection.iterator(); i.hasNext(); ) {
     LwWholeSaleSummaryDto lwWholeSaleSummaryDto = (LwWholeSaleSummaryDto) i.next();
     dbManager.setString(1, lwWholeSaleSummaryDto.getLineCode());
     dbManager.setString(2, lwWholeSaleSummaryDto.getStatMonth());
     dbManager.setString(3, lwWholeSaleSummaryDto.getPowerClass());
     dbManager.setDouble(4, lwWholeSaleSummaryDto.getElectricQuantity());
     dbManager.setDouble(5, lwWholeSaleSummaryDto.getPointerQuantity());
     dbManager.setDouble(6, lwWholeSaleSummaryDto.getSanXiaFee());
     dbManager.setDouble(7, lwWholeSaleSummaryDto.getSurcharge());
     dbManager.setDouble(8, lwWholeSaleSummaryDto.getSumFee());
     dbManager.setString(9, lwWholeSaleSummaryDto.getValidStatus());
     dbManager.setString(10, lwWholeSaleSummaryDto.getFlag());
     dbManager.setString(11, lwWholeSaleSummaryDto.getRemark());
     dbManager.setDouble(12, lwWholeSaleSummaryDto.getTransLoss());
     dbManager.setDouble(13, lwWholeSaleSummaryDto.getLineLoss());
     dbManager.setDouble(14, lwWholeSaleSummaryDto.getUnPointerQuantity());
     dbManager.setDouble(15, lwWholeSaleSummaryDto.getRateCode());
     dbManager.setDouble(16, lwWholeSaleSummaryDto.getAdjustRate());
     dbManager.setDouble(17, lwWholeSaleSummaryDto.getFarmUseScale());
     dbManager.setDouble(18, lwWholeSaleSummaryDto.getFarmUsePrice());
     dbManager.setDouble(19, lwWholeSaleSummaryDto.getFarmUseQuantity());
     dbManager.setDouble(20, lwWholeSaleSummaryDto.getFarmUseFee());
     dbManager.setDouble(21, lwWholeSaleSummaryDto.getProductScale());
     dbManager.setDouble(22, lwWholeSaleSummaryDto.getProductPrice());
     dbManager.setDouble(23, lwWholeSaleSummaryDto.getProductQuantity());
     dbManager.setDouble(24, lwWholeSaleSummaryDto.getProductFee());
     dbManager.setDouble(25, lwWholeSaleSummaryDto.getDenizenScale());
     dbManager.setDouble(26, lwWholeSaleSummaryDto.getDenizenPrice());
     dbManager.setDouble(27, lwWholeSaleSummaryDto.getDenizenQuantity());
     dbManager.setDouble(28, lwWholeSaleSummaryDto.getDenizenFee());
     dbManager.setDouble(29, lwWholeSaleSummaryDto.getUnDenizenScale());
     dbManager.setDouble(30, lwWholeSaleSummaryDto.getUnDenizenPrice());
     dbManager.setDouble(31, lwWholeSaleSummaryDto.getUnDenizenQuantity());
     dbManager.setDouble(32, lwWholeSaleSummaryDto.getUnDenizenFee());
     dbManager.setDouble(33, lwWholeSaleSummaryDto.getIndustryScale());
     dbManager.setDouble(34, lwWholeSaleSummaryDto.getIndustryPrice());
     dbManager.setDouble(35, lwWholeSaleSummaryDto.getIndustryQuantity());
     dbManager.setDouble(36, lwWholeSaleSummaryDto.getIndustryFee());
     dbManager.setDouble(37, lwWholeSaleSummaryDto.getBizScale());
     dbManager.setDouble(38, lwWholeSaleSummaryDto.getBizPrice());
     dbManager.setDouble(39, lwWholeSaleSummaryDto.getBizQuantity());
     dbManager.setDouble(40, lwWholeSaleSummaryDto.getBizFee());
     dbManager.setDouble(41, lwWholeSaleSummaryDto.getPowerRateFee());
     dbManager.setString(42, lwWholeSaleSummaryDto.getUpCompany());
     dbManager.setDouble(43, lwWholeSaleSummaryDto.getPowerFee());
     dbManager.setString(44, lwWholeSaleSummaryDto.getInputDate());
     dbManager.setString(45, lwWholeSaleSummaryDto.getKv());
     dbManager.setString(46, lwWholeSaleSummaryDto.getWholesaletype());
     dbManager.setDouble(47, lwWholeSaleSummaryDto.getWorkNum());
     dbManager.setDouble(48, lwWholeSaleSummaryDto.getUnWorkNum());
     dbManager.setDouble(49, lwWholeSaleSummaryDto.getOtherSurcharge());
     dbManager.setString(50, lwWholeSaleSummaryDto.getDifferenceQuantity());
     dbManager.setDouble(51, lwWholeSaleSummaryDto.getUnTransLoss());
     dbManager.setDouble(52, lwWholeSaleSummaryDto.getUnLineLoss());
     dbManager.addBatch();
   }
   dbManager.executePreparedUpdateBatch();
 }
 /**
  * 采用批方式插入多条数据
  *
  * @param collection collection
  * @throws Exception
  */
 public void insertAll(Collection collection) throws Exception {
   StringBuffer buffer = new StringBuffer(200);
   buffer.append("INSERT INTO LwTownIndicator (");
   buffer.append("UserNo,");
   buffer.append("UserName,");
   buffer.append("Address,");
   buffer.append("ReadDate,");
   buffer.append("StatMonth,");
   buffer.append("ThisWorkNum,");
   buffer.append("MidWorkNum,");
   buffer.append("LastWorkNum,");
   buffer.append("Rate,");
   buffer.append("ReadQuantity,");
   buffer.append("ExcepQuantity,");
   buffer.append("ChgAmmeterQuantity,");
   buffer.append("CompensateQuantity,");
   buffer.append("AppendCalQuantity,");
   buffer.append("TranferLossQuantity,");
   buffer.append("PeoplePrice,");
   buffer.append("NotPeoplePrice,");
   buffer.append("FarmPrice,");
   buffer.append("ProducePrice,");
   buffer.append("BusinessPrice,");
   buffer.append("Voltlevel,");
   buffer.append("IndustryPrice,");
   buffer.append("ValidStatus,");
   buffer.append("Flag,");
   buffer.append("Remark,");
   buffer.append("InputDate ");
   buffer.append(") ");
   buffer.append("VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
   if (logger.isDebugEnabled()) {
     logger.debug(buffer.toString());
   }
   dbManager.prepareStatement(buffer.toString());
   for (Iterator i = collection.iterator(); i.hasNext(); ) {
     LwTownIndicatorDto lwTownIndicatorDto = (LwTownIndicatorDto) i.next();
     dbManager.setString(1, lwTownIndicatorDto.getUserNo());
     dbManager.setString(2, lwTownIndicatorDto.getUserName());
     dbManager.setString(3, lwTownIndicatorDto.getAddress());
     dbManager.setString(4, lwTownIndicatorDto.getReadDate());
     dbManager.setString(5, lwTownIndicatorDto.getStatMonth());
     dbManager.setDouble(6, lwTownIndicatorDto.getThisWorkNum());
     dbManager.setDouble(7, lwTownIndicatorDto.getMidWorkNum());
     dbManager.setDouble(8, lwTownIndicatorDto.getLastWorkNum());
     dbManager.setDouble(9, lwTownIndicatorDto.getRate());
     dbManager.setDouble(10, lwTownIndicatorDto.getReadQuantity());
     dbManager.setDouble(11, lwTownIndicatorDto.getExcepQuantity());
     dbManager.setDouble(12, lwTownIndicatorDto.getChgAmmeterQuantity());
     dbManager.setDouble(13, lwTownIndicatorDto.getCompensateQuantity());
     dbManager.setLong(14, lwTownIndicatorDto.getAppendCalQuantity());
     dbManager.setLong(15, lwTownIndicatorDto.getTranferLossQuantity());
     dbManager.setDouble(16, lwTownIndicatorDto.getPeoplePrice());
     dbManager.setDouble(17, lwTownIndicatorDto.getNotPeoplePrice());
     dbManager.setDouble(18, lwTownIndicatorDto.getFarmPrice());
     dbManager.setDouble(19, lwTownIndicatorDto.getProducePrice());
     dbManager.setDouble(20, lwTownIndicatorDto.getBusinessPrice());
     dbManager.setInt(21, lwTownIndicatorDto.getVoltlevel());
     dbManager.setDouble(22, lwTownIndicatorDto.getIndustryPrice());
     dbManager.setString(23, lwTownIndicatorDto.getValidStatus());
     dbManager.setString(24, lwTownIndicatorDto.getFlag());
     dbManager.setString(25, lwTownIndicatorDto.getRemark());
     dbManager.setString(26, lwTownIndicatorDto.getInputDate());
     dbManager.addBatch();
   }
   dbManager.executePreparedUpdateBatch();
 }