spring hibernate 批量插入jdbc及hibernate方法_spring hibernate批量插入-优快云博客

本文介绍使用Hibernate进行批量数据插入的方法，通过示例展示了如何利用PreparedStatement和executeBatch进行高效批量操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

项目中需要用到批量添加，考虑到新能问题用jdbc实现.
记录下来,以后会用.

[javascript]view plaincopy 
   
 public void createRolePermissionBySql(final String roleId,final String[] permIds){  
           
         getHibernateTemplate().execute(new HibernateCallback() {  
             public Object doInHibernate(Session session)  
                     throws HibernateException, SQLException {  
                 if(permIds==null||permIds.length==0)  
                           return null;  
                 Connection conn=session.connection();  
                 PreparedStatement ps=null;  
                 String sql=" insert into base_role_permission (ROLE_PERM_ID,PERM_ID,ROLE_ID,CREATE_DATE)" +  
                            " values (?,?,?,?) ";  
                 ps=conn.prepareStatement(sql);  
                 if(log.isDebugEnabled())  
                        log.debug("batch add base_role_permission:"+sql);  
                 UUIDHexGenerator uuidGenerator=null;  
                 for(String permId:permIds){  
                     uuidGenerator=new UUIDHexGenerator();  
                     ps.setString(1,uuidGenerator.generate(null, null).toString());  
                     ps.setString(2,permId);  
                     ps.setString(3, roleId);  
                     ps.setDate(4, DateUtils.getJavaSqlDate());  
                     ps.addBatch();  
                 }  
                 int[] counts=ps.executeBatch();  
                 ps.close();  
                 session.flush();  
                 session.close();  
                 return null;  
             }  
         });  
     }  
      

hibernate批量插入

[java]view plaincopy 
   
 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;  
             }  
         });  
 }  