package fangsoft.testcenter.model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import fangsoft.testcenter.model.Test;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;

public class PracticeTest extends Test implements java.io.Serializable {

	/**
	 * 
	 */

	public PracticeTest() {
		// TODO 自動生成構造函數存根
		super();
		System.out.println("java 知識測試開始！");
	}

	public PracticeTest(String aText) throws SQLException {
		super(aText);
		// TODO Auto-generated constructor stub
	}

	/**
	 * @param args
	 */
	public boolean generate(Connection con) throws SQLException {
		PreparedStatement ps = null;
		ResultSet result;
		String sqlString = "select *"
				+ "from question_choice where test_name='java 知識測試'";
		setTest_name("java 知識測試");
		ps = con.prepareStatement(sqlString);
		result = ps.executeQuery(sqlString);
		String QuestionText = null;
		String ChoiceText = null;
		String Answer;
		while (result.next()) {
			QuestionText = result.getString("question");
			Question question = new Question();
			question.setText(QuestionText);
			Choice choicea = new Choice();
			ChoiceText = result.getString("choiceA");
			choicea.setText(ChoiceText);
			question.addChoice(choicea);
			Choice choiceb = new Choice();
			ChoiceText = result.getString("choiceB");
			choiceb.setText(ChoiceText);
			question.addChoice(choiceb);
			Choice choicec = new Choice();
			ChoiceText = result.getString("choiceC");
			choicec.setText(ChoiceText);
			question.addChoice(choicec);
			Choice choiced = new Choice();
			ChoiceText = result.getString("choiceD");
			choiced.setText(ChoiceText);
			question.addChoice(choiced);
			Answer = result.getString("answer");
			question.setAnswer(Answer);
			addQuestion(question);
		}

		return true;
	}

}