Java：byte[]数组到Excel到BLOB

Java：byte[]数组到Excel到BLOB

java
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExcelUtils {
    public static byte[] createExcel() throws Exception {
        // 创建一个新的Excel文档
        Workbook workbook = new XSSFWorkbook();
        
        // 创建工作表
        Sheet sheet = workbook.createSheet("Sheet1");
        
        // 创建行和单元格
        Row row = sheet.createRow(0);
        Cell cell = row.createCell(0);
        
        // 写入数据
        cell.setCellValue("Hello, Excel!");
        
        // 将Excel文档保存为byte[]数组
        ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
        workbook.write(outputStream);
        byte[] excelBytes = outputStream.toByteArray();
        
        // 关闭流
        outputStream.close();
        workbook.close();
        
        return excelBytes;
    }
}

java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class DatabaseUtils {
    public static void saveExcelToBlob(byte[] excelBytes) throws Exception {
        // 连接到数据库
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
        
        // 创建插入语句
        String sql = "INSERT INTO excel_table (excel_blob) VALUES (?)";
        PreparedStatement statement = connection.prepareStatement(sql);
        
        // 设置参数
        statement.setBytes(1, excelBytes);
        
        // 执行插入语句
        statement.executeUpdate();
        
        // 关闭连接和语句
        statement.close();
        connection.close();
    }
}