直接上码:
1、批量添加数据
public class Demo05 {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
//加载驱动类
Class.forName("com.mysql.cj.jdbc.Driver");
//建立数据库连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testjdbc?&useSSL=false&serverTimezone=UTC","root","123456");
conn.setAutoCommit(false);//设为手动提交
long start = System.currentTimeMillis();
stmt = conn.createStatement();
//批量添加
for (int i = 0; i < 20000; i++) {
stmt.addBatch