Java를 사용하여 온라인 시험 시스템의 일괄 가져오기 기능을 개발하는 방법

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

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class StudentImportUtil {
    public static void importStudents(String filePath) {
        try {
            FileInputStream file = new FileInputStream(new File(filePath));
            Workbook workbook = new XSSFWorkbook(file);

            Sheet sheet = workbook.getSheetAt(0);
            Iterator<Row> rowIterator = sheet.iterator();

            List<Student> students = new ArrayList<>();

            while (rowIterator.hasNext()) {
                Row row = rowIterator.next();
                Iterator<Cell> cellIterator = row.cellIterator();

                String studentId = "";
                String name = "";
                int grade = 0;

                while (cellIterator.hasNext()) {
                    Cell cell = cellIterator.next();
                    int columnIndex = cell.getColumnIndex();

                    switch (columnIndex) {
                        case 0:
                            studentId = cell.getStringCellValue();
                            break;
                        case 1:
                            name = cell.getStringCellValue();
                            break;
                        case 2:
                            grade = (int) cell.getNumericCellValue();
                            break;
                    }
                }

                Student student = new Student(studentId, name, grade);
                students.add(student);
            }

            // 将学生信息保存到数据库中
            saveStudents(students);

            file.close();
            workbook.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    private static void saveStudents(List<Student> students) {
        // 保存学生信息到数据库的逻辑
    }

    public static void main(String[] args) {
        String filePath = "students.xlsx";
        importStudents(filePath);
    }
}

import com.opencsv.CSVReader;

import java.io.FileReader;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

public class QuestionImportUtil {
    public static void importQuestions(String filePath) {
        try {
            CSVReader reader = new CSVReader(new FileReader(filePath));

            List<Question> questions = new ArrayList<>();

            String[] line;
            while ((line = reader.readNext()) != null) {
                String question = line[0];
                String[] options = new String[line.length - 1];
                for (int i = 0; i < options.length; i++) {
                    options[i] = line[i + 1];
                }
                String answer = line[line.length - 1];

                Question q = new Question(question, options, answer);
                questions.add(q);
            }

            // 将试题信息保存到数据库中
            saveQuestions(questions);

            reader.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    private static void saveQuestions(List<Question> questions) {
        // 保存试题信息到数据库的逻辑
    }

    public static void main(String[] args) {
        String filePath = "questions.csv";
        importQuestions(filePath);
    }
}