[Java] JDBC 05 TestBatch.java 批处理 Batch

最新推荐文章于 2022-11-19 08:58:18 发布

小尼人00

最新推荐文章于 2022-11-19 08:58:18 发布

阅读量1.1k

点赞数

分类专栏： Java / Spring / Guava

本文链接：https://blog.csdn.net/robbyo/article/details/17453327

版权

Java / Spring / Guava 专栏收录该内容

274 篇文章 0 订阅

订阅专栏

import java.sql.*;
public class TestBatch {

    public static void main(String[] args) throws Exception {
        
        Class.forName("com.mysql.jdbc.Driver");

        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata?user=root&password=root");
        /*
        Statement stmt = conn.createStatement();
        stmt.addBatch("insert into dept2 values (51, '500', 'haha')");
        stmt.addBatch("insert into dept2 values (52, '500', 'haha')");
        stmt.addBatch("insert into dept2 values (53, '500', 'haha')");
        stmt.executeBatch();
        stmt.close();
        */
        
        PreparedStatement ps = conn.prepareStatement("insert into dept2 values (?, ?, ?)");
        ps.setInt(1, 61);
        ps.setString(2, "haha");
        ps.setString(3, "bj");
        ps.addBatch();
        
        ps.setInt(1, 62);
        ps.setString(2, "haha");
        ps.setString(3, "bj");
        ps.addBatch();
        
        ps.setInt(1, 63);
        ps.setString(2, "haha");
        ps.setString(3, "bj");
        ps.addBatch();
        
        ps.executeBatch();
        ps.close();
        
        conn.close();

    }

}