批量处理

1. try {   
2.             Connection conn = ConnectionManager.getConnection();   
3.             pstmt = conn.prepareStatement(sql);   
4.             for (Iterator iter=flowCardDetailList.iterator(); iter.hasNext();) {   
5.                 FlowCardDetail flowCardDetail = (FlowCardDetail)iter.next();   
6.                 pstmt.setString(1, vouNo);   
7.                 pstmt.setString(2, flowCardDetail.getAimClient().getId());   
8.                 pstmt.setString(3, flowCardDetail.getItem().getItemNo());   
9.                 pstmt.setDouble(4, flowCardDetail.getQty());   
10.                 pstmt.setString(5, flowCardDetail.getAdjusFlag());   
11. -----------------------------   pstmt.addBatch();   
12.             }   
13.             pstmt.executeBatch();   
14.         }