# 使用批处理

__*rewriteBatchedStatements*__
__*批量 DML 最佳实践*__

+ JDBC 参数: `rewriteBatchedStatements=true`

```12
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();
```
--------------------------------------------------------------------

```
Class 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
```