www.compilejava.net

java_pmfJ9y.java

public class quizSceneController{

    private Flow flow;
    public void setMain(Flow flow){ this.flow = flow;}
    @FXML Button answerbutton;
    @FXML Text timeField, scoreField;
    @FXML public Label question, showQuestionCounter, answer, questionId, questionType, questionSpeed;
    NextQuestion nextQuestion;
    public String temp, temp2;
    public GridPane takingTestPane = new GridPane();

    public void chooseNextQuestion(Flow flow){

        try {
            this.flow.nextQ = false;
            this.flow.startTime = System.currentTimeMillis();
            //Choosing the next question
            String sql = "select * from Questions where Subject = ? and Level = ?  and questionId = ?";
            PreparedStatement pst = this.flow.connectionQuestions.prepareStatement(sql);
            pst.setString(1, this.flow.textSubjectQTest);
            pst.setString(2, this.flow.user_course_level);
            pst.setString(3, this.flow.list.get(counter));
            ResultSet rs = pst.executeQuery();
            if (rs.next()) {

                temp = rs.getString("Question");
                temp2 = rs.getString("Answer");

                pst.execute();
                pst.close();
            } else {
                System.out.println("No data for this subject");
            }

        } catch (Exception a) {
            System.out.println(a);
        }
    }

    @FXML private void myButton(ActionEvent event){

        chooseNextQuestion(this.flow);
        this.question.setText(temp);
    }
    @FXML public void initialize(){

        chooseNextQuestion(this.flow);
        this.question.setText(temp);
    }
}