java 批量新增100条数据库数据

在Java中，批量插入100条数据库数据通常通过JDBC（Java Database Connectivity）或者ORM框架如Hibernate或MyBatis来进行。这里我会给出一种基本的示例，假设我们正在使用JDBC连接MySQL：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class BatchInsertExample {
    private static final String DB_URL = "jdbc:mysql://localhost:3306/your_database";
    private static final String USER = "your_username";
    private static final String PASS = "your_password";

    public static void main(String[] args) {
        String sql = "INSERT INTO your_table (column1, column2, ...) VALUES (?, ?, ...)";
        
        try {
            // 首先，加载数据库驱动
            Class.forName("com.mysql.cj.jdbc.Driver");
            
            // 获取连接
            Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
            
            // 准备批处理的PreparedStatement
            PreparedStatement pstmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            pstmt.setBatchSize(10); // 设置每批次插入的数量

            for (int i = 1; i <= 100; i++) { // 假设每个数据是一个元组
                pstmt.setString(1, "value1_" + i);
                pstmt.setString(2, "value2_" + i);
                // ...设置其他字段值
                pstmt.addBatch(); // 添加到批处理
            }

            // 执行批处理
            int[] result = pstmt.executeBatch();

            // 检查并获取生成的主键
            if (result != null) {
                for (int index : result) {
                    if (index == Statement.EXECUTE_FAILED) {
                        System.out.println("Failed to insert row " + (pstmt.getUpdateCount() + 1));
                    }
                }
            }

            // 关闭连接
            pstmt.close();
            conn.close();

            System.out.println("Batch insertion completed successfully.");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}