# Using Batch Processing

__*rewriteBatchedStatements*__
__*Batch DML best practices*__

+ JDBC parameters: `rewriteBatchedStatements=true` 
```
ps = connection.prepareStatement("insert into t1 (name) values(?)")
pstmt.setString(1, "1");
pstmt.~!@addBatch()@!~;
pstmt.setString(1, "2");
pstmt.~!@addBatch()@!~;
pstmt.setString(1, "3");
pstmt.~!@executeBatch()@!~;
```

------------------------------------------------------------

Demo scripts:

macOS and Linux: https://github.com/pingcap/tidb-course-201-lab/blob/master/scripts/10-demo-jdbc-batch-insert-01-show.sh

Windows: https://github.com/pingcap/tidb-course-201-lab/blob/master/scripts/10-demo-jdbc-batch-insert-01-show.bat