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

来源：互联网发布：五十岁而知天命编辑：程序博客网时间：2024/05/15 07:50

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();    }}

0 0