该博客展示了如何使用Java的JDBC批处理功能来高效地插入多条数据到MySQL数据库中。通过`PreparedStatement`创建预编译的SQL语句，并使用`addBatch()`方法添加多组参数，最后调用`executeBatch()`执行批量操作。这种方式提高了数据库操作的效率，减少了与数据库的交互次数。
import java.sql.*;
public class TestBatch {
public static void main(String[] args) throws ClassNotFoundException, SQLException
{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection
("jdbc:mysql://localhost/test","root","ZHEN");
/*
Statement stmt = conn.createStatement(); //执行静态 SQL 语句并返回它所生成结果的对象。
stmt.addBatch("INSERT INTO student VALUES(30,'ddd',12,'ii')");
stmt.addBatch("INSERT INTO student VALUES(31,'ddd',12,'ii')");
stmt.addBatch("INSERT INTO student VALUES(32,'ddd',12,'ii')");
stmt.addBatch("INSERT INTO student VALUES(33,'ddd',12,'ii')");
stmt.executeBatch();
stmt.close();
*/
PreparedStatement pstmt =
conn.prepareStatement("INSERT INTO student VALUES(?,?,?,?)");
pstmt.setInt(1, 40);
pstmt.setString(2,"qq");
pstmt.setInt(3,5);
pstmt.setString(4,"ww");
pstmt.addBatch();
pstmt.setInt(1, 41);
pstmt.setString(2,"qq");
pstmt.setInt(3,5);
pstmt.setString(4,"ww");
pstmt.addBatch();
pstmt.setInt(1, 42);
pstmt.setString(2,"qq");
pstmt.setInt(3,5);
pstmt.setString(4,"ww");
pstmt.addBatch();
pstmt.executeBatch();
pstmt.close();
conn.close();
}
}
扫一扫
678
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
