jdbc addBatch 处理大数据

<span style="font-family: Arial, Helvetica, sans-serif;">/** </span>

	* @Description 分销订单，批量增加操作 
	* @return -1:操作失败;0:执行正常;>0:执行成功的数目
	*/ 
	@Override 
	public int batchAddUsingJdbc(String beginDate,String endDate) {
		int result = 0; 
		Connection conn = null; 
		PreparedStatement pstmt = null; 
		List<MerchantDistributeInfo> distrilist=merchantDistributeService.getAll();
		String sql=" INSERT into merchant_distribute_stage_account_info(account_no,merchant_distribute_id,total_order_amount,total_withdrawal_amount) "+
				" values (?,?,?,?)";
        //遍历分销商，保存到分期账单表中		
		try{	
			conn = SessionFactoryUtils.getDataSource(sessionFactory).getConnection(); 
			conn.setAutoCommit(false); 
			pstmt = conn.prepareStatement(sql); 
		   for(MerchantDistributeInfo distr : distrilist){
				//根据分期时间/订单状态/分销商，查询订单
				Map<String,Object> distributeParamMap= merchantDistributeService.getDistrubuteByDateStatus(distr, beginDate, endDate);
				pstmt.setString(1,distributeParamMap.get("dateNo").toString()); 
				pstmt.setInt(2, distr.getId()); 
				pstmt.setBigDecimal(3, new BigDecimal(distributeParamMap.get("total").toString()));
				pstmt.setBigDecimal(4,new BigDecimal(distributeParamMap.get("littleTotal").toString()));
				pstmt.addBatch();
			} 
			pstmt.executeBatch(); 
			conn.commit(); 
			conn.setAutoCommit(true); 
		} catch (SQLException e) { 
			if (conn != null) { 
				try { 
				conn.rollback(); 
				} catch (SQLException e1) { 
				e1.printStackTrace(); 
				} 
			} 
		} finally { 
			if (pstmt != null) { 
				try { 
				pstmt.close(); 
				} catch (SQLException e) { 
				e.printStackTrace(); 
				} 
			} 
			if (conn != null) { 
				try { 
				conn.close(); 
				} catch (SQLException e) { 
				e.printStackTrace(); 
				} 
			} 
		} 
		return result; 
	}