예제 #1
0
  private static CurVO executeBatchNoBindSQL(String sql, List voList, Connection connect)
      throws Exception {
    CurVO resultVO;
    if (voList == null || voList.size() == 0) {
      resultVO = new CurVO();
      resultVO.setBatchBesult(new int[0]);
    }
    Statement stm = null;

    try {
      stm = connect.createStatement();
      for (int i = 0; i < voList.size(); i++) {
        // P.print(DBAssistantTools.GetJointSQL(sql, voList.get(i),
        // null, false));
        /** ---------------------打印------------------------- */
        P.printSQL(sql, voList.get(i));
        /** ---------------------打印------------------------- */
        // 添加SQL字符串
        stm.addBatch(SqlTool.GetJointSQL(sql, voList.get(i), null, false));
      }
      // 该数组可查看每次SQL处理的整形结果
      resultVO = new CurVO();
      resultVO.setBatchBesult(stm.executeBatch());
      resultVO.setResult(stm.getUpdateCount());
      return resultVO;
    } catch (Exception e) {
      throw e;
    } finally {
      DBTool.close(null, stm, null);
    }
  }
예제 #2
0
 /**
  * 批量处理SQL
  *
  * @param sql
  * @param voList
  * @return
  * @throws Exception
  */
 protected CurVO executeBatchSQL(String sql, List voList) throws Exception {
   if (voList.size() == 0) return new CurVO();
   CurVO vo;
   if (!this.bind) vo = executeBatchNoBindSQL(sql, voList, this.connect);
   else vo = executeBatchBindSQL(sql, voList, this.connect);
   vo.setResult(vo.getBatchBesult().length);
   return vo;
 }
예제 #3
0
  private static CurVO executeBatchBindSQL(String sql, List<Object> voList, Connection connect)
      throws Exception {
    if (voList == null || voList.size() == 0) return new CurVO();
    PreparedStatement ps = null;
    CurVO resultVO;
    try {
      // 哪些变量需要绑定
      List<String> fieldNameList = SqlTool.GetSQLBindFieldNameList(sql, voList.get(0).getClass());
      // 获得批量处理的绑定变量SQL
      ps = connect.prepareStatement(SqlTool.GetBindSQL(sql));

      // 绑定变量
      for (Object vo : voList) {
        // 当前SQL要绑定的所有参数
        List<Object> valueList = SqlTool.GetSQLFieldValueList(vo, fieldNameList);
        // 绑定
        for (int i = 0; i < valueList.size(); i++)
          DBTool.BindJavaValueByJavaType(ps, valueList.get(i), i + 1, connect);

        /** ---------------------打印------------------------- */
        P.printBindSQL(sql, vo);
        /** ---------------------打印------------------------- */
        // 添加到批量处理
        ps.addBatch();
      }

      ps.executeBatch();
      resultVO = new CurVO();
      // 绑定变量只能获得总更新记录,无法这么处理.setBatchBesult(ps.executeBatch());
      resultVO.setResult(ps.getUpdateCount());
      return resultVO;
    } catch (Exception e) {
      throw e;
    } finally {
      DBTool.close(null, ps, null);
    }
  }