批量插入 jdbc及hibernate方法

最新推荐文章于 2025-09-24 17:29:28 发布

原创最新推荐文章于 2025-09-24 17:29:28 发布 · 714 阅读

0 ·

CC 4.0 BY-SA版权

Java 专栏收录该内容

26 篇文章

订阅专栏

本文介绍了两种批量数据处理的方法：一种是通过SQL批处理插入记录，另一种是利用Hibernate框架进行对象批量保存。前者展示了如何使用PreparedStatement批量执行SQL插入语句，后者则演示了通过Hibernate Session的save方法结合flush和clear操作实现高效批量保存。

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;  
            }  
        });  
}