<div id="readability-page-1" class="page"><div data-language="java"><pre><code>
@Repository
@RequiredArgsConstructor
public class someJdbcRepository {

 private final JdbcTemplate jdbcTemplate;

 public int[] bulkInsert(List&lt;SomeEntity&gt; someEntities) {
 return this.jdbcTemplate.batchUpdate(
 "insert into some_table (some_value) values (?)",
 new BatchPreparedStatement() {
 @Override
 public void setValues(PreparedStatement ps, int i) throws SQLException {
 SomeEntity someEntity = someEntities.get(i);
 ps.setLong(1, someEntity.getSomeValue(i));
 }

 @Override
 public int getBatchSize() {
 return someEntities.size();
 });
 }
}</code></pre></div></div>

Seulog💘

이예슬

Jdbc를 통한 Bulk Insert
@Repository
@RequiredArgsConstructor
public class someJdbcRepository {
 private final JdbcTemplate jdbcTemplate;
 public int[] bulkInsert(List<SomeEntity> someEntities) {
 return this.jdbcTemplate.batchUpdate(
 "insert into some_table (some_value) values (?)",
 new BatchPreparedStatement() {
 @Override
 public void setValues(PreparedStatement ps, int i) throws SQLException {
 SomeEntity someEntity = someEntities.get(i);
 ps.setLong(1, someEntity.getSomeValue(i));
 }
 @Override
 public int getBatchSize() {
 return someEntities.size();
 });
 }
}

Jdbc를 통한 Bulk Insert

댓글