批量插入 jdbc及hibernate方法

public void insertUndoRecordsIntoReport(final List<Object[]> recordsNeeded, final int monitoring_report_id) {
		final String sql =" insert into record (case_id, pass, level_id, info, project_id, module_id, monitoring_id, alternative, monitoring_report_id) " +
						  " values ( ?, ?, ?, ?, ?, ?, ?, ?, ?) ";

		this.getHibernateTemplate().execute(
		new HibernateCallback() {
		
			public Object doInHibernate(Session session) throws HibernateException,
			SQLException {
		
				java.sql.Connection con = session.connection();
				java.sql.PreparedStatement stmt = con.prepareStatement(sql);
				for (Object[] recordNeeded:recordsNeeded) {
					
					stmt.setString(1,recordNeeded[1].toString()); 
				    stmt.setLong(2, 0);
				    stmt.setLong(3, 4);
				    stmt.setString(4, "用例未执行");
				    stmt.setString(5, recordNeeded[4].toString());
				    stmt.setString(6, recordNeeded[3].toString());
				    stmt.setString(7, recordNeeded[2].toString());
				    stmt.setString(8, recordNeeded[0].toString());
				    stmt.setLong(9, monitoring_report_id);
				    stmt.addBatch();//将插入的任务添加到批处理中
				}
				stmt.executeBatch();//执行批量任务 
				stmt.close();
				session.flush();    
				session.close();
				
				return null; 
				
			}
		}
		);
	}

public void batchSaveCardDetail(List<TCardInfo> cardDetails) {  
        return this.getHibernateTemplate().execute(new HibernateCallback() {  
            @Override  
            public Object doInHibernate(Session session) throws HibernateException, SQLException {                  
        for (int i = 0; i < cardDetails.size(); i++) {  
                    session.save(cardDetails.get(i));         
                    if (i % 50 == 0) {  
                        session.flush();  
                        session.clear();  
                    }  
                }                  
                return null;  
            }  
        });  
}