Shulou(Shulou.com)06/01 Report--

This article will explain in detail how JPA saves saveAll in batches. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

JPA's saveAll method is used to save more than a thousand pieces of data in batch, but it is found that log printing is an insert statement.

Looking at the source code of saveAll, it is found that a for loop is used and then the save method is executed one by one.

All right, write a batch execution method manually

@ Componentpublic class DbUtils {private static EntityManager entityManager; public static final int BATCH_SIZE = 1000; public static EntityManager getEntityManager () {if (entityManager = = null) {entityManager = SpringUtils.getBean (EntityManager.class);} return entityManager;} public static void setEntityManager (EntityManager entityManager) {/ / DbUtils.entityManager = entityManager } public static void batchExecute (String sql, List params, Integer batchSize) {if (batchSize = = null) {batchSize = BATCH_SIZE;} if (params.size () = = 0) {return;} Connection conn = null; Session session = null; PreparedStatement stmt = null; try {session = (Session) getEntityManager () .getDelegate () SessionFactoryImpl sf = (SessionFactoryImpl) session.getSessionFactory (); conn = sf.getJdbcServices (). GetBootstrapJdbcConnectionAccess (). ObtainConnection (); stmt = conn.prepareStatement (sql); conn.setAutoCommit (false); int index = 0; for (Object [] objects: params) {for (int item0; I)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.