批量写入mysql数据库表

import MySQLdb

# 连接数据库
conn = MySQLdb.connect(host='localhost', user='username', password='password', db='database_name')

# 创建游标
cursor = conn.cursor()

# 构造批量插入的数据
data = [(1, 'John'), (2, 'Jane'), (3, 'Tom')]

# 执行批量写入
cursor.executemany("INSERT INTO table_name (id, name) VALUES (%s, %s)", data)

# 提交事务
conn.commit()

# 关闭游标和连接
cursor.close()
conn.close()

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

public class BatchInsertExample {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement pstmt = null;

        String url = "jdbc:mysql://localhost:3306/database_name";
        String user = "username";
        String password = "password";

        try {
            // 连接数据库
            conn = DriverManager.getConnection(url, user, password);

            // 开启批量插入模式
            conn.setAutoCommit(false);

            // 构造批量插入的数据
            String sql = "INSERT INTO table_name (id, name) VALUES (?, ?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, 1);
            pstmt.setString(2, "John");
            pstmt.addBatch();

            pstmt.setInt(1, 2);
            pstmt.setString(2, "Jane");
            pstmt.addBatch();

            pstmt.setInt(1, 3);
            pstmt.setString(2, "Tom");
            pstmt.addBatch();

            // 执行批量写入
            pstmt.executeBatch();

            // 提交事务
            conn.commit();

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (pstmt != null)
                    pstmt.close();
                if (conn != null)
                    conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}