使用Java编写在线考试系统的考试成绩导出模块

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileOutputStream;
import java.io.IOException;
import java.util.List;

public class ExamScoreExport {
    
    public void export(List<Student> students, String filePath) {
        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet("考试成绩");

        // 创建表头
        Row headerRow = sheet.createRow(0);
        headerRow.createCell(0).setCellValue("姓名");
        headerRow.createCell(1).setCellValue("学号");
        headerRow.createCell(2).setCellValue("成绩");

        // 填充数据
        int rowNum = 1;
        for (Student student : students) {
            Row row = sheet.createRow(rowNum++);
            row.createCell(0).setCellValue(student.getName());
            row.createCell(1).setCellValue(student.getId());
            row.createCell(2).setCellValue(student.getScore());
        }

        // 保存Excel文件
        try (FileOutputStream outputStream = new FileOutputStream(filePath)) {
            workbook.write(outputStream);
            System.out.println("考试成绩导出成功！");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    // 示例学生类
    private static class Student {
        private String name;
        private String id;
        private int score;

        public Student(String name, String id, int score) {
            this.name = name;
            this.id = id;
            this.score = score;
        }

        public String getName() {
            return name;
        }

        public String getId() {
            return id;
        }

        public int getScore() {
            return score;
        }
    }

    // 示例使用
    public static void main(String[] args) {
        List<Student> students = List.of(
                new Student("张三", "1001", 80),
                new Student("李四", "1002", 90),
                new Student("王五", "1003", 85)
        );

        String filePath = "exam_scores.xlsx";

        ExamScoreExport exporter = new ExamScoreExport();
        exporter.export(students, filePath);
    }
}