mysql 报表ireport

import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;
import java.util.*;

public class ReportGenerator {
    public static void main(String[] args) {
        try {
            // 加载报表模板
            InputStream reportStream = ReportGenerator.class.getResourceAsStream("/reports/sample.jasper");
            JasperReport jasperReport = (JasperReport) JRLoader.loadObject(reportStream);

            // 准备数据源
            List<Map<String, ?>> data = new ArrayList<>();
            // 假设这里是从 MySQL 数据库中查询到的数据
            data.add(Collections.singletonMap("name", "Alice"));
            data.add(Collections.singletonMap("name", "Bob"));

            JRBeanCollectionDataSource dataSource = new JRBeanCollectionDataSource(data);

            // 填充报表
            JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, new HashMap<>(), dataSource);

            // 导出报表
            JasperExportManager.exportReportToPdfFile(jasperPrint, "sample_report.pdf");

            System.out.println("报表生成成功！");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}