阅读背景:

addBatch()批量添加结果只添加了一条数据的原因

来源:互联网 
	public void deleteMember(String[] dataArr, String[] taskIdArr, String loginId, String acceptType) {
		Connection conn = null;
		PreparedStatement pstmt = null;
		List<String> taskIdList = new ArrayList<String>();
		List<Map<String,String>> receiveList = new ArrayList<Map<String,String>>();
		for(int i=0;i<taskIdArr.length;i++){
			taskIdList.add(taskIdArr[i]);
		}
		String sql = "delete from FXYD_MEMBER where recever_id_ =? ";
		try {
			conn = getConnection();
			conn.setAutoCommit(false); //设置自动提交为false
			pstmt = conn.prepareStatement(sql);
			for(int i=0;i<receiveList.size();i++){
				receiveList = taskReceiveDao.receiveId(taskIdList, acceptType);
				pstmt.setString(1,receiveList.get(i).get("id"));
				pstmt.addBatch(); //添加到缓存中
			}
			pstmt.executeBatch(); //执行缓存中的代码
			conn.commit(); //手动提交
		} catch (Exception e) {
			e.printStackTrace();
			IReportServer.handleException(e);
		}finally{
			release(null,pstmt,conn);
		}
	}
	
}	public void deleteMember(String[] dataArr, Str



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: