mysql数据库导出百万数据到excel_poi从数据库导出百万数据并写入excel

package com.example.demo.bigDataExcelOutWrite;

import java.io.FileOutputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.xssf.streaming.SXSSFWorkbook;

public class BigDataExcelOutWrite {

/**

* 数据库连接操作

*

* @throws Exception

*/

public Connection getConnection() throws Exception {

// 使用jdbc链接数据库

Class.forName("com.mysql.jdbc.Driver").newInstance();

String url = "jdbc:mysql://localhost:3306/data?serverTimezone=UTC&useUnicode=true&characterEnc