String[] checkboxes = request.getParameterValues("genre");
int sex = Integer.parseInt(request.getParameter("sex"));
int age = Integer.parseInt(request.getParameter("age"));

try(Connection con = ds.getConnection()){

    int voteID = 0;

    // insert vote
    String voteQuery = "INSERT INTO vote (sex, age, date) VALUES (?,?,NOW())";
    PreparedStatement voteStatement = con.prepareStatement(voteQuery);
    voteStatement.setInt(1, sex);
    voteStatement.setInt(2, age);
    voteStatement.executeUpdate();
    voteStatement.close();

    // get id of vote just submitted
    String getVoteIDString = "SELECT id FROM vote ORDER BY date DESC LIMIT 1";
    PreparedStatement getVoteID = con.prepareStatement(getVoteIDString);
    ResultSet rs = getVoteID.executeQuery();
    while(rs.next()){
        voteID = rs.getInt("id");
    }
    getVoteID.close();

    // insert selected game genres - linking to vote using id retrieved
    String genreQuery = "INSERT INTO voteGenre (voteID, genreID) VALUES (?,?)";
    for(String cb : checkboxes){

        PreparedStatement genreStatement = con.prepareStatement(genreQuery);
        genreStatement.setInt(1, voteID);
        genreStatement.setInt(2, Integer.parseInt(cb));
        genreStatement.executeUpdate();
        genreStatement.close();

    }
    out.print("yes");
}catch(SQLException e){

    out.print(e);
}