オンライン試験システムで解答一括インポートを実現するJavaプログラミング

create table question (
    id int primary key,
    content varchar(200) not null
);

create table answer (
    id int primary key,
    question_id int,
    content varchar(200) not null,
    foreign key (question_id) references question(id)
);

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public void importAnswers(List<Answer> answers) {
    String url = "jdbc:mysql://localhost:3306/exam";
    String username = "root";
    String password = "123456";
    
    try (Connection connection = DriverManager.getConnection(url, username, password)) {
        String sql = "insert into answer (id, question_id, content) values (?, ?, ?)";
        PreparedStatement statement = connection.prepareStatement(sql);
        
        for (Answer answer : answers) {
            statement.setInt(1, answer.getId());
            statement.setInt(2, answer.getQuestionId());
            statement.setString(3, answer.getContent());
            statement.addBatch();
        }
        
        statement.executeBatch();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

public class Main {
    public static void main(String[] args) {
        List<Answer> answers = new ArrayList<>();
         answers.add(new Answer(1, 1, "A"));
         answers.add(new Answer(2, 2, "B"));
         answers.add(new Answer(3, 3, "C"));
        
         importAnswers(answers);
    }
}